Question
A company is considering the purchase of new equipment with an expected life of five years. The equipment requires an initial investment of $44,500,000. The
A company is considering the purchase of new equipment with an expected life of five years. The equipment requires an initial investment of $44,500,000. The expected inflows, outflow, and certainty equivalent coefficients (CEC) are given in the table below. The historical average stock market return is 10.90%, the return on U.S. Treasury bond is 5 percent (risk-free rate), and the beta coefficient of the division is 1.76.
Year | Expected Cash flow | CEC |
0 | -$44,500,000.00 | 100% |
1 | $21,000,000.00 | 88% |
2 | $20,500,000.00 | 81% |
3 | $19,000,000.00 | 79% |
4 | $18,500,000.00 | 71% |
5 | $17,800,000.00 | 69% |
What is the risk adjusted NPV of the project based on certainty equivalent approach.
PLEASE USE EXCEL AND SHOW SCREENSHOT OF ALL EXCEL FUNCTIONS
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started