Problem 1 A Future Future Value Value Factor a) b) c) d) Problem 2 A B Present Present Value Value a) b) c) d) Problem 3 IRR Cash Flow Cummulative Cash Flow IRR= % Problem 4 Excel less the investment NPV Accept or do not accept the project Problem 5 What is the payback period for problem 3? Payback period = Year before recovery + Year before cummulative cash flow/cash flow for year paid off Healthcare Financial Management and Economics Week 10 Assignment Capital Budgeting There are many options to buy capital, including cash purchases, loans, leasing, and other forms of payment. Your goal as a healthcare manager is to determine which method is best for your organization, given its financial and organizational structure (i.e., for-profit or not-for-profit). Time value of money and net present value are two techniques that may help you determine how and when to invest in new capital. For this Assignment, you examine these concepts as they pertain to the healthcare industry. To prepare for this Assignment: Review this week's Learning Resources. Reflect on concepts of time value of money, net present value, internal rate of return, and purchasing options. The Assignment: Use the \"Week 10 Assignment Capital Budget Excel Template\" to show your work, answer the following questions: 1. If a physician deposits $25,000 today into a mutual fund that is expected to grow at an annual rate of 8%, what will be the value of this investment: a. 3years from now b. 6 years from now c. 9 years from now d. 12 years from now 2. The Chief Financial Officer of a hospital needs to determine the present value of $150,000 investment received at the end of year 5. What is the present value if the discount rate is: a. 3% b. 6% c. 9% d. 12% 3. The Ford OBGYN group purchased a new diagnostic ultrasound machine for their office for $900,000. The expected cash flows for each year of the five year period is $120,000, $155,000, $186,000, $208,000, and $225,000 for the five years. What is the internal rate of return or the IRR for the project? 4. Determine the Net Present Value for Problem 3 with an interest rate of 10%. Do you proceed or not with the project? 5. Determine the Payback Period for Problem 3. 2024 Walden University Page 1 of 1