BNBCalc Short Term Rental Rental Arbitrage Analysis 13845 Underclift Street Northwest, Andover, MN

4 bed • 2 bath • 12 guests • $2,610

BNB

Calc

Annual Revenue

$65,072

Profit (Cash Flow)

$7,745

Cash on Cash Return

242.0%

Annual Revenue

$65,072

AirDNA projects $275/night at 52% occupancy ($52,229). Airbtics projects $297/night at 65% occupancy ($70,510). Airbtics predicts this property will perform in the 49% revenue percentile

BNB Calc projects a 68% occupancy rate, $262 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$44,322	$65,191	$93,390	$135,481
Occupancy	59%	67%	75%	81%
Nightly Rate	$199	$259	$330	$440

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
The Castle House	$80,436	$269	81%	4	2	3	$90	❌	❌	✅	Y / Y	⭐️ 5 (56)
Game Room \| Theatre Room \| Fire Pit \| Sleeps 16	$106,844	$348	82%	4	4	3	$235	❌	❌	❌	Y / Y	⭐️ 4.8 (32)
Lake Retreat \| Hot Tub \|Pool Table \| Peaceful\| Fun	$47,717	$174	68%	4	3	3	$275	✅	✅	❌	Y / Y	⭐️ 5 (112)
Mpls Marvel: Spacious Retreat	$46,400	$163	71%	4	2	1	$126	❌	❌	❌	Y / Y	⭐️ 5 (122)
Hathaway House: quaint, stylish, central retreat	$40,553	$153	70%	4	2	2	$150	❌	❌	❌	Y / Y	⭐️ 5 (63)
Beautiful, Spacious Home in Maple Grove	$65,052	$226	77%	4	2.5	2	$150	❌	❌	✅	Y / Y	⭐️ 5 (34)
Fridley Family Home wArcade, Playset, BBQ, Firepit	$77,828	$297	69%	4	2.5	3	$200	❌	❌	✅	Y / Y	⭐️ 5 (44)
Brookstone Bliss - Hot tub, Pool, Games and more	$59,026	$297	53%	4	3	2	$279	✅	✅	✅	Y / Y	⭐️ 4.5 (35)
Kids and Pets	$49,762	$206	66%	4	3	2	$0	✅	❌	✅	Y / Y	⭐️ 5 (78)
Tranquil Family Home l 4BR 2BA	$45,038	$188	63%	4	2	2	$140	❌	❌	❌	Y / Y	⭐️ 5 (84)
Great Patio, Hot Tub, 4 Bedroom	$82,230	$262	84%	4	2	2	$125	✅	✅	❌	Y / Y	⭐️ 5 (124)
Family and Pet Friendly 4BR FirePit Grill 2MI NSC	$107,467	$357	81%	4	3	3	$200	❌	❌	✅	Y / Y	⭐️ 5 (28)
Sunset Shores - River View, King Beds, Soaker Tub	$161,113	$620	71%	4	2	2	$0	❌	❌	❌	Y / Y	⭐️ 5 (59)
MINNeSTAY* Lakeside Park Escape \| Entertainment	$83,785	$294	69%	4	3.5	2	$329	✅	❌	✅	Y / Y	⭐️ 5 (17)
Charming Moore Lake Park Home	$54,546	$238	60%	4	2	2	$140	❌	❌	❌	Y / Y	⭐️ 5 (31)
Lakefront House w/ Sauna & comfy King bed!	$94,925	$432	59%	4	3.5	2	$250	❌	❌	✅	Y / Y	⭐️ 5 (53)
Renovated Blaine Farmhouse w/ Heated Pole Barn!	$72,929	$409	41%	4	2.5	2	$285	❌	❌	❌	Y / Y	⭐️ 5 (6)
Sunlit Oasis: 4 Bedroom Family Friendly Retreat	$44,000	$152	72%	4	2	2	$180	❌	❌	❌	Y / Y	⭐️ 5 (42)
Great Cabin-like 15 Acres-Couples&Groups, dogs ok	$65,017	$218	79%	4	2	4	$100	❌	❌	✅	Y / Y	⭐️ 5 (125)
The Quincy Place	$53,804	$185	77%	4	2	4	$99	✅	❌	✅	Y / Y	⭐️ 4.5 (101)
Quiet 4 BRs house/Near downtown Msp / Minneapolis	$47,985	$257	49%	4	2	2	$189	❌	❌	❌	Y / Y	⭐️ 5 (90)
Art District/Heart of NE Minneapolis/UofMN	$54,710	$271	51%	4	1	3	$275	❌	❌	✅	Y / Y	⭐️ 4.8 (24)
Comfy Homestay- Spacious Rooms/Private Backyard	$57,522	$202	74%	4	2	3	$165	❌	❌	❌	Y / Y	⭐️ 5 (38)
Cozy and Modern 4 bedroom 1 Bathroom McKinley Home	$35,420	$110	87%	4	1	2	$30	❌	❌	❌	Y / Y	⭐️ 5 (171)
Light & Bright MN Retreat 15 mins from everything	$51,609	$219	61%	4	2	1	$180	❌	❌	✅	Y / Y	⭐️ 5 (101)
Remodeled duplex in the heart of Northeast	$70,960	$201	91%	4	2	2	$165	❌	❌	✅	Y / Y	⭐️ 5 (85)
New Listing Promo/Near all pro stadiums/Game Room	$35,894	$196	47%	4	2	2	$180	❌	❌	❌	Y / Y	⭐️ 5 (45)
Game room / huge backyard / 5min to DT Minneapolis	$76,979	$398	52%	4	2	2	$175	❌	❌	❌	Y / Y	⭐️ 5 (67)
NE Arts/BrewHouse; Great location,hottub,pooltable	$41,766	$146	75%	4	2	1	$120	✅	✅	❌	Y / Y	⭐️ 4.5 (346)
Modern 4 Bed/3 Bath LOG Cabin HOT TUB & SAUNA!	$80,599	$519	37%	4	3	2	$285	❌	✅	❌	Y / Y	⭐️ 5 (20)
Minneapolis Hygge House w/ fireplace & garage	$37,741	$141	70%	4	1.5	1	$159	❌	❌	✅	Y / Y	⭐️ 5 (71)
2 Story House with Gas Fireplace + Garage Parking	$69,965	$324	59%	4	2.5	2	$0	❌	❌	❌	Y / Y	⭐️ 5 (32)
The Great City Escape	$52,515	$209	67%	4	3	1	$150	❌	❌	❌	Y / Y	⭐️ 4.8 (143)
Sullivan Lake Retreat-GamesBBQFenced*2CarGarage	$78,380	$322	65%	4	2	3	$210	❌	❌	✅	Y / Y	⭐️ 5 (42)
Spa-cious Secluded Retreat (11+3)	$133,714	$543	66%	4	4.5	3	$260	❌	✅	❌	Y / Y	⭐️ 4.5 (4)
Secluded Spa-cious Retreat (8+3)	$106,532	$381	76%	4	4.5	3	$225	❌	✅	❌	Y / Y	⭐️ 5 (73)
Lakefront Getaway	$63,660	$273	62%	4	2	3	$125	❌	❌	❌	Y / Y	⭐️ 5 (17)
10Bed/2Bath Steam Shower NEMpls	$39,763	$278	38%	4	1.5	2	$200	❌	❌	✅	Y / Y	⭐️ 5 (6)
COZY CHARMER☆NORTHEAST MINNEAPOLIS☆ART DISTRICT	$58,606	$250	63%	4	2	2	$125	❌	❌	❌	Y / Y	⭐️ 5 (95)

Return Metrics

242.04% cash on cash return is a excellent return over the next 1 year

Cashflow Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	$7,745	$15,490	$23,236	$30,981	$38,726	$77,453	$232,360
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$0	$0	$0	$0	$0	$0	$0
Down Payment	$0	$0	$0	$0	$0	$0	$0
Property Appreciation	$78	$158	$242	$327	$415	$897	$3,725
Total Return	$7,823	$15,649	$23,478	$31,308	$39,142	$78,351	$236,085

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

242.04%

Payback Period Days

150

Return on Investment

244.48%

13845 Underclift St NW Andover, Minnesota, 55304

4 bed • 2 bath • 12 guests

Monthly Rent

Inquire about this property

Contact Agent

$65,072

Annual Revenue

This property is projected to be in the top 49% revenue percentile compared to similar properties nearby.
Projected nightly rate is $275/night at 52% occupancy.Projected nightly rate is $297/night at 65% occupancy.

Occupancy Rate

Top 48% of comparables

Avg Daily Rate

Top 48% of comparables

Seasonality

40 Airbnb Comparables

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

$67,943

Avg annual revenue

65%

Avg occupancy rate

$297

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

$35k

$75k

$115k

$160k

$7,745

Profit

Revenue

$65,072

Operating Expenses

$26,007

Operating Income

$39,065

Net Effective Rent

$31,320

Profit (Cash Flow)

$7,745

$3,200

Cash Investment

Renos & Furnishing

$3,100

Setup Costs

$100

Total

$3,200

Investment Value Over Time

Revenue Appreciation

Cash on Cash Return

242.04%

Payback Period Days

150