You buy a flat-screen TV for $1,000 with a credit card that charges 12% APR.Calculated the amount owed at the end of one year with a $50 payment each month. Fill down to 30 months. b. How much do you owe at the end of one year? In cell F35 enter a simple formula which links to the cell with the answer in it. So if the amount you owe at the end of one year is in cell B3, your formula in F35 would be =B3. c. How long will it take you to pay off the loan? In cell F37 enter a simple formula which links to the cell with the answer in it. So if the number of the month the loan is paid off is in cell B3, your formula in F37 would be =B3.