Log in or sign up

Loading your account…

A spreadsheet printout with highlighted rows on a desk beside a laptop and a cup of coffee, the numbers blurred

For investors

How to Read a Short-Term Rental Pro Forma

Read a short-term rental pro forma line by line: income, fees, operating costs, the loan, the red flags sellers hide and what to verify before you offer.

Category

For investors

Written by

The JekkyStay team

Published

· 8 min read

Quick answer

To read a short-term rental pro forma, go line by line from gross income down to cash flow, ask where each number came from, and rebuild the sheet with your own figures. The seller's version shows what a property could earn; your version shows what it is likely to earn.

This guide walks through each line, the red flags we see most often, and what to verify before you make an offer. The worked Example uses invented numbers.

This is general information, not tax, legal or investment advice. Talk to a CPA, an attorney and your lender about your own situation.

Key takeaways

  • A pro forma is a forecast, not a record: read it top to bottom, and rebuild every line from your own sources before you trust the bottom line.
  • Occupancy and nightly rate drive the whole sheet, so compare them with what similar homes nearby actually book, not with the best month.
  • The most common gaps are a missing management fee, a platform fee that does not match how the listing is set up, no reserve for replacements, and last year's property tax.
  • Depreciation is a tax line, not cash, so it should never raise the cash flow figure.
  • Run the adjusted numbers through a calculator and a stress test: if a 10 point drop in occupancy wipes out the cash flow, the deal is thin.
In this guide
  1. What a pro forma is, and what it is not
  2. The income lines
  3. The operating cost lines
  4. A worked Example: the seller's sheet against yours
  5. Red flags to look for
  6. What to verify before you offer
  7. The bottom line

What a pro forma is, and what it is not

A pro forma is a forecast of a rental's income and costs for a typical year, built from assumptions rather than a record of what happened.

That distinction matters. A trailing profit and loss statement shows what a property actually earned. A pro forma shows what someone expects it to earn, and the person who prepared it usually wants you to buy. Neither is dishonest by nature, but the pro forma deserves more questions.

Most short-term rental pro formas follow the same shape:

  1. Income: nightly rate times booked nights, plus cleaning fees charged to guests.
  2. Operating costs: cleaning, platform fees, management, utilities, supplies, repairs, insurance, property tax and a reserve.
  3. Net operating income (NOI): income minus operating costs, before the loan.
  4. Debt service: the yearly mortgage payment.
  5. Cash flow and returns: what is left after the loan, and ratios such as cap rate, cash-on-cash return and debt service coverage.

Read it in that order. A mistake near the top flows through every line below it.

The income lines

The income section rests on two inputs, average nightly rate and occupancy, and almost every inflated pro forma inflates one of them.

Nightly rate. Ask whether it is the average across the year or the rate in a good month. A group home that books $600 a night over a holiday weekend may average far less once you include winter weeknights.

Occupancy. This is the share of the year's nights that are booked. A high figure with no source is the biggest single red flag on a pro forma. Ask for the actual booking calendar if the home is already rented, and compare with similar homes nearby.

Booked nights and stays. Occupancy times 365 gives booked nights. Divide by the average stay length to get the number of stays, which drives cleaning income and cleaning cost. A pro forma that shows high occupancy but very few stays has probably assumed long stays, which lowers cleaning costs on paper.

Cleaning fees. These are income from guests, but each stay also has a cleaning cost. Check both lines are there and use the same number of stays.

The operating cost lines

Operating costs are where a pro forma most often looks better than reality, usually because a line is low or missing altogether.

Go through each one:

  • Cleaning cost per stay. Should rise with bedrooms. Check it against a quote from a local cleaner.
  • Platform fees. Airbnb's help page says most hosts on the split fee pay 3%, while most hosts on the host-only fee pay 15.5%, and that the host-only fee is mandatory for most hosts, including those who use property management software. If the pro forma uses 3% but the home will be run through management software, the fee line is too low.
  • Management. Even if you plan to self-manage, put in a fee or a value for your time. A pro forma with no management line assumes you work for free. Our guide to vacation rental management fees covers how fees are usually structured.
  • Utilities and internet. Guests run the air conditioning, heat, pool and hot tub. Ask for the actual bills.
  • Supplies. Linens, toiletries, paper goods, coffee and replacements for what breaks.
  • Repairs and maintenance. A group home sees heavy use. A very low figure is a sign the seller is counting on nothing going wrong.
  • Insurance. A short-term rental usually needs a different policy than a standard homeowner's policy. Get your own quote rather than using the seller's number.
  • Property tax. Many counties reassess after a sale, so last year's bill may be lower than yours will be.
  • Licenses, permits and local taxes. Some cities charge permit fees and lodging taxes. See short-term rental permits.
  • Reserve for replacements. Furniture, appliances, mattresses and the roof all wear out. A pro forma with no reserve treats them as free.

IRS Publication 527 makes a useful distinction here: repairs can generally be deducted, but you must capitalize expenses that improve the property. For the pro forma, that means a new roof belongs in the reserve, not in ordinary repairs.

A worked Example: the seller's sheet against yours

The quickest way to see what a pro forma hides is to rebuild it line by line next to the original.

LineSeller's pro formaAdjusted (Example)
Booked nights256201
Rent at $400 a night$102,400$80,400
Cleaning fees ($250 per stay, 3-night average)$21,250$16,750
Total income$123,650$97,150
Cleaning cost ($220 per stay)$18,700$14,740
Platform fee$3,710 (3%)$15,058 (15.5%)
Management$0$16,080 (20% of rent)
Utilities, internet and software$7,200$7,200
Supplies$2,400$2,400
Repairs$3,000$3,000
Insurance$3,500$3,500
Property tax$4,500$7,000
Reserve$0$4,800
Operating costs$43,010$73,778
Net operating income$80,640$23,372
Cap rate on $450,00017.9%5.2%

Same house, same nightly rate. The difference is four assumptions: occupancy, the platform fee, management and the reserve, plus a tax bill that reflects a sale. Each one is defensible on its own. Together they cut the NOI by more than two thirds.

Now add the loan. Say the yearly mortgage payment is $20,000. On the seller's sheet, cash flow is $60,640. On the adjusted sheet it is $3,372, and the debt service coverage ratio is about 1.17, below the 1.25 our deal analyzer uses as its benchmark for most DSCR lenders. If the buyer put in $112,500 down, $12,000 in closing costs and $40,000 in furniture, that $3,372 is a cash-on-cash return of about 2%.

A hand holding a pen over a printed financial summary next to a magnifying glass, the text out of focus
Rebuild each line yourself. The assumptions that look small on their own add up fast.

Red flags to look for

Most weak pro formas share a handful of patterns, and you can spot them in a few minutes once you know where to look.

Red flagWhy it mattersWhat to ask for
Occupancy with no sourceIt drives every income lineBooking calendar, payout statements, comparable listings
One annual figure, no monthsHides slow seasons and cash shortfallsA month-by-month projection
Platform fee of 3%Wrong if the host-only fee appliesHow the listing is set up and which software it uses
No management lineAssumes free laborYour own quote, or a value for your time
Last year's property taxMay rise after a saleThe county's reassessment rules
No reserveReplacements show up as surprise costsA yearly reserve line
Depreciation added to cash flowIt is a non-cash tax deductionCash flow before any tax effect
Cash invested is only the down paymentOverstates cash-on-cash returnClosing, furnishing and startup costs included
Year one income from a brand new listingNew listings take time to build reviewsActual results from similar homes

Depreciation deserves a note. IRS Publication 527 lists residential rental property as depreciated over 27.5 years under the general system. Depreciation can lower taxable income, but no cash changes hands, so it should sit in a separate tax section and never raise the cash flow line. Tax treatment of short-term rentals has its own rules, which our short-term rental tax loophole guide explains; ask a CPA before relying on any tax figure.

What to verify before you offer

Before you make an offer, turn each assumption into a document or a quote you got yourself.

  1. Actual results. If the home is already a rental, ask for 12 to 24 months of payout statements and the booking calendar, not a summary.
  2. Comparable homes. Check rate and occupancy for listings with the same bedroom count in the same area across a full year.
  3. Bills. Ask for utility, internet and pool service bills.
  4. Insurance. Get your own quote for a short-term rental policy.
  5. Property tax. Ask the county how the assessment will change after a sale.
  6. Rules. Confirm the city and any homeowners association allow short-term rentals, and what permits and taxes apply.
  7. Loan. Get the actual rate and payment from your lender, and ask how it calculates income for a DSCR loan. Our DSCR loans guide explains the ratio.
  8. Startup costs. Price the furniture, supplies and photos you will need.

Then run your adjusted numbers through the deal analyzer, which adds the loan, the slow months and a stress test, and check the ratios with the cap rate calculator and the DSCR calculator. If you want the full method, our step-by-step guide to analyzing a short-term rental deal covers it, and cap rate vs cash-on-cash return explains which ratio answers which question.

The bottom line

Read a short-term rental pro forma from the top: question the nightly rate and occupancy first, then check every cost line is present and realistic, and keep depreciation out of cash flow. Rebuild the sheet with your own documents and quotes, run it through a calculator, and test it at lower occupancy. All our free tools are on the investor tools page. If you are interested in investing with JekkyStay, see our investors page.

This is general information, not tax, legal or investment advice.

Frequently asked questions

What is a short-term rental pro forma?

It is a projected income statement for a vacation rental: expected nightly rate and occupancy, the income they produce, the operating costs, net operating income, the loan payment and the cash left over. Sellers, agents and syndicators prepare them to show what a property could earn. It is a forecast, so every input needs checking.

What occupancy rate is realistic on a pro forma?

There is no single right number. Use what comparable homes of the same size in the same area actually book across a full year, then test the deal 10 and 20 points lower. Be wary of a pro forma that uses a peak-season month as the annual rate.

What platform fee should a pro forma use?

It depends on how the listing is set up. Airbnb's help page says most hosts on the split fee pay 3%, while most hosts on the host-only fee pay 15.5%, and the host-only fee is mandatory for most hosts who use property management software. Use the fee that matches how the home will actually be run.

Should depreciation be on a short-term rental pro forma?

It can appear in a tax section, but it should not raise cash flow. Depreciation is a non-cash deduction. IRS Publication 527 lists residential rental property as depreciated over 27.5 years under the general system. Ask a CPA how it applies to your situation.

How do I check a seller's pro forma numbers?

Ask for the actual booking history and payout statements, the last property tax bill, utility bills and the insurance policy. Compare rate and occupancy with nearby listings of the same size, get your own insurance quote, and ask the county how the tax will change after a sale.

What is a good cash-on-cash return on a vacation rental?

There is no standard answer, and no one can promise a return. Compare it with what your cash could earn elsewhere at similar risk, and make sure the cash you put in includes closing costs and furnishing, not just the down payment.

Sources

  1. Airbnb Help Center: Airbnb service fees
  2. IRS Publication 527: Residential Rental Property

Invest in large group homes

Accredited investors can register for future JekkyStay opportunities.