What's Supported?

The spreadsheet supports a wide variety of personal financial situations as described below. Contact us if there is something you would like to see in a future version.

• Life Events

  • Retirement

  • Death of a spouse (succession planning)

  • Downsizing (or upsizing) of your principal residence and/or budget

• Personal income taxes

  • Note: Mark's Spreadsheet is not intended to replace Income Tax Preparation software. Many of the less common and smaller income tax credits and deductions are not implemented. The income tax calculations are intended to be representative of what might be expected over the next 50 years.

  • All Canadian provinces and territories (including surtaxes and health taxes)

  • Credits and Deductions

    • Basic Personal Amount

    • Spousal Amount

    • Age Amount

      • SK Senior Supplementary Amount

    • Pension Amount

    • Employment Credit

    • Amounts Transferred from Spouse

      • Basic Personal Amount

      • Age Amount

      • Pension Income Amount

      • CPP Amount

      • EI Amount

      • Employment Amount

    • NT and NU Cost of Living Credit

    • QC deduction for workers, QPIP 

    • Charitable Donation Credit, Expired Donations

    • Eligible and Ineligible Dividend Tax Credits

    • Capital Gains

      • Includes federal changes to the capital gains inclusion rate as of June 25, 2024

  • Tax Strategies

    • RRSP Contributions: fixed, cost of living, smooth taxes, as available, hybrid, spousal contributions (avoids income attribution)

    • RRSP Withdrawals: fixed, cost of living, smooth taxes, RRIF minimum, as needed, last resort, hybrid, use spouse's age for RRIF

    • Pension splitting

    • CPP/QPP sharing

• Employment Income and Deductions

  • Salary and bonus

  • CPP/QPP and EI

  • QPIP

  • Other deductions manually entered

• Self-employment Income

  • CPP/QPP

  • QC QPIP

  • QC Health Services Fund

• Pensions and Benefits

  • CPP/QPP

  • OAS (includes OAS prorating and OAS clawback)

  • Defined Benefit

  • Group RRSP

  • Other pensions manually entered

• Other Income

  • Other (fully taxable)

  • Capital gains

  • Eligible and ineligible dividends

  • Non-taxable income

• Accounts

  • Savings

  • Non-registered (includes adjusted cost base)

  • TFSA

  • RRSP/RRIF

  • LIRA/LIF

  • Overdraft

• Real Estate

  • Principal Residence

    • Mortgage

    • Reverse mortgage

    • Two residence and/or budget downsize (upsize) events

  • Plus up to three other income or non-income generating properties

• Other Assets

  • Other non-taxable manually entered

  • Other taxable manually entered (includes adjusted cost base)

• Other Liabilities

  • Up to three consumer loans

  • Other loans and payments manually entered

• Net Worth and Estate Value

• Life Insurance

  • Individual and joint cash value and death benefit

  • First to die and last to die

• Inflation

  • Fixed inflation rate

  • User-overrides for general inflation and real estate inflation