EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Accrued Interest Formula

Accrued Interest Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 27, 2023

Accrued Interest Formula

Accrued Interest Formula (Table of Contents)
  • Formula
  • Examples
  • Calculator

What is Accrued Interest Formula?

Accrued Interest is the Interest amount you earn on a debt. But it is the amount that is not yet collected or paid. These amounts come from:

Start Your Free Investment Banking Course

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

  1. Income statement
  2. Balance Sheet

This gets gathered gradually from the data a loan is issued or bond coupon is made. Accrued Interest is noted as Revenue or Expense for a Bond selling or buying a loan respectively in Income Statements. Similarly, In Balance Sheet, The amount to be collected is noted as an asset and to be paid is noted as Liability. It is often called as Current Asset or Current Liability since it is expected to be paid or gathered within a year of time or 6 months. For the payment on bonds, this is called as ‘Coupon’ payments.

Formula to calculate Accrued Interest is given below:

Accrued Interest = Bond Face Value * Time of the Accrued Interest * Proper Interest Rate

When a seller sells a bond, the buyer of the bond will pay interest to the seller. Generally, most of the bonds follow semiannual interest payments. Generally, Accrued Interest follows Day Count Fraction. That is the number of Days considered in a month divided by Number of days in a year considered. Total days, most of the bonds consider is 30 days for a month, 360 days for a year. Hence DCF will be 30/360 in this case. But some bonds follow an actual number of days too. That is 365 days for a year. So it is necessary to know the days for a particular bond and the payments are semiannual or annual. Two Accounts are adjusted in two separate Financial Statements.

  1. Interest Expense Account
  2. Accrued Interest account

For Example, if Accrued Interest Account has Rs.1000 already, and it is to be received Rs.1000 again from Payable Account, the end amount in Accrued Interest Account will be Rs.2000.

Examples of Accrued Interest Formula (With Excel Template)

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

You can download this Accrued Interest Formula Excel Template here – Accrued Interest Formula Excel Template

Accrued Interest Formula – Example #1

A bond is sold at a book value of Rs.1000 with annual Payment rate. The Interest is set as 2%. The Accrued period starts from Jan 1st to Dec 31st. The Bond is bought on March 5th. Here the actual number of days is considered. Calculate the accrued Interest that is yet to be received.

Accrued Interest Formula Example 1-1

Solution:

Most recent payment should be on Jan 1st. so No of days from most recent payment is 31 days for Jan, 28 days for Feb, 5 days in March = 31+28+5 = 64.

Time of the Accrued Interest is calculated using the formula given below

Time of Accrued Interest = Interest Rate / Payment Frequency

Accrued Interest Formula Example 1-2

  • Time of the Accrued Interest = 2% / 1
  • Time of the Accrued Interest = 0.02

Proper Interest Rate is calculated using the formula given below

Proper Interest Rate = No of Days from your most recent Interest Payment / Total Number of Days in a Payment Period

Proper Interest Rate Example 1-3

  • Proper Interest Rate = 64 / 365
  • Proper Interest Rate = 0.175

Accrued Interest is calculated using the formula given below

Accrued Interest = Bond Face Value * Time of the Accrued Interest * Proper Interest Rate

Accrued Interest Formula Example 1-4

  • Accrued Interest = 1000 * 0.02 * 0.175
  • Accrued Interest = Rs. 3.51

Rs.3.51 is the accrued interest in the selected frame. Since Par value is very less, the interest accumulated too is very less.

Accrued Interest Formula – Example #2

A bond is bought at the book value of Rs.71000. The interest rate is 5%. It is payable Semi-annually on February 1st and August 1st. Bond is bought on April 15th. Calculate the Accrued Interest that it is to be paid.

Example 2-1

Solution:

Total no of days in payment = since nothing is specified it is 180 days.

No of days since last payment = 30+30+15 = 75

Time of the Accrued Interest is calculated using the formula given below

Time of Accrued Interest = Interest Rate / Payment Frequency

Accrued Interest Formula Example 2-2

  • Time of the Accrued Interest = 5% / 2
  • Time of the Accrued Interest = 0.025

Proper Interest Rate is calculated using the formula given below

Proper Interest Rate = No of Days from your most recent Interest Payment / Total Number of Days in a Payment Period

Proper Interest Rate Example 2-3

  • Proper Interest Rate = 75 / 180
  • Proper Interest Rate = 0.417

Accrued Interest is calculated using the formula given below

Accrued Interest = Bond Face Value * Time of the Accrued Interest * Proper Interest Rate

Accrued Interest Formula Example 2-4

  • Accrued Interest = 71000 * 0.025 * 0.417
  • Accrued Interest = Rs. 739.6

Explanation

Here is the step by step approach for the calculation of Accrued Interest.

Step 1: Bond Face or PAR Value

This is the Initial Book value of a bond when it was bought or sold. This should be noted.

Step 2: Time of the Accrued Interest

This is the amount what you get by dividing the Annual Interest rate by a frequency of the payment.

Time of the Accrued Interest = Annual Interest Rate / Payment Frequency

Step 3: Proper Interest Rate

This is based on the no of days since the most recent interest payment date and the Total number of days in a payment Period. If it is semi-annual, a Total number of days in a payment period is 180 days. If it is an annual payment method, it is 360 days. As it is said earlier, for most of the bond, the total number of days is considered as 30 days for a month and 360 days for a year.

Proper Interest Rate = No of Days from your most recent Interest Payment / Total number of days in a payment Period.

Step 4: After getting all the necessary values of the variables, it is applied in the below formula to calculate the Accrued Interest.

Accrued Interest = Bond Face Value * Time of the Accrued Interest * Proper Interest Rate

Relevance and Uses of Accrued Interest Formula

The use of Accrued interest is based on Accrual Accounting. It is neither received nor paid. It is just being realized in the account statements when they occur not at the time of only receiving the payment. It keeps getting added in the Par value as an interest to the bondholder. It is being recorded in Income Statements and Balance sheets before even they received or paid. This is exactly an income like pension, leaves that are not paid immediately but once in a year.

Accrued Interest Formula Calculator

You can use the following Accrued Interest Calculator

Bond Face Value
Time of the Accrued Interest
Proper Interest Rate
Accrued Interest Formula
 

Accrued Interest Formula = Bond Face Value x Time of the Accrued Interest x Proper Interest Rate
=0 x 0 x 0 = 0

Recommended Articles

This is a guide to Accrued Interest Formula. Here we discuss How to Calculate Accrued Interest along with practical examples. We also provide an Accrued Interest Calculator with downloadable excel template. You may also look at the following articles to learn more –

  1. Bond Pricing Formula with Different Examples
  2. Formula Of Effective Interest Rate
  3. Capital Employed Formula with Excel Template
  4. How to Calculate Simple Interest using Formula?
  5. Interest vs Dividend | Top 8 Key Differences You Should Know
PYTHON Course Bundle - 81 Courses in 1 | 59 Mock Tests
257+ Hours of HD Videos
81 Courses
59 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.8
C# Course Bundle - 24 Courses in 1 | 5 Mock Tests
93+ Hours of HD Videos
24 Courses
5 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.6
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
CYBER SECURITY & ETHICAL HACKING Course Bundle - 13 Courses in 1 | 3 Mock Tests
64+ Hours of HD Videos
13 Courses
3 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
FINANCIAL MODELING & VALUATION Course Bundle - 51 Courses in 1 | 30 Mock Tests | World's #1 Training
 278+ Hours of HD Videos
51 Courses
30 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.6
Price

View Course
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

Download Accrued Interest Formula Excel Template

Let’s Get Started

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

EDUCBA

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

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

डाउनलोड Accrued Interest 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