The rate of interest (R) on your loan is calculated monthly i.e. (R= Annual rate of interest/12/100). For instance, if R = 10% per annum, then R= 10/12/100 = 0.0083. Finding it complicated?

How do I calculate EMI in Excel?

How to Calculate Your Personal Loan EMI Using Excel

  1. Highlights.
  2. Calculate EMIs using the PMT function on Excel.
  3. Use this formula =PMT(RATE,NPER,PV,FV,TYPE)
  4. These variables need to be computed & may lead to errors.
  5. Use the online EMI calculator to avoid manual errors.

How is EMI calculated with example?

  • Monthly Interest Rate = 10% ÷ 12 (10% is the annual interest rate.
  • Interest Component of EMI = 0.8333% × 50 lacs = Rs 41,667.
  • Principal Component of EMI = Rs 48,251 – Rs 41,667 = Rs 6,584.
  • Principal Outstanding at the end of the month (beginning of the next month) = Rs 50 lacs – Rs 6,584 = Rs 49.93 lacs.

How is principal and EMI calculated?

E = P x r x ( 1 + r )n / ( ( 1 + r )n – 1 ) where E is EMI, P is Principal Loan Amount, r is monthly rate of interest (For eg. If rate of interest is 14% per annum, then r = 14/12/100=0.011667), n is loan duration in number of months.

How EMI is divided in principal and interest?

Equated Monthly Installment (EMI) Formula The EMI flat-rate formula is calculated by adding together the principal loan amount and the interest on the principal and dividing the result by the number of periods multiplied by the number of months.

How do you calculate EMI manually?

The mathematical formula for calculating EMIs is: EMI = [P x R x (1+R)^N]/[(1+R)^N-1], where P stands for the loan amount or principal, R is the interest rate per month [if the interest rate per annum is 11%, then the rate of interest will be 11/(12 x 100)], and N is the number of monthly instalments.

What is formula for EMI with example?

USING MATHEMATICAL FORMULA EMI = [P x R x (1+R)^N]/[(1+R)^N-1], where P stands for the loan amount or principal, R is the interest rate per month [if the interest rate per annum is 11%, then the rate of interest will be 11/(12 x 100)], and N is the number of monthly instalments.

How can calculate EMI interest in Excel?

How To Calculate Principal Amount From EMI Using Excel Sheet

  1. To get the principal component in a particular month type: =PPMT(I,x,n,-p)
  2. To get the interest component in a particular month: =IPMT(I,x,n,-p)
  3. Also, you can calculate your EMI by typing: =PMT (I,n,-p)

What is the simplest method of calculating EMI?

Calculating EMI has a Simple Formula, Which is As Follows: EMI = (P X R/12) X [ (1+R/12) ^N] / [ (1+R/12) ^N-1]. P is the original loan amount or principal, R is the rate of interest that is applicable per annum and N is the number of monthly installments/ loan tenure.

How to calculate EMI formula?

RATE. Interest rate applicable on the loan. The value for this variable must be converted by dividing the rate by 12.

  • NPER. This variable denotes the number of EMIs applicable for the tenor. You can get the value by multiplying the number of years into 12.
  • PV. This variable denotes the principal loan amount or the present value. Here,you will need to add the amount you intend to borrow.
  • FV. This variable denotes the future value or balance remainder after the last payment. You may omit it and it will not affect the results.
  • TYPE. This variable denotes when the payment is due and the values can be either a 0 or 1.

    • How to calculate EMI?

    You have to use a mathematical formula to calculate EMI is: EMI = P × r × (1 + r) n / ((1 + r) n – 1) where P= Principal amount, r= rate of interest, n=Tenure (in months). Let assume a principal amount is Rs. 1 lakh with 10% interest rate and 12 months tenure:

    How is formula for calculating EMI derived?

    P = The home loan principal

  • R = Rate of interest divided by 100
  • N = Tenure for loan repayment in months