topic Promo Balance Spreadsheet in Credit Cards

Promo Balance Spreadsheet

0errant — Tue, 09 Jul 2013 19:29:33 GMT

I searched and found lots of different spreadsheets, but none that dealt with promotional balances. Anyone have something I can use to help keep better track of my promotional balances? I have two with 0% BTs on them, and then my HD card with several 0% promos ending at various times. I'm trying to figure out the best way to attack all of this debt, yet still make sure everything gets paid up before the various promo periods end to avoid the interest and now my head is spinning

Re: Promo Balance Spreadsheet

0errant — Wed, 10 Jul 2013 14:49:14 GMT

I think I found an easy way to get these promo rates all lined up for payoff at 0%. I used the snowball calculator at WhatsTheCost, and entered each with interest rates at 1% increments with the first promo expiration at the highest and the last to expire at the lowest

I would still like to find a spreadsheet, rather than an online calculator, but this works for now!

Re: Promo Balance Spreadsheet

yudeology101 — Wed, 10 Jul 2013 15:05:41 GMT

try this: http://www.vertex42.com/Calculators/debt-reduction-calculator.html

hope this works for ya. This site also has great other excel spreadsheets for many diff categories, i use it quite often.

Re: Promo Balance Spreadsheet

Odiseous — Wed, 10 Jul 2013 17:14:30 GMT

@0errant wrote:
I searched and found lots of different spreadsheets, but none that dealt with promotional balances. Anyone have something I can use to help keep better track of my promotional balances? I have two with 0% BTs on them, and then my HD card with several 0% promos ending at various times. I'm trying to figure out the best way to attack all of this debt, yet still make sure everything gets paid up before the various promo periods end to avoid the interest and now my head is spinning

These are the column headers I curently use for my spreadsheet. I'm sure it can be fine tuned, but it's currently working.

The top cell for Column A gives me a running total of my total credit. I use the rest of the cells in that column, to identify each of the various CCs.

=sum(J:J)

Promo APR

Promo End

APR

Contact #

Date Opened

Last CLI Date

CLI Frequency

Last CLI Amount

Credit Limit

Closing Date

Due Date

Auto-Pay Date

Pay Source

For Example:

Chase Slate

Sep 1, 2014

11.99

800-945-2000

Jun 5, 2013

n/a

$x,xxx

n/a

One of my Credit Unions