SHOW WORK AND STEPS ON EXCEL

SHOW WORK AND STEPS ON EXCEL

SHOW WORK AND STEPS ON EXCEL

SHOW WORK AND STEPS ON EXCEL

Exercise 3.19. Assume that you start with a balance of $4,573 on your Visa credit card. During the first month, you charge $522.50, and during the second month, you charge $315.43, and make no charges after this. Assume that Visa has finance charges of 24% APR and that the minimum payment for this card is 2.5%. 1. Make a "New Balance" table for this situation for 1 year, assuming you make the minimum payment every month. 2. If you put a monthly bill of $84 on this credit card, how much will you owe after 1 year? 3. Keep the situation from (b). How much will you owe if instead you make the minimum payment plus an extra $200 each month