Assume VISA has sent you a bill in which they charge 17.8% for their APR and you have an outstanding credit card balance of $1,456.38. The minimum monthly payment they ask for is $25.00. Also assume that you will not be charging anymore items on your card as you pay off your debt. a. If you only pay the minimum payment of $25 every month, about how many months would it take to pay off your debt? Use the excel formula =NPER formula with the rate being 0.178/12, the payment being 25 since you're making the loan go down by 25 each month, and PV the credit card balance of 1456.38. The output excel gives is the number of monthly payments you will have to pay. Round to the nearest month. How many years is this? b. If you only pay the minimum payment, use the answer from part a to find out how much will you be paying overall for the credit card debt of $1,456.38 ? How much interest does that amount to? Show your calculations. c. Suppose instead, you decide you want to pay off the debt in 1 year. What would your monthly payment be? (Hint: use the PMT formula). Show what you put into excel. d. If you pay off the credit card in 1 year, how much will you be paying overall for the credit card debt? How much interest does that amount to? Show your calculations