Please enter the administrator username & password
Administrative actions ....
Admin password
Guest accounts
...
Specify a new user, and then
New user name:
New password:
Comment (optional):
Or, check to remove username:
Specify guest user accounts
and then
# of guest accounts:
Maximum time (per guest user logon), in hours:
Archived data
...
Welcome to retPlan (retirement planner) -- for simulating different retirement scenarios (income streams, asset utilization, expenses, etc. … )
Scenario
Description and general parameters
Your current age is ; w/ retirement ages:
║ Inflation :
% ║
avg tax rate:
% ║
Interest rate adjustment:
║
COLA adjust :
║
Static time trends
summary tables from now to 1001
for each selected retirement age:
financial status metrics...
Year-by-year calculation of your financial status
To view a short summary of financial status over time, click the Main button
To view goal status, click the Main button
Living expenses during retirement ... use Invests ⋯ for loan payments and one-time expenses
Year-by-year
Year-by-year
↑
?or, you can
Name
Sub name
Group
Goal
Frequency
Year start
Year end
$Value
Inflation Multiplier (1.0=overall)
Tax deduct
Description
View expenses!
Retirement income ... (not including asset growth and distributions from IRA, 401k, etc.). Use Invests ⋯ for one time windfalls.
Year-by-year Year-by-year
↑
?or, you can
Name
Sub name
Age retire
Group
Goal
Year start
Year end
$Value
COLA Adjust
Fraction taxable
Description
View incomes!
Financial assets (currently owned) ... for current & future physical assets & loans, and future one-time expenses & windfalls … use Investments etc. ⋯
Investments (physical assets) & loans, and one time expenses & windfalls
currently owned, and future. Use Assets for current financial assets, and use Expenses for regularly occuring, future, living expenses ...
Year-by-year
Year-by-year
↑
?or, you can
The Investment type is used as short summary of the type of investment. We recommend using one of the following values (which are used in the add 1 entry form for investments).
investinvest with loanone-time expenseone-time expense with loanone-time windfallseveral-year windfallloan for cash
Name
Sub name
Group
Goal
$Value
Upfront Payment
Loan Amount
Interest Rate
Term
Tax deduct
Age Start
Age end
Appreciation rate
Investment type
Description
The Investment type is used as short summary of the type of investment. We recommend using one of the following values
investinvest with loanone-time expenseone-time expense with loanone-time windfallseveral-year windfallloan for cash
Select the flavor of this (...) investment:
║
║
Specify some house expenses, and then
Property taxes:
Insurance:
Maintenance:
Cleaning:
Local fees (i.e.; condo or homeowners association):
# of short trip miles driven per year:
║ Short trip MPG:
# of long trip miles driven per year:
║ Long trip MPG:
Gas cost per gallon:
Yearly gas cost: 0
View investments!
Welcome to retPlan: a financial retirement planner & simulator. retPlan allows you to specify a variety of details of
your financial status as you approach and enter retirement. With this information, and your guesses as to future economic conditions (such as
interest rates and inflation rates), retPlan will track your financial status over time.
Hint: to access retPlans many on-line help messages -- click on
these buttons and
these links. Click either of these,
and a popup window appears, with hints & tips specific to the topic.
To use retPlan, you need to specify 4 classes of entries:
Expenses
Living expenses when you are retired (food, enterainment, health insurance, etc.)
Income
Income streams when you are retired (social security, pension, part time jobs, etc.)
Assets
Current financial assets (bank accounts, mutual funds, 401ks, etc.)
Investments
Current and future investments, which can involve loans & liabilities (mortgages, automobiles, education expenses, etc.)
You can also use
Goals
Define goals that can be used to include (or exclude) sets of entries
General
Specify general parameters (such as your current age, and the average inflation rate)
Main
View year-by-year schedules of your income, expenses -- and show how your assets change in response!
Scenarios
For added flexiblity, you can specify different scenarios. Each scenario can be a bit different (say, dropping a few entries); or it can
be completely different (say, with different general parameters).
these buttons and
these links. Click either of these,
and this popup window appears, with hints & tips specific to the topic.
The following icons appear at the top, or side, of the window:
Click this to close the help window. You can also close the help window by hitting the ESC key!
Click to display this (topic specific) help message in a new window. Note that the styling might be a bit rough (some of the shadings
and indentations will be missing).
Used to resize the popup window: depress this button, and then move your mouse (while keeping the button depressed).
Alas, you can't make the the help window larger than the retPlan window.
Used to move the popup window: depress this button, and then move your mouse (while keeping the button depressed).
Alas, you can't move the help window outside of the retPlan window.
↥
This will take you to the summary help page; which contains brief descriptions, and links, to the main features of retPlan
This will display a clickable menu of retPlan help topics
Click this to display the help topics in a seperate window (or tab). You can view just one help topic at a time, or view them all at once
What are entries?
An entry is simply a set of information describing an item -- such as an expense, an income, an asset, or a investment.
You can specify as many, or as few, entries as you wish -- the idea is to capture the fundamental features of your life, but without the need to
go into deep detail. Basically, each entry is tracked over time. If different things behave differently (i.e.; different financial assets have
very different interest rates), having an entry for each of these "things" is useful. But if they behave similarly (i.e.; different kinds of
food purchase have the same inflation rate), it might be easier to combine them into one entry.
Entries from each of these classes has its own set of variables. But they all share some common variables:
Name
A one-word name.
subname
A secondary name. This is optional -- you can use it for finer breakdowns. For example, you might have several
expenses with a name of markets, with subnames like supermarket, farmersMarket, cheeseStore, etc.
Note that the combination of a name and a subname identifies an entry. The one exception is income entries (which also require
a special ageRetire variable).
Group
For display purposes, entries are combined into groups. For example, a food group could contain the above examples,
along with entries with names of lunchTruck and automat. In addition, sub-totals are computed for all entries in a group --
for example: for all of the food entries. In many places you can choose to display all the entries, or (to save screen space) just
group summaries.
Thus, the use of names, subnames, and groups is a matter of taste and convenience. It's probably a good idea not to have more than a dozen
groups in any one class -- more than that and summaries of just the groups can get longish.
Goals
All entries are assigned a goal. By default (if you don't bother specifying a goal), the core goal is used.
goals are used to quickly drop (or retain) sets of entries. This provides a very convenient way to see what happens when some stuff isn't done (or
is done).
For example, you may identify a luxuryLiving goal, that includes expenses like theaterSubscription, bigParties, and
seasonTickets. If your finances might be tight, you can quickly include (or exclude) these entries by activating (or deactivating) the the
luxuryLiving goal.
Of course, you could always do the same thing by deleting an entry. But then, if you wanted to put them back in, you would have to re-enter the information.
Thus, the use of goals is a convenient shortcut.
Value
The value is a dollar amount. It means ...
expenses : The yearly cost (of this item).
income: yearly payments from this income
Assets: current value of the asset
Investment: price (or resale value) of the investment
Note: the name, subname, group, and goal can only be one word (no embedded spaces), and can only contain
alphabetical characters (a to z, and A to Z), numeric digits (0 to 9), and the underscore (_). They can be up to 40 characters long, and are case insensitive.
The view feature (on the expenses, income, assets, investments, and goals pages) will
display a table of all entries; with each row used for one entry. In the first (or 2nd) column is a checkbox. You can use these to
modify,
delete, or
export one (or more) entries you select using the checkboxes.
Note:
As a shortcut, the All … button will check (or uncheck) all the buttons.
modify
The contents of the checked entries will be inserted into the
bulk entries edit form. You can the change them, and save the results.
Or you can change their names: when you save the results, new entries will be created
delete
The checked entries will be deleted, and the table of entries updated.
You will be asked to confirm this deletion (a list of the names of the chosen entries will be displayed).
export
The contents of the checked entries will be converted into a CSV file,
and displayed in a popup window. You can view this, or cut and paste it to a text file or a spreadsheet.
Or, click on the
⌮ to download it to a file.
This requires some server help, so you will see your browser's
file download alert box, using a default name that describes what you are downloading.
Note: the CSV entries can be imported back into retPlan -- using Enter using CSV
under bulk -- just cut and paste it to the textarea box.
Note:
Export provides a means of archiving (in an easy to restore form) all of your entries (so you don't have to depend on this server's
mysql databases).
The expense class of entriesexpense are used to specify recurring expenses -- things that you purchase at a more-or-less constant level every year.
This can include food, health insurance, gasoline, utilities, real estate taxes, entertainment, vacations, clothing, etc etc etc.
It should not include one-time expenses. And, in particular, it should not include loan payments. Those should be
specified under investments.
These expenses are for your retirement -- they should not be your current expenses! Many of these will be the same
(i.e.; property taxes). But many could be different: your health care costs might increase, but your food expenditures might drop.
The Expenses page is used to specify expenses. Basically, for each expense you specify several
variables. The expenses page contains help buttons that provide much more details.
Frequency
How often does this occur (i.e.; weekly, monthly, yearly). This is a convenience, it makes easy to enter
the yearly expense (retPlan only uses yearly expenses in its calculations)
Inflation multiplier
Does the cost of this item rise at, below, or above the general rate of inflation
Tax deductible
Is this expense tax deductible (i.e; charitable donations)
Start and end year
When does this expense start (i.e.; right after retirement). When does it end (say, after 20 years of retirement
you won't be taking wilderness vactions).
Value
What is the cost of this expense. Enter what it would cost today: not what you think it will cost during retirement
(the inflation multiplier, and the inflation rate, are used to calculate future costs).
The income class of entries income is used to specify income sets -- streams of income that may depend on your retirement age.
This can include social security payments, pension payments, and part time jobs.
income entries are a bit unusual: they are identified by a name, subname, and an ageRetire. The
idea is to capture the variation in income as your retirement age changes.
For example, social security payments increase depend on your retirement age: they increase by around 6% a year for every year after 62 (until 70).
It should not include one-time payouts (i.e.; from selling a house) -- those should be
specified under investments. Nor should it include distributions of assets (such as minimum payments from a 401k) -- those should
be specified under assets.
These incomes are for your retirement -- they should not include current income! You can account for savings from current income on the
assets page.
The Income page is used to specify income sets. Basically, for each income set you specify several entries, and each entry
has several variables. The income page contains help buttons that provide much more details.
ageRetire
This entry is used given you retire at this age. Thus, within an income-set, only one entry is used -- the one that matches
your actual retirement age. Actually, linear interpolation is used if no exact match is found.
COLA adjustment
What is the COLA (cost of living adjustment), as a fraction of the inflation rate.
Start and end year
When does this income start (i.e.; you take a part time job after retirement). When does it end (say, you leave this part time job
after a few years).
Value
What is the yearly payments from this income set, given you retire at ageRetire. Enter the currently announced value:
not what you think it will be during retirement: the COLA adjustment (and the COLA adjustment modifier), and the inflation rate, are used to calculate future payments.
Note that linear interpolation is used to fill in values; so your income-set doesn't have to contain entries for every concievable retirement age!
The assets class of entries assets are used to specify your current financial assets -- such as bank accounts, mutual funds, and 401ks.
It should not include physical assets (such as your house) -- those should be specified under investments.
Not should it include loans (which should also be specified under investments).
These are your current assets (they are not what you think they will be when you retire).
The Assets page is used to specify assets. Basically, for each asset you specify several
variables. The assets page contains help buttons that provide much more details.
Average interest rate
What is the interest rate paid on this asset.
If the interest rate may vary over time, enter the average over the lifespan of this asset.
SD of interest rate
What is the standard deviation of this interest rate?
This is used when all interest rates are adjusted, using the Interest rate adjustment general parameter.
Note:
if the interest is the same in all circumstances, enter 0.0.
Real/nominal
Is the interest rate real (should inflation be added to it). Or is it nominal (use it as is).
Tax deferred
Is this a tax deferred asset (such as 401k). That is, when you extract payments from this asset, do you have to
pay income tax on it?
Fraction of interest earning subject to income tax
What fraction of this assets earnings are subject to income tax? For example, a normal bank account will
have a value of 1.0 (all of its interest earnings are subject to income tax); while interest earnings on a municipal bonds account will have a value
close to 0.0 (since these earnings are exempt from federal, and maybe exempt from your state's, income tax).
Addtions
How much do you anticipate adding (or removing) from this financial asset every year -- from now until retirement. For example,
contributions to a 401k you get through your work. Note that these additions are assumed to stop the year you retire.
Value
What is the current value of this financial asset. Enter the actual dollar amount -- don't adjust them for tax deferrment status
(that adjustment occurs when funds are withdrawn). Do note that the value of the asset will continue to grow -- at the specified rate of interest -- from
now until retirement. It will also grow at this rate after retirement, but distributions from it may also occur.
The investments class of entries investments are used to specify your current, and future, investments & liablities -- such as purchases of second homes, future
automobiles, help with children's education, etc.
It should not be used for regular expenses, even large ones (such as home repairs) that happen more or less yearly -- use the expenses
page for those. And it should not include financial instruments -- use the assets page for those. It should include any loans
you take out, even if you get nothing of tangible (i.e.; resale) value from the loan (i.e.; a loan to pay for a trip around the world).
These can be your current, and anticipated future, investments & liabilities. Note that liabilities are simply investments with
no resale value -- which can be paid for with a one-time payout, or may require a loan.
The Investments page is used to specify investments. Basically, for each investment you specify several
variables. The investments page contains help buttons that provide much more details.
Appreciation rate
What is the real appreciation (or, if negative, depreciation) rate of this investment. This is a pre-inflation rate --
the actual change in actual cash value will use the sum of its appreciation rate and the inflation rate.
Start and end year
When does this investment occur (i.e.; you buy a 2nd home 3 years after retirement).
When does it end (say, you sell your primary residence 20 years after retirement).
Down payment
How much do you have to pay when the investment occurs. For one time payments (i.e.; liabilities), that require no loan, this
should be the size of this one-time payment (so you should enter an actual dollar amount).
Or, for future investments, you can enter a xx% (the percent of the value of the investment, in the future).
Loan variable
If you take out a loan, there are several variables to enter:
Loan amount: the size of the loan (do not include any down payment). Enter an actual dollar amount. Or, for future investments, you can
enter a xx% (the percent of the value of the investment, in the future).
Interest rate: the interest rate. retPlan does not support variable rate loans -- if you have one of these, enter
a guess of what the average rate will be.
Term: length of loan, in years.
Tax deductible: are interest payments tax deductible (i.e.; for a house mortgage)
Value
What is the current value of the thing being invested in. Enter the actual current dollar amount -- don't anticipate
what it will cost in the future -- the appreciation rate and inflation rate will do that for you.
What are retPlan's goals
retPlan uses goals as a quick and convenient way to retain, or drop, set of entries (from any of the 4 classes of entries).
When an entry is dropped, it is not used at all. For example, you could specify a set of entries under the charity goal:
such as donations, liabilties you take on in the future, or even a 2nd (low paying volunteer) job. If you don't think you can afford to
be so charitable, you can deactive this goal and see how it effects your bottom line.
More powerfully, if you define several goals, you can see what combination of goals you can afford, and what combination you can not.
Thus, by using goals you can specify a wide range of possible expenses, income streams, assets, and investments. . And when you are ready
to simulate your financial status -- just activate them in the order of importance (and see how it effects your bottom line).
While this can be accomplished by deleting entries, it is much quicker to use
goals -- by activating (and deactivating) a goal, you will automatically retain or drop the entries
that have this goal! And you can even define goals over good things (i.e.; stuff you want to do), and bad things (stuff you don't want to do) --
so that activating a goal can mean retaining entries that specify good things or dropping entries that specify bad things.
Note: to compare very different situations, instead of changing lots of goals it might be easier to specify different scenarios
General parameters
retPlan has a several general parameters. These include:
The overall inflation rate
Your current age
Up to three retirement ages -- simulations will be done for each of them, and bottom-line comparisions will be made across all 3.
How are IRAs and 401ks distributed?
Your average income tax rate
The General page contains further descriptions of these (and other) parameters.
Your overall financial status, and details over time
The Main page contains a summary of your financial status; and contains links to display
final results. These include year-by-year schedules of your expenses, income flows,
and investment status (i.e.; principal owned and interest paymement). And year by year views of the bottom line. For example:
how much do expenses exceed income, and how do your assets change accordingly.
Working with scenarios
To make it easy to compare a large set of situations, you can specify multiple scenarios.
Each simulation contains a full set of specificatons -- general parameters and entries for all four classes. You can create a scenario
that is a copy of an existing scenario, change some parameters, and examine the results.
If you are dedicated, you can generate a lot of scenarios; and the compare them at your leisure.
Note that scenarios are a coarse tool. For finer control (but without any long term storage of parameters), you can use goals.
Calculating tax-deferred asset distributions using a life expectancy table.
Most tax deferrred assets (such as 401ks and IRAs) have a yearly minimum distribution requirement based on a
life expectancy table. You can instruct retPlan to use this table to determine yearly withdrawals from these assets.
The life expectancy table
Age
Life expectancy
Minimum % distribution
60
32
3.1%
61
32
3.1%
62
31
3.2%
63
31
3.2%
64
30
3.3%
65
30
3.3%
66
29
3.4%
67
29
3.4%
68
28
3.6%
69
28
3.6%
70
27
3.7%
71
26
3.8%
72
25
4.0%
73
25
4.0%
74
24
4.2%
75
23
4.3%
76
22
4.5%
77
21
4.8%
78
20
5.0%
79
19
5.3%
80
19
5.3%
81
18
5.6%
82
17
5.9%
83
16
6.3%
84
15
6.7%
85
15
6.7%
86
14
7.1%
87
13
7.7%
88
13
7.7%
89
12
8.3%
90
11
9.1%
91
11
9.1%
92
10
10.0%
93
10
10.0%
94
9
11.1%
95
9
11.1%
96
8
12.5%
97
8
12.5%
98
7
14.3%
99
6
16.7%
100
6
16.7%
101
6
16.7%
102
5
20.0%
103
5
20.0%
104
4
25.0%
105
4
25.0%
106
3
33.3%
retPlan can automatically estimate the average tax rate as a function of the AGI (income-deductions) in a given year.
To do this, retPlan uses statistics from CBO on average tax burden by income class. This has changed over time, as the tax
code has changed.
When you chose to automatically calculate, you will pick which year's tax schedule statistics to use.
For a chart displaying average tax rates as a function of AGI -- for the several tax schedules supported within retPlan -- use the button.
The COLA adjustment modifier
Every income entry has a COLA adjustment variable. This is used to set the Cost of living adjusments --
how much (as a fraction of the overall inflation rate) does this income increase every year.
The COLA adjustment modifier allows you to reduce (or increase) these values by a fixed fraction. For example a value of 0.9
means all the COLA adjustments are reduced by 10%. For example:
Inflation
5%
An income entry with a COLA adjustment of:
0.85
The COLA adjustment modifier is :
0.8
Then the rate of increase for this income stream will be:
0.85 * 0.8 * 5.0% = 3.4%
Basically, setting the COLA adjustment modifier to be < 1.0 means you are a pessimist:
you don't think your income streams will live up to their promises; across the board, they won't increase at the claimed rate of inflation.
Conversely, a value >1.0 means you are an optomist: your income streams will do a better than expected job of tracking inflation!
Setting the inflation rate
The inflation rate is a key component of retPlan. It effects expenses, income, financial assets, and investments!
A single inflation rate is used. This inflation rate should be your guess as to the average (over time) inflation rate.
That is, if you think inflation will fluctuate, you will have to guess what its average will be.
While the use of a single number is rather simple, retPlan has a number of ways of modifying how the inflation rate is used.
For expense entries
Each expense entry has an inflation multiplier parameter. It is a fraction applied to the
overall inflation rate, yielding the inflation rate for this expense.
For example, if inflation=4%, and an expense's inflation multiplier is 1.25, then this entry will have
a (yearly average) inflation rate of 5%.
For income entries
Each income entry has an cola adjusment parameter. It is a fraction applied to the inflation rate
For example, if inflation=2%, and the income's cola adjustment is 0.9, then this entry will have a COLA of 1.8%.
Note: you can globally modify all the cola adjustments using the Cola adjustment modifier parameter.
For financial asset entries
Each asset entry has a Real/nominal parameter. It is a flag used to specify how the asset's interest rate is calculated.
If set to nominal, the interest rate is used as is. If set to real
then the interest rate is relative to the inflation rate.
For example: if inflation=2%, and the assets average interest rate is 4.0.
If real is used: the interest rate used each year is 6%
If nominal is used: the interest rate used each year is 4%
For investment entries
Each investment entry has an Appreciation rate parameter. It is a real appreciation rate -- the actual yearly rate of change
is the sum of its appreciation rate and inflation rate.
For example, if inflation=6%, and an investment appreciates at 4% per year, then the yearly change in value is approximately
10%
The average tax rate
retPlan uses an average tax rate to calculate your actual (after tax) income. This rate is applied to all earnings (your AGI); which
includes
income streams (such as pensions), distributions from tax deferred assets, and interest earnings from non-tax deferred assets. Note that there are a few
other parameters that also affect this calcuation.
The average tax rate is specified on the General page. You can:
Specify a state & and local income tax
and specify a federal income tax rate
For the federal income tax, you can
Specify an exact percent
... you can use the worksheet to estimate an average tax rate as a function of income
Or, let retPlan calculate it for you, as a function of each year's adjusted gross income (AGI) -- using a table derived from IRS statistics.
This is the default method. You can choose which year (of IRS statistics) to use (the default is based on 2018 tax payments).
When calculating yearly tax bill,your
average tax rate is based on total earnings (your AGI) after deductions.
The actual tax is calculated as: averageTaxRate * (totalIncome - taxDeductions).
Tax deductions include tax deductible living expenses (such as charitable contributions), tax deductible investment expenses
(such as interest payments on a mortgage), non-taxable interest earnings (such as state tax on US bonds), and non-taxable portion of income (such as a 15% of social security payments).
Note that retPlan uses an inflation adjusted AGI when looking up an average tax rate (so there is no bracket creep due to inflation).
Two other parameters affect tax tax calculations:
Min rate (%): The CBO derived average tax rate schedules built into retPlan allow for negative income taxes; when household income is < ~$40k
(the value depends on which year is used) . This accounts for rebates, such as ETIC.
Of course, you can also set this value to what you think a minimum tax rate percentage will be... depending on your guesses about future tax policy
Fraction itemized: Federal tax law changes have affected the treatment of deductions. This parameter attempts to control for this
This parameter only applies to deductions listed for living expenses and investment expenses! For Income and Financial asset earnings, this parameter
does not apply -- you will always have your taxable income reduced by non-taxable components of these earnings.
Expense: yearly total
The {Yearly} column contains the approximate yearly expenses associated with this expense (or with this
group of expenses). Note that this is calculated based on the frequency and value used when specifying expenses.
Approx. value? For groups, an Approx. value figure is displayed. This measures total yearly expenses for all entries in this group,
assuming all expenses start in the first year of your retirement, and inflation is 0%. Thus, the actual values may differ.
Expense: age range
You can dictate the timespan over which this expense occurrs; using a starting year and an ending year.
In years outside of this range, the entry is dropped (you do not incur the expense in those years).
If you know (or can realiably predict!) how expenses will change over the course of retirement, you can specify multiple entries with
non-overlapping ranges. Each entry would have a different value (and possibly a different inflation multiplier).
Notes:
expense entries are meant to account for expenses during your retirement.
Thus, the timespan is typically specified using years after retirement, rather than years of age.
However, if you are confident that this expense is not effected by when you retire, you can use an age range
when you specify the expense.
expenses may, or may not be the same as current expenses!
For example …
Reminder: do not enter current expenses! Enter what you think your post-retirement expenses will be (which might vary over time).
Expense: deductible
Is this expense tax deductible? If it is, your net income (used to compute income taxes) will be reduced by this amount.
For example, charitable donations are usually tax deductible (assuming you itemize your tax forms).
Note: income taxes are an internally generated expense. It is computed every year; and is a function of income, asset distributions (i.e.; from 401ks),
and tax deductions.
Expense: inflation multiplier
retPlan uses an overall inflation rate (specified on the General page). This inflation rate is used to
change the cost of an expense as time passes by.
This inflation rate is used in all years, and for all entries (including expense, income, asset, and investment entries). Thus, it is best thought of as
global average (over time) inflation rate.
However, the cost of some items may increase (or decrease) at a rate different than this long-term average inflation rate. You can use the inflation mult
variable to specify such differnces!
inflation mult is a multiplier applied to the general inflation rate. Thus: the inflation rate for an entry will equal:
inflation mult × inflation rate
For example, assuming the inflation rate is 4%.
An inflation mult of …
yields this inflation rate (for this entry)
1.0
4.0%
1.25
5.0%
2.0
8.0%
0.5
2.4%
Specifying expense entries …
Hints:
If you do not specify a group or a goal, then other and core are used (respectively).
For value, you can use xxK for thousand. Thus, 5000 is the same as 5k (the k is case insensitive)
The value should be the cost if this expense was incurred today. This cost will rise at the specified rate of inflation, starting
from today!
The value should be the cost during retirement. For example, if your kids will have moved out when you retire,
but are living with you now, then a food expense should not include what you may be spending to feed your kids!
Frequency values can be Y,Q, M, B, or W (yearly, quarterly, monthly, bi-weekly, or weekly).
If you are using the add form, use one of the several radio buttons to choose a frequency.
Note that retPlan only stores yearly expenses -- so the frequency variable is just used to simplify data entry (so you
don't have to do multiplication in your head!).
inflation mult is a multiplier used for this expense.
I.e.; 1.0 means use the overall inflation rate; 1.4 means inflation is 40% higher than over all (so a 2% overall inflation means 2.8% inflation for this expense).
If taxDeduct is 1, this is a tax deductible expense (such as a charitable contribution).
If you are using the add form, check the is this tax deductible... button.
If you do not specify a Year Start or a Year End, then 0 and 100 are used (respectively).
A value of 0 for Year Start means you incur the specified expense in the first year of retirement.
Thus, Year start of 1 would mean you don't have the expense for a year;
and Year end of 4 means the expense lasts until 4 years after the start of retirement.
Alternatively, to specify an absolute age (to start and end), enter -age. For example, Year Start=-65 and Year End=-75
means the expense occurs between the ages of 65 and 75 (inclusive).
If you are using the add form, you can click on the check to enter ages .. checkbox -- this toggles
between specifying ages (such as 65 to 100) or years (such as 3 years after retirement to 20 years after)
You can include commas in the description (that's why it is the last item on the csv entry forms)
The subname is optional
On csv entry forms: empty lines, or lines whose first (non-space) character is a ;, are ignored
Income: yearly income
The yearly income is a simple approximation, as it ignores the age range (it assumes the income stream starts
as soon as retirement starts).
Note that several group totals are displayed: one for each retirement age. The
retirement ages are those specified on the General page.
These are approximate, they do not
account for COLA adjustments or the year range.
Income: retirement age income
Income entries are different than other entries. Many kinds of retirement income depend on your retirement age . For example,
social security payments increase by (more or less) 6% for every year after 62 years of age (up until 70 years old).
retPlan accounts for this by using income sets. Each income set is comprised of one or more income entries. Each
entry in a set has the same name and subname, but has a different ageRetire. The actual income you receive is calculated
by comparing the actual retirement age to entries in an income set (and using linear interpolation if necessary).
For example, assume an income set
with 3 entries ...
ageRetire
62
65
68
Value
24k
30k
33k
Then if you …
Retire at
income received
Why?
61
0
If you retire before the earliest age in an income set, you receive 0.0.
62
24,000
This matches the ageRetire=62 entry
66
31,000
Linear interpolation is used: using the 30,000 values (at age 65) and 33,000 value
(at age 68).
79
33,000
The value of the last entry in the income set (ageRetire=68) is used
Important reminder! These values are all expressed in today's dollars. The actual amount received will be a function of the inflation rate,
the entry's COLA adjustment, and the time between now (that is, your current age) and the retirement age.
For example, assume a cola mult of 1.0, and an inflation rate of 4% (hence the COLA rate is also 4%). Then, using the above numbers:
Current age
Retire at
Nominal $ received (after COLA & inflation)
Notes
55
62
29.6k
55
64
39.9k
At age=64, the interpolated value is 28,000
60
62
26.0k
60
64
32.8k
Note: the above example assumes the COLA adjustment modifier general parameter is 1.0.
Reminder: to facilitate comparisions, retPlan will calculate scenarios for up to 3 different retirement ages.
Income: age range
You can dictate the timespan over which this income occurrs; using a starting year and an ending year.
In years outside of this range, the entry is dropped (you do not earn this income in those years).
If you know or can realiably predict!) how an income stream will change over the course of retirement, you can specify multiple entries with
non-overlapping ranges. Each entry would have a different value (and possibly a different COLA adjustment).
Notes:
income entries account for income sources received during your retirement. They should not
be used for income before retirement. The effects of pre-retirement income should be captured on the
Financial assets page -- by appropriately setting
yearly additions.
Thus, the timespan is specified using years after retirement, rather than years of age.
You can use a short year range to capture a part time job taken for a few years after retirement.
Hint:
Using year ranges with different retirement ages
Income entries are specific to the age of retirement. And specifying entry specific age ranges, that depend on retirement age, can be useful.
For example: suppose you would like to work part time until 66 years of age, but not beyond.
And the job earns $20k/yr (its a volunteer job, so does NOT increase with inflation). Then you would specify something like ...
Name
Retirement age
value
start year
end year
COLA adjustment
partTimeJob
62
20k
0
4
0.0
partTimeJob
65
20k
0
2
0.0
partTimeJob
67
0
0
100
0.0
The last entry (for age 67) is crucial -- without it, retPlan would assume that the partTimeJob will extend 2 years regardless
of when you retire (since retPlan uses interpolation to fill in values for unspecified retirement ages!)
Income: cost of living adjustment
Income sorces (such as a pension, or social security), are often subject to cost of living adjustments.
Typically, these are pegged to the rate of inflation, so your payments go up along with the inflation rate. But just
how much it goes up can vary -- some COLAS are more generous than others!
cola adjustment is a multiplier applied to the general inflation rate. Thus: the cost of living adjusment rate for an entry will equal:
cola adjustment × inflation rate
For example, assuming the inflation rate is 3.0%.
An cola mult of …
yields this cost of living adjustment rate (for this entry)
1.0
3.0%
0.9
2.7%
0.66
2.0%
1.1
3.3%
0
0%
Notes:
In the above example, the last line (a cola adjusment of 0) is used to specify a fixed income stream -- one where you receive the same amount every year.
You can use the COLA adjustment modifiierGeneral parameter to modify all of the
COLA adjust parameters.
Specifying income entries ...
Hints:
You must specify a name. The subname is optional.
The name and subName must be one word (no embedded spaces), and can only contain
digits,
letters, and
the underscore
ageRetire is required. It identifies an age of retirement.
Each retirement income stream is specified using an income set.
An income set consists of one or more
entries with the exact same name and subname, but with different values of ageRetire.
The income stream actually used (for an income set) will be computed using the actual retirement
age. In other words, only one value from an income set is actually used.
Some details …
Entries of an income set can be in any order (they will be sorted by ageRetire)
Actual income (from this income set) will be 0 if you retire before the first ageRetire
For retirement ages after the last ageRetire, income will be the value of the last entry in the income set If an income set contains one entry, then income will be 0 if you retire before
ageRetire, and constant if you retire at (or after) ageRetire
Linear interpolation is used if necessary. Example:
If an income set contains just one entry that has ageRetire equal 0 -- you get this income regardless of when you retire.
Note: on the add page, fill in the at this retirement age ... text box
If you do not specify a group or a goal, then other and core are used (respectively).
Years Start and Year End limit the years (after retirement) you recieve this income stream.
Values should be yearly income: before income taxes, but after unavoidable (and non-refundable) deductions (such as FICA taxes).
The fraction taxable is what fraction of this income stream is subject to taxation, and should be a value between 0.0 and 1.0.
0.0 means this income stream is not subject to taxation; while 1.0 (the default) means it is all subject to taxation.
Social security example: if your pension income is 80k, and your SS payments are 20k, use 0.85…
the COLA Adjustment is the ratio of cost of living adjustments (COLA) to inflation (the overall inflation value
specified on the General page). If not specifed, a value of 1.0 is used.
Notes:
1.0 means income stream keeps up with inflation,
and 0 means no-inflation adjustment (same dollar amount every year). Values less than 1.0 means COLAs do not keep up with inflation.
The COLA adjustment modifier rategeneral parameter can be used to modify all of the (entry specific) COLA Adjust parameters.
For example: setting COLA adjustment modifier rate to be less than 1.0 simulates all income streams do not live up to their
promised inflation rate matching
Fraction subject to income tax
Most income streams are subject to state and federal income tax -- but often not the complete amount.
To specify all of this amount is subject to income tax, enter 1.0
To specify none of this amount is taxable, enter 0.0
Values between 0.0 and 1.0 can be entered. For example: for 85% of the income is subject to income tax, enter 0.85
Some examples:
Social security:
SS taxable fraction depends on your income -- but is never more than 0.85.
total income
SS earnings
fraction subject to income tax
40k
20k
0.48
50k
30k
0.60
58k
25k
0.85
70k
20k
0.85
70k
30k
0.85
Hint: for greater detail you can try this social security
income tax rate calculator
FERS
Depends on payments made during retirement. Typical fraction is 0.95. more details
Investment: down payment
An investment's down payment is (obviously?) the size of the down payment: this is a one-time payment made when the
investment occurs. While down payment often is used in the context of loans, in retPlan the down payment
is also used for one-shot purchases (i.e.; for liabilities paid off in one payment).
Not so obviously, down payment is also used for cash loans -- for loans that are immediately distributed to your
non-tax deferred financial assets (using the priority parameters). For example,
a line of credit on a house used to help pay for a temporary surge in expenses. To account for such loans, and also to account
for one-time windfalls (such as an inheritance), use negative values for the down payment, and 0.0 for the value!
For example:
You take out a loan to buy a $250k house
You pay a 10% downpayment
The down payment is 25,000
The loan is 225,000
In 10 years, you contribute $20,000 for your daughters wedding (i.e.; you take on a liablity)
You pay for it out of future income
The down payment is 20,000
The loan is 0.
In 15 years, you need $50,000 in cash to cover a few years of miscellaneous expenses
you don't want to draw down your
financial assets (or have the debits asset go negative)
The down payment is -50,000
The loan is 50,000
Note: downpayment is treated as an expense in the year the investment occurs; so it is kind of like an expense with a carefully specified
year range. And, for loans for cash (negative down payment), it can yield a yearly excess (total earnings > total expenses) that
will be distributed to your non-tax deferred financial assets.
If inflation (and appreciation) are not 0%, the price of the investment will not be the same in the future. Thus, a down payment amount
(that is entered in actual dollars) may not be sufficient. To account for this, you can enter a percent amount-- the actual downpayment
(when the investment occurs) will be this percent × the (inflated and appreciated) value of the investment
(More details here!) asset.
Investment: loan
If you will pay for a future investment, or are currently paying off an existing investment, with a loan -- you will need to specify a few variables:
loan amount
This is how much you will spend, or currently owe.
If you are not taking out a loan, enter 0. For example, if you anticipate a one-time expense, with a down payment that will be covered by your non-tax-deferred assets.
If this is an existing investment,
See below for a hint on calculating currently owned principal!
term
The length of the loan (in years). This is ignored if the loan amount is 0.
For existing loans, this should the number of years left on the loan (that is, it should not be the original term).
Interest
The interest rate on the loan. This is ignored if the loan amount is 0.
This is an absolute amount -- retPlan does not support variable rate loans.
Deduct
Are interest payments tax deductible? For example, interest payments on a mortgage were (pre 2018 tax code changes) fully tax deductible.
However, if the loan is to pay for a vacation, probably not.
Hint: Need to compute the remaining principal on an existing loan, given the starting loan amount, interest rate, and the
remaining years left on the loan? Use the View loan schedule button in the
Add (an investment) button!
If inflation (and appreciation) are not 0%, the price of the investment will not be the same in the future. Thus, a loan amount
(that is entered in actual dollars) may not be sufficient. To account for this, you can enter a percent amount-- the actual loan
(when the investment occurs) will be this percent × the (inflated and appreciated) value of the investment.
(More details here!)
Investment: appreciation
Many investments will appreciate over time -- their real value will increase (such as a house in a growing city).
Other investments depreciate -- they lose value over time (such as an automobile).
The appreciation rate specifies this rate of growth, or rate of loss -- without taking into account inflation! That is,
the dollar amount an investment will sell for (the nominal amount) will be effected both by the appreciation rate and the inflation rate.
For example, assuming an existing investment worth $100,000 ...
Appreciation rate
Inflation rate
in this many years
The nominal value will be
with a real (inflation adjusted value) value
0
0
10
100k
100k
0
5.0
10
163k
100k
2.0
3.0
10
163k
122k
-6.0
3.0
10
74k
54k
Investment: start and end age
retPlan's investment entries are often used to account for future one-time purchases (i.e; not everyday living expenses).
These often occur at known times -- they are not as dependent on your retirement age as expenses and income are.
Each investment has a start age and an end age -- your age when you obtain the investment, and the age you sell it off.
To specify a existing investment (or one you plan to obtain as soon as you retire), enter a start age of 1.
Note: existing investments should have a 0 down payment -- and you should specify loan parameters reflecting
currently owed principal (not the original terms).
If you never intend to sell the investment (i.e.; your kids will inherit it), enter an end age value of 200.
Actually, you can enter years after retirement for both the start and end year. In particular, a value of 0
means the investment occurs as soon as you retire
Investment: value
The value of an investment (or a one-time expense) is what it is worth today! That is …
For future investments & expenses, retPlan will calculate the cash (the nominal ) expenditure needed in the year when the
investment (or expense) occurs. This is done using both the appreciation rate (for this investment)
and the inflation rate (as set on the General page).
Since assets typically do not depreciate if you don't own them: when retPlan calculates a
future price, it will ignore (set to 0) a negative appreciation rate.
For example ...
Current price
inflation
(real)appreciation
#years
The price will be
real (inflation adjusted) value
$100,000
3%
0%
5
116k
100k
$100,000
2%
1%
5
116k
105k
$200,000
2%
-3%
5
221k
200k
$50,000
2%
1%
15
78k
58k
retPlan's investments ⋯ also used to enter future one-time expenses and one-time windfalls
Specifying investment entries …
Investments ⋯ are used to specify future expenses that do not occur regularly.
And, it is a convenient means of specifying loan payments (that build equity in an asset, and then eventually end).
For regularly occuring expenses (such as grocery purchses, or utility bills), you should
use
Note that an investment can be a non-zero valued asset whose purchase is financed with a loan, or purchased using available funds.
It can be a one-shot purchase of a consumer good (i.e.; has a value of 0, but requires a downpayment and/or a loan to purchase).
And it can be a one-time windfall (i.e.; sale of an heirloom), or a windfall that has several years of growth (i.e.; inherit a close-to-term bond)
To simplify your choices, choose an investment type! This will highlight what fields need to be filled out, and which fields should be left as is.
Hints:
If you do not specify a group or a goal, then other and core are used (respectively).
The value of the investment is today's value (i.e.; what it would cost to purchase today).
The investment occurs when you are ageStart years old.
Special case:. -xx (values less than or equal to 0) means the investment occurs xx years after retirement.
If you are using the add form, you can click on the years after retirements .. checkboxes -- this toggles
between specifying ages (such as 65) or years (such as 3 years after retirement)
The investment ends (is sold for its appreciated value, minus any remaining principal) when you are ageEnd years old.
Note that the proceeds from a sold investment are treated as a negative investment expense.
If the sales value is high enough,
excess value (money left even after paying all other regular and investment related expenses) are treated as a one-time addition to your assets (with deposits
based on their
priority parameters).
Conversely, if the investment is under water (more principal is owed than its appreciated value), the loss is treated as a one-time investment expense
(which may necessitate withdrawals from non-tax deferred assets)
Notes:Special case:. as with ageStart: -xx (values less than 0) mean investment occurs xx years after retirement.
If you are using the add form, you can click on the years after retirements .. checkboxes -- this toggles
between specifying ages (such as 65) or years (such as 3 years after retirement)
The Down Payment is the nominal dollars (no inflation adjusment) paid the year the investment occurs. For currently owned investments, this should be 0.
For one-time payments (such as one-time expenses), use the Down Payment to enter the amount (and set loan amount to 0)
Shortcut: xx% (0<xx<=100) are interpreted as xx percent of value, at the time of investment.
Thus,
for future investments (whose value increases due to appreciation and inflation), the nominal amount (the actual $ expenditure) of the down payment will also grow.
Note that future down payments (or one-shot expenses) are drawn from savings and other non-IRA assets -- using the priority parameters to allocate where withdrawals are from.
The loan amount should be 0 if no loan is required (say, if a one-time payment is used, or if you already own the investment)
Shortcut: xx%0<xx<=100) is interpreted as xx percent of value, at the time of investment
Thus, for future investments (whose value increases due to appreciation and inflation), the nominal amount (the actual $ expenditure)
of the loan amount will also grow.
For Down Payment,Loan Amount, and Value: you can use xxK for thousand. Thus, 45000 is the same as 45k (the k is case insensitive)
Loan payments are automatically computed -- given the Loan Amount,
the Interest Rate, and term (the length of the loan).
These payments are automatically divided into interest payments, and principal payments
Interest Rate and the (real) Appreciation rate should be entered as a whole numbers.
Examples ...
Note that actual (nominal dollar) change in value is (roughly) the sum of inflation and appreciation.
Example: an investment that requires a one time payment (i.e.; not a loan), and
value = 100k
appreciation= 5 (5% increase per year), and inflation=0.
Then after 3 years the value of the asset = 100k * 1.05 ^ 3 = $115,673
If interest payments are tax deductible (i.e.; a primary or vacation home), canDeduct should be 1.
Otherwise (i.e.; if no value specified) interest payments are not tax deductible.
If you are using the add form, can click on the check if this is tax deductible checkbox
You can include commas in the description (that's why it is the last item on the csv entry forms)
The subname is optional
On csv entry forms: empty lines, or lines whose first (non-space) character is a ;, are ignored
For further details (such as how cost of future purchases of appreciating, or depreciating investments); click on
? buttons at the bottom bottom of the in the add form
Approximate total assets
The approx. total assets field (on the Assets page) lists the approximate value of all of your
assets. There are 3 values displayed:
$NNNk
The current value of all your assets. This is the value as of today, and includes the current amount of your tax deferred assets. Thus,
it is not what you would have if you cashed them all out!
MMMk
An approximate after tax value of these assets. This adjusts the values of tax
deferred assets, using the
average tax rate (as specified on the General parameters page).
[JJk]
The additions to your assets. This is the sum of the yearly additions across all assets.
It includes additions to tax deferfed assets, so the real (after tax) value of these additions can be less.
These additions are from extra --- they are not due to growth of assets. For example, if you have several more years of work before
you retire, and you are adding $10k a year to your IRA, then additions would be 10k.
What are the debit and cashassets? debit is a special asset that is created by retPlan, and can not be removed.
debit has a very special feature -- it can go negative! This means debit is borrowed from when you have
a yearly shortfall, but all of your non-tax deferred assets are empty. In a sense, debit is a line of credit -- you can
borrow from it when you really need to. Therefore, its priority is always 0.0.
Whenever debit is negative, any excess cash (say, from selling an investment; or from an investment with a negative down payment)
is used to pay off this debt. Once debit
becomes non-negative, the normal rules for distribution of excess cash (using asset priority parameters) are used.
But debit can not become positive -- its largest possible value is 0.0.
debit is like other assets -- it gets even more negative at the specified rate of interest.
debit is initialized by retPlan (you don't have to add it) using a moderately pessimstic assumption: when you need to borrow from it,
the interest rate will be 4% greater than the inflation rate. You can change that if you want.
retPlan also automatically creates a cash asset. It can not be deleted, its interest rate is always 0%, and it is non-tax deferred. You
can modify its value, and change its priority.
What is a taxDeferasset? taxDefer refers to assets that are in tax deferred accounts. This includes IRAs, 401ks, and the Thrift Savings Plan.
Tax deferred accounts contain money deposited, and interest earnings on this money, that have never been taxed. Thus, upon
withdrawal they are subject to income tax.
Distributions from taxDefer occur yearly -- using the distribution rate, and starting age, that is specified on the general page (typically,
one starts at 70 years old using the life expectancy table rates).
That is the only way withdrawals occur.
Thus … in years with shortfalls (where total income < total expenses) extra money is not not withdrawn from taxDefer
accounts. It is only drawn from non taxDefer assets.
If these shortfalls are large, and there is a lot of money in your taxDefer assets, you may want to increase the distribution rate.
Current shortcomings of retPlan (that might be fixed in later versions)
Using priority to allocate asset withdrawals and deposits
What should be done when you have a yearly shortfall -- when your total costs
(living expenses + investment expenses) exceed your total earnings (income + tax deferred asset distributions + sales of investments).
Answer: withdraw cash from your non-tax deferred assets!
But how? If you have multiple non-tax deferred assets, how much should be withdrawn from which? The priority variable is used to calcuate these withdrawals
(or deposits, if you have a yearly excess)!
Priority value
Action
Desription
0.0
Withdrawn from last. Never added to
These are your emergency accounts -- that are only used last -- when you have nothing else to use. And they aren't added to --
once exhausted, they are gone forever. Example: a coin collection you inherited
1.0
Withdrawn from first. Never added to
These are your spare cash accounts -- that are used before anything else. And they aren't added to --
once exhausted, they are gone forever. Example: a bunch of gift cards recieved at a going away party
0.0 < priority > 1.0
Higher priority accounts are withdrawn from more quickly, and added to less quickly.
The higher the priority, the less valuable the account -- you would rather take money from it that from an
account with a lower priority (so priority means intensity of use when paying off shortfalls).
Similarly, the higher the priority, the less you add (in years where total earnings > total costs).
Examples...
A checking account could have a priority of 0.8 (if you need it use it, and don't add much to it)
A high performing stock account could have a priority of 0.3 (limit withdrawals from it, and favor it when there is money to be saved).
0.5
Equal weighting
If all accounts have priority of 0.5, then withdrawals (and deposits) are proportional to the size of the account.
Example: assume you have a $10,000 shortfall in a given year, and 3 non-tax deferred assets. Where should the money to cover this come from?
Asset value
Priority
Money withdrawn
comment
5,000
0.8
$2000
A checking account -- use it first (but try not to empty it)
10,000
0.5
$2500
A savings account -- use it in a normal fashion
27,500
0.4
$5500
Your largest account is in a well performing mutual fund -- try to keep it growing
Technical note:
the following function is used (for assets with 0.0<priority<1.0)
withdrawal= shortfall * (value * priority)/ sum{value * priority}
In the above examples, the weights equal 0.20, 0.25, and 0.55.
Priority is not used with tax deferred assets! Distributions from tax deferred assets
are not effected by shortfalls (or excesses) in your yearly accounts. They are only effected by the distribution variables set on the
General page.
The debits asset is special: it has a priority of 0.0, and has a maximum value of 0.
It is only withdrawn from in a special emergency -- when costs > earnings and all your (non-tax deferred) assets are empty!
However, if there is an excess, and the value of debits is < 0 -- it has top priority: it is deposited to exclusively
(up until its value equals 0).
What is a pctTaxable interest rate for an asset?
Assets grow at a rate of interest, and this growth is subject to income tax. However, some assets (such as mutual funds holding municipal bonds)
are not subject to federal (and sometimes state & local) income taxes.
pctTaxable is used to specify what fraction of the value of an asset is subject to income taxes. Thus, for a normal bank account,
pctTaxable should be 1.0. Conversely, for a fund that only holds tax exempt bonds, the number would be at (or close to) 0.0.
Thus, as a general rule: pctTaxable should equal 1.0 minus the fraction of an asset interest earnings that are tax exempt.
Things get a bit complicated if the asset is subject to some income taxes, but not others. In those case, you will have to weight pctTaxable to
reflect this mix. That is, you would reduce pctTaxable to account for the fact that not all income taxes are exempted.
Example:
Your average tax rate is 20%
This includes 15% federal tax, and 5% state tax.
You have a $25,000 of US Savings Bonds that earn 4% ($1000) per year.
US Savings bonds are not exempt from federal taxes, but are exempt from state taxes.
Therefore: pctTaxable should be 75% (since all of the account is in an asset that is exempt from 25% of your taxes)
Conversely, if the asset was a muni bond fund, with bonds from a state you don't live in, the rate would 25% (since
interest earning would be exempt from the 15% federal income tax, but not your state's 5% income tax).
Obviously, if an asset has a mix of tax exempt and non-tax exempt items, you will have to weight things accordingly.
In fact, the math might be simpler if you break the asset into two components, using different subnames (one for tax exempt, and one for non-tax exempt)!
Note: as of now, interest earnings on taxDefer assets must have %taxable of 100% -- that is, all withdrawalw from taxDefer
assets are subject to all income taxes. If this is inaccuate, a workaround is to increase the interest rate on the asset.
Future versions of retPlan might relax this limitation.
What are the Average and (sd) interest rate for a financial asset?
You can specify the average interest rate (over all years) that a financial asset will grow at.
You can also specify a standard deviation (sd) of this interest rate.
the Interest rate adjustment ± SD general parameter can be used as a shortcut: it allows you to simulate what would happen if the interest rate on all of your assets were higher,
or lower, than their average. How does this work?
For each asset, the interest rate is calculated using:
The interest rate adjustment -- which must be a percentile value between 0.0 and 100.0,
is converted into a weight (based on a normal cdf)
The interest rate used (for an asset) is set to: average + (weight * SD)
Reminder: the average and the SD are asset specific.
The calcuation of a weight is based on a normal CDF -- the intent is to capture convert a probability of occurence into a multiplier!
For example, the following interest rate adjustment values yield these weights ...
95: 1.96
70: 0.5
50: 0.0 (an interest rate adjustment of 50 has the same
effect as a SD of 0.0)
30: -0.5
5: -1.96
Basically, a value less than 50 means you are a pessimist: for each of your assets, the interest rates will be lower than expected.
Conversely, value greater than 50 means you are an optomist: interest rates will be greater than expected.
The actual (after tax) value of a tax deferred asset
Tax deferred assets (such as IRAs and 401ks) are accumulated using before-tax income. When it is time to take distributions
from a tax deferred asset, you have to pay income taxes on them. retPlan uses a average income (the sum of federal, state & local)
to calculate this tax.
You can specify exactly what your average income tax is, or you retPlan can estimate it for you based on your income (at
the time the distribution is taken). See the General page for the details.
On the Financial assets page, the afterTax value of your tax-deferred
assets is displayed. This afterTax value is as of right now -- the current AGI (as specified on the General page)
is used to calcuate the tax rate.
Thus: this is just an estimate! The actual value (after taxes are paid) may depend on your actual AGI in the year a distribution occurs --
which is likely to be less than your current AGI
Specifying asset entries ...
Hints:
If you do not specify a group or a goal, then other and core are used (respectively).
For value and additions, you can use xxK for thousand. Thus, 5000 is the same as 5k (the k is case insensitive)
value is the current value. addditions are the per-year additions until retirement.
The assumption is that upon retirement, these additions will no longer be made.
avgInt (average interest rate over time) and sdInt (standard deviation of interest rate over time) should be entered
using whole numbers. For example: 3.1 means 3.1% interest rate
The Interest rate adjustment (on the General page) is used to globally adjust all interest rates,
using each rate's sdInt
On the add page, the above are entered using the average value and standard deviation text boxes.
If this is a tax deferred (i.e.; an IRA or a 401k), taxDefer shoulde be 1.
Otherwise (i.e.; if no value specified) this is not a tax deferred asset.
On the add page, the above is specified using the Is this tax deferred .. checkbox,
interestTaxable should be between 0.0 and 1.0. If some of the interest earnings from this are tax exempt (i.e.; earnings from a government bonds mutual fund), enter a
a value less than 1.0.
For example, a simple savings account should have a value of 1.0 (its interest earnings are
all taxable), while a municipal bonds fun should be close to 0.0 (since interest earnings are exempt from federal and most state income taxes).
Note: this refers to interest earnings, not withdrawals. Therefore, all distributions from a tax deferred asset (i.e.; automatic payments
from a 401k) are subject to full income tax, even if a large fraction of them are due to interest earnings (on contributions made early on).
This is a limitation of retPlan (that could be fixed, but at the cost of even more complexity!)
On the add page, the above are entered using the Fraction of interest earnings subject to income tax ... text boxes.
The nominal/real should be a 0 or 1.
On the add page, the above is specified using the Real interest rate .. checkbox,
The priority should be a value between 0.0 and 1.0. It is used to prioritize what non-tax deferred asset should be used first.
priority is used to determine how cash should be withdrawn from assets in years with a shortfall -- in years where your total costs
(living expenses + investment expenses) exceed your total earnings (income + tax deferred asset distributions + sales of investments).
Or, how cash should be saved when you have a excess (when earnings exceed costs)!
Example: assume you have a $10,000 shortfall in a given year, and 3 non-tax deferred assets. Where should the money to cover this come from?
Asset value
Priority
Money withdrawn
comment
5,000
0.8
$1538
A checking account -- use it first (but try not to empty it)
20,000
0.5
$3846
A savings account -- use it in a normal fashion
30,000
0.4
$4616
Your largest account is in a well performing mutual fund -- try to keep it growing
Technical note:
the following function is used (for assets with 0.0<priority<1.0)
withdrawal= shortfall * (value * priority)/ sum{value * priority}
In the above examples, the weights equal 0.16, 0.38 and 0.46.
Priority is not used with tax deferred assets! Distributions from tax deferred assets
are not effected by shortfalls (or excesses) in your yearly accounts. They are only effected by the distribution variables set on the
General page.
You can include commas in the description (that's why it is the last item on the csv entry forms)
The subname is optional
On csv entry forms: empty lines, or lines whose first (non-space) character is a ;, are ignored
Goals: specifying a retain or drop action
When active a goal can have one of two actions: retain or drop. What does this mean?
If a goal's action is:
and if the goal is …
what happens?
Example
Retain
active
Entries with this goal are used
3 expenses have a luxury goal (i.e.; longVacations, fancyDining, and theater).
These are kept: their costs contribute toward total expenses.
inactive
Entries with this goal are not used (they are dropped)
None of the luxury goals are obtained; they do not contribute toward total expenses.
Drop
active
Entries with this goal are not used (they are dropped)
A moreWork goal on an income entry (i.e.; partTimeJob with a 4 year timespan).
This entry is dropped -- its earnings do not contribute toward total income.
inactive
Entries with this goal are used
You work at this part time job; its earnings contribute toward total income.
Basically, retain goals are for good things: ideally (if you meet this goal), you obtain these entries (i.e.; you "purchase luxury goods").
Conversely, drop goals are for bad things: ideally (if you meet this goal), you do not obtain these entries (i.e.; you "avoid working a part time job").
Goals can be active (☺), or inactive (☹);. You are happiest when all your goals are active.
This table shows costs, or earnings, associated with these goals.
Goals can be…
For example ...
Type of goal
Shorthand
Example
Good stuff you obtain...
☺ Obtain
You take fancy vacations every year (a desired goal -- you want to be able to spend money on this)
Bad stuff you avoid...
☺ Avoid
You do not have to work a part time job in retirement (an undesired goal -- you would rather not need to earn this income)
Good stuff you can not obtain ...
☹ Not obtain
You just can not take those yearly fancy vacations
Bad stuff you can not avoid ..
☹ Not avoid
You need extra money, so you must work part time during retirement
Goal: specifying sets of goals using the goal variant
The goal variant is optional. Variants, if entered, must be an integer between 1 and 20.
Variants are used to create a set of goals -- goals that have the same name!
You can have only 1 active goal in a set -- all others must be inactive. retPlan's goal choosing tools will make sure of that!
Using variants makes it easy to choose between somewhat different versions of the same expense (or income or asset or investment).
Instead of using variants, you could modify an entry (i.e.; change the age end on an investment entry).
Specifying multiple variants of a goal, and then choosing which of these variants to activate, should be quicker (though it
does mean spending the time to specity goals entries).
Specifying goal entries …
Hints:
You must specify a one-word name.
The variant is optional. Variants, if entered, must be an integer between 1 and 20.
Variants are used to create a set of goals -- goals that have the same name!
When you include a goal, you can only include one from a set. That is: only one variant from a set may be included.
Using variants makes it easy to choose between somewhat different versions of the same expense (or income or asset or investment).
Instead of using variants, you could modify an entry (i.e.; change the age end on an investment entry).
Specifying multiple variants of a goal, and then choosing which of these variants to include as a goal, should be quicker (though it
does mean a bit more time creating entries).
When active, a goal can have one of two actions.
On tbe add form, use the radio buttons to choose between retain and drop.
You can include commas in the description (that's why it is the last item on the csv entry forms)
On csv entry forms: empty lines, or lines whose first (non-space) character is a ;, are ignored
What are missing goals?
Every entry (every expense, income, asset, or investment entry) has a goal variable.
Goals are assigned when you create the entry; and when you assign a goal, you are only allowed to pick from a set of defined goals (goals
are defined on the Goals page.)
However, if you delete a goal, any entry assigned this goal is a in state of limbo -- the goal it is part of is no longer defined.
So how are such entries handled? They are dropped! For example, if an expense is assigned a goal that is now undefined (i.e.; does not exist in the
list of goals), it is not used to calculate total (or group total) expenses.
However, by clicking on the ⊄ button, you can display rows with these entries.
We advice modifying these entries --
change their goal to a currently defined goal (or recreate the missing goal).
This is easily done by clicking the , and then clicking on
Modify!
Charting your retPlan results
You can create line (or bar) graphs displaying year-by-year values of retPlan's trend measures. To use retPlan,
just select which measures(s) you want to view, select your
desired options, and then click the to view ... button.
Or, you can display any combination of previously charted trend measures with the vu button.
retPlan's trend measures
𝔦 Assets
𝔦Investments
𝔦IRA/401k
𝔦Earnings
𝔦Costs
𝔦Shortfalls
The are three charting methods:
One retirement age. Select one (or more) of the measures, just one of the RetAge checkboxes, and do not check the Δ checkbox. A year-by-year trend, for each of the selected measures: given the selected retirement age. Thus, if you select all 6 measures, 6 lines (or bar charts) will
be displayed
Several retirement ages. Select just one measure, two or three of the RetAge checkboxes, and do not check the Δ checkbox. A year-by-year trend, for just the selected measure, for each of the selected retirement ages. Thus, if you select 3 retirement ages, 3 lines (or bar charts) will be displayed
Differences across retirement Ages. Select one (or more) measues, exactly two of the RetAge checkboxes, and do check the Δ checkbox. A year-by-year trend of the differences for each measure. The differences are value of larger retirement age - value for smaller retirement age.
Thus, if you select all 6 measures, 6 lines (or bar charts) will be displayed
There are 3 charting areas. Choose one before you click
the to view ... button.
← : 1/2 width area on left
→ : 1/2 width area on right
␣ : full width area on bottom (initially hidden)
Options:
ℜeal$
When checked, real (inflation adjusted) values are used
X / Y min and max
Select the X (age) range, and Y (value) range. This allows you to zoom in.
Bar charts also
When checked, bar charts and a line plot are displayed. This can be cluttered if there is more than one measure being displayed
Values also
Display the actual values next to the line plots. This can be very cluttered.
Every nth point
Display a subset of the values. For example: 2 means display every other value. This is especially useful when displaying values (it unclutters the graph)
Special displays
Earnings details
Immediately displays 3 earnings measures
Cost details
Immediately displays 3 cost measures
Custom combinations
The vu button allows you to display any combination of previously charted trend measures -- such as measures calcuated using different inflation rates; or
different sets of goals
Clicking vu brings up a table of trend measure plots created in this session.
Each row of the table contains
some descriptive information (such as the inflation rate used).
You can select a number of these to display. They will be combined into one plot, using shorthand names in the legend.
You can select up to 15 (which is probably more plot lines than anyone should try to display on a single graph)
You can select some of the display options: such as the chart area to use, whether values are displayed and how many points to display,
and the X and Y mins & maxs.
However, other options (such as retirement age and real values) are ignored -- since the values used are from the prior charts.
✗Would you like to view topic specific help? Getting started with retPlan
Welcome to retPlan: a program to simulate your financial status throughout your retirement. retPlan is designed
to help you see how your future financial status changes as you change your personal decisions and goals (such as when to retire, and what
kind of lifestyle you will lead); and under different guesses about trends in economic circumstances (such as inflation and interest rate pathways).
Simulating your financial status means that for every year of your retirement, retPlan calculates
your total costs (such as your living expenses and loan payments), and
your total earnings (such as pensions, social security, and 401k distributions).
These are then compared -- and your assets (your bank accounts and retirement holdings) are adjusted accordingly.
By displaying these, along with your physical holdings (which you can specify when to liquidate), you can
see if there are danger periods -- where you run out of money. Or if there are grandiose periods, where you could easily
afford to spend more money (or accept a reduction in earnings).
retPlan is designed for flexiblity, allowing you to specify in some detail your financial situation. In particular, retPlan
requires details on four classes of activities and assets:
Expenses
Living expenses when you are retired (food, entertainment, health insurance, etc.)
Income
Income streams when you are retired (social security, pension, part time jobs, etc.)
Assets
Current financial assets: both non-tax deferred (bank accounts, mutual funds), and tax-deferred (IRAS, 401ks. etc.).
Investments
Current and future investments, which can involve loans & liabilities (mortgages, automobiles, education expenses, etc.). And, one time expenses & windfalls
Within each class you should specify individual items -- what retPlan calls entries. Each entry describes the item
in a bit of detail -- with the description depending on the class. For example, for an expense, you specify the yearly cost, and an expected inflation rate;
while for an asset you specify its current balance, and its average interest rate over the course of your retirement.
While you can be quite aggregated in how many entries you enter (for example, you could have just one expense entry,
that guesses your total living expenses) -- one
of retPlan's strength is the ability to quickly examine how things change as your decisions change. For example:
What if you want to buy a vacation home?
Or help a child with a big expense (such as graduate education or a down payment)
What if you want to retire early?
Or invest in riskier stocks
What if inflation increases
Or your 401k's return diminishes
To accomodate investigation of what happens under circumstances such as the above, retPlan uses Goals. Goals are assigned to every
entry (in all four classes). Goals have one purpose: you can specify which goals you want to achieve, and which goals you
will not strive for. retPlan will generate its simulation based on which goals you want to achieve, and ignore anything associated with goals
you will not strive for. By changing which goals you want to achieve, you can quickly compare what your financial status looks like as your goals change.
For example...
A luxury goal could be assigned to expenses associated with real nice living: season tickets, 2nd homes, exotic vacations
A workLess goal could be assigned to part-time jobs -- in this case, achieving the goal means you don't work a part time job.
That is: with retPlan, you can specify goals that specify things to achieve, and goals that specify things to avoid.
A inheritance goal, where you specify an investment (such as your home) to be passed on to your children
So -- to fully take advantage of retPlan:
Specify lots of entries! Divide your expenses into a few dozen categories. Break down your assets into
different accounts. Specify your retirement income (such as from pensions and social security) seperately for each of retirement age
you are considering (its easy to do in retPlan).
When you specify these entries: assign them to a goal that describes something you care about achieving (or avoiding).
A dozen or so goals is a good place to start -- more than that can get cumbersome.
And then … include (or exclude) these goals. Excluding means you won't try to achive (or seek to avoid) the entries associated with this goal.
What happens? For example, does dropping a luxury goal make your finances much less scarey? Or does working a 2nd job for a few
years means you can pay for long term care? And how is this effected by changes in inflation predictions?
The point: play around with the goals, and tweak the general parameters (that specify your guesses about future economic trends). … and see what happens!.
Hopefully, this will illuminate something real about the tradeoffs you face during your retirement!
What to do?
👉 Specify your entries!
Use the buttons at the top of the screen to open up pages for
Expenses,
Income.
Financial Assets,
and Investments etc ⋯.
When you open a page you will see a list of the current entries; and you can create new entries.
You can use an easy to read form to specify one entry at a time, or use a table (or a comma seperated list) to enter many entries at a time.
retPlan focuses on financial status after retirement. This means:
The basic idea is that you do not specify details on pre-retirement expenses and income. The presumption is your pre-retirement income will cover all your
pre-retirement expenses: including living expenses and expenses on current investments (such as loan payments).
Any leftover income should be accounted for it in the yearly additions to assets (which can be negative if pre-retirement income is less than expenses).
There is one exception:expenses on future investments that occur before you retire. These can be large (such as a downpayment for 2nd home)!
Thus:
👉Specify global parameters -- such as inflation rate, interest trends, and tax rates
The will open a page of global parameters. This includes the long term inflation rate,
an interest rate adjuster (will interest rates be better or worse than average), and COLA adjustments, and tax rates.
These parameters can make a big difference in your financial portfolio. You can change them to see how your financial portfolio changes (say, if long
term inflation is higher than expected, and interest rates are lower).
👉 Specify your goals by clicking on goals.
This is optional. However, use of goals is a convenient way to simulate your long-term financial status as your personal circumstances (such as which living expenses you indulge in) changes.
👉
When you have all your financial information entered, the Main button brings you back to the home page.
From there, you can observe details on year by year expenses, investments (including
loan payments), and income streams. You can do that for 3 different retirement ages (this lets you quickly see the major impacts that later
retirement can have). And, you can view the big picture for every year: how do your total costs compare to your total earnings,
what this does to your assets balances, and what is the status of your investments.
👉
A useful way to view the status & trends is with Charts.
For a candidate retirement age, you can view a year-by-year chart of
one, or several, trend measures -- such as remaining assets and yearly shortfalls. Or you can view differences, given
different retirement ages. Or you can be creative, and produce a variety of charts and display them in custom combinations.
Some tips
The message window
retPlan will often display content (such as the year-by-year financial status reports) in a popup message window.
This message window has a number of control icons:
✋ Move message window (depress button, move, and relase)
⇕ Resize message window (depress button, move, and relase)
⤵ click to move message window to a series of preset positons
✗ close message window
⇗ Display contents of message window in a new browser window (that can be saved/printed/etc).
Note that this icon is also used on other pages (not just in the message window) -- for example, it is used to copy charts to a new window.
⎗ View next contents of the prior message window
⎘ View prior contents of the next message window
Context specific help
retPlan's has a fair amount of context specfic help (such as when you create entries). Just click on the
help buttons and the
help links
popup titles
A short description is displayed when you move the most over just about any
and
links.
Also, you can move your mouse over a
𝔦 icons
to see a more detailed popup tip.
Saving scenarios
Do you have some very different retirement pathways you would like to compare -- so different that using a variety of goals is too much trouble?
Then specify a different scenario.
Each scenario is completely seperate, so you can specify big differences (i.e.; very different expense and income projetions)
and see how things change.
You can create new scenarios that are copies of old ones (so the old one can be treated as a baseline).
Archive & restore
Archive: You can save all of your entries to a file on your hard drive. At a later date, you can then
Restore: : Restore your entries from a previously created archive file.
In addition, you can read entries (for example, expenses entries) from a comma seperated value (CSV) file -- say, as produced by
your favorite spreacsheet program.
And you can export entries to a CSV file (say, to import to a spreadsheet)
info
The info page contains a variety of informationals; including historical data on inflation and interest rates, a
summary table of social security earnings, a FERS income estimator, and worksheets that display the impact of inflation on financial assets and
mortgages.
? Charts of financial status trends
...
...
...
Statistics and information
Some historical trends: treasury bill interest rates, inflation, Dow Jones growth
In period (i.e.; 10 year period) ending in this year, the average yearly rate was …
Calculating your social security income
Social security income primarily depends on your history of earnings, and your retirement age.
The Social Security website contains severalonline benefit calculators -- including
a quick calculator (that requires only a little bit of information, to calculate a guess) and personallized ones
(that use your actual earnings records to give a close estimate).
The following table uses the Social Security website quick calculator to estimate some examples of social security income
Current age
Current yearly earnings
Earnings growth (over your lifetime)
Approx social security monthly benefits at retirement age ...
62
66
70
55
$40k
typical
$915
$1265
$1740
60
$40k
typical
$915
$1290
$1750
62
$40k
typical
$911
$1260
$1740
65
$40k
typical
—
$1190
$1660
55
$40k
flatter
$1052
$1400
$1872
60
$40k
flatter
$1110
$1490
$1960
62
$40k
flatter
$1160
$1490
$1975
65
$40k
flatter
—
$1420
$1940
55
$80k
typical
$1480
$2000
$2720
60
$80k
typical
$1470
$2080
$2790
62
$80k
typical
$1500
$2140
$2785
66
$80k
typical
—
$1910
$2685
55
$120k
typical
$1745
$2380
$3250
60
$120k
typical
$1770
$2460
$3310
62
$120k
typical
$1830
$2420
$3300
66
$120k
typical
—
$2310
$3170
Notes:
typical growth assumes that over the last 35 years your yearly income has grown at 2% more than the average income growth rate.
flatter growth means that over the last 35 years, you income has grown at the national average. Which means: compared to typical
growth, you made more in the past (that's why monthly benefits are greater, since your lifetime average monthly income is greater)
Calculating FERS income
FERS (Federal Employee Retirement System) income is based on the number of years of federal service, and the average high 3 income, and
your age of retirement. The following form will give approximate FERS payments (under some common assumptions).
Federal tax rates
Note that negative rates are due to means tested income transfers (such as medicaid).
Average Income Tax Rate (percent of income). Does not include payroll, corporate, or excise taxes (9-13%)
Income percentile
Year 0 to 20 20-40 40-60 60-80 81- 90 91- 95 95-99 Top 1% All
======== --------------------------------------------------------------------------
1979 -0.2 4.1 7.4 10.1 12.3 14.1 16.8 22.6 11.1
1989 -1.9 3.0 5.9 8.3 10.7 12.6 15.6 20.4 10.3
1999 -5.7 1.7 5.1 8.0 11.0 13.5 17.7 24.5 11.5
2009 -12.8 -2.8 1.4 4.7 7.7 10.3 14.7 21.1 7.5
2015 -11.6 -1.3 3.0 6.6 9.7 12.2 16.9 24.0 10.1
2019 -11.6 -1.3 2.0 3.6 6.7 9.2 11.9 21.0
Within these quintiles, the average household income (inflation adjusted), k$. market income (includes SS)
1979 15 36 56 76 99 123 178 557 65
1989 14 36 58 83 113 146 219 891 75
1999 18 42 66 96 134 178 289 1525 95
2009 20 42 67 100 143 191 292 1324 94
2015 20 44 71 108 157 214 356 1855 105
2019 20 44 71 108 157 214 356 1855
source: https://www.cbo.gov/system/files/2018-11/54646-Distribution_of_Household_Income_2015_0.pdf
For 2019, there are no CBO estimates. A guess is made using average tax rate calculator at
https://www.taxact.com/tools/tax-bracket-calculator
(using the difference between 2015 and 2019 rates);
Below $200k
Above $200k
Inflation impacts
Inflation can have interesting impacts on your assets. In particular:
Distributions from an asset (such as 401k) can be strongly impacted by inflation -- holding interest rate fixed, the higher the
inflation the quicker the will zero out.
If inflation increases faster than interest rates (if the real interest rate decreases),
the increase in your principal will be less than the increase in required distributions (that is: distributions required to
purchase the same set of stuff). You will run of out money (in this financial asset) quicker ☹
A fixed interest rate mortgage, on an asset whose appreciation tracks inflation (i.e.; a home mortgatge), can act as an inflation hedge.
A fixed rate loan on an asset that appreciates at the inflation can offer protection against high inflation -- since the
real value of the asset remains the same, but the real value of the mortgage payments decreases.☺
Inflation impact examples
You can use the following to illustrate these impacts (for simplicity, we assume a non-tax deferred financial asset, and no tax deductiblity of loan payments).
Inflation impacts on a financial asset being drawn down
Inflation rate:
Interest rate
[real interest rate=3%]
Starting balance:
real yearly withdrawals:
│
fixed yearly withdrawals:
Inflation impacts on purchasing a property with a loan
Inflation rate:
Loan interest rate
[real interest rate=3%]
Loan amount:
length of loan:
│ real monthly income generation:
𝔦 ...
Financial asset
Property purchased with loan
Year
Asset Balance
Interest earnings
Nominal withdrawals
Remaining principal
Net yearly payments
Net sale value
𝔦 ...
Year
Balance
Interest earnings
𝔦 Nominal
withdrawals
𝔦 ...
Year
Remaining principal
infAdj payments
𝔦
infAdj
𝔦
net sale value
monthly
cumulative
final cost
Nominal
Real
Archive restoration. You can check these entries. When ready, click the Restore these entries button.
Caution: restoration will overwrite any existing entries with the same name (and subname). It will not remove
entries. So you might end up with redundant (and possibly contradictory) entries that you should delete.