I have often referred to Keith Betty’s Preferred Share Yield Calculator [Link updated 2023-10-17 … JH] – 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.
Update, 2015-2-3: There’s a detailed numerical example for the use of this calculator in the post What is the Yield of HSE.PR.A?.
Update, 2015-3-26: There’s an updated version with a better layout and a 30-year maximum term (compared to the old 25-year maximum) described in the post Yield Calculator for Resets: New and Improved!.
Update, 2023-9-27: A new update has added the calculated yield compounded semi-annually, for comparability to bonds.
[…] Yield Calculator […]
[…] from Malachite Aggressive Preferred Fund with a client, and as part of that referred him to the Yield Calculator for Resets so he could see for himself why the projected income from the fund was so much higher than the […]
James, the link to Keith’s calculator doesn’t work and hasn’t worked for quite some number of years.
The tool is available at https://www.shakesprimer.com/ytc.xls so perhaps you can update the link in the post.
FWIW, I downloaded James’ latest link and it worked if I used Open Office (not Libre Office) to open the app.
James, the link to Keith’s calculator doesn’t work and hasn’t worked for quite some number of years.
I have updated the link in the post to the copy that’s on my site. The link in the right-hand navigation panel was fine.
Thanks for telling me!
I downloaded James’ latest link and it worked if I used Open Office (not Libre Office) to open the app.
I only use MS-Excel, so won’t even notice problems with the off-brand packages. Thanks for the tip; it will help those who get confused!