WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Simple Interest Formula

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

Formula to Calculate Simple Interest (SI)

Simple Interest (SI) is a way of calculating the amount of interest that is to be paid on the principal and is calculated by an easy formula, which is by multiplying the principal amount with the rate of interest and the number of periods for which the interest has to be paid.

Simple Interest Formula

Simple Interest Formula

Here, interest is calculated only on the amount initially invested, and there is no interest in interest as the case with compound interest formula. It finds its usage in car loans and other consumer loans extended by banks and financial institutions. Also, the interest paid on savings bank accounts and term deposits by banks is also based on simple interest.

Examples

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

Example #1

ABC lends a sum of $5000 at 10% per annum for a period of 5 years. Calculate the simple interest and total amount due after 5 years.

Principal: $5000

Interest Rate: 10% per annum

Time period (in years) = 5

So now we will do the calculation this using the simple interest equation i.e

  • Simple Interest = Principal * Interest Rate * Time Period
  • Simple Interest =$5000 * 10%*5
  • =$2500

Total Simple Interest for 5 years= $2500

Amount due after 5 years=Principal + Simple Interest

  • = $5000+$2500
  • Amount due after 5 years = $7500.

Example #2

Ravi purchased a microwave oven from an electronics store that is priced at Rs 10000. he financed the same from its lender, HDFC bank. Details as follows:

loan amount: Rs 12000

loan period: 1 year

interest: 10% per annum

The frequency of payment: monthly

We can calculate the equated monthly amount in excel using the PMT function.

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

Accordingly, the EMI amount which Ravi will have to pay comes out to rs 879.16 (which includes both interest and principal amount as well). We can simply observe from the below amortization schedule of mortgage that the interest amount kept decreasing with each payment and the principal amount kept increasing; however, the monthly installment remained the same across the tenure of the loan.

Simple Interest Formula - Example 1

Important Points to Note when calculating simple interest:

  • The time period must be in years. In case the same is in a month, it should be converted into years as a fraction.
  • The interest rate must be expressed on an annual basis, but if the time period is less than a year, then it must be adjusted for one year. For instance, if the interest rate is 12% per annum, but the problem pertains to the monthly interest rate, then it will be 1% (12%/12).

Example #3

Ram took a car loan of $500000 from HDBC Bank, where interest is payable at 10% for a period of 24 months. The loan is to be repaid by making monthly equal payments of $23072.46 (calculated using PMT function in Excel)

The Schedule of payments calculated using SI formula in excel is as follows:

Simple Interest Formula - Practical Example 1

Practical Example 1-1

Practical Example 1-2

Let’s understand the concept of SI formula in excel using one more industry example related to Certificate of Deposits (CD).

Example #4

ABC Bank subscribed to the certificate of deposits totaling $20000 issued by the government of India, which carries a 5% interest per annum. The certificate of deposits matures in 6 months.

Interest earned by ABC Bank on the certificate of deposits:

Simple Interest= Principal * Rate* Time period

Practical Example 2

Thus ABC Bank will earn a total interest of $500 on the certificates of deposits on maturity, i.e., after 6 months.

Practical Example 2-1

Simple Interest Calculator

You can use the following Simple Interest Calculator.

Principal
Interest Rate
Time Period
Simple Interest Formula =
 

Simple Interest Formula = Principal x Interest Rate x Time Period
0 x 0 x 0 = 0

Relevance and Uses

  • The simple interest finds its relevance in the way interest is calculated by Banks on the savings bank account and term deposits held by depositors. Banks normally calculate interest on a quarterly basis in savings and term deposits.
  • Returns calculated under simple interest will always be less than returns calculated under compound interest as it ignores the concept of compounding.
  • SI formula ensures that the interest portion is higher in the Initial years and subsequently reduced as the tenure of the loan progress.
  • It is used to calculate interest on short-term loans like car loans, certificates of deposits and savings accounts, and term deposits.

Simple Interest Formula Video

Recommended Articles:

This has been a guide to Simple Interest Formula. Here we learn how to calculate simple interest along with some practical examples. Here we also provide you with Simple Interest Calculator with a downloadable excel template. You can learn more about Excel Modeling from the following articles –

  • Compound Interest Examples
  • Monthly Compound Interest Formula
  • Differences between Mortgage APR vs Interest Rate
  • Imputed Interest
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 Simple Interest Formula Excel Template

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