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.
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"
