STR Deal Analysis Case Study: Underwriting a Real Listing Start to Finish

A proper STR deal analysis follows a fixed sequence: confirm the market’s demand drivers, verify regulations at the exact address, estimate revenue from true comparable listings, build a complete expense stack, compute cash-on-cash return and DSCR under both management scenarios, and stress-test the assumptions before you write an offer. In this walkthrough we apply every one of those steps to a single illustrative deal—a 3-bed/2-bath single-family home in Chandler, Arizona listed at $485,000—and show all the math, including the numbers that ultimately argue against paying asking price.

One thing before we start: every number in this article—the listing, the price, the comps, the expenses—is an illustrative composite built to be realistic for the market, not a real property for sale. Use the method, not the specific figures, and verify everything against live data when you underwrite your own deal. Nothing here is a promise of returns.

The Subject Property

• Type: Single-family home, 3 bed / 2 bath, ~1,850 sq ft
• Location: Chandler, AZ (Phoenix East Valley), non-gated neighborhood
• List price: $485,000
• Condition: Move-in ready, no pool, standard backyard
• Buyer profile: Out-of-state investor, 20% down DSCR financing, deciding between self-managing remotely with a local cleaner or hiring full-service property management

Step 1: Why This Market Made the Shortlist

You never start with a house; you start with a market. Chandler made this buyer’s shortlist for reasons that show up in the revenue data rather than in marketing copy:

• Phoenix metro demand depth. The metro draws year-round leisure, sports, and family-visit travel, so demand isn’t dependent on one event or one season surviving.
• Spring training. Cactus League games across the East Valley create a February–March demand spike with premium rates—visible in every comp’s Q1 numbers.
• The Intel corridor. Chandler’s semiconductor and tech employment base (Intel’s Ocotillo campus and its supplier network) generates midweek corporate and relocation stays that smooth out the leisure calendar.
• Diversified exit. A 3/2 single-family home in Chandler is a normal family house. If STR economics change, it rents long-term or sells to an owner-occupant—the exit isn’t dependent on the STR market.

How to build a shortlist like this from scratch is its own discipline—we walk through the screening process in our market shortlisting companion piece and in the step-by-step market research guide. The short version: durable demand drivers, plural, plus a sane regulatory posture, plus an exit that doesn’t require the next buyer to be an STR investor.

Step 2: The Regulation Check Comes First

Before pulling a single comp, verify you’re legally allowed to operate. Revenue analysis on a property you can’t permit is wasted work—or worse, a deal you close and then can’t run.

Arizona is one of the friendlier states: state law generally preempts cities from banning short-term rentals outright. But preemption is not a free pass. For a Chandler address, the checklist looks like this:

• City registration/permit: Arizona cities may require STR registration, an emergency contact, liability insurance, and neighbor notification. Verify Chandler’s current requirements before offering—rules change.
• Transaction Privilege Tax (TPT): Arizona requires an STR operator to hold a TPT license. Platforms remit some taxes on your behalf in Arizona, but the license obligation is yours.
• HOA and CC&Rs: Critical—state preemption does not apply to private HOA restrictions. An HOA can prohibit STRs even where the city cannot. We check this in Step 6 as a formal red-flag pass.
• Occupancy, noise, and nuisance rules: Arizona law allows cities to act against problem properties; repeated violations can cost you the ability to operate.

Run every candidate address through our regulation checker and read the state and city summaries in the regulations library. In this case study, the subject address passes: city registration is obtainable, TPT licensing is routine, and—pending the HOA check—nothing blocks operation.

Step 3: Revenue Estimate—The Comps Method

Skip the listing agent’s “projected revenue” flyer. Build your own estimate from at least five active listings that genuinely match the subject: same bedroom count, similar bathrooms, comparable amenities, and the same micro-area. Here are the five illustrative comps used for this deal:

Notice the pattern: the pool properties (A, C, E) cluster well above the no-pool properties (B, D). Our subject has no pool, so honestly it comps closer to B and D—we underwrite at $210 ADR and 68% occupancy, which leans slightly optimistic on the assumption of superior furnishing and photography, and we flag the pool gap as both a risk and an upside lever. The math: $210 × 365 nights × 68% ≈ $52,100 gross.

Seasonality: When the Money Actually Arrives

Phoenix is an inverse-season market—winter and spring carry the year, summer craters when it’s 112°F. Annual averages hide this, and it matters for cash planning:

Q1 alone produces more than a third of annual revenue. A bad spring training season—or buying in April and missing it entirely—reshapes year one. For underwriting we round down to $52,000 gross. Cross-check your comp work against market-level data (methodology in our STR analytics guide) and sanity-check the figure with the income estimator.

Step 4: The Full Expense Stack

This is where most first-time underwriters fail—not on revenue optimism, but on missing expense lines. Here is the complete annual stack for this deal:

Financing Assumptions

• Loan: 30-year DSCR loan, 20% down, illustrative 7.25% rate
• Down payment: $97,000  |  Loan amount: $388,000
• Principal & interest: ~$2,647/month = $31,760/year
• Closing costs: ~$9,700  |  Furnishing & setup: ~$30,000
• Total cash invested: ~$136,700

Two lines deserve emphasis. First, insurance must be a short-term rental policy—a standard landlord policy can deny claims for paying guests, and platform host guarantees are not a substitute. Our STR insurance guide covers what proper coverage looks like. Second, the 5% capex reserve is real money: in Phoenix an AC compressor failure in July is a four-figure emergency that also refunds bookings.

Step 5: The Verdict Math

Cash Flow and Cash-on-Cash, Both Scenarios

Read that honestly. Self-managed, this deal roughly breaks even on cash—about $145/month of cushion on a $136,700 investment. With professional management, it loses roughly $670/month. The 1.05 DSCR means some lenders would still fund it (and note many DSCR lenders underwrite to long-term market rents, not STR projections—details in our cash flow analysis deep-dive), but a 1.05 leaves essentially no operating margin.

Five-Year Simple Projection (Self-Managed)

Assuming an illustrative 3% annual growth in both revenue and operating expenses, fixed debt service, and no refinance:

Five years of operating a business for roughly $19,000 of cumulative cash flow plus loan paydown—with any appreciation as an unpromised bonus. That’s not a catastrophe, but it’s not a margin of safety either. Growth assumptions are illustrative; revenue can also fall.

Step 6: The Red-Flag Pass

Before deciding, run the kill-list. Any one of these ends or reshapes the deal:

• HOA prohibition or minimum-lease rules. The single most common STR deal-killer in Phoenix-area subdivisions. Arizona’s state preemption does not bind private HOAs—a “30-day minimum lease” clause in the CC&Rs ends this deal regardless of city rules. Read the full CC&Rs during the inspection period, not after. Our HOA rules guide shows exactly what language to look for.
• Permit or registration surprises. Confirm no pending city rule changes, caps, or enforcement actions on the street.
• Insurance surprises. Get an actual STR policy quote during due diligence, not after closing.
• Deferred capex. A 12-year-old AC unit or original roof in Arizona converts your 5% reserve into a year-one certainty.
• Comp integrity. If the strong comps are all pool homes and yours isn’t (as here), your revenue basis is the weaker cluster unless you budget to add the amenity.

For this composite deal, assume the CC&Rs come back clean but the AC is mid-life: we’d ask for a credit or price that in.

Step 7: Sensitivity—Where This Deal Breaks

Underwriting isn’t done until you know where the deal fails. Two standard stress tests, self-managed scenario:

The breakeven sits at roughly 66% occupancy—just two points below the underwritten 68%. A soft spring training season, three new competing listings on the street, or one algorithm change eats that cushion. Strong deals survive a 10-point occupancy haircut; this one doesn’t.

Step 8: The Decision—and the Framework to Reuse

Verdict on this deal at $485,000: pass, or negotiate hard. The composite numbers say this is a fine house priced for an owner-occupant, not an STR investor. What could change the answer:

1. Price. At roughly $455,000–$460,000, debt service drops by ~$1,600–$2,000/year and cash-on-cash improves—still thin, but the margin of safety widens.
2. Revenue. Adding the pool the comps are screaming about (call it $60,000–$75,000 installed) could plausibly move the property toward the $56,000–$58,000 comp cluster—model it as a separate project with its own return, never as a certainty.
3. Different property. Often the honest conclusion. The process exists to make you walk away cheaply, on paper, instead of expensively, at closing.

The reusable framework: market → regulations → comp-based revenue → full expense stack → cash-on-cash + DSCR both scenarios → red-flag pass → sensitivity → decide. For the theory behind each step, read our companions on how to analyze an STR deal and STR cash flow analysis. Then run your own numbers in the ROI calculator—and if Arizona is your target market, get matched with an AZ STR-specialized agent who underwrites like this every week.

Frequently Asked Questions

How do you analyze an Airbnb property before buying?

Follow a fixed sequence: confirm the market’s demand drivers, verify regulations at the specific address, estimate revenue from five or more true comps, build a complete expense stack (mortgage, STR insurance, utilities, supplies, software, taxes, capex reserve, and management), compute cash-on-cash and DSCR under both self-managed and property-managed scenarios, then stress-test with lower occupancy and ADR. If the deal only works under best-case assumptions, it’s not a deal—that’s the entire lesson of this case study.

What is a good cash-on-cash return for a short-term rental?

Many investors target roughly 8–15% in year one, but the right threshold depends on your market, financing, risk tolerance, and how much weight you give appreciation and tax benefits. Our subject property produced ~1.3% self-managed at asking price—a clear signal to renegotiate, add revenue, or pass. Treat any target as a screening filter, not a promised outcome; returns are never guaranteed.

How do you estimate Airbnb revenue for a property you don’t own yet?

Use the comps method: at least five active listings matching your subject on bedrooms, bathrooms, amenities, and micro-location. Record each comp’s ADR and occupancy, underwrite at or below the median—never at the best performer—and build a quarterly seasonality table so you know when cash actually arrives. Cross-check against market-level data using the approach in our STR analytics guide, and sanity-check with the income estimator.

What expenses do Airbnb hosts forget when underwriting?

The usual suspects: a genuine STR insurance policy instead of a landlord policy, a ~5% capex reserve, software subscriptions, guest-paid-utilities that are actually owner-paid, pool/landscaping service, supplies, and lodging taxes where platforms don’t remit. The biggest omission is property management at 15–25% of gross—which in our case study was the difference between marginally positive and clearly negative cash flow.

What DSCR do lenders require for a short-term rental loan?

Most DSCR lenders look for roughly 1.0–1.2 or better. Our case-study deal penciled at 1.05—fundable with some lenders, but with almost no operating cushion. Also note that many DSCR programs qualify the property on long-term market rents rather than projected STR income, so the lender’s ratio and your operating reality can diverge in either direction.

Are short-term rentals legal in Chandler, Arizona?

Arizona state law generally prevents cities from banning STRs outright, but Chandler can require registration, emergency contacts, insurance, and neighbor notification, and operators need an Arizona TPT license. Crucially, HOA and CC&R restrictions are private contracts that state preemption does not touch—an HOA can prohibit STRs even where the city allows them. Verify current rules for the exact address in our regulations library and with the regulation checker before writing an offer.