Please help with constructing the rest of the table until debt = 0.

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.

So,... in this scenario, 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

Construct the following table in an Excel worksheet. Keep adding lines to the table until the outstanding debt = $0.00.

When you are finished with the table, answer the following questions.

1. How many years did it take to pay off this debt?

2. How much did you actually pay for this furniture?

3. How much interest did you pay?

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.

5. 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?

| Remaining Plus Interest Applied to You Make a Minimum Monthly End of (Outstanding) the Amount of Billed Amount Payment of 2% of the Billed Month # Balance Outstanding Balance For This Month Amount You Charged This Amount on a Credit Card | $ 10,000.00 The Bill Arrives and You Make 2% the Minimum Payment [ $ 10,000.00 | $ 200.00 Next Month's Bill= $9800 + interest on the outstanding balance 2] $ 9.800.00 | $ 138.83 $ 9,938.83 198.78 | 3| $ 9,740.06 | $ 137.98 $ 9,878.04 $ 197.56 4 $ 9,680.48 | $ 137.14 | $ 9,817.62 | $ 196.35 | 5 6 7| 8 1o 11 12 13 14 15 16| 17 18 19 20