PLEASE PREPARE RESPONSE IN SPREADSHEET FORMAT

The staff of Jefferson Memorial Hospital has estimated the following net cash flows for a satellite food service operation that it may open in its outpatient clinic:

YearExpected Net Cash Flow

0 (100,000)

1 30,000

2 30,000

3 30,000

4 30,000

5 30,000

5 (salvage value) 20,000

The year 0 cash flow is the investment cost of the new food service, while the final amount is the terminal cash flow. (The clinic is expected to move to a new building in five years) All other flows represent net operating cash flows. Jefferson's corporate cost of capital is 10 percent.

a. What is the project's IRR? Its MIRR?

b. Assuming the project has average risk, what is its NPV?

c. Now assume that the operating cash flows in year 1 through 5 could be as low as 20,000 or as high as 40,000. Furthermore, the salvage value cash flow at the end of year 5 could be as low as 0 or as high as 30,000. What are the worst-case and best-case IRRs? The worst-case and best case NPVs?

PLEASE PREPARE RESPONSE IN SPREADSHEET FORMAT