A few testimonials...
From Art Kingsley, Leonardtown, MD: “I have used a number of PC-based financial planning software packages, some free, some at a cost. By far, PRC offers the best value and capability! You get what you spend with most free calculators. Not only does PRC calculate a standard of living based on accurate expense and income calculations, its output is fully transparent, easy to follow, and verifiable. If you don’t want to verify, rest assured complex calculations are being correctly applied. You can start with a simple model and add complexity as you go along. With its historic analysis capabilities and superior input and output interface, the Pralana Retirement Calculator now far exceeds the more expensive ESPlanner. Its capabilities are truly immense.”
From Dwayne C, Gardner, MA.: “I love this program…so powerful yet fairly easy to use. It has made our retirement planning much more a plan as opposed to a guess. I’ve endorsed it on Darrow Kirkpatrick’s website as well as with friends and relatives. And frankly, this is without a doubt the best $100 I have ever spent…for the price of a nice dinner out, getting to see where you’ll stand financially in the future based on where you are today…it really is a great bargain.”
From Bryan D., Chicago, IL: “PRC is very powerful and easy to use financial planning software. I have tried many other financial planners (including ESPlanner) and for my purposes PRC is the best! PRC allows you to quickly enter your income, expenses, and assets to see a year-by-year projections of future cash flow, taxes, savings, and net worth. It has very robust calculations including factoring in inflation, taxes, social security, and life insurance. It allows you to quickly change assumptions (e.g. inflation, life expectancy, tax rates) and view different scenarios. I really like the analysis page that graphically shows three different scenarios side-by-side. I highly recommend PRC.”
Here’s an in-depth, qualitative and quantitative comparison of over a dozen retirement calculators. Read on...
Calculator Evaluation list:
Pralana Retirement Calculator
Flexible Retirement Planner
Ultimate Retirement Calculator
T Rowe Price Retirement Income
AARP Retirement Calculator
MSN Money Retirement Calc
Charles Schwab Retirement Calc
Vanguard Retirement Income
Vanguard Nest Egg Calculator
Fidelity Retirement Income Planner
With PRC2015/Gold, you can:
Analyze 3 independent scenarios simultaneously using fixed rate, Monte Carlo and historical analysis methods
Model key assumptions, complex income streams, investment assets, property expenses, education expenses, healthcare expenses and discretionary expenses
Start simple and add complexity anytime you wish
Perform a complete life cycle analysis with consumption smoothing, life insurance recommendations and survivor scenarios
Keep synchronized copies on your home computer and your office or travelling computer
This is the first of several top-down technical articles on retirement calculators. It has been prepared by the designer of the Pralana Retirement Calculator but it is written objectively and will not get into the highly subjective business of suggesting “the best retirement calculators”. Armed with the knowledge presented in this article and others to follow, you will be equipped to assess for yourself the goodness of a retirement calculator and the extent to which it can be trusted to provide accurate and/or useful information, and then determine which one (s) might be “best” for YOU.
This first article works its way into the subject matter from a very high level and starts the process of peeling back the skin of a retirement calculator. The second article will peel that skin back all the way and explore the effects of various design choices on a calculator’s outputs. The third article will address some advanced topics and hopefully facilitate your efforts to get the most out of a retirement calculator.
Retirement Calculators 101 (The formula for creating a prognosis)
Retirement calculators are about one fundamental thing: they create a long term prognosis of your financial health based on certain assumptions and then allow you to change some or all of those assumptions to observe the effects on that prognosis. Here, in the simplest mathematical form possible, is the formula for creating that prognosis:
Long term prognosis = initial savings + growth of savings + deposits to savings – withdrawals from savings, projected out over your lifetime. The terms of this formula are defined as follows:
Retirement Calculators 102 (Defining the terms comprised by the prognosis formula)
Growth of savings is often referred to as “rate of return” and is always expressed as a percentage. This percentage is then used to determine how the value of the savings accounts change each year, independent of any new contributions or withdrawals. For example, if the growth is 5%, then the size of the account at the end of year 2 will be 105% of what it was at the end of year 1 (ignoring the effects of inflation).
Your income, which is indirectly affected by inflation, includes wages, salaries, pensions, Social Security benefits, annuity payments, contributions made on your behalf by others (such as company-matching on your 401k contributions), windfalls such as inheritances, life insurance, or the selling of your home. Your expenses, which are usually directly affected by inflation, are every dime you spend, including payroll deductions, taxes, down payments on new property, house payments and utility bills, car payments and maintenance, gasoline, healthcare, college educations, food, clothes, vacations and so on. The difference between your income and your expenses determines whether you’re making deposits to or withdrawals from savings. Let’s call this difference ΔIE (delta IE, where delta refers to difference, I refers to income and E refers to expenses). When ΔIE is positive, you have a net deposit in the amount of ΔIE; when ΔIE is negative, you have a net withdrawal in the amount of ΔIE.
To create the projection of your savings, the retirement calculator simply has to do the following:
Retirement Calculators 201 (Growth of Savings)
For the sake of this discussion, let’s say that savings accounts come in the following forms:
There are some issues that arise when trying to model these savings accounts in a retirement calculator:
The answers to the above questions have a direct bearing on the complexity of the calculator and on the complexity of the calculations the user has to perform just to make reasonable inputs to the calculator. All of this will be addressed further in the next article.
Retirement Calculators 202 (Calculating ΔIE)
Calculating ΔIE, which is income minus expenses, is a simple thing once annual income and annual expenses are known; however, defining income and expenses involves some complexities and this is where we can find significant differences in the approaches used by the designers of retirement calculators.
As previously stated, your income includes wages, salaries, pensions, Social Security benefits, annuity payments, contributions made on your behalf by others (such as company-matching on your 401k contributions), windfalls such as inheritances, life insurance, or the selling of your home. One way or another, every retirement calculator must collect information from the user related to the various income streams and create an “income profile” that projects the user’s income into the future, including annual adjustments as appropriate.
As also previously stated, your expenses are every dime you spend, including payroll deductions, taxes, down payments on new property, house payments, healthcare, and college educations. One way or another, every retirement calculator must collect information from the user related to the various expense streams and create an “expense profile” that projects the user’s expenses into the future, including annual inflationary adjustments as appropriate.
Expense streams and, to a lesser extent, income streams, tend to be more complex during the accumulation phase than in the distribution phase because they include things like fixed rate mortgages which eventually get paid off, child-rearing/education expenses which taper off as the kids leave the nest, and company matching on contributions to 401k’s. To avoid this complexity, a common design choice is to treat the accumulation phase differently than the distribution phase. In this case, the calculator will not create income or expense streams during the accumulation phase and will instead simply ask the user to tell it ΔIE, (i.e., savings contributions during your working years). Armed with this number, all the calculator has to do is adjust it for inflation (or not) and add it to the growth-adjusted savings balance each year throughout the accumulation phase to create that portion of the calculator’s long term projection. Because the central focus of most of these tools is the retirement (or distribution) phase rather than accumulation phase, the vast majority of retirement calculators use this approach.
Moving ahead into the distribution phase, all retirement calculators actually perform the ΔIE calculation and use the user’s income- and expense-related inputs in doing so; however, there are large variations in the approaches used by retirement calculators in collecting these inputs. Approaches for collecting income vary from asking the user to specify Social Security and pension income to allowing the user to define multiple income streams for both husband and wife, including part-time employment or self-employment, Social Security, multiple pensions, annuities and windfalls. Approaches for collecting expenses range from asking the user to specify a single number representing total expenses for all time (commonly specified as a percentage of pre-retirement income) to specifying the details of a large variety of expense streams with variations over time, such as property, child-rearing, healthcare and discretionary expenses.
Retirement Calculators 203 (Taxes)
A complicating factor intentionally omitted from the discussion on calculating ΔIE is taxes, specifically income and FICA taxes. Taxes are an expense, but there is no standard way for treating taxes in the world of retirement calculators. Here are some of the approaches in use:
This disparity in the handling of taxes is one of the reasons why you can observe very different results from various calculators to seemingly the same input data. The next article will clearly explain why the different approaches yield different outputs and quantitatively address the sensitivity of long term projections to errors in tax calculations.
Retirement Calculators 204 (Keeping track of your savings)
As a quick review, we’ve now discussed the growth of savings and the calculation of deposits to and withdrawals from savings, including the effects of taxes. Let’s now turn our attention to keeping track of your savings as it grows or declines and as we make deposits and withdrawals.
If the calculator treats all savings as one common pool and simply doesn’t try to model the unique characteristics of separate types of savings, then all it has to do is add annual ΔIE to the old balance to get the new balance. A subset of these calculators recognize that withdrawals from savings can be a taxable event and apply a tax burden on all withdrawals based on the user-supplied tax rate.
The calculators that manage the various savings accounts separately must deal with considerably more complexity than those that model savings as a single pool of money. In these calculators, a positive ΔIE is probably treated as a deposit to regular savings but when ΔIE is negative these calculators must determine which account to take the withdrawal from. The order in which withdrawals are taken across the various savings types may or may not be under the user’s control. A common approach would be to take it from regular savings first and when that’s depleted, then go to either tax-deferred or tax-free accounts to cover the deficit. In any case, the calculator must establish the order in which withdrawals are to be taken whenever negative cash flow (negative ΔIE) situations occur and it must work its way from one account to the other whenever the withdrawals result in the depletion of one or more of the accounts (possibly when negative ΔIE is large and prolonged over several years). When this process results in withdrawals from tax-deferred savings, this is a taxable event which in turn affects expenses. When this process results in withdrawals from regular savings, this may be a taxable event with an attendant effect on expenses. It depends upon whether the growth of the regular savings is taxable as simple interest/dividends (taxable annually as the growth occurs) or taxable as long term capital gains (taxable only when withdrawals are made and then only on the growth and not on the principle). Some calculators have the capability to fully model this while others always assume growth is to be treated as simple interest.
Calculators that keep track of the balance of tax-deferred accounts typically also deal with the issue of Required Minimum Distributions (RMD’s) and automatically generate taxable withdrawals starting at age 70 or 71. These RMD’s can be treated as additional income or as additional deposits to regular savings. Regardless, the RMD’s must be accounted for in the process of keeping track of the balances of the various types of savings accounts. They matter because they’re a taxable event which has ramifications on annual expenses.
So, here’s a simple question to ponder: Presumably there are financial advantages and disadvantages to regular accounts vs. tax-deferred accounts vs. tax-free accounts and it makes a significant enough difference for us to employ different accounts in preparing for retirement; otherwise, we’d just put all our money in one account and not worry about it. Does a similar consideration come into play when it comes to modeling our savings over time in a retirement calculator? Does trying to model the complexity described above actually matter when it comes to a prognosis of your financial future? Think about it and we’ll come back to it in Retirement Calculators 304.
Retirement Calculators 301 (Sensitivity of Long Term Projections to Simplified Accumulation Phase Modeling)
This discussion is moot if you’re already retired or quickly approaching retirement. Otherwise, it might be pertinent to you. The reason it matters is that the accuracy of your portfolio estimate at the start of your retirement is a function of how accurately your accumulation phase is modeled. Inaccuracies in this estimate will then be magnified over the distribution period because of the law of compounded returns.
To be clear on the terminology, the accumulation phase generally refers to your pre-retirement years when you’re building your savings and the distribution phase generally refers to your retirement years when you’re making withdrawals from your savings to cover retirement expenses. Regarding the modeling of these phases, retirement calculators tend to fall into one of two categories:
To get specific about potential difficulties in determining a single value representing ΔIE, here are a few examples of expenses that are likely to occur during the accumulation period which can make it difficult to come up with a good average annual contribution amount:
You may be thinking that inputting ΔIE directly is ideal because that allows you to set up the calculator to be consistent with your real-world payroll deductions for contributions to savings. There are two major issues with this:
Clearly, then, errors will be introduced into a calculator’s prognosis whenever it asks the user to specify the average savings contributions per year and if, over time, that number isn’t consistent with the expected difference between income and expenses. Check out the table below to get a feel for the effect of this type of error. It shows how errors in savings contributions to taxable savings during a 15-year accumulation period would be magnified during retirement periods of 20 and 30 years, including the effects of taxes.
So, an input error of only $1000 per year for 15 years will lead to a 4% error in the portfolio’s ending value after a 30-year retirement, but an input error averaging $5000 for a 15-year accumulation period will lead to a 20% error after a 30-year retirement.
In the final analysis, this may or may not matter to you depending upon your circumstances and what you want to achieve with the retirement calculator. It doesn’t matter at all if you’re already retired or are nearing retirement. It probably won’t matter too much if you’ve adopted a repetitive approximation approach for evaluating retirement readiness wherein you take a quick look once in a while with your latest numbers. It may matter a lot if you’ve still got a long way to go to retirement and are using the calculator to assist you in evaluating the long term financial impacts of multiple lifestyle alternatives.
Retirement Calculators 302 (Determining Retirement Income Requirements)
As a quick refresher, we’ve defined the term ΔIE to be the difference between income and expenses and have stated that a positive value represents a positive cash flow and net deposits to savings while a negative value represents a negative cash flow and net withdrawals from savings. Some retirement calculators use the term “retirement income requirements”, but what they’re really talking about are your expenses in the distribution phase.
Regardless of the terminology used to refer to expenses, this is another area where we can differentiate low fidelity from high fidelity calculators. Many calculators only allow expenses to be defined by a single summary-level value while others allow for expenses to be defined to whatever level of detail the user desires. Some of the latter category of calculators go so far as to model college educations, home mortgages and other property-related expenses, healthcare expenses that vary greatly from early to late retirement, one-time expenses, and so on. Clearly, the first group of calculators belongs to the low fidelity category while the second group meets at least one important criterion for a high fidelity calculator.
There are rules of thumb suggesting that retirement income requirements (i.e, expenses during your retirement years) should be assumed to be a particular percentage of your pre-retirement income, and many retirement calculators ask for your input in those terms. The author of this article considers that to be complete nonsense and will not propagate any such numbers here. Unless you’ve continually raised your standard of living to keep up with your income throughout your working years, your expenses in retirement will not necessarily be a high percentage of your income at the time you retire. The fact is that the only way to know what your retirement-era expenses are going to be is to figure it out, then review and update it from time to time. As a starting point, you can look at your current expenses and determine which of them you’ll still have after you retire and for how long, and quantify them in terms of today’s dollars. If you plan to downsize your home, write that down along with the related details. If you plan to take up new activities, maybe you need to add an expense item or two.
With that said, there are really two fundamental ways of going about this:
Retirement Calculators 303 (Sensitivity of Long Term Projections to the Tax Handling Approach)
You may be of the opinion that it’s a waste of time to attempt to model taxes because we don’t know what Uncle Sam is going to do to tax rates in the future. I believe the correct approach is to use the best information available (i.e., the current tax code) to establish a baseline plan, supplement that with a sensitivity analysis based on potential future tax increases, and then revisit your analysis from time to time to make updates based on any new information that has become available.
With that said, retirement calculators generally fall into one of three tax-handling categories: 1) those that perform detailed tax calculations, 2) those that account for taxes based on user-specified tax rates and 3) those that ignore taxes. If you go with one of those that perform detailed tax calculations, you simply do not have to concern yourself with taxes and can be reasonably confident that they’re being accounted for accurately. If you go with one of those that estimate taxes based on user-specified tax rates, then you have to accurately determine the proper tax rate to use and how it might vary over time and enter that into the tool, knowing that most tools only accept a single rate that applies to the entire modeling period. Finally, with the set of tools that ignores taxes altogether, you can either choose to ignore taxes yourself, or you can figure your tax rate and then manually adjust your income and expense inputs to the tool to account for taxes.
The first set of tools (those that perform detailed tax calculations) requires you to do no tax-related math yourself. The next set requires you to determine your income tax rate and/or your investment tax rate for your working years, early and late retirement years and then, for most calculators, boil them down to a single average value. The last set requires you to do everything the second set does in addition to using that value to adjust all of your income and expense values. So, not only do you have to do more work in the second and third cases, but there’s also increased risk of error.
Going back to the subject of performing a sensitivity analysis on tax rates, some calculators make this easier and less error prone than others and fall into one of two categories: 1) those that allow you to specify tax rate changes at specific times in the future and 2) those that use the same tax rate across the whole modeling period or ignore taxes altogether. If you use one of the latter set, you will have less control over your analysis and will have to do more work yourself. In the Calculator Evaluation article on this website, four of the five tools in the High Fidelity set perform detailed tax calculations AND allow you to specify future tax rate increases (amount and date), as well as decreases in Social Security benefits. The fifth tool (Flexible Retirement Planner) doesn’t do detailed tax calculations but it does allow you to specify both income and investment tax rates (and Social Security benefits) on a year by year basis if you so choose.
Ignoring ease-of-use issues and user-induced errors, I decided to do some testing to try to quantify the affect different tax-handling approaches might have on calculator outputs. To get the absolute best apples-to-apples test I could, I used just one calculator (Flexible Retirement Planner - FRP) and then modeled taxes using three different approaches for the distribution period (all approaches were identical for the accumulation period): Approach 1) with several periods of different tax rates, with rates as measured by the Pralana Retirement Calculator (PRC) which performs detailed tax calculations, Approach 2) with a constant tax rate, using the average measured by PRC and Approach 3) with tax rate set to zero and income and expenses adjusted to compensate for taxes, again using the average tax rate as measured by PRC. Using only test case 1 defined in the Calculator Evaluation article (60 year-old couple beginning a 40-year retirement with $1,100,000 and $24,000 of Social Security income starting at age 66) and with all other parameters exactly the same for each tax-handling approach being evaluated, here are the final savings balances (in today’s $) I observed:
Observation #1: there was only a 3% error introduced by using a constant tax rate rather than a nuanced tax rate.
Observation #2: if you manually compensate for taxes by adjusting income and expenses, the errors are worsened if there are periods where you actually pay no taxes, such as the first several years of Case 1 where all expenses are covered by withdrawals from taxable savings. So, in this case, expenses are exaggerated by modeling taxes which may not actually have to be paid.
Observation #3: Even though the exact same average tax rate was used for approaches 2 and 3, substantial differences in the final savings balances were projected. There are two reasons for this:
I repeated this tax analysis using Case 2 (involving both accumulation and distribution periods) and got similar results and for the same reasons:
Finally, I decided to do one more test. Conclusion #2 above says it doesn’t make much difference whether you use a flat tax rate or a more nuanced one; however, it doesn’t say anything about user-induced errors in the specification of those flat tax rates. So, for this test, I again used FRP and the test case 1 scenario, but with three different tax rates: 8%, 9% and 10%. Final savings balances were as follows:
Conclusion: Absolute precision in specification of your tax rate is not crucial; however, just making a rough estimate will probably result in substantial errors. For this test case, it appears that each 1% error in tax rate results in an 8% error in the final savings balance. This error is avoidable by using a calculator that performs detailed tax calculations.
Retirement Calculators 304 (Sensitivity of Long Term Projections to Pooled vs. Separate Savings Accounts)
Previously, a question was posed on whether it makes a significant difference whether a retirement calculator models savings accounts separately according to their unique characteristics or simply models them as a common pool. The test case described below, involving only the distribution phase, is enlightening. In this case, there’s $1,000,000 in savings at the start of a 30-year retirement that begins at age 65, and retirement expenses are about twice the retirement income such that withdrawals from savings will be made throughout the retirement years. The exercise here is to study the differences in the final savings balance with respect to variations in how the $1M is split between tax-deferred, Roth and taxable savings accounts, and the extent to which the growth of taxable savings is due to simple interest or capital gains (which affects its taxation). This test was performed using the Pralana Retirement Calculator (Gold version) which performs detailed federal income tax calculations with no tax rate inputs from the user. The rate of return is the same on all accounts. Taxable account balances go above zero despite a zero initial balance due to RMD’s. The details are presented in the table below, in today’s dollars.
We can readily conclude from this data that there are significant differences in final account balances depending on whether the calculator models separate savings accounts or simply treats them as a common pool. We can see up to 19% variation depending simply upon whether the growth of regular savings is simple interest or capital gains (see the case where the $1M is split between tax-deferred and taxable savings at the start of retirement). Additionally, we can see up to 18% variation depending upon how the money is split between the various accounts at the start of retirement even with no variation in whether the growth of regular savings is simple interest or capital gains.
In real world investing, we choose to put money in different types of accounts because it really does matter, and these findings indicate that it matters in the world of modeling as well.
Retirement Calculators 305 (Ease of Use Issues)
Retirement Calculators 306 (Analysis Methods)
Retirement Calculators 307 (Unknowns, Cautions and Risks)
Retirement Calculators 401 (Consumption Smoothing)
Retirement Calculators 402 (Personal Finance/Life Cycle Models)
We periodically release a newsletter that contains information on upcoming product updates and it will also announce the posting of the follow-on “Retirement Calculators” articles on this website. If you’d like to receive the PRC Newsletter, all you have to do is sign up below. You can unsubscribe at any time if you’d like to be removed from the list in the future.
The Silver Edition is specially made for the person who desires to go well beyond a quick-and-dirty financial analysis but prefers to keep it simple
The Gold Edition has unprecedented capabilities for financial modeling, analysis and exploration of what-if’s
Read the inside scoop on retirement calculator design and learn how sensitive long term projections are to various design choices
Picture taken by Stuart Matthews while flying low over Monument Valley, Utah, August 2010
FREE Newsletter sign-up
NEW: The Bronze Editionhas most of the capabilities of the SIlver Edition, and is FREE!
Pralana Consulting LLC, Plano, TX
© 2015 Pralana Consulting. All Rights Reserved.
PRALANA CONSULTING LLC
Discover the Difference!