Please answer question 4 (NPV, What is the decision?)

Dik Details Details Theme Park Initial Investment Tanah Bangunan Wahana Infrastructur Support Total Initial Investment Usia pakai Theme Park Tax Scenario Revenue Price Quantity Cost FC VC Depreciation - Straight Line OCF per year NWC SV After Tax SV D/E Ratio Bunga Bank Tax Dalam Miliar IDR 50 25 100 20 195 20 25% Normal 50 500000 100000 15 5 10 9.75 28.6875 50 100 75 75% 10% 25% M Tahun M per tahun Rupiah Lembar M per tahun M per tahun M per tahun M Per tahun M Per tahun M di awal periode M di akhir periode M di akhir periode ini NCS Optimis 75 M per tahun 750000 Rupiah 100000 Lembar 18.75 M per tahun 7.5 M per tahun 11.25 M per tahun 9.75 M per tahun 44.625 M Per tahun 40 110 82.5 100% 8% 25% M di awal periode M di akhir periode M di akhir periode Pesimis 35 M per 350000 Rupiah 100000 Lemba 12.25 3.5 8.75 9.75 M per tahun M per tahun M per tahun M per tahun 19.5 M Per tahun 60 90 67.5 50% 12% 25% M di M di M di Tax Shield Approach OCF (Sales-Costs) (1-T) + Depreciation*T After-tax salvage = salvage - T*(salvage - book value) O + 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 60 List pertanyaan D/E Ratio Bunga Bank Tax 10 year Gov Bond Beta - Project Expected Market return Next year Dividend Dividend growth rate Market Cap Cost of Equity SML GGM Average Cost of Debt % Debt % Equity Tax Cost of Capital 75% 10% 25% 5% 1.2 15% 30 5% 500 17.0% 11.0% 14.0% 10% 42.9% 57.1% 25% 11.2% M M 100% 8% 25% 3 NPV, What is the decision? 4 IRR, What is the decision compare to cost of capital? 5 Bayback Dorind What is the decision if the company.onl 5% 1 18% 30 M 7% 600 M 18.0% 12.0% 15.0% 8% 50.0% 50.0% 25% 10.5% Berdasarkan scenario Analysis, hitunglah untuk masing-masing dan buatlah pitch deck untuk investor pitch: 1 Average Cost of Equity using SML & Gordon Growth Model Done Done 2 Cost of Capital 50% 12% 25% 5% 1.5 12% 30 M 4% 400 M 15.5% 11.5% 13.5% 12% 33.3% 66.7% 25% 12.0% project with sviumum 15 year payback period? CON AST PAR IN THE pas gran IN 1 BIC + 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 List pertanyaan Tax Cost of Capital NCS OCF NWC After tax SV CFFA NPV Normal IRR 25% 11.2% Berdasarkan scenario Analysis, hitunglah untuk masing-masing dan buatlah pitch deck untuk investor pitch: 1 Average Cost of Equity using SML & Gordon Growth Model Done Done 2 Cost of Capital 3 NPV, What is the decision? 4 IRR, What is the decision compare to cost of capital? 5 Payback Period - What is the decision if the company only accept project with maxiumum 15 years payback period? 6 Discounted Payback Period - What is the decision if the company only accept project with maximum 18 years discounted payback period? Buat di dalam word, PPT dan Excel untuk report dan materi presentasi (Video max 20 menit) NCS OCF NWC After tax SV CFFA 0 0 0.00 #NUM! 0 0 0 0 1 2 0 1 2 25% 10.5% 0 0 0 3 3 Normal 4 0 Pesimis 4 0 5 25% 12.0% 5 0 0 0 6 6 0 0 0 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0000000000000 7 8 9 10 11 12 13 14 15 16 17 18 19 BE L 0000000000000 8 + 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 NPV Normal IRR NCS OCF NWC After tax SV CFFA NPV Optimis IRR NCS OCF NWC After tax SV CFFA NPV Pesimis IRR 0.00 #NUM! 0 0 0.00 #NUM! 0 0 0.00 #NUM! 0 0 Payback + Discounted Payback Period liat template dr bapanya 1 2 0 1 2 0 0 0 3 3 Pesimis 4 0 Optimis 4 0 5 0 5 0 6 0 6 0 0 0 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0000000000000 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0000000000000 Batang 8 + Dik Details Details Theme Park Initial Investment Tanah Bangunan Wahana Infrastructur Support Total Initial Investment Usia pakai Theme Park Tax Scenario Revenue Price Quantity Cost FC VC Depreciation - Straight Line OCF per year NWC SV After Tax SV D/E Ratio Bunga Bank Tax Dalam Miliar IDR 50 25 100 20 195 20 25% Normal 50 500000 100000 15 5 10 9.75 28.6875 50 100 75 75% 10% 25% M Tahun M per tahun Rupiah Lembar M per tahun M per tahun M per tahun M Per tahun M Per tahun M di awal periode M di akhir periode M di akhir periode ini NCS Optimis 75 M per tahun 750000 Rupiah 100000 Lembar 18.75 M per tahun 7.5 M per tahun 11.25 M per tahun 9.75 M per tahun 44.625 M Per tahun 40 110 82.5 100% 8% 25% M di awal periode M di akhir periode M di akhir periode Pesimis 35 M per 350000 Rupiah 100000 Lemba 12.25 3.5 8.75 9.75 M per tahun M per tahun M per tahun M per tahun 19.5 M Per tahun 60 90 67.5 50% 12% 25% M di M di M di Tax Shield Approach OCF (Sales-Costs) (1-T) + Depreciation*T After-tax salvage = salvage - T*(salvage - book value) O + 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 60 List pertanyaan D/E Ratio Bunga Bank Tax 10 year Gov Bond Beta - Project Expected Market return Next year Dividend Dividend growth rate Market Cap Cost of Equity SML GGM Average Cost of Debt % Debt % Equity Tax Cost of Capital 75% 10% 25% 5% 1.2 15% 30 5% 500 17.0% 11.0% 14.0% 10% 42.9% 57.1% 25% 11.2% M M 100% 8% 25% 3 NPV, What is the decision? 4 IRR, What is the decision compare to cost of capital? 5 Bayback Dorind What is the decision if the company.onl 5% 1 18% 30 M 7% 600 M 18.0% 12.0% 15.0% 8% 50.0% 50.0% 25% 10.5% Berdasarkan scenario Analysis, hitunglah untuk masing-masing dan buatlah pitch deck untuk investor pitch: 1 Average Cost of Equity using SML & Gordon Growth Model Done Done 2 Cost of Capital 50% 12% 25% 5% 1.5 12% 30 M 4% 400 M 15.5% 11.5% 13.5% 12% 33.3% 66.7% 25% 12.0% project with sviumum 15 year payback period? CON AST PAR IN THE pas gran IN 1 BIC + 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 List pertanyaan Tax Cost of Capital NCS OCF NWC After tax SV CFFA NPV Normal IRR 25% 11.2% Berdasarkan scenario Analysis, hitunglah untuk masing-masing dan buatlah pitch deck untuk investor pitch: 1 Average Cost of Equity using SML & Gordon Growth Model Done Done 2 Cost of Capital 3 NPV, What is the decision? 4 IRR, What is the decision compare to cost of capital? 5 Payback Period - What is the decision if the company only accept project with maxiumum 15 years payback period? 6 Discounted Payback Period - What is the decision if the company only accept project with maximum 18 years discounted payback period? Buat di dalam word, PPT dan Excel untuk report dan materi presentasi (Video max 20 menit) NCS OCF NWC After tax SV CFFA 0 0 0.00 #NUM! 0 0 0 0 1 2 0 1 2 25% 10.5% 0 0 0 3 3 Normal 4 0 Pesimis 4 0 5 25% 12.0% 5 0 0 0 6 6 0 0 0 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0000000000000 7 8 9 10 11 12 13 14 15 16 17 18 19 BE L 0000000000000 8 + 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 NPV Normal IRR NCS OCF NWC After tax SV CFFA NPV Optimis IRR NCS OCF NWC After tax SV CFFA NPV Pesimis IRR 0.00 #NUM! 0 0 0.00 #NUM! 0 0 0.00 #NUM! 0 0 Payback + Discounted Payback Period liat template dr bapanya 1 2 0 1 2 0 0 0 3 3 Pesimis 4 0 Optimis 4 0 5 0 5 0 6 0 6 0 0 0 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0000000000000 7 8 9 10 11 12 13 14 15 16 17 18 19 20 0000000000000 Batang 8 +