Follow the instruction and complete the Excel template
. Page 1 of 1
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.
The Assignment:
Use the “ 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. 3 years 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.
