| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||||
3 | 3 bedroom mid-high range villa project in Seminyak (leasehold over 25 years, newly built) | |||||||||||||||||||||||||||
4 | All figures are estimates and non contractual | |||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||||
6 | Land size | 2 | ares | Currency exchange rate and inflation | ||||||||||||||||||||||||
7 | Price/are/year | 20 | mIDR | 1 USD | = | 15740 | IDR | |||||||||||||||||||||
8 | Duration | 25 | years | Inflation | 3% | per year | ||||||||||||||||||||||
9 | Total land cost | $63,532 | USD | Building price (/m²) | ||||||||||||||||||||||||
10 | Number of bedrooms | 1 | bedrooms | Mid-high quality villa | $500 | USD | ||||||||||||||||||||||
11 | Building size | 200 | m² | Luxury villa | $1,000 | USD | ||||||||||||||||||||||
12 | Building price / m2 | $800 | USD | Rental rate | ||||||||||||||||||||||||
13 | Decoration/furnitures | $5,000 | USD | Location | Occupancy | Average room rate | ||||||||||||||||||||||
14 | Garden/pool | $15,000 | USD | Seminyak | 55% | $117 | USD | |||||||||||||||||||||
15 | Notaris/IMB/legal costs | $15,000 | USD | Canggu | 40% | $93 | USD | |||||||||||||||||||||
16 | Total building cost | $195,000 | USD | Ubud | 40% | $117 | USD | |||||||||||||||||||||
17 | Total investment | $250,000 | USD | Legian | 50% | $100 | USD | |||||||||||||||||||||
18 | ||||||||||||||||||||||||||||
19 | ||||||||||||||||||||||||||||
20 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | ||
21 | Average Nightly Villa Rate | Construction | $225 | $232 | $239 | $246 | $253 | $261 | $269 | $277 | $285 | $294 | $302 | $311 | $321 | $330 | $340 | $351 | $361 | $372 | $383 | $395 | $406 | $419 | $431 | $444 | ||
22 | Occupancy | 0 | 75% | 76% | 77% | 78% | 79% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | ||
23 | Gross revenue | $0 | $61,594 | $64,287 | $67,087 | $69,997 | $73,022 | $76,164 | $78,449 | $80,803 | $83,227 | $85,724 | $88,295 | $90,944 | $93,672 | $96,483 | $99,377 | $102,358 | $105,429 | $108,592 | $111,850 | $115,205 | $118,662 | $122,221 | $125,888 | $129,665 | ||
24 | Property management | 15% | $9,239 | $9,516 | $9,802 | $10,096 | $10,399 | $10,711 | $11,032 | $11,363 | $11,704 | $12,055 | $12,417 | $12,789 | $13,173 | $13,568 | $13,975 | $14,394 | $14,826 | $15,271 | $15,729 | $16,201 | $16,687 | $17,187 | $17,703 | $18,234 | ||
25 | Maintenance | 3% | $1,848 | $1,929 | $2,013 | $2,100 | $2,191 | $2,285 | $2,353 | $2,424 | $2,497 | $2,572 | $2,649 | $2,728 | $2,810 | $2,894 | $2,981 | $3,071 | $3,163 | $3,258 | $3,355 | $3,456 | $3,560 | $3,667 | $3,777 | $3,890 | ||
26 | Air BNB Platform fees | 3% | $1,848 | $1,929 | $2,013 | $2,100 | $2,191 | $2,285 | $2,353 | $2,424 | $2,497 | $2,572 | $2,649 | $2,728 | $2,810 | $2,894 | $2,981 | $3,071 | $3,163 | $3,258 | $3,355 | $3,456 | $3,560 | $3,667 | $3,777 | $3,890 | ||
27 | Local tax | 10% | $6,159 | $6,429 | $6,709 | $7,000 | $7,302 | $7,616 | $7,845 | $8,080 | $8,323 | $8,572 | $8,830 | $9,094 | $9,367 | $9,648 | $9,938 | $10,236 | $10,543 | $10,859 | $11,185 | $11,521 | $11,866 | $12,222 | $12,589 | $12,966 | ||
28 | Net revenue | $0 | $42,500 | $44,485 | $46,552 | $48,702 | $50,940 | $53,267 | $54,865 | $56,511 | $58,207 | $59,953 | $61,752 | $63,604 | $65,512 | $67,478 | $69,502 | $71,587 | $73,735 | $75,947 | $78,225 | $80,572 | $82,989 | $85,479 | $88,043 | $90,684 | ||
29 | Return on investment | 0% | 17% | 18% | 19% | 19% | 20% | 21% | 22% | 23% | 23% | 24% | 25% | 25% | 26% | 27% | 28% | 29% | 29% | 30% | 31% | 32% | 33% | 34% | 35% | 36% | ||
30 | Break even point | -$250,000 | -$207,500 | -$199,086 | -$145,826 | -$90,124 | -$31,882 | $29,002 | $91,712 | $156,304 | $222,833 | $291,358 | $361,939 | $434,638 | $509,517 | $586,643 | $666,083 | $747,906 | $832,183 | $918,989 | $1,008,399 | $1,100,491 | $1,195,346 | $1,293,047 | $1,393,679 | $1,497,329 | ||