The essence of management is to make decisions, and to that extent, a health care manager must have a working knowledge on how to calculate time value money (TVM) financial problems.

Scenario

As a health care manager at a hospital, your supervisor has asked you to submit a set of financial calculations needed for the new capital projects of purchasing an MRI and deciding whether to expand the emergency room or to renovate the hospital lobby.

Preparation

Access Excel for Corporate Finance Professionals located in the Week 3 Learning Activities folder and watch it. Specifically, “NPV Tests in Excel” and “NPV and Scenario Analysis” in Lesson 2, “Project Selection in Excel,” may be helpful for understanding this assignment

Assignment Deliverable 

Complete all sets and parts of the Financial Exercises worksheet. The file contains the following 5 worksheet tabs:

• Wk 3: Set 1, Part 1
• Wk 3: Set 1, Part 2
• Wk 3: Set 2, Part 1
• Wk 3: Set 2, Part 2
• Wk 3: Set 2, Part 3

Assignment Support

• Access and watch the following videos in the Week 3 section on the HCS/385 Video Lectures Home Page for examples of different formulas used to calculate in Microsoft Excel:
• “Present Value Problems #1–3”
• “Future Value Problems #1–2”
• “Net Present Value Problems #1–3”
• “Internal Rate of Return Problems #1–3”
•  “Break-Even Point Problems #1–3”