Retirement Planning

Navigating requirement requires a goal and a plan.


Examples of goals include:


In retirement there are things outside your control, things over which you have some control and things you can control. Retirement planning focuses on the things you can control while allowing for the possibility of things you cannot control.

Things outside your control

Things over which you have some control

Things you can control

Excess Cash

In retirement, an individual or couple may have access to funds in savings, investment and TFSA accounts along with registered retirement accounts like RRSP/RRIFs, LIRA/LIFs and access to various pensions such as CPP or QPP, OAS, Defined Benefit and Defined Contribution plans. We define excess cash as any accessible (i.e. not locked in) funds not required for living expenses in any given year. Retirees have some freedom to choose where to keep and how to use excess cash including using those funds to delay the age at which they take pensions. Each of these decisions have financial and tax implications which further complicate the decision making process. Here is where Mark's Spreadsheet comes in.

The Spreadsheet

Mark's Spreadsheet is designed to help you make decisions about things you can control and to model things you can't control. It generates projections for income and expenses including income taxes, account withdrawals, deposits and balances and net worth and estate value based on data you enter. The Dashboard worksheet lets you try different scenarios and optimizers are available to help when faced with multiple choices like:


Mark's Spreadsheet has some built-in assumptions which you should be aware of: