J&L Retirement and Financial Planner

[Pages:160]1

J&L Financial Planner Users Manual

Version 23.0

Copyright ? 2018 J&L Software LLC All Rights Reserved

J&L Financial Planner ? Version 23.0

2

Table Of Contents

TABLE OF FIGURES.....................................................................................................................6

INTRODUCTION............................................................................................................................9

Assumptions................................................................................................................................................................................9 Getting Started.........................................................................................................................................................................10

QUICK TIPS.................................................................................................................................12

Quick Tip ? Importing Account Data From A Tab or Comma Delimited File..................................................................12 Comma-Delimited File (CSV)...............................................................................................................................................12 Tab-Delimited File.................................................................................................................................................................12

Quick Tip ? Exporting Account Data To A Tab or Comma Delimited File.......................................................................13 Quick Tip ? Summary Folder.................................................................................................................................................13 Quick Tip ? Accounts Folder..................................................................................................................................................13 Quick Tip ? Results Folder......................................................................................................................................................13 Quick Tip -- Graph Functionality..........................................................................................................................................14 Quick Tip ? Asset Allocation Withdrawals (Retirement/Professional Versions Only).....................................................15

Asset Allocation Withdrawal Options Fields.........................................................................................................................15 Quick Tip ? Required Minimum Distribution (RMD) (Retirement/Professional Versions Only)...................................16 Quick Tip ? Revenue Code Section 529.................................................................................................................................17 Quick Tip ? Printing Reports And Graphs...........................................................................................................................17

Alternate Print Engine............................................................................................................................................................17 Original Print Engine.............................................................................................................................................................18 Quick Tip ? Lighter Banding..................................................................................................................................................18 Quick Tip ? Removing Summary From Results....................................................................................................................18 Quick Tip ? Monte Carlo Analysis (Professional Version Only).........................................................................................18 Quick Tip ? Font Size / Line Width........................................................................................................................................19 Quick Tip ? Colorizing An Event Description (Professional Versions Only).....................................................................19 Quick Tip ? Changing Age to Years.......................................................................................................................................20 Quick Tip ? Exporting Reports to Spread Sheets and Data Bases......................................................................................20 Quick Tip ? "Drilling Down" a Value....................................................................................................................................20

2

3

Quick Tip ? Undo / Redo Changes.........................................................................................................................................21

MENUS.........................................................................................................................................22

File Menu..................................................................................................................................................................................22 Import New............................................................................................................................................................................22 Open.......................................................................................................................................................................................22 Save........................................................................................................................................................................................22 Save As...................................................................................................................................................................................22 Import From Mobile...............................................................................................................................................................22 Import Account Data..............................................................................................................................................................22 Export Account Results..........................................................................................................................................................22 Read Accounts.......................................................................................................................................................................23 Write Accounts.......................................................................................................................................................................23 Re-Index Accounts.................................................................................................................................................................23 Save Graphs...........................................................................................................................................................................23 Exit.........................................................................................................................................................................................23

Edit Menu.................................................................................................................................................................................24 Initial Values..........................................................................................................................................................................24 Initial Data Screen..............................................................................................................................................................24 Initial Data Screen Fields.......................................................................................................................................................25 Optional Effective Tax Table.................................................................................................................................................26 Account Category Group Names (Retirement/Professional Versions Only).........................................................................28 Asset Allocation Names (Professional Version Only)...........................................................................................................29 Add Account..........................................................................................................................................................................30 Add Event To Scenario..........................................................................................................................................................30 Withdrawal.........................................................................................................................................................................31 Withdrawal Event Screen Fields....................................................................................................................................31 Deposit...............................................................................................................................................................................32 Deposit Event Screen Fields..........................................................................................................................................33 Loan...................................................................................................................................................................................35 Loan Event Screen Fields...............................................................................................................................................35 Credit Card Debt (Retirement/Professional Version Only)...............................................................................................37 Budgets (Professional Version Only).................................................................................................................................38 Creating A Budget..........................................................................................................................................................38 Mortgage............................................................................................................................................................................40 Mortgage Event Screen Fields.......................................................................................................................................41 Investment Property Worksheet (Professional Version Only).......................................................................................45 Home Equity Line Of Credit (Professional Version Only)............................................................................................46 Property Income and Expenses (Professional Version Only)........................................................................................48 Reverse Mortgage (Retirement/Professional Versions Only)............................................................................................49 Transfer..............................................................................................................................................................................52 Transfer Event Screen Fields.........................................................................................................................................53 Fundamentals (Retirement/Professional Version Only).....................................................................................................55 Fundamentals Event Screen Fields.................................................................................................................................55 Asset Allocation Withdrawal Options (Retirement/Professional Versions Only).................................................................57 Asset Allocation Withdrawal Options Fields.....................................................................................................................57 Required Minimum Distribution Option (Retirement/Professional Versions Only)..............................................................59 Required Minimum Distribution Options Screen...........................................................................................................59 Life Expectancy Table...................................................................................................................................................62 Budgets (Retirement Version Only).......................................................................................................................................64 Creating A Budget..............................................................................................................................................................65 Adjust Monte Carlo Analysis (Professional Version Only)...................................................................................................67

Copyright ? 2018 J&L Software LLC

All Rights Reserved

J&L Financial Planner ? Version 23.0

4

Standard Deviation.............................................................................................................................................................69 Adjust Historical Return Analysis(Professional Version Only).............................................................................................70 Rule 72T Distribution (Retirement/Professional Versions Only)..........................................................................................71

Inputs..................................................................................................................................................................................72 Life Expectancy Tables......................................................................................................................................................73 Methods..............................................................................................................................................................................73 Program Preferences..............................................................................................................................................................74 Report Options (See Reports / Report Options).................................................................................................................74 Automatic Backup and Copy Options................................................................................................................................74

Tools/Aids Menu......................................................................................................................................................................76 Mortgage Calculator...............................................................................................................................................................76 Refinance Analysis.................................................................................................................................................................76 Refinance Analysis Screen Fields......................................................................................................................................78 Accelerated Mortgage Payment Analysis..............................................................................................................................80 Inflation Calculator................................................................................................................................................................81 Taxes/Inflation/Investment Analysis......................................................................................................................................81 Trade Off Analysis.................................................................................................................................................................82 Compare Scenarios.................................................................................................................................................................83 Compare All Scenario Groups (Retirement/Professional Version Only)...............................................................................84 Calculate Effective Rate.........................................................................................................................................................85 Calculate Credit Card Debt Payoff........................................................................................................................................86 View Monte Carlo / Historical Return Analysis Statistics (Professional Version Only).......................................................87 Rule 72T Calculator...............................................................................................................................................................88 Calculator Inputs................................................................................................................................................................88 Life Expectancy Tables......................................................................................................................................................88 Methods..............................................................................................................................................................................89 View Historical Data Files(Professional Version Only)........................................................................................................90

Budgeting Menu.......................................................................................................................................................................91 Create a New Budget.............................................................................................................................................................91 Open an Existing Budget........................................................................................................................................................91 Discretionary / Non-discretionary Reports...........................................................................................................................91 All Budget Reports.................................................................................................................................................................91 Page Setup..............................................................................................................................................................................91 Report / Graph Options..........................................................................................................................................................91

Reports Menu...........................................................................................................................................................................92 ................................................................................................................................................................................................92 Combined Report...................................................................................................................................................................93 Page Setup..............................................................................................................................................................................95 Report Options.......................................................................................................................................................................96 Example Report..................................................................................................................................................................98 Color Chooser....................................................................................................................................................................99 Currency Options.............................................................................................................................................................100

Graph Menu...........................................................................................................................................................................100 Create Graph Window..........................................................................................................................................................100 Save Graphs.........................................................................................................................................................................100 Print Current Graph..............................................................................................................................................................100

J&L Folders Menu.................................................................................................................................................................101 Open Documentation Folder................................................................................................................................................101 Open Backups Folder...........................................................................................................................................................101 Open Reports Folder............................................................................................................................................................101 Open Historical Data Folder (Professional Version Only)..................................................................................................101 Open Logo, Banner, Watermark Folder (Professional Version Only).................................................................................101

4

5

Change J&L Folder Locations.............................................................................................................................................101 Changing J&L Folder Locations..........................................................................................................................................101

TABBED FOLDERS...................................................................................................................102

Summary Folder.....................................................................................................................................................................102 Accounts Folder......................................................................................................................................................................105

Add Account Screen Fields..................................................................................................................................................107 Account Data Screen............................................................................................................................................................108 Assign Rate Components (Professional Version Only).......................................................................................................109 Assign Asset Allocations (Professional version only).........................................................................................................112 Scenario Folder......................................................................................................................................................................115 Financial Scenario Screen....................................................................................................................................................116 Scenario Event Groups (Retirement / Professional version only)........................................................................................117 Results Folder.........................................................................................................................................................................119 Net Worth Folder...................................................................................................................................................................120 Incoming / Outgoing Folder..................................................................................................................................................120 Incoming Folder.....................................................................................................................................................................120 Outgoing Folder.....................................................................................................................................................................120 Group Folder..........................................................................................................................................................................120 Account Graph Folders.........................................................................................................................................................121 Monte Carlo Analysis Folder (Professional Version Only)................................................................................................122 Why Does the J&L Financial Planner Use the Monte Carlo Analysis?...............................................................................122 The J&L Financial Planner Monte Carlo Analysis..............................................................................................................123 How the J&L Financial Planner implements the Monte Carlo Analysis..............................................................................123 Historical Return Analysis(Professional Version Only).....................................................................................................125 How the J&L Financial Planner implements the Historical Return Analysis......................................................................126

END USERS LICENSE AGREEMENT......................................................................................128

Legal Disclaimer.....................................................................................................................................................................128

GLOSSARY OF TERMS............................................................................................................129

KEYBOARD KEY ASSIGNMENTS...........................................................................................130

Table of Figures

Copyright ? 2018 J&L Software LLC All Rights Reserved

J&L Financial Planner ? Version 23.0

6

Initial Data Screen...................................................................................................................................................................24 Optional Effective Tax Table..................................................................................................................................................26 Account Category Group Names............................................................................................................................................28 Asset Allocation Names............................................................................................................................................................29 Withdrawal Event....................................................................................................................................................................31 Deposit Event............................................................................................................................................................................33 Loan Event................................................................................................................................................................................35 Credit Card Debt Event..........................................................................................................................................................37 Budget Event (Professional Version Only)............................................................................................................................38 Mortgage Event........................................................................................................................................................................41 Investment Property Worksheet.............................................................................................................................................45 Home Equity Line of Credit....................................................................................................................................................46 Property Income and Expenses...............................................................................................................................................48 Reverse Mortgage Event.........................................................................................................................................................50 Transfer Event..........................................................................................................................................................................52 Fundamentals Event................................................................................................................................................................55 Asset Allocation Withdrawal Options....................................................................................................................................57 Required Minimum Distribution Options.............................................................................................................................60 Life Expectancy Table.............................................................................................................................................................62 Budget (Retirement Version Only).........................................................................................................................................64 Adjust Monte Carlo Analysis..................................................................................................................................................67 Adjust Historical Return Analysis..........................................................................................................................................70 Rule 72T Distribution..............................................................................................................................................................72 Automatic Backup and Copy Options....................................................................................................................................74 Printer Line Width Offset.......................................................................................................................................................75 Mortgage Calculator................................................................................................................................................................76 Refinance Analysis...................................................................................................................................................................78 Accelerated Mortgage Payment Analysis..............................................................................................................................80

6

7

Inflation Calculator..................................................................................................................................................................81 Taxes/Inflation/Investment Analysis......................................................................................................................................81 Trade Off Analysis...................................................................................................................................................................82 Financial Scenario Comparisons............................................................................................................................................83 Compare All Scenario Groups................................................................................................................................................84 Effective Rate Calculator........................................................................................................................................................85 Credit Card Debt Payoff Calculator......................................................................................................................................86 Rule 72T Distribution Calculator...........................................................................................................................................88 View Historical Data Files.......................................................................................................................................................90 Combined Report.....................................................................................................................................................................93 Report Options.........................................................................................................................................................................96 Example Report........................................................................................................................................................................98 Color Chooser...........................................................................................................................................................................99 Currency Options...................................................................................................................................................................100 Change Current J&L Folders Base......................................................................................................................................102 Summary Folder.....................................................................................................................................................................103 Accounts Folder......................................................................................................................................................................105 Add Accounts Screen.............................................................................................................................................................107 Edit Account Data Screen.....................................................................................................................................................108 Assign Rate Components.......................................................................................................................................................109 Assign Asset Allocations........................................................................................................................................................112 Scenario Folder......................................................................................................................................................................115 Selecting an Event Group(s)..................................................................................................................................................117 Scenario Group ID.................................................................................................................................................................118 Results Folder.........................................................................................................................................................................119 Monte Carlo Analysis Folder................................................................................................................................................122 Historical Return Analysis....................................................................................................................................................125

Copyright ? 2018 J&L Software LLC All Rights Reserved

J&L Financial Planner ? Version 23.0

8

Introduction

Important Note: This manual is common to the three versions of our financial planning software. The graphics and the corresponding descriptions represent the functionality available with our Professional Version. The manual attempts to specify which functionality exists between the three versions of our software, but this is not always the case.

The Financial Planner is designed to create a financial plan comprised of financial events that take place during your life. The Financial Planner was created to give a "broad brush" overview of you financial future based on actual and proposed financial plans. To create a plan:

1. You fill out the initial values form which contains the age you wish the plan to begin and the age you wish the plan to end. Use this form to set your effective income tax rate, inflation rate, capital gains rate and the dividend tax rate.

2. You create accounts that represent your current investments, assets, equity and the return rates for each. 3. You assemble a Financial Scenario consisting of money related events. Each event is applied to the scenario at the event's

start age and continues until the event's end age. These events represent a deposit to or a withdrawal from one of your accounts. There is an event available that allows you to change the fundamental rates with which the scenario is calculated. 4. You run the scenario to see how your accounts are affected by the events.

Assumptions

The Financial Planner makes a number of assumptions. The first assumption is that your savings and investments consist of the following types:

1. Investment Savings ? The interest earned on these investments is taxed. Withdrawals are not taxed. 2. Tax-free Savings ? The interest earned on these investments is not taxed. Withdrawals are not taxed. 3. Retirement Savings ? The interest earned on these investments is not taxed. Withdrawals are taxed. 4. Assets ? Cars, boats, household furnishings, etc. 5. Equity ? Real estate that you own outright. For real estate that has an outstanding mortgage use the Mortgage Event a

scenario.

The second assumption is that all of the events that affect your money are triggered by your age. For example your Social Security starts at a particular age. You can withdraw from an IRA after a particular age. Therefore all of the events that make up your Financial Scenario start at an age (your age at the time the event first takes place) and ends at an age (your age when the event stops.)

The third assumption is when an event requires money to be withdrawn from your accounts the Financial Planner does it in the sequence (order) defined in the Accounts Dialog.

Important: The program will not withdraw from an Asset or Equity account.

When the money in an account is depleted the next account in order is accessed. This order may be overridden for certain accounts with the Asset Allocation Option discussed later. If the withdrawal has to be made from your Retirement Savings accounts before the qualification age ? the Financial Planner will withdraw the required penalties and taxes. If the withdrawal is made from your Retirement Savings accounts after the qualification age is reached the required taxes are assessed.

The fourth assumption is that each year the scenario events will take place in the following order: 1. Fundamentals 2. Deposits 3. Transfers 4. Loans 5. Mortgages 6. Credit Card Debts 7. Withdrawals

This is the same order the events are listed in the Add Event to Scenario menu item.

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download