guest house ekotek
DESCRIPTION
tugas besar ekotekTRANSCRIPT
Penggunaan Luas SatuanLuas lahan 5000 m2Jumlah lantai 4 lantai
LuasLuas Bangunan 10283 m2Kamar (20) @floor 1800 m2Akses Jalan 900 m2tempat parkir (mobil & motor) 1500 m2mini market, cafe, kios (20) 500 m2receptionist 20 m2pos security 8 m2kantor pemasaran, musholla, toilet tamu 100 m2lift (2) 5 m2taman 50 m2
PENGELUARANHarga lahan keseluruhan KonstruksiKamar Rp 21,600,000,000 tempat parkir Rp 75,000,000 pos security Rp 1,600,000 Akses jalan Rp 180,000,000 kantor pemasaran dll Rp 100,000,000 mini market, cafe,kios Rp 1,000,000,000 receptionist Rp 20,000,000 taman Rp 10,000,000 Total Biaya konstruksiPeralatanLift Rp 100,000,000 Instalasi Listrik, TV & Air Rp 50,000,000 Alat Pemadam kebakaran Rp 50,000,000 Lampu Rp 25,000,000 Pintu, Jendela dll Rp 35,000,000 Kamar Mandi (Bath up, shower, closet, kran, wastafel) Rp 100,000,000 Dapur (Kompor, Lemari, Tempat cuci, microwave) Rp 80,000,000 Kamar tidur (kasur, lemari, AC, Meja, kursi) Rp 130,000,000 Ruang tamu (meja, kursi) Rp 70,000,000 Ruang tengah (AC, TV, Sofa) Rp 150,000,000 Ruang Makan(Meja, lemari, kursi) Rp 110,000,000 Total Biaya PeralatanTotal Biaya AdministrasiOperation & MaintenanceAdministrasi Rp 10,000,000 Kebersihan Rp 30,000,000 Listrik,Air,Kantor Rp 100,000,000 Iklan Rp 9,000,000
Kenaikan Biaya 2%Total Biaya O&MTOTAL BIAYA INVESTASI
PENGELUARAN PER TAHUNGaji Seluruh Pegawai Rp. 350,000,000 Total Biaya O&M Rp 149,000,000 Pajak Bumi Bangunan Rp 7,298,660,000 Cicilan ke bank Rp. 13,027,068,757 TOTAL PENGELUARAN
TARIFKamar standard (30) Rp 750,000 Kamar Deluxe (20) Rp 1,250,000 Kamar Junior suite (20) Rp 2,000,000 Kamar President suite (5) Rp 3,000,000 Sewa Kios Rp 100,000,000
PEMASUKANKamar standard (30) Rp 6,750,000,000 Kamar Deluxe (20) Rp 7,250,000,000 Kamar Junior suite (20) Rp 8,000,000,000 Kamar President suite (5) Rp 2,250,000,000 Parkir Rp 100,000,000 Sewa Kios Rp 2,000,000,000 TOTAL PEMASUKAN Rp 26,350,000,000
Kenaikan harga pertahun 10%
Guest House
panjang 100 lebar 50
Pembelian lahan Rp 10,000,000 /m27200
total
Rp 50,000,000,000
Rp 22,986,600,000 72,986,600,000
Rp 900,000,000 Rp 40,000,000
per tahunper tahunper tahunper tahun
Rp 149,000,000 pertahunRp 74,075,600,000
124,075,600,000 spv 1
per tahun staff 2pertahun receptionist 2pertahun security 3pertahunRp 20,824,728,757 pertahun
per hariper hariper hariper hariper tahun
per tahunper tahunper tahunper tahunpertahunper tahunper tahun
(Rp10,876,093,646.35)
10000000 per bulan 1200000005000000 per bulan 1200000003000000 per bulan 360000002000000 per bulan 72000000
348,000,000
hasil browsingkira2
CASHFLOWModal Awal Rp 50,000,000,000 Biaya Pembelian Tanah Rp 50,000,000,000 Pinjam ke Bank Rp 74,075,600,000
Salvage Value Rp 40,000,000,000Rencana investasi 15 tahun
Tahun Pengeluaran Pendapatan0 124,075,600,000 -1 20,827,708,757 28,985,000,000 2 20,830,748,357 31,883,500,000 3 20,833,848,749 35,071,850,000 4 20,837,011,149 38,579,035,000 5 20,840,236,797 42,436,938,500 6 20,843,526,957 46,680,632,350 7 20,846,882,921 51,348,695,585 8 20,850,306,005 56,483,565,144 9 20,853,797,550 62,131,921,658
10 20,857,358,926 68,345,113,824 11 20,860,991,529 75,179,625,206 12 20,864,696,784 82,697,587,727 13 20,868,476,145 90,967,346,499 14 20,872,331,093 100,064,081,149 15 20,876,263,139 150,070,489,264
IRR
ANALISIS IRRi=15%tahun P/F P
0 0 (124,075,600,000)1 0.8696 7,093,580,465 2 0.7561 8,356,985,517 3 0.6575 9,361,485,823 4 0.5718 10,144,889,238 5 0.4972 10,737,880,087 6 0.4323 11,169,380,661 7 0.3759 11,465,631,380 8 0.3269 11,648,512,412 9 0.2843 11,735,370,684
10 0.2472 11,738,973,011 11 0.2149 11,673,074,377 12 0.1869 11,556,567,317 13 0.1625 11,391,066,433 14 0.1413 11,189,794,283 15 0.1229 15,877,970,391
41,065,562,079
PAYBACK PERIODMARR 15%Ptotal Rp 648,161,197,047.20 (P/F,15%,n) 0.191427071792087n saat 0,434 11.8 tahun
MARR
Modal EquitasPinjaman dari BankTotal% Modal Equitas% Pinjaman dari BankBunga DepositoBunga BankWACC
NCF Profit (124,075,600,000) Resiko 8,157,291,243 MARR 11,052,751,643 14,238,001,251 Inflasi 17,742,023,851 MARR setelah inflasi 21,596,701,703 25,837,105,393 30,501,812,664 35,633,259,139 41,278,124,108 47,487,754,898 54,318,633,677 61,832,890,942 70,098,870,354 79,191,750,056 129,194,226,125
19%
i=20% tahun P/F P
0 0 (124,075,600,000)1 0.8333 6,797,470,793 2 0.6944 7,675,030,741 3 0.5787 8,239,531,324 4 0.4823 8,556,978,103 5 0.4019 8,679,714,415 6 0.3349 8,652,846,596 7 0.2791 8,513,055,914 8 0.2326 8,288,296,076 9 0.1938 7,999,700,452
10 0.1615 7,669,272,416 11 0.1346 7,311,288,093 12 0.1122 6,937,650,364 13 0.0935 6,554,244,378 14 0.0779 6,169,037,329 15 0.0649 8,384,705,275
(7,646,777,731)
IRR setelah diinterpolasi 19.21%
B/C Ratio i=19%Periode Keuntungan Benefit
1 8,157,291,243 Rp6,854,866,590.76 2 11,052,751,643 Rp7,805,064,361.98 3 14,238,001,251 Rp8,449,055,104.59 4 17,742,023,851 Rp8,847,392,881.31 5 21,596,701,703 Rp9,050,084,262.96 6 25,837,105,393 Rp9,098,338,454.97 7 30,501,812,664 Rp9,026,033,054.80 8 35,633,259,139 Rp8,860,941,208.70 9 41,278,124,108 Rp8,625,758,602.07
10 47,487,754,898 Rp8,338,962,556.70 11 54,318,633,677 Rp8,015,530,332.38 12 61,832,890,942 Rp7,667,539,382.63 13 70,098,870,354 Rp7,304,668,662.42 14 79,191,750,056 Rp6,934,617,017.89 15 129,194,226,125 Rp9,506,894,707.55
Rp124,385,747,181.71
Cost 124,075,600,000 BC Ratio 1.0025
Rp 50,000,000,000 Rp 74,075,600,000 Rp 124,075,600,000
40%60%
8%12%10%
4%1%
15%
7%23%
CASHFLOWModal Awal Rp 50,000,000,000 Biaya Pembelian Tanah Rp 50,000,000,000 Pinjam ke Bank Rp 74,075,600,000
Salvage Value Rp 40,000,000,000Rencana investasi 15 tahun
Pajak 25% menurut UU 17 Tahun 2000Tahun Pengeluaran Pendapatan
0 124,075,600,000 -1 20,827,708,757 28,985,000,000 2 20,830,748,357 31,883,500,000 3 20,833,848,749 35,071,850,000 4 20,837,011,149 38,579,035,000 5 20,840,236,797 42,436,938,500 6 20,843,526,957 46,680,632,350 7 20,846,882,921 51,348,695,585 8 20,850,306,005 56,483,565,144 9 20,853,797,550 62,131,921,658
10 20,857,358,926 68,345,113,824 11 20,860,991,529 75,179,625,206 12 20,864,696,784 82,697,587,727 13 20,868,476,145 90,967,346,499 14 20,872,331,093 100,064,081,149 15 20,876,263,139 150,070,489,264
ANALISIS IRRi=14%tahun P/F P
0 0 (124,075,600,000)1 0.8722 5,336,092,067 2 0.7695 6,378,819,292 3 0.675 7,207,988,133 4 0.5921 7,878,789,242 5 0.5194 8,412,995,149 6 0.4556 8,828,538,913 7 0.3996 9,141,393,255 8 0.3506 9,369,765,491 9 0.3075 9,519,767,372
10 0.2697 9,605,585,622 11 0.2366 9,638,841,546 12 0.2076 9,627,381,120 13 0.1821 9,573,753,219 14 0.1597 9,485,191,863 15 0.1401 13,575,083,310
9,504,385,592
PAYBACK PERIODMARR 15%Ptotal Rp 486,120,897,785.40 (P/F,22%,n) 0.255236095722783n saat 0,434 9.5 tahun
menurut UU 17 Tahun 2000CFBT TAX CFAT
(124,075,600,000) 0 (124,075,600,000) 8,157,291,243 2,039,322,811 6,117,968,432 11,052,751,643 2,763,187,911 8,289,563,732 14,238,001,251 3,559,500,313 10,678,500,938 17,742,023,851 4,435,505,963 13,306,517,888 21,596,701,703 5,399,175,426 16,197,526,277 25,837,105,393 6,459,276,348 19,377,829,044 30,501,812,664 7,625,453,166 22,876,359,498 35,633,259,139 8,908,314,785 26,724,944,354 41,278,124,108 10,319,531,027 30,958,593,081 47,487,754,898 11,871,938,725 35,615,816,174 54,318,633,677 13,579,658,419 40,738,975,258 61,832,890,942 15,458,222,736 46,374,668,207 70,098,870,354 17,524,717,589 52,574,152,766 79,191,750,056 19,797,937,514 59,393,812,542 129,194,226,125 32,298,556,531 96,895,669,594
IRR 15%
i=16% tahun P/F P
0 0 (124,075,600,000)1 0.8621 5,274,300,585 2 0.7432 6,160,803,766 3 0.6407 6,841,715,551 4 0.5523 7,349,189,830 5 0.4761 7,711,642,261 6 0.4104 7,952,661,040 7 0.3538 8,093,655,990 8 0.305 8,151,108,028 9 0.263 8,142,109,980
10 0.2267 8,074,105,527 11 0.1954 7,960,395,765 12 0.1685 7,814,131,593 13 0.1452 7,633,766,982 14 0.1252 7,436,105,330 15 0.1079 10,455,042,749
(9,024,865,023)
IRR setelah diinterpolasi 15.03%
B/C Ratio i=15%1 6,117,968,432 5,319,972,550 2 8,289,563,732 6,268,101,121 3 10,678,500,938 7,021,287,705 4 13,306,517,888 7,608,044,790 5 16,197,526,277 8,053,033,235 6 19,377,829,044 8,377,570,245 7 22,876,359,498 8,600,070,874 8 26,724,944,354 8,736,431,715 9 30,958,593,081 8,800,364,343
10 35,615,816,174 8,803,685,054 11 40,738,975,258 8,756,566,632 12 46,374,668,207 8,667,757,075 13 52,574,152,766 8,544,769,623 14 59,393,812,542 8,394,047,819 15 96,895,669,594 11,907,943,433
123,859,646,214 B//C ratio 1.0
MARR
Modal Equitas Rp 50,000,000,000 Pinjaman dari Bank Rp 74,075,600,000 Total Rp 124,075,600,000 % Modal Equitas 40%% Pinjaman dari Bank 60%Bunga Deposito 8%Bunga Bank 12%WACC 10%Profit 4%Resiko 1%MARR 15%
Inflasi 7%MARR setelah inflasi 23%
DEPRESIASIModal Awal Rp 50,000,000,000 Biaya Pembelian Tanah Rp 50,000,000,000 Pinjam ke Bank Rp 74,075,600,000
Salvage Value Rp 40,000,000,000Rencana investasi 15 tahun
Pajak 25% menurut UU 17 Tahun 2000Tahun Pengeluaran Pendapatan
0 124,075,600,000 -1 20,827,708,757 28,985,000,000 2 20,830,748,357 31,883,500,000 3 20,833,848,749 35,071,850,000 4 20,837,011,149 38,579,035,000 5 20,840,236,797 42,436,938,500 6 20,843,526,957 46,680,632,350 7 20,846,882,921 51,348,695,585 8 20,850,306,005 56,483,565,144 9 20,853,797,550 62,131,921,658
10 20,857,358,926 68,345,113,824 11 20,860,991,529 75,179,625,206 12 20,864,696,784 82,697,587,727 13 20,868,476,145 90,967,346,499 14 20,872,331,093 100,064,081,149 15 20,876,263,139 150,070,489,264
ANALISIS IRRi=15%tahun P/F P
0 0 (124,075,600,000)1 0.8696 6,625,759,309 2 0.7561 7,402,909,873 3 0.6575 8,008,251,992 4 0.5718 8,467,138,859 5 0.4972 8,799,881,285 6 0.4323 9,026,069,101 7 0.3759 9,163,581,000 8 0.3269 9,227,175,624 9 0.2843 9,228,361,818
10 0.2472 9,175,363,478 11 0.2149 9,077,445,898 12 0.1869 8,948,027,803 13 0.1625 8,787,269,199 14 0.1413 8,604,486,467 15 0.1229 12,092,993,708
8,559,115,414
PAYBACK PERIODMARR 15%Ptotal Rp 508,641,147,785.40 (P/F,22%,n) 0.243935435700039n saat 0,434 10 tahun
dt 0.0714285714285714D 6,005,400,000
menurut UU 17 Tahun 2000CFBT Depresiasi CFBT - D TAX
(124,075,600,000) 0 (124,075,600,000) 0 8,157,291,243 6,005,400,000 2,151,891,243 537,972,811 11,052,751,643 6,005,400,000 5,047,351,643 1,261,837,911 14,238,001,251 6,005,400,000 8,232,601,251 2,058,150,313 17,742,023,851 6,005,400,000 11,736,623,851 2,934,155,963 21,596,701,703 6,005,400,000 15,591,301,703 3,897,825,426 25,837,105,393 6,005,400,000 19,831,705,393 4,957,926,348 30,501,812,664 6,005,400,000 24,496,412,664 6,124,103,166 35,633,259,139 6,005,400,000 29,627,859,139 7,406,964,785 41,278,124,108 6,005,400,000 35,272,724,108 8,818,181,027 47,487,754,898 6,005,400,000 41,482,354,898 10,370,588,725 54,318,633,677 6,005,400,000 48,313,233,677 12,078,308,419 61,832,890,942 6,005,400,000 55,827,490,942 13,956,872,736 70,098,870,354 6,005,400,000 64,093,470,354 16,023,367,589 79,191,750,056 6,005,400,000 73,186,350,056 18,296,587,514 129,194,226,125 6,005,400,000 123,188,826,125 30,797,206,531
IRR
i=20% tahun P/F P
0 0 (124,075,600,000)1 0.8333 6,349,178,050 2 0.6944 6,798,810,496 3 0.5787 7,048,479,738 4 0.4823 7,141,834,683 5 0.4019 7,113,178,376 6 0.3349 6,992,437,062 7 0.2791 6,803,818,721 8 0.2326 6,565,436,067 9 0.1938 6,290,736,969
10 0.1615 5,994,422,337 11 0.1346 5,685,547,780 12 0.1122 5,371,689,243 13 0.0935 5,056,059,509 14 0.0779 4,743,733,162 15 0.0649 6,385,966,572
(29,734,271,238)
IRR setelah diinterpolasi 16.12%
B/C ratio i=16%Periode CFAT Benefit
1 7,619,318,432 6,568,377,959 2 9,790,913,732 7,276,243,856 3 12,179,850,938 7,803,114,966 4 14,807,867,888 8,178,253,613 5 17,698,876,277 8,426,665,354 6 20,879,179,044 8,569,697,323 7 24,377,709,498 8,625,553,491 8 28,226,294,354 8,609,738,329 9 32,459,943,081 8,535,438,764
10 37,117,166,174 8,413,852,978 11 42,240,325,258 8,254,473,397 12 47,876,018,207 8,065,330,206 13 54,075,502,766 7,853,200,870 14 60,895,162,542 7,623,790,349 15 98,397,019,594 10,619,696,509
123,423,427,964 B/C ratio 1.0
MARR
Modal EquitasPinjaman dari BankTotal% Modal Equitas% Pinjaman dari BankBunga DepositoBunga BankWACC
CFAT Profit (124,075,600,000) Resiko 7,619,318,432 MARR 9,790,913,732 12,179,850,938 Inflasi 14,807,867,888 MARR setelah inflasi 17,698,876,277 20,879,179,044 24,377,709,498 28,226,294,354 32,459,943,081 37,117,166,174 42,240,325,258 47,876,018,207 54,075,502,766 60,895,162,542 98,397,019,594
16%
Rp ###Rp ###Rp ###
40%60%
8%12%10%
4%1%
15%
7%23%
ANALISIS SENSITIVITAS
Perubahan Pw-0.5 Rp69,792,525,000
-0.25 Rp93,056,700,0000 Rp124,075,600,000
0.25 Rp155,094,500,0000.5 Rp193,868,125,000
Menggunakan metode PW Pw-0.5 Rp492,471,067,841
-0.25 Rp515,735,242,8410 Rp546,754,142,841
0.25 Rp577,773,042,8410.5 Rp616,546,667,841
Variabel (berdasarkan Analysis Sensitivity PW Method) yang paling sensitif = MARR
Variabel (berdasarkan Analysis Sensitivity PW Method) yang tidak sensitif = Biaya Investasi & Pengeluaran
-0.6 -0.4 -0.2 0 0.2 0.4 0.6Rp0
Rp100,000,000,000
Rp200,000,000,000
Rp300,000,000,000
Rp400,000,000,000
Rp500,000,000,000
Rp600,000,000,000
Rp700,000,000,000
Rp800,000,000,000
Rp900,000,000,000
PWPengeluaranPemasukanLifeMARR
Pengeluaran Pemasukan n (life) MARR (i)Rp11,728,656,932 Rp36,034,701,821 8 8%Rp15,638,209,243 Rp48,046,269,095 11 11%Rp20,850,945,657 Rp64,061,692,127 15 15%Rp26,063,682,071 Rp80,077,115,159 19 19%Rp32,579,602,589 Rp100,096,393,948 23 23%
Pengeluaran Pemasukan n(life) MARR (i)Rp501,345,169,498 Rp407,241,253,692 Rp417,874,526,870 Rp772,260,700,686Rp520,806,158,073 Rp467,032,491,899 Rp498,824,803,974 Rp658,173,431,775Rp546,754,142,841 Rp546,754,142,841 Rp546,754,142,841 Rp546,754,142,841Rp572,702,127,609 Rp626,475,793,784 Rp575,132,322,712 Rp466,742,815,408Rp605,137,108,569 Rp726,127,857,462 Rp591,934,580,198 Rp407,681,276,682
Variabel (berdasarkan Analysis Sensitivity PW Method) yang paling sensitif = MARR
Variabel (berdasarkan Analysis Sensitivity PW Method) yang tidak sensitif = Biaya Investasi & Pengeluaran
-0.6 -0.4 -0.2 0 0.2 0.4 0.6Rp0
Rp100,000,000,000
Rp200,000,000,000
Rp300,000,000,000
Rp400,000,000,000
Rp500,000,000,000
Rp600,000,000,000
Rp700,000,000,000
Rp800,000,000,000
Rp900,000,000,000
PWPengeluaranPemasukanLifeMARR