80.2K

Verified Solution

Link Copied!

Evaluate the 10 projects given by NPV, IRR, PI and Discounted Payback methods. Identify if they are acceptable or should be rejected. Finally, rank each method appropriately. You should use a hurdle rate of 18% and utilize 6 years as maximum payback years. Verify you have entered these factors into the appropriate box in the model so the results will calculate accurately for you. Remember you should only rank ACCEPTABLE projects-ranking unacceptable projects is incorrect and a deduction in your score. If a Payback project never pays off, you may simply indicate "Never" in the documentation grid; otherwise the model will indicate the payback results. Using the results of your above analysis, various information elements will feed the problem section dealing with capital rationing. Finish the problem by identifying which projects should be done by management with the given capital budget of S142,000,000. Project Year Project Cash Flow 1.00 Capital Budgeting Evaluation Methods Discounted Discounted Payback Minimum Accept or PVIES Cash Flow Payback Years Payback Yrs Relect 1.0000 0.8475 6 Accept 0.7182 6 Accept 0.6086 6 Accept 0.5158 6 Accept 0.4371 6 Accept 0.3704 6 Accept 0.3139 6 Reject 0.2560 6 Reject 0.2255 6 Reject 0.1911 6 Reject 10.00 Payback Yrs Total Outflows Total Inflows Net Present Value Hurdle rate 1800 UNUMI Profit Index #DIV/0! Project 1 (32.000.000) Project 10 (35,600,000) 5.000.000 6,000,000 8.000.000 10,000,000 16,000,000 18.000.000 6.000.000 Project 2 19,200,000) (150.000 700,000 1.100.000 2.500.000 2,700,000 2.700.000 100 900 000 Project Project (1.500,000) 196,000,000) (150.000) 5,000,000 (100,000) 10,000,000 (50,000) 59.900,000 500,000 45,000,000 770,000 24,000,000 790,000 24,000,000 490,000 18,000,000 530,000 14.000.000 700,000 16,000,000 900,000 14,000,000 Problem 120 Points Project (75,000,000) 12,500,000 13.900,000 14,000,000 14,000,000 14,000,000 14,000,000 14,000,000 14.000.000 14,000,000 14,000,000 Project 6 (30,000,000) 2.000.000 5.000.000 7,000,000 9,000000 12,000,000 16,000,000 20,000,000 22,000,000 24,000,000 10,000,000 Project (14,800,000) 1,000,000 800,000 600,000 400.000 200,000 5.000.000 9,000,000 5.000.000 7.000000 8,550,000 Projects (17,000,000) 2,000,000 3.500.000 3,500,000 2.800.000 2,640,000 2,580,000 2.000.000 8.000.000 12.000.000 18,000,000 Project (28,000,000) 6.250.000 5,250,000 6,250,000 6.250.000 6,250,000 5,950,000 5,950,000 5.950.000 5.950,000 5.950,000 6.000.000 7,000,000 500.000 9,500,000 10,700,000 11,700,000 13.480.000 14.540,000 16,700,000 300 Type your name here Document your answers in this section as you process each project, using the project numbers from directly above Year Project 1 Project 2 Project 3 Project 4 Projects Project 6 Project 7 Project 8 Project 9 Project 10 Investment (32,000,000) 19,200,000) (1,500,000) (96,000,000) 175,000,000) (30,000,000) (14,800,000) (17,000,000) (28,000,000) (35,600,000) NPV 5 A/R 1 IRR A/R 47 Rank 49 Disc Payback AR Rank 51 52 Capital Rationing Problem - Available Capital Budget $142,000,000. Identify in the include/exclude columns which project to include in the current year given the available budget $'s Project Project Cost - Yo NPV Accept/Reject NPV Rank Include/ Exclude Budget Available Information imported from Problem # 2 Type Type X $ 142,000,000 (32,000,000) $ 142,000,000 19,200,000) $ 142,000,000 (1,500,000) $ 142,000,000 (96,000,000) $ 142,000,000 (75,000,000) $ 142,000,000 (30,000,000) $ 142,000,000 (14,800,000) $ 142,000,000 (17,000,000) $ 142,000,000 (28,000,000) $ 142,000,000 (35,600,000) $ 142,000,000 ou

Answer & Explanation Solved by verified expert

See Answer