cancel
Showing results for 
Search instead for 
Did you mean: 

Promo Balance Spreadsheet

tag
0errant
New Contributor

Promo Balance Spreadsheet

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 Smiley Surprised


Starting Score: 528
Current Score:840 DISC, 788 EFX, 849 TRU, 850 XPN
Goal Score: 850+ for all three


Take the FICO Fitness Challenge
Message 1 of 4
3 REPLIES 3
0errant
New Contributor

Re: Promo Balance Spreadsheet

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 Smiley Happy

 

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


Starting Score: 528
Current Score:840 DISC, 788 EFX, 849 TRU, 850 XPN
Goal Score: 850+ for all three


Take the FICO Fitness Challenge
Message 2 of 4
yudeology101
Senior Contributor

Re: Promo Balance Spreadsheet

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. 

JPM Ritz Carlton $8k I UMP Club $8k I CSP $8k | Chase Hyatt $5k I AMEX Green NPSL I AMEX Delta $2k I Citi AA $2k | C1 QS $4.5k
BOA UNC-CH Alumni $6k I Hawaiian WEMC $3k I Arrival $6.5k I IT $1.5k | Merrill+ $2k | Lowes $12k | Apple $2k | +23more
Scores: EQ:671 (FICO 11) EX:686 (FICO N/C) TU:686 (FICO N/C) *8-5-14*
Overall UTIL: 14% *Gardening Since: 1/20/16*
------------------------------------------------------------
Need to stay out of trouble.... Go Heels!!! ... GC Watchlist ( #1 since 12-12-13)
Message 3 of 4
Odiseous
Frequent Contributor

Re: Promo Balance Spreadsheet


@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 Smiley Surprised


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

0

Sep 1, 2014

11.99

800-945-2000

Jun 5, 2013

n/a

n/a

n/a

$x,xxx

4

1

 n/a

One of my Credit Unions

 

TU98 751, EQ 766, EX 766 (Lender)

If at first you don't succeed; Garden for 6 months, then try again.

Work the system. Don't let the system work you.
Message 4 of 4
Advertiser Disclosure: The offers that appear on this site are from third party advertisers from whom FICO receives compensation.