guest house ekotek

33
Penggunaan Luas Luas lahan 5000 Jumlah lantai 4 Luas Luas Bangunan 10283 Kamar (20) @floor 1800 Akses Jalan 900 tempat parkir (mobil & motor) 1500 mini market, cafe, kios (20) 500 receptionist 20 pos security 8 kantor pemasaran, musholla, toilet tamu 100 lift (2) 5 taman 50 PENGELUARAN Harga lahan keseluruhan Konstruksi Kamar Rp tempat parkir Rp pos security Rp Akses jalan Rp kantor pemasaran dll Rp mini market, cafe,kios Rp receptionist Rp taman Rp Total Biaya konstruksi Peralatan Lift Rp Instalasi Listrik, TV & Air Rp Alat Pemadam kebakaran Rp Lampu Rp Pintu, Jendela dll Rp Kamar Mandi (Bath up, shower, closet, kran, wastaf Rp Dapur (Kompor, Lemari, Tempat cuci, microwave) Rp Kamar tidur (kasur, lemari, AC, Meja, kursi) Rp Ruang tamu (meja, kursi) Rp Ruang tengah (AC, TV, Sofa) Rp Ruang Makan(Meja, lemari, kursi) Rp Total Biaya Peralatan Total Biaya Administrasi Operation & Maintenance Administrasi Rp

Upload: letnan-winter

Post on 13-Dec-2015

241 views

Category:

Documents


4 download

DESCRIPTION

tugas besar ekotek

TRANSCRIPT

Page 1: Guest House ekotek

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

Page 2: Guest House ekotek

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%

Page 3: Guest House ekotek

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

Page 4: Guest House ekotek

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

Page 5: Guest House ekotek
Page 6: Guest House ekotek

(Rp10,876,093,646.35)

10000000 per bulan 1200000005000000 per bulan 1200000003000000 per bulan 360000002000000 per bulan 72000000

348,000,000

hasil browsingkira2

Page 7: Guest House ekotek
Page 8: Guest House ekotek

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

Page 9: Guest House ekotek

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

Page 10: Guest House ekotek

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

Page 11: Guest House ekotek

(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

Page 12: Guest House ekotek

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%

Page 13: Guest House ekotek

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

Page 14: Guest House ekotek

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

Page 15: Guest House ekotek

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

Page 16: Guest House ekotek

(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

Page 17: Guest House ekotek

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%

Page 18: Guest House ekotek

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

Page 19: Guest House ekotek

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

Page 20: Guest House ekotek

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

Page 21: Guest House ekotek

(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

Page 22: Guest House ekotek

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%

Page 23: Guest House ekotek

Rp ###Rp ###Rp ###

40%60%

8%12%10%

4%1%

15%

7%23%

Page 24: Guest House ekotek

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

Page 25: Guest House ekotek

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