WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Interest on Loan

Interest on Loan

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Interest on Loan?

The term “interest on loan” refers to the amount that a borrower is obligated to pay or a depositor is supposed to earn on a principal sum at a pre-determined rate, which is known as the rate of interest and the formula for interest can be derived by multiplying the rate of interest, the outstanding principal sum and the tenure of the loan or deposit.

Interest Formula

Interest on Loan = P * r * t

where,

  • P = Outstanding principal sum
  • r = Rate of interest
  • t = Tenure of loan / deposit

In the case of periodic interest payment (such as monthly, quarterly, etc.), the equation for interest payment can be derived by multiplying the rate of interest and the outstanding principal sum and then dividing the result by the number of periodic payments during the year.

Mathematically, Interest Payment is represented as,

Interest on Loan = P * r / N

where,

  • P = Outstanding principal sum
  • r = Rate of interest
  • N = number of periodic payment per year

Steps to Calculate Interest on Loan

  • Step 1: Firstly, figure out the outstanding principal sum of the loan or deposit, and it is denoted by ‘P.’ Please keep in mind that the outstanding principal is the balance at the beginning of the year.
  • Step 2: Next, figure out the rate of the interest rate for the given loan or deposit, which is denoted by ‘r.’
  • Step 3: Next, figure out the tenure of the loan or deposit, and it is denoted by ‘t.’ The tenure of the facility is the number of years remaining until its maturity.
  • Step 4: Finally, the interest can be derived by multiplying the outstanding principal sum (step 1), the rate of interest (step 2), and the tenure of the loan or deposit (step 3) as shown below,
Interest = P * r * t

Examples

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

Example #1

Let us take an example, Trevor, who has deposited his money at ABC Bank Ltd. As per the bank policy, Trevor has been offered an interest rate of 6% on a sum of $1,000 that has been deposited for a period of 3 years. Calculate the interest to be earned by Trevor at the end of 3 years.

Solution:

Given,

  • Outstanding principal sum, P = $1,000
  • Rate of interest, r = 6%
  • Tenure of deposit, t = 3 years

Use the above data for the calculation of interest.

The interest earned by Trevor can be calculated as,

Example 1.1.1

Interest = $1,000 * 6% * 3

Interest will be –

Example 1.2.2

Interest = $180

Therefore, Trevor will earn an interest of $180 at the end of 3 years.

Example #2

Let us take another example of Smith, who has borrowed a sum of $5,000 from XYZ Bank Ltd for a period of 3 years. The rate of interest charged for the facility is 8%, and the loan has to be repaid in 6 equal half-yearly payments of $954. Calculate the interest on a loan to be paid by Smith at the end of 1st year, 2nd year, and 3rd year.

Solution:

Given,

  • Outstanding principal sum, P = $5,000
  • Rate of interest, r = 8%
  • Number of payments per year, N = 2 (since half-yearly payments)

Use the above data for calculation of interest charged for 1st six months.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

So, calculation of interest charged for 1st six months can be done as follows –

Interest Formula Example 0.2

Interest Charged for 1st Six Months = $5,000 * 8% / 2

Interest Charged for 1st Six Months will be –

Calculation 0.2.1

Interest Charged for 1st Six Months = $200

Calculation of Outstanding Principal Sum after 1st Six Months will be –

Interest Formula Example 0.2.2

Outstanding Principal Sum after 1st Six Months will be –

Calculation 0.2.3

Outstanding principal sum after 1st six months = $5,000 – ($954 – $200)

Outstanding Principal Sum after 1st Six Months = $4,246

Similarly, we can do the calculation of outstanding principal and interest charged for months 1 to 5.

Interest 0.2.4

Interest Formula Example 0.2.5

Interest on Loan Calculator

You can use the following Interest Formula Calculator

P
r
t
Interest
 

Interest = P x r x t
0 x 0 x 0 = 0

Relevance and Uses

The calculation of interest is an important concept to understand because it is an indispensable part of the income statement of any company. It can either impact the income side in the form of interest earned on an investment or affect the cost in the form of interest expense charged on the debt. As such, a company should employ adequate resources for settling down on the interest of both invested (return on investment) and borrowed funds (cost of the fund) in order to manage the financial performance efficiently.

Recommended Articles

This article has been a guide to Interest on Loan. Here we learn how to calculate interest on loan using its formula along with practical examples, a calculator, and a downloadable excel template. You can learn more about financial analysis from the following articles –

  • ROI
  • Formula of Nominal Interest Rate
  • Loan Note
  • Amortized Loan
  • Normalization Formula
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
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 Interest Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More