Capital Needs Analysis spreadsheet

	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%