________________________________________________________________________
"Personal Financial Planning Software"©
The "Retirement Financial Planning Software" is an analytical tool designed to help you develop a sound financial strategy so you can achieve the retirement lifestyle you desire. It will reinforce your retirement financial plan by helping you make informed decisions in setting and achieving your life goals.
__________________________________________________________________
Review
your personal finances and create a reliable
personal Retirement
Financial Plan.
Build and maintain an Emergency Fund that will help you preserve your desired standard of living and act as a form of insurance against a sudden unexpected need for emergency funds.
Establish and preserve a Diversified Investment Portfolio that will reduce your investment risks; protect both your short term and long term financial goals; and adjust for your changing level of risk tolerance.
Develop
a CD
Ladder
to safeguard your short term financial security and shield your retirement
savings from a temporary economic recession. This is especially important when
you are nearing your retirement or have just entered retirement.
__________________________________________________________________
The Retirement Financial Planning software will help you identify the factors that you should consider in planning your financial future. The model will provide Cash Flow forecasts and Total Net Worth estimates, BY YEAR, from the current year through retirement (maximum of 41 years). It will also provide a year to year breakdown of your Income Forecasts; Projected Personal Expenses; Investment Portfolio; and Contributions / Distributions / Balancing of excess earnings and / or expenditures.
__________________________________________________________________
Price - Only $19.95 for unlimited plans
(Develop a plan for
yourself as well as plans for your parents or children)
(Access a "Live" or "Adobe '.PDF'
format" Sample Retirement Financial Plan below)
__________________________________________________________________
The
software is designed to assist you in developing a comprehensive retirement plan and
answer many of your retirement questions including:
Is your retirement financial plan on track? Will your retirement income (Social Security, Fixed Income, Pension, Annuity, Etc,) along with your financial assets (Stocks, Bonds, Mutual Funds, Etc.) cover your expenses during retirement.
Can you and/or your spouse retire early?
Can you and/or your spouse reduce your work week during your last year (s) of retirement?
Do you need to adjust your spending (fixed and/or discretionary) to meet your retirement goals before or during retirement?
Can you take that European vacation you always desired after you retire?
Will you need a part-time job after you retire to meet your retirement financial goals? For how long?
Can you meet your retirement goals by adjusting your investments to a more aggressive portfolio?
Will you need to use your home and/or personal property as financial resources to meet your retirement goals?
Can you increase your discretionary spending and still retire early? By how much?
Do you have enough cash or liquid assets available for an emergency event (E.g. emergency medical costs, loss of car or major appliance, etc.)?
What effect will your MORTGAGE have on your retirement finances? Your CREDIT CARD balances? When and why should you pay these off?
____________________________________________
You have complete control over all aspects of your retirement financial plan. You can change any and/or all elements of your plan effortlessly to check its validity and reliability. You can immediately see what changes will have the most impact in helping you achieve your retirement financial goal.
____________________________________________
The
model is segmented into four User Friendly sections:
Primary Data
Entry
Financial Retirement
Reports & Graphs
Advanced Schedules
(Optional)
Tools and Aides
(As needed)
_______
View
a Live Sample Retirement Financial Plan
(in MS Excel)
The sample plan displays the screens
& reports contained in the model with demo values.
The RED outlined cells identify those fields in which data entry
is allowed.
All cells with a RED
TRIANGLE in the
upper right corner contained in the model have comments, instructions, and
additional information to assist the user in entering data or understanding the
process used in the model. The comments will appear when you place your curser
on the cell.
Most screens
and schedules are operational. However, some schedules are not interactive in
the Web Site Demo ONLY. The Demo will provide a realistic example of a retirement
plan and a hands-on experience of
how the model operates.
The model contains buttons used for simple navigation from the "Index" to all
other screens and to return to the "Index".
The buttons
utilize simple navigation VBA macros to perform these tasks. "Enable Macros" when opening the
workbook to use the
navigation buttons,
You can open the workbook without enabling the macros ("Disable
Macros"). However, you will have to
manually move from worksheet to worksheet.
"Live"
Sample
Retirement Financial Plan
(a
2 MB file in
Microsoft "Excel". It may take a few seconds to download or open)
Price - $19.95
Click (Here)
to place an order.
OR
View
the sample plan in '.PDF' format below
using
Adobe Acrobat's Reader. You can print copies of the samples.
(You
may close the window in which the examples appear at the end of each review.)
____________________________________________
You can create an unlimited number
of retirement financial plans concurrently changing the user’s profile, income
forecast,
expense forecast, investment assets, market performance and economic factors.
The User’s manual examines the primary elements that affect a retirement financial plan.
____________________________________________
(Top
of Page)
Primary
Data Entry
The data entered in these input screens are all that is required to create your
primary retirement financial plan. Each data entry screen asks you to enter different categories of
your
basic financial information in the Red
outlined cells only. You can enter estimates and / or refine your analysis by
entering adjusted historical values:
Plan title and economic parameters (estimated inflation %; estimated cost-of-living %; ages; year of retirement; plan start date; etc., ….)
Expected income sources (current and during the plan period). The model can accommodate fixed period pensions & annuities or pensions & annuities that designate a variable survivor benefit.
Current actual and planned future expenses (fixed and discretionary)
Current financial investments and real estate holdings; and expected return on investments (interest, dividends & appreciation)
Current liabilities (mortgages, loans, credit card debt, …)
(Sample Input Screens)
(in Adobe ".PDF" format)____________________________________________
(Top of Page)
Financial
Retirement Reports & Graphs
The model provides two sets of financial retirement reports and graphs for you to review and
analyze your personal financial retirement plan.
Retirement Cash Flow Forecast (by year for the entire forecast period)
Retirement Cash Flow Graphs (by year for the entire forecast period)
Retirement Forecasted Net Worth (by year for the entire forecast period)
Retirement Net Worth Graphs (by year for the entire forecast period)
(Sample
Financial Retirement Reports & Graphs)
(in Adobe ".PDF" format)
(These reports & graphs are easier to view when printed)
____________________________________________
(Top of Page)
Advance
Schedules (Optional)
The model allows you to refine your primary retirement financial plan by allowing
you to adjust your financial information to fit your unique
circumstances.
Enter supplemental incomes expected during the forecast period (part-time jobs; home-base business; hobby; etc.).
Enter special / miscellaneous expenses that might be incurred during the forecast period (purchase of a new car; a special vacation; family gifts; donations; etc.).
Enter current personal property and associated loans if applicable (valuable collections; antiques; etc.).
Maintain and balance your portfolio during the forecast period (assign your annual contribution to specific assets; specify asset distributions when applicable; and annually rebalance your portfolio if desired).
Build and maintain an Emergency Fund that will help you preserve your desired standard of living and act as a form of insurance against a sudden unexpected need for emergency funds.
(Sample
Supplemental Schedules)
(in
Adobe ".PDF" format)
(These reports
are easier to view when printed)
(The
Distribution report is best printed on legal size paper)
____________________________________________
(Top
of Page)
Financial
Security
Schedules / Reports (Optional)
The model allows you to analyze your portfolio and adjust it to your personal
short and long term financial goals. It will provide suggested adjustments to
your portfolio for diversification and short term financial security.
Establish and preserve a Diversified Investment Portfolio that will reduce your investment risks and protect both your short term and long term financial goals.
Develop a CD Ladder to safeguard your short term financial security and shield your retirement savings from a temporary economic recession.
(Sample
Financial Security Schedules / Reports)
(in
Adobe ".PDF" format)
(These reports
are easier to view when printed)
____________________________________________
(Top of Page)
Tools
& Aides (As needed)
The model provides tools and aides to assist you in developing a more
concise retirement financial plan.
You can enter your past expense history (up to 3 years) and the model will perform a detail analysis to help you develop a more reliable expense forecast.
Consolidate investments - This tool allows a user who has a large number of financial investments to consolidate like investments so they can be entered as a group on the Investments input screen.
The model provides a 'Future Value of Money Calculator' to assist you in estimating future values you may be entering in the model.
Warning messages are provided to help you identify possible errors and/or omissions when entering data into your plan.
(Sample
Tools
& Aides)
(in
Adobe ".PDF" format)
____________________________________________
(Top
of Page)
The
Process
(Reference
the 'Sample Model' above)
You enter your personal information to obtain an estimate of your financial position (current and in retirement). You can first use historical market performance values in your evaluation of your plan along with historical averages for such values as: return on assets; cost-of-living index; real estate appreciation; social security inflation index; and percent annual increases in salary. Historical averages are provided for reference.
You define the reporting currency to be used in the model.
You enter your estimated annual income sources for the first year of your retirement financial plan in the “Income Forecast” data entry screen. Samples include: salaries/wages; social security / pension / government defined benefit plan; annuity / fixed income; etc.; …). Income forecasting is then performed automatically by the model using these values and the economic factors you have entered.
The model accommodates a Significant Change in an Ongoing Annuity, Fixed Income or Pension to allow you to modify one or both of your annuity, fixed income, or pension revenues to accommodate a fixed period instrument or designate a variable survivor benefit for an instrument.
You enter the expense values (fixed and discretionary) you expect for the first year of your retirement financial plan. Expense forecasting for the balance of the plan period is automatically performed by the model using these values and the economic factors you have entered. The values can be entered as a single lump sum amount or broken down by detail expense types.
The software allows you to schedule a significant change in your spending pattern at the time of retirement or at another significant event during the forecast period. (E.g. reduce fixed expenses to 90 % of the pre-retirement levels and/or increase discretionary expenses to 105 % of pre-retirement levels.).
Mortgages and structured loan payments are entered if applicable.
The model automatically calculates the net operating income / loss on the “Cash Flow Forecast” report for the entire forecast period and transfers this information to the “Forecasted Net Worth” report. Graphs of the Cash Flow forecasts and Net Worth forecasts are updated automatically.
Investment assets, real estate holdings and personal property values are entered along with estimated return-on-investment percentages. The retirement planning software uses these values; the cash flow forecast; and economic factors for automatically generating the 'Net Worth Forecast' report.
You can enter special one-time expenses and incomes for any future periods. (Example: special vacations; future auto purchase; future assisted living costs; part-time employment income; inheritance; etc.; …).
You can optionally enter up to three years of historical expenses in the 'Expense History Analysis' tool provided. The model will use this information to calculate historical averages for the periods entered and item by item percentages for each expense category. It will also show the maximum value of the annual amounts entered for each expense.
You can define how and where any surplus income is applied to a particular asset during the forecast period. You can also deduct excess expenses from specific assets as desired. You can rebalance your portfolio each year if desired. The model is designed so you can apply Minimum Required Distributions for IRA’s; 401(k)’s; 403(b)'s; 457; etc., if applicable.
____________________________________________
(Top
of Page)
General
The model provides suggestions; recommendations; and sources of information that may help you achieve your retirement goals.
The personal retirement planning software is written in easy to understand Microsoft Excel with all formulas and spread sheets protected making it very user friendly.
Exact values and economic measurements may not always be available. You can perform an infinite number of "What If?" scenarios by changing any of the values and parameters in the retirement financial plan. This allows you to examine the validity and reasonableness of the numbers and their significance. You can develop a realistic retirement financial plan by performing multiple “What-If?” scenarios varying the amounts and economic parameters between average expectancy, worse case scenario and optimum conditions.
____________________________________________
(Top
of Page)
The results generated by the retirement planning software (cash flow forecasting, expense forecasting, income forecasting and net worth forecasting) are based on the information and parameters provided by you. All values are in future dollars. Trends and historical performance values discussed in the instructions and used in the demo retirement financial plan are only provided as reference. Past market performance and economic conditions are not a guarantee of future results. The results of the retirement financial planning software should not be used as the primary basis for any investment or tax planning decisions. We strongly recommend that you seek the assistance of a professional financial advisor before making any investment decisions.
The retirement financial planning software consists of twenty-two (22) interactive spreadsheets and requires about 5.0 MB. It is written in Microsoft Office (MS Excel & MS Word) for Microsoft Windows. System requirements are Microsoft Office 2003 or higher / Microsoft Windows.
Excel,
Microsoft and Windows are registered trademarks of the Microsoft Corporation.
_______
Submit
questions & inquiries on the Personal Retirement Financial Planning Software to
support@hornungllc.com.
___________________________________________
The retirement financial planning software gives you a comprehensive set of tools for establishing, evaluating and monitoring your financial future.
Price - $19.95
Click (Here)
to place an order.