Valued Contributor
IOBA
Posts: 2,659
Registered: ‎08-13-2009
Re: Do I have a problem? ;)

SynnDiesel - I do an Excel spreadsheet - well actually two tables on one sheet.


The first table looks like this:

 

CD Bingo20112012201320142015201620172018
January  N 20, 21I 01    
February    Annuity   
March U 02      
April        
May       Annuity
JuneU 01U 03, 04   A 01  
July N 01 - 03  AM 01A 02  
August N 04 - 08      
SeptemberP 01N 09 -12      
October N 13, 14   A 03  
November N 15, 16   Am 02  
DecemberP 02, U 01N 17 - 19  AY 01, 02   

 

It shows what CD's mature in what month, in what year.  I have just taken the first letter of each bank where the CD is at.  I number each CD at each place.  ie - AY = Ally.  I have two CD's at Ally, so AY 01, AY 02.

 

The other table looks like this:

 

CDAmount2012201320142015201620172018
A 01 $523.14     $523.14  
A 02 $596.94     $596.94  
A 03 $579.19     $576.95  
AM 01 $973.66    $973.66   
AM 02 $100.27     $100.27  
AY 01 $100.08    $100.08   
AY 02 $100.22    $100.22   
I 01 $1,041.12   $1,041.12    
N 01  $3,050.66 $3,050.66      
N 02 $3,047.35 $3,047.35      
N 03 $3,047.35 $3,047.35      
N 04 $111.51 $111.51      
N 06 $100.33 $100.33      
N 08 $145.87 $145.87      
N 09 $145.79 $145.79      
N 10 $172.78 $172.78      
N 12 $123.69 $123.69      
N 13 $102.97 $102.97      
N 14 $107.78 $107.78      
N 15 $102.14 $102.14      
N 16 $103.67 $103.67      
N 17 $102.03 $102.03      
N 18 $100.08 $100.08      
N 19 $108.39 $108.39      
N 20 $100.39 $-   $100.39     
N 21 $100.01  $100.01     

N 22

        
U 02 $444.58 $444.58        
U 03 $359.46 $359.46      
U 04 $251.14 $251.14      
Total $15,942.59 $11,727.57 $200.40 $1,041.12 $1,173.96 $1,797.30 $-   $-