{"id":6693,"date":"2009-05-28T23:19:54","date_gmt":"2009-05-29T03:19:54","guid":{"rendered":"http:\/\/www.prefblog.com\/?p=6693"},"modified":"2009-05-28T23:19:54","modified_gmt":"2009-05-29T03:19:54","slug":"yield-calculator-for-resets","status":"publish","type":"post","link":"https:\/\/prefblog.com\/?p=6693","title":{"rendered":"Yield Calculator for Resets"},"content":{"rendered":"<p>I have often referred to <a href=\"http:\/\/www.telusplanet.net\/public\/kbetty\/ytc.xls\">Keith Betty&#8217;s Preferred Share Yield Calculator<\/a> &#8211; there is a permanent link in the right hand panel under &#8220;On-Line Resources&#8221;.<\/p>\n<p>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 <a href=\"http:\/\/www.prefblog.com\/xls\/ytc_resets_150211.xls\">clicking here<\/a>.<\/p>\n<p><b>Update, 2015-2-3<\/b>: There&#8217;s a detailed numerical example for the use of this calculator in the post <a href=\"http:\/\/prefblog.com\/?p=27023\">What is the Yield of HSE.PR.A?<\/a>.<\/p>\n<p><b>Update, 2015-3-26<\/b>: There&#8217;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 <a href=\"http:\/\/prefblog.com\/?p=28403\">Yield Calculator for Resets: New and Improved!<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have often referred to Keith Betty&#8217;s Preferred Share Yield Calculator &#8211; there is a permanent link in the right hand panel under &#8220;On-Line Resources&#8221;. I have slightly modified this spreadsheet so that it will &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-6693","post","type-post","status-publish","format-standard","hentry","category-miscellaneous-news"],"_links":{"self":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/6693","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6693"}],"version-history":[{"count":0,"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/6693\/revisions"}],"wp:attachment":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}