Hi Everyone i need a formula to calculate Accumulated Interest earned and Maturity vale of an Investment made for a certain period.
<tbody>
</tbody>
In the above mention table i need a single formula in cell "G1" to calculate total interest earned.
Thanks in advance.
A1 | B1 | C1 | D1 | E1 | F1 | G1 | ||
Principal Amount | Interest Rate | Start Date | Maturity Date | Period (days) |
<tbody> </tbody> |
<tbody> </tbody> | ||
100 | 7% | 1/4/14 | 31/03/15 | 365 | 107 | 7 |
<tbody>
</tbody>
In the above mention table i need a single formula in cell "G1" to calculate total interest earned.
Thanks in advance.