I have got the table below which shows the amount of money A has given to B and the amount of money B has returned to A. I would like to calculate the interest (compounded annually) at 5% pa on each transaction that A will be charging B. For e.g. on 02.09.2009, A gave Rs. 75,000 to B which B returned on 27.01.2010. I can very well calculate the interest on that but what about the interest on the rest of the transactions? That is where I am getting stuck. Can someone please suggest me how to go about it? Thanks
DATE | PAYMENT FROM A TO B | PAYMENT FROM B TO A |
02-09-2009 | 75,000.00 | |
14-09-2009 | 30,000.00 | |
27-01-2010 | 75,000.00 | |
25-02-2010 | 25,000.00 | |
25-02-2010 | 25,000.00 | |
25-02-2010 | 25,000.00 | |
25-02-2010 | 27,000.00 | |
08-03-2010 | 20,000.00 | |
10-03-2010 | 20,000.00 | |
10-03-2010 | 30,000.00 | |
15-03-2010 | 32,000.00 | |
26-03-2010 | 25,000.00 | |
29-03-2010 | 5,000.00 | |
15-04-2010 | 2,000.00 | |
15-06-2010 | 1,30,000.00 | |
13-12-2010 | 50,000.00 | |
09-02-2011 | 80,000.00 |