>I have this calculation to be done for a Cummulative Fixed Deposit. The thing is that the interest for only a given sub period is to be shown. For eg. the deposit is of 100,000/- @ 8% cummulative interest for a period of 5 years. I have to show what will be the interest say in the second year for the whole of the second year dated 01/04/2004 to 31/03/2005.Bhavbhuti,
You could just calculate the period-to-date interest for the start and end dates of the year in question (given the deposit's effective date) and then take the difference between those amounts to determine what interest accrued between those dates.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer