Three valuation methods. Total equity. What a buyer would actually pay. Portfolio valuation model for Airbnb / STR investors. Cap rate × NOI, comparable sales, gross rent multiplier. Excel + Google Sheets. How much is your STR portfolio actually worth? Most hosts know what they paid. Few know what it’s worth today. Even fewer know what a sophisticated investor (not a retail homebuyer) would actually pay if you put it on the market. This workbook computes current market value using 3 methods — cap rate × NOI, comparable-sales (per BR/BA), gross rent multiplier — and outputs a mid-point estimate, a conservative estimate (use this for refi LTV math), and a buyer’s- perspective price for sale conversations. WHAT’S INCLUDED 📋 Property Roster — every property with purchase, basis, current debt 📋 NOI Inputs — stabilized NOI per property (pull from TAX-002) 📋 Cap Rate Method — cap rate × NOI per market 📋 Comparable Sales Method — recent comps by BR/BA, $/sqft or $/bed 📋 Gross Rent Multiplier Method — GRM × annual gross rent 📋 Three-Method Compare — independent estimates per property 📋 Mid-Point Valuation — average of the three (most defensible) 📋 Conservative Valuation — lowest of three (use for refi LTV math) 📋 Total Portfolio Equity — sum of (mid-point − current debt) 📋 Debt-to-Value Ratio — portfolio leverage health check 📋 Buyer’s-Perspective Price — what an investor would pay (vs retail homebuyer)
Related
- 3-Property Side-by-Side Comparison
- 5-Year Pro Forma Builder
- Aspiring Host Bundle
- Commission / Split Calculator for Co-Hosts
- Cost-to-Launch Calculator
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.