You have just started your summer internship, and your boss asks you to review a recent analysis that was done to compare three alternative proposals to enhance the firm's manufacturing facility. You find that the prior analysis ranked the proposals according to their IRR, and recommended the highest IRR option, Proposal A. You are concerned and decide to redo the analysis using NPV to determine whether this recommendation was appropriate. But while you are confident the IRRs were computed correctly, it seems that some of the underlying data regarding the cash flows that were estimated for each proposal was not included in the report. For Proposal B, you cannot find information regarding the total initial investment that was required in Year 0. And for Proposal C, you cannot find the data regarding additional salvage value that will be recovered in Year 3. Here is the information you have (in $ millions): . Suppose the appropriate cost of capital for each alternative is 10%. Using this information, determine the NPV of each proposal. Which project should the firm choose? Why is ranking the projects by their IRR not valid in this situation? Fill in the missing values ($ millions). (Round to two decimal places.) Proposal IRR Year 0 Year 1 Year 2 Year 3 A 60.00% - $100 $30 $153 $88 B 59.15% $0 $206 $95 C 59.93% - $100 $37 $0

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter5: Probability: An Introduction To Modeling Uncertainty
Section: Chapter Questions
Problem 7P: The Human Resources Manager for Optilytics LLC is evaluating applications for the position of Senior...
icon
Related questions
Question
You have just started your summer internship, and your boss asks you to review a recent analysis that was done to compare three
alternative proposals to enhance the firm's manufacturing facility. You find that the prior analysis ranked the proposals according to
their IRR, and recommended the highest IRR option, Proposal A. You are concerned and decide to redo the analysis using NPV to
determine whether this recommendation was appropriate. But while you are confident the IRRs were computed correctly, it seems
that some of the underlying data regarding the cash flows that were estimated for each proposal was not included in the report. For
Proposal B, you cannot find information regarding the total initial investment that was required in Year 0. And for Proposal C, you
cannot find the data regarding additional salvage value that will be recovered in Year 3. Here is the information you have (in
$ millions):
Suppose the appropriate cost of capital for each alternative is 10%. Using this information, determine the NPV of each proposal.
Which project should the firm choose? Why is ranking the projects by their IRR not valid in this situation?
Fill in the missing values ($ millions). (Round to two decimal places.)
Proposal
IRR
Year 0
Year 1
Year 2
Year 3
A
60.00%
- $100
$30
$153
$88
B
59.15%
$
$0
$206
$95
C
59.93%
- $100
$37
$0
$
Transcribed Image Text:You have just started your summer internship, and your boss asks you to review a recent analysis that was done to compare three alternative proposals to enhance the firm's manufacturing facility. You find that the prior analysis ranked the proposals according to their IRR, and recommended the highest IRR option, Proposal A. You are concerned and decide to redo the analysis using NPV to determine whether this recommendation was appropriate. But while you are confident the IRRs were computed correctly, it seems that some of the underlying data regarding the cash flows that were estimated for each proposal was not included in the report. For Proposal B, you cannot find information regarding the total initial investment that was required in Year 0. And for Proposal C, you cannot find the data regarding additional salvage value that will be recovered in Year 3. Here is the information you have (in $ millions): Suppose the appropriate cost of capital for each alternative is 10%. Using this information, determine the NPV of each proposal. Which project should the firm choose? Why is ranking the projects by their IRR not valid in this situation? Fill in the missing values ($ millions). (Round to two decimal places.) Proposal IRR Year 0 Year 1 Year 2 Year 3 A 60.00% - $100 $30 $153 $88 B 59.15% $ $0 $206 $95 C 59.93% - $100 $37 $0 $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning