Need help with this question.

Project Information M4 Engineering has received five proposals for capital investment projects. Your job is to evaluate these proposals and rank them in the order in which they should be funded. Begin your analysis by computing the average rate of return and cash payback period for each proposal. Any project that has an average rate of return of less than 13 percent or a cash payback period of five years or longer should be eliminated from further consideration. After this initial screening, compute the net present value (using a 13 percent discount rate) and internal rate of return for the remaining projects. Rank the projects based on both their profitability and overall merit to the corporation (qualitative factors). Projects: A B C D E Cost $70,000 $440,000 $90,000 $60,000 $212,500 Life (in years) 8 9 10 10 Residual value $0 $0 $0 $0 $0 Annual project income $7,325 $55,000 $10,250 $4,650 $21,250 Annual net cash flows $17,325 $1 10,000 $20,250 $10,650 $42,500 Present Value of an Annuity of $1 at Compound Interest n/i 10.0% 11.0% 12.0% 13.0% 14.0% 15.0% 16.0% 17.0% 7 4.86842 4.71220 4.56376 4.42261 4.28830 4.16042 4.03857 3.92238 8 5.33493 5.14612 4.96764 4.79877 4.63886 4.48732 4.34359 4.20716 9 5.75902 5.53705 5.32825 5.13166 4.94637 4.77158 4.60654 4.45057 10 6.14457 5.88923 5.65022 5.42624 5.21612 5.01877 4.83323 4.65860 Complete the calculations on the following page. Show all work.Calculate Average Rate of Return, Cash Payback, NPV and IRR for each project. Show your work below. Projects A B C D E Average Rate of Return Cash Payback Net Present Value IRR Which Projects should be considered