please i need help asap

Suppose you have a $17,000 bal anee en your credit card. "This has got to stopl" you say to yourself. So you decide to repay the $17,000 debt in four months. An unpaid crodit cand balance at the beginning of a month will be charged interest by your credit card company. For this situation, we have selected three plans to repay the $17,000 principal plus interest owed. These three plans are illustrated below. Investigate these repaymeat plans. Credit card monthly interest rate Complete the steps below asing cell refereoces to given data or previous calculations. In some cases, a simple cell reference is all you peed. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a speciffe Ereel function is to be used, the Iilrectlons will specify the use of that function. Do not type in sumerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blae cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, useally the Given Data section. Plan 1: Pay interat due at ond of each month and principal at end of fourth month. 1. Start Execl-completed. 2. In cell E12, by using cell references, calculate the interest acenued for the first month under plan I at the 2 jonthly interest rate of 1% ( 1 pt.) Note: Use only the data given in the table for plan 1 and the corresponding interest rate. 3. To calculate the interest accrued for corresponding periods under different plans at the monthly interest rate of 1%, copy cell E12 and paste it onte cells E13:E15, E20:E23, and E28:E31. (1 pt) 4. In cell F12, by using eell references, calculate the total moncy owed at the end of the first month under plan 1 at the monthly interest rate of 1% ( 1 pt.) Note: Refer only to cells from the table for plan 1. 5. To calculate the total money owed at the end of periods under different plans at the monthly interest rate of 1%, copy cell F12 and paste it onte cells F13:F15, F20:F23, and F28:F31. (1 pt.) 6. In cell H12, by using cell references, calculate the total end-of-month payment for the first month under plan 1 at the monthly interest mate of 1% ( fpt ) Note: Refer only to cells from the table for plan 1. 7. To calculate the total end-of-month payment for cortesponding periods under plan I at the monthly interest rate of 1%. copy cell Hil 2 and paste it onto cells H13:HIS. (1 pt.) 8. In cell D13, by using cell references, calculate the amount owed at the beginning of the second month under plan 1 at the monthly interest rate of 1% ( p p.) Note: Refer only to cells from the table forplan 1. 9. To calculate the amount owed at the beginning of periods under different plans at the monthly interest rate of 1% copy cell D13 and paste it onte cells D14:D15, D21:D23, and D29:D31. (1 pt.) 10. In cell E16, by using cell references, calculate the total accumulated interest under plan 1 at the monthly interest rate of 1% (1 pt) 11. To calculate the accumulated interest under different plans at the monthly interest rate of 1%, copy cell E16 and paste it onto cells E24 and k32, (1pt. 12. In cell H20, by usiag cell references and the function PMr, calculate the total end-of-month payment for the first month under plan 2 at the monthly interest rate of 1% (1 pt.) Note: Use only the data given in the table for plan 2 and the corresponding interest rate. 13. To calculate the total end-of-month payment for corresponding periods under plan 2 at the monthly interest rate of 1%, copy cell H20 and paste it onto cells H21:H23, (1 pt.) 14. In eell G20, by using cell references, calculate the principal payment for the first month under plan 2 at the monthly interest rate of 1% ( 1 pt.) Note: Refer only to cells from the table forplan 2. 15. To calculate the principal payment for corresponding periods under plan 2 at the monthly interest rate of 1%, copy cell G20 and pastc it onto cells G21:G23. (1 pt.) 16. In cell 131 , by using cell references, calculate the total end-of-month payment for the fourth month under plan 3 at the monthly interest rate of 1% ( 1 pt.) Note: Refer only to cells from the table for plan 3 17 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed