Financial Planning Software  
Financial Planning Software menu navigation fade.


REASONS TO PLAN EARLY:
APPLICATIONS OF RETIREMENT PLANNING SOFTWARE:

Sandra L. Reynolds, Ph.D.
Associate Professor, Gerontology Department
University of South Florida
sreynold@chuma1.cas.usf.edu
 

As part of the retirement planning process, there are a host of choices when it comes to choosing software, both for the professional and for individuals.  In general, most consumers use retirement planning software (RPS) to gain some sense of their ability to retire with some measure of financial security.  While the retirement planning process is a complex one that should involve consultation with a professional, analyzing individual and family resources, goals, expectations, and obligations, among other factors.  RPS can be a good place for the consumer to start.  Software can help individuals to estimate the amount of funds they will need to put away in order to retire when they want and in a manner that suits themselves and their families.  Because of the complexity of the retirement planning process, the software should have the flexibility to alter various assumptions, in effect, to provide “what if” scenarios for the potential planning client to consider.   

Some critical features in RPS include programs that allow the professional to examine life cycle consumption models, probability analysis, and visual presentation capabilities.  In cases where software does not provide comprehensive information or capability, some professionals end up using multiple programs.  For the professional, ideally the desired features in retirement planning software would include: 

1)      The ability to estimate different inflation and tax rates before and after retirement

2)      The ability to plan for different rates of return on investments before and after retirement

3)      The flexibility to present different budgeting scenarios – varying income and expenses, both before and after retirement

4)      The ability to choose the order and amount of distributions from investments, whether personal or benefits-based.

5)      The flexibility to estimate retirement needs using different life expectancies     

6)      The ability to produce “what if” scenarios--the software should be able to demonstrate readily the impact of changing a single or multiple assumptions present comparisons in a comprehensible manner.

7)      The data output should be clear and in terms that the average client can understand. 

The following examples give a simplistic, but fairly clear view of the kind of guidance that retirement planning software can give a mature worker.  In this case, we have a 55-year-old person we will call John Doe.  Mr. Doe expects to retire when he is 65, and his life expectancy is 87, so he will need post-retirement income for at least 22 years.  He has assets that will provide income in retirement, currently valued at:

Equity in house                        $35,000

401K                                         40,000

Rollover IRA                             35,000

As he is not sure how easy it will be to access the equity in his home, he decides to plan conservatively based on $75,000 in assets.

Initially, he plans for an 8.0% return on his investments, and an inflation adjustment of his retirement income of 3.0%.  He estimates that $22,000 would suffice for his post-retirement income, in today’s money. 

After providing his financial advisor with all of the necessary information, he receives information that looks similar to this: 

RETIREMENT CALCULATOR

 

Prepared for

 

 

 

 

John Doe

 

Current Age

 

 

 

 

55

 

Desired Retirement Age

 

 

 

65

 

# of Years income required

 

 

 

22

 

Existing Assets which will provide income

 

 

 

75,000.00

 

Monthly Savings – Target

 

 

 

1,000.00

 

Annual Rate of Return on investments

 

 

 

8.000%

 

Retirement Inflation Rate (Indexing)

 

 

 

3.000%

 

Annual Income Required at Retirement

 

 

 

22,000.00

 

RESULTS

Percent of Goal

Funds Accumulated by Retirement Age

 

 

 

343,202.57

113%

Income Available for retirement period (indexed)

 

 

 

 

 

24,831.69

 

 

 

 

 

 

 

 

 

SOLUTION

 

Funds Required for Retirement

 

 

 

304,065.36

 

Monthly Savings Required to Reach Your Goal

 

 

 

784.11

 

Using this scenario, based on a complete set of information already shared with the financial advisor, this plan appears to give Mr. Doe good news regarding his future financial state.  This plan tells him that, all things being equal, the current money he puts away for retirement is more than sufficient (13% more) to meet his goals; in fact, he could cut down his contributions to $784 per month and make his goals.

However, his financial advisor advises him that counting on an 8.0% yield over the next 30 years may be overly optimistic; the advisor suggests that Mr. Doe plan instead on an average rate of 5.0%.  With nothing else changed, the plan now looks like this: 

RETIREMENT CALCULATOR

 

Prepared for

 

 

 

 

John Doe

 

Current Age

 

 

 

 

55

 

Desired Retirement Age

 

 

 

65

 

# of Years income required

 

 

 

22

 

Existing Assets which will provide income

 

 

 

75,000.00

 

Monthly Savings - Target

 

 

 

1,000.00

 

Annual Rate of Return on investments

 

 

 

5.000%

 

Retirement Inflation Rate (Indexing)

 

 

 

3.000%

 

Annual Income Required at Retirement

 

 

 

22,000.00

 

RESULTS

Percent of Goal

Funds Accumulated by Retirement Age

 

 

 

277,159.15

70%

Income Available for retirement period (indexed)

 

 

 

 

 

15,388.15

 

 

 

 

 

 

 

 

 

SOLUTION

 

Funds Required for Retirement

 

 

 

396,246.60

 

Monthly Savings Required to Reach Your Goal

 

 

 

1,768.35

 

Clearly, this news is less favorable, but probably more realistic.  By counting on a more conservative return on investments, the amount he currently puts away means that his plan will fall 30% short of meeting his goal for the future; in fact, he should be putting away $1700 per month.  Here is what his plan looks like, if he agrees to put $1700 away each month: 

RETIREMENT CALCULATOR

 

Prepared for

 

 

 

 

John Doe

 

Current Age

       

55

 

Desired Retirement Age

     

65

 

# of Years income required

     

22

 

Existing Assets which will provide income

     

75,000.00

 

Monthly Savings - Target

     

1,700.00

 

Annual Rate of Return on investments

     

5.000%

 

Retirement Inflation Rate (Indexing)

     

3.000%

 

Annual Income Required at Retirement

 

 

 

22,000.00

 

RESULTS

Percent of Goal

Funds Accumulated by Retirement Age

 

 

 

385,653.59

97%

Income Available for retirement period (indexed)

 

 

 

 

 

21,411.87

 

 

 

 

 

 

 

 

 

SOLUTION

 

Funds Required for Retirement

 

 

 

396,246.60

 

Monthly Savings Required to Reach Your Goal

 

 

 

1,768.35

 

Mr. Doe feels that he can afford to put $1700 away each month, but he also is worried about the projected life expectancy.  Calculating the population’s life expectancy is fairly easy, but an individual life expectancy depends on many factors other than average death rates, including genetic disposition, lifestyle and other health behaviors, and individual medical history.  The advisor and Mr. Doe decide to include one other scenario, one in which he exceeds his life expectancy by just 3 years, to age 90, requiring 25 years of post-retirement income.  His plan now looks like this: 

RETIREMENT CALCULATOR

 

Prepared for

 

 

 

 

John Doe

 

Current Age

 

 

 

 

55

 

Desired Retirement Age

 

 

 

65

 

# of Years income required

 

 

 

25

 

Existing Assets which will provide income

 

 

 

75,000.00

 

Monthly Savings - Target

 

 

 

1,700.00

 

Annual Rate of Return on investments

 

 

 

5.000%

 

Retirement Inflation Rate (Indexing)

 

 

 

3.000%

 

Annual Income Required at Retirement

 

 

 

22,000.00

 

RESULTS

Percent of Goal

Funds Accumulated by Retirement Age

 

 

 

385,653.59

88%

Income Available for retirement period (indexed)

 

 

 

 

 

19,366.03

 

 

 

 

 

 

 

 

 

SOLUTION

 

Funds Required for Retirement

 

 

 

438,106.36

 

Monthly Savings Required to Reach Your Goal

 

 

 

2,038.42

 

Going back to the original scenario, with life expectancy at 87, Mr. Doe wonders what will happen to him if he has a heart problem and he has to retire earlier than he anticipated, say, around age 60.  Using the same assumptions, but changing the length of time he would need post-retirement income, his plan would now look like this: 

RETIREMENT CALCULATOR

 

Prepared for

 

 

 

 

John Doe

 

Current Age

 

 

 

 

55

 

Desired Retirement Age

 

 

 

60

 

# of Years income required

 

 

 

27