Please see attached documents to complete assignment. Work Must be Shown.
The Capital Project Case Study, Part 2 spreadsheet provides cash flow data (costs and benefits) for the proposal. Download and save this Excel spreadsheet, and use the information provided to complete the following:
Determine the cash inflows and outflows for each year.
Evaluate the capital project by calculating the following metrics:
net present value (NPV)
internal rate of return (IRR)
modified internal rate of return (MIRR)
discounted payback period
Indicate whether the project is acceptable, assuming Jiranna has a corporate policy of not accepting projects that take more than 3.5 years to pay for themselves, and assuming an 11% cost of capital.