WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Risk Management Tutorials » Fixed Income Tutorials » Coupon Rate Formula

Coupon Rate Formula

Formula to Calculate Coupon Rate

Coupon Rate Formula is used for the purpose of calculating the coupon rate of the bond and according to the formula coupon rate of the bond will be calculated by dividing the total amount of annual coupon payments with the par value of the bonds and multiplying the resultant with the 100.

The term “coupon rate” refers to the rate of interest paid to the bondholders by the bond issuers. In other words, it is the stated rate of interest paid on fixed income securities, primarily applicable to bonds. The formula for coupon rate is computed by dividing the sum of the coupon payments paid annually by the par value of the bond and then expressed in terms of percentage.

Coupon Rate = Total Annual Coupon Payment / Par Value of Bond * 100%
Coupon Rate Formula

Conversely, the equation of the coupon rate of a bond can be seen as the percentage of the face value or par value of the bond paid every year.

Coupon Rate Calculation (Step by Step)

The coupon rate can be calculated by using the following steps:

  • Step 1: Firstly, figure out the face value or par value of the issued bonds. It will be easily available in the funding proposal or the accounts department of the company.
  • Step 2: Next, determine the no. of periodic payments made during the course of a year. Then all the periodic payments are added up to calculate the total coupon payment during the year. In the case of equal periodic payments, the total annual coupon payment can be computed by multiplying the periodic payments and the no. of payments made in the year. Total annual coupon payment = Periodic payment * No. of payments in a year
  • Step 3: Finally, the coupon rate is calculated by dividing the total annual coupon payment by the par value of the bond and multiplied by 100%, as shown above.

Examples 

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

Example #1

Let us take an example of bond security with half-yearly coupon payments. Let us assume a company PQR Ltd has issued a bond having the face value of $1,000 and quarterly interest payments of $25. Do the Calculation of the coupon rate of the bond.

coupon rate formula example 1.1

Annual Coupon Payment

coupon rate formula example 1.2

  • Annual coupon payment = 2 * Half-yearly coupon payment
  • = 2 * $25
  • = $50

Therefore, the calculation of the coupon rate of the bond is as follows –

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 rate formula example 1.3

Coupon Rate of the Bond will be –

coupon rate formula example 1.4

Example #2

Let us take another example of bond security with unequal periodic coupon payments. Let us assume a company XYZ Ltd has paid periodic payments of $25 at the end of 4 months, $15 at the end of 9 months, and another $15 at the end of the year. Do the Calculation of the coupon rate of the bond if the par value is $1,000.

Example2.1

Therefore, the calculation of the coupon rate of the bond is as follows,

Example2.2

Coupon Rate of the Bond will be –

Example2.3

Example #3

Dave and Harry are two bondholders of ABC Ltd. The company has made equal quarterly payments of $25. The par value of the bond is $1,000, and it is trading $950 in the market. Determine which statement is correct:

  1. Dave said that the coupon rate is 10.00%
  2. Harry said that the coupon rate is 10.53%

coupon rate formula example 3.1

Annual Coupon Payment

Example 3.2

  • Annual coupon payment = 4 * Quarterly coupon payment
  • = 4 * $25
  • = $100

Therefore, the coupon rate of the bond can be calculated using the above formula as,

Example 3.3

Coupon Rate of the Bond will be –

Example 3.4

Therefore, Dave is correct. [Harry has mistakenly used the market price of $950 in the place of par value for the calculation of coupon rate, i.e., $100 / $950 * 100% = 10.53%]

Relevance and Uses

It is important to understand the concept of coupon rate because almost all types of bonds pay annual payment to the bondholder, which is known as coupon payment. Unlike other financial metrics, the coupon payment in terms of the dollar is fixed over the life of the bond. For example, if a bond with a face value of $1,000 offers a coupon rate of 5%, then the bond will pay $50 to the bondholder until its maturity. The annual interest payment will continue to remain $50 for the entire life of the bond until its maturity date irrespective of the rise or fall in the market value of the bond.

Based on the coupon rate and the prevailing market rate of interest, it can be determined whether a bond will trade at a premium, par, or discount.

  • A bond trades at a premium when the coupon rate is higher than the market interest rate, which means that the price of the bond will fall because an investor will be reluctant to purchase the bond at that value.
  • Again the bond will trade at a discount when the coupon rate is lower than the market interest rate, which means the price of the bond will increase because an investor will be willing to purchase the bond at a higher value.
  • A bond trades at par when the coupon rate is equal to the market interest rate.

Recommended Articles

This has been a guide to what is Coupon Rate Formula. Here we learn how to calculate the Coupon Rate of the Bond using practical examples and a downloadable excel template. You can learn more about Accounting from the following articles –

  • Rate Formula Excel
  • Bond Sinking Fund
  • Bonds Payable
  • Advance Refunding
9 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 Rate Formula Excel Template

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