BNBCalc Short Term Rental Rental Arbitrage Analysis 1230 Pendleton St, Columbia, SC, 29201

1 bed • 1 bath • 3 guests • $0

BNB

Calc

Annual Revenue

$25,589

Profit (Cash Flow)

-$3,538

Cash on Cash Return

-81.3%

Annual Revenue

$25,589

AirDNA projects $128/night at 64% occupancy ($29,920). Airbtics projects $113/night at 62% occupancy ($25,588). Airbtics predicts this property will perform in the 48% revenue percentile

BNB Calc projects a 62% occupancy rate, $113 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$15,859	$23,646	$33,975	$54,125
Occupancy	53%	64%	76%	88%
Nightly Rate	$79	$97	$115	$159

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Stylish suite downtown with FREE parking and GYM	$35,673	$97	94%	1	1	1	$60	❌	❌	❌	Y / Y	⭐️ 5 (142)
Chic Nautical Suite Downtown-FREE Parking, Gym!	$31,899	$107	77%	1	1	1	$60	❌	❌	❌	Y / Y	⭐️ 5 (112)
Tuscan Sun KING suite downtown FREE parking	$34,433	$106	81%	1	1	1	$60	❌	❌	❌	Y / Y	⭐️ 5 (112)
The Roost - USC Campus(steps from USC front gates)	$20,836	$98	56%	1	1	1	$34	❌	❌	❌	Y / Y	⭐️ 5 (498)
The Nest - USC Campus (steps from USC front gates)	$22,442	$107	56%	1	1	1	$34	❌	❌	❌	N / Y	⭐️ 5 (377)
The Perch - USC Campus(steps from USC front gates)	$29,713	$104	76%	1	1	1	$34	❌	❌	❌	Y / Y	⭐️ 5 (524)
Downtown Modern Industrial Oasis	$33,611	$123	68%	1	1	1	$130	❌	❌	✅	Y / Y	⭐️ 5 (75)
Historic Downtown Lofts #1	$26,910	$79	87%	1	1	1	$50	❌	❌	✅	Y / Y	⭐️ 5 (558)
The Coop on USC Campus(steps from USC front gates)	$22,427	$98	61%	1	1	1	$34	❌	❌	❌	N / Y	⭐️ 5 (480)
Heart of the Vista Apartment	$25,198	$101	66%	1	1	2	$33	❌	❌	✅	N / Y	⭐️ 5 (119)
MCM Inspired Downtown Loft	$25,463	$84	78%	1	1	1	$50	✅	❌	❌	Y / Y	⭐️ 5 (313)
Columbia Vacation Rental - Walk to UofSC Campus!	$27,564	$166	40%	1	1	2	$124	✅	❌	❌	Y / Y	⭐️ 5 (9)
Apartment in heart of Columbia	$28,188	$100	75%	1	1	2	$35	❌	❌	✅	N / Y	⭐️ 5 (151)
Urban Oasis - Downtown Columbia-Newly Renovated	$39,520	$237	44%	1	1	1	$50	❌	❌	❌	Y / Y	⭐️ 5 (41)
The Botanical Suite \| 1 BR 1 BA	$23,370	$75	75%	1	1	1	$75	❌	❌	❌	Y / Y	⭐️ 4.5 (57)
Front Seat on Main St \| Walk to Dining Sleeps 4	$27,155	$117	56%	1	2	1	$115	❌	❌	❌	Y / Y	⭐️ 4.7 (83)
Downtown Industrial Loft	$25,692	$73	92%	1	1	1	$50	✅	❌	❌	Y / Y	⭐️ 5 (257)
Lovely 1 Bedroom - Unit Near USC Columbia Campus	$19,510	$116	45%	1	1	3	$100	✅	❌	❌	Y / Y	⭐️ 4.8 (31)
The Rainbow Room \| Studio Apartment	$20,758	$74	68%	1	1	1	$75	❌	❌	❌	N / Y	⭐️ 4.5 (23)
NEW Luxury Apartment Downtown NO Cleaning Fee	$29,097	$159	50%	1	1	1	$0	✅	❌	❌	Y / Y	⭐️ 5 (83)
Vintage Studio Loft Downtown	$20,583	$79	66%	1	1	1	$50	✅	❌	❌	Y / Y	⭐️ 4.8 (62)
Sylvia's "Son" Suite	$41,460	$192	59%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 5 (16)
Amazing place! Ideal location! 5pts, Usc, ft. J	$22,621	$86	71%	1	1	1	$45	❌	❌	❌	Y / Y	⭐️ 4.5 (107)
The Flamingo Suite \| 1 King \| Newly Renovated!	$14,553	$71	56%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 5 (29)
The Scholar Suite \| 1 King \| Newly Renovated!	$16,470	$75	60%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 5 (27)
Economically Furnished 1 Bedroom (7G)	$11,239	$83	37%	1	1	30	$125	❌	❌	✅	N / N	⭐️ 4.5 (4)
Fully Furnished Monthly at USC & Capital (2C)	$13,773	$71	53%	1	1	30	$125	❌	❌	✅	N / N	⭐️ 5 (3)
The Venturi Suite \| 1 King \| Newly Renovated!	$22,307	$115	53%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 4 (14)
Economically Furnished 1 Bedroom (14B)	$15,517	$80	53%	1	1	30	$125	❌	❌	✅	N / N	⭐️ 4.5 (4)
Economically Furnished 1 Bedroom (12C)	$16,143	$70	63%	1	1	30	$125	❌	❌	✅	N / N	⭐️ 5 (3)
Economically Furnished 1 bedroom (16E)	$26,086	$81	88%	1	1	30	$125	❌	❌	✅	Y / Y	⭐️ 4.7 (3)
14th Flr Studio in Downtown Columbia	$25,986	$78	91%	1	1	28	$125	✅	❌	❌	Y / Y	⭐️ 0 (1)
Secure prime location close to USC and Downtown	$23,082	$85	72%	1	1	2	$29	❌	❌	❌	Y / Y	⭐️ 5 (126)
Casa Verde \| Spacious USC/Five Points Apartment	$26,232	$82	85%	1	1	1	$60	❌	❌	✅	Y / Y	⭐️ 4.9 (49)
Studio loft downtown five points	$32,940	$90	100%	1	1	1	$0	❌	❌	✅	Y / Y	⭐️ 4.8 (10)
Modern condo, closest to the University of SC	$40,230	$157	70%	1	1	1	$0	✅	❌	❌	Y / Y	⭐️ 5 (10)

Return Metrics

-81.32% 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)	-$3,537	-$7,075	-$10,612	-$14,150	-$17,687	-$35,375	-$106,127
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	-$3,537	-$7,075	-$10,612	-$14,150	-$17,687	-$35,375	-$106,127

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-81.32%

Payback Period Days

Return on Investment

-81.32%

1230 Pendleton St Columbia, South Carolina, 29201

1 bed • 1 bath • 3 guests

Monthly Rent

Inquire about this property

Contact Agent

Columbia

Zoning

Laws

$25,589

Annual Revenue

This property is projected to be in the top 48% revenue percentile compared to similar properties nearby.
AirDNA projects $128/night at 64% occupancy ($29,920.78). Airbtics projects $113/night at 62% occupancy ($25,588).

Occupancy Rate

Top 53% of comparables

Avg Daily Rate

Top 26% of comparables

Seasonality

40 Airbnb Comparables

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

$24,367

Avg annual revenue

62%

Avg occupancy rate

$113

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

$20k

$30k

$40k

-$3,538

Profit

Revenue

$25,589

Operating Expenses

$15,327

Operating Income

$10,262

Net Effective Rent

$13,800

Profit (Cash Flow)

-$3,538

$4,350

Cash Investment

Renos & Furnishing

$4,250

Setup Costs

$100

Total

$4,350

Investment Value Over Time

Revenue Appreciation

Cash on Cash Return

-81.32%

Payback Period Days