How do I calculate interest rate on a loan?

How is Interest Calculated on Personal Loans?

  1. EMI = equated monthly instalments.
  2. P = the principal amount borrowed.
  3. R = loan interest rate (monthly basis) = annual interest rate/12.
  4. N = loan tenure (in months)

>> Click to

Additionally, how do I calculate interest on a loan in Excel?


  1. The rate argument is the interest rate per period for the loan. For example, in this formula the 17% annual interest rate is divided by 12, the number of months in a year.
  2. The NPER argument of 2*12 is the total number of payment periods for the loan.
  3. The PV or present value argument is 5400.
Keeping this in view, how do I calculate principal and interest on a loan in Excel?

People also ask, how do you calculate interest rate example?

Simple Interest Formula

  1. (P x r x t) ÷ (100 x 12) …
  2. Example 1: If you invest Rs.50,000 in a fixed deposit account for a period of 1 year at an interest rate of 8%, then the simple interest earned will be: …
  3. Example 1: Say you borrowed Rs.5 lakh as personal loan from a lender on simple interest.

How do you calculate interest rate with repayments?

Divide your interest rate by the number of payments you’ll make in the year (interest rates are expressed annually). So, for example, if you’re making monthly payments, divide by 12. 2. Multiply it by the balance of your loan, which for the first payment, will be your whole principal amount.

How do you calculate principal and interest payments?

Use this simple interest calculator to find A, the Final Investment Value, using the simple interest formula: A = P(1 + rt) where P is the Principal amount of money to be invested at an Interest Rate R% per period for t Number of Time Periods. Where r is in decimal form; r=R/100; r and t are in the same units of time.

Is interest rate based on loan amount?

The interest rate is the amount a lender charges a borrower and is a percentage of the principal—the amount loaned. The interest rate on a loan is typically noted on an annual basis known as the annual percentage rate (APR).

What is the interest formula?

Simple interest is calculated with the following formula: S.I. = P × R × T, where P = Principal, R = Rate of Interest in % per annum, and T = The rate of interest is in percentage r% and is to be written as r/100. Principal: The principal is the amount that initially borrowed from the bank or invested.

Leave a Comment