Airbnb Investment Calculator (STR Analyzer)

Run the numbers before you buy. Excel & Google Sheets template.

Price: $15.00 USD · XLSX file · Instant download

What is included

  • Excel
  • Google Sheets
  • Compare 3 properties
  • Property inputs: price, down payment, loan rate and term, furnishing budget
  • Revenue model: nightly rate, occupancy and seasonality by month
  • Operating costs: cleaning, platform fees, utilities, management, insurance

About this tool

Run the numbers before you buy. Compare up to 3 short-term rental properties side by side and see cash flow, cash-on-cash return, cap rate and break-even occupancy in minutes.

Made for real estate investors and future hosts deciding whether a property will work as a short-term rental.

WHAT'S INCLUDED

• Property inputs: price, down payment, loan rate and term, furnishing budget

• Revenue model: nightly rate, occupancy and seasonality by month

• Operating costs: cleaning, platform fees, utilities, management, insurance

• Results: cash flow, cash-on-cash return, cap rate, break-even occupancy

• Compare up to 3 properties side by side

• Sensitivity table for rate and occupancy

• Instructions tab

HOW IT WORKS

1. Download the files using the download link you get right after checkout.

2. Open the .xlsx in Excel, or upload it to Google Sheets (File > Import > Upload).

3. Read the Start Here tab, then type in the cream cells. Everything else calculates for you.

4. Delete the sample data when you are ready to use your own.

GOOD TO KNOW

• Works in Excel 2016+, Excel for Mac, Microsoft 365 and Google Sheets

• No macros and no add-ons

• Colorful tabs and labelled charts

• Sample data is included so you can see how it works

• Instant digital download: nothing is shipped

For analysis only; not financial or tax advice. Check local short-term rental rules before you buy.

Buy it once and it is yours: no subscription, no account, free updates. Questions? Use the contact page and we reply within one business day.

How delivery works

Pay through PayPal and your download link appears on the success page right after payment. It works for 5 minutes and up to 3 downloads, and a fresh link is available from the same success page; if anything goes wrong, contact us. The file opens in any browser with no installation, no account and no subscription.