I want to know how I'll calculate Quarterly Compound interest(on FDR) in excel.Also please help to calculate accrued interest(qtrly.compound).Please send in MS Excel file.
I'm giving an example for your understanding of my question:
Example Let's say I made a FDR for Rs.16,00,000/- for 6 months @ 6% (quarterly compound interest) on 16.10.2009 maturity date is 16.04.2010.
Now my question is - how much accrued interest i'll have to booked as on 31.3.2010(financial year closing date). and interest for the remaining period in the f.y.2010-11.
Please provide me in MS-Excel file only,so that I could solve my other fdr amount by puting the same in your file and keep it for future reference.