Associated Topics || Dr. Math Home || Search Dr. Math

Formula for Mortgage

```
Date: 7/4/96 at 18:59:48
From: Anonymous
Subject: Mortgage Loan Formula

I am unable to find a formula for loans. The only formulas I have are
for interest. What I need is a formula (like A=P(1+r/m)^mt).

Any help would be appeciated.

Thanks,
Patrick
```

```
Date: 7/5/96 at 11:34:52
From: Doctor Anthony
Subject: Re: Mortgage Loan Formula

We will let L = loan, n = number of months for repayment, starting at
end of first month, r = percentage interest rate per year, (take r/12
as monthly rate). P = amount of repayment per month (starting at end
of first month).

If we consider the loan first, this would increase by a factor
(1 + r/1200) per month, so after n months the value of the loan would
have increased to L(1 + r/1200)^n

Now consider the repayments.  These are \$P per month, but the value of
the earlier repayments also increases at a compound rate (1 + r/1200).
Thus after the second repayment, the value of the repayments is:

P + P(1 + r/1200)  and after three months it would be:
P + P(1 + r/1200) + P(1 + r/1200)^2   and after n months it would be:
P{1 + (1+r/1200) + (1+r/1200)^2 + ..... + (1+r/1200)^(n-1)}

This is a geometric series with n terms, first term = 1 and common
ratio (1+r/1200), so the sum of n terms is given by

P{(1+r/1200)^n - 1}/{(1+r/1200)-1)}
= P{(1+r/1200)^n - 1}/(r/1200)
= 1200P{(1+r/1200)^n - 1}/r

We must now equate the total repayments to total value of the loan,
and this gives:

1200P{(1+r/1200)^n - 1}/r  =  L(1+r/1200)^n

P = Lr(1+r/1200)^n/[1200{(1+r/1200)^n - 1}]

Example.  Find the monthly repayments on a loan of \$20,000 over 15
years at 12 percent per year compound interest.

Here we have n = 12*15 = 180 months, r = 12, and L = 20000.
We want to find P.

1+r/1200 = 1 + 12/1200 = 1.01   and the above formula becomes

P = {20000*12*1.01^180}/{1200*(1.01^180 - 1)}

= {20000*12*5.99}/{1200*(5.99 - 1)}

= 1437600/5988

= \$240.08

-Doctor Anthony,  The Math Forum
Check out our web site!  http://mathforum.org/dr.math/
```
Associated Topics:
High School Interest

Search the Dr. Math Library:

 Find items containing (put spaces between keywords):   Click only once for faster results: [ Choose "whole words" when searching for a word like age.] all keywords, in any order at least one, that exact phrase parts of words whole words

Submit your own question to Dr. Math
Math Forum Home || Math Library || Quick Reference || Math Forum Search

Ask Dr. MathTM
© 1994- The Math Forum at NCTM. All rights reserved.
http://mathforum.org/dr.math/