Interest Earning of Fixed Deposit

[spycein]

Hi Everyone i need a formula to calculate Accumulated Interest earned and Maturity vale of an Investment made for a certain period.


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[TD]F1[/TD]
[TD]G1[/TD]
[/TR]
[TR]
[TD]Principal Amount[/TD]
[TD]Interest Rate[/TD]
[TD]Start Date[/TD]
[TD]Maturity Date[/TD]
[TD]Period (days)[/TD]
[TD][TABLE="width: 114"]
<tbody>[TR]
[TD="width: 114"]Maturity Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 138"]
<tbody>[TR]
[TD="width: 138"]Total Interest Earned[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]7%[/TD]
[TD]1/4/14[/TD]
[TD]31/03/15[/TD]
[TD]365[/TD]
[TD]107[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]

In the above mention table i need a single formula in cell "G1" to calculate total interest earned.

Thanks in advance.

 

[jumbledore]

(a2*(1+b2)^(1/(((d2-c2)+1)/365)))-a2