{"id":4636,"date":"2008-12-22T21:56:36","date_gmt":"2008-12-23T01:56:36","guid":{"rendered":"http:\/\/www.prefblog.com\/?p=4636"},"modified":"2008-12-22T21:56:36","modified_gmt":"2008-12-23T01:56:36","slug":"what-is-the-ytw-of-ryprn","status":"publish","type":"post","link":"https:\/\/prefblog.com\/?p=4636","title":{"rendered":"What is the YTW of RY.PR.N? Win a PrefLetter!"},"content":{"rendered":"<p>I will admit that sometimes I look at the analysis generated by HIMIPref&trade; and blink. The assumptions and procedures and approximations used in the course of the analysis can sometimes work together in unexpected ways &#8230; so the results need to be reviewed in order to determine whether<\/p>\n<ul>\n<li>the programme is really doing what I wanted it to do, and\n<li>whether I still want the programme to do what I previously wanted it to do<\/ul>\n<p>Such are the joys of quantitative analysis, when you can spend a month trying to figure out the analysis of one instrument on a date from ten years back!<\/p>\n<p>This time, however, it&#8217;s today&#8217;s analysis of RY.PR.N: it closed today at 26.00-10, 28&#215;1, after trading 29,390 shares in a range of 26.00-10.<\/p>\n<p>And yet despite the $26.00 price, HIMIPref&trade; shows the pre-tax bid-YTW scenario as being the limitMaturity &#8211; that is, the dummy maturity thirty-years hence which is used as a substite for &#8220;forever&#8221;.<\/p>\n<p>First, some facts: the issue <a href=\"http:\/\/www.prefblog.com\/?p=4395\">closed on December 9<\/a> and is a fixed reset with the terms 6.25%+350. The analysis assumes that 5-year Canadas will now and forever yield 1.83%, so the rate is presumed to be reset to 5.33% at the first (and all subsequent) reset dates.<\/p>\n<p>HIMIPref&trade; calculates the yield to first call of 5.4130% and yield-to-limit of 5.2913%. I have uploaded the cash-flow reports for the <a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2008\/12\/ryprn_cf5.pdf'>five year<\/a> and <a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2008\/12\/ryprn_cf30.pdf'>30-year<\/a> maturities. The YTW is the worst yield, 5.2913%, and the YTW scenario is the 30-year maturity.<\/p>\n<p>There cannot be much argument about the yield calculation for the five year maturity; everything is known, so it&#8217;s all perfectly standard. However, the thirty year maturity is simply an analytical placeholder for &#8220;forever&#8221; and the maturity value is not known. As you can see from the reports, HIMIPref&trade; estimates a price of $23.44 for the 30-year case.<\/p>\n<p>Why $23.44? For that we have to look at the HIMIPref&trade; calculation of costYield &#8230; I have uploaded the <a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2008\/12\/ryprn_cf_cost.pdf'>relevant cash flow analysis<\/a>. Readers will note the cash flow entry dated 2014-3-26, for -1.73 (future value) discounted to -1.34 (present value). This is the estimate of what the issuer&#8217;s call option is costing the holder; the implication is that if this option didn&#8217;t exist, we&#8217;d be willing to pay $1.34 (present value) more for the security.<\/p>\n<p>The value of the option is calculated using a time-influenced distribution of possible prices centred on the current price. As shown by the <a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2008\/12\/ryprn_option.pdf'>Option Cash Flow Effect Analysis<\/a>, it is currently assumed that there is a 53% chance of the option being exercised. Slicing the price distribution into two parts on that date, it is calculated that the average unconstrained price in exercise scenarios is 28.24; the average unconstrained price in non-exercise scenarios is 23.44. Voila! An estimated maturity price of $23.44.<\/p>\n<p>I&#8217;ve also uploaded <a href='http:\/\/www.prefblog.com\/wp-content\/uploads\/2008\/12\/ryprn_adj.xls'>an Excel spreadsheet<\/a> where I did a little fooling around with the reports. Raw data is in cells a1:e128. I&#8217;ve converted the semi-annual yield back into annual in cells c129:c130. The cash-flows with some decimals put back in are in cells g1:g122. My check on the arithmetic is in cells i1:j122 and sum to a present value of $26.03805; I&#8217;m assuming that the extra 3.805 cents is due to rounding differences of dates and days-in-year approximations. I used cells l1:n124 to play around with the yield-effect of different maturity values, and summarized my playing in cells l127:n130, which I will reproduce here:<\/p>\n<div align=\"center\">\n<table border=\"1\">\n<tr>\n<td colspan=\"2\">RY.PR.N<br \/>Effect of Maturity Value<br \/>on Calculated Yield<\/td>\n<\/tr>\n<tr>\n<td>Maturity Value<\/td>\n<td>Semi-Annual Yield<\/td>\n<\/tr>\n<tr>\n<td>25.00<\/td>\n<td>5.38%<\/td>\n<\/tr>\n<tr>\n<td>26.00<\/td>\n<td>5.44%<\/td>\n<\/tr>\n<tr>\n<td>23.44<\/td>\n<td>5.290%<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<p>It&#8217;s not all that sensitive, but the rate with a 26.00 end-value is slightly in excess of the 5-year rate, implying that if we rely on a 26.00 end-value then the 5-year yield is the YTW &#8230; as would be expected.<\/p>\n<p>But I claim that you cannot count on a 26.00 end-value. I claim that if the unconstrained market price is 26.00 on a call date, then the issuer will call the issue at 25.00 instead. All you can count on at the end of eternity (which is 30-years off) is that fraction of the price distribution that escaped the calls &#8230; and that has an average value of 23.44.<\/p>\n<p>And hence, the YTW scenario for a 26.00 issue callable at 25.00 in five years is &#8230; the limit maturity. This doesn&#8217;t happen for normal &#8220;straight&#8221; perpetuals: if the issue had an expected cash flow stream of 6.25% for the entire 30-year period, rather than 6.25% for five years and 5.33% thereafter, the five-year call would have a lower yield and hence be the YTW scenario.<\/p>\n<p>And, just for fun, let&#8217;s have a contest! Presuming an end-value of 23.44, what post-reset 5-Year Canada yield (and hence, what dividend rate on RY.PR.N) do we need to bump the yield up to the point where the 5-year call becomes the Yield-To-Worst scenario? First correct answer wins a copy of the January edition of PrefLetter.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I will admit that sometimes I look at the analysis generated by HIMIPref&trade; and blink. The assumptions and procedures and approximations used in the course of the analysis can sometimes work together in unexpected ways &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,18],"tags":[],"class_list":["post-4636","post","type-post","status-publish","format-standard","hentry","category-issue-comments","category-prefletter"],"_links":{"self":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/4636","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=4636"}],"version-history":[{"count":0,"href":"https:\/\/prefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/4636\/revisions"}],"wp:attachment":[{"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}