THE JIMBARAN VIEW INCOME PROJECTION FOR OWNERS

TAHUN 1 2 3 4 5 6 7 8 9 10
DAY 365 365 365 365 365 365 365 365 365 365
ROOM TYPE 27 226 226 226 226 226 226 226 226 226 226
ROOM TYPE 54 8 8 8 8 8 8 8 8 8 8
ROOM SALEABLE (STANDARD ROOM) 8 8 8 8 8 8 8 8 8 8
ROOM STANDARD AVAILABLE 82.490 82.490 82.490 82.490 82.490 82.490 82.490 82.490 82.490 82.490
ROOM SUITE AVAILABLE 2.920 2.920v 2.920 2.920 2.920 2.920 2.920 2.920 2.920 2.920
OCCUPIED ROOMS STANDARD 45.370 49.494 57.743 61.868 65.992 65.992 65.992 70.117 70.117 70.117
OCCUPIED ROOMS SUITE 1.606 1.752 2.044 2.190 2.336 2.336 2.336 2.482 2.482 2.482
TOTAL ROOM OCCUPIED 46.976 51.246 59.787 64.058 68.328 68.328 68.328 72.599 72.599 72.599
OCCUPANCY (%) 55% 60% 70% 75% 80% 80% 80% 85% 85% 85%
AVERAGE ROOM RATE STANDARD 600.000 620.000 640.000 665.000 690.000 720.000 755.000 790.000 825.000 860.000
AVERAGE ROOM RATE SUITE 1.200.000 1.240.000 1.280.000 1.330.000 1.380.000 1.440.000 1.510.000 1.580.000 1.650.000 1.720.000
HARGA JUAL TYPE 27 600.000.000 600.000.000 600.000.000 600.000.000 600.000.000 600.000.000 600.000.000 600.000.000 600.000.000 600.000.000
HARGA JUAL TYPE 54 1.200.000.000 1.200.000.000 1.200.000.000 1.200.000.000 1.200.000.000 1.200.000.000 1.200.000.000 1.200.000.000 1.200.000.000 1.200.000.000
BREAKFAST/GUEST (IDR) 50.000 55.000 60.000 65.000 70.000 75.000 80.000 85.000 90.000 95.000
TOTAL ROOM REVENUE 43.159.060.000 48.218.325.000 53.541120.000 56.002.660.000 58.817.560.000 65.484.467.500 68.475.277.500 71.466.087.500
ROOM EXPENSES 10.851.953.861 12.007.607.825 13.230.961.687 13.958.577.447 14.758.439.332 16.265.154.892 17.138.061.206
NETT ROOM REVENUE 32.307.106.139 36.210.717.175 40.310.158.313 42.044.102.553 44.059.120.668 49.219.312.608 51.337.216.294 53.432.752.048
REVENUE TYPE 27 10.848.000.000 10.848.000.000 16.153.553.070 18.105.358.587 20.155.079.156 21.022.051.276 22.029.560.334 24.609.656.304 25.668.608.147 26.716.376.024
REVENUE TYPE 54 768.000.000 768.000.000
OWNER SHARE PROFIT
GROSS 6534 6534 6534 6534 6534 6534 6534 6534 6534 6534
TYPE
27 48.000.000 48.000.000 66.750.219 74.815.531 83.285.451 86.867.980 91.031.241 101.692.795 106.068.629 110.398.248
54 96.000.000 96.000.000 133.500.439 149.631.063 166.570.902 173.735.961 182.062.482 203.385.589 212.137.257 220.796.496
27 8% 8% 11% 12% 14% 14% 15% 17% 18% 18%
54 8% 8% 11% 12% 14% 14% 15% 17% 18% 18%
PAYBACK PERIODE
Tahun Nilai Investasi EAT Proceed Akumulasi Kekurangan
a b c d=(b+c) e f
2012 600.000.000
2013 1 48.000.000 48.000.000 48.000.000 552.000.000
2014 2 48.000.000 48.000.000 96.000.000 504.000.000
2015 3 66.750.219 66.750.219 162.750.219 437.249.781
2016 4 74.815.531 74.815.531 237.565.751 362.434.249
2017 5 83.285.451 83.285.451 320.851.202 279.148.798
2018 6 86.867.980 86.867.980 407.719.182 192.280.818
2019 7 91.031.241 91.031.241 498.750.423 101.249.577
2020 8 101.692.795 101.692.795 600.443.218 (443.218)
2021 9 106.068.629 106.068.629 706.511.847 (106.511.847)
2022 10 110.398.248 110.398.248 816.910.095 (216.910.095)
816.910.095
BEP 7 tahun
11,95 bulan
Jadi investasi break event poin pada tahun ke-7 bulan ke-10.