Having solved for maximum lifestyle without contributing to TFSA, we can see in the Cash Flow chart that from age 60 to age 95 there are no lifestyle shortfalls. We can also see the income allocation between government benefits, RRIF minimum, and non-registered withdrawals.
If we review the Retirement Options chart, we can see all 4 retirement options are in perfect balance having been automatically solved by RazorPlan.
Now that we have determined the maximum lifestyle available according to our assumptions, we can choose to automatically re-balance Non-Registered assets to TFSA up to the maximum permitted each year. To do this, we will create a new scenario and set TFSA Auto Allocate from No to Yes.
The best way to see the results of maximizing TFSA contributions throughout retirement is to view the Retirement Options chart.
In Option #3 we can clearly see that the tax efficiency of maximizing contributions to TFSA have created a Risk Alpha of 0.24% (4.00% – 3.76%).
This means that Mary could spend $2,000 more each year as seen in Option #1, or spend up to $66,400 in a lump-sum at retirement, as seen in Option #4, and still have enough to meet her lifestyle goal.
How To Build with RazorPlan:
This case is assumed to have the following account level assumptions. To replicate this case as outlined below, be sure to update your Account Settings to match through Your Account. Additional steps may be required if you do not choose to set up your account this way.
- Set Stop Income At to Assumed Life Expectancy
- Set Pre-Retirement Cash Flow to On
Step 1 – Download and Open ‘Auto Allocate TFSA’ Razor Academy file
Select Razor Academy from the RazorPlan home screen. From there select “Auto Allocate TFSA” and click Download. The sample case will download to your RazorPlan account and automatically open.
Step 2 – Set Retirement Lifestyle to Zero
To calculate the maximum lifestyle in retirement, ensure the Monthly After-Tax Lifestyle is set to a value of $0.00 under the “Active Retirement” data column.
Step 3 – Solve for Retirement Lifestyle
With Retirement Lifestyle set to $0.00, click on the Chart icon to have RazorPlan automatically solve for a Lifestyle Goal that liquidates all investment assets at the plan life expectancy.
Step 4 – Create a New Scenario
Click the Scenario drop-down menu and select Copy Scenario. Name this new scenario “Maximize – TFSA”. Once created the new scenario will load.
Step 5 – Change TFSA ‘Auto Allocate’ to ‘Yes’
With the new scenario active, go to Data Entry Step 3: Personal Assets and under the TFSA tab, change the Auto Allocate value from No to Yes.
Step 6 – Recalculate the Scenario with the New Data
With TFSA Auto Allocate set to Yes, click on the Chart icon on the RazorPlan Toolbar to have RazorPlan re-calculate the analysis and take you to the Cash Flow chart. Next, select the Retirement Options chart to see the value (Alpha) added by the change made.
In this example, the simple recommendation to take full advantage of TFSA contributions throughout retirement, gives the client more options and greater income security.