SHOW IN EXCEL ONLY

Problem 3 for two years You evaluate a credit card charges and payments period. The annual rate is 18% and a minimum payment is required for 20% of the monthly balance. Total Monthly Changes Post at the end of the Month Months $100.00 2 3 $350.00 + $100.00 5 6 $250.00 7 $350.00 8 $250.00 9 10 11 12 $100.00 13 $250.00 14 $1,000.00 15 16 $500.00 17 18 $200.00 19 20 $350.00 21 $450.00 22 $300.00 23 24 The last month the total amount is paid, not just the minimum payment as all the previous periods. How much is the total amount paid for interest evaluated at the beginning of the two year period? How much is the total amount of charges evaluated at the beginning of the two year period