{"id":391425,"date":"2017-05-20T12:36:44","date_gmt":"2017-05-20T12:36:44","guid":{"rendered":"https:\/\/ghana-mma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/"},"modified":"2017-05-20T12:36:44","modified_gmt":"2017-05-20T12:36:44","slug":"appreciating-investment-valuation-models-v","status":"publish","type":"post","link":"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/","title":{"rendered":"Appreciating Investment Valuation Models (v)"},"content":{"rendered":"<p><\/p>\n<div id=\"\">\n<p><strong>Coupon payments\u00a0in bond transactions<\/strong><\/p>\n<p>&#13;<\/p>\n<p>Coupon payments to bondholders could be made by bond issuers in different ways, depending on the contractual agreement. For instance, coupons could be paid annually, semi-annually, quarterly or monthly. The last two options are rare in bond transactions, but they are possibilities. Each of these payment options is illustrated below.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>Annual Coupon Payments: For annual coupon payments, valuations in the preceding sections, including illustration of bond valuation, YTM, YTC provide ample explanation on its application. To illustrate, the value of a 10-year bond with a face value of GH\u00a21,000 and coupon rate of 10 per cent would be GH\u00a21,000. The Excel input for the computation is =PV(0.1,10,100,1000,0). The Excel output is 1,000.00. However, computation of semi-annual, quarterly and monthly coupon payments requires different valuation formulae and inputs.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>Semi-Annual Coupon Payments: The successful determination of the value of a bond with semi-annual coupon payments would hinge on the following steps.<\/p>\n<p>&#13;<\/p>\n<p>1. The number of years, denoted by N, must be multiplied by 2, that is, N x 2. In our Fiesta Corporation\u2019s example, the number of years was 10. For semi-annual payments, N = 10 years x 2 = 20.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>2. The annual coupon payments must be divided by 2, that is, I \u00f7 2. For Fiesta Corporation, the annual coupon payment amount was GH\u00a2100. For semi-annual payments, I = GH\u00a2100 \u00f7 2 = 50.<\/p>\n<p>&#13;<\/p>\n<p>3. The annual coupon rate must be divided by 2, that is, r \u00f7 2. For Fiesta Corporation, the annual coupon rate was 10 per cent. For semi-annual payments, r = 10% \u00f7 2 = 5.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>Mathematically, the value of bonds with semi-annual coupon payments can be derived as follows: \u00a0<\/p>\n<p>&#13;<\/p>\n<p>Bt=\u2211_(t=1)^2N\u2592\u3016(It\u00f72)\/(1+r\u00f72)t+F\/(1+r\u00f72)2N\u3017<\/p>\n<p>&#13;<\/p>\n<p>Supposing Fiesta Corporation\u2019s contractual agreement included semi-annual coupon payments to bondholders, the PV function in Excel could be used to compute the value of the bond.<\/p>\n<p>&#13;<\/p>\n<p>The final input would look like: =PV(0.05,20,50,1000,0). Click \u201cok.\u201d The output\u00a0= -1000.00.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>Using a financial calculator, the compounded value of the bond can be determined\u00a0as follows:<\/p>\n<p>&#13;<\/p>\n<p>N = 20; I\/YR = 0.05 (5%); PMT = 50; FV = 1000; and press the PV key to determine the bond\u2019s value.<\/p>\n<p>&#13;<\/p>\n<p>The output of 1000.00 is the bond\u2019s value with semi-annual coupon payments. The<\/p>\n<p>&#13;<\/p>\n<p>frequency of payments and compounding under the semi-annual valuation method<\/p>\n<p>&#13;<\/p>\n<p>(twice) is more than those under the annual valuation method (once). However, no difference is observed in the value (GH\u00a21000.00) of bonds between both methods.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>Quarterly Coupon Payments: To successfully determine the value of a bond with quarterly coupon payments, the following steps would be helpful.<\/p>\n<p>&#13;<\/p>\n<p>1. The number of years, denoted by N, must be multiplied by 4, that is, N x 4. In our Fiesta Corporation\u2019s illustration, the number of years was 10. For quarterly payments, N = 10 years x 4 = 40.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>2. The annual coupon payments must be divided by 4, that is, I \u00f7 4. In our Fiesta Corporation\u2019s example, the annual coupon payment amount was GH\u00a2100. For quarterly payments, I = GH\u00a2100 \u00f7 4 = 25.<\/p>\n<p>&#13;<\/p>\n<p>3. The annual coupon rate must be divided by 4, that is, r \u00f7 4. The annual coupon rate in Fiesta Corporation\u2019s illustration was 10%. For quarterly payments, r = 10% \u00f7 4 = 2.5.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>As noted earlier, quarterly bond payments are rare. However, it is essential to acquaint ourselves with the computation to ease its application, should the need arise in future. The value of bonds with quarterly payments can be derived, mathematically, as follows: \u00a0<\/p>\n<p>&#13;<\/p>\n<p>Bt=\u2211_(t=1)^4N\u2592\u3016(It\u00f74)\/(1+r\u00f74)&#8221;t&#8221; +F\/(1+r\u00f74)4N\u3017<\/p>\n<p>&#13;<\/p>\n<p>Assume Fiesta Corporation\u2019s contractual agreement with bondholders included a provision for quarterly coupon payments. The PV function in Excel could be used to compute the value of the bond.<\/p>\n<p>&#13;<\/p>\n<p>The final input would look like: =PV(0.025,40,25,1000,0). Click \u201cok.\u201d The output = -1000.00.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>With the aid of a financial calculator, the value of the bond (compounded) can be computed as follows:<\/p>\n<p>&#13;<\/p>\n<p>N = 40; I\/YR = 0.025 (2.5%); PMT = 25; FV = 1000; and press the PV key to compute the bond\u2019s value.<\/p>\n<p>&#13;<\/p>\n<p>In the financial calculator, the value of I\/YR is entered as 0.025, not 2.5%; the percentage (2.5%) is converted into decimal (0.025) before the application. The output, 1000.00, depicts the bond\u2019s value with quarterly coupon payments. Using the quarterly valuation method, the value (1000.00) of bond derived is not different from the values obtained from the annual (1000.00) and semi-annual (1000.00) valuation methods. We observe frequency of payments and compounding did not add more significant value to the quarterly payments than to the annual and semi-annual payments. It is worth emphasising the frequency of payments and compounding under the quarterly valuation method (four times) is more than those under the annual (once) and semi-annual (twice) valuation methods. \u00a0<\/p>\n<p>&#13;<\/p>\n<p>Monthly Coupon Payments: The following steps are essential to successful determination of the value of a given bond with monthly coupon payments.<\/p>\n<p>&#13;<\/p>\n<p>1. The number of years, denoted by N, must be multiplied by 12, that is, N x 12. In Fiesta Corporation\u2019s illustration, the number of years was 10. For monthly payments, N = 10 years x 12 = 120.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>2. The annual coupon payments must be divided by 12, that is, I \u00f7 12. For Fiesta Corporation, the annual coupon payment amount was GH\u00a2100. For monthly payments, I = GH\u00a2100 \u00f7 12 = 8.33.<\/p>\n<p>&#13;<\/p>\n<p>3. The annual coupon rate must be divided by 12, that is, r \u00f7 12. The annual coupon rate in Fiesta Corporation\u2019s illustration was 10 per cent. For monthly payments, r = 10% \u00f7 12 = 0.83.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>It is observed that the bond\u2019s value (1,002.27), when determined using the monthly valuation method is high, relative to the value (1,000.00) derived from the annual, semi-annual and quarterly valuation methods.<\/p>\n<p>&#13;<\/p>\n<p>Ebenezer M. Ashley (PhD)<\/p>\n<p>&#13;<\/p>\n<p>Lead Consultant\/CEO<\/p>\n<p>&#13;<\/p>\n<p>Eben Consultancy<\/p>\n<p>&#13;<\/p>\n<p>Fellow Chartered Economist &amp;\u00a0<\/p>\n<p>&#13;<\/p>\n<p>Council Member, ICEG<\/p>\n<p>&#13;<\/p>\n<p>Email: [email\u00a0protected]<\/p>\n<p>&#13;<\/p>\n<p>Website: www.ebenezerashley.com<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>As stated earlier, monthly bond payments are rare. However, it is essential to acquaint ourselves with the computation to ease its application in future bond transactions. The value of bonds with monthly coupon payments can be derived, mathematically, as follows: \u00a0<\/p>\n<p>&#13;<\/p>\n<p>Bt=\u2211_(t=1)^12N\u2592\u3016(It\u00f712)\/(1+r\u00f712)&#8221;t&#8221; +F\/(1+r\u00f712)12N\u3017<\/p>\n<p>&#13;<\/p>\n<p>Suppose Fiesta Corporation\u2019s contractual agreement with bondholders included a provision for monthly coupon payments. The PV function in Excel could be used to compute the value of the bond.<\/p>\n<p>&#13;<\/p>\n<p>The final input would look like: =PV(0.0083,120,8.33,1000,0). Click \u201cok.\u201d The output = -1002.27.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>Using a financial calculator, the value of the bond (compounded) can be computed as follows:<\/p>\n<p>&#13;<\/p>\n<p>N = 120; I\/YR = 0.0083 (0.83 per cent); PMT = 8.33; FV = 1000; and press the PV key to compute the bond\u2019s value.<\/p>\n<p>&#13;<\/p>\n<p>In using the financial calculator, the value of I\/YR is entered as 0.0083, not 0.83 per cent; the percentage (0.83 per cent) is converted into decimal (0.0083) before the application. The output of 1,002.27 represents the value of the bond with monthly coupon payments.\u00a0<\/p>\n<p>&#13;<\/p>\n<p>It is observed that the bond\u2019s value (1,002.27), when determined using the monthly valuation method is high, relative to the value (1,000.00) derived from the annual, semi-annual and quarterly valuation methods. It is worth noting the frequency of payments and compounding under the monthly valuation method (twelve times) is significantly more than those under the annual (once), semi-annual (twice) and quarterly (four times) valuation methods. This significant difference in payment and compounding periods may account for the higher bond value (1002.27) under the monthly valuation method than the bond value (1,000.00) derived from the annual, semi-annual and quarterly valuation methods.<\/p>\n<p>&#13;<\/p>\n<p>\u00a0 \u00a0\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\u00a0<\/p>\n<p>&#13;<\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t\t              <!-- new position --><br \/>\n          <!-- new position end -->\n\t\t\t<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Coupon payments\u00a0in bond transactions &#13; Coupon payments to bondholders could be made by bond issuers in different ways, depending on the contractual agreement. For instance, coupons could be paid annually, semi-annually, quarterly or monthly. The last two options are rare in bond transactions, but they are possibilities. Each of these payment options is illustrated below.\u00a0 [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-391425","post","type-post","status-publish","format-standard","category-business"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Appreciating Investment Valuation Models (v) - Ghanamma.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Appreciating Investment Valuation Models (v) - Ghanamma.com\" \/>\n<meta name=\"twitter:description\" content=\"Coupon payments\u00a0in bond transactions &#013; Coupon payments to bondholders could be made by bond issuers in different ways, depending on the contractual agreement. For instance, coupons could be paid annually, semi-annually, quarterly or monthly. The last two options are rare in bond transactions, but they are possibilities. Each of these payment options is illustrated below.\u00a0 [&hellip;]\" \/>\n<meta name=\"twitter:creator\" content=\"@ghanamma\" \/>\n<meta name=\"twitter:site\" content=\"@ghanamma\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/05\\\/20\\\/appreciating-investment-valuation-models-v\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/05\\\/20\\\/appreciating-investment-valuation-models-v\\\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"Appreciating Investment Valuation Models (v)\",\"datePublished\":\"2017-05-20T12:36:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/05\\\/20\\\/appreciating-investment-valuation-models-v\\\/\"},\"wordCount\":1145,\"commentCount\":0,\"articleSection\":[\"Business\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/05\\\/20\\\/appreciating-investment-valuation-models-v\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/05\\\/20\\\/appreciating-investment-valuation-models-v\\\/\",\"url\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/05\\\/20\\\/appreciating-investment-valuation-models-v\\\/\",\"name\":\"Appreciating Investment Valuation Models (v) - Ghanamma.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/#website\"},\"datePublished\":\"2017-05-20T12:36:44+00:00\",\"author\":{\"@id\":\"\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/05\\\/20\\\/appreciating-investment-valuation-models-v\\\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/#website\",\"url\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/\",\"name\":\"Ghanamma.com\",\"description\":\"News In Ghana - Latest Ghana News Headlines\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.ghanamma.com\\\/2017\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Appreciating Investment Valuation Models (v) - Ghanamma.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/","twitter_card":"summary_large_image","twitter_title":"Appreciating Investment Valuation Models (v) - Ghanamma.com","twitter_description":"Coupon payments\u00a0in bond transactions &#13; Coupon payments to bondholders could be made by bond issuers in different ways, depending on the contractual agreement. For instance, coupons could be paid annually, semi-annually, quarterly or monthly. The last two options are rare in bond transactions, but they are possibilities. Each of these payment options is illustrated below.\u00a0 [&hellip;]","twitter_creator":"@ghanamma","twitter_site":"@ghanamma","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/#article","isPartOf":{"@id":"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/"},"author":{"name":"","@id":""},"headline":"Appreciating Investment Valuation Models (v)","datePublished":"2017-05-20T12:36:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/"},"wordCount":1145,"commentCount":0,"articleSection":["Business"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/","url":"https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/","name":"Appreciating Investment Valuation Models (v) - Ghanamma.com","isPartOf":{"@id":"https:\/\/www.ghanamma.com\/2017\/#website"},"datePublished":"2017-05-20T12:36:44+00:00","author":{"@id":""},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ghanamma.com\/2017\/05\/20\/appreciating-investment-valuation-models-v\/"]}]},{"@type":"WebSite","@id":"https:\/\/www.ghanamma.com\/2017\/#website","url":"https:\/\/www.ghanamma.com\/2017\/","name":"Ghanamma.com","description":"News In Ghana - Latest Ghana News Headlines","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ghanamma.com\/2017\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/posts\/391425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/comments?post=391425"}],"version-history":[{"count":0,"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/posts\/391425\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/media?parent=391425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/categories?post=391425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ghanamma.com\/2017\/wp-json\/wp\/v2\/tags?post=391425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}