FP Explains: The Pros and Cons of Using Retirement Planning Software to Help You Determine Your Needs

Test Drive: Canadians Retirement Prep, or CPR Software, May Be Worth a Look

article content

By Julie Cazzin with Allan Norman

Announcement 2

article content

Good financial planning software can be vital if you want to be in a position to make smart, confident decisions while adapting to change and learning the truth about your money—what it will do for you.

Is software always necessary? Not if you have 100 percent confidence in your advisors and/or yourself, and prefer answers to learning and understanding. Nor if your questions or problems are of a simple nature. Everyone else is more likely to use help, so let’s take a look at a couple of packages that take into account wages, Registered Retirement Savings Plans (RRSPs), tax-free savings accounts (TFSA) and other sources of income.

The HEC Montréal Savings and Retirement Institute provides free software, Preparing Canadians for Retirement (CPR), whose purpose is to determine a fixed retirement income based on current assets and future savings.

Announcement 3

article content

I went through the software by entering information for two fictitious people who want to retire at age 65.

The first is a male, born in 1963, who lives in Ontario and earns $150,000 in annual income, with RRSPs totaling $600,000 and TFSAs totaling $100,000. He is making maximum contributions to both, and has no pension.

The second is a female, born in 1962, resident in Ontario, with an annual income of $60,000, with an RRSP of $100,000 (no further contributions made) and a TFSA of $100,000 (maximum contributions made), and an annual pension of $20,000.

The software works out a “consumption” replacement income, equal to your total income minus taxes, debt payments, and savings, at 80 percent and 65 percent retirement.

Announcement 4

article content

Using what appears to be a sophisticated database, the program estimates your investment returns based on your current investments. Taxes are based on Quebec and Ontario provincial rates, with the suggestion to use Ontario rates if you are not from Quebec.

The program also assumes the full benefits of the Canada Pension Plan and Old Age Security for everyone once retirement begins, at which point all of your financial assets are converted into an annuity.

There are other assumptions or generalizations that I suspect allow the program to remain free for all.

It was quite easy to enter your information and there are options to add property and business values. Once everything was entered, I clicked a button and the results of their combined income appeared in the following table:

ad 5

article content

Reviewing the main scenario in the top row, consumption income (total income minus taxes, debt payments, and savings) before retirement is $125,128. The software suggests that 95 percent of that income could be replaced, or $118,695. The program assumes an inflation rate and indexes the previous two figures.

Looking down each row, you can see the differences as you increase your savings or retire sooner or later.

After adding your information and viewing the results, you can go back and change your savings rates and view a different set of results.

CPR is pretty good for a free software program. It is useful? I’m not sure. It provides an answer, but does it provide enough experiential learning to aid decision making?

ad 6

article content

If all you want to know is how much fixed income you can expect in retirement, then this may be the software for you. But if you want to know whether or not you could spend an extra $10,000 a year traveling for the first 15 years of your retirement, then maybe not.

Is it accurate? I’m guessing it is, based on the assumptions made and the data sources used. I’m not sure it’s believable. Generalizations made within the software cast doubt on the output, whether it is accurate or not. I can be more confident in the numbers if I could see the rates of return used.

ad 7

article content

Having said that, the free CPR program isn’t bad, and to be fair, I’m comparing it to professional planning software, which is way over the top.

The other freeware you might want to check out is MINUTEan improved personal retirement calculator of LifeWorks Inc. (formerly Morneau Shepell) as well as what if i from Anthill Inc. I came across Whatifi while preparing to write this article. It’s not quite ready to run retirement plans, but it can be helpful in making everyday financial decisions. It reminds me of mind mapping software and is one to look out for.

As I said at the beginning, good software in the hands of a knowledgeable and experienced person is a vital combination for solving the hyper-complex questions associated with lifestyle and financial planning. Try the freeware I’ve listed and you’ll learn something at the very least.

Allan Norman, M.Sc., CFP, CIM, RWM, is a Paid Certified Financial Planner with Atlantis Financial Inc. and a Fully Licensed Investment Advisor with Aligned Capital Partners Inc. He can be contacted at www.atlantisfinancial.ca or alnorman@atlantisfinancial.ca. This commentary is provided as a general source of information and is intended for Canadian residents only.


If you liked this story, sign up for more in the FP Investor newsletter.




Postmedia is committed to maintaining a lively but civil discussion forum and encourages all readers to share their thoughts on our articles. Comments can take up to an hour to be moderated before appearing on the site. We ask that you keep your comments relevant and respectful. We’ve enabled email notifications – you’ll now receive an email if you receive a reply to your comment, there’s an update in a comment thread you follow, or if a user you follow comments. visit our Community Principles for more information and details on how to adjust your E-mail settings.

Previous post Young people struggling amid inflation have a right, says CEO, valued at some $400 million | Arwa Mahdawi
Next post The release of 180 million barrels in the US will stabilize the market