Now is the time to pull together all of your
receipts, pay statements, loans and bank account information. There are many things to consider and the
sample spreadsheet included on this page will help you see the value of completing this form. Click
here for a copy of the
Microsoft Excel analysis spreadsheet. You can save the
spreadsheet to your local computer hard drive and work
on it off line.
This spreadsheet
shows approximately what you will have left over after
you pay all of your bills before and after you retire.
The last column represents what your survivor will have
remaining from their reduced annuity after you die. This
exercise provides an opportunity for you to review and
make changes to increase you retirement income.