I need to know how to calculate this problem using excel. A model is also on the sheet that can be used as a guide. The numbers in the model have nothing to do with the problem.
The Seattle Corporation has been presented with an investment opportunity which will yield end-of-year cash flows of $30,000 per year in Years 1 through 4, $35,000 per year in Years 5 through 9, and $40,000 in Year 10.
The investment will cost the firm $150,000 today, and the firm's cost of capital is 10 percent.
a. What is the payback period, discounted payback period, npv, IRR, and MIRR for this investment?
b. Should the project be accepted or rejected?
This job calculates this problem using excel.