BNBCalc Short Term Rental Rental Arbitrage Analysis 123-09 Cra. 17, Bogotá, DC, 110111

1 bed • 1.5 bath • 2 guests • $0

BNB

Calc

Report by:

Juan Felipe Perdomo Carvajal

jf.perdomo416@gmail.com

Annual Revenue

$8,832

Profit (Cash Flow)

-$13,317

Cash on Cash Return

-297.6%

Annual Revenue

$8,832

AirDNA projects $44/night at 57% occupancy ($9,160). Airbtics projects $39/night at 62% occupancy ($8,831). Airbtics predicts this property will perform in the 44% revenue percentile

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

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

Percentiles	25%	50%	75%	90%
Revenue	$6,277	$8,877	$13,303	$17,331
Occupancy	49%	62%	77%	89%
Nightly Rate	$34	$38	$46	$52

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Unicentro, vista exterior. Parqueadero.	$11,800	$52	62%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 4.5 (65)
HERMOSO, ACOGEDOR, EXCELENTE UBICACION.	$6,917	$30	63%	1	2	1	$0	❌	❌	❌	Y / Y	⭐️ 4.8 (26)
Hermoso apto unicentro para 2 personas	$6,214	$39	40%	1	1	1	$14	❌	❌	❌	Y / N	⭐️ 5 (6)
Hermoso Apartamento Junto a Unicentro, parqueadero	$13,175	$36	98%	1	1	2	$13	❌	❌	❌	Y / Y	⭐️ 4.9 (77)
Beautiful new apt Unicentro 122* L	$9,490	$35	72%	1	1	3	$17	❌	❌	❌	Y / N	⭐️ 4.8 (16)
Apto a 100 mts de Unicentro, Excelente Ubicación!	$4,860	$38	33%	1	2	1	$18	❌	❌	❌	Y / N	⭐️ 4.3 (100)
Tranquilo Apartamento Diagonal a Unicentro.	$12,221	$53	63%	1	1	1	$0	❌	❌	✅	N / Y	⭐️ 4.7 (33)
Espectacular apartamento con terraza zona unicent	$8,632	$37	60%	1	1	1	$16	❌	❌	❌	Y / Y	⭐️ 0 (0)
apartamento central Centro Comercial Uni centro	$5,664	$39	37%	1	1	1	$14	❌	❌	❌	Y / N	⭐️ 5 (4)
¡NUEVO! Apartaestudio cerca a Unicentro	$8,707	$30	76%	1	1	2	$15	❌	❌	❌	Y / Y	⭐️ 5 (50)
Apartamento excepcional en Unicentro	$12,287	$35	94%	1	1	2	$13	❌	❌	❌	Y / Y	⭐️ 5 (71)
Spectacular Minimalist Apartment 116 Street	$14,011	$44	85%	1	2	1	$20	❌	❌	✅	Y / Y	⭐️ 4.9 (192)
ACOGEDOR APARTAMENTO AL FRENTE DE UNICENTRO	$9,311	$48	53%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 4.7 (16)
Perfect Minimalist Apartment 116 Street!	$15,962	$52	82%	1	2	1	$20	❌	❌	✅	Y / Y	⭐️ 4.9 (28)
Hermoso Apartamento Estudio	$9,150	$50	50%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 4.6 (27)
living hammock 127	$13,065	$48	73%	1	2	3	$18	❌	❌	✅	Y / Y	⭐️ 4.2 (8)
Modern Unicentro 1 Bedroom Apartment Top Location	$12,420	$42	78%	1	2	2	$16	❌	❌	❌	Y / Y	⭐️ 4.8 (47)
Amazing Minimalist Apartment Avenida 116 Street	$13,714	$46	79%	1	2	1	$20	❌	❌	✅	Y / Y	⭐️ 4.8 (58)
Moderno, Cerca Unicentro.	$8,813	$43	56%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 4.8 (32)
Loft Espectacular - Cerca Unicentro	$9,461	$47	55%	1	2	1	$0	❌	❌	❌	N / N	⭐️ 4.9 (11)
Cozy Unit in Unicentro, near the Shopping Center.	$7,458	$33	61%	1	2	1	$9	❌	❌	✅	N / N	⭐️ 4.3 (55)
Long Stay by Unicentro a Professional Home Office	$8,771	$34	69%	1	1	21	$24	❌	❌	✅	Y / Y	⭐️ 4.9 (52)
Moderno apartamento para 4 cerca a unicentro	$5,853	$59	26%	1	1	1	$10	❌	❌	❌	N / N	⭐️ 3.6 (8)
ACOGEDOR APARTAMENTO AL FRENTE DE UNICENTRO	$7,174	$40	49%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 4.7 (11)
Unicentro, Parqueadero, Wifi de Alta velocidad.	$10,212	$45	62%	1	1	1	$0	❌	❌	❌	Y / Y	⭐️ 4 (5)
Spectacular Minimalist Apartment 116 Street	$14,490	$43	91%	1	2	1	$20	❌	❌	✅	Y / Y	⭐️ 4.8 (91)
Hermoso apto cerca al centro c.unicentro 1 hab.	$4,564	$25	44%	1	1	1	$14	❌	❌	❌	Y / Y	⭐️ 4.5 (2)
Apartaestudio muy cerca de Unicentro	$8,212	$26	82%	1	1	1	$20	❌	❌	❌	Y / Y	⭐️ 4.9 (66)
Luxurious Apartment next to UNICENTRO Mall	$5,274	$31	45%	1	1	5	$20	❌	❌	❌	Y / N	⭐️ 4.7 (18)
RentaElite Charming 1 room in Unicentro	$11,750	$52	60%	1	1	7	$52	❌	❌	✅	Y / Y	⭐️ 4.7 (25)
City Heights 118 Loft	$5,058	$49	27%	1	1	1	$13	❌	❌	❌	Y / Y	⭐️ 4 (4)
Duplex flat with parking spaces - Unicentro	$9,516	$26	100%	1	2	4	$0	❌	❌	✅	Y / N	⭐️ 4.9 (8)
Cozy Studio Near Unicentro	$12,716	$38	89%	1	1	2	$20	❌	❌	❌	Y / Y	⭐️ 4.9 (19)
Hermoso loft con estacionamiento gratuito	$5,843	$40	36%	1	1	3	$18	❌	❌	❌	Y / Y	⭐️ 3 (1)
Stunning 1 BR Loft in Usaquen!	$7,162	$38	49%	1	1	2	$15	❌	❌	❌	Y / Y	⭐️ 4.5 (34)
Lovely modern apartment near Unicentro mall	$8,454	$33	70%	1	2	30	$26	❌	❌	✅	Y / Y	⭐️ 4.7 (5)
Lindo Apto a 5 minutos del c.c. Unicentro.	$7,381	$38	49%	1	1	1	$13	❌	❌	❌	Y / N	⭐️ 4.5 (3)
Apartamento con terraza cerca a Unicentro	$7,900	$37	56%	1	1	1	$13	❌	❌	✅	Y / Y	⭐️ 4.9 (12)
Studio in Santa Barbara Bogotá	$8,442	$29	77%	1	1	2	$16	❌	❌	✅	Y / N	⭐️ 4.8 (11)
Beautiful new apt Unicentro 122	$8,280	$35	63%	1	1	3	$18	❌	❌	❌	Y / N	⭐️ 4 (4)

Return Metrics

-297.57% 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)	-$13,316	-$26,633	-$39,949	-$53,266	-$66,582	-$133,165	-$399,495
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	-$13,316	-$26,633	-$39,949	-$53,266	-$66,582	-$133,165	-$399,495

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-297.57%

Payback Period Days

Return on Investment

-297.57%

123-09 Cra. 17 Bogotá, DC, 110111

1 bed • 1.5 bath • 2 guests

Monthly Rent

$8,832

Annual Revenue

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

Occupancy Rate

Top 51% 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.

$9,259

Avg annual revenue

62%

Avg occupancy rate

$39

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

$5k

$10k

$15k

-$13,317

Profit

Revenue

$8,832

Operating Expenses

$13,148

Operating Income

-$4,317

Net Effective Rent

$9,000

Profit (Cash Flow)

-$13,317

$4,475

Cash Investment

Renos & Furnishing

$4,375

Setup Costs

$100

Total

$4,475

Investment Value Over Time

Revenue Appreciation

Cash on Cash Return

-297.57%

Payback Period Days