| 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.) |
| 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). |
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 ...
|
| 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.
|
It should not include one-time expenses. And, in particular, it should not include loan payments. Those should be specified under investments.
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). |
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.
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.
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. |
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).
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. |
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).
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:
|
| 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. |
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
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.
| 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% |
For a chart displaying tax rates as a function of AGI -- for all the years supported within retPlan -- use the button.
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% |
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.
|
| 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 is specified on the General page. You can:
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.
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: |
|
inflation mult is a multiplier applied to the general inflation rate. Thus: the inflation rate for an entry will equal:
| 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% |
| Hints: |
|
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.
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 |
| 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 |
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: |
|
| 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 ...
|
cola adjustment is a multiplier applied to the general inflation rate. Thus: the cost of living adjusment rate for an entry will equal:
| 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% |
Hints: |
|
| Social security: | SS taxable fraction depends on your income -- but is never more than 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 |
| 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 |
| loan amount |
This is how much you will spend, or currently owe.
|
|---|---|
| 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 are (for most people) are fully tax deductible. However, if the loan is to pay for a vacation, probably not. |
| 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 |
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).
| 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 |
Hints: |
|
| $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. |
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...
|
| 0.5 | Equal weighting | If all accounts have priority of 0.5, then withdrawals (and deposits) are proportional to the size of the account. |
| 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. | |||
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:
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.
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: |
|
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.
Hints: |
| |||||||||||||||||||||
| 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. |
| Goals can be… |
| 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 |
| Hints: |
|
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.
| retPlan's trend measures |
|
| The are three charting methods: |
|
|
There are 3 charting areas. Choose one before you click the to view ... button. |
|
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