MATH 123 - HW 10 Credit Cards 3. Create an Excel spreadsheet and using formulas and the drag function of Excel (see page 136), find the balance for 12 months for the following credit card. For the next 12 months you will make only the minimum monthly payment and no additional charges on a credit card with a carry-over balance of $1200. The APRIS 24.99% and the minimum payment each month is 3% of the balance. Determine the finance charges, new balances, minimum payments and carry-over balances for 12 months. Submit your spreadsheet in IvyLearn as last name, first name.HW 10. 4. You open a credit card account and you charge $100 to the account on the first of each month to pay for your cable and internet subscription. You plan to pay just the minimum amount each month for this first 6 months until your summer job starts. The APR is 24.99% and the minimum payment is 3% of the balance. Fill in the table below: Round to nearest cent. Mont Carry-over Finance New New balance Minimum h balance charge Purchases payment 1 $0 $0 $100 N $100 $100 fun 4 $100 5 $100 $100 Va 7 Section 10