Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Describe this functionality and why an organization would use it (i.e. the business requirements).
Panel

On this page:

Table of Contents
maxLevel3
minLevel3
printablefalse

Declining Balance—Equal installments

Interest is computed The declining balance method calculates interest at periodic intervals on the amount of the original principal that has not yet been repaid. Since the borrower only pays interest on that amount of original principal that has not yet been repaid, interest paid is smaller every period. However, to make sure that the borrower sets EMI.

Formulas:

EMI FORMULA Repayment amounts, EMI, are equal. The interest component of the EMI is larger in the initial repayments and gradually reduces over time when compared to the principal amount. The exact percentage allocated towards payment of the principal depends on the interest rate. Even though periodic EMI payment don’t change, the proportion of principal and interest components will change with time. With each successive payment, more is allocated towards the principal and less towards interest.

The calculations is:

EMI = i*P / [1- (1+i)^-n]

Where,

P =

Loan

loan amount (principal)
r =

Rate

rate of interest per year/per month
n =

Term

term of the loan in periods
l =

Length

length of a period (Fraction of a year, i.e., 1/12 = 1 month, 1/52 = Week;If Interest calculation period is Daily then 7/365 = Week)
i = Interest rate per period (r*l)

Note: Interest = Principal balance*i

For example, a

Example

A client borrows a loan of $1000 with a interest rate

of5%

of 5% per year with 2

instalments

installments for every six months.

P=1000, r = 5/100, l = 6/12 & n = 2, i = 5/100 * 6/12 = 0.025
EMI = 0.025 * 1000 / [1-(1+0.025)^-2]
EMI = $518.83

 

Warning
titleKey Error Messages

 

Info

The way to apply payments is as follows:

Calculate interest in the principal due: If balance = $1000, and i = 0.025, interest is $25
Calculate the amount to principal which is the monthly payment minus the interest due: $518.83 - $25 = $493.83
Calculate the principal remaining, which is the previous principal remaining minus the amount applied to principal: $1000 - $493.83 = $506.17 (remaining balance)
Once next payment is received, repeat steps 1 to 3

.Note: Due to rounding of computed values, it could potentially be off by a maximum of N number of pennies after the full term of the loan

.

It will never be short if we round up, rather, principal could end up with a few more pennies.

 

Warning
titleKey Error Messages

 

info

Filter by label (Content by label)
showLabelsfalse
max5
spacesdocs
sortmodified
showSpacefalse
reversetrue
typepage
labelsloan calculations