Airbnb Investment Analysis: 13200 Excelsior Boulevard, Hopkins, MN

Weak · financed

Priced too high to cash-flow with a loan — an equity or tax play, not income.

13200 Excelsior Boulevard

Hopkins, MN

3bd · 2ba · 8 guests

Purchase price

Est. monthly payment$2,495/mo

Break-even price$339.1K

Vs 3 comps nearby#2 of 4

$19.1K$75.7K

Connect with a local STR agent

Investment potential

Your scenario · adjust the levers below or open advanced settings to see how returns change

Projected annual revenue

$42,248

$3,521/mo · at 69% occupancy & $227/night

Cash-flow negative

-$9,633

-$803/mo after costs & mortgage

Cap rate

4.1%

Cash-on-cash

-6.4%

DSCR

0.68

Confidence

45%

Your assumptions

Revenue

$42,248/yr

Market avg: $42,248/yr · 69% occ · $227 ADR

Occupancy

mkt

Avg daily rate

mkt

Days available

Financing

$29,939/yr

Down payment

Interest rate

Mortgage term

Operating costs

$21,942/yr

Property management

Airbnb fee

Property tax

Insurance

Utilities

Market Context

How this property compares to similar short-term rentals nearby.

Comparable set · 3 properties

Daily rate

$115–$326

Median $240

Occupancy

55%–83%

Median 68%

Annual revenue

$19.1K–$75.7K

Median $31.9K

Days available

196–331

Median 225

Revenue floor · $19.1KTop performer · $75.7K

This property · $42.2K

Comparable properties (3)

Cash flow potential Low · Appreciation potential Medium

RevenueOccupancyDaily rate

Gorgeous Modern 3 Bed Home by Lake Mtka and WayzataTop performer

331 days available · 225 days booked ·

Annual revenue

$75,719

Occupancy

68%

Daily rate

$326

Minnetonka by I-394 and I-494--spectacular acre

225 days available · 124 days booked ·

Annual revenue

$31,929

Occupancy

55%

Daily rate

$240

Open Floor Plan, Smart TV and Parking

196 days available · 163 days booked ·

Annual revenue

$19,095

Occupancy

83%

Daily rate

$115

Revenue and occupancy reflect Chalet's modeled estimates from observed booking activity for comparable active listings. Individual results vary with management, seasonality, and pricing.

Who this property is for

Three ways this deal works — and who each one fits

The same property is a great buy for one investor and a trap for another. Here's the honest read.

Best fit

1031 / high-equity buyer

~$123.5K

Year-1 tax shield

Buying with cash or low leverage removes the debt-coverage problem entirely, so the thesis rests on appreciation plus a large first-year write-off. At roughly 25% of purchase price, the shield is substantial enough to carry the deal on its own.

Not a fit

Price-disciplined buyer

$339.1K

Break-even purchase price

Break-even is ~32% below the Zestimate, a discount sellers in Hopkins rarely accept. Treat the number as a walk-away line rather than an opening offer.

Not a fit

DSCR cash-flow buyer

0.68

DSCR at asking

At asking price the property doesn't cover its own debt service, so it won't qualify for DSCR financing as modeled. If you need cash flow from day one, look at a mid-term-rental fallback or a different Hopkins submarket.

Year-one tax shield estimate

For a buyer who materially participates and qualifies for the STR tax treatment.

$123.5K

Estimated first-year deduction · range $102.5K–$140.8K

Purchase price: $500,000
Land allocation (excluded): −$175,000
Depreciable basis: $325,000
Cost-seg accelerated: $97,500
+ Bonus depreciation & furnishings: $26,000

Why this matters here

At a marginal bracket, this deduction can be worth $37.9K–$52.1K in estimated federal tax saved.

This only applies if you meet the IRS material-participation tests for short-term rentals and are not using a full-service property manager.

Estimate, subject to CPA review. Cost-segregation percentages shown here are illustrative and depend on an actual study of the property.

Some states do not conform to federal bonus depreciation, so your state may not allow the same first-year treatment shown above.

Chalet can introduce a cost-segregation partner — this is not tax, legal, or financial advice.

Price sensitivity & break-even

How cash-on-cash return moves with purchase price. The marked line is break-even (1.0 DSCR).

Purchase price$500,000 (+0.0% vs asking)

At this price: cash-on-cash -6.4%, DSCR 0.68, cash flow -$9,633/yr

Cash-on-cash return by purchase price
Price vs asking	Price	Cash-on-cash	DSCR	Band
-25%	$375,000	-1.8%	0.90	Below break-even
-22%	$390,000	-2.5%	0.87	Below break-even
-15%	$425,000	-3.9%	0.80	Below break-even
-8%	$460,000	-5.2%	0.74	Below break-even
Asking	$500,000	-6.4%	0.68	Below break-even
+8%	$540,000	-7.5%	0.63	Below break-even
+15%	$575,000	-8.3%	0.59	Below break-even

Below break-evenAt break-evenPositive

Break-even price

$339,123

~32% under Zestimate. Where this property reaches 1.0 DSCR and neutral cash flow.

Discount needed

−$160,877

The gap between asking and the price a cash-flow buyer can underwrite.

If refi to 5.5% in 24 mo

+$4,388/yr

Illustrative cash-flow improvement at asking price if rates fall. Planning figure, not a forecast.

Gross revenue$42,248

Booking & management fees−$5,492

Airbnb fee (3%)$1,267

Property mgmt (10%)$4,225

Net revenue

$36,756

Property operating costs−$16,450

Insurance, utilities & maintenance$11,450

Property tax (est.)$5,000

Net operating income (NOI)Before mortgage · 48% margin

$20,306

Debt service (mortgage)−$29,939

Annual cash flow−$9,633

−$803/mo after all expenses

Cash to close

Down payment, closing costs, and furnishing

$145,000

Return on cash:10.6%

Down payment

25% of purchase price

$125,000

Closing costs

1% of purchase price

$5,000

Furnishing budget

3BR · est. 3% of purchase price

$15,000

DSCR below 1.0 — but you can still qualify

Your DSCR is 0.68 · lenders typically require 1.0+.

01.0 threshold2.0+

Get matched with 2–3 vetted STR lenders, free.

Return & exit scenario

What the deal returns over the hold — including the tax shield, which is the whole point for an appreciation buyer.

Levered IRR

12.9%

over 5-yr hold, with tax shield

Equity multiple

1.7×

total proceeds vs. $145,000 invested

Projected value at exit

$638,141

year 5 · 5.0% annual appreciation

Tax shield contribution

+6.4 pts

of IRR comes from year-1 depreciation

Equity builtAppreciationCumulative cash flow (netted into total)

Projected investment value by year
Year	Equity	Appreciation	Cumulative cash flow	Total value
Year 1	$128,809	$25,000	$36,062	$189,871
Year 2	$132,894	$51,250	$27,063	$211,207
Year 3	$137,274	$78,813	$18,707	$234,793
Year 4	$141,970	$107,753	$11,003	$260,727
Year 5	$147,007	$138,141	$3,963	$289,110

Projection, not a promise.

Assumes 5.0% annual appreciation, 1.5% rent growth (operating costs held flat), and that the property qualifies for short-term-rental tax treatment. The year-1 depreciation shield depends on a real cost-segregation study and your tax situation — consult a CPA.

Appreciation is the dominant driver of this return. When cash flow is negative, the deal depends on the property gaining value — it is not paying for itself from income.

Appreciation, rent growth, and financing rates are editable under Edit financials.

Get a Hopkins STR agent who understands this deal.

STR deals turn on local rules and demand that a generalist agent misses. Chalet matches you with a vetted Hopkins agent who knows which properties actually cash flow — and which to avoid.

Vetted STR specialistsFree to investorsNo obligation

Popular Airbnb Investment Opportunities Near This Property (Analyzed by Chalet Users)

13200 Excelsior Boulevard, Minnetonka, MN, USA

3 bed 2 bath 8 guests

Revenue

$45,925/yr

Daily Rate

$242

Occupancy

0.6%

3925 France Avenue South, Minneapolis, MN, USA

4 bed 2 bath 10 guests

Revenue

$58,713/yr

5217 Washburn Ave S, Minneapolis, MN 55410, USA

5 bed 2 bath 12 guests

Revenue

$70,156/yr

5901 Washburn Ave S, Minneapolis, MN 55410, USA

3 bed 2 bath 8 guests

Revenue

$54,759/yr

2814 W 41st St, Minneapolis, MN 55410, USA

3 bed 1 bath 8 guests

Revenue

$42,129/yr

5645 Vincent Ave S, Minneapolis, MN 55410, USA

5 bed 2 bath 12 guests

Revenue

$70,156/yr

Disclaimer. This page and the data presented are for informational purposes only. The information provided should not be construed as financial, legal, or investment advice. Market conditions can change rapidly, and past performance does not guarantee future results. Always consult with qualified professionals before making investment decisions.

TOOLS & CALCULATORS

LEARNING & RESOURCES

SERVICES & PARTNERS

MARKET INSIGHTS

Three ways this deal works — and who each one fits

Year-one tax shield estimate

Price sensitivity & break-even

Return & exit scenario

Get a Hopkins STR agent who understands this deal.

Popular Airbnb Investment Opportunities Near This Property (Analyzed by Chalet Users)

Popular Airbnb Investment Opportunities Near This Property (Analyzed by Chalet Users)