Explore BrainMass

CFO at a local hospital - payback, NPV, and IRR

Assume you are the CFO at a local hospital. The CEO has asked you to analyze two proposed capital investments - Project X and Project Y. Each requires a net investment outlay of $10,000 and the opportunity cost of capital for each project is 12%. The projects' expected net cash flows are as follows:

Year Project X Project Y
0 ($10,000) ($10,000)
1 6,500 3,000
2 3,000 3,000
3 3,000 3,000
4 1,000 3,000

a. Calculate each project's payback, NPV, and IRR
b. Which project (or projects) is financially acceptable? Explain your anser

Solution Preview

Only project X is acceptable because it earns better than the other opportunities that compete for limited financial resources (that can generate the 12%). This is seen in both the positive NPV, meaning that the project has a present v alue above the opportunity ...

Solution Summary

Your tutorial computes the required project metrics in excel so you have a template for other similar problems. A recommendation is made and supported with three paragraphs of comments.