BNBCalc Short Term Rental Investment Analysis Carrera 2, 470009 Santa Marta, Magdalena, Colombia

2 bed • 1 bath • 4 guests • $100,000

BNB

Calc

Report by:

Alexandra Rey

alereyece@gmail.com

Annual Revenue

$12,491

Profit (Cash Flow)

-$3,336

Cap Rate

2.0%

Annual Revenue

$12,491

AirDNA projects $60/night at 57% occupancy ($12,491).

BNB Calc projects a 56.99999999999999% occupancy rate, $60 rate per night.

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

Return Metrics

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

Investment Value Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	-$3,335	-$6,671	-$10,007	-$13,343	-$16,679	-$33,358	-$100,076
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$1,408	$2,875	$4,401	$5,989	$7,641	$16,972	$79,999
Down Payment	$20,000	$20,000	$20,000	$20,000	$20,000	$20,000	$20,000
Property Appreciation	$3,000	$6,090	$9,272	$12,550	$15,927	$34,391	$142,726
Total Return	$21,072	$22,293	$23,666	$25,196	$26,889	$38,005	$142,649

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-12.04%

Cap Rate

1.99%

Return on Investment

3.87%

26-1 Cra. 2 Santa Marta, Magdalena, 470004

2 bed • 1 bath • 4 guests

Purchase Price

$12,491

Annual Revenue

Occupancy Rate

Top 101% of comparables

Avg Daily Rate

Top 101% of comparables

-$3,336

Profit

Revenue

$12,491

Operating Expenses

$10,494

Operating Income

$1,997

Mortgage & Taxes

$5,333

Profit (Cash Flow)

-$3,336

$27,688

Cash Investment

Down Payment

$20,000

Renos & Furnishing

$4,688

Closing Costs

$3,000

Total

$27,688

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-12.04%

Cap Rate

1.99%

Return on Investment

3.87%