Working knowledge on how to calculate time value money
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
Sample Solution
Time value of money (TVM) is a concept in finance that states that money today is worth more than money in the future. This is because money today can be invested and earn interest, while money in the future is worth less because it has less time to earn interest.Full Answer Section
TVM is a powerful tool that can be used to make financial decisions. For example, TVM can be used to calculate the present value of a future cash flow, or to calculate the future value of a present cash flow. Calculations for New Capital Projects The following are the 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: MRI The cost of purchasing an MRI is $1 million. The MRI will generate $200,000 in annual revenue. The MRI will have a lifespan of 10 years. The present value of the MRI is calculated as follows: Present Value = Future Value / (1 + r)^t where:- Present Value = the present value of the MRI
- Future Value = $200,000
- r = the discount rate (assumed to be 5%)
- t = the number of years (10)
- Present Value = the present value of the emergency room expansion
- Future Value = $1 million
- r = the discount rate (assumed to be 5%)
- t = the number of years (20)
- Present Value = the present value of the hospital lobby renovation
- Future Value = $500,000
- r = the discount rate (assumed to be 5%)
- t = the number of years (10)