EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • 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
  • Log in
  • Sign Up
Home Finance Finance Resources Finance Formula Interest Expense Formula
 

Interest Expense Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 29, 2023

Interest Expense Formula

 

 

Interest Expense Formula (Table of Contents)
  • Interest Expense Formula
  • Examples of Interest Expense Formula (With Excel Template)
  • Interest Expense Formula Calculator

Interest Expense Formula

Interest Expense is one of the primary components of Income Statement, where it is treated as an ‘Expense’ and is directly related to the Current Debt Position of the Business.

The formula to calculate Interest Expense is as below:

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Interest Expense = Principal Amount (Total Borrowed Amount) * Rate of Interest * Time Period

Or,

Interest Expense = Average Balance of Debt Obligation * Interest Rate * Time period

Examples of Interest Expense Formula (With Excel Template)

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

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

Example #1

ABC Ltd. took a Loan of INR 1,00,000 on 1st January with a simple interest rate of 8.5% per annum. On 31st December, ABC Ltd. paid the Principle loan Amount along with the Interest expense.

Example 1-1

Solution:

The formula to calculate Interest Expense is as below:

Interest Expense = Principal Amount (Total Borrowed Amount) * Rate of Interest * Time Period

Interest Expense Example 1-2

  • Interest Expense = INR 1,00,000 * 8.5% * 1
  • Interest Expense = INR 8,500

Total amount paid for Interest is INR 8,500

Thus, the amount paid by ABC Ltd at the end of the year = INR (8,500 + 1,00,000) = INR 1,08,500

Example #2

Gati Ltd. has a long-term Loan of INR 216 Cr on 31st March with a simple interest rate of 8.5% per annum and a Short-term loan of INR 105 Cr during that period with a rate of interest of 10% per annum. Both were taken a year ago. Calculate the Interest expense on 31st March.

Example 2-1

Solution:

Interest Expense = Principal Amount (Total Borrowed Amount) * Rate of Interest * Time Period

Interest Expense Example 2-2

  • Interest Expense (Long Term) = INR 216 Cr * 8.5% * 1
  • Interest Expense (Long Term) = INR 18.36 Cr

Interest Expense = Principal Amount (Total Borrowed Amount) * Rate of Interest * Time Period

Interest Expense Example 2-3

  • Interest Expense (Short Term) = INR 105 Cr * 10% * 1
  • Interest Expense (Short Term) = INR 10.5 Cr

Total amount paid for Interest = INR (18.36+ 10.5) = INR 28.86 Cr.

Example #3

Tata Motors Ltd had total Borrowings (including Long-term and Short-term borrowings) of INR 88,950 Cr on 31st March 2018. On 1st October, the Company increased its total Borrowings to INR 92,923 Cr. Calculate the total amount of Interest the Company has to pay at the end of March 31st, 2019, if the rate of interest stands @ 5.25% / annum.

Solution:

  • Loan taken by Tata Motors Ltd. one year ago = INR 88,950 Cr.
  • The rate of Interest per annum = 5.25%
  • Tenure = 365 Days (One Year)

Interest Expense is calculated using the formula given below

Interest Expense = Principal Amount (Total Borrowed Amount) * Rate of Interest * Time Period

  • Interest Expense = INR 88,950 Cr * 5.25% * 1
  • Interest Expense = INR 4,669.88 Cr

Again, the Loan is taken by Tata Motors Ltd. for the last six months = INR (92,923 – 88,950) Cr = INR 3,973 Cr

  • Loan = INR 3,973 Cr
  • The rate of Interest per annum = 5.25%
  • Tenure = 180 Days (Half Year)

Interest Expense is calculated using the formula given below

Interest Expense = Principal Amount (Total Borrowed Amount) * Rate of Interest * Time Period

  • Interest Expense = INR 3,973 Cr * 5.25 % * 1/2
  • Interest Expense = INR 104.29 Cr

Total amount paid for Interest = INR (4,669.88 + 104.29) Cr =INR 4,774.17 cr.

Explanation of the Interest Expense Formula

Interest expense is the cost of the Lender giving money to the required party. Business houses need capital to do business. Capital can be of two types – one is Equity, and another is Debt. Equity holders are the real owners who are entitled to take the risk of the business, and their return is not Fixed. On the other hand, the Debenture holders are willing to invest in the business but with an assurance of guaranteed return. Debenture holders charge a fixed interest rate, and the Business is liable to pay irrespective of the loss or profit of the Business. The same phenomenon happens with Financial Institutions or banks when they lend money to the business.

Relevance and Uses

  • Interest Expense formula is extensively used by Companies, Firms, Governments, Banks, and Financial institutions as it is the revenue of the lender and an expense for the Borrower. Details of Interest calculations are always required as it might affect their business negatively or positively depending upon the rate of interest and tenure of the loan.
  • Due to higher Borrowings, some companies might find it hard to see profitability due to higher expenses, and margins with profitability are sinking. Thus, the management might discuss a revised interest rate to save their ‘bottom-line’. Again, during swift interest payment, the borrowers might give a certain interest rate rebate which helps borrowers pay interest before the time. The interest rate also depends on the Central bank’s interest rate changes. During high inflation, the government hikes interest costs for the banks so that the excess liquidity would get arrested, resulting in lower inflation and vice versa.
  • Thus, Interest costs have played a vital role for the Lender and the borrower. From the borrower’s point of view, higher interest costs lower the profit as it tends to lower the Company’s Net profit margin. Higher interest costs are always healthy for Lenders as it tends to generate income from the existing Funds.

Interest Expense Formula Calculator

You can use the following Interest Expense Calculator.

Principal Amount
Rate of Interest
Time Period
Interest Expense Formula
 

Interest Expense Formula = Principal Amount x Rate of Interest x Time Period
=0 x 0 x 0 = 0

Recommended Articles

This has been a guide to the Interest Expense formula. Here we discuss How to Calculate Interest Expenses along with practical examples. We also provide Interest Expense Calculator with a downloadable Excel template. You may also look at the following articles to learn more :

  1. Formula for Profitability Ratios
  2. How to Calculate Price Elasticity?
  3. Calculation of Average Total Cost
  4. Interest vs Dividend | Top 8 Key Differences You Should Know
  5. Expected Return Formula

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - 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
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

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

Download Interest Expense Formula Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड Interest Expense Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW