The difference between a good micro resort investment and a money pit comes down to one skill: underwriting. Not gut feelings, not excitement about the property, not how beautiful the listing photos are. The numbers either work or they do not.
After acquiring $9M in hospitality assets, I have refined this underwriting framework through real deals, real mistakes, and real returns. This is the same framework our community of 200+ STR investors uses inside the Incredible Hospitality Mastermind to evaluate micro resort and boutique hotel acquisitions.
Whether you are analyzing your first deal or your tenth, this guide walks you through every metric, every step of the pro forma, and the red flags that should stop you cold.
The Key Metrics You Need to Know
Before you can analyze a deal, you need to speak the language. Here are the metrics that matter in hospitality underwriting, along with the targets we use for micro resort acquisitions in the $2M to $5M range.
| Metric | What It Measures | Target |
|---|---|---|
| ADR (Average Daily Rate) | Average rental income per paid occupied room per day | Market-dependent; validate with CoStar |
| Occupancy Rate | Percentage of available rooms sold | 60-75% for stabilized boutique properties |
| RevPAR (Revenue Per Available Room) | Total room revenue / total available rooms | 10+ years of growth in target market |
| NOI (Net Operating Income) | Revenue minus operating expenses (before debt) | Must be positive from day one |
| Cap Rate | NOI / Property Value | 8-8.5% entry; 7-7.5% exit |
| Cash-on-Cash (CoC) | Annual cash flow / total cash invested | 15%+ |
| DSCR (Debt Service Coverage Ratio) | NOI / annual debt service | 1.35x or higher |
| IRR (Internal Rate of Return) | Annualized total return including appreciation | 18%+ over 5-7 years |
| LTV (Loan-to-Value) | Loan amount as percentage of property value | 70% |
These are not abstract concepts. Each one tells you something specific about whether a deal will generate the returns you need while maintaining a margin of safety.
Step 1: Revenue Modeling
Revenue is the foundation of every hospitality underwriting model. Get this wrong and nothing downstream will be accurate.
The Revenue Formula
Total Room Revenue = ADR x Occupancy Rate x Room Count x 365
Start by establishing the property's current performance. Request at least 2 years (ideally 3) of monthly P&L statements from the seller. You want to see:
- Monthly ADR trends (is it growing, flat, or declining?)
- Monthly occupancy (are there seasonal patterns?)
- Revenue by channel (what percentage comes from OTAs vs. direct bookings?)
- Ancillary revenue (event space, food and beverage, activities, retail)
Then validate the seller's numbers against market data. CoStar is the gold standard here. Pull RevPAR trends, ADR benchmarks, and occupancy rates for the submarket. If the seller claims a $200 ADR but CoStar shows the submarket averaging $140, you have a gap that needs explaining.
Pro Tip
Underwrite to market averages for your base case, not the seller's claimed performance. If you can beat market averages through better operations, that upside is your margin of safety, not your assumption.
Projecting Revenue After Acquisition
For your pro forma, model three scenarios:
- Conservative: Current performance continues as-is. No improvements.
- Base case: Moderate operational improvements (better revenue management, channel optimization, direct booking push) lift ADR by 5-10% and occupancy by 3-5 points within 12 months.
- Upside: Full value-add execution (renovations, rebranding, unit additions) achieves stabilized performance within 18-24 months.
Your purchase decision should be based on the conservative case. If the deal only works in the upside scenario, it is too risky.
Step 2: Expense Analysis
Expenses in hospitality are higher and more complex than in residential real estate. Typical operating expenses for a small boutique hotel or micro resort run between 55% and 65% of gross revenue.
Major Expense Categories
| Category | Typical Range (% of Revenue) | Notes |
|---|---|---|
| Labor / Staffing | 25-35% | Largest single expense; varies by service level |
| Property Management | 5-8% | Third-party; model at 7% (or capture this yourself) |
| OTA Commissions | 8-15% | Booking.com, Expedia, Airbnb take 15-20% per booking |
| Utilities | 4-6% | Higher for resorts with pools, hot tubs, laundry |
| Insurance | 3-5% | Commercial hospitality policies are expensive |
| Property Taxes | 2-4% | Verify reassessment risk at acquisition |
| Maintenance / FF&E Reserve | 4-6% | Budget 4% minimum for furniture, fixtures, equipment |
| Marketing | 3-5% | Direct booking strategy reduces OTA dependency over time |
One of the biggest value-add levers in micro resort acquisitions is bringing property management in-house. If you model a 7% PM fee paid to yourself instead of a third party, you capture that revenue and boost your cash-on-cash return significantly.
"Boost CoC by bringing property management in-house, capturing ~7% of gross revenue. Underwrite as a PM fee to yourself, not an asset-management fee."
Step 3: Calculate NOI
NOI = Total Revenue - Total Operating Expenses
This is the number that drives everything: your property valuation (via cap rate), your debt capacity (via DSCR), and your cash flow (NOI minus debt service).
For a first deal, we require day-one positive NOI. No speculative ground-up builds. No properties that only work "once we renovate." The property must cash flow from the day you close.
Current NOI vs. Stabilized NOI
The gap between current NOI and stabilized NOI is where your value-add opportunity lives. This is the core investment thesis for micro resort acquisitions:
"Buy poorly operated assets to unlock NOI quickly."
If a property is generating $200k in NOI under current management, but your underwriting shows it should be generating $320k with basic operational improvements (dynamic pricing, reduced OTA dependency, better staffing), that $120k gap is your value creation opportunity. At a 7.5% exit cap rate, that NOI increase translates to $1.6M in additional property value.
Step 4: Valuation and Cap Rate Analysis
In hospitality, properties are valued based on their income, not comparable sales. The formula:
Property Value = NOI / Cap Rate
For acquisitions, we target an entry cap rate of 8 to 8.5%. This means a property generating $280k in NOI would be valued at $3.3M to $3.5M.
On exit (after value-add improvements), model a compressed cap rate of 7 to 7.5%. The compression happens because a stabilized, well-operated property commands a premium from buyers. Using the example above, if you stabilize NOI to $380k and exit at a 7% cap rate, the property is now worth $5.4M.
Step 5: Debt Service and Cash Flow
Once you have NOI, layer in your financing to calculate actual cash flow:
Annual Cash Flow = NOI - Annual Debt Service
For a typical deal structure at 70% LTV:
| Line Item | Amount |
|---|---|
| Purchase Price | $3,500,000 |
| Loan Amount (70% LTV) | $2,450,000 |
| Equity Required (30%) | $1,050,000 |
| Interest Rate | 6.5% |
| Amortization | 25 years |
| Annual Debt Service | ~$198,000 |
| Day-One NOI | $280,000 |
| Annual Cash Flow | $82,000 |
| DSCR | 1.41x |
| Cash-on-Cash Return | 7.8% (day one) |
After value-add (stabilized NOI of $380k), annual cash flow jumps to $182k, pushing cash-on-cash above 15%. That is the trajectory we underwrite for.
For a deeper look at financing options, including DSCR loans, SBA 7(a) loans, and seller financing, read our financing guides.
Step 6: Model the Exit
Every deal should have a clear exit strategy modeled from day one. We think through multiple exit scenarios:
- Sale in Year 5: Stabilized NOI / exit cap rate = sale price. Subtract remaining loan balance and transaction costs. The difference is your equity created.
- Refinance in Year 3: If the property appreciates significantly, refinance to pull out equity while keeping the asset. This is a tax-deferred way to access your gains.
- Hold and cash flow: If the market does not support a favorable sale, can you hold the asset indefinitely on its cash flow? The DSCR should be strong enough to support this.
Using our $3.5M example: stabilized NOI of $380k at a 7% exit cap in Year 5 yields a value of $5.4M. After paying off the remaining loan balance (approximately $2.2M after 5 years of amortization), you have roughly $3.2M in proceeds, representing approximately $1.2M in equity created above your original investment.
The Quick Underwriting Sheet
Before committing hours to a full pro forma, run every deal through this quick screening checklist. If it passes, do the deep dive. If it fails, move on.
- Does it have day-one positive NOI? If no, pass.
- Is the asking price at or below 8% cap rate on current NOI? If significantly above, negotiate or pass.
- Does the submarket show 10+ years of RevPAR growth? If declining, pass.
- Can you identify at least 2 clear value-add levers? If not, the upside is limited.
- Does DSCR exceed 1.25x on day-one NOI? If not, the deal will be hard to finance.
- Is the property in a non-seasonal, drive-to market? Seasonal cash flow swings increase risk.
This 60-second screen eliminates 80% of deals that would have wasted your time in a full analysis. Use it before opening your spreadsheet.
Red Flags to Watch For
After reviewing hundreds of deals across our community, these are the patterns that should raise immediate concern:
- Declining RevPAR over 3+ years. A market or property losing momentum is fighting against you.
- Deferred maintenance exceeding 10% of purchase price. A property needing $400k in repairs on a $3M purchase eats your equity before you start.
- Single-source revenue dependency. If 70%+ of bookings come from one OTA or one corporate account, you have concentration risk.
- Environmental issues. Underground storage tanks, flood zones, contamination. These can be deal-killers with lenders.
- Seller cannot provide clean financials. If they do not have 2+ years of organized P&L statements, their actual performance is likely worse than what they are representing.
- Zoning restrictions that limit value-add. If you planned to add units or change use, verify zoning first.
- Unrealistic ADR assumptions. Always benchmark against CoStar. A property claiming $250 ADR in a $150 market needs serious scrutiny.
Sample Deal Walkthrough
Let us walk through a real example using the framework. This is based on a deal structure from our community.
The Property
A 10-room boutique hotel in an affluent secondary market, 90 minutes from a major metro. Currently owner-operated with dated interiors and limited online presence. Listed at $3.5M.
Current Performance
- ADR: $175
- Occupancy: 55%
- RevPAR: $96.25
- Gross Revenue: $351,000 (10 rooms x $175 x 55% x 365)
- Operating Expenses: 60% of revenue = $210,600
- Current NOI: $140,400
- Current Cap Rate at $3.5M asking: 4.0% (too high a price for this NOI)
The Negotiation
At $140k NOI, this property is worth $1.65M at an 8.5% cap rate. The $3.5M ask is way off. But you dig deeper and find that CoStar shows the submarket ADR at $210 with 68% occupancy. The current owner is underperforming because of poor revenue management and no direct booking strategy.
Stabilized Projection (Base Case, 12-18 Months)
- ADR: $200 (moderate improvement, still below market)
- Occupancy: 65%
- Gross Revenue: $474,500
- Operating Expenses: 58% = $275,210
- Stabilized NOI: $199,290
Now negotiate based on a blended analysis. Offer $2.35M (current NOI at 6% cap, giving the seller some credit for the upside). If accepted, your numbers improve dramatically. Add 4 casitas if zoning allows (at $25k NOI per unit), and your stabilized NOI jumps to $299k, yielding a $4.3M valuation at a 7% exit cap.
This is the kind of deal analysis work we do every Thursday in our live deal review calls inside the Mastermind. Real numbers, real properties, real feedback from operators who have closed these deals.
Your Underwriting Toolkit
You need three things to underwrite effectively:
- A reliable underwriting model. A spreadsheet-based pro forma that models revenue, expenses, debt, and exit scenarios. We provide this inside the 5-Day Micro Resort Buyer Challenge.
- CoStar access. This is the primary data source for RevPAR trends, ADR benchmarks, and market-level performance. Your underwriting credibility, and your ability to raise capital, depends on professional data.
- An experienced underwriter to review your work. For your first 3 to 5 deals, have someone experienced pressure-test your assumptions. Wrong inputs produce confident but dangerous conclusions.
Frequently Asked Questions
What metrics do I need to underwrite a micro resort deal?
The core metrics are RevPAR (Revenue Per Available Room), ADR (Average Daily Rate), occupancy rate, NOI (Net Operating Income), cap rate, cash-on-cash return, and DSCR (Debt Service Coverage Ratio). Together, these tell you how much the property earns, what it is worth, and whether it can service debt while generating returns.
What is a good cap rate for a micro resort?
For acquisitions, target an 8 to 8.5% entry cap rate. This provides enough spread above your debt cost to generate cash flow from day one. On exit (after value-add improvements), you can model a compressed cap rate of 7 to 7.5%, which creates equity through appreciation.
How do I build a pro forma for a hotel acquisition?
Start with revenue modeling using ADR multiplied by occupancy multiplied by room count multiplied by 365 days. Then subtract operating expenses (typically 55 to 65% of revenue for small hotels). The result is your projected NOI. Layer in your debt service to calculate cash flow, then divide by your equity investment for cash-on-cash return.
What DSCR do lenders require for hotel loans?
Most lenders require a minimum DSCR of 1.25x, meaning the property's NOI must be at least 1.25 times the annual debt service. For conservative underwriting and stronger loan terms, target 1.35x or higher. DSCR loans are particularly valuable because they qualify on the property's income rather than your personal W-2.
What are the biggest red flags in hotel deal analysis?
Key red flags include declining RevPAR trends over 3+ years, deferred maintenance exceeding 10% of purchase price, single-source revenue dependency (one OTA channel or one corporate account), environmental issues, zoning restrictions that limit value-add plans, and a seller who cannot provide at least 2 years of clean financial statements.