Attached is a credit calculator, in Excel format, that I've been using over time to keep track of CLI's, utilization, and balances.
Link: http://min.us/moXbTq3mu
Notes:
TU shows specific start dates on credit reports so it's listed as a separate date in red.
My target utilization is 15% but you can adjust the formulas appropriately.
Auto-payments indicate what bills are automatically paid by which card. I'm doing this to constantly show some amount of utilization on each card per month.
Footer comments might be up for debate.
CreditKarma TU: 680 | Credit.com EX: 668 | Equifax EQ: 671 | Credit Sesame Simulated FICO: 736
Citi Platinum Select: ($6900), Chase Freedom ($3500), Amex BCE ($5000), Amex CLEAR ($6000), Barclaycard Ring ($2800), Barclay Rewards MC ($2500), CareCredit ($4100), Kohls ($1000) | UTL: 3.14%
