Assiduous Reader KB writes in and says:<\/p>\n
I often have occasion to use your modified for resets spreadsheet on your site (ytc_resets).<\/p>\n
I always have to remember to only use 25 years when I want a \u201cLimit Maturity\u201d of 30 years.<\/p>\n
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.<\/p>\n
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\u2019s Excel 2007)<\/p><\/blockquote>\n
I’ve checked it out and everything is in order; so I have appropriated this development and it is now available for download<\/a>.<\/p>\n
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<\/a>.<\/p>\n
There’s a detailed numerical example for the use of this calculator in the post What is the Yield of HSE.PR.A?<\/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.<\/p>\n