BNBCalc Short Term Rental Investment Analysis 40 Northrup Ave, Excelsior, MN, 55331

4 bed • 3.5 bath • 12 guests • $693,800

BNB

Calc

Annual Revenue

$109,018

Profit (Cash Flow)

$74,297

Cap Rate

11.7%

Annual Revenue

$109,018

AirDNA projects $745/night at 55% occupancy ($149,658). Airbtics projects $533/night at 56% occupancy ($109,018). Airbtics predicts this property will perform in the 47% revenue percentile

BNB Calc projects a 56% occupancy rate, $533 rate per night.

Revenue Percentile (property's earnings compare to others in the market}

Percentiles	25%	50%	75%	90%
Revenue	$48,293	$86,432	$174,470	$337,595
Occupancy	43%	54%	63%	88%
Nightly Rate	$302	$431	$743	$1,028

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Excelsior Nautical Themed Home, with Fenced Yard!	$51,280	$255	52%	4	2	28	$250	❌	❌	✅	Y / Y	⭐️ 5 (63)
Getaway on Lake Minnetonka	$136,791	$1,194	31%	4	2.5	2	$200	❌	❌	❌	Y / Y	⭐️ 5 (19)
Downtown Excelsior Dream Home!	$110,431	$483	62%	4	2	28	$250	❌	❌	✅	Y / Y	⭐️ 5 (13)
Cedar House Retreat	$81,784	$372	58%	4	4	2	$350	❌	❌	❌	Y / Y	⭐️ 5 (89)
Designer Rental in Excelsior - walk to everything!	$97,822	$472	56%	4	2	3	$300	❌	❌	✅	Y / Y	⭐️ 4.8 (41)
Crystal Bay Getaway - Lake Minnetonka	$148,299	$897	44%	4	3	2	$350	❌	❌	❌	Y / Y	⭐️ 5 (26)
Lakefront Lodge Home sleeps 10 by Prince Museum	$147,961	$1,137	32%	4	3	2	$350	❌	❌	❌	Y / Y	⭐️ 0 (0)
Heavenly Home/Minnetonka Lakes/Nature Scenic View	$60,266	$199	81%	4	2	2	$210	❌	❌	✅	Y / Y	⭐️ 5 (79)
Lovely renovated home close to Lake Minnetonka	$51,775	$273	49%	4	2	2	$175	❌	❌	✅	Y / Y	⭐️ 5 (69)
Unique Excelsior Home! Location Location Location!	$63,605	$237	71%	4	2	28	$250	❌	❌	✅	Y / Y	⭐️ 5 (37)
MINNeSTAY* Lakefront Luxury \| Waterfront	$221,514	$1,028	56%	4	4.5	2	$329	❌	❌	❌	Y / Y	⭐️ 5 (38)
MINNeSTAY* Creekside Lodge \| Nature	$90,818	$338	66%	4	3	2	$319	❌	❌	❌	Y / Y	⭐️ 5 (22)
Spacious Forest Retreat + Pool Near Lk Minnetonka	$170,346	$569	79%	4	3.5	2	$265	✅	❌	❌	Y / Y	⭐️ 5 (23)
16+Wayzata home! Central, Comfortable, Peaceful.	$73,279	$334	56%	4	3	2	$265	❌	❌	✅	Y / Y	⭐️ 5 (34)
Stunning 1 Acre Farmhouse Great Lake Location	$61,971	$262	63%	4	2.5	2	$231	❌	❌	❌	Y / Y	⭐️ 4.5 (101)
Spacious Home w/Lake Access	$76,614	$380	54%	4	2.5	2	$250	❌	❌	✅	Y / Y	⭐️ 4.5 (12)
The Luxury Lake Minnetonka Home	$132,002	$904	38%	4	3	3	$600	❌	✅	❌	Y / Y	⭐️ 5 (2)
Downtown Wayzata just a short walk to coffee shop	$91,686	$487	51%	4	3.5	2	$195	❌	❌	✅	Y / Y	⭐️ 5 (146)
Private home close to Lake Minnetonka	$57,432	$396	39%	4	2.5	3	$200	❌	❌	✅	Y / Y	⭐️ 5 (81)
The Green House. Walkable to everything.	$83,656	$401	57%	4	3.5	2	$0	❌	❌	✅	Y / Y	⭐️ 5 (20)
Casita Excelsior	$78,704	$224	96%	4	2	2	$0	❌	❌	✅	Y / Y	⭐️ 5 (14)
Nature's Blissful Haven - King Bed, Outdoor Patio	$42,504	$237	49%	4	2	2	$0	❌	❌	❌	Y / Y	⭐️ 5 (18)
Eden Prairie Escape *spacious home, quiet and safe	$102,281	$461	60%	4	4	3	$198	❌	❌	❌	Y / Y	⭐️ 5 (59)
Lake Minnetonka Home w/ Retreat Feel & Boat Dock	$40,508	$318	31%	4	4	4	$375	❌	✅	✅	Y / Y	⭐️ 5 (52)
The Lake House	$131,820	$830	43%	4	2.5	2	$300	❌	❌	✅	N / N	⭐️ 5 (41)
Contemporary modern home near the lake and shops	$198,092	$530	100%	4	4.5	4	$200	❌	❌	✅	Y / Y	⭐️ 4.5 (5)
Best side of lake for sunsets!	$69,540	$500	38%	4	3	2	$0	❌	✅	❌	Y / N	⭐️ 0 (5)
Plymouth Wayzata \| Peaceful Lake Retreat \| Quiet	$59,380	$312	52%	4	2	2	$0	❌	❌	❌	Y / Y	⭐️ 5 (9)
Entire Home In Chanhassen	$51,307	$326	43%	4	3.5	1	$0	❌	❌	✅	Y / Y	⭐️ 5 (16)
Waterfront Mound Retreat w/ Dock & Lake Access!	$58,253	$173	92%	4	2.5	30	$238	❌	❌	❌	Y / Y	⭐️ 5 (10)
Modern Wayzata Home With Large Private Pool	$206,964	$1,032	54%	4	4.5	3	$500	✅	❌	❌	Y / Y	⭐️ 5 (18)
Excelsior Bay Retreat \| Walkable Downtown & Beach	$234,201	$714	88%	4	3.5	2	$350	❌	❌	❌	Y / Y	⭐️ 5 (20)
Family-Friendly Home w/Kid Suite	$86,717	$254	90%	4	3	2	$200	❌	❌	✅	Y / Y	⭐️ 4 (4)
Spacious Retreat in the Midwest	$41,724	$190	60%	4	2.5	30	$165	❌	❌	❌	Y / Y	⭐️ 0 (1)
Spacious Chanhassen Vacation Rental w/ Lake Access	$96,054	$486	54%	4	3	3	$0	❌	✅	❌	Y / Y	⭐️ 3.8 (5)
Super Bowl Get Away	$164,844	$863	52%	4	2.5	3	$100	❌	✅	❌	Y / Y	⭐️ 0 (1)
The LUXE on Lake Minnetonka	$48,089	$1,314	10%	4	4.5	2	$0	❌	❌	❌	Y / Y	⭐️ 0 (0)
Executive Estate in Eden \| High-End & Relaxing	$98,657	$599	45%	4	4.5	1	$0	✅	❌	❌	Y / Y	⭐️ 0 (1)
Manuela Haus	$119,151	$383	85%	4	2.5	2	$0	❌	❌	✅	Y / Y	⭐️ 5 (3)
Minnetonka Custom Designed Home w/ Deck & Hot Tub!	$46,867	$985	13%	4	4	3	$0	❌	✅	✅	Y / Y	⭐️ 0 (0)

Return Metrics

10.29% cash on cash return is a good return over the next 1 year

Investment Value Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	$74,297	$148,594	$222,891	$297,188	$371,485	$742,970	$2,228,911
Revenue Appreciation	$365	$730	$1,095	$1,460	$1,826	$3,652	$10,957
Home Equity	$0	$0	$0	$0	$0	$0	$0
Down Payment	$693,800	$693,800	$693,800	$693,800	$693,800	$693,800	$693,800
Property Appreciation	$20,814	$42,252	$64,333	$87,078	$110,504	$238,609	$990,234
Total Return	$NaN	$NaN	$NaN	$NaN	$NaN	$NaN	$NaN

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

10.29%

Cap Rate

11.69%

Return on Investment

13.16%

40 Northrup Ave Excelsior, Minnesota, 55331

4 bed • 3.5 bath • 12 guests

Purchase Price

Est. $3,328/mo

Inquire about this property

Contact Agent

$693,800

Zestimate

126

Airbnb Investor Score

$74,297

Annual Profit

11.7%

Cap Rate

10.3%

Cash on Cash

$109,018

Annual Revenue

BNBCalc predicts this property will get $533 per night with 56% occupancy, putting it in the top 47% revenue percentile compared to similar properties nearby.

Occupancy Rate

Top 46% of comparables

Avg Daily Rate

Top 33% of comparables

Seasonality

40 Airbnb Comparables

Adjust the filters to identify similar listings to yours. Then adjust your annual revenue estimate accordingly.

$99,624

Avg annual revenue

56%

Avg occupancy rate

$533

Avg nightly rate

🏊‍♂️ Pool

🛁 Hot tub

🐶 Pet friendly

Any type

House

Apartment

Any min stay

Weekly min

Monthly min

4.8+ stars

Revenue per year

$40k

$105k

$165k

$235k

$74,297

Profit

Revenue

$109,018

Operating Expenses

$27,852

Operating Income

$81,166

Mortgage & Taxes

$6,869

Profit (Cash Flow)

$74,297

$704,675

Cash Investment

Down Payment

$693,800

Renos & Furnishing

$10,875

Total

$704,675

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

10.29%

Cap Rate

11.69%

Return on Investment

13.16%

STR Tax Calculator (USA)

On purchasing a large business asset, you can subtract the depreciation value from your taxable income in order to pay less income tax. Use this calculator to find out how much you can save. Read tax guide.

Your current annual income

Your income tax rate

Taxes paid on $150,000

$45,000

If you buy this investment property, your est deduction will be...

Deductible mortgage interest

Deductible property tax

$6,869

Your total deduction

$2,942

Your adjusted annual income

$150,000 - $2,942 = $147,058

Taxes on $147,058 (30%)

$44,117

Your old tax bill

$45,000

Your new tax bill

$44,117

Estimated tax savings

$883

Maximize the depreciation value on your tax returns. Get $50 off cost segregation reports with code BNBCALC at DIYCostSeg.com

Property Overview

View property info, current ownership, recently sold comps, school zone ratings, area rents, and more.

Lot size:

0.74 sqft

Year built:

1942

Size:

2,292 sqft

Type:

SINGLE_FAMILY

Parking:

Heating:

Forced air, Gas

Sold Comparables

Address	Beds	Baths	Square Feet	$/SqFt	Lot Size	Year Built	Last Sale	Days on Market
6085 Riviera Ln	4	3	2,260	$287	1.25	-	-	-
24885 Glen Rd	4	3	2,212	$273	0.92	-	-	-
5325 Lee Cir	4	3	2,438	$262	0.86	-	-	-
5665 Echo Rd	3	2	1,860	$317	0.26	-	-	-
5371 Manitou Rd	4	2	2,268	$228	0.79	-	-	-

Property Details

MLS Status: N/A

Property Use: SINGLE_FAMILY

Stories: -

Lot size: 0.74 sqft

Building area: 2,292 sqft

Garage: No

Heating: Forced air, gas

Pool: No

Fireplaces: -

Basement: Yes

Cooling: Central

View: Water

Parking: Garage - Attached, Garage - Detached, Off-street

Amenities: Dishwasher, Dryer, Freezer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer

Price per square foot: $302

Lot Info

Zoning: -

Land Use: -

Parcel Number: -

Flood Zone: No

Tax Info

Year Assessed:

Assessed Value: -

County Est. Land Value: -

Assessed Land Value: -

County Est. Structure Value: -

Market Estimate: $693,800

Schools

Middle School: Minnetonka West Middle School with 8/10 star rating
High School: Minnetonka Senior High School with 10/10 star rating