projection.xls is a spreadsheet to calculate the effect of early/deferred cpp/oas.
The spreadsheet assumes an arbitrary age 59 simply for comparison and covers the years from 2016 through 2030 calculating how different choices of early/deferred cpp/oas affect your income [cf. if you qualified for $1000/month cpp @ age 65 you could receive a cost of living indexed early cpp of $640/month @ age 60 to a cost of living indexed deferred cpp of $1360/month @ age 70 for the rest of your life].
The main variables to see effect of early/deferred cpp/oas
age D7 is fixed @ 59 [if you are familiar with spreadsheets to change from
age 59 to, for example, age 55 add "4" to the year in G2 through
T2 {so change 2017 to 2021...} and to the index power in G4 through T4
{so change (d4)^1 to (d4)^5...}]
"inflation index" D4, if replaced express the % index as 1 +
.xxx [where xxx is a decimal equivalent of the annual inflation %]
"interest rate" D5, if replaced express the rate as 1 + .xxx
[where xxx is a decimal interest rate]
"# years early/deferred cpp" D8, any integer value from 5 to
-5 years that you want early/deferred cpp
"# years early/deferred oas" D9, any integer value from 5 to
-5 years that you want early/deferred oas
enter income/expense column E and savings E51
totals are calculated [addition depends on years early/deferred cpp/oas]
don't change formulae of columns/rows F12 through T53
don't delete column F (used in calculation of most other columns]
The spreadsheet is ballpark of what things might look like year by year.
useful links
http://www.esdc.gc.ca/en/msca/index.page
http://www.esdc.gc.ca/en/cpp/oas/payments/tab1_43.page#above
http://www.rbcroyalbank.com/mortgages/mpcrds/index.html?buyerType=first-time-home-buyer&purchasePrice=233000&downPayment=50000&postalCode=k7v3z7&mortgageTiming=zero_to_six&&