Homework Content
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
Submit your assignment.
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”
I previously recorded or hosted a live session for students and thought I would share those recordings to help you out. I promise if you dedicate the time to work your exercises alongside the video you will find mastering Excel AND formulas IS possible. It does take time to stop and pause – but WELL worth your investment of time and yourself!
THIS video helps you work through Week 3 Parts 1 & 2 using Excel formulas.
