**Formulae**

The balance of a loan with regular monthly payments is augmented by the monthly interest charge and decreased by the payment so

- ,

where

- i = loan rate/100 = annual rate in decimal form (e.g. 10% = 0.10 The loan rate is the rate used to compute payments and balances.)
- r = period rate = i/12 for monthly payments (customary usage for convenience)
- B
_{0}= initial balance (loan principal) - B
_{k}= balance after k payments - k = balance index
- p = period (monthly) payment

By repeated substitution one obtains expressions for B_{k}, which are linearly proportional to B_{0} and p and use of the formula for the partial sum of a geometric series results in

A solution of this expression for p in terms of B_{0} and B_{n} reduces to

To find the payment if the loan is to be finished in n payments one sets B_{n} = 0.

The PMT function found in spreadsheet programs can be used to calculate the monthly payment of a loan:

An interest-only payment on the current balance would be

- .

The total interest, I_{T}, paid on the loan is

- .

The formulas for a regular savings program are similar but the payments are added to the balances instead of being subtracted and the formula for the payment is the negative of the one above. These formulas are only approximate since actual loan balances are affected by rounding. To avoid an underpayment at the end of the loan, the payment must be rounded up to the next cent. The final payment would then be (1+r)B_{n-1}.

Consider a similar loan but with a new period equal to k periods of the problem above. If r_{k} and p_{k} are the new rate and payment, we now have

- .

Comparing this with the expression for B_{k} above we note that

and

- .

The last equation allows us to define a constant that is the same for both problems,

and B_{k} can be written as

- .

Solving for r_{k} we find a formula for r_{k} involving known quantities and B_{k}, the balance after k periods,

Since B_{0} could be any balance in the loan, the formula works for any two balances separate by k periods and can be used to compute a value for the annual interest rate.

B* is a scale invariant since it does not change with changes in the length of the period.

Rearranging the equation for B* one gets a transformation coefficient (scale factor),

- (see binomial theorem)

and we see that r and p transform in the same manner,

The change in the balance transforms likewise,

which gives an insight into the meaning of some of the coefficients found in the formulas above. The annual rate, r_{12}, assumes only one payment per year and is not an "effective" rate for monthly payments. With monthly payments the monthly interest is paid out of each payment and so should not be compounded and an annual rate of 12·r would make more sense. If one just made interest-only payments the amount paid for the year would be 12·r·B_{0}.

Substituting p_{k} = r_{k} B* into the equation for the B_{k} we get,

Since B_{n} = 0 we can solve for B*,

- .

Substituting back into the formula for the B_{k} shows that they are a linear function of the r_{k} and therefore the λ_{k},

This is the easiest way of estimating the balances if the λ_{k} are known. Substituting into the first formula for B_{k} above and solving for λ_{k+1} we get,

λ_{0} and λ_{n} can be found using the formula for λ_{k} above or computing the λ_{k} recursively from λ_{0} = 0 to λ_{n}.

Since p=rB* the formula for the payment reduces to,

and the average interest rate over the period of the loan is

- ,

which is less than r if n>1.

Read more about this topic: Interest

### Other articles related to "formulae":

**Formulae**Involving π

... The following is a list of significant

**formulae**involving the mathematical constant π ... The list contains only

**formulae**whose significance is established either in the article on the formula itself, the article on pi, or the one on numerical ...

... The language of well-formed CTL*

**formulae**is generated by the following unambiguous (wrt bracketing) context-free grammar where ranges over a set of atomic formulas ... Valid CTL*-

**formulae**are built using the nonterminal ... These

**formulae**are called state

**formulae**, while those created by the symbol are called path

**formulae**...

... , where and are regular

**formulae**i.e ...

**formulae**built up from atomic

**formulae**, the truth constant, binary meets and existential quantification ... Such

**formulae**can be interpreted in a regular category, and the interpretation is a model of a sequent ...

... The following

**formulae**give the distances to the Sun and Moon in terrestrial units where θ is the apparent radius of the Moon and Sun measured in degrees ... It is unlikely that Aristarchus used these exact

**formulae**, since he would have lacked a precise value for π ... These

**formulae**are likely a good approximation to those of Aristarchus ...

### Famous quotes containing the word formulae:

“I don’t believe in providence and fate, as a technologist I am used to reckoning with the *formulae* of probability.”

—Max Frisch (1911–1991)