Scenarios
Scenario 1 - How much can I leave to my kids or to charity?
This scenario assumes you want to maximize the estate you give to your children or leave to charity.
Set the Age at Death for both spouses to 85 (or your typical life expectancy)
Optionally, to access the equity in your principal residence, setup one or two Downsize Events or consider a Reverse Mortgage.
Run the Estate optimizer.
The optimizer experiments with your retirement fund (RRSP/RRIF, LIRA/LIF) contribution and withdrawal rates, CPP and OAS start ages in an attempt to maximize your Estate in the Final Year. Try changing the CPP and OAS start ages manually to see if you can improve the solution.
If your Net Estate Value is negative in the Final Year it means that your plan is underfunded. Reduce your Annual Budget and/or Charitable Donations or increase your Retirement Age.
Scenario 2 - When can I retire?
This scenario assumes you want to know how early you can retire without running out of money.
Set the Age at Death for both spouses to 100 (or your maximum life expectancy). If you are younger than 50, the Final Year will max out at 50 years from now.
Optionally, to access the equity in your principal residence, setup one or two Downsize Events or consider a Reverse Mortgage.
Run the Retirement Age(s) optimizer.
The optimizer maximizes your Estate, then decreases (or increases) your Retirement Age until your Account Balances approach zero in the Final Year. If you have a spouse, their Retirement Age is also adjusted. If the optimizer has changed your Retirement Age(s) significantly, you may be asked to re-run the optimizer to obtain a better result.
Scenario 3 - How much can I spend without running out of money?
This scenario assumes you want to spend your last dollar on the day you die.
Set the Age at Death for both spouses to 100 (or your maximum life expectancy). If you are younger than 50, the Final Year will max out at 50 years from now.
Optionally, to access the equity in your principal residence, setup one or two Downsize Events or consider a Reverse Mortgage.
Run the Budget optimizer.
The optimizer maximizes your Estate, then increases (or decreases) your Annual Budget until your Account Balances approach zero in the Final Year. If the optimizer has changed your Annual Budget significantly, you may be asked to re-run the optimizer to obtain a better result.
Scenario 4 - How much can I give without running out of money?
This scenario assumes you want to give as much as possible to charitable causes during your lifetime without running out of money.
Set the Age at Death for both spouses to 100 (or your maximum life expectancy). If you are younger than 50, the Final Year will max out at 50 years from now.
Optionally, to access the equity in your principal residence, setup one or two Downsize Events or consider a Reverse Mortgage.
Run the Donations optimizer.
The optimizer maximizes your Estate, then increases (or decreases) your Charitable Donations Percentage until your Account Balances approach zero in the Final Year. If the optimizer has changed your Charitable Donations Percentage significantly, you may be asked to re-run the optimizer to obtain a better result.
A personal note: chances are you are using this spreadsheet because you have done well financially. Even if you don't want to be as radical as this scenario proposes, be generous with your money. Being generous is good for the heart, protects against greed and, with charitable tax incentives, is less expensive than you think.
Scenario 5 - Succession Planning
This scenario tests if a surviving spouse will have sufficient funds to fund their retirement if the other spouse passes away.
Set the Age at Death of the surviving spouse to 100 (or their maximum life expectancy)
Set the Age at Death of the deceased spouse to an earlier age
Check that Net Estate Value and Account Balances are positive in the Final Year (the life expectancy of the surviving spouse)
The wealth transfer can be seen in the Net Worth and Estate Value chart. If tax planning has been done correctly, assets should transfer to the surviving spouse tax free. In the Cashflow Sources chart, there is typically a drop in pension income due to the loss of the deceased's OAS, CPP changing to a CPP survivor benefit and the loss or reduction of the deceased's other pension plans if any.
Scenario 6 - Stress Test (Advanced Optimizer)
This scenario applies a cash adjustment to the first year of your projection by either adding or removing money until your Account Balances approach zero in the Final Year. It gives an indication of strength or weakness in your plan.
Set What to Optimize to Account Balances
Run Stress Test
The result is shown in the Current Year Adjustment field.
A positive amount means that your retirement is underfunded. Stress Test had to add money to your projection to make it work. A negative amount indicates strength in your projection. Given current assumptions, your projection can tolerate an unexpected expense or drop in investment values.
Remember to clear the Current Year Adjustment field when you are done.
Update your numbers and rerun your projections annually using Mark's latest spreadsheet. Also check out our Scenarios Video Tutorial.