BNBCalc Short Term Rental Rental Arbitrage Analysis 3049 Columbia Rd

3 bed • 2 bath • 6 guests • $0

BNB

Calc

Annual Revenue

$32,540

Profit (Cash Flow)

-$8,531

Cash on Cash Return

-99.2%

Annual Revenue

$32,540

AirDNA projects $216/night at 42% occupancy ($33,134). Airbtics projects $151/night at 59% occupancy ($32,539). Airbtics predicts this property will perform in the 43% revenue percentile

BNB Calc projects a 59% occupancy rate, $151 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$25,857	$36,358	$40,131	$60,604
Occupancy	53%	61%	64%	79%
Nightly Rate	$125	$153	$159	$197

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Charming 3-bedroom single home with parking	$39,770	$125	82%	3	1	1	$55	❌	❌	❌	Y / Y	⭐️ 5 (142)
Central Downtown Lakewood; Cleveland Private Home	$55,359	$210	65%	3	1	1	$150	❌	❌	❌	N / Y	⭐️ 5 (32)
*2BR Entire Home, 4miles from CLE Airport*	$16,370	$106	38%	3	1	2	$70	❌	❌	❌	Y / Y	⭐️ 4.7 (225)
Huge Family Home: Hot Tub, Crib, Play Area, Rocker	$40,000	$158	63%	3	1	1	$125	❌	✅	❌	Y / Y	⭐️ 4.9 (82)
Cozy 3 bedroom home on the west side of Cleveland!	$28,707	$132	58%	3	3	2	$30	❌	❌	❌	Y / Y	⭐️ 4.7 (70)
Newly Remodeled...... Recently Reduced Price	$30,839	$159	50%	3	1	2	$70	❌	❌	❌	Y / Y	⭐️ 4.9 (392)
Cute 3BR House Westside Suburb Pet Friendly Yard	$22,628	$78	75%	3	1	3	$60	❌	❌	✅	Y / Y	⭐️ 4.8 (133)
Huge Hot Tub! Huge Space Perfect for Long TermStay	$37,485	$159	59%	3	1	1	$125	❌	✅	❌	Y / Y	⭐️ 4.8 (92)
Min from Airport \| Fully Remodeled \| Fam Friendly!	$28,119	$126	54%	3	1	2	$100	❌	❌	✅	Y / Y	⭐️ 5 (57)
Chic Home w/ Deck, Walk to Lake Erie!	$66,280	$271	63%	3	3	2	$129	❌	❌	❌	Y / Y	⭐️ 5 (20)
Family Fun! \|Gameroom \| Backyard	$37,850	$160	61%	3	1	2	$90	❌	❌	❌	Y / Y	⭐️ 4.8 (166)
Tranquil 3 bedroom oasis in North Olmsted.	$42,041	$178	61%	3	2	1	$100	❌	❌	❌	Y / Y	⭐️ 4.8 (37)
Westbridge Cottage	$44,976	$143	85%	3	1	2	$50	❌	❌	❌	Y / Y	⭐️ 5 (24)
Avon Lake Cottage	$31,083	$153	52%	3	1	2	$115	❌	❌	✅	Y / Y	⭐️ 4.8 (26)

Return Metrics

-99.19% cash on cash return is a poor return over the next 1 year

Cashflow Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	-$8,530	-$17,061	-$25,591	-$34,122	-$42,652	-$85,305	-$255,916
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	$0	$0	$0	$0	$0	$0	$0
Total Return	-$8,530	-$17,061	-$25,591	-$34,122	-$42,652	-$85,305	-$255,916

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-99.19%

Payback Period Days

Return on Investment

-99.19%

3049 Columbia Rd Westlake, Ohio, 44145-5517

3 bed • 2 bath • 6 guests

Monthly Rent

Inquire about this property

Contact Agent

$2,070

Zestimate

$32,540

Annual Revenue

This property is projected to be in the top 43% revenue percentile compared to similar properties nearby.
Projected nightly rate is $216/night at 42% occupancy.Projected nightly rate is $151/night at 59% occupancy.

Occupancy Rate

Top 54% of comparables

Avg Daily Rate

Top 48% of comparables

Seasonality

15 Airbnb Comparables

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

$35,629

Avg annual revenue

59%

Avg occupancy rate

$151

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

$10k

$30k

$50k

$65k

-$8,531

Profit

Revenue

$32,540

Operating Expenses

$16,230

Operating Income

$16,309

Net Effective Rent

$24,840

Profit (Cash Flow)

-$8,531

$8,600

Cash Investment

Renos & Furnishing

$8,500

Setup Costs

$100

Total

$8,600

Investment Value Over Time

Revenue Appreciation

Cash on Cash Return

-99.19%

Payback Period Days