Monday
Top of Form
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
Bottom of Form