The balance of a loan with regular monthly payments is augmented by the monthly interest charge and decreased by the payment so
- 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)
- B0 = initial balance (loan principal)
- Bk = balance after k payments
- k = balance index
- p = period (monthly) payment
By repeated substitution one obtains expressions for Bk, which are linearly proportional to B0 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 B0 and Bn reduces to
To find the payment if the loan is to be finished in n payments one sets Bn = 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, IT, 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)Bn-1.
Consider a similar loan but with a new period equal to k periods of the problem above. If rk and pk are the new rate and payment, we now have
Comparing this with the expression for Bk above we note that
The last equation allows us to define a constant that is the same for both problems,
and Bk can be written as
Solving for rk we find a formula for rk involving known quantities and Bk, the balance after k periods,
Since B0 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, r12, 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·B0.
Substituting pk = rk B* into the equation for the Bk we get,
Since Bn = 0 we can solve for B*,
Substituting back into the formula for the Bk shows that they are a linear function of the rk and therefore the λk,
This is the easiest way of estimating the balances if the λk are known. Substituting into the first formula for Bk 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":
... 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 dont believe in providence and fate, as a technologist I am used to reckoning with the formulae of probability.”
—Max Frisch (19111991)