if possible solve in excel and take screenshot or somthing

Q4. An investment proposal requires $20,000 outlay now (at time zero) and returns a constant cash flow of $8,000 per period before tax savings due to interest payments for the next four years. The proposal is to have a market debt proportion of 50% (i.e., 0.50). The capital market requires per period rate of return on equity of 25% and on debt of 10%. The corporate tax rate is 42%, and interest is deductible for the calculation of income tax. Using both mid-year rule and end-year rule, calculate the NPV and IRR based on: a. Weighted average cost of capital method b. Arditty-Levy method c. Equity residual method d. Adjusted net present value method e. What is the difference between both accounting rules used (mid-year and end-year rule)