Credit Card Payoff

When you get your credit card bill you might see a box that tells you how long it will take to pay off the balance if you make the minimum payment. This spreadsheet shows the payoff years, give a minimum payment of the greater of:

  • A percent of the balance
  • A dollar amount

The percent of the balance is normally the greater payment, until that payment reaches the minimum dollar amount, which will then continue to be the payment until the final payoff. The default values I used are below, 2% or $100:

An  amortization schedule is used to make the largest payment, until the other payment kicks in:

This formula determines the payment and is put into cell C14 and copied down to the end of the amortization schedule.

The answer appears like this:

Download workbook “CreditCard” from:

http://www.pistulka.com/Excel_Shared/ 

Downloads Written in Excel 2013

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

WordPress spam blocked by CleanTalk.