Fill in the yellow blanks with the given information. Use Excel formulas.

c D 1 2 3 4 5 6 7 8 9 10 Debt = $10,000 Interest Rate = 17% APR of your outstanding balance Minimum Monthly Payment = 2% of outstanding debt When the outstanding balance < $100, you decide to pay off the remainder. You charged this amount on a credit card. The bill arrives and you make the 2% minimum payment. Next month's bill = $9800 + interest on the outstanding balance. End of Month # 1 2 Remaining (Outstanding) Balance Plus Interest Applied to the Amount of Outstanding Balance Billed Amount For This Month 10,000.00 10,000.00 You Make a Minimum Monthly Payment of 2% of the Billed Amount 200.00