Simple Interest Formula

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

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: 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 loansConsumer LoansA consumer loan is a type of credit given to a consumer to finance specified set of expenditures. The borrower must pledge a specific asset as collateral for the loan, or it may be unsecured depending on the loan's monetary more 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.


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 functionUsing The PMT FunctionThe PPMT function in Excel is a financial function that calculates the payment for a given principal and returns an integer result. This function can be used to calculate the principal amount of an installment for any more.

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 payableInterest Is PayableInterest Payable is the amount of expense that has been incurred but not yet paid. It is a liability that appears on the company's balance more 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 functionPMT FunctionPMT function is an advanced financial function to calculate the monthly payment against the simple loan amount. You have to provide basic information, including loan amount, interest rate, and duration of payment, and the function will calculate the payment as a more 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)Certificate Of Deposits (CD)Certificate of deposit (CD) is a money market instrument issued by a bank to raise funds from the secondary money market. It is issued for a specific period for a fixed amount of money with a fixed rate of interest. It is an arrangement between the depositor of money and the more.

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.

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 –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *