WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Risk Management Tutorials » Fixed Income Tutorials » Coupon Bond Formula

Coupon Bond Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Coupon Bond Formula?

The term “coupon bond” refers to bonds that pay coupons which is a nominal percentage of the par value or principal amount of the bond. The formula for calculation of the price of this bond basically uses the present value of the probable future cash flows in the form of coupon payments and the principal amount which is the amount received at maturity. The present value is computed by discounting the cash flow using yield to maturity.

Mathematically, it the price of a coupon bond is represented as follows,

Coupon Bond = ∑i=1n  [C/(1+YTM)i + P/(1+YTM)n]
Coupon Bond = C * [1-(1+YTM)-n/YTM + P/(1+YTM)n]

Coupon Bond Formula

where

  • C = Periodic coupon payment,
  • P = Par value of bond,
  • YTM = Yield to maturity
  • n = No. of periods till maturity

Calculation of the Coupon Bond (Step by Step)

The formula for coupon bond calculation can be done by using the following steps:

  • Step 1: Firstly, determine the par value of the bond issuance, and it is denoted by P.
  • Step 2: Next, determine the periodic coupon payment based on the coupon rate of the bond based, the frequency of the coupon payment, and the par value of the bond. The coupon payment is denoted by C, and it is calculated as C = Coupon rate * P / Frequency of coupon payment
  • Step 3: Next, determine the total number of periods till maturity by multiplying the frequency of the coupon payments during a year and the number of years till maturity. The number of periods till maturity is denoted by n, and it is calculated as, n = No. of years till maturity * Frequency of coupon payment
  • Step 4: Now, determine the yield to maturity on the basis of the current market return from an investment with a similar risk profile. The yield to maturity is denoted by YTM.
  • Step 5: Next, determine the present value of the first coupon, second coupon, and so on. Then, determine the present value of the par value of the bond.
  • Step 6: Finally, the formula for determination of the coupon bond calculation is done by adding the present value of all the coupon payments and the par value, as shown below.

Coupon Bond Formula 2

Examples

You can download this Coupon Bond Formula Excel Template here – Coupon Bond Formula Excel Template

Example #1

Let us take an example of bonds issued by company XYZ Ltd that pays coupons annually. The company plans to issue 5,000 such bonds, and each bond has a par value of $1,000 with a coupon rate of 7%, and it is to mature in 15 years. The effective yield to maturity is 9%. Determine the price of each bond and the money to be raised by XYZ Ltd through this bond issue.

Below is given data for the calculation of the coupon bond of XYZ Ltd.

Coupon Bond eg 1

The price of each bond is calculated using the below formula as,

Popular Course in this category
Sale
Fixed Income Course
4.7 (487 ratings)
9 Courses | 37+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Coupon Bond Formula2

Therefore, calculation of the Coupon Bond will be as follows,

Coupon Bond eg 1.1

So it will be –

Bond Price

= $838.79

Therefore, each bond will be priced at $838.79 and said to be traded at a discount (bond price lower than par value) because the coupon rate is lower than the YTM. XYZ Ltd will be able to raise $4,193,950 (= 5,000 * $838.79).

Example #2

Let us take an example of bonds issued by company ABC Ltd that pays semi-annual coupons. Each bond has a par value of $1,000 with a coupon rate of 8%, and it is to mature in 5 years. The effective yield to maturity is 7%. Determine the price of each C bond issued by ABC Ltd.

Below is given data for the calculation of the coupon bond of ABC Ltd.

bond price (data)

Therefore, the price of each bond can be calculated using the below formula as,

Coupon Bond Formula2

Therefore, calculation of the Coupon Bond will be as follows,

bond price calcualtion

So it will be –

bond price

= $1,041.58

Therefore, each bond will be priced at $1,041.58 and said to be traded at a premium (bond price higher than par value) because the coupon rate is higher than the YTM.

Relevance and Uses

The concept of pricing of this kind of bond is very important from the perspective of an investor because bonds are an indispensable part of the capital markets. The purchaser of a bond receives these coupon payments during the period between the issuance of the bond and the maturity of the bond. In the bond market, bonds with higher coupon rates are considered to be more attractive for investors because they offer higher yields.

Further, bonds trading at a value higher than their par value is said to be traded at a premium, while the bonds trading at a value lower than their par value is said to be traded at a discount. Nowadays, these bonds are quite uncommon because most recent bonds are not issued in coupon or certificate form. Rather the bonds are issued electronically.

Recommended Articles

This has been a guide to Coupon Bond Formula. Here we discuss how to calculate the Price of a Coupon Bond along with the examples and downloadable excel template. You may learn more about excel from the following articles –

  • Par Value of Share Formula
  • Zero-Coupon Bond
  • Bond Pricing Formula Calculation
  • Examples of Duration Formula
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Coupon Bond Formula Excel Template

Special Offer - Fixed Income Course (9 courses, 37+ hours videos) View More