Reference no: EM13885471
Calculating Mutually Exclusive Projects
Trail Guides, Inc., is currently evaluating two mutually exclusive investment. After doing a scenario analysis and applying probabilities to each scenario, they have determined that the investments have the following distributions around the expected NPVs.
Profitability NPV A NPV B
15% -$40,000 -$15,000
20% -10,000 2,500
30% 20,000 20,000
20% 50,000 37,500
15% 80,000 55,000
Several members of the management team have suggested that Project A should be selected because it has a higher potential NPV. Other members have suggested that Project B appears to be more conservative and should be selected. They have asked you to resolve this question.
a. Calculate the expected NPV for both projects. Can the question be resolved with this information alone?
b. Calculate the variance and standard deviation of the NPVs for both projects. Which project appears to be riskier?
c. Calculate the coefficient of variation for both projects. Does this change your opinion from part b?
d. Calculate the probability of a negative NPV for both projects.
e. Which project should be accepted?
Solutions in Excel Format
|
Shareholders are happy with the existing management
: Which of the following can cause a project to have multiple IRRs? The project has a large initial outlay. B) A ten-year project requires an initial investment and has a negative cash flow in the last year of the project's life. Which one of the follo..
|
|
Cause a project to have multiple irrs
: Which of the following can cause a project to have multiple IRRs?
|
|
Difference in weighted-average cost of capital-pre-tax wacc
: The difference between the weighted-average cost of capital (WACC) and the pre-tax (unlevered) WACC is
|
|
About the liquidity ratio
: Josh Smith has compiled some of his personal financial data in order to determine his liquidity position. Calculate Josh’s liquidity ratio. Several of Josh’s friends have told him that they have liquidity ratios of about 1.8. How would you analyze Jo..
|
|
Calculating mutually exclusive projects
: Trail Guides, Inc., is currently evaluating two mutually exclusive investment. After doing a scenario analysis and applying probabilities to each scenario, they have determined that the investments have the following distributions around the expected..
|
|
Stock prices of the banned stocks in the ban period
: On the other hand, Nguyen and Tang (2009) find that- The 2008 short-sale ban has a ________ (positive or negative or no) impact on the stock prices of the banned stocks in the ban period.
|
|
Maturity equal to our investment horizon
: U.S. Treasuries are never subject to interest rate risk unless we select a maturity equal to our investment horizon. Many practitioners analyze other financial characteristics of a firm, when they forecast betas. When using historical returns to fore..
|
|
Raise additional capital to fund its upcoming expansion
: Klose Outfitters Inc. believes that its optimal capital structure consists of 70% common equity and 30% debt, and its tax rate is 40%. Klose must raise additional capital to fund its upcoming expansion.
|
|
Positive alphas if the market portfolio is not efficient
: The book-to-market is the observation that firms with high book-to-market ratios have positive alphas. Portfolios with high market capitalizations will have positive alphas if the market portfolio is not efficient. Portfolios with low book-to-market ..
|