Cash Flow

To calculate annual cash inflows, NaviPlan:

1. Calculates the returns earned by each of your clients' assets. NaviPlan makes this calculation based on how you define the assumptions for each asset.
   Factors that may affect this calculation include:
   • the assets' assigned asset class weightings and return rates.
   • the return rates entered for each specific asset.
   • the valuation date for each account or holding.
2. Adds-up all itemized income from other sources (entered on the Cash Flow page) such as salaries.
3. Adds-up special income such as the tax-free proceeds of any new loans, redemptions from assets used to fund goals as well as the proceeds from insurance policies.
   Note: Special incomes are not entered on any one page—instead—NaviPlan makes this calculation based on information entered into several locations throughout the application.

To calculate annual cash outflows, NaviPlan:

1. Calculates the income tax due on asset returns, based on the income tax method selected.
   1. When the Detailed Tax Method is selected, NaviPlan applies bracketed federal taxes that consider an extensive number of deductions and credits.
   2. When the Average Tax Method is selected, NaviPlan uses average, short-term capital gains, long-term capital gains, or marginal tax rates (entered under Tax Rates on the Plan Management Section - Assumptions category - General page).
2. Deducts amounts such as registered contributions or tax-deductible interest from the clients' taxable income from other sources. Then—depending on the income tax method selected—applies the appropriate tax rate to calculate income tax liability generated by sources other than taxable portfolios.
   Note: Deductible amounts are calculated by NaviPlan based on information you enter throughout the plan, you need not enter them specifically.
3. Adds all of the clients' expenses for the year, including the following:
   1. Expenses entered on the Cash Flow page.
   2. Expenses associated with goals.
   3. Loan payments (calculated by NaviPlan).
   4. Investment expenses entered on the General page (Plan Management section - Assumptions category).
   5. Savings Strategies
   6. Insurance premiums
      Note: Expenses associated with goals are funded by specific, dedicated assets. All other expenses are paid from cash flow. If a non-registered asset is more than sufficient to fund a goal to which it is dedicated, the surplus is automatically allocated to retirement.

1. Allocates any cash surplus according to the clients' surplus savings strategies. Each strategy is fully-funded before any cash surplus is allocated to the next one entered. If these strategies do not use all the surplus cash the remainder is assumed to be spent and not carried forward to the next year.
2. Keeps track of any pre-retirement cash flow deficits.
3. During Retirement, redeems assets at the end of the year to cover the retirement goal. By default, funds are used in the following order:
   1. Any reinvestment of income from non-registered assets that would be made at year end.
   2. Non-registered assets in the following order:
      1. Ratio of adjusted adjusted cost base to market value as of the end of the year, from highest to lowest.
      2. Return Rate, from lowest to highest.
      3. Market value from smallest to largest.
      4. Asset category in the order of cash accounts, mutual funds, and investment portfolios.
      5. Alphabetically, based on the Description field.
   3. Registered accounts that are not paying out in the following order:
      1. Ratio of registered basis to market value as of the end of the year, from highest to lowest.
      2. Total return rate, from lowest to highest
      3. Alphabetically, based on the Description field.

• Benefit Formula: This method calculates Social Security benefits based on the annual income. NaviPlan will automatically calculate the value for you based on current Social Security ratios and current earnings.
• Estimate Benefit: This method uses benefit amounts directly entered from a Social Security Statement. All income is manually generated based on what is entered when the client starts earning Social Security.

• Surplus expenses are hidden expenses (such as unexpected car repairs, dry cleaning, and dining out) and can reduce the clients' surplus cash.
• These expenses never cause cash flow deficits because they only occur in years when clients have surplus cash.
• If expenses are currently understated in the plan, you can enter surplus expenses in the Surplus Expenses container on either the Cash Flow(Enter Financial Data section - Cash Flow category) page or on the Surplus (Enter Financial Data section - Strategies category) page.

1. From the Cash Flow page, click for Add Income and select an income type from the list.
2. If applicable, select the family member receiving the income, and then enter the annual income amount.
3. To enter additional details, click and enter any relevant information.

Follow these steps to model benefits from the Canada Pension Plan (CPP), Québec Pension Plan (QPP), and/or Old Age Security (OAS)in plan calculations. If benefits are included, you can enter the benefit amount as an eligible percentage or as an estimate in today's dollars.

1. From the CPP/QPP & OAS container, select the CPP/QPP & OAS link.

Monthly CPP/QPP Benefits

2.  From the Monthly CPP/QPP Benefits section, define the monthly benefit information for the client and/or co-client.
   Note: If a client should not be included in the calculations, under Monthly CPP/QPP Benefits, clear the relevant option.
   • Enter the amount to be used in calculations in the Benefit Amount (Eligible % or Est. in today's $) field.
   • Specify when the client and co-client will start receiving CPP/QPP benefits in the Benefit Start (Age or Retirement) field.
   • If you want CPP/QPP benefits to be shared between the client and co-client, select the Share CPP/QPP option.
     Note: This option is not available for single clients.
   • Select the benefit types that are to be included in the calculations (survivor, retirement, and disability).

Note: If death occurs prior to the anticipated start of receipt of pension, the calculation assumes a pension amount as if the deceased started receiving pension at age 65. If benefits have already started, then the amount of those benefits will be used.

Monthly OAS Benefits

3. From the Monthly OAS Benefits section, define the monthly benefit information for the client and/or co-client.
   • Enter the amount to be used in calculations in the Benefit Amount (Eligible % or Est. in today's $) field.
   • Enter a Benefit Start Age and a Benefit Start Month for each client; the Deferred Benefit Bonus and Monthly Benefit (in future $) fields update automatically.
     Note: If your client(s) wish to defer benefits and are eligible to do so, simply enter the appropriate start age and month and NaviPlan will calculate accordingly.
   • To have NaviPlan automatically determine the optimal Benefit Start Month, select Maximize Benefit.

Benefits Indexed At

4. If applicable, use the Infl and/or Add'l fields to index the benefit for inflation and/or any other indexation.

Voluntary Contributions to CPP/QPP

5. If applicable, select any clients aged 65 or older who are making voluntary CPP/QPP contributions from the Voluntary Contribution to CPP/QPP section.

In NaviPlan, you can estimate pension income using either the Estimate Benefit or the Benefit Formula method.
See the What are the Estimate Benefit and Benefit Formula methods? section earlier on this page for more information on these methods.

Entering an estimated benefit pension

1. From the Cash Flow page, click the for Add Pension and select Add Estimate Benefit....
2. Enter a unique name for the pension in the Description field.
3. Select the pension's owner from the Member menu.
4. Enter either the Benefits Start Age or the Benefits Start Date.
5. Enter the percentage of pension benefits to be paid to the surviving spouse when the pension owner dies.
   Note: NaviPlan does not calculate any discounts if this election is chosen.
6. If the pension is based on an income, select the options for the appropriate income(s) under Linked Incomes.
7. Enter either a percentage of the owner's final salary in the % of Final Salary field.
   OR
   Enter the estimated pension amount (in today's dollars) in the Est. Benefit Amount field.
8. Click Benefit Payout Options.
9. From the Method of Payout menu, select Life Income or Lump Sum.
   • If you select Lump Sum, you must also select a Transfer Payout to destination.
     • To transfer to an existing RRSP, select an existing RRSP from the list.
     • To transfer to a new RRSP, select New RRSP. The default name for the new RRSP is Transfer From <description of pension>.
     • To transfer to the clients' cash flow, select Cash Flow.
10. Enter the remaining details for the pension.
11. Go to the Future Benefits tab.
12. Review the displayed items. To override any of the data you see here, select Modify the Calculated Values and enter the benefit information you want to use.
    OR
    You can use the options in the Fill Values container to define a starting value indexed at a given rate over a period of years. To do this, make a selection from the Column to Fill menu, enter the criteria by which NaviPlan should calculate the amounts, and click Fill.
13. When you are satisfied with these options, click OK.

Entering a benefit formula pension

1. From the Cash Flow page, click the for Add Pension and select Add Benefit Formula....
2. Select the pension's owner from the Member menu.
3. Enter either the Benefits Start Age or the Benefits Start Date.
4. Enter the percentage of pension benefits to be paid to the surviving spouse when the pension owner dies. The Benefit Reduction for Survivor Coverage field becomes accessible, enter the percentage in this field.
5. If the pension is based on an income, select the options for the appropriate income(s) under Linked Incomes.
6. Enter information from the available pension documents.
   Note: If a pension is linked to a salary and the payout method is set to Life Income, the benefits that will be paid in the first year appear under Estimated Annual Benefit when Benefits Begin.
7. Click Benefit Payout Options.
8. From the Method of Payout menu, select Life Income or Lump Sum.
   • If you select Lump Sum, you must also select a Transfer Payout to destination.
     • To transfer to an existing RRSP, select an existing RRSP from the list.
     • To transfer to a new RRSP, select New RRSP. The default name for the new RRSP is Transfer From <description of pension>.
     • To transfer to the clients' cash flow, select Cash Flow.
9. Use the fields under Early Retirement to calculate how early retirement can affect the pension benefit.
10. Go to the Future Benefits tab.
11. Review the displayed items. To override any of the data you see here, select Modify the Calculated Values and enter the benefit information you want to use.
    OR
    You can use the options in the Fill Values container to define a starting value indexed at a given rate over a period of years. To do this, make a selection from the Column to Fill menu, enter the criteria by which NaviPlan should calculate the amounts, and click Fill.
12. When you are satisfied with these options, click OK.

• Use the following steps to model your clients' business and lifestyle expenses.
•   Do not use these steps to enter:
  • loan or mortgage payments.
  • insurance premiums.
  • property taxes.
  • savings contributions.
  • Expenses that apply only to retirement.
    Note: These should be entered on the Retirement page (Set Goals section - Retirement category).

Entering Expenses

1. From the Cash Flow page, select the for Add Expense and select an expense type from the menu.
2. Enter a Description and Amount for the newly-created expense.
3. To add additional details for the expense, click .
4. Enter expense details.
5. If you are entering an expense owned by the client or co-client and you expect the expense to continue for the survivor after the owner dies, select the Transfer to Survivor option.
6. If you are entering a Fixed Expense, select the Fixed Expense option. If this option is cleared, NaviPlan will treat the expense as discretionary.
   Note: Fixed Expenses are expenses that cannot be readily changed or eliminated by the clients (e.g. utility bills or rent payments). Fixed Expenses are used in the calculation of emergency fund goals and in determining scenario goal coverage.
7. If the End Date for the expense is later than the date of retirement for either client, the expense will also appear on the Retirement page (Set Goals section - Retirement category).
8. If you would like NaviPlan to automatically redeem from assets to cover any cash flow deficits caused by this expense during pre-retirement, select the Cover any pre-retirement deficits cause by this expense option.
9. When you are satisfied with these options, click OK.

• While the clients' plan may project a surplus, these projected surpluses often do not materialize because the clients underestimated their regular expenses or incurred unexpected expenses (e.g. car repairs).
  • If you believe that the plan's projected surplus is unrealistic, NaviPlan allows you to clear some or all of the surplus by creating a surplus expense strategy.
  • Even if you believe that a surplus exists, the projected surplus may be too large. You can use a surplus expense strategy to reduce the size of a projected surplus.

Entering a surplus expense strategy

1. From the Cash Flow page, click Add Surplus Expense.
2. Enter a Description, a % of Surplus to reduce, as well as a Start Year and End Year for the surplus expense.
   
3. To modify the Owner of the surplus expense, click .
4. When you are satisfied with these options, click OK.

• Use this button to generate the Cash Flow standalone report. This report provides a summary of all incomes and expenses entered into the plan.