Capital Needs Analysis:
Investment Portfolio at Retirement
 
 
  Years to Retirement  Year of Retirement  
  Years in Retirement  Life Expectancy  
  Current Portfolio Amount      
  Inflation Rate      
  Investment Return      
       
  Today's Dollars        
  Expected Income Requirement      
  Outside Sources of Income (-)      
  Income Needed from Investments  (Today)  
         
First Year Of Retirement
    First Year's Withdrawal
  (Inflation-Adjusted)
 1st Year of Retirement  
         
  Minimum Investment Portfolio Size
at Retirement
Monthly Savings
Required
   
  1. Run the Portfolio Down to Zero    
  2. Maintain Same Dollar Amount    
  3. Number 2. Inflation-Adjusted    
  4. Withdraw no more than 4%     
             
     

                     Spreadsheet Explanation

copyright © George Fisher Advisors 2004 - 2010 | disclaimer

                              home page