Calculations: Analytic Methods for Financial Decision Making

Determining how to make a capital investment decision using financial techniques is an essential aspect of long-term financial decision making.

To preparefor the Calculations, review the sections ofChapter 7 ("The Investment Decision")from yourFinancial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applicationstextbook that explain how to analyze capital investment decisions using financial techniques. (The pertinent section ofChapter 7to review for each type of Calculation is identified in the below list of Calculations.) Then, read scenario #15 (Kaiser Oakland Practice) on page 329, which contains the information that you will use to populate and perform the Calculations.

Completethe following Calculations and submit your completed Calculations in an Excel spreadsheet with three tabsone tab for each of the following Calculations and with that particular tab reflecting only the result of that particular Calculation.

1.Determine the payback for both projects.

Note:For detailed information on how to perform this type of Calculation, review the section "Payback Method" and Exhibit 7-2 "Cash flows for two alternative project investments" and Exhibit 7-3 "Calculation of payback year for two alternative investments" on pages308 and 309, respectively, of theFinancial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applicationstextbook.

2.Determine the IRR for both projects.

Note:For detailed information on how to perform this type of Calculation, review the section "Unequal cash flows" and Exhibit 7-8 "Using Excel to Calculate the IRR...that yields unequal operating cash flows..." (This can also be used for equal cash flows) on page318-319 of theFinancial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applicationstextbook.

3.Determine the NPV at a cost of capital of 12 percent for both projects. Which project should be chosen? Explain.

Note:For detailed information on how to perform this type of Calculation, review the section "Using spreadsheets to calculate NPV" and Exhibit 7-6 "Using Excel to calculate the net present value of unequal annual cash flows" (This can also be used for equal annual cash flows) on page316 of theFinancial Management of Health Care Organizations: An Introduction to Fundamental Tools, Concepts, and Applicationstextbook.

Save your Calculations as a ".xls" file.Submit your Calculations by Day 7 of Week 5.