CD Laddering (2-Year) Spreadsheet

Document Sample
CD Laddering (2-Year) Spreadsheet
Description

Simple CD Laddering Spreadsheet for a 2-year cycle across 5 CDs. Enter the rates of your bank and the amount of your investment and the spreadsheet will calculate the rest. Please use attribution for www.gobankingrates.com/cd-rates if including in your website.

Shared by: gobankingrates
Stats
views:
4281
posted:
6/4/2009
language:
English
pages:
1
CD Ladder: 2-Year Cycle

1/1/2009 ###### Total Investment ###### Interest After 1st Maturity 111.20 $ Interest After 2nd Maturity113.74 $ Interest After 3rd Maturity 116.34 $ Total Interest after 6 Years341.28 $ Total Investment Value ######

Start Date Invested (Each CD)



CD Rates CD CD 1 CD 2 CD 3 CD 4 CD 5 Term (Mos) 6 9 12 18 24 APY 1.75% 1.90% 2.30% 2.45% 2.80% Interest Rate 1.75% 1.89% 2.28% 2.43% 2.77% Account Information www.discoverbank.com www.discoverbank.com www.discoverbank.com www.discoverbank.com www.discoverbank.com



*Interest accrues daily and compounds yearly



Instructions:

Items in yellow: Change the start date to the date of initial deposit. Change the total amount invested to match your investment amount. Change the interest rates and APY to match that offered by your account. Insert any account information into account information. The rest will calculate for you.



1st Purchase CD Start Maturity CD 1 1/1/2009 7/1/2009 CD 2 1/1/2009 10/1/2009 CD 3 1/1/2009 1/1/2010 CD 4 1/1/2009 7/1/2010 CD 5 1/1/2009 1/1/2011 Total



Interest $ 17.50 $ 18.90 $ 22.80 $ 24.30 $ 27.70 #####



Value $ 1,017.50 $ 1,018.90 $ 1,022.80 $ 1,024.30 $ 1,027.70 ######



2nd Purchase (Roll-over After 1st Maturity) CD Start Maturity Interest Value CD 1 7/1/2009 1/1/2010 $ 17.81 $ 1,035.31 CD 2 ###### 7/1/2010 $ 19.26 $ 1,038.16 CD 3 1/1/2010 1/1/2011 $ 23.32 $ 1,046.12 CD 4 7/1/2010 1/1/2012 $ 24.89 $ 1,049.19 CD 5 1/1/2011 1/1/2013 $ 28.47 $ 1,056.17 Total ##### ###### 3rd Purchase (Roll-over After 2nd Maturity) CD Start Maturity Interest Value CD 1 1/1/2010 6/1/2011 $ 18.12 $ 1,053.42 CD 2 7/1/2010 1/1/2012 $ 19.62 $ 1,057.78 CD 3 1/1/2011 11/1/2012 $ 23.85 $ 1,069.97 CD 4 1/1/2012 1/1/2014 $ 25.50 $ 1,074.69 CD 5 1/1/2013 4/1/2015 $ 29.26 $ 1,085.42 Total ##### ###### Provided by www.gobankingrates.com




Share This Document



Related docs
Other docs by gobankingrates
CD Laddering (2-Year) Spreadsheet
Views: 4281  |  Downloads: 502
How Not to Write a Credit Repair Inquiry Letter
Views: 770  |  Downloads: 4
Find the Best Savings Account (Checklist)
Views: 711  |  Downloads: 0
Best Savings Account Rates
Views: 1240  |  Downloads: 3
by registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!