Interest Compounding Continuously With Bi Weakly Payments

Compounding sum paid for the use of money

The effect of earning 20% annual interest on an initial $1,000 investment at various compounding frequencies

Compound interest is the addition of interest to the principal sum of a loan or deposit, or in other words, interest on principal plus interest. It is the result of reinvesting interest, or adding it to the loaned capital rather than paying it out, or requiring payment from borrower, so that interest in the next period is then earned on the principal sum plus previously accumulated interest. Compound interest is standard in finance and economics.

Compound interest is contrasted with simple interest, where previously accumulated interest is not added to the principal amount of the current period, so there is no compounding. The simple annual interest rate is the interest amount per period, multiplied by the number of periods per year. The simple annual interest rate is also known as the nominal interest rate (not to be confused with the interest rate not adjusted for inflation, which goes by the same name).

Compounding frequency [edit]

The compounding frequency is the number of times per year (or rarely, another unit of time) the accumulated interest is paid out, or capitalized (credited to the account), on a regular basis. The frequency could be yearly, half-yearly, quarterly, monthly, weekly, daily, or continuously (or not at all, until maturity).

For example, monthly capitalization with interest expressed as an annual rate means that the compounding frequency is 12, with time periods measured in months.

The effect of compounding depends on:

1. The nominal interest rate which is applied and
2. The frequency interest is compounded.

Annual equivalent rate [edit]

The nominal rate cannot be directly compared between loans with different compounding frequencies. Both the nominal interest rate and the compounding frequency are required in order to compare interest-bearing financial instruments.

To help consumers compare retail financial products more fairly and easily, many countries require financial institutions to disclose the annual compound interest rate on deposits or advances on a comparable basis. The interest rate on an annual equivalent basis may be referred to variously in different markets as effective annual percentage rate (EAPR), annual equivalent rate (AER), effective interest rate, effective annual rate, annual percentage yield and other terms. The effective annual rate is the total accumulated interest that would be payable up to the end of one year, divided by the principal sum.

There are usually two aspects to the rules defining these rates:

1. The rate is the annualised compound interest rate, and
2. There may be charges other than interest. The effect of fees or taxes which the customer is charged, and which are directly related to the product, may be included. Exactly which fees and taxes are included or excluded varies by country, may or may not be comparable between different jurisdictions, because the use of such terms may be inconsistent, and vary according to local practice.

Examples [edit]

Compound interest of 15% on initial $10,000 investment over 40 years

Annual dividend of 1.5% on initial $10,000 investment
$266,864 in total dividend payments over 40 years
Dividends were not reinvested in this scenario

Inflation compounded over 40 years at different rates

 8%

 7%

 6%

 5%

 4%

 3%

 2%

 1%

• 1,000 Brazilian real (BRL) is deposited into a Brazilian savings account paying 20% per annum, compounded annually. At the end of one year, 1,000 × 20% = 200 BRL interest is credited to the account. The account then earns 1,200 × 20% = 240 BRL in the second year.
• A rate of 1% per month is equivalent to a simple annual interest rate (nominal rate) of 12%, but allowing for the effect of compounding, the annual equivalent compound rate is 12.68% per annum (1.01¹² − 1).
• The interest on corporate bonds and government bonds is usually payable twice yearly. The amount of interest paid (each six months) is the disclosed interest rate divided by two and multiplied by the principal. The yearly compounded rate is higher than the disclosed rate.
• Canadian mortgage loans are generally compounded semi-annually with monthly (or more frequent) payments.^[1]
• U.S. mortgages use an amortizing loan, not compound interest. With these loans, an amortization schedule is used to determine how to apply payments toward principal and interest. Interest generated on these loans is not added to the principal, but rather is paid off monthly as the payments are applied.
• It is sometimes mathematically simpler, for example, in the valuation of derivatives, to use continuous compounding, which is the limit as the compounding period approaches zero. Continuous compounding in pricing these instruments is a natural consequence of Itō calculus, where financial derivatives are valued at ever increasing frequency, until the limit is approached and the derivative is valued in continuous time.

Discount instruments [edit]

• US and Canadian T-Bills (short term Government debt) have a different convention. Their interest is calculated on a discount basis as (100 − P)/Pbnm,^{[ clarification needed ]} where P is the price paid. Instead of normalizing it to a year, the interest is prorated by the number of days t: (365/t)×100. (See day count convention).

Calculation [edit]

Periodic compounding [edit]

The total accumulated value, including the principal sum ${\displaystyle P}$ plus compounded interest ${\displaystyle I}$ , is given by the formula:^{[2] [3]}

$${\displaystyle A=P\left(1+{\frac {r}{n}}\right)^{nt}}$$

where:

• A is the final amount
• P is the original principal sum
• r is the nominal annual interest rate
• n is the compounding frequency
• t is the overall length of time the interest is applied (expressed using the same time units as r, usually years).

The total compound interest generated is the final value minus the initial principal:^[4]

$${\displaystyle I=P\left(1+{\frac {r}{n}}\right)^{nt}-P}$$

Example 1 [edit]

Suppose a principal amount of $1,500 is deposited in a bank paying an annual interest rate of 4.3%, compounded quarterly.
Then the balance after 6 years is found by using the formula above, with P = 1500, r = 0.043 (4.3%), n = 4, and t = 6:

$${\displaystyle A=1500\times \left(1+{\frac {0.043}{4}}\right)^{4\times 6}\approx 1938.84}$$

So the amount A after 6 years is approximately $1,938.84.

Subtracting the original principal from this amount gives the amount of interest received:

$${\displaystyle 1938.84-1500=438.84}$$

Example 2 [edit]

Suppose the same amount of $1,500 is compounded biennially (every 2 years). (This is very unusual in practice.) Then the balance after 6 years is found by using the formula above, with P = 1500, r = 0.043 (4.3%), n = 1/2 (the interest is compounded every two years), and t = 6 :

$${\displaystyle A=1500\times (1+(0.043\times 2))^{\frac {6}{2}}\approx 1921.24}$$

So, the balance after 6 years is approximately $1,921.24.

The amount of interest received can be calculated by subtracting the principal from this amount.

$${\displaystyle 1921.24-1500=421.24}$$

The interest is less compared with the previous case, as a result of the lower compounding frequency.

Accumulation function [edit]

Since the principal P is simply a coefficient, it is often dropped for simplicity, and the resulting accumulation function is used instead. The accumulation function shows what $1 grows to after any length of time.

Accumulation functions for simple and compound interest are

$${\displaystyle a(t)=1+rt}$$

$${\displaystyle a(t)=\left(1+{\frac {r}{n}}\right)^{nt}}$$

If ${\displaystyle nt=1}$ , then these two functions are the same.

Continuous compounding [edit]

As n, the number of compounding periods per year, increases without limit, the case is known as continuous compounding, in which case the effective annual rate approaches an upper limit of e ^r − 1, where e is a mathematical constant that is the base of the natural logarithm.

Continuous compounding can be thought of as making the compounding period infinitesimally small, achieved by taking the limit as n goes to infinity. See definitions of the exponential function for the mathematical proof of this limit. The amount after t periods of continuous compounding can be expressed in terms of the initial amount P ₀ as

$${\displaystyle P(t)=P_{0}e^{rt}.}$$

Force of interest [edit]

As the number of compounding periods ${\displaystyle n}$ tends to infinity in continuous compounding, the continuous compound interest rate is referred to as the force of interest ${\displaystyle \delta }$ .

In mathematics, the accumulation functions are often expressed in terms of e, the base of the natural logarithm. This facilitates the use of calculus to manipulate interest formulae.

For any continuously differentiable accumulation function a(t), the force of interest, or more generally the logarithmic or continuously compounded return is a function of time defined as follows:

$${\displaystyle \delta _{t}={\frac {a'(t)}{a(t)}}={\frac {d}{dt}}\ln a(t)}$$

This is the logarithmic derivative of the accumulation function.

Conversely:

$${\displaystyle a(t)=e^{\int _{0}^{t}\delta _{s}\,ds}\,,}$$

(since ${\displaystyle a(0)=1}$ ; this can be viewed as a particular case of a product integral.)

When the above formula is written in differential equation format, then the force of interest is simply the coefficient of amount of change:

$${\displaystyle da(t)=\delta _{t}a(t)\,dt}$$

For compound interest with a constant annual interest rate r, the force of interest is a constant, and the accumulation function of compounding interest in terms of force of interest is a simple power of e:

$${\displaystyle \delta =\ln(1+r)}$$

or

$${\displaystyle a(t)=e^{t\delta }}$$

The force of interest is less than the annual effective interest rate, but more than the annual effective discount rate. It is the reciprocal of the e-folding time. See also notation of interest rates.

A way of modeling the force of inflation is with Stoodley's formula: ${\displaystyle \delta _{t}=p+{s \over {1+rse^{st}}}}$ where p, r and s are estimated.

Compounding basis [edit]

To convert an interest rate from one compounding basis to another compounding basis, use

$${\displaystyle r_{2}=\left[\left(1+{\frac {r_{1}}{n_{1}}}\right)^{\frac {n_{1}}{n_{2}}}-1\right]{n_{2}},}$$

where r ₁ is the interest rate with compounding frequency n ₁, and r ₂ is the interest rate with compounding frequency n ₂.

When interest is continuously compounded, use

$${\displaystyle \delta =n\ln {\left(1+{\frac {r}{n}}\right)},}$$

where ${\displaystyle \delta }$ is the interest rate on a continuous compounding basis, and r is the stated interest rate with a compounding frequency n.

Monthly amortized loan or mortgage payments [edit]

The interest on loans and mortgages that are amortized—that is, have a smooth monthly payment until the loan has been paid off—is often compounded monthly. The formula for payments is found from the following argument.

Exact formula for monthly payment [edit]

An exact formula for the monthly payment ( ${\displaystyle c}$ ) is

$${\displaystyle c={\frac {rP}{1-{\frac {1}{(1+r)^{n}}}}}}$$

or equivalently

$${\displaystyle c={\frac {rP}{1-e^{-n\ln(1+r)}}}}$$

where:

This can be derived by considering how much is left to be repaid after each month.
The Principal remaining after the first month is

$${\displaystyle P_{1}=(1+r)P-c,}$$

that is, the initial amount plus interest less the payment.
If the whole loan is repaid after one month then

$${\displaystyle P_{1}=0,}$$

so

$${\displaystyle P={\frac {c}{1+r}}}$$

After the second month ${\displaystyle P_{2}=(1+r)P_{1}-c}$ is left, so

$${\displaystyle P_{2}=(1+r)((1+r)P-c)-c}$$

If the whole loan was repaid after two months,

$${\displaystyle P_{2}=0,}$$

so

$${\displaystyle P={\frac {c}{1+r}}+{\frac {c}{(1+r)^{2}}}}$$

This equation generalises for a term of n months, ${\textstyle P=c\sum _{j=1}^{n}{\frac {1}{(1+r)^{j}}}}$ . This is a geometric series which has the sum

$${\displaystyle P={\frac {c}{r}}\left(1-{\frac {1}{(1+r)^{n}}}\right)}$$

which can be rearranged to give

$${\displaystyle c={\frac {Pr}{1-{\frac {1}{(1+r)^{n}}}}}={\frac {Pr}{1-e^{-n\ln(1+r)}}}}$$

Spreadsheet formula [edit]

In spreadsheets, the PMT() function is used. The syntax is:

PMT( interest_rate, number_payments, present_value, future_value, [Type] )        

See Excel, Mac Numbers, LibreOffice, Open Office, Google Sheets for more details.

For example, for interest rate of 6% (0.06/12), 25 years * 12 p.a., PV of $150,000, FV of 0, type of 0 gives:

= PMT(0.06/12, 25 * 12, -150000, 0, 0) = $966.45        

Approximate formula for monthly payment [edit]

A formula that is accurate to within a few percent can be found by noting that for typical U.S. note rates ( ${\displaystyle I<8\%}$ and terms ${\displaystyle T}$ =10–30 years), the monthly note rate is small compared to 1: ${\displaystyle r<<1}$ so that the ${\displaystyle \ln(1+r)\approx r}$ which yields a simplification so that

$${\displaystyle c\approx {\frac {Pr}{1-e^{-nr}}}={\frac {P}{n}}{\frac {nr}{1-e^{-nr}}}}$$

which suggests defining auxiliary variables

$${\displaystyle Y\equiv nr=IT}$$

$${\displaystyle c_{0}\equiv {\frac {P}{n}}.}$$

Here ${\displaystyle c_{0}}$ is the monthly payment required for a zero–interest loan paid off in ${\displaystyle n}$ installments. In terms of these variables the approximation can be written

$${\displaystyle c\approx c_{0}{\frac {Y}{1-e^{-Y}}},}$$

The function ${\textstyle f(Y)\equiv {\frac {Y}{1-e^{-Y}}}-{\frac {Y}{2}}}$ is even:

$${\displaystyle f(Y)=f(-Y)}$$

implying that it can be expanded in even powers of ${\displaystyle Y}$ .

It follows immediately that ${\textstyle {\frac {Y}{1-e^{-Y}}}}$ can be expanded in even powers of ${\displaystyle Y}$ plus the single term: ${\displaystyle Y/2.}$

It will prove convenient then to define

$${\displaystyle X={\frac {1}{2}}Y={\frac {1}{2}}IT}$$

so that

$${\displaystyle c\approx c_{0}{\frac {2X}{1-e^{-2X}}}}$$

which can be expanded:

$${\displaystyle c\approx c_{0}\left(1+X+{\frac {X^{2}}{3}}-{\frac {1}{45}}X^{4}+\cdots \right)}$$

where the ellipses indicate terms that are higher order in even powers of ${\displaystyle X}$ . The expansion

$${\displaystyle P\approx P_{0}\left(1+X+{\frac {X^{2}}{3}}\right)}$$

is valid to better than 1% provided ${\displaystyle X\leq 1}$ .

Example of mortgage payment [edit]

For a $10,000 mortgage with a term of 30 years and a note rate of 4.5%, payable yearly, we find:

$${\displaystyle T=30}$$

$${\displaystyle I=0.045}$$

which gives

$${\displaystyle X={\frac {1}{2}}IT=.675}$$

so that

$${\displaystyle P\approx P_{0}\left(1+X+{\frac {1}{3}}X^{2}\right)=\$333.33(1+.675+.675^{2}/3)=\$608.96}$$

The exact payment amount is ${\displaystyle P=\$608.02}$ so the approximation is an overestimate of about a sixth of a percent.

Investing: monthly deposits [edit]

Given an principal (initial) deposit and a recurring deposit, the total return of an investment can be calculated via the compound interest gained per unit of time. If required, the interest on additional non-recurring and recurring deposits can also be defined within the same formula (see below).^[5]

The compound interest for each deposit is:

$${\displaystyle M'=M(1+r)^{t}}$$

and adding all recurring deposits over the total period t (i starts at 0 if deposits begin with the investment of principal; i stars at 1 if deposits begin the next month) :

$${\displaystyle M'=\sum _{i=0}^{t-1}{M(1+r)^{t-i}}}$$

recognizing the geometric series: ${\displaystyle M'=M\sum _{i=0}^{t-1}(1+r)^{t}{\frac {1}{(1+r)^{i}}}}$ and applying the closed-form formula (common ratio : ${\displaystyle 1/(1+r)}$ ) we obtain:

$${\displaystyle P'=M{\frac {(1+r)^{t}-1}{r}}+P(1+r)^{t}}$$

If two or more types of deposits occur (either recurring or non-recurring), the compound value earned can be represented as

$${\displaystyle {\text{Value}}=M{\frac {(1+r)^{t}-1}{r}}+P(1+r)^{t}+k{\frac {(1+r)^{t-x}-1}{r}}+C(1+r)^{t-y}}$$

where C is each lump sum and k are non-monthly recurring deposits, respectively, and x and y are the differences in time between a new deposit and the total period t is modeling.

A practical estimate for reverse calculation of the rate of return when the exact date and amount of each recurring deposit is not known, a formula that assumes a uniform recurring monthly deposit over the period, is:^[6]

$${\displaystyle r=\left({\frac {P'-P-\sum {M}}{P+\sum {M}/2}}\right)^{1/t}}$$

or

$${\displaystyle r=\left({\frac {P'-\sum {M}/2}{P+\sum {M}/2}}\right)^{1/t}-1}$$

History [edit]

Compound interest when charged by lenders was once regarded as the worst kind of usury and was severely condemned by Roman law and the common laws of many other countries.^[7]

The Florentine merchant Francesco Balducci Pegolotti provided a table of compound interest in his book Pratica della mercatura of about 1340. It gives the interest on 100 lire, for rates from 1% to 8%, for up to 20 years.^[8] The Summa de arithmetica of Luca Pacioli (1494) gives the Rule of 72, stating that to find the number of years for an investment at compound interest to double, one should divide the interest rate into 72.

Richard Witt's book Arithmeticall Questions, published in 1613, was a landmark in the history of compound interest. It was wholly devoted to the subject (previously called anatocism), whereas previous writers had usually treated compound interest briefly in just one chapter in a mathematical textbook. Witt's book gave tables based on 10% (the then maximum rate of interest allowable on loans) and on other rates for different purposes, such as the valuation of property leases. Witt was a London mathematical practitioner and his book is notable for its clarity of expression, depth of insight and accuracy of calculation, with 124 worked examples.^{[9] [10]}

Jacob Bernoulli discovered the constant ${\displaystyle e}$ in 1683 by studying a question about compound interest.

In the 19th century, and possibly earlier, Persian merchants used a slightly modified linear Taylor approximation to the monthly payment formula that could be computed easily in their heads.^[11]

See also [edit]

Look up interest in Wiktionary, the free dictionary.

• Credit card interest
• Exponential growth
• Fisher equation
• Interest
• Interest rate
• Rate of return
• Rate of return on investment
• Real versus nominal value (economics)
• Yield curve

References [edit]

1. ^ http://laws.justice.gc.ca/en/showdoc/cs/I-15/bo-ga:s_6//en#anchorbo-ga:s_6 ^{[ permanent dead link ]} Interest Act (Canada), Department of Justice. The Interest Act specifies that interest is not recoverable unless the mortgage loan contains a statement showing the rate of interest chargeable, "calculated yearly or half-yearly, not in advance." In practice, banks use the half-yearly rate.
2. ^ "Compound Interest Formula". qrc.depaul.edu . Retrieved 2018-12-05 .
3. ^ Investopedia Staff (2003-11-19). "Continuous Compounding". Investopedia . Retrieved 2018-12-05 .
4. ^ "Compound Interest Formula - Explained". www.thecalculatorsite.com . Retrieved 2018-12-05 .
5. ^ "Using Compound Interest to Optimize Investment Spread".
6. ^ http://moneychimp.com/features/portfolio_performance_calculator.htm "recommended by The Four Pillars of Investing and The Motley Fool"
7. ^  This article incorporates text from a publication now in the public domain:Chambers, Ephraim, ed. (1728). Cyclopædia, or an Universal Dictionary of Arts and Sciences (1st ed.). James and John Knapton, et al.
8. ^ Evans, Allan (1936). Francesco Balducci Pegolotti, La Pratica della Mercatura. Cambridge, Massachusetts. pp. 301–2.
9. ^ Lewin, C G (1970). "An Early Book on Compound Interest - Richard Witt's Arithmeticall Questions". Journal of the Institute of Actuaries. 96 (1): 121–132. doi:10.1017/S002026810001636X.
10. ^ Lewin, C G (1981). "Compound Interest in the Seventeenth Century". Journal of the Institute of Actuaries. 108 (3): 423–442. doi:10.1017/S0020268100040865.
11. ^ Milanfar, Peyman (1996). "A Persian Folk Method of Figuring Interest". Mathematics Magazine. 69 (5): 376. doi:10.1080/0025570X.1996.11996479.

smithtexer1939.blogspot.com

Source: https://en.wikipedia.org/wiki/Compound_interest

Share this post