Question 3: Juhayna Food Industries is attempting to select the best of three mutually exclusive projects. The initial investment and after-tax cash inflows associated with these projects are shown in...



Question 3:


Juhayna Food Industries is attempting to select the best of three mutually exclusive projects.


The initial investment and after-tax cash inflows associated with these projects are shown in the following table.
















































Cash flow



Project A



Project B



Project C



Initial Investment



100000



120,000



130,000



Year 1 Cash Inflows



30000



36,500



38000



Year 2 cash inflows



35000



45000



20000



Year 3 cash inflows



40000



40000



42000



Year 4 cash inflows



38000



35000



45000



Year 5 cash inflows



20000



30000



50000



  Taking into consideration that the cost of debt 7% , cost of preferred stock 12% and cost of new common stock 15%. The weight of each source of capital are long term debt 30% , preferred stock 20% and common stock equity 50%.



TO dO


Create a spreadsheet to answer the following questions:



  1. Calculate the firm‘s cost of capital ( WACC)

  2. Calculate the payback period for each project.

  3. Calculate the net present value (NPV) of each project,

  4. Calculate the internal rate of return (IRR) for each project.

  5. Discuss any conflict in ranking that may exist between NPV and IRR.

  6. Summarize the preferences dictated by each measure, and indicate which project you would recommend. Explain why




Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here