We are solving it over excel, can you please write with the formulas

Question 6: You are a financial analyst for Damon Electronics Company. The director of capital budgeting has asked you to analyze two proposed capital investments, Projects X and Y. Each project has a cost of $20,000, and the cost of capital for each project is 10 percent. The projects' expected net cash flows are as follows: Year 0 1 Expected Net Cash Flows Project X Project Y $20.000 $20.000 $3.500 $15.000 $5.500 $10.000 $9.000 $3.000 $15.000 $1.500 2 3 4 a) Calculate each project's payback period, discounted payback period, NPV, IRR, and MIRR Project X Project Y Present Value of CFS r= Time Y 0 1 Payback period = Discounted Payback Period NPV = IRR = MIRR = 2 4 b) Which project or projects should be accepted if they are independent? c) Which project should be accepted according to NPV rule if they are mutually exclusive ? What would be your conclusion according to IRR rule? (Do not make any calculations but just explain how you would decide.)