Lesson Interest rate calculation for compound interest

Source code of 'Interest rate calculation for compound interest'

This Lesson (Interest rate calculation for compound interest) was created by by Shruti_Mishra(0)

: View Source, Show
About Shruti_Mishra: I am a maths graduate from India and am currently persuing masters in Operations Research.

Compound Interest

<a href="compound_interest.wikipedia">Compound interest</A> is the money charged by the lender on the principal and the interests which is accumulated till that time period. In the case of <a href="compound_interest.wikipedia">Compound interest</A> there is a provision of the interest on interest.

The formula for the calculation of Compound Interest is
<center>
 {{{Amount = Principal * (1 + Rate/100) ^Years}}}
 {{{Interest = Amount - Principal}}}
</center>
 Example:&nbsp; We deposit money with the bank. The bank not only pay us back our initial deposit but also provide us with some kind of cash benefits (in the form of interest) for keeping the money with them. Suppose that you deposit the sum of $100 with the bank for the period of 5 yrs and the bank agrees to pay you the interest at the rate of 10%. 
 At the end of the first year you will get the interest of Rs 10 deposited in your account. In the second apart from getting the fixed interest of Rs 10, you will also get the interest on the accumulated interest till that time period i.e. &nbsp;10% * $10 = 0.1 * $10 = $1 
 So the final amount in the second year will be 100 + 10 + 11 = 121 
 In case of Compound Interest the interest itself earns interest. The working for above example:
<table border="1" align="center" cellpadding="0" cellspacing="0">
 <tr>
 <td valign="top"> 
 Year </td>
 <td valign="top">Principal</td>
 <td valign="top">Amount</td>
 <td valign="top">Interest</td>
 </tr>
 <tr>
 <td valign="top">1</td>
 <td valign="top">100</td>
 <td valign="top">100 * ( 1 + 0.1) = 110</td>
 <td valign="top">110 &ndash; 100 = 10</td>
 </tr>
 <tr>
 <td valign="top">2</td>
 <td valign="top">110</td>
 <td valign="top">100 * ( 1 + 0.1) (1 + 0.1) = 121 
 Or 
 110 * ( 1 + 0.1)^2 = 121</td>
 <td valign="top">121 &ndash; 110 = 11</td>
 </tr>
 <tr>
 <td valign="top">3</td>
 <td valign="top">121</td>
 <td valign="top">100 * ( 1 + 0.1) (1 + 0.1)(1 + 0.1) = 133.1 
 Or 
 121 * (1 + 0.1)^3 = 133.1</td>
 <td valign="top">133.1 &ndash; 121 = 12.1</td>
 </tr>
</table>
&nbsp; 
 While Calculating <a href="compound_interest.wikipedia">Compound interest</a> we observed that every year the Principal is equal to the Amount calculated last year.

Formulae when the compounding is not done annually

Compounded Semi- annually (Rate becomes half and time doubles) 
<center> {{{Amount = Principal *((1 + (Rate/200)) ^ (2*Time))}}}
 {{{Interest = Amount - Principal}}}
</center>

Compounded quarterly (Rate becomes one fourth and Time becomes four times) 
<center>{{{Amount = Principal *((1 + (Rate/400)) ^ (4*Time))}}}
 {{{Interest = Amount - Principal}}}
</center>

Compounded Monthly (Rate becomes one twelfth and Time becomes twelve times) 
<center> {{{Amount = Principal *((1 + (Rate/200)) ^ (2*Time))}}}
 {{{Interest = Amount - Principal}}}
</center>

Also see: 
Lessons:
<a href="interest_rate.lesson">Basics of Interest Rates and its uses</A>
<a href="simple_interest2.lesson">Simple Interest</A>

Solvers:
<A href="compound-interest-calculation.solver">
Calculate Compound Interest, given Principal, Time and Interest Rate </A>
<A href="calc-CompundInterestRate.solver">
Calculate Interest Rate, given Principal, Compund Interest and Time</A>