How to Calculate Bond Accrued Interest

PDF download Download Article
PDF download Download Article

Accrued interest on a bond refers to the interest that has been earned but not yet paid since the most recent interest payment. At the end of this accrual period (typically six months or a year) bonds generally pay interest. These are known as "coupon" payments. Depending on the bond, interest can be calculated in different ways. They all use what's called a "day-count fraction" or DCF. This refers to the number of days in a month or year, a number that is standardized for any given bond. For example, many bonds calculate interest by allocating 30 days to a month and 360 days to a year. Others may use the actual number of days in a month and year. To calculate your accrued interest, you must first know which of these methods is used for your bond and then do a few simple calculations.

Part 1
Part 1 of 3:

Gathering Your Information

PDF download Download Article
  1. The day-count convention (DCC) determines how the day-count fraction (DCF) is found when calculating accrued interest. The day-count convention on your bond is defined in the accompanying indenture (contract). [1] For example, 30 days in a month and 360 days in a year would mean a DCC of 30/360. Other bonds, especially U.S. government (Treasury) bonds, calculate interest using the exact number of days in a month and year. Such a DCC is sometimes referred to as "actual/actual" or "ACT/ACT."
    • In practice, bonds can also use a combination of these two DCCs, with such possible DCCs as 30/ACT and ACT/360. In practical terms, the convention used will make very little difference in terms of interest earned. Double-check your bond indenture to be sure. [2]
  2. Your interest rate, also called the coupon rate, specifies the amount of interest you earn on the bond annually as a percentage of your par (or "face") value. The payment frequency signifies whether your bond pays interest once a year or more often. Bonds typically pay interest either annually or semi-annually (once or twice per year). [3] This information can be found within your bond indenture.
    • For example, your bond might pay a 6% coupon rate twice per year. In this case, the annual interest rate would be 6% divided by the number of payments within the year. Thus, a 6% bond that pays interest twice per year would effectively pay 3% of the par value for each of the two payments during the year, or 6% total.
    Advertisement
  3. Search your records to see when your bond made its latest coupon payment. This information is available from the financial institution that sold you the bond.
  4. This will depend on your DCC, as the passage of days is calculated differently in each type of bond. Generally, if your bond is actual/actual, you will actually count the days. If your bond is 30/360, you would use those numbers for each month or year that has passed. [4]
    • Let's say you have a 30/360 bond, and exactly two months have passed since your latest payment. You would simply multiply 2 x 30 and use 60 days in your calculations, regardless of how many days there actually were in the elapsed months.
  5. This is the amount paid to the holder of the bond at maturity (when the interest payments stop). [5] This will be stated clearly on your bond indenture.
    • Note that the par value may be more or less than what you actually paid for the bond originally. Market price is affected by the existing rate environment and the bond issuer's creditworthiness. [6]
    • Bonds are often valued at $1000. That would be the par value even if you paid slightly more or less for it.
    6. Advertisement
Part 2
Part 2 of 3:

Calculating Bond Accrued Interest Manually

PDF download Download Article
  1. It's simpler than it looks: [7]
    • "A" is the accrued interest earned. This is the figure you are solving for.
    • "P" is the par value of the bond.
    • "C" is the annual coupon rate or interest rate. For our purposes it should be expressed as a decimal. Simply take the interest rate shown in the bond indenture and divide by 100 to produce the decimal equivalent.
      • For example, a 6% rate would be expressed as 0.06 (6/100).
    • "F" is the payment frequency (or number of payments per year). This would be 2 for semi-annual payments or 1 for annual ones.
    • "D" is the number of days since your latest coupon payment.
    • "T" is the total number of days in a payment period. This would be 360 for annual payments and 180 for semi-annual ones.
  2. Simply put all of the above information into the appropriate places in the equation. Double-check everything to make sure it's expressed correctly.
    • In the above example, we will use a bond with a par value of $1000 paying a 6% coupon rate semi-annually with a 30/360 DCC. Two months (60 days) have passed since the last payment, so "D" is 60. The total days in the payment period is 180, because payments are made twice per year (360/2=180).
    • The sample equation with all variables included would look like this:
  3. This simply means dividing the coupon rate by the payment frequency. This reflects the interest rate earned in each payment period. In the equation, this is C divided by F.
    • In our example, this calculation would give a rate of 0.03. The equation will look as follows after this calculation:
  4. Divide the number of days that have passed since the latest payment by the number of days in your current payment period. This is the final part of the equation.
    • In the example, this calculation would be 60/180, or 0.333. The equation should now look like this:
  5. Multiply the DCF by the face value of your bond to get the value of your accrued interest or coupon payment. You are multiplying the face value by the coupon rate by the day-count fraction.
    • In the example, this would be
    • Which simplifies to
    • The answer is then $10. Your bond has earned $10 in accrued interest over the selected time frame.
    6. Advertisement
Part 3
Part 3 of 3:

Calculating Bond Accrued Interest in Excel

PDF download Download Article
  1. Start Excel on your computer and start with a blank sheet so that there is no other information to distract you.
  2. For this calculation we would enter the current date , most recent payment date, DCC, par value, and coupon rate. Put these variables on separate lines down the first column of the spreadsheet. "Current date" goes in A1. "Coupon rate" lands in A5.
  3. Next to each variable name input the actual values. Make sure that these values are entered correctly. In other words, the dates are entered as dates, percentages as percentages, and monetary values as such. Otherwise, the program will not calculate the result properly. In our example, we use the following variables:
    • 3/31/2016 as the current date in cell B1.
    • 1/31/2016 as the last payment date in cell B2.
    • 0 as the DCC in cell B3. This indicates that we are using the 30/360 DCC. Inputting 1 indicates the actual/actual DCC. [8]
    • $1000 as the par value in cell B4.
    • 6% as the coupon rate in cell B5.
  4. The function needed to calculate bond accrued interest is known as the YEARFRAC function. Click on a nearby empty cell and type "=YEARFRAC(" to get started. The system will prompt you to input variables.
    • Click on cell B2.
    • Type in a comma to move to the next variable.
    • Click on cell B1.
    • Type in a comma to move to the next variable.
    • Click on cell B3.
    • Close the function with a parenthesis.
  5. In the same cell as the function, after you've closed the function, you must multiply it by your other two variables. Simply type in "*B4*B5" directly after the function, with no spaces anywhere.
    • Your completed entry into this cell should look like this: =YEARFRAC(B2,B1,B3)*B4*B5
  6. The program will solve your equation when you press enter on the cell that contains your function. Be sure to adjust the type of number in the cell to "currency" by selecting it at the top of the page under "number." This will ensure that your answer is displayed correctly.
    • In the example, this function yields $10, which is exactly the same as it was in our manual calculation.
    7. Advertisement

Glossary, Calculator, Practice Problems, and Answers

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • FINRA also has a useful calculator at https://accruedinterest.nga.finra.org/calculator/#!/ .
        Thanks
        Helpful 0 Not Helpful 0
      • For an easy approach, look up the security in Bloomberg. Enter BXT or SXT and complete the screen displayed. The interest will be calculated for you.
        Thanks
        Helpful 0 Not Helpful 0
      • Do not be confused by the different percentage rates calculated and used. Remember that when you do your first division calculations and end up with a percent, that percent is not the total annual or semi-annual rate; it is a percentage of the total percent paid in interest. In other words, 20/360 = 0.556 or 5.56 percent, which, in turn, is multiplied by the annual or semi-annual rate to get the rate for the period in question.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to
      Calculate Carrying Value of a Bond
      How to
      Calculate an Annual Percentage Growth Rate
      How to
      Make Money with Sweatcoin
      How to
      Calculate Dividends
      How to
      Calculate NPV
      How to
      Delete a Robinhood Account
      How to
      Find the Maturity Value for an Investment
      How to
      Calculate Beta
      How to
      Start Investing
      How to
      Calculate Annualized Portfolio Return
      How to
      Start an Investment Club
      How to
      Create an Investment Plan
      How to
      Set Up a Stop‐loss Order
      How to
      Annualize a Quarterly Return
      Advertisement

      References

      1. ↑ https://www.tvmcalcs.com/index.php/calculators/apps/calculate-accrued-interest-on-a-bond-in-excel-3-ways
      2. ↑ https://www.tvmcalcs.com/index.php/calculators/apps/calculate-accrued-interest-on-a-bond-in-excel-3-ways
      3. ↑ https://www.tvmcalcs.com/index.php/calculators/apps/calculate-accrued-interest-on-a-bond-in-excel-3-ways
      4. ↑ https://www.tvmcalcs.com/index.php/calculators/apps/calculate-accrued-interest-on-a-bond-in-excel-3-ways
      5. ↑ https://www.investopedia.com/terms/f/facevalue.asp
      6. ↑ https://www.investopedia.com/terms/p/parvalue.asp
      7. ↑ https://www.tvmcalcs.com/index.php/calculators/apps/calculate-accrued-interest-on-a-bond-in-excel-3-ways
      8. ↑ https://www.tvmcalcs.com/index.php/calculators/apps/calculate-accrued-interest-on-a-bond-in-excel-3-ways

      About This Article

      Article Summary X

      To calculate bond accrued interest manually, you’ll need to know the equation A = P × C/F × D/T. This may sound complicated, but it’s simpler than it looks. A is the accrued interest you are solving for. P is the par value of the bond. C is the annual coupon rate or interest rate. F is the payment frequency. D is the number of days since your last coupon. T is the total number of days in a payment period. Once you plug in your values, you’ll have your bond accrued interest. For more advice from our Certified Public Accountant reviewer, including how to calculate interest in Excel, keep reading!

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 272,689 times.

      Reader Success Stories

      • Vamshi Venishetty

        Oct 13, 2016

        "Simple, sophisticated and excellent explanation. I never imagined that I would able to understand so easily."
      More reader stories Hide reader stories
      Share your story

      Did this article help you?

      Advertisement