Client Data Worksheets

Follow

The General Information tab of the Client Data worksheet contains Client Personal information and Client Annual Income sections.

general_info.png

  1. Personal Information Section: Information in the Client Personal information section is pre-filled with the client and spouse’s names entered when the client was first created in the Client Management screen. You may click on the Details button to the right of the clients’ names to see the address, phone number and other contact information.

    NOTE: Finance Logix allows creation of multiple plan scenarios; therefore any changes made to the top level client contact information will be automatically applied to all of the existing planning scenarios. However, changes to the Marital Status can differ from one planning scenario to the other.

  2. After entering client’s Date of Birth, the system automatically calculates the age. Date of Birth can be entered in the input field or selected by clicking on the Date picker icon next to the field.
  3. The system defaults the Retirement Age to age 67. You may change this value or click on the Currently Retired checkbox if the client is in retirement. Clicking the checkbox will automatically set the Retirement Age to current and will disable client’s salary and any inputs having to do with client’s contributions to retirement accounts.
  4. You may enter client’s Life Expectancy or click on the Table button to view average life expectancy table.
  5. Make sure to specify Client’s citizenship status as it will be a factor in Estate Planner calculations.
  6. Click on the Edit Beneficiaries button to enter children information as well as information on any other beneficiaries. Changes to this list will be applied to the Beneficiaries choices available for each Asset in the program.

Client Annual Income Section


income.png

  1. Annual Salary Amount: represents current annual salary income before-taxes for client/spouse respectively. You may click Details to manually adjust salaries for future years, or enter an average. Current salary is assumed to end at retirement. Changing the salary using the Salary Details screen will automatically adjust the plan to limit contributions by available money from the future Salary. For example, if one of the spouses takes a sabbatical for 2 years, any planned retirement contributions during those years will be ignored by the Financial Model.
  2. Annual Salary Increase:Enter a percentage estimate of salary increases averaged over the client's career span.
  3. Assumed Inflation Rate:Enter estimation for average future inflation. The Table will provide more information. This figure will be used in several calculations regarding future spending and social security benefits.

When you're done with this page, choose the Assets and Liabilities tab, or click next to proceed to the Assets and Liabilities screen.

The Assets & Liabilities tab of the Client Data worksheet contains two sections that allow user entering all the assets and liabilities data for the plan. Each row in those lists has an “Edit” and “Delete” buttons on the right hand side. Clicking Edit will display the Asset/Liability detailed popup page. Delete will ask for a confirmation and allow you to delete the asset from the plan.

edit_or_delete_assets.png


Assets are categorized in the list on the left and include Investment Assets, Insurance Policies, and Other Assets (Real estate, Personal Property, Businesses, etc.). All liabilities associated and not associated with assets will appear in the table on the right. You may add a liability by selecting Liability type from the drop-down list at the bottom of the page and clicking Add button. Alternatively, you may add any Asset by selecting its type and clicking Add as well.

adding_accounts.png


When adding an Other Asset (Real estate, Personal Property, Businesses, etc.) you may associate a liability with the asset by specifying it in the details screen. Once the asset is added, it will appear under appropriate category in the Asset List on the left. At the same time a Liability associated with the asset will appear in the Liabilities list on the right.

asset_details.png


Net worth Summary is shown in a form of the pie chart at the bottom of the screen. You may also review analyses based on Morningstar data of the entire Household portfolio by clicking on the Investment Holdings Analysis button.

investment_holding_analysis.png


Finance Logix allows altering the order in which assets are depleted to cover expenses and goals. By default, the program first depletes all taxable assets, then tax-free assets and then tax-deferred assets. This order can be modified by clicking on Withdrawal Order button and specifying a custom assets depletion strategy in the Withdraw Order details screen.

withdrawal_order.png


Goals and Cash Flows tab allows for two different user calculation modes based on the data already collected. In goal based planning mode the program assumes that any annual cash inflows that are not contributed to accounts are spent in the current year. In cash flow mode the user can explicitly specify all inflows and outflows. The surplus is automatically saved in a taxable account.

2mode.png


Cash flow mode calculation provides a cash flow statement summary which includes living expenses and incomes.

Goal Mode

Retirement Income Goal can be calculated as a percentage of current income or expressed as a dollar value. It represents desired annual income (pre-tax) the client would like to receive during their retirement years. Income from your estate is swapped to the default saving account with calculation of due interest.

goalmode.png

Cash Flow Mode

When switching to the Cash Flow mode, a high level Cash Flow summary is displayed showing all client Inflows, Outflows, Annual Savings as well as disposable income as money Available for Living Expenses. Be sure to specify 1) Pre and 2) Post Retirement living expenses under Living Expenses/Incomes section to the right. This will automatically recalculate Cash Flow summary numbers on the left based on entered current living expenses.

pre_and_post_retirement.png

Entering a Capital Preservation amount will modify calculations such that this Capital Preservation amount of money is preserved for heirs and available at the end of the planning horizon. This is also known as a Legacy.

capital_preservation.png


Clicking Other Expenses button allows you to enter additional foreseen expenses in the pop up edit screen which is then calculated as part of the distribution schedule. Click the edit button on the right hand side of the Other Expenses popup screen to enter detailed data regarding the expense.

other_expenses.png


You may specify additional lump sum or continuous current or future income by clicking on Other Income button. Any anticipated trust income, inheritance or any other future income can be entered using the Other Income popup screen. Adding Other Income for the current year will be reflected in the Cash Flow summary.

other_income.png

In case assets allocated towards College Education in the Education Module are not sufficient to cover all the tuition and other expenses, you may setup the program to automatically withdraw money from other non-education specific accounts to cover this education shortfall. This is achieved by selecting Yes for the option to Include Education Shortfall.

education_shortfall.png

Retirement Benefits

Social Security Benefits are calculated for the user using Social Security income tables. Click on the Details tab to make any adjustments manually. Computer Estimate mode does not allow Annual Benefits to be adjusted. To make manual adjustments to benefits, select the No option. Benefits start age can be adjusted using manual age entry or by utilizing the drop down box and selecting desired age options. Manual adjustments on Social Security subject to Federal taxes can also be adjusted in the Social Security detail screen.

sspension.png

Income Taxes

The program is using average tax rate assumptions for federal and state taxes. Pre-Retirement Federal and State Tax rate is applied from current year until the year one of the spouses retires. After that retirement year, the program will apply Post Retirement Tax: rates for Federal and State taxes. Clicking Details button next to the fields will bring up a Tax Calculator which will help determining the average federal and state tax rates.

incometax.png

Have more questions? Submit a request

Comments