show me excel format

Problem 1 PROBLEM 3 (Based on 14.5) Problem 2 Problem 3 Problem 4 Assume that you are the CFO at Porter Memorial Hospital. The CEO has asked you to analyze two proposed capital investments project X and project Y. Each project requires a net investment outlay of S145,000, and the cost of capital for each project is 6.5 percent. The projects' expected net cash flows are as follows: Year Project X Project Y X Cumulative Y Cumulative Rate 0 2 3 4 -145,000 81,000 57,000 36,000 18,000 a. Calculate each project's payback perio b. Which project is financially acceptable. -145,000 38,063 38,063 38,063 38,063 net present value (NPV), an Explain your answer. the internal rate of return (IRR). Years ANSWER Payback NPV IRR b. x