BNBCalc Short Term Rental Rental Arbitrage Analysis 155 E Broad St, Columbus, OH, 43215

2 bed • 2 bath • 6 guests • $0

BNB

Calc

Report by:

Mariane Nassar

+15074488993

info@purplesaillodging.com

purplesaillodging.com

Annual Revenue

$36,985

Profit (Cash Flow)

-$15,823

Cash on Cash Return

-239.7%

Annual Revenue

$36,985

AirDNA projects $220/night at 54% occupancy ($43,390). Airbtics projects $166/night at 61% occupancy ($36,984). Airbtics predicts this property will perform in the 50% revenue percentile

BNB Calc projects a 61% occupancy rate, $166 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$22,209	$34,763	$49,146	$69,014
Occupancy	48%	63%	71%	81%
Nightly Rate	$120	$144	$180	$222

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
King \| Queen With Balcony Downtown	$22,423	$70	75%	2	1	1	$200	✅	❌	✅	Y / Y	⭐️ 5 (84)
Downtown Luxury Apartment on the Columbus Commons	$38,593	$143	71%	2	2	2	$130	✅	❌	❌	Y / Y	⭐️ 5 (149)
Spacious Luxury Downtown Loft (Free Parking!)	$33,163	$123	67%	2	2	1	$88	✅	❌	❌	Y / Y	⭐️ 4.5 (118)
KING Suite + 2 Queen Bed - Downtown	$22,221	$75	69%	2	2	1	$200	✅	❌	✅	Y / Y	⭐️ 4.5 (167)
Luxury Downtown Condo	$32,382	$139	59%	2	2	2	$135	✅	❌	❌	Y / Y	⭐️ 5 (70)
208B\| Onsite Restaurant & Bar \| 2BR + Balcony \| DT	$32,551	$183	45%	2	2	1	$100	✅	❌	❌	Y / Y	⭐️ 5 (37)
Mid-Century Downtown Loft (Free Parking)	$31,099	$110	71%	2	2	1	$88	✅	❌	❌	Y / Y	⭐️ 5 (90)
PERFECT CONVENTION CENTER location! LUXURY UNIT	$44,548	$215	56%	2	1.5	2	$60	❌	❌	❌	Y / Y	⭐️ 5 (123)
German Village Gem: Cozy Luxury & Hot Tub Haven	$46,411	$262	45%	2	1	1	$130	❌	✅	❌	Y / Y	⭐️ 5 (54)
Travel Haus: Stunning Cottage in German Village!	$26,745	$132	51%	2	1.5	1	$100	❌	❌	✅	Y / Y	⭐️ 5 (128)
The Grant Cottage \| German Village at Nationwide	$43,849	$148	76%	2	1	2	$95	❌	❌	✅	Y / Y	⭐️ 5 (63)
Stylish Haus \| Heart of German Village \| Parking	$40,754	$168	63%	2	1	2	$100	❌	❌	✅	Y / Y	⭐️ 5 (74)
Downtown Views from a Stylish 2BR with Balcony	$35,287	$133	69%	2	2	2	$120	✅	❌	✅	Y / Y	⭐️ 5 (27)
Gem of German Village	$40,341	$188	57%	2	1	1	$65	❌	❌	❌	Y / Y	⭐️ 5 (406)
German Village Point	$43,067	$178	64%	2	1	1	$65	❌	❌	❌	Y / Y	⭐️ 4.5 (284)
German Village Getaway!	$51,579	$188	74%	2	1	1	$65	❌	❌	❌	Y / Y	⭐️ 5 (399)
Historic German Village Home/A+ Downtown Location!	$26,305	$88	69%	2	2	1	$80	❌	❌	✅	Y / Y	⭐️ 5 (184)
Downtown's Best. You'll Love It	$38,722	$139	73%	2	2	3	$138	✅	❌	❌	Y / Y	⭐️ 5 (69)
214M \| Lux Two Bedroom Suite \| Downtown Columbus	$28,094	$202	38%	2	2	1	$0	✅	❌	❌	Y / Y	⭐️ 5 (5)
The Lantern -German Village Updated 2 BR +Parking	$32,447	$148	58%	2	1	1	$64	❌	❌	✅	Y / Y	⭐️ 5 (21)
Cheerful 2 bedroom in the heart of German village	$17,718	$103	47%	2	1.5	2	$0	❌	❌	❌	Y / Y	⭐️ 4.5 (69)
The Columbus Downtown Suite	$34,302	$132	71%	2	2	1	$0	✅	❌	❌	Y / Y	⭐️ 5 (28)
The Downtown Columbus Residence	$32,281	$126	70%	2	2	1	$0	✅	❌	❌	Y / Y	⭐️ 4.5 (29)
Housepitality - The Study -Downtown 2 BR Lux	$26,057	$173	38%	2	1	1	$122	❌	❌	✅	Y / Y	⭐️ 4.9 (8)
Stylish Rock Glam 2BD Loft Apt w/ Deck & Views	$19,879	$112	45%	2	1	1	$59	❌	❌	❌	Y / Y	⭐️ 4.5 (84)
326M \| Luxury 2 Bedroom Suite \| Downtown Columbus	$29,463	$230	35%	2	2	1	$0	✅	❌	❌	Y / Y	⭐️ 5 (9)
Comfort&Spacious\|Located in Heart of Columbus	$30,833	$140	53%	2	2	30	$150	❌	❌	❌	Y / Y	⭐️ 4.8 (23)
Summer in the City	$21,124	$111	52%	2	2	30	$0	✅	❌	❌	Y / Y	⭐️ 5 (3)
Cozy 2 Bedroom Cottage in Historic German Village	$44,606	$146	81%	2	1	1	$110	❌	❌	✅	Y / Y	⭐️ 5 (40)
The Skyline Bike Condo—DOWNTOWN/ARENA/CONV CENTER	$27,977	$156	49%	2	2	30	$115	❌	❌	❌	Y / Y	⭐️ 4.8 (5)
Spacious Private Residence on Top Floor DT CBUS	$63,651	$561	31%	2	2	1	$0	✅	❌	❌	Y / Y	⭐️ 0 (1)
The Paper White Flat—DOWNTOWN/ARENA/CONV CENTER	$39,820	$170	64%	2	2	30	$115	❌	❌	✅	Y / Y	⭐️ 4.5 (5)
Historic German Village house with parking	$70,242	$222	86%	2	1	1	$60	❌	❌	❌	Y / Y	⭐️ 5 (32)
Modern Industrial Loft in Downtown Columbus	$64,709	$485	34%	2	1	2	$120	❌	❌	✅	Y / Y	⭐️ 3 (2)
Frontdesk \| Bright 2 BR Apt by Childrens Hospital	$32,662	$92	97%	2	2	1	$0	❌	❌	❌	Y / Y	⭐️ 4.8 (28)
Frontdesk \| 2 BR Apt by Grant Medical Center	$31,309	$91	94%	2	2	1	$0	❌	❌	❌	Y / Y	⭐️ 4.8 (19)
Frontdesk \| Bright 2 BR Apt by the Italian Village	$28,986	$90	88%	2	2	1	$0	❌	❌	❌	Y / Y	⭐️ 4.3 (14)
Heart of Columbus Gem!	$26,862	$179	41%	2	2	1	$0	❌	❌	❌	Y / Y	⭐️ 0 (6)
German Village Gem- City Views & private patio!	$30,262	$143	51%	2	2	1	$80	❌	❌	❌	Y / Y	⭐️ 4.7 (134)
Downtown Loft Apartment	$49,101	$172	78%	2	2	30	$0	❌	❌	❌	Y / Y	⭐️ 0 (0)

Return Metrics

-239.74% 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)	-$15,823	-$31,646	-$47,470	-$63,293	-$79,116	-$158,233	-$474,701
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	-$15,823	-$31,646	-$47,470	-$63,293	-$79,116	-$158,233	-$474,701

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-239.74%

Payback Period Days

Return on Investment

-239.74%

155 E Broad St Columbus, Ohio, 43215

2 bed • 2 bath • 6 guests

Monthly Rent

Inquire about this property

Contact Mariane

Columbus

Guide

Zoning

Market

Guide

Laws

Market Data

$36,985

Annual Revenue

This property is projected to be in the top 50% revenue percentile compared to similar properties nearby.
Projected nightly rate is $220/night at 54% occupancy.Projected nightly rate is $166/night at 61% occupancy.

Occupancy Rate

Top 53% of comparables

Avg Daily Rate

Top 38% of comparables

Seasonality

40 Airbnb Comparables

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

$35,810

Avg annual revenue

61%

Avg occupancy rate

$166

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

$15k

$35k

$50k

$70k

-$15,823

Profit

Revenue

$36,985

Operating Expenses

$16,808

Operating Income

$20,177

Net Effective Rent

$36,000

Profit (Cash Flow)

-$15,823

$6,600

Cash Investment

Renos & Furnishing

$6,500

Setup Costs

$100

Total

$6,600

Investment Value Over Time

Revenue Appreciation

Cash on Cash Return

-239.74%

Payback Period Days