CD Ladder

[anon125]

what i am trying to do is this.
put in a figure say $5000.
this is the figure plus inflation that i need to draw out from CDS - one a year.
then with supposed interest and inflation rates figure out how much i need at day one of a 15 year term to finance all this?
http://www.4shared.com/document/KenNt9dm/futureincome.html
this is where i have got to.
thanks all

 

[Akashwani]

Hi,

I don't have a solution, but I bet Mike has a video on something similar to what you want....

http://www.youtube.com/user/ExcelIsFun#p/search/17/ywvJ8Cw6xxI

Type Finance into the search box on Mike's site.

Good luck.

Ak

 

[anon125]

thanks but nothing there solved the problem