Assiduous Reader KB writes in and says:
I often have occasion to use your modified for resets spreadsheet on your site (ytc_resets).
I always have to remember to only use 25 years when I want a “Limit Maturity” of 30 years.
Anyway, it bothered me enough times that I modified it. I also added a couple fields for entering reset spread and GoC 5 year rate instead of having to modify the dividend formula each time.
Might be useful in place of the one you initially modified, or not. You can check it out, modify it, or throw it out. (it’s Excel 2007)
I’ve checked it out and everything is in order; so I have appropriated this development and it is now available for download.
Note that the new version is a .xlsx file and there may still be a few doddering old fogeys out there who haven’t upgraded since the last geological era, so the Old .xls version is still available.
There’s a detailed numerical example for the use of this calculator in the post What is the Yield of HSE.PR.A?. This explanation is based on the old version, but if you can’t figure out the layout difference then you don’t deserve to use nice things anyway.