Montrose Manufacturing is considering two potential investments. Each project will cost $115,000 and have an expected life of five years. The CFO has estimated the probability distributions for each projects cash flows as shown in the following table:

Potential Cash Flows Probability Project 1 Project 2 30% $21,600 $13,500 40% 42,126 40,500 30% 53,591 67,890

The company believes that the probability distributions apply to each year of the five years of the projects lives. Montrose Manufacturing uses the risk-adjusted discount rate technique to evaluate potential investments. As a guide for assigning the risk premiums, the CFO has put together the following table based on the coefficient of variation.

Coefficient of Variation Risk Premium 0.00 1.30% 0.20 0.00% 0.30 0.50% 0.40 1.50% 0.50 2.00%

Calculate the expected cash flows, standard deviation, and coefficient of variation for each project.

If the firms WACC for average risk projects is 10%, what is the appropriate risk-adjusted discount rate for each project?

Use the VLookup function to calculate the project WACC. Using the appropriate discount rates, calculate the payback period, discounted payback period, NPV, PI, IRR, and MIRR for each project.

If the projects are mutually exclusive, which should be accepted? What if they are independent?

Please set up like this

Cash flows Schedule of risk premiums Probability Project 1 Project 2 CV Risk premium Cash flow Standard deviation Coefficient of variation Cash flows period Project 1 Project 2 0 1 2 3 4 5 Corporat WACC 10% Project WACC Payback Discounted payback NPV Profitability IRR MIRR