CHAPTER 11 UHFM 7TH EDITION

Great Lakes Clinic has been asked to provide exclusive healthcare services for next year's World Exposition. Although flattered by the request, the clinic's managers want to conduct a financial analysis of the project. There will be an up-front cost of $160,000 to get the clinic in operation. Then, a net cash inflow of $1 million is expected from operations in each of the two years of the exposition. However, the clinic has to pay the organizers of the exposition a fee for the marketing value of the opportunity. This fee, which must be paid at the end of the second year, is $2 million.

a. What are the cash flows associated with the project that are relevant for capital budgeting purpose?

b. Find the project NPV if its cost of capital is 25 percent and if its cost of capital is 400%. Why would a financial calculator give an error message when attempting to calculate this project's IRR?

c. If the project cost capital is 10 percent, what would be the project's NPV in each case? Shoud the project be undertaken?

Please respond to this question only using the Excel sheet provided with formulas included, not just answers. Please show your work!

Problem Set 5 Chapter 11 -- Capital Budgeting Assigned Problem 2 Great Lakes Clinic has been asked to provide exclusive healthcare services for next year's World Exposition. Although flattered by the request, the clinic's managers want to conduct a financial analysis of the project. There will be an up-front cost of $160,000 to get the clinic in operation. Then, a net cash inflow of $1 million is expected from operations in each of the two years of the exposition. However, the clinic has to pay the organizers of the exposition a fee for the marketing value of the opportunity. This fee, which must be paid at the end of the second year, is $2 million. a. What are the cash flows associated with the project that are relevant for capital budgeting purpose? b. Find the project NPV if its cost of capital is 25 percent and if its cost of capital is 400%. Why would a financial calculator give an error message when attempting to calculate this project's IRR? c. If the project cost capital is 10 percent, what would be the project's NPV in each case? Shoud the project be undertaken? ANSWER a. Cash flows: Year b. NPV @ 25% NPV @ 400% c. NPV @ 10% Cash Flow 0 -$160,000 1 $1,000,000 2 -$1,000,000