Sunday, 11 December 2016

CPP Benefit Calculator Spreadsheet

CPP Calculation v1p2

This spreadsheet will estimate your CPP Benefit based on past pensionable earning and future earnings.  You can vary the age you retire and the age you elect to take CPP benefits.  Download the spreadsheet in excel format here and in Google Sheet format here.

Updated to v1.2 on December 11th, 2016
  • Added the over 65 dropout provision.
  • Updated the government YMPE values for 2016 and 2017.

Updated to v1.1 on April 23rd, 2015
  • The spreadsheet has been updated to fix some bugs and update some values that have changed.  


  1. And thanks for this. I actually started to make my own version for myself but then I got the bright idea to look if someone else had already done so. And yours is probably better than what I would've come up with anyway. Hah

  2. I appreciate doing this spreadsheet although it does not seem to work for our application.

    The spreadsheet inputting for MPE starts at year 1993 which is not early enough for me or my wife. (We are recently retired) Therefore it would seem the results we get are not accurate.
    I see the appropriate early ages off the right in another column. Is there something I am missing or is there a workaround?

    Thank you

    1. RBull,
      You can change the start year in the pensionable earnings report to make it earlier. It's the yellow cell in column D.