An Airbnb property analysis tests whether a specific home can operate legally and produce acceptable cash flow under conservative assumptions. The process has five steps: verify the market and rules, calculate the full project cost, forecast revenue from comparable listings, model returns, and stress-test the risks.
For help finding and evaluating short-term rental opportunities, connect with the team at STRSearch. Its property search process supports investors from initial screening through underwriting.
- 1Verify market and rules
Confirm lawful use, permit availability, and comparable demand.
- 2Calculate total project cost
Include acquisition, renovation, furnishing, launch, and reserves.
- 3Forecast monthly revenue
Model available nights, occupancy, ADR, retained fees, and costs.
- 4Calculate cash flow and returns
Measure NOI, cap rate, cash yield, break-even occupancy, and DSCR.
- 5Stress-test and decide
Apply downside assumptions and predetermined approval rules.
Download the underwriting worksheet
Step 1: Verify the Market, Property, and Local Rules
Legal eligibility is the first screen because a property that cannot receive the required permit does not have a viable short-term rental revenue model. Review city and county ordinances, zoning, permit caps, owner-occupancy rules, minimum-stay requirements, occupancy limits, parking standards, and lodging-tax obligations before relying on projected income.
Confirm the rules with the government office that administers short-term rentals. Airbnb's local laws and taxes guidance explains that hosting requirements vary by jurisdiction and may include registration, permits, licenses, and tax collection. HOA declarations, condominium rules, leases, insurance restrictions, and mortgage terms can impose additional limits even when local law permits hosting.
Measure demand with comparable listings
Define a comparable set of at least five active listings that match the subject property's neighborhood, guest capacity, bedroom count, property type, amenity level, and overall quality. Broad city averages can hide meaningful differences between submarkets and property types.
- Demand drivers: Identify the attractions, employers, hospitals, universities, event venues, and seasonal travel patterns that generate bookings.
- Competitive supply: Record the number and quality of directly comparable listings rather than every listing in the market.
- Rate evidence: Check weekday, weekend, peak-season, and low-season prices across future dates.
- Booking evidence: Compare available calendars over time, while recognizing that blocked dates do not always represent reservations.
- Guest fit: Confirm that parking, accessibility, layout, and nearby services match the needs of the intended guest segment.
Third-party market data can support the analysis, but its occupancy and revenue estimates should be reconciled with listing-level evidence. Use a documented Airbnb market research process to record sources, observation dates, and comparable adjustments. Remove aspirational or poorly matched properties from the comparable set and document why each retained listing is relevant.
Step 2: Calculate the Complete Project Cost
The project budget must include the cash required to acquire, prepare, launch, and stabilize the property. Purchase price alone understates the investment and can make an otherwise weak deal appear attractive.
| Cost category | Include | Evidence to obtain |
|---|---|---|
| Acquisition | Purchase price, lender fees, appraisal, inspection, title, escrow, legal, and transfer costs | Loan estimate, closing disclosure, and professional quotes |
| Renovation | Repairs, design, construction, permits, contingency, and carrying costs during work | Scope of work, contractor bids, permit fees, and schedule |
| Furnishing and launch | Furniture, linens, kitchenware, locks, safety equipment, photography, supplies, and listing setup | Room-by-room budget and vendor quotes |
| Working capital | Operating reserve, debt-service reserve, utility deposits, and opening inventory | Monthly expense model and reserve policy |
Separate one-time costs from recurring expenses. Recurring expenses normally include property taxes, insurance, utilities, internet, cleaning not reimbursed by guests, supplies, repairs, maintenance, landscaping, pest control, software, licenses, accounting, management, platform fees, and reserves for future replacements.
Mortgage principal and interest belong in the cash-flow model, while interest is excluded from net operating income. Tax accounting follows different rules. IRS Publication 527 explains the treatment of residential rental income, operating expenses, mortgage interest, and depreciation. A qualified tax professional should determine the treatment for a specific owner and property.
Owners planning substantial setup work can use a detailed Airbnb furnishing cost breakdown to build the room-level budget. Add contingency only after obtaining current bids because a percentage applied to an incomplete scope still produces an incomplete budget.
Step 3: Build a Monthly Revenue Forecast
Revenue should be projected by month because nightly rates, occupied nights, and available nights change through the year. A single annual occupancy assumption can obscure low-season cash deficits and overstate the benefit of peak periods.
Estimate available nights, occupancy, and ADR
Start with the nights the property can legally and practically be offered. Subtract owner stays, planned maintenance, minimum-stay gaps, and any regulatory cap. Occupancy equals occupied nights divided by available nights, not automatically divided by 365. The detailed Airbnb occupancy-rate calculation explains how to keep available, blocked, and booked nights distinct.
Average daily rate, or ADR, is lodging revenue divided by occupied nights. Use comparable booked-rate estimates where available, then adjust for differences in location, capacity, amenities, condition, reviews, and management quality. Do not assume that the highest advertised rate will be achieved consistently.
| Forecast input | Calculation | Underwriting check |
|---|---|---|
| Available nights | Calendar nights minus owner use, closures, and unavailable dates | Matches local limits and operating plan |
| Occupied nights | Available nights multiplied by projected occupancy | Supported by seasonally matched comparables |
| Lodging revenue | Occupied nights multiplied by projected ADR | Excludes taxes and pass-through fees |
| Gross host revenue | Lodging revenue plus retained guest fees and other host income | Avoids counting reimbursed costs as profit |
Reconcile booking charges to owner revenue
Separate amounts paid by the guest from amounts retained by the owner. Lodging taxes collected for a government, refundable deposits, and reimbursements that merely offset an equal expense should not be treated as operating profit. Record every fee consistently in both the revenue forecast and expense model.
| Booking amount | Revenue treatment | Expense treatment |
|---|---|---|
| Nightly accommodation charge | Include as lodging revenue after discounts and refunds | Record related operating costs separately |
| Cleaning fee retained by owner | Include as fee revenue | Record cleaner and laundry costs separately |
| Platform service fee | Do not add to owner receipts when withheld from payout | Record consistently as a reduction of revenue or an operating expense, never both |
| Occupancy or lodging tax | Exclude when collected and remitted for the government | Include only tax the owner must pay and has not already excluded |
| Pet, extra-guest, or other retained fee | Include when earned and retained | Record related incremental costs separately |
Use three scenarios
Create downside, base, and upside cases. The base case should reflect supportable comparable evidence. The downside case should reduce both occupancy and ADR, then include higher variable costs where appropriate. The upside case can show potential, but it should not determine whether the acquisition is financially survivable.
For a simplified example, 240 available nights at 65% occupancy produce 156 occupied nights. At a $225 ADR, projected lodging revenue equals $35,100 before platform fees, operating expenses, debt service, and taxes. The example illustrates the calculation and is not a market benchmark or expected result.
Step 4: Calculate Cash Flow and Returns
Returns should be calculated from the same revenue and expense assumptions used in the monthly forecast. Keep property operations, financing, capital expenditures, and income taxes separate so each metric answers a defined question.
| Metric | Formula | Use |
|---|---|---|
| Net operating income | Property revenue minus property operating expenses | Measures operations before debt service, depreciation, and income tax |
| Cap rate | Annual NOI divided by purchase price or the selected property value basis | Compares unlevered property income with the chosen value basis |
| Cash flow before tax | NOI minus debt service and planned capital expenditures | Estimates cash remaining before owner-level income tax |
| Cash-on-cash return | Annual cash flow before tax divided by total cash invested | Measures annual pre-tax cash yield on invested cash |
| Debt-service coverage ratio | NOI divided by annual debt service | Tests the property's ability to cover scheduled loan payments |
Calculate break-even occupancy
Break-even occupancy is the share of available nights that must be booked to cover annual fixed operating costs, debt service, and the variable cost associated with each occupied night. The calculation uses contribution per occupied night, which equals ADR minus variable cost per occupied night.
Airbnb underwriting formula card
Occupied nights ÷ available nightsLodging revenue ÷ occupied nightsProperty revenue − property operating expensesAnnual NOI ÷ stated property value basisAnnual pre-tax cash flow ÷ total cash investedNOI ÷ annual debt service(Fixed operating costs + debt service) ÷ (ADR − variable cost per occupied night)Break-even occupied nights ÷ available nightsAssume annual fixed operating costs of $21,000, annual debt service of $24,000, a $225 ADR, a $38 variable cost per occupied night, and 300 available nights. Break-even occupied nights equal $45,000 divided by $187, or approximately 241 nights. Break-even occupancy is approximately 80.2%. That result would leave little room for forecast error if the supported base occupancy were only 82%.
This simplified calculation excludes income taxes and irregular capital events. Include replacement reserves or planned capital expenditures in the numerator when the investment standard requires them. A lender may also define NOI or DSCR differently for loan qualification.
Define the denominator before comparing returns. A cap rate based on purchase price is different from one based on total project cost, and cash invested should include the down payment, closing costs, renovation, furnishing, and other cash contributed to reach stabilized operation.
Assume a property produces $60,000 in annual property revenue and $32,000 in operating expenses. NOI is $28,000. If annual debt service is $20,000 and planned capital expenditures are $2,000, cash flow before tax is $6,000. If total cash invested is $120,000, cash-on-cash return is 5%. These figures are hypothetical and exclude appreciation, sale proceeds, depreciation, and owner-specific taxes.
A complete Airbnb investment underwriting process also compares the projected return with the investor's risk tolerance, liquidity needs, and alternative uses of capital. A positive return alone does not establish that the price is attractive.
Step 5: Stress-Test the Deal and Set Decision Rules
A stress test identifies the assumptions that can cause the property to miss its cash-flow target. Change one variable at a time to measure sensitivity, then combine plausible adverse conditions to model a realistic downside year.
- Revenue: Reduce occupancy and ADR, especially during the market's weakest months.
- Operating costs: Increase insurance, utilities, cleaning, repairs, management, and property taxes.
- Project execution: Extend the renovation schedule and increase the setup budget.
- Financing: Test the final quoted rate, required reserves, amortization, and any variable-rate exposure.
- Regulation: Model a permit delay, a shorter legal operating season, or conversion to a permitted mid-term or long-term use.
- Capital events: Include a major repair and adequate replacement reserves.
Write the approval criteria before negotiating
Decision rules prevent an attractive property or optimistic forecast from changing the standard mid-analysis. Establish a maximum total project cost, minimum reserve balance, minimum downside cash flow, required return, and legal-operability condition before submitting an offer.
- Reject the property if short-term rental eligibility cannot be confirmed in writing from authoritative sources.
- Revise the price or scope if current bids push total project cost above the approved limit.
- Require the downside case to meet the investor's minimum cash-flow and reserve standards.
- Confirm that management capacity and local vendors can support the operating plan.
- Document the exit options and estimate the costs of converting to another lawful rental strategy.
Apply the deal-killer screen
Stop, reprice, or obtain more evidence when:
- Short-term rental use cannot be confirmed through authoritative rules and required approvals.
- A permit is unavailable, nontransferable, or inconsistent with the intended operating plan.
- An HOA, lender, lease, or insurer prohibits the intended use.
- Comparable evidence does not support the projected ADR or occupancy.
- Break-even occupancy is too close to or above supportable occupancy.
- The downside case cannot cover debt service or maintain the required reserve.
- Current bids push total project cost above the approved limit.
- The property lacks a workable management plan or lawful alternative rental strategy.
Worked Example: From Assumptions to Decision
Consider a hypothetical property with a $400,000 purchase price, $100,000 down payment, $12,000 in closing costs, $25,000 in renovation, $22,000 in furnishing and launch costs, and $18,000 in opening reserves. Total cash invested is $177,000 before any additional financing costs or funded contingencies.
The base forecast assumes 300 available nights, 62% occupancy, and a $225 ADR. That produces 186 occupied nights and $41,850 in lodging revenue. With fixed operating costs of $21,000 and variable costs of $38 per occupied night, projected NOI is $13,782. Annual debt service of $24,000 produces negative pre-tax cash flow of $10,218 and a DSCR of approximately 0.57.
The same assumptions require approximately 241 occupied nights to cover fixed operating costs and debt service, equal to about 80.2% break-even occupancy. Because the base occupancy forecast is only 62%, the property fails before the downside case is applied.
| Decision stage | Result | Action |
|---|---|---|
| Legal and market | Assume legal use is confirmed and comparable demand supports 62% occupancy | Continue to financial analysis |
| Project cost | $177,000 total cash invested | Confirm current bids and financing costs |
| Base operations | $13,782 NOI and negative $10,218 pre-tax cash flow | Do not approve at current assumptions |
| Break-even | 80.2% occupancy required versus 62% supported occupancy | Reject, reduce price or debt, or revise the operating plan with evidence |
Final Airbnb Property Analysis Checklist
A purchase recommendation should be supported by a file that another reviewer can reproduce. The final package should contain the following evidence:
- Local ordinance, permit, zoning, tax, HOA, insurance, and lender checks
- Comparable listings with selection rationale and observed dates
- Monthly ADR, occupancy, available-night, and revenue assumptions
- Acquisition, renovation, furnishing, launch, and reserve budgets
- Recurring operating expenses with sources
- Downside, base, and upside cash-flow models
- NOI, cap rate, cash flow, cash-on-cash return, and debt coverage calculations
- Written approval thresholds, risks, and exit options
The property passes analysis only when its legal status, operating assumptions, costs, and downside performance satisfy the investor's predetermined criteria. Unsupported revenue, incomplete expenses, or uncertain operating rights require more evidence, a revised price, or rejection of the deal.
