Use the “Week 10 Assignment Capital Budget Excel Template” to show your work, answer the following questions:

HELP WANTED: For this assignment, you will construct a firm’s monthly cash budget. Download the Excel template below and complete the included problem.
May 6, 2017
Risk Assessment : The Chief Risk Officer has asked you to perform an enterprise-wide risk assessment.
May 6, 2017

Week 10 Assignment Capital Budget

Use the “Week 10 Assignment Capital Budget Excel Template” to show your work, answer the following questions:

If a physician deposits $24,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:

3 years from now
6 years from now
9 years from now
12 years from now
The Chief Financial Officer of a hospital needs to determine the present value of $120,000 investment received at the end of year 5. What is the present value if the discount rate is:

3%
6%
9%
12%
The Kadrie’s dental group purchased a new diagnostic machine for their office for $1,200,000. The expected cash flows for each year of the five year period is $140,000, $175,000, $199,000, $218,000, and $245,000 for the five years. What is the internal rate of return or the IRR for the project?

Determine the Net Present Value for Problem 3 with an interest rate of 10%. Do you proceed or not with the project?

Determine the Payback Period for Problem 3.

Comments are closed.