I have often referred to Keith Betty’s Preferred Share Yield Calculator – there is a permanent link in the right hand panel under “On-Line Resources”.
I have slightly modified this spreadsheet so that it will calculate yields that reset to a different rate after a given date; you may download this spreadsheet by clicking here.
[...] Yield Calculator [...]