Need help with this question if you use an excel please show the formulas you use. You don't have to do part (D) if you don't want.

-Thanks

a. A loan in the amount of $28,460 at 4.36%, 5.36%, 6.34% APR over 36,50 and 72 months respectively. (1) What is the total interest paid for each number of payments (period)? (2) What is the total interest paid for each year? (3) What is the total interest paid? (4) Compare the options and discuss the pros and cons of each option. Include the results of the previous sections in your discussion. a. A loan in the amount of $28,460 at 4.36%, 5.36%, 6.34% APR over 36,50 and 72 months respectively. (1) What is the total interest paid for each number of payments (period)? (2) What is the total interest paid for each year? (3) What is the total interest paid? (4) Compare the options and discuss the pros and cons of each option. Include the results of the previous sections in your discussion