Determine the cash inflows and outflows for each year Healthcare Finance Questions
Please see attached documents to complete assignment. Work Must be Shown.
Assignment
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)
- payback period
- 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.