|
gbVisualRetirement
gbVisualRetirement is a free retirement planning tool which makes it very simple to
create a financial plan in just minutes. Wizards are available to help guide the user
through the steps of creating a basic or advanced financial plan, covering both pre-retirement
and post-retirement. Beginners and more experienced users will find
gbVisualRetirement easy to understand and use, but also very powerful in how
quickly it can be used to examine financial options. Financial plans are generated
in real time in response to user changes.
To install, just unzip the contents of the distribution file into a folder of its own! Then create
a shortcut to the gbvisualretirement.exe file on the desktop, or where is convenient. To remove gbVisualRetirement
just delete the installation folder.
Disclaimer:
Use at your own risk! While an honest attempt has been made to
ensure the accuracy of gbVisualRetirement you should always
consult a professional retirement planner when making critical
retirement financial decisions!
Table of Contents

Feature List
gbVisualRetirement provides the following features:
- Basic and Advanced modes of analysis
- Graphical view of pre- and post-retirement net worth
- Basic modes simplifies user inputs
- Advance mode enables input of greater financial detail
- Wizards available for Basic and Advanced inputs
- Extensive control over which/how information is displayed
- Detailed breakdown of financial calculations
- Analysis covers major financial factors
- Inputs selected from dropdown list, mouse wheel, toolbar button or manually edited
- Simplified "Inertial" inputs (enter once, stays in effect until user changes it)
- Fixed or inflation-escalated savings and expenses
- Automatically save session changes
- Copy image of results to clipboard
- Print image of results
- Online update
- Email the Author option
- Online Help

Introduction
gbVisualRetirement is designed to be used by people of all skill levels. It's simple to
use yet the analysis it provides is comprehensive enough to support sound pre-retirement and
post-retirement financial decisions.
There are two types of financial plans supported, Basic and Advanced.
The Basic Plan is the easiest approach and uses a minimal set of financial inputs.
The Basic Plan is used to provide quick overviews of impact of the factors involved in
retirement - giving the user useful information without requiring excessive time to build the
results.
The Advanced Plan allows entry of a much wider range of financial information. While
the output is the same for both plans (net worth graph), the greater level of detail is
intended to provide greater assurance of the accuracy of the financial plan results.
Wizards are available which walk the user through providing inputs for the Basic and Advanced
Financial plans. Wizards utilize default settings, based on user inputs, to speed up the process
of creating a financial plan. Once the wizard is complete, the user can manually change the
settings to tweak the results.
When I retired, analysis similar to that provided by gbVisualRetirement compared favorably
(though with much less detail) to the results of the software utilized by my financial advisors. I
consider gbVisualRetirement to be an excellent tool to use in getting familiar with retirement
planning and especially as a tool to use before sitting down with your own financial advisor!

Financial Plans
There are two financial plans supported by gbVisualRetirement - Basic and Advanced.
The Basic and Advanced Financial Plans differ by the detail with which the user can specify settings.
Additional details on how user inputs are made for each plan are provided in sections further down
this page, but the bottom line is that the user can exercise greater control over the Advanced Financial
Plan than can be done with the Basic Financial Plan.
For both plans, however, the primary output is a graph showing net worth during pre-retirement and
post-retirement years.
A financial plan file (*.pln) contains both the Basic and Advanced versions of the financial plans. The two
plans can be modified independently of one another, but both are saved when the toolbar Save option is chosen.

Net Worth Graph
A typical retirement plan includes a pre-retirement period of time in which money is
saved for retirement, followed by a post-retirement period in which savings are used
to cover post-retirement expenses.
The primary output of gbVisualRetirement is a graph which shows
the user's net worth throughout pre-retirement (in green) and post-retirement
(in red) through the age of 100.
Automatic Adjustments
By default, the graph is automatically redrawn to fit within the available
area. In particular, axis label values, bar widths and age span covered are
automatically optimized. The user may lock these values if desired.
The graph draws a bar for each age, but if the chart is sized too small for
all ages to be shown without overlapping one another, the chart automatically
skips printing of ages to ensure that printed ages can be read.
By default, the vertical chart values are sized so that the maximum net
worth fits within the dimensions of the chart, ensuring that the graph is as
large as possible. The maximum vertical axis value (net worth) can also be fixed,
which may be less confusing than a chart whose maximum value shifts with changes
in the input values or as the user resizes the main window.
Graph Content
Other than the graph itself (axis values and bars), content of the graph can be tailored
by the user. The graph can be limited to values from pre-retirement, retirement or both.
The annotation categories of retirement net worth, year at which net worth reaches zero,
the principal/interest accrued during pre-retirement and percent of net worth spend each
year are all optional. The age drawn in the graph can be limited to the age at which zero
net worth is reached, or 100 (the maximum age for which calculations are provided).
The chart can optionally include 4 annotations - NW@retirement, year@zero
net worth, rate at which net worth is reduced during retirement and a pie chart
of the principal and interest accrued during pre-retirement. A toolbar button is available
to toggle display of annotations and menus are provided to fine tune which annotation
elements are shown. The rate of reduction may optionally be replaced with the
calendar year.

Basic Financial Plan
The Basic and Advanced Financial Plans differ by the detail with which
the user can specify settings. Both, however, provide a graph showing net worth
during pre-retirement and post-retirement years.
User Inputs
The following image shows the information the user specifies for
the Basic Financial Plan. Whenever a value is changed, the financial
graph is automatically updated. All values are entered as now year values.
Each of these setting values can be selected from dropdown lists. The wheel mouse
may be used to move quickly through the values available to each setting. Just
select one of the setting with the mouse, then use the wheel mouse to scroll up or down
through the dropdown list. If you have manually entered a value that is not in the
dropdown list, gbVisualRetirement will detect the appropriate next value to display
when the wheel mouse is used.
Settings may also be manually typed into the fields. This allows entry of a value other
than one found in the dropdown list. After typing in a value, pressing
ENTER will update the financial graph.
Next are some comments about the pre-retirement inputs needed by the Basic Financial Model.
- Current Age
The user's current age, at which financial planning begins.
- Retirement Age
The age at which retirement begins. At that age, the Pre-Retirement
settings no longer apply and the Retirement settings do apply.
- Current Net Worth
This includes all user assets, to which interest can be applied during
pre-retirement years. It could also include the current value of the
user's home, if the user intends to eventually sell the home as needed to meet
future expenses and if the user expects the value of the house to grow
according to the Basic Financial Plan interest rate.
- Monthly Savings
The amount of money to be put into savings or investment accounts in each of
the pre-retirement years. In order to keep savings at the equivalent now year
entry, monthly savings are assumed to grow at the pre-retirement inflation rate.
- Interest
This is the interest rate applied to month savings in each pre-retirement year.
Interest is applied as though all savings were deposited on the first day of
the year.
- Inflation
The pre-retirement inflation rate is used to calculate the projected "then year"
monthly savings.
- Fixed Retirement NW
Rather than have gbVisualRetirement calculate net worth at retirement, the
net worth can simply be assigned a value. Checking the "Fixed Retirement NW"
checkbox will tell gbVisualRetirement to ignore Pre-Retirement settings
and instead use the entered net worth value.
Retirement Inputs
Next are some comments about the post-retirement inputs needed by the Basic Financial Model.
- Monthly Income
The amount of money earned each year of retirement. This might include Social Security,
salary/wages, or any other source of income. The value is entered in now year dollars.
- Monthly Expenses
This covers all expenses during retirement - home, insurance, medicine, food, travel, etc.
The value is entered in now year dollars.
- Interest
This is the yearly interest rate applied to income in each year of retirement.
The interest rate applies to all years of retirement.
The Advanced Financial Plan allows the interest rate to vary each year.
- Inflation
The post-retirement yearly inflation rate is used to establish "then year" values for income
and expenses during retirement. The inflation rate applies to all years of retirement.
The Advanced Financial Plan allows the inflation rate to vary each year.
Intermediate Calculations
The following intermediate calculated values, used in generating the net worth values for the Basic
Financial Plan, can optionally be displayed.
(click on the image to see a full size, readable version)
A user may occasionally want to review the intermediate values for each year to
determine what then-year values have been used by the plan.

Advanced Financial Plan
The Advanced Financial Plan uses a completely different approach to specify
the user inputs, as shown in the following image.
Here's a close up image of just the Advanced Financial Plan input section:
The Advanced Financial Plan allows up to 100 lines of input, where each line
consists of a description and the age at which the additional (optional)
10 inputs on the line become effective.
Here's a description of the parameters found on each input line. One or more
input values can be assigned to any input line.
- Desc - A description of the reason which the input values are changing
- Age - Age at which the remaining parameters apply.
- Int - Interest rate (yearly)
- Inf - Inflation rate (yearly)
- AltInf - Alternate inflation rate (yearly)
- Lump Sum - Lump sum income (yearly)
- SocSec - Social security income (monthly)
- Work - Work related income (monthly)
- Other - Other income (monthly)
- Lump Sum - Lump sum expenses (yearly)
- Expenses - Expenses (monthly)
- Alt Exp - Alternate expenses (monthly)
The Advanced Financial Plan input lines can be placed in any order. gbVisualRetirement
always sorts the lines by age before using them to generate results.
Persistent Inputs
When an Advanced Financial Plan monthly input is entered, the input continues to apply in all
subsequent months/years until explicitly changed by another input line. For example, in the following
excerpt from the input image above ...
Desc Age Int%
Current Age 30 5.0
Retirement 65 4.0
The interest rate of 5.0 applies for years 30-64. The interest rate of 4.0 applies
for years 65-100 (100 is the maximum year of both the Basic and Advanced retirement plans).
Yearly Inputs
Lump Sum inputs (income or expense) are yearly values and apply only to the year
specified by the Age on the input line
Required Input Lines
There is a minimum of 2 lines required for the Advanced Financial Plan inputs. One
line must have a description of "Current Age", "Now", or "Today". The Age on that
line is considered to be the starting age of the Advanced Financial Plan.
A second line must have the description of "Retire" or "Retirement". The Age on that
line is considered to be the retirement age of the Advanced Financial Plan.
Toolbar for Advanced Financial Plan Inputs
The following toolbar allows actions to be taken on the plan rows and cells:
- Clear (All) - Clears all rows in the plan
- Clear (Row) - Clears the selected row
- Cut - Copies the selected row to internal clipboard and then deletes the row
- Copy - Copies the selected row to an internal clipboard
- Paste - Fills the selected row with the content of the internal clipboard
- Delete - Deletes the row without copying it to the internal clipboard
- Insert - Inserts a new row above the selected row
- Raise - increases the value of the selected cell
- Lower - decreases the value of the selected cell
- Sort - sorts all rows of the plan
- GoTo - jumps to the Advance Financial Plan results grid, same age as the selected plan row
Many of the toolbar functions are also conveniently available via the plan context menu.
Intermediate Calculations
The following intermediate calculated values, used in generating the net worth values for the Advanced
Financial Plan, can optionally be displayed.
(click on the image to see a full size, readable version)
A user may occasionally want to review the intermediate values for each year to
determine what then-year values have been used by the plan.
In the Intermediate Calculations you'll see headers which start with nm, ny, tm and ty.
These are just shortcuts for "Now Monthly", "Now Yearly", "Then Monthly", "Then Yearly".
The shortcuts are used just to keep the header widths to a minimum.

Main Toolbar
Many gbVisualRetirement features and settings are accessed through the toolbar,
as discussed in the following paragraphs.
- New - Create a new financial plan (with default values)
- ... file names ... - Lists the last 10 previously Opened or Saved financial plans
- Clear History - Removes all entries from the history list
- Open - Open an existing financial plan
- Save - Saves all changes to the current financial plan.
The dropdown menus provides additional options ...
- Save As - Saves current financial plan to a new file
- Pre-Ret - Display only pre-retirement values in the financial chart
- All - Display both pre-retirement and retirement values in the financial chart
- Ret - Display only retirement values in the financial chart
- Std - Displays the Basic Financial Plan
- Adv - Displays the Advanced Financial Plan
- Copy - Copies the chart to the clipboard/
The dropdown menus provides additional options ...
- Copy Dialog - Copy the gbVisualRetirement window to the clipboard
- Print - Print an image of the financial chart
- Annotate - Toggles display of all annotation options
- Details - Displays intermediate calculations used to generate the graphed Net Worth values.
- Settings - Toggle display of the graph only or the graph and plan inputs.
The dropdown menus provides additional options ...
- Auto Select Max Age - Plot only to the age at which net worth is zero
- Fixed Vert Scale - Fix the maximum vertical dimension of the chart
- Show Graph Only - Hide the bottom half of the display (inputs and calculations)
- Auto Save Session - When closing the app, save values into a temporary file that will be loaded when the app is re-opened
- Show Calculations in Reverse Age - Show numerical results starting with age 100 at the top of the listing
- Minimal Advanced Results Headers - Uses short-cut names for the headers of the Advanced Financial Plan calculations
- Show Results as $K - Displays dollar amounts as $K. Note that some values will appear as "0" because their value is rounded
- Set Basic Chart Title - Allows user to enter their own title for the Basic graph
- Set Advanced Chart Title - Allows user to enter their own title for the Advanced graph
- Annotation - Opens sub-menu containing items to include in the chart
- Colors - Opens sub-menu containing options to change various chart colors
- Max Age - Fix the right-most age that will be plotted in the chart
- Vertical Scale - Sets the maximum vertical dimension of the chart (enabled by "Fixed Vert Scale" setting)
- Help - Open this online Help page
The dropdown menus provides additional options ...
- Online Update - Downloads the latest gbVisualRetirement version (if newer)
- Email Author - Opens the default email client with an email addressed to the gbVisualRetirement author
- About - Display the version number and usage disclaimer

Basic Input Wizard
gbVisualRetirement provides a built-in Wizard which can walk users through providing
the inputs needed for a Basic Financial Model. Just click the "Wizard" button on the main
toolbar to start the Wizard.
The Basic Wizard walks the user through the necessary inputs in just 5 questions.

Advanced Input Wizard
gbVisualRetirement provides a built-in Wizard which can walk users through providing
the inputs needed for an Advanced Financial Model. Just click the "Wizard" button on the main
toolbar to start the Wizard.
The Advanced Wizard walks the user through the necessary inputs in just 10 questions.

Wizard Assumptions
This section documents the settings used by the Wizards, in response to user inputs.
In particular, the primary input from the user is the "Risk" level, which I've listed
as 'Conservative', 'Typical' and 'Best Case'. That choice affect the interest/inflation
rates, savings amount, and expenses that are used in the financial model, as shown in this
table:
| Pre-Retirement | Post-Retirement
| | Risk | Int | Inf | Alt-Inf | Savings | Int | Inf | Alt-Inf | SocSec | Exp | Alt-Exp
| | Conservative | 4.0 | 3.0 | 6.0 | 10% | 2.0 | 3.0 | 6.0 | $800/person | 90% | 30%
| | Typical | 5.0 | 3.0 | 6.0 | 15% | 4.0 | 3.0 | 6.0 | $1000/person | 85% | 25%
| | Best Case | 6.0 | 3.0 | 6.0 | 20% | 6.0 | 3.0 | 6.0 | $1200/person | 70% | 20%
|
Notes:
One of the questions in the Wizard is how many people are included in the plan. That allows
the setting to be multiplied by the per person Social Security defaults given in the table.
Another question is how much monthly income does the user make. The Savings percentages in the
table are applied to that value to determine pre-retirement savings.
Post-retirement expenses are estimated as a percentage of the pre-retirement expenses.
Finally, post-retirement alternate expenses (those which use a higher inflation value) are
estimated as a percentage of the post-retirement expenses.

Keyboard Shortcuts
The following key combinations are available to the user to access gbVisualRetirement features:
- F1 - Help
- Ctrl+G - Cycle through which content to display in the chart (pre-, post- or both)
- Ctrl+H - Toggle hiding the detailed financial plan calculations (shown below the inputs)
- Ctrl+I - Display information report
- Ctrl+L - Toggle location of graph only
- Ctrl+M - Toggle display of minimal Advanced Financial Plan result headers
- Ctrl+N - Create a new financial analysis
- Ctrl+O - Open an existing financial plan
- Ctrl+R - Reverse the numerical listing of results
- Ctrl+S - Save the current financial plan
- Ctrl+W - Display the current Wizard input values
- Ctrl+Y - Replace "Draw" annotation with "Calendar Year" annotation
Other Comments
Comments and suggestions are welcome!
|