Does Short-Term-Rental (Airbnb) Deal Analyzer work in Google Sheets and Excel?

Yes. Short-Term-Rental (Airbnb) Deal Analyzer is an .xlsx workbook that opens in Excel 2010 or newer, Google Sheets and LibreOffice. Short-Term-Rental (Airbnb) Deal Analyzer contains no macros, so nothing is blocked by security settings, and the yellow cells mark exactly where your own numbers go.

Why does break-even occupancy matter?

Break-even occupancy is the occupancy rate at which a short-term rental stops losing money, and the Airbnb Deal Analyzer solves it exactly rather than approximating. If that number sits close to the occupancy you expect, the deal is fragile — which is precisely what most Airbnb spreadsheets never show you.

How is Short-Term-Rental (Airbnb) Deal Analyzer verified?

Every metric in Short-Term-Rental (Airbnb) Deal Analyzer uses its standard industry definition, and the formulas are machine-tested for arithmetic correctness before release. Short-Term-Rental (Airbnb) Deal Analyzer also ships with a worked example and a plain-English “Start Here” sheet, so you can check the logic yourself rather than trusting the claim.

What does Short-Term-Rental (Airbnb) Deal Analyzer cost, and is there a subscription?

Short-Term-Rental (Airbnb) Deal Analyzer is $12 as a one-time purchase through Gumroad, with free updates and no subscription. Payment and delivery are handled by Gumroad; By the Loop never sees your payment details.

SPREADSHEET

Short-Term-Rental (Airbnb) Deal Analyzer

Name: Short-Term-Rental (Airbnb) Deal Analyzer — Cash Flow, DSCR & Break-Even Occupancy (Excel + Google Sheets)
Brand: By the Loop
SKU: str-deal-analyzer
Price: 12.00 USD
Availability: InStock

IN ONE PARAGRAPHThe Airbnb Deal Analyzer is a short-term-rental underwriting spreadsheet that calculates the number most tools skip: break-even occupancy, solved exactly. The Airbnb Deal Analyzer also computes cash flow, cap rate, cash-on-cash and DSCR from your nightly rate, occupancy and STR-specific costs. It costs $12 once.

An Airbnb can look amazing on Zillow and quietly lose money every month. Find out before you buy — not after. The Short-Term-Rental Deal Analyzer underwrites a potential Airbnb/VRBO the way it should be: revenue from your nightly rate and occupancy, all the STR-specific costs, and the one number most spreadsheets skip — the occupancy you actually need to break even.

What it calculates

Annual revenue from your ADR (average daily rate) × occupancy
All STR costs: platform/host fees, management %, cleaning, utilities, supplies, insurance, furnishing reserve, and more
NOI, monthly & annual cash flow, cap rate, cash-on-cash, DSCR
Break-even occupancy — solved exactly: the % you must stay booked just to cover every cost including the mortgage. If it's near your expected occupancy, the deal is fragile.
RevPAR and mortgage payment (standard amortization from your rate and term)

Why break-even occupancy is the whole game

Cash flow at 70% occupancy means nothing if you break even at 68%. This tool shows the gap instantly, so one soft season doesn't sink you. The worked example even shows a healthy deal — plug in a marginal one and watch it flag itself.

Why this one

Every metric uses the standard industry definition and is machine-verified for arithmetic correctness — no pretty-but-broken formulas. A plain-English "Start Here" sheet explains each number.

What you get

1 × .xlsx — Analyzer + Start Here. Excel 2010+, Google Sheets, LibreOffice. No macros.
Yellow cells are yours; a worked $300k / $210 ADR example shows the format. Yours forever, free updates.

Verification

Every metric uses the standard industry definition and the formulas are machine-tested for arithmetic correctness before release. The spreadsheet ships with a worked example and a plain-English “Start Here” sheet.

Important: a calculation tool, not investment advice. STR revenue is uncertain and seasonal, and many cities restrict short-term rentals — model conservatively, check local rules, and do your own due diligence. Real estate carries risk, including loss of capital.