Excel fixed deposit year wise interest

Shri (M.Com) (129 Points)

05 October 2013  

I want to compute compound interest year wise, Can anyone help me in creating an excel sheet. I tried the net but could not find something i could use. I tried a few things but it did not work.

I have something like this:


Rate of Interest (in Percentage)

Fixed Deposit From Date:

Fixed Deposit To Date


I want yearly interest calculations.


If I have a fixed deposit for 3 years and 4 months, Then For Each year, i want interest calculations.

Also From Date can start on Any month - Say it could start in Sept, So interest calculation should be From Sept to 31st March of the current year and from 1st April of Next year to 31st March of the following year and so on.


Any Excel experts Please help me.