Vacation Rental Investment Calculator

Someone posted in a BiggerPockets STR thread last month asking how I knew the Smoky Mountains cabin I bought was a real deal before I closed. I almost said gut feel. The actual answer: I ran a spreadsheet for three hours, got my year-one occupancy projection wrong by 11 percentage points, and still made money because I'd stress-tested the downside hard enough that even the miss didn't hurt me.

A vacation rental investment calculator doesn't give you certainty — nothing does. What it does is force you to write down your assumptions explicitly so you can pressure-test them and find out whether your deal works at 50% occupancy or only at 72%.

Here's the full framework I use before every acquisition. You can build it in Google Sheets in under an hour.

What This Calculator Actually Does

At its core, a vacation rental investment calculator projects gross revenue, subtracts every real cost category, and outputs the metrics that tell you whether the deal is worth doing. That's it. Seasonality curves, dynamic pricing simulations, comparable-property pulls — those are refinements layered on top. Get the foundation right first.

The Core Inputs and Metrics

Gross Revenue

Gross Revenue = ADR × Occupancy Rate × 365.

ADR (average daily rate) is the most important input in the model and the most commonly wrong one. Don't use your listing price. Use what you'll actually collect after promotions, mid-week fill discounts, and slow-season rate drops. In Q1 2026, I audited 90 days of actuals on my Columbus GA property and found my effective ADR was $23 below my sticker rate because of mid-week discounts I'd set and half-forgotten. That's $2,070 less annualized on a single property. Pull your real average from your channel manager or booking history, not your calendar rate.

Operating Expenses

This is where most investor models fall apart. People remember the mortgage and forget eight other cost buckets. Here's the complete list:

• Debt service: Mortgage principal plus interest. If you're paying cash, model your opportunity cost instead.
• STR-specific insurance: Budget 2–3× a standard homeowner's policy. On a $400,000 property, expect $2,500–$4,000/year. Standard policies exclude commercial rental use.
• HOA fees: Many STR-friendly communities still charge $200–$600/month. Verify before you make an offer — some HOAs have quietly banned short-term rentals in the past two years without advertising it.
• Platform fees: Airbnb charges hosts roughly 3% per booking. VRBO runs closer to 5%. If you list on both, model a blended rate based on your projected channel split, not a flat 3%.
• Cleaning: You can pass cleaning fees to guests, but you'll absorb costs for gap-night cleans, owner stays, and slow-season deep cleans. Budget $150–$300 per clean for a 3BR depending on your market.
• Supplies and restocking: Toiletries, paper goods, dish soap, light bulbs, batteries. Budget $75–$175/month for a 2–3BR. This line surprises almost every new host.
• Utilities: Water, electric, gas, internet. Most STRs include utilities — budget $250–$500/month depending on climate and property size.
• Maintenance and repairs: 1% of property value per year as a baseline. On a $350,000 property, that's $3,500/year. Add 0.5% for properties with a pool or hot tub.
• Property management (if outsourcing): Typically 20–30% of gross revenue for full-service managers. This single line makes most deals not pencil in high-price markets if you aren't self-managing.
• Software and tools: Dynamic pricing, property management software, messaging tools. Budget $100–$300/month for a full stack. Self-managing hosts running lean can get this under $50/month.
• Smart home hardware (amortized): A Yale Assure 2 lock runs around $250. An ecobee SmartThermostat Premium is about $220. A Nest 3rd-gen thermostat is $130. Budget $500–$1,500 upfront for a fully automated setup, amortized over five years — this directly reduces labor cost and guest friction on checkout-to-checkin turns. Here's a full breakdown of which smart lock to pick for Airbnb before you standardize on hardware.
• Miscellaneous buffer: Add 5% of projected gross revenue as a catch-all. Something always comes up in year one that you didn't model.

The Four Metrics That Matter

Breakeven occupancy is the first number I look at. If a deal only breaks even at 68% occupancy and the market median sits at 62%, you're one slow season from bleeding money. If it breaks even at 42%, you have a real buffer. That buffer is what lets you hold through a year like 2023, when a lot of STR markets saw 10–15 point occupancy drops in previously hot destinations.

How to Build the Calculator: Step by Step

1. Pull market ADR data. Use AirDNA ($19.95–$39.95/month) or Rabbu (free tier available) to get the trailing 12-month ADR for comparable properties in your target zip code — matched specifically by bedroom count, property type, and key amenities. A Smoky Mountains cabin with a hot tub commands $40–$60/night more than one without. Don't average across property types.
2. Set a conservative occupancy rate. Take the market average and subtract 8–12 percentage points for year one. New listings build slowly — reviews, photography, and pricing calibration all take 60–90 days to dial in. Projecting market-average occupancy from day one is the single most common modeling mistake I see.
3. List every expense category. Don't skip any line. The ones people miss most often: STR insurance premium versus standard homeowner's, capex reserve, and supplies restocking.
4. Calculate NOI. Gross Revenue minus all operating expenses, before debt service. This number lets you compare deals independent of how you're financing them.
5. Subtract debt service from NOI to get annual cash flow. Divide that by your total cash invested — down payment plus closing costs plus upfront setup spend — for your cash-on-cash return.
6. Compute breakeven occupancy. Annual fixed costs divided by (ADR × 365). This is your safety floor. Know it before you make an offer.
7. Run three scenarios. Base case, downside (occupancy minus 15 points), and upside (occupancy plus 10 points). Only close if the downside scenario still produces positive cash flow — or at minimum, covers your mortgage so you can weather a genuinely bad year without forced selling.

Common Mistakes That Wreck the Model

Using gross ADR instead of net. Airbnb's 3% host fee and VRBO's ~5% come off your payout before you see a dollar. On a $50,000 gross revenue property, a 3% fee is $1,500/year. Build it in from line one.

Ignoring seasonality. A mountain cabin might do $280/night in October and $95/night in February. A flat ADR across 365 days overstates revenue. Use a monthly model with a seasonal index if you can get market-level monthly data from your comp research tool.

Underestimating insurance. I've seen hosts budget $1,200/year for STR insurance on a $500,000 property and get quoted $3,800. That $2,600 gap flips a marginal deal into a loss. Always get an actual STR insurance quote before you finalize your model.

No capex reserve. The HVAC will fail. The roof has a lifespan. Budget 0.5–1% of property value annually for capital expenditures on top of your maintenance line. It feels conservative until the $8,500 HVAC replacement hits in year three.

Single-channel dependency. Projecting 70% occupancy relying solely on Airbnb means betting on their algorithm and their pricing. A property management system can handle multi-channel distribution without significantly increasing your operational overhead — worth modeling the revenue upside of VRBO plus direct bookings alongside the modest cost increase.

Where the Calculator Breaks Down

At scale — five or more properties in a market you know well — this model matters less than your own historical data. You'll understand your seasonality curves better than AirDNA by year two. The calculator is most valuable for your first two or three acquisitions. It builds analytical discipline that pays off later, even when the specific numbers feel imprecise.

More critically: no calculator models permitting risk. Cities like Nashville, Austin, and Scottsdale have tightened STR permits in ways that can kill a deal after you've already closed. Run your numbers, then independently verify local STR permitting status before you make an offer. The VRMA tracks STR regulatory changes by market — check it for any market you're seriously pursuing. One zoning change can reduce a 12% cap rate deal to a long-term rental yielding 5%.

Tools That Help With Inputs and Ongoing Operations

For market data, AirDNA ($19.95–$39.95/month) is the most widely used source for comparable revenue estimates. Mashvisor ($17.99–$74.99/month) blends long-term and short-term rental comps if you're comparing asset classes or evaluating a market where STR demand is thin. Neither replaces local knowledge — their occupancy projections tend to run 5–8 points optimistic in emerging markets where the comparable property count is low. Cross-check by looking at actual Airbnb calendars for established listings in the area and estimating their real occupancy from blocked dates.

Once you close, operational overhead determines whether your real returns match your model. Bad management can turn a good investment into a weekend-eating headache that barely breaks even. A solid STR management platform keeps per-property labor low enough that the numbers you modeled hold in practice. If you're evaluating channel managers specifically, there are worth-knowing Hospitable alternatives depending on your property count and tech preferences.

On the demand side, guest messaging quality affects occupancy more than most investors anticipate in year one, before your review count is large enough to sell itself. Airbnb messaging tools with AI-drafted replies can improve inquiry conversion during that early window when response time and tone are the main differentiators between you and a more established listing.

I run 12 properties on Koohost ($30/month Pro Host, full PMS API integration with Hospitable, Lodgify, and Smoobu). My monthly software cost across all 12 is under $100, including dynamic pricing coordination and smart home management through Yale Assure 2 locks and ecobee thermostats. That operational cost is a line in my investment model — it directly affects whether cap rate projections hold in year two and three.

If you're doing this analysis for the first time, the BiggerPockets short-term rental forums have threads where operators share actual P&Ls from real properties. Those are worth more than any calculator tutorial, including this one. Read 20 real examples before you trust your own model.

Try Koohost free for 30 days — no credit card. Sign up here and get the operational side of your investment working from day one so the numbers you modeled are the numbers you actually hit.

FAQ

What is a good cap rate for a vacation rental investment?

Most STR investors target a 7–12% cap rate. Below 5% requires a strong property appreciation thesis — you're counting on price growth, not income, to generate returns, which is speculation not investment. Above 12% usually signals higher market risk: regulatory uncertainty, thin year-round demand, or a property that needs significant work. Cap rate is a useful starting filter, but always pair it with breakeven occupancy to understand how much demand cushion you actually have.

Should I include the mortgage payment in my cap rate calculation?

No. Cap rate is calculated using NOI (net operating income) before debt service, divided by purchase price. This makes it independent of your financing structure so you can compare deals regardless of how much you put down or what your interest rate is. Cash-on-cash return is the metric that accounts for your specific financing — use both metrics together rather than either alone.

What occupancy rate should I project for a new short-term rental listing?

Take the trailing 12-month market average for comparable properties and subtract 8–12 percentage points for year one. New listings build gradually — you're establishing reviews, refining photos, and calibrating pricing during the first 60–90 days. Projecting market-average occupancy from month one is the most common mistake in VR investment modeling, and it's the difference between a deal that works and a deal that looked good on paper.

How do Airbnb platform fees affect my investment projections?

Airbnb charges hosts approximately 3% per booking as a host service fee, deducted from your payout. VRBO charges closer to 5% for most hosts. These come off the top before you receive anything. On a property projecting $50,000 in gross bookings, a 3% Airbnb fee is $1,500/year in revenue you'll never see. Build platform fees into your gross revenue line from the start, not as an afterthought — and if you're modeling multi-channel distribution, blend the rate based on your expected channel split.

How do I find reliable comparable rental income data for a specific market?

AirDNA and Rabbu are the most widely used tools for pulling ADR and occupancy data by zip code, bedroom count, and property type. Treat their numbers as a starting range, not a guarantee — in markets with fewer comparable properties, the data gets thin and their projections run optimistic. Always cross-check against actual Airbnb listings in the area by looking at how many calendar days established properties have blocked versus open, which gives you a rough real-world occupancy read without paying for a subscription.

Is cash-on-cash return or cap rate more important when evaluating a vacation rental?

Both serve different purposes. Cap rate tells you how the asset performs independent of financing — useful for comparing deals apples-to-apples and understanding the underlying income quality of the property. Cash-on-cash return tells you how your actual deployed capital is performing, which matters when you're deciding whether your money is better placed in this deal versus another. If you're paying cash, the two converge. If you're use, they diverge significantly — use can turn a 7% cap rate into a 14% cash-on-cash return, or into negative cash flow if you over-use into a market that softens.