Please Show ALL STEPS and Explanations on EXCEL! Please make sure screenshot is CLEAR!

You have an unpaid credit card debt of $2356. your interest rate is 204-4: Use Excel to determine how much you would have to pay each month in order to pay the debt ba ck in a years. You wilI need to program a version of the present value of annuity formula, solving for PMT. Using the information above, show the paying down of the account until there is a zero balance. In other words, make a table showing Payment Number, Monthly Payment, Balance Less Payment, PIus Interest, and Remaining Balance. Assume no new charges have been made to the credit card. Now, assume you are starting as you were in number 2. You make 6 of the same monthly payments and then decide to transfer the baIance to another card. There is a one-time transfer fee of 3% of the transferred balance. You resume the same montth payments for 6 months, during which time you enioy a 2.35% teaser late. After these 45 months, you continue making the same monthly payments at a 26.4: interest rate untiI the baIance is paid off. Use ExceI to determine the total interest paid back in both situations {numbers 2 and 3). Was it worth it to transfer the balance to the other card? Why or why not