Airbnb Investment Calculator Spreadsheet – Deal Analyzer: Cash-on-Cash, Cap Rate, 10-Year Projection, 3 Scenarios, Excel & Sheets, No Canva

Short-Term Rental Deal Analyzer is an Excel and Google Sheets workbook that answers the question every investor asks before making an offer: does this short-term rental actually make money? Enter the purchase price, financing, furnishing budget, ADR and occupancy, and every operating expense, and the workbook calculates cash-on-cash return, cap rate, DSCR, break-even occupancy, a 10-year projection with IRR, three scenarios and a side-by-side comparison of up to four deals.

No Canva needed. This is a plain spreadsheet with no macros and no add-ons. Yellow cells are for typing and gray cells hold the formulas. It works in Excel, Google Sheets and Numbers.

This is a template only, not financial, tax or legal advice. Have a local professional review it before use. Every number is an estimate based on your own assumptions, and real results depend on your market, financing, taxes and local rental rules.

What is inside (7 sheets)

• Inputs - property, purchase price, closing costs, down payment, interest rate and term; a 10-line furnishing and setup budget (furniture, beds and linens, kitchen, electronics, decor, smart lock and tech, photography, permits, initial supplies, contingency); ADR, occupancy, cleaning fee, average stay and other income; 13 operating expense inputs; growth, appreciation and selling-cost assumptions; and the Strong and OK thresholds.
• Analysis - loan amount, monthly payment (PMT), annual debt service, booked nights, stays, gross revenue, every expense line, NOI, cash flow after debt, cash-on-cash, cap rate, DSCR, gross rent multiplier, break-even occupancy, a Strong, OK or Weak verdict and three what-if lines.
• 10-Year Projection - year by year revenue, expenses, NOI, debt service, cash flow, cumulative cash flow, loan balance, property value, equity, net sale proceeds, total return if sold, annualized return and the 10-year IRR, with a line chart and a bar chart.
• Scenarios - conservative, base and optimistic columns (ADR, occupancy, cleaning fee, revenue growth, expense growth, appreciation) with revenue, NOI, cash flow, cash-on-cash, cap rate, DSCR, break-even occupancy, 10-year return, a does-it-still-work flag and two charts.
• Comparison - your deal plus up to three other candidates side by side, with NOI, cash flow, cash-on-cash, cap rate, DSCR, a rank by cash-on-cash and a chart.
• Dashboard - six headline numbers, the verdict, a scenario check, two charts and three lines on what moves the result most.
• Read Me - how to use the workbook, how each number is worked out and what is not included.

A complete sample deal is included (a 3-bedroom cottage at $385,000, $215 ADR, 62% occupancy, 6.75% interest), so every formula, flag and chart shows real numbers from the first click. Replace the yellow cells with your own property.

This workbook is for evaluating a property you might buy. It does not price a listing you already run.

Files you receive

• STR-Deal-Analyzer.xlsx - editable workbook
• STR-Deal-Analyzer.pdf - printable overview of every sheet
• START-HERE-How-to-Edit.pdf - editing guide for Excel, Google Sheets and Numbers

How it works

1. Download the ZIP after checkout.
2. Open the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
3. Type your property, financing, revenue and expense numbers into the yellow cells on Inputs.
4. Read the Analysis, test the Scenarios, compare other deals and check the Dashboard before you make an offer.

FAQ

Do I need Canva? No, this is an Excel file.

Does it tell me what the home will earn? No. You enter the ADR and occupancy you expect, ideally from comparable homes, and the workbook shows what that means for cash flow and returns. Use the scenarios to test lower numbers.

How is break-even occupancy calculated? It solves for the occupancy where annual cash flow is exactly zero, using your margin per booked night, your fixed costs and your debt service.

Are income taxes and depreciation included? No. Add what applies to you to the expense lines, and ask a tax professional.

Does it work in Google Sheets? Yes. Upload the file and open it with Google Sheets. The formulas avoid add-in functions.

License: personal and single-business use. Please do not resell or redistribute the files. Airbnb, VRBO and Booking.com are trademarks of their respective owners; this product is not affiliated with or endorsed by them.