EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Finance Finance Resources Finance Formula Bond Formula

Bond Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 24, 2023

Bond Formula-1

Bond Formula (Table of Contents)
  • Formula
  • Examples

What is the Bond Formula?

The term “bond” refers to a type of debt instrument that pays periodic interest in the form of coupons and such bonds are known as coupon bonds. There are also bonds that don’t pay coupons but are issued at a lower price than their redeemable value and such bonds are known as zero-coupon or deep discount bonds.

The term “bond formula” refers to the bond price determination technique that involves computation of present value (PV) of all probable future cash flows, such as coupon payments and par or face value at maturity. The PV is calculated by discounting the cash flow using yield to maturity (YTM). Mathematically, the formula for coupon bond is represented as,

ADVERTISEMENT
Popular Course in this category
BOND TRADING Course

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Coupon Bond Price = C * [(1- (1 + r / n )-n*t ) / (r/n) ] + [F / (1 + r / n) n*t]

where,

  • C = Annual Coupon Payment
  • F = Par Value at Maturity
  • r = YTM
  • n = Number of Coupon Payments in A Year
  • t = Number of Years until Maturity

On the other hand, the formula for zero-coupon bond (putting C = 0 in the above formula) is represented as,

Zero-Coupon Bond Price = F / (1 + (r / n) )n*t

Examples of Bond Formula (With Excel Template)

Let’s take an example to understand the calculation of Bond in a better manner.

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

Bond Formula – Example #1

Let us take the example of deep discount bonds issued by ASD Inc. last week. The company will raise funds for its upcoming capex plans by issuing these 10,000 deep discount bonds. The face value of the bond is $1,000 and it is redeemable after 20 years. Calculate the price of each bond and the money that can be raised by ASD Inc. through these bonds if the YTM based on current market trends is 5%.

Example ASD Inc-1.1

Solution:

Bond Price is calculated using the formula given below

Bond Price = F / (1 +r / n) n*t

Bond Formula-1.2

  • Bond Price = $1,000 / (1 + 5% / 1) 1*20
  • Bond Price = $376.89

Fund is calculated using the formula given below

Fund = Number of Bonds Issued * Bond Price

Bond Formula-1.3

  • Fund = 10,000 * $376.89
  • Fund = $3,768,895 or $3.77 million

Therefore, based on the given information, each bond is worth $376.89. Further, ASD Inc. will be able to raise fund worth $3.77 million.

Bond Formula – Example #2

Let us take the example of another bond issue by SDF Inc. that will pay semi-annual coupons. The bonds have a face value of $1,000 and a coupon rate of 6% with maturity tenure of 10 years. Calculate the price of each coupon bond issued by SDF Inc. if the YTM based on current market trends is 4%.

Example of SDF Inc.-2.1

Solution:

Bond Price is calculated using the formula given below

Bond Price = C * [(1 – (1 + r / n )-n*t ) / (r/n) ] + [F / (1 + r / n) n*t]

Bond Formula-2.2

  • Bond Price = $30 * [(1 – (1 + (4% / 2) )-2*10 ) / (4% / 2) ] + [$1,000 / (1 + (4% / 2) )2*10]
  • Bond Price = $1,163.51

Therefore, the price of each coupon bond is expected to be $$1,163.51.

Explanation

The formula for a bond can be derived by using the following steps:

Step 1: Initially, determine the par value of the bond and it is denoted by F.

Step 2: Next, determine the rate at which coupon payments will be paid and using that calculate the periodic coupon payments. It is the product of the par value of the bond and coupon rate. It is denoted by C and mathematically represented as shown below.

C = Annual Coupon Rate * F

Step 3: Next, determine the bond’s number of years until maturity, which is denoted by t.

Step 4: Next, determine the YTM of the bond on the basis of the return currently expected from securities with similar risk profiles. The YTM is denoted by r.

Step 5: Next, determine the number of coupon payments to be paid during a year, which is denoted by n. To put it simply, it is the number of compounding per year.

Step 6: Next, determine the PV of probable future cash flows by discounting coupon payments and the face value at maturity using the YTM as shown below.

PV of kth Periodic Coupon Payment = (C / n) / (1 + r / n) k

PV of Face Value = F / (1 + r / n) n*t

Step 7: Finally, the bond formula can be derived by adding up the PV of all the coupon payments and the face value at maturity as shown below.

Bond Price = C * [(1 – (1 + r / n )-n*t ) / (r/n) ] + [F / (1 + r / n) n*t]

Relevance and Use of Bond Formula

From the perspective of an investor or an analyst, it is important to understand the concept of bond pricing as bonds are an indispensable part of the capital market. In the bond market, bonds paying higher coupons attractive for investors as a higher coupon rate means higher yields. Further, bonds that trade at a value higher than their face value are said to be trading at a premium, while bonds that trade at a value lower than their face value are said to be trading at discount. However, in the case of zero-coupon bonds, the current market trend decides it worth it. If the issue price is lower than the market rate then it is good for the investor.

Recommended Articles

This is a guide to Bond Formula. Here we discuss how to calculate Bond along with practical examples. We also provide a downloadable excel template. You may also look at the following articles to learn more –

  1. Formula for Current Yield of Bond
  2. Example of Bond Pricing
  3. Calculation of Bond Equivalent Yield
  4. How to Calculate Net Cash Flow
ADVERTISEMENT
FRM LEVEL 1 Exam Prep Course Bundle - 12 Courses in 1 |7 Mock Tests
85+ Hours of HD Videos
12 Courses
7 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
FIXED INCOME Course Bundle - 9 Courses in 1 | 3 Mock Tests
34+ Hours of HD Videos
9 Courses
3 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.7
ADVERTISEMENT
MERGERS & ACQUISITIONS Course Bundle - 5 Courses in 1 | 3 Mock Tests
21+ Hours of HD Videos
5 Courses
3 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

EDUCBA

Download Bond Formula Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

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

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

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Bond Formula Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW