I was looking for help with setting up the formulas for this Excel spreadsheet. What formulas would I need to get this balance to a zero after years of paying off the account. I.E. (Plus Interest Applied to the Amount of Outstanding Balance) Thank you for your help.

Credit Card Debt Scenario A department store offers you the following credit card offer: No money down and no interest for 5 years. You have been considering a new furniture purchase for your home and decide to sign up for this attractive offer as you purchase $10,000 worth of furniture. Since personal funds are low, you decide to utilize the no payment, no interest option for 5 years, and plan to begin making the 2% per month payments when the five year offer ends. You also decide not to make any more charges on this credit card. o in this 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, you pay the minimum monthly payment 2% of outstanding debt. When the outstanding balance bill arrives and you make the 2% minimum payment. > 200.00 Next month's bill- $9800 interest on the outstanding balance2S ,800.00 9,740.06 9,680.48 $ 138.83 938.83 $ 3798$ 878.04$ 37.34 $ 817.62 197.56 When you are finished with the table, answer the following questions 1 How many years did it take to pay off this debt? (2 pts.) 2. How much did you actually pay for this furniture? (2 pts.) . How much interest did you pay? (2 pts.) 4. There are times when everyone needs to borrow money. Assuming that the loan was necessary, identify at least 2 strategies that would have helped lower the total amount paid for this furniture. (2 pts.) Suppose you HAD decided to add more charges to the credit card before or even while trying to pay off this furniture purchase? Copy the first few lines of your existing work onto a second worksheet and experiment by adding what you think is a typical monthly expenditure (and it does not have to be the same amount each month). Complete 12- 24 months. What observations can be made? (12 pts.) 5. Plus Interest Applied to the Amount of You Makea Remaining Minimum Monthly End ef (Outstanding Outstanding Cit Cand Month Balance Med Mount For payment of 2%of This Month Balance You charged this amount on a credit cand. The bill arrives and you make the 2% minimum payment. Next month's bill $9800+ interest on the outstanding balance. 0,000.00 0000.00 200.00 20678 13.51 2 $ ,800.00 13883 $ 400.00 $ 0338.83 S 0000$ 067559