Question
Please perform the solution in excel. The answers to the question are a. -19 million and b. 9.0981 million according to the answers in the
Please perform the solution in excel. The answers to the question are a. -19 million and b. 9.0981 million according to the answers in the back of my book. I just need help getting to the solution.
Hart Lumber is considering the purchase of a paper company. Purchasing the company would require an initial investment of $300 million. Hart estimates that the paper company would provide net cash flows of $40 million at the end of each of the next 20 years. The cost of capital for the paper company is 13 percent.
Should Hart purchase the paper company?
While Hart"s best guess is that cash flows will be $40 million a year, it recognizes that there is a 50 percent chance the cash flows will be $50 million a year, and a 50 percent chance that the cash flows will be $30 million a year. One year from now, it will find out whether the cash flows will be $30 million or $50 million. In addition, Hart also recognizes that if it wanted, it could sell the company at Year 3 for $280 million. Given this additional information, does using decision tree analysis indicate that it makes sense to purchase the paper company?
Again, assume that all cash flows are discounted at 13 percent.
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