Using the CFM Order column

This article describes how to change the default underlying cash flow management (CFM) logic for the order of contributions and withdrawals. 

The default underlying CFM logic is to automatically contribute to RRSPs first, then TFSAs, then Non-Registered assets.  Automatic withdrawals are made in reverse order.  Using the CFM Order column you can select different cash flow management strategies and even change them in the middle of your projections.

To enable this feature, select the blue gear icon in the Capital Assets column header on the Planning Page and click the checkbox to Show the CFM Order column for this scenario. To enable this feature for new scenarios that you create, select that checkbox as well.  Click Save.

A new column will appear on the  Planning Page called CFM Order. The default Contribution order is displayed in this column as R, T, N (Registered, TFSA, Non-Registered). The default Withdrawal order is displayed as the reverse, N, T, R (Non-Registered, TFSA, Registered).

To change the order, click either  R, T, N under Contributions or N, T, R under Withdrawals. In this example, we will change the contribution order to T, N, R and copy down for all years.

After running the scenario, the TFSA is the first account to be contributed to during the client's working years with the surplus spilling over to the Non-Registered account after the TFSA room has been filled.  The Non-Registered account is still the first account to be withdrawn from in the decumulation years because the CFM Order for Withdrawals has remained as N, T, R. If we would like to use a different Withdrawal order we can change that as well.

You can adjust the CFM Order throughout the projections if desired.  For example, if at retirement the withdrawal order was desired to be Non-Registered, TFSA, RRSP, simply edit the CFM Withdrawals column.

NOTES: 

  1. If there are multiple registered accounts of the same type, Snap will withdraw from them based on the CFM Method selected for the plan. The default is to deposit to or withdraw from accounts of the same type on a proportional basis (based on the value of the account).
  2. Minimum RRIF/LIF withdrawal amounts will always be enforced.  (Maximum LIF withdrawals will also be enforced).
  3. If the RRIF hasn't started yet or if there is no taxable income and withdrawals are required, Snap will withdraw from RRSP/RRIF up to the personal amount, provincial or federal, whichever is least.  This will occur before withdrawals from other asset types.
  4. When there is a spouse in the scenario, if you adjust the CFM Order for one spouse, this will be done for the other spouse as well. 
  5. When you disable this feature through the Capital Asset column header gear icon, the CFM Order will revert back to the default CFM order. (Contributions = R, T, N and Withdrawals = N, T, R).
  6. The Excel Export for the projections contains the CFM Order columns. The CFM order setting is not stated in the Report.

Still need help? Contact Us Contact Us