CPP and QPP calculator

The CPP and QPP calculator is an easy-to use spreadsheet to estimate Canada Pension Plan (CPP) and Québec Pension Plan (QPP) pension amounts.

How to use
You must provide your birth year and month, your province (to select between CPP and QPP), and fill in your pensionable earnings record. The spreadsheet automatically estimates your CPP or QPP monthly pension at the selected start age. Start ages range from 60 to 70.

The Birth month, the Province, and the Start age are conveniently selected using a drop-down control.

The spreadsheet allows to evaluate the impact of retiring at various ages by entering anticipated future pensionable earnings between now and the start of pension payments.

The estimated pension amount is expressed in inflation-adjusted dollars (except when the start year is in the past).

Download location
The latest CPP-QPP spreadsheet (version 1.10) comes in three versions:

Google Docs (Sheets)
This version can be used online.

Read the following instructions before clicking on the link!
 * 1) Click on the link below.
 * 2) Sign into your Google account (if not already signed in).
 * 3) Make a copy of the file as follows: File -> Make a copy...
 * 4) The copy is yours to modify.
 * Here is the link: CPP-QPP.

Microsoft Office (Excel)

 * To download, click on: CPP-QPP.xlsx.

LibreOffice (Calc)

 * To download, click on: CPP-QPP.ods.

Limitations
The spreadsheet has some limitations:
 * It doesn't handle child rearing dropout provisions and post retirement benefits.
 * It doesn't handle the new CPP/QPP enhancements.
 * It doesn't work for people born before 1948.
 * It only implements current rules (without the new enhancements); it doesn't implement historical rules.
 * Start ages have an annual granularity. It isn't possible to select "age 60 and 3 months".

Support and Development
Support for this spreadsheet and discussions about further development are held in.