Question: Below, I am including the projected cash flows for a long term capital project. The project has the following cash flows (negative numbers represent cash
Below, I am including the projected cash flows for a long term capital project. The project has the following cash flows (negative numbers represent cash outflows and positive numbers represent cash inflows):
•YR 0 = -$50 Million
•YR 1 = $7 Million
•YR 2 = $7 Million
•YR 3 = $7 Million
•YR 4 = $7 Million
•YR 5 = $10 Million
•YR 6 = $10 Million
•YR 7 = $10 Million
•YR 8 = $12 Million
•YR 9 = $12 Million
•YR 10 = $12 Million
Plus the company stops the projects and sells off the project for an additional $16 Million inflow. Thus, total inflows at year ten equals $28 Million. The company wishes to earn 12% on this project (here, we assume the company computed its cost of capital at 12%). Compute the NPV and IRR for the above project. You can turn in an excel sheet for this assignment. As an alternative, you can turn in a word file (if you turn in a word file show your work). Regardless, this assignment only requires you to turn in one file.
Step by Step Solution
3.39 Rating (152 Votes )
There are 3 Steps involved in it
Computation of the Net Present Value and IRR Rate 12 Alternative Metho... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
68-B-M-A-F-S-A (1265).xlsx
300 KBs Excel File
