The same models used to underwrite a real deal or run a real P&L — every formula verified end to end, then left fully unlocked so you can open it, read it, and change it.
Each one is a working model — not a pretty spreadsheet dressed up to look capable.
Score your resort, club or hotel against budget and last year — year-to-date revenue, gross operating profit (GOP), net operating income, occupancy, average daily rate (ADR), revenue per available room (RevPAR) and membership, with a full-year outlook. Formulas fully visible, no passwords, with a blank template and a filled-in example.
See your cash 13 weeks out — weekly receipts, disbursements and closing cash from your open invoices, bills and recurring payments, with three scenarios, a cash-cushion alert and forecast-versus-actual tracking. Formulas fully visible, no passwords, with a blank template and a filled-in example.
Run the books on your rentals — rent roll, rent ledger, expense log, deposits, monthly profit and loss (P&L), and an IRS Schedule E summary for up to ten properties. Formulas fully visible, no passwords, with a blank template and a filled-in example.
Split any deal between limited partners (LPs) and the general partner (GP) — preferred return, GP catch-up, two internal rate of return (IRR) hurdles with promote tiers, and an investor-by-investor distribution schedule.
Underwrite any Airbnb or STR — occupancy, ADR, NOI, cap rate on price and all-in cost, plus a full-year performance tracker.
Run your short-term rentals like a business — occupancy, ADR, RevPAR, owner statements, co-host splits, lodging tax and a Schedule E summary for up to ten properties.
Run a renovation or build against the lender's draw schedule — budget vs. actual by line, change orders, retainage, a lender-ready draw request and continuation sheet, and a live cash position.
Run your whole book of business — a twelve-step pipeline, commission cap and net-income tracking, closing deadlines, and lead-source ROI in one workbook.
The full flip model — MAO on the 70% rule, ARV from comps, renovation budget, sensitivity solver, and a margin-of-safety block.
ARV, the 70% rule, your Maximum Allowable Offer, assignment fee, and marketing ROI by channel — the whole wholesale deal in one workbook.
Underwrite a duplex, triplex, fourplex, or up to 10 units — a unit-by-unit rent roll, cap rate, cash-on-cash return, debt service coverage ratio (DSCR), and a 30-year projection to your exit internal rate of return (IRR) and equity multiple.
Track a full year of an agent's production — set your gross commission income (GCI) goal, log every deal from active to closed, and see net commission after your broker split, goal pace, and a tax-ready expense summary on one dashboard.
See what it truly costs you to live in your own two-to-four-unit while tenants cover part of the mortgage — then whether the building cash flows the day you move out. Models an owner-occupied Federal Housing Administration (FHA), VA, or Conventional loan and returns a color-scored verdict on both.
A fast, one-page go/no-go read on a flip — enter six numbers, get your MAO, net profit, ROI, and a plain verdict. The entry-price companion to the Analyzer.
A fast, one-page read on a wholesale assignment — enter six numbers, get your Maximum Allowable Offer (MAO), the most to offer the seller, assignment fee, net profit, and a plain verdict. The entry-price companion to the Deal Analyzer.
A fast, one-page read on a buy-and-hold rental — enter seven numbers, get cap rate, cash flow, cash-on-cash return, debt service coverage ratio (DSCR), the 1% rule, and a plain verdict. The entry-price companion to the analyzers.
A fast, one-page read on an agent's year — set your gross commission income (GCI) goal, log each deal, and see closed, pending and projected GCI, your net after the broker split, and a color-scored pace verdict. The entry-price companion to the Commission Tracker.
A fast, one-page read on a house hack — enter eight numbers, get your net cost to live, savings versus renting, move-out cash flow, and a plain verdict. The entry-price companion to the House Hacking Analyzer.
Built to answer the question that actually matters: will this make money, and what does it take?
Every template comes from the desk of a working CFO who runs the numbers daily across real estate, hospitality, retail, and membership operations.
No passwords, no protected cells, no hidden sheets. Open any calculation, read the logic, and change it. You own the model, not just the file.
Every formula is checked cell by cell and tested in both Excel and Google Sheets before it ships. Working models, not decoration.
Pick the tool that matches the decision in front of you.
Landlord Bookkeeping System Pro tracks rent, expenses, deposits and your IRS Schedule E summary. The Rental Property Quick Analyzer and Multifamily Property Analyzer help you decide whether to buy.
Short-Term Rental Analyzer and STR Host Operating Tracker underwrite a property, then track occupancy, average daily rate (ADR), owner statements and lodging tax.
Fix & Flip Analyzer, Wholesale Deal Analyzer and Construction Draw Tracker cover the maximum allowable offer (MAO), after repair value (ARV), renovation budget and lender draws.
Realtor Income & Commission Tracker and Real Estate Agent Transaction Tracker follow gross commission income (GCI), broker split, deadlines and lead-source return.
Equity Waterfall Distribution Model splits a deal between limited partners and the general partner with preferred return and promote tiers.
House Hacking Analyzer and House Hack Quick Calc show what it costs to live in your own multi-unit while tenants cover part of the mortgage.
Plain-English how-tos on the numbers behind each tool. All guides
Build a 13-week cash flow forecast in Excel or Google Sheets: opening cash, weekly receipts and disbursements, closing cash, a minimum cash buffer and a weekly roll.
The IRS Schedule E expense lines landlords report, what typically goes on each line, and a simple monthly bookkeeping routine for rental properties.
Analyze a rental property deal with four numbers: NOI, cap rate, cash-on-cash return and DSCR, plus the 1% rule. Formulas and a worked example.
How resort, club and hotel operators calculate occupancy, ADR, RevPAR and gross operating profit (GOP), with formulas, a worked month and how to read budget variance.
What buyers ask before they download.
Yes. Every template is built in Excel and tested in Google Sheets before it ships. You get a standard .xlsx file that opens in desktop Excel, Excel for the web, and Google Sheets.
Formulas are fully visible, with no passwords and no hidden sheets. Cells are protected against accidental edits; unprotect any tab in one click to change the logic.
These are instant digital downloads from Etsy. Right after checkout, your files are available from your Etsy purchases page and in your order confirmation email.
One-time purchase. You pay once, keep the file, and there are no subscriptions or recurring fees.
The templates are built by a working chief financial officer (CFO) who runs real estate, hospitality, retail, and membership financials daily.
No. They are planning tools for information only, not financial, tax, legal, or investment advice. Check results with your own accountant or advisor.
Join the list for new releases and launch pricing. No spam, unsubscribe anytime.
Prefer Etsy? Just tap “Follow” on the shop page and Etsy will email you about new listings and sales.