Rebase a Scenario in New Year

Scenarios can only be edited if they start in the current or next year. If your scenario starts in a previous year it must be rebased to the current year before you can make changes. Rebasing a scenario does not replace or delete the original scenario.

When you open a client's scenario with a Start Year before the current calendar year (for example in 2024 you open a scenario with the Start Year of 2023), the Run Scenario button will be replaced with the Rebase Scenario button at the top of the Planning page.

When you click the Rebase Scenario button the following dialogue box will appear.

Click Rebase.

Once the Rebase is complete, the new scenario that starts in the current year will be displayed and you can rename it.

Back to top

The existing scenario is copied and the Start Year is changed to the current year. End-of-year projected values from the previous year's scenario are automatically entered as the start-of-year values in the rebased scenario. You have a new, up-to-date scenario for your clients, created in minutes.

NOTE: If you are trying to rebase scenarios created more than one year in the past, please additionally review and update the RRSP and TFSA contribution room to make sure these values are current.

It is important to review the scenario as there will be areas automatically adjusted for you based on the inflation settings and updated new year financial and tax data. These areas include but aren't limited to income and expense amounts, asset values and costs, RESP grants, debt balances, government benefits, past contribution room, tax settings (e.g. additional amounts), charitable donations, etc.

Back to top

Case 1: If a client wasn't yet receiving government benefits in the original projections

• Snap will take the original CPP/QPP percent of maximum (at age 65) and in the rebased version, apply this percent of maximum to the new CPP/QPP maximum value for this individual to calculate the Annual Retirement Pension amount. The same calculation is performed for the rebased OAS Annual Pension amount.

Case 2: If a client was already receiving government benefits in the original projections

• Snap will use the original value for the CPP/QPP Annual Retirement Pension, and then index this amount based on the inflation rate for CPP/QPP in the scenario. The same calculation is performed for the rebased OAS Annual Pension amount.

Back to top

For illustration purposes, let's work with a scenario where the first year of the projections was last year.

Financial Assets

Here is the Planning page for the scenario that needs to be rebased, with asset columns displaying the end-of-the-year projected values under the Value column.

After clicking Rebase Scenario, a copy of the scenario that starts in the current year is created.

The original scenario will remain accessible as long as you don't manually delete it, and the new scenario will have the same name with the addition of (rebased) at the end of it.  

The rebase takes the end-of-year projected values from the original scenario and uses those as the starting point for income, assets, and debt. You can see these values under Scenario Setup -> Incomes, Assets, and Debts. Here are the Financial Assets in the rebased scenario and they match the projected values from last year's scenario.

You can update the values based on actual current-year data.

Base Expenses

The nominal dollar Base Expense value will remain constant between the original and rebased scenarios. In this example, in last year's scenario, the $54K of Base Expenses (in real dollars) in 2029 equalled $61,171 in nominal dollars. After rebasing the scenario, in 2029 the nominal dollar amount remains the same so that calculations can stay consistent. It is the real dollar Base Expense amounts that are automatically adjusted. You can change the real dollar amounts directly on the Planning page if you wish.

Debts

The starting Balance for the debts in the rebased version will come from the projected end-of-year debt balance in the original scenario. You can edit the Balance in the rebased version based on actual events from the past year.

Remember to review the entire scenario and update the inputs as necessary.

Back to top