Airbnb Pro Forma: The 5-Year Model a Lender Will Actually Accept

A DSCR lender wants five years and a coverage ratio on each one. The $475,000 Fort Lauderdale deal below clears a 6.20% cap rate and still fails underwriting at 0.95 DSCR.

An Airbnb pro forma that survives a lender's desk needs five years, a debt service coverage ratio calculated on every one of them, and an occupancy assumption you can defend without a market estimate. The $475,000 Fort Lauderdale two-bedroom modelled below reads well on a one-year spreadsheet: 6.20% cap rate, $29,462 of net operating income. It fails underwriting anyway, at a year-one DSCR of 0.95 against the 1.20 most short-term rental lenders want. The gap between those two readings is the entire reason a pro forma exists.

Key takeaways

• A lender-ready Airbnb pro forma runs five years and reports DSCR on each one, because a deal that covers debt in year three and not year one is a deal that needs more cash at closing, not a better spreadsheet.
• The example property produces $29,462 of year-one NOI against $31,107 of annual debt service, a DSCR of 0.95, and needs 74.4% occupancy rather than the assumed 64% to reach a 1.20 DSCR.
• Freddie Mac's Primary Mortgage Market Survey put the 30-year fixed at 6.65% on August 20, 2026, and that survey covers owner-occupied purchases, so a DSCR investment quote sits above it.
• Airbnb charges its 15.5% single service fee on the nightly rate plus host-charged fees including cleaning, so a pro forma applying 15.5% to nightly revenue alone understates the fee by $1,660 in year one on this property.
• The IRS Schedule E property type code for a short-term rental is 3, and the form requires Fair Rental Days and Personal Use Days per property, which means your pro forma's occupancy assumption becomes a reported figure later.

What an Airbnb pro forma has to contain

Five statements, in this order: a revenue build, an operating expense schedule, net operating income, debt service with DSCR, and a cash flow line after debt. Anything that stops at net operating income is a cap rate exercise, and cap rate is the number that made the Fort Lauderdale deal look acceptable while it was failing.

Nobody buying their first door should build that from an empty grid. MagicBNB's Property Analyzer runs the same five in purchase mode with mortgage and depreciation simulation built in, and returns cap rate, annual ROI, and a fixed-versus-variable cash flow split from the inputs you already have.

The revenue build needs three inputs and one denominator. ADR, occupancy, and average length of stay, measured against available nights rather than calendar nights. Length of stay matters more than most models allow, because it sets turnover count, and turnover count drives cleaning volume, consumables, and the share of your calendar lost to same-day turns.

The expense schedule splits into fixed and variable. Fixed carries property tax, insurance, HOA, base utilities, internet, and software. Variable carries cleaning, consumables, and the maintenance reserve. A reserve is not optional in a lender-facing model. Leaving it out is the single fastest way to have a pro forma dismissed as unserious.

The five-year model, filled in

Here is the full build on a real structure. A $475,000 two-bedroom in Broward County, 20% down, a $380,000 loan at 7.25% over 30 years, $14,250 of closing costs and $34,000 of furnishing and setup. Total cash in at $143,250. Annual principal and interest is $31,107.

On the rate. Freddie Mac's Primary Mortgage Market Survey reported the 30-year fixed at 6.65% on August 20, 2026, down from 6.67% the week before and up from 6.58% a year earlier. That survey measures owner-occupied single-family purchases at 80% loan-to-value. A DSCR product on a non-owner-occupied short-term rental prices above it, and 7.25% is a defensible year-one assumption rather than a headline borrowed from the wrong loan type.

Year one revenue: $268 ADR at 64% occupancy across 365 available nights is 234 booked nights and $62,712 of nightly revenue. At 3.4 nights per stay that is 69 turnovers, and $155 of cleaning fee per stay adds $10,695. Booking subtotal reaches $73,407.

The platform fee comes off that whole subtotal, not off nightly revenue. Airbnb states its service fees are a percentage of the nightly price and any fees charged by the host, excluding the guest service fee and taxes. At 15.5% of $73,407 that is $11,378. A model applying 15.5% to the $62,712 of nightly revenue alone would report $9,718 and be short by $1,660 in year one. Cleaners are paid $10,005 against the $10,695 collected. Net revenue lands at $52,024.

Operating expenses: property tax at Broward County's 0.96% effective rate, per the Tax Foundation's county property tax data, is $4,560 on this basis. Short-term rental insurance at $4,800, which is a Florida coastal number and inflates faster than everything else in the model. HOA at $3,840, utilities and internet at $3,420, consumables at $1,080, software at $1,740. A 6% maintenance and capital reserve adds $3,121. Year-one NOI: $29,462.

Now the five years, with 3% ADR growth, occupancy stepping to 65% in year two, 3.5% general expense inflation and 8% insurance inflation.

• Year 1: $73,407 subtotal, $52,024 net revenue, $29,462 NOI, DSCR 0.95, cash flow negative $1,645.
• Year 2: $76,651 subtotal, $54,265 net revenue, $30,734 NOI, DSCR 0.99, cash flow negative $374.
• Year 3: $79,007 subtotal, $55,888 net revenue, $31,377 NOI, DSCR 1.01, cash flow $270.
• Year 4: $81,435 subtotal, $57,559 net revenue, $32,017 NOI, DSCR 1.03, cash flow $909.
• Year 5: $83,938 subtotal, $59,281 net revenue, $32,650 NOI, DSCR 1.05, cash flow $1,543.

Cumulative five-year cash flow: $704. On $143,250 of capital. The property appreciates and the loan amortises, so this is not a total loss, but nobody should sign it believing it is a cash-flowing asset.

DSCR is the line that decides the loan

DSCR is net operating income divided by annual debt service, and most short-term rental lenders want 1.20 rather than the 1.00 that appears in general DSCR marketing. The premium exists because seasonal revenue is more volatile than a twelve-month lease. This property returns 0.95 in year one and does not cross 1.20 in any of the five.

Run it backwards and the number gets useful. Holding ADR at $268, this deal needs 74.4% occupancy to reach a 1.20 DSCR. Broward is a strong market and 74.4% on available nights is not a normal year for a two-bedroom. That single calculation is worth more than the rest of the model, because it converts a vague worry into a testable claim about a specific submarket.

A pro forma is not a forecast of what will happen. It is a statement of what has to be true, written down precisely enough that someone can tell you it is not.

Lenders and partners push back on assumptions, not arithmetic, so showing your work matters more than showing your answer. MagicBNB's Milo analyst uses Chain-of-thought reasoning that splits a calculation into variables, formula, math and interpretation as separate auditable steps, so a DSCR figure arrives with its derivation attached.

The three assumptions that get a pro forma rejected

Occupancy measured against the wrong denominator is the first. Calendar-night and available-night occupancy differ by 8 to 15 points on any property with owner use or maintenance blocks, and quoting the flattering one to a lender who calculates the other is how a file gets marked as unreliable rather than merely optimistic.

Missing reserves is the second. A model with no maintenance line, no capital line, and no vacancy allowance is describing a property where nothing wears out. Underwriters have seen thousands of these.

Third is treating the occupancy figure as private. It does not stay private. IRS Schedule E lists property type code 3 for Vacation/Short-Term Rental and requires Fair Rental Days and Personal Use Days for each property. The occupancy you assumed at underwriting becomes a number you report annually, and a wide gap between the two across several years is a pattern, not a bad season.

Insurance modelled flat is a quieter fourth. At 8% annual inflation the $4,800 premium in this model reaches $6,531 by year five, which is $1,731 of NOI erased by one line nobody updated.

What to do when the pro forma fails

Three levers move a failing DSCR and only three. More cash down, a lower purchase price, or a defensible revenue assumption that is higher than the one you started with. Everything else is decoration.

On this deal, moving from 20% to 30% down cuts the loan to $332,500 and annual debt service to about $27,219, which lifts year-one DSCR to 1.08. Still short of 1.20. Getting the price to $415,000 at 20% down does more. The honest read is that the property is priced for a buyer with a different cost of capital, and walking is a legitimate outcome of the exercise.

Year two is where a pro forma earns its keep or gets quietly abandoned. MagicBNB's Property Detail carries a month-by-month year-over-year toggle with KPI delta pills, which turns the model you built at acquisition into a running comparison against actuals.

For the offer-stage process around this model, see magicbnb.io/blog/how-to-underwrite-short-term-rental. For the twelve inputs that drive it, see magicbnb.io/blog/short-term-rental-calculator. For the loan product itself, see magicbnb.io/blog/dscr-loans-short-term-rentals.

Frequently asked questions

What is an Airbnb pro forma?

An Airbnb pro forma is a multi-year financial projection covering revenue, operating expenses, net operating income, debt service, and cash flow for a short-term rental. A lender-facing version runs five years and reports DSCR on each one, because a single-year model cannot show whether a deal that fails in year one recovers by year three.

What DSCR do short-term rental lenders require?

Most short-term rental DSCR lenders want 1.20, above the 1.00 to 1.25 range quoted for DSCR products generally, because seasonal revenue is more volatile than a twelve-month lease. The example property returns 0.95 in year one and needs 74.4% occupancy instead of 64% to reach 1.20.

How many years should an Airbnb pro forma cover?

Five. A three-year model hides the insurance and property tax escalation that decides marginal deals, and on the example property insurance alone climbs from $4,800 to $6,531 between year one and year five at 8% annual inflation.

Does the Airbnb service fee apply to cleaning fees in a pro forma?

Yes. Airbnb charges the service fee on the nightly price plus any fees charged by the host, which includes cleaning. Modelling 15.5% against nightly revenue alone understated the fee by $1,660 in year one on the example property.

What occupancy rate should a pro forma assume?

Assume the occupancy your DSCR can survive, then test whether the submarket supports it. This property needs 74.4% on available nights to clear a 1.20 DSCR, so any market read below roughly 74% means the deal does not finance at 20% down regardless of what a comp set reports.

Is a pro forma the same as a proof of income for a DSCR loan?

No. A pro forma is a projection you build, while DSCR lenders underwriting a property with no operating history typically rely on an appraiser-supported rent analysis or third-party market data. The pro forma is what you use to decide whether to pursue the deal before a lender ever sees it.

Build the model that can fail

Run your next deal to a five-year DSCR before you run it to a cap rate. If the coverage ratio never crosses 1.20, the cap rate was never the number that mattered. Model purchase and lease deals with full mortgage simulation in MagicBNB →

About MagicBNB

MagicBNB is a portfolio intelligence platform for short-term rental operators, useful at one door and at twenty. A first-time buyer underwrites a deal before making an offer. An operator at six doors uses the 60+ metrics glossary to keep Cap Rate, NOI, DSCR and Cash-on-Cash Return on one consistent definition. A co-host uses the Monthly Portfolio Report Builder with PDF and Excel dual export for owner statements. See it at magicbnb.io.