Building a CD Ladder by ExcelGeek@verizon.
net
Instructions:
1) Enter the current CD Rates in the CD Rate Table.
Check www.bankrate.com or other sources for current rates.
2) Enter your Start Dates and Investment Amounts in
the 2-Year Cycle and 5-Year Cycle Worksheets.
Articles and Free Resources:
http://www.bankrate.com/brm/news/sav/20010521b.asp
http://www.savewealth.com/banking/cdladder/
http://www.dinkytown.net/java/CDLadder.html
http://money.cnn.com/2002/08/19/pf/expert/ask_expert/
http://financialplan.about.com/cs/investing/a/LadderingCDs.htm
http://www.schaeffersresearch.com/personalfinance/calculators/CDLadder.aspx
http://www.usatoday.com/money/perfi/columnist/waggon/2003-12-19-invest2_x.htm
http://www.statefarm.com/planning/calculators/cdladdering.asp
http://www.yourfreecreditreportnow.com/articles/ladder.html
CD Rate Table *
Enter the current rates for the following Terms:
Term APY Interest Effective Source
Rate Date
6 Mos 5.00% 5.0000% 7/1/2006 www.ingdirect.com
9 Mos 5.10% 5.1000% 7/1/2006 www.ingdirect.com
1 Year 5.25% 5.2500% 4/29/2006 www.ingdirect.com
18 Mos 5.25% 5.2500% 5/20/2006 www.ingdirect.com
2 Year 5.30% 5.3000% 7/1/2006 www.ingdirect.com
3 Year 5.25% 5.2500% 6/24/2006 www.ingdirect.com
4 Year 5.25% 5.2500% 6/24/2006 www.ingdirect.com
5 Year 5.25% 5.2500% 6/24/2006 www.ingdirect.com
*CD's with interest accruing daily and compounding annually.
CD Ladder - Two Year Cycle
Start Date: 01/01/2006
Amount Invested (Each CD): $ 1,000.00
Total Investment: $ 5,000.00
Interest After 1st Maturity: $ 303.79
Interest After 2nd Maturity: $ 326.80
Interest After 3rd Maturity: $ 351.83
Total Interest after 6 years: $ 982.42
Total Investment Value: $ 5,982.42
First Purchase
Months Invest Int Rate Start Maturity Interest Tot Value
CD 1 6 $ 1,000.00 5.0000% 01/01/2006 07/01/2006 $24.70 $ 1,024.70
CD 2 9 $ 1,000.00 5.1000% 01/01/2006 10/01/2006 $38.01 $ 1,038.01
CD 3 12 $ 1,000.00 5.2500% 01/01/2006 01/01/2007 $52.50 $ 1,052.50
CD 4 18 $ 1,000.00 5.2500% 01/01/2006 07/01/2007 $79.77 $ 1,079.77
CD 5 24 $ 1,000.00 5.3000% 01/01/2006 01/01/2008 $108.81 $ 1,108.81
$ 5,000.00 $ 303.79 $ 5,303.79
Roll-Over After 1st Maturity
Months Invest Int Rate Start Maturity Interest Tot Value
CD 1 6 $ 1,024.70 5.0000% 07/01/2006 01/01/2007 $25.30 $ 1,050.00
CD 2 9 $ 1,038.01 5.1000% 10/01/2006 07/01/2007 $39.46 $ 1,077.47
CD 3 12 $ 1,052.50 5.2500% 01/01/2007 01/01/2008 $55.26 $ 1,107.76
CD 4 18 $ 1,079.77 5.2500% 07/01/2007 01/01/2009 $86.14 $ 1,165.91
CD 5 24 $ 1,108.81 5.3000% 01/01/2008 01/01/2010 $120.65 $ 1,229.46
$ 5,303.79 $ 326.80 $ 5,630.59
Roll-Over After 2nd Maturity
Months Invest Int Rate Start Maturity Interest Tot Value
CD 1 6 $ 1,050.00 5.0000% 01/01/2007 07/01/2007 $25.93 $ 1,075.93
CD 2 9 $ 1,077.47 5.1000% 07/01/2007 04/01/2008 $40.96 $ 1,118.42
CD 3 12 $ 1,107.76 5.2500% 01/01/2008 01/01/2009 $58.16 $ 1,165.91
CD 4 18 $ 1,165.91 5.2500% 01/01/2009 07/01/2010 $93.01 $ 1,258.92
CD 5 24 $ 1,229.46 5.3000% 01/01/2010 01/01/2012 $133.78 $ 1,363.23
$ 5,630.59 $ 351.83 $ 5,982.42
CD Ladder - Five Year Cycle
Start Date: 01/01/2006
Amount Invested (Each CD): $ 1,000.00
Total Investment: $ 5,000.00
Interest After 1st Maturity: $ 845.89
Interest After 2nd Maturity: $ 1,024.60
Interest After 3rd Maturity: $ 1,245.81
Total Interest after 15 years: $ 3,116.31
Total Investment Value: $ 8,116.31
First Purchase
Years Invest Int Rate Start Maturity Interest Tot Value
CD 1 1 $ 1,000.00 5.2500% 01/01/2006 01/01/2007 $52.50 $ 1,052.50
CD 2 2 $ 1,000.00 5.3000% 01/01/2006 01/01/2008 $108.81 $ 1,108.81
CD 3 3 $ 1,000.00 5.2500% 01/01/2006 01/01/2009 $165.91 $ 1,165.91
CD 4 4 $ 1,000.00 5.2500% 01/01/2006 01/01/2010 $227.12 $ 1,227.12
CD 5 5 $ 1,000.00 5.2500% 01/01/2006 01/01/2011 $291.55 $ 1,291.55
$ 5,000.00 $ 845.89 $ 5,845.89
Roll-Over After 1st Maturity
Years Invest Int Rate Start Maturity Interest Tot Value
CD 1 1 $ 1,052.50 5.2500% 01/01/2007 01/01/2008 $55.26 $ 1,107.76
CD 2 2 $ 1,108.81 5.3000% 01/01/2008 01/01/2010 $120.65 $ 1,229.46
CD 3 3 $ 1,165.91 5.2500% 01/01/2009 01/01/2012 $193.44 $ 1,359.35
CD 4 4 $ 1,227.12 5.2500% 01/01/2010 01/01/2014 $278.71 $ 1,505.83
CD 5 5 $ 1,291.55 5.2500% 01/01/2011 01/01/2016 $376.55 $ 1,668.10
$ 5,845.89 $ 1,024.60 $ 6,870.50
Roll-Over After 2nd Maturity
Years Invest Int Rate Start Maturity Interest Tot Value
CD 1 1 $ 1,107.76 5.2500% 01/01/2008 01/01/2009 $58.16 $ 1,165.91
CD 2 2 $ 1,229.46 5.3000% 01/01/2010 01/01/2012 $133.78 $ 1,363.23
CD 3 3 $ 1,359.35 5.2500% 01/01/2012 01/01/2015 $225.54 $ 1,584.89
CD 4 4 $ 1,505.83 5.2500% 01/01/2014 01/01/2018 $342.01 $ 1,847.84
CD 5 5 $ 1,668.10 5.2500% 01/01/2016 01/01/2021 $486.33 $ 2,154.43
$ 6,870.50 $ 1,245.81 $ 8,116.31
Looking for Freedom?
Try the Freedom Account Workbook by ExcelGeek
Based on the Freedom Account concept created by Mary Hunt as described in
her best-selling book, Debt-Proof Living (www.debtproofliving.com), this sleek
and spiffy spreadsheet program will dramatically reduce the time and effort it
takes to manage your Freedom Account and sub-account balances.
Written by a devoted fan and active user of the DPL Plan since 2000, this is
not your ordinary little spreadsheet program… read more…
Product Review
http://www.mdmproofing.com/iym/reviews/fa/index.shtml
What is the Freedom Account?
http://www.mdmproofing.com/iym/freedom.shtml
It's Your Money : Home Page
www.MoneySpot.org
Free Excel Spreadsheets
http://www.mdmproofing.com/iym/excel.shtml
Debt-Proof Living
www.debtproofliving.com
Email ExcelGeek
ExcelGeek@verizon.net
* This is an advertisement for a commercial web-site. Not affiliated with Mary Hunt or Debt-Proof Living.
