Rental Property & Airbnb Cash-Flow Analyzer - Excel & Google Sheets

Know if a rental is a good deal before you make an offer. Enter the price, financing and your assumptions once and this Excel & Google Sheets analyzer calculates monthly cash flow, cap rate, cash-on-cash return, DSCR, break-even and a 10-year outlook for BOTH a long-term tenant and a short-term (Airbnb / VRBO) rental, side by side.

What's inside

• Inputs: every assumption in cream cells with notes (mortgage, vacancy, nightly rate, occupancy, cleaning, management, reserves, growth, targets)
• Analysis: income, expenses, NOI, cash flow, cap rate, cash-on-cash, DSCR, GRM, expense ratio, payback years and break-even rent / occupancy
• 10-Year Projection: cash flow, loan balance, equity, sale profit and IRR
• Dashboard: KPI tiles, verdict vs your own targets, strategy comparison and 2 charts
• Portfolio: track up to 12 properties you already own
• Start Here guide in every file

You get: a BLANK workbook and an EXAMPLE workbook with a worked 3-bed house deal (easy to clear).

Works in: Excel 2010+, Microsoft 365, Excel for Mac and Google Sheets (upload the .xlsx, Open with Google Sheets). Standard formulas only, no macros.

Instant DOWNLOAD. For your own use.

Disclaimer: An educational planning tool, not financial, investment, tax or legal advice. Results depend on your inputs. Check local short-term rental rules and licensing.