Loan repayment formula

This forum made possible through the generous support of SDN members, donors, and sponsors. Thank you.

s.mutans

Senior Member
7+ Year Member
15+ Year Member

Members don't see this ad.
PLEase confirm this formula.

(Total cost for Four years)(percentage rate) + (total cost for four years)

divided by

240 payments(20 years) = monthly payment

i.e.

(200,000)(.08) + (200,000)= 216,000

216,000/ 240= \$900 per month.

Right?

mpp

SDN Moderator
Moderator Emeritus
15+ Year Member
Sorry to be the bearer of bad news but you're not right. The interest is earned each year and must be paid on top of the principal payments that will pay down the loan. The formula is a little bit more complicated than that. It would be:

Payment = P*(I/12) / (1-(1+I/12)^(-n))

Where P is the principal loan amount, I is the APR interest rate, and n is the number of periods.

In your case the monthly payment would be \$1672.88

The best way to figure out payments is to use a financial calculator or you can use Excel. The formula for use in Excel would be

=PMT(0.08/12,240,200000,0)

or =PMT(I,n,P,FV)

where P=principal, I=Interest per period, n=number of periods, FV=final value.

Good luck.

camilagrace

New Member
The loan is repaid by way of EMI on your total amount. When I had taken the home loan I calculated its EMI on the basis of the below mentioned mathematical formula:
[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 installments.
EMI calculator is also based on this basic formula.
Source: http://emicalculators.in/