Retirement Worksheet
Annual Retirement Income Need	125,000
Years until Retirement	40
Years in Retirement	35
Rate of Return before Retirement	10.00%
Rate of Return during Retirement	6.00%

A) You must calculate the amount of money you require the day you retire to fund your anticipated retirement needs of $125,000 per year for 35 years while earning 6% in retirement. B) How much would you need to invest today as a single sum to fund your retirement? C) Once you have calculated the funds required the day you retire the next step is to calculate the annual payment required to reach your goal D) To calculate the monthly payment we must adjust both the interest rate and the number of compounding periods. adjustments yearly rate /12 and number of years * times per year