View Single Post
  #27  
Old 01-10-2007, 09:33 AM
DespotInExile DespotInExile is offline
Senior Member
 
Join Date: Jul 2005
Posts: 788
Default Re: What\'s your retirement nut?

[ QUOTE ]
Being an accountant I've worked all this out in a huge Excel spreadsheet

[/ QUOTE ]

This isn't something that can be done in Excel. You cant think in terms of low, base, and high case. This is something that needs to be modelled, through a monte carlo simulation, based on historical data about market performance for various asset classes, and historical inflation data. For a good treatment of the problem, see the books by William Bernstein.
Reply With Quote