Please show excel equations

PROBLEM 4 (14.9) The staff of Jefferson Memorial Hospital has estimated the following net cash flows for a satellite food services operation that may open in its outpatient clinic: Year Expected Net Cash Flow o $ (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 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? It's MIRR? b. Assuming the project has average risk, what is it's NPV? c. Now, assume that the operating cash flows in years 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