Retirement Costs

Pre and post retirement review

Main Menus

 
 
   

 

Recent Articles

 
 
   

 

What's New

 
 
   

 

Hot Topics

 
 

2012 COLA Update

Federal retirees in the CSRS retirement system will receive a COLA increase of 3.6 percent in their annuities in 2012, while FERS retirees will receive a 2.6 percent increase. Complete COLA information is available on this site.

Retiree JOB Opportunities

Many job opportunities are available for federal retirees − and those planning to retire soon − to earn additional income in retirement. Our Jobs Board has updated listings targeted to federal retirees. Many companies seek out retired federal employees due to their government experience and contacts. You can also explore high paying opportunities for those that hold current Security Clearances.  

   

 

Retirement Cost Analysis

 

Your expenses, pre and post retirement, must be reviewed so that you and your spouse will know how much you will have to live on after retirement. This section will help you analyze your personal situation and determine how many dollars you will have after paying for the necessities of life. You will be able to determine if your lifestyle will change dramatically. It will also help you focus on the realities of retirement and help you assess whether or not you will need to work part time to supplement your income.

  Read on for additional information:

 

 
Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for Our Email Newsletter
Retirement Costs Menu

Introduction (Continued)

 

Now is the time to pull together all of your receipts, pay statements, secured and unsecured personal loans and bank account information. There are many things to consider for both CSRS and FERS federal employees and the sample spreadsheet included on this page will help you see the value of completing this form. A copy of the Microsoft Excel Retirement Cost analysis spreadsheet is available on this site. 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.

Over 50 and still Single - Find Love PerfectMatch 

Gather Up the following Documents in preparation for completing this spreadsheet:

  • Pay Stubs
  • Insurance Policies
    • Life
    • Auto
    • Home
    • Umbrella
    • Long Term Care
  • Loans
  • Utility costs
  • Other expense items
  • Last years taxes

Table R1, listed below, is not all inclusive and you can add or remove expenses as you see fit on the downloaded version. The sample here is for a federal employee who will soon retire at age 55. He is a CSRS employee and worked 35 years for Uncle Sam. His top grade was a GS-11, step 6.

All expenses are listed on the chart for pre retirement per year and month and again for post retirement per year and month. The last column is for calculating what your spouse will have to live on with current expenses after you pass on. This is a very revealing analysis. Note that in retirement this person will be living on an annuity of approximately $36,985. His total expenses after retirement are $33,835 leaving him with a buffer of just over $3,000 for emergencies. If there are unanticipated expenses or increased costs this person will need to be able to tap other retirement savings such as savings bonds, his Thrift Savings plan, or other investment income. The other option, if you don't have much in your other savings plans, is to continue to work at least part time some where.

NOTE: The example leaves out the spouses income in this example so the retiree will know what their total expenses will be based on the annuitants income only. A spouse could be laid off or stop working for other reasons. This example shows that the total expenses pre retirement are greater than the employee's gross pay and can be typical with working couples. Just one more reason to plan ahead for retirement.

After completing this chart you may determine that it is not feasible for you to retire if you were depending 100% on annuity income. Most in the federal sector have the Thrift savings plan which can substantially augment your retirement income. Others purchased savings bonds through payroll deduction and you and your spouse may be eligible for social security when you reach age 62 or older if you worked over 40 quarters, 10 years, in the private sector. If you are in the FERS system and retire at or after your eligibility date a social security supplement may help you make ends meet. Download our FREE Report - How to be Financially Prepared When You Retire. This report includes the sample cost analysis spreadsheet from this section.

The last column is significant to the surviving spouse. In this example, the surviving spouse's annuity reduces to 55 percent of the retiree's annuity, or $20,341. The survivor has expenses totaling $19,680, way to close for comfort. Ideally, insurance would add a blanket of security for the survivor along with social security, Thrift Savings and other investment income. The survivor may have to change their lifestyle considerably to live comfortably in retirement.

For a professional comprehensive review of your personal situation a Benefits Specialist can prepare a free analysis of your benefits, income and expenses with trend lines that reveal you and your spouses expenses verses total retirement income from all sources. A sample analysis is available online. Notice the trend lines on the report, they are very revealing. This independent service is not affiliated with federalretirement.net.

Request Your FREE Analysis

The above discussion should get you thinking about where you need to go from here. You can cut unnecessary expenses, possibly move to a less expensive home, sell the second car. There are lots of options. Also, in the survivor's case, there are a number of cost cutting things they can do immediately such as change their health insurance from a family plan to self only. This one action alone can save thousands each year. A full survivor annuity election will decrease your net monthly payment buy approximately 10%. Visit our Survivor Concerns page for a complete discussion on this subject.  

 

Calculators that will help you with this process

 

Sample Retirement Cost Analysis Spreadsheet
(Table R-1)



Download our free sample Excel spreadsheet to estimate your income and expenses in retirement. Also review the Assset Allocation Chart for ways to protect your assets for your heirs.
EXPENSE Pre/year Pre/mo Post/year Post/mo Survivor  Comments
Mortgage 13800 1150 0 0 0 Paid off mortgage t
Mtg Taxes 3800 317 3800 316 3800  
Gas 1050 87.5 1050 87.5 1050  
Light 1100 92 1100 92 900  
Phone 500 42 360 30 360  
Water/Sewage 720 60 720 60 432  
Security 0 0 0 0 0  
Garbage 116 10 116 10 116  
Lawn Service 0 0 0 0 0  
Cable 540 45 540 45 540  
Internet Access 363.4 21.95 363.4 21.95 363.4  
Other            
Other            
SUBTOTALS 21989.4 1825.45 8049.4 662.45 7561.4  
             
INSURANCE            
Employee             
FEGLI         59K 237.74 19.81 237.74 19.81 0 75% reduction to $0 at 65
Policy 1       25K 265 22 265 22 0  
Policy 2                   
Home Care 457 39 457 38 0  
Other                
Spouse            
Policy 1       25K 216 18 216 18 216  
Policy 2        3K 0 0 0 0 0  
Home Care 444 37 444 37 444  
Other                
Home 490 40.83 490 40.83 490  
Umbrella 0 0 0 0 0  
Car #1 585 48.75 585 48.75 0  
Car #2 600 50 600 50 600  
Mobile Home            
Motor Cycle            
Health Ins 3692 307.66 3692 307.66 1113.6 Survivor change to self only
SUBTOTALS 6986.74 583.05 6986.74 582.05 2863.6  
             
PAY            
Gross Pay 56,900 4,741 36,985 3,082 20,341  
Deductions            
Social Security            
CSRS Ret  (7%) 3,983 331.87 0 0   Amount paid into CSRS
State Tax   (3%) 1707 142 0 0   PA does not tax retirement
Fed Tax     7,567 630 3,500 291 1500 Varies per exemptions
Medicare 804 67 0 0    
TSP 3,983 367 0 0   No contributions after retire
CFC 26 2 0 0                        "
Savings Bond 1,300 108 0 0                        "
SUBTOTALS 19369.53 1647.87 3500 291 1500  
             
AUTOs            
Car 1 1200 100 600 50 0 Check for rate reductions
Car 2 600 50 500 41 400  
Maint 1 200 17 200 17 0  
Maint 2 200 17 200 17 300  
Loan 2592 216 0 0 0  
SUBTOTALS 4792 400 1500 125 700  
             
FOOD/MISC            
Groceries 8500 704 7000 583 4000  
Clothing 1500 125 1000 83 1000 Depends on habits/etc.
SUBTOTALS 10000 829 8000 666 5000  
             
ENTERTAIN            
Eat Out 1800 150 2400 200 1000  
Misc 1200 100 2400 200 1000  
Other            
SUBTOTALS 3000 250 4800 400 2000  
             
EXPENSES 21989 1825 8049 662 7561  
INSURANCE 8557 721.23 7986.2 664.9 2919  
PAY WITHHOLD 19,367 1697 3500 291 1500  
AUTOS 4192 400 1500 125 700  
FOOD/MISC 10000 829 8000 666 5000  
ENTERTAIN 3000 250 4800 400 2000  
             
TOTAL ALL 67105 5722.23 33835.2 2808.9 19680  

 

Go to Chart Analysis Discussion
Back to Top
Back to Financial Planning Menu
Back to Home Page