Compound Interest:-
Compound Interest is known as the interest of interest. He provide the multiple benefits. Compound Interest > Simple interest.
Compound Interest = p[{1+(r÷100)^t}-1]
 |
Results of above sheet:-
Other Results :-
Simple interest calculator Formula:-
Simple interest, Interest is equal every year if principal amount is not charged.
Simple interest = (P×t×r)÷100
Practical sheet is given in previous Page Click
Example 1. Write a MS Excel Formula who calculate the difference of compound Interest and Simple interest.
Solution:-
Let's P = C1
t = C2
r = C3
Different of SI and CI = C5
Results of above sheet Formula:-
Other Results:-
Example 2. Write a formula who calculated the 5year compound Interest, If principal amount is 8000 and rate 10% par year.
Solution:-
Let's D3 = Principle Amount
D4 = rate of interest
D5 = Time
Formula [ =D3×((1+(D4÷100))^D5) ]
Results of this example:-
Other Page
No comments:
Post a Comment