The STR Ledger.
The Deal Analyzer cover

ACQ-001 · Acquisition

The Deal Analyzer.

STR underwriting workbook. Stress-tested. Yes-or-no on a property in 10 minutes. Cash-on-cash, DSCR, cap rate, and a go/no-go recommendation.

The 30-second pitch

You’re three weeks into looking at deals. You’ve opened the same generic “rental property calculator” twelve times. It asks for purchase price and rent. It does not understand cleaning fees, occupancy seasonality, furnishing CapEx, or that your real cash-on-cash sits 4 points below the headline number once you back out the actual operating math.

This is the workbook for the math. Fifteen minutes from MLS listing to a defensible go/no-go.

Math that earns the price

One bad acquisition costs $30,000-$80,000 to unwind. The workbook costs $47. The math is not complicated.

What's inside

  • Deal Inputs — purchase price, down, rate, ARV, furnishing budget, projected ADR + occupancy.
  • Operating Pro Forma — month-by-month revenue and expense build for year 1.
  • Returns Dashboard — cash-on-cash, DSCR, cap rate, IRR over 5 years.
  • Sensitivity Grid — what happens at -10/-20% occupancy or ADR.
  • Go / No-Go — color-coded recommendation against your own thresholds.
  • Comp Worksheet — paste AirDNA or PriceLabs comps; auto-blend to a defensible ADR.

FAQ

Does this pull AirDNA data automatically?
No. You paste comp data manually. AirDNA's TOS prohibits API scraping and the data goes stale fast either way.
How conservative are the defaults?
Defaults assume 10% vacancy on top of seasonality, 12% cleaning cost, 8% PM (or zero if self-managed), and a 5% maintenance reserve. Edit any cell.
Does this work for rental arbitrage?
No. Arbitrage has different mechanics (no down, no equity, lease term risk). Use ACQ-003 — Rental Arbitrage Analyzer.
Can I share scenarios with my partner?
Save copies of the workbook with different filenames. Excel/Sheets-native, no app required.
What's your refund policy?
14 days, no questions. Email hello@thestrledger.com.

Get the workbook

Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.

Built by The STR Ledger. Excel templates and PDFs for short-term rental finance.

Visit The STR Ledger