For the next part of the Final Assessment, you are expected to complete a number of calculations, and then interpret the numbers to provide recommendations based on these analyses. It is essential both to show your work and calculation using current technology like Excel Workbook, and to demonstrate how these calculations support your conclusions. Be sure to explain your reasoning. You will be assessed on the accuracy of your quantitative analyses and the quality of the evidence you use to support your conclusions.

Imagine that you are an administrator at Jiranna Healthcare who has been asked to analyze cash$-$flow data to determine the costs and benefits of implementing a new capital project. For background, read $$Capital Project Case Study.$$ Then, complete the $$Capital Project Case Study Spreadsheet$,$ which provides cash$-$flow data $($costs and benefits$)$ for the proposal. Download and save the Excel spreadsheet in your working Excel Workbook, and use the information provided to complete the following:

Calculate 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