HCAD512 Rhode Island College Week 10 Capital Budget Excel Template

The Assignment:

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

1. If a physician deposits $19,000 today in to a mutualfund 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. 12yearsfromnow

2. The Chief Financial Officer of a hospital needs to determine the present value of $140,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. An eye Surgeon purchases a new Lasix laser for their office for $700,000. The expected cash flows for each year of five-year period is $114,000, $160,000, $190,000, $ 210,000, and 240,000 for the 5 years. What is the internal rate of return or 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 Question 3

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.