Health Care Finances worksheet

Health Care Finances worksheet

Tab 5 of 5: Complete the following 5 Wk 3 Financial Exercises: Set 2, Part 3 Questions in A3 through B9.
Table 1: Set 2, Part 3 Questions
Problem	Answer
1. How much will you have saved after 6 years by contributing $1,200 at the end of each year if you expect to earn 11% on the investment?	9495.48
2. A business owner plans to deposit their annual profits in an investment account earning a 9% annual return. If the owner starts with their first deposit today for $22,000 and expects to make the same profit for the next 7 years, how much will be saved for retirement at that point?	202408.8
3. An investor plans to invest $500 a year and expects to get a 10.5% return. If the investor makes these contributions at the end of the next 20 years, what is the present value of this investment today?	4115.454457
4. What is the present value (PV) of a 12-year lease arrangement with an interest rate of 7.5% that requires annual payments of $4,250 per year with the first payment being due now?	32874.93267
5. A recent college graduate hopes to have $200,000 saved in their retirement account 25 years from now by contributing $150 per month to a 401(k) plan. The goal is to earn 10% annually on the monthly contribution. Will they have the $200,000 at the end of the 25 years?	191133.3151
	they will not have $200,000 at the end of the 25 years

ORDER A PLAGIARISM-FREE PAPER HERE

We’ll write everything from scratch

---

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

Scenario
As a healthcare 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 renovate the hospital lobby.

Preparation
Access Excel for Corporate Finance Professionals, which is 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 five 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.

Break-even analysis. (2014). QFinance: The Ultimate Resource.
Calculating future value. (2011). Business: The Ultimate Resource.
Calculating net present value. (2011). Business: The Ultimate Resource.
Doost, R. K. (2007). Budgets and budgeting. In B. S. Kaliski (Ed.), Encyclopedia of business and finance, (Vol. 2, pp. 58–60). Gale.