Montrose Manufacturing is considering two potential investments. Each project will cost $70,000 and have an expected life

Question:

Montrose Manufacturing is considering two potential investments. Each project will cost $70,000 and have an expected life of five years. The CFO has estimated the probability distributions for each project's cash flows as shown in the following table.
Potential cash Flows
Probability Project 1 Project 2
25% ..............................$12,000.....................$10,000
50% ................................27,000...................... 30,000
25%......................................... .36,000...................... 46,000
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.50%
0.20......................................................... 0.00%
0.30......................................................... 1.00%
0.40......................................................... 1.50%
0.50.......................................................... 2.50%
a. Calculate the expected cash flows, standard deviation, and coefficient of variation for each project.
b. If the firm's 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.
c. Using the appropriate discount rates, calculate the payback period, discounted payback period, NPV, PI, IRR, and MIRR for each project.
d. If the projects are mutually exclusive, which should be accepted? What if they are independent?
Discount Rate
Depending upon the context, the discount rate has two different definitions and usages. First, the discount rate refers to the interest rate charged to the commercial banks and other financial institutions for the loans they take from the Federal...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Financial Analysis with Microsoft Excel

ISBN: 978-1111826246

6th edition

Authors: Timothy R. Mayes, Todd M. Shank

Question Posted: