Rifleman62 said:I posted this previously.
My buy back Excel spreadsheet shows contributions. Then interest is added. For the Part I.1, the interest added is 63% of the total.
RLD do you have your buy back spreadsheet with headings A to W? I think DND paid William Mericer a million dollars to develop a formula to make Reservists pay.
I had the Treasury Board President sitting at my dinning room table. He was incredulous. He passed it on the McKay. I got the usual letter.
I assume you are referring to the Excel calculator that was published on the pension website back in 2007 and then removed. If so then the latest update I did back in 2009 showed about 64% of the total part I.1 cost was interest. While I believe this is roughfully accurate (+/- 2 or 3%) there were errors in the calculator, for example it did not treat mid year interest calculations correctly if the election date was after 1 Jul in a given year, so I have not used it with the most recent info I have. The reason I believe this is roughfully accurate is that the corrected online calculator provided a final result that was close to what I got with the spreadsheet using the same input although of course it did not provide any details.