How to solve for plus interest applied to the amount of outstanding balance, billed amount, the minimum monthly payment of 2% of billed amount and remaining outstanding balance. For one cell row only

Credit Card Debt Scenario A depart have been considering a new furniture ment store offers you the following credit card offer: No money down and no interest for 5 years. You purchase for your home and decide to sign up for this attractive offer as purchase $10,000 worth of furniture. Since interest option for 5 years, and plan to begin payments when the five year offer ends. You also decide not to make any more charges on this credit card you personal funds are low, you decide to utilize the no payment, no So.. in his assignment, we pick up at the end of the 5-year period, with a $10,000 debt on a credit card. The interest rate-17% APR of your outstanding balance. Each month, your minimum monthly pa yment . 2% of debt. When the outstanding balance The bill arrives and you make the 2% minimum payment. " Next month's bill-$3800+interest on the outstanding balance. -2$ S 10,000.00 S 10,000.00$ 3,800.00 $ 740.06$ 4 9,68048 $ 13833 $ 9.93883 198.7 11738 s ?78.04 $ 197.56 137.14 $ 9,817.62 $ 196.35 When you are finished with the table, answer the following questions. 1. 2. 3. How many years did it take to pay off this debt? How much did you actually pay for this furniture? How much interest did you pay