...
Date | Up to & (inclusive) | Days | Type | Amount | Opening Bal | Closing Bal | Interest on Bal | Interest To Date | Bal for Compounding | (I) Posted | Gain/Loss Due To Rounding | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
01/03/2013 | 01/03/2013 | 1 | Deposit | 1200 | 0 | 1200 | 0.164383562 | 0.164383562 | 1200.164383562 | ||||||||||
02/03/2013 | 09/03/2013 | 8 | Withdrawal | 100 | 1200 | 1100 | 1.206237813 | 1.370621375 | 1,101.370621375 | ||||||||||
10/03/2013 | 14/03/2013 | 5 | Withdrawal | 400 | 1100 | 700 | 0.480522469 | 1.851143844 | 701.851143844 | ||||||||||
15/03/2013 | 15/03/2013 | 1 | Deposit | 200 | 700 | 900 | 0.123541253 | 1.974685097 | 901.974685097 | ||||||||||
16/03/2013 | 17/03/2013 | 2 | Withdrawal | 900 | 900 | 0 | 0.000541047 | 1.975226144 | 1.975226144 | ||||||||||
18/03/2013 | 20/03/2013 | 3 | Deposit | 200 | 0 | 200 | 0.083014888 | 2.058241032 | 202.058241032 | ||||||||||
21/03/2013 | 30/03/2013 | 10 | Deposit | 700 | 200 | 900 | 1.236458229 | 3.294699261 | 903.294699261 | ||||||||||
31/03/2013 | 31/03/2013 | 1 | Withdrawal | 100 | 900 | 800 | 0.110040370 | 3.404739631 | 803.404739631 | ||||||||||
end of posting period | 31 | 800 | 3.404739631 = 3.40 | ||||||||||||||||
3.40 | -0.004739631 | ||||||||||||||||||
01/04/13 | 30/04/2013 | 30 | Interest Posting | 3.40 | 800 | 803.40 | 3.087239746 | 3.087239746 | 806.487239746 | end of posting period | 30 | 803.40 | 3.087239746 =3.09 | +0.002760254 | |||||
01/05/13 | 31/05/2013 | 31 | Interest Posting | 3.09 | 803.40 | 806.49 | 3.431867178 | 3.431867178 | 809.921867178 | ||||||||||
end of posting period | 31 | 806.49 | 3.431867178 = 3.43 | ||||||||||||||||
3.43 | -0.001867178 | ||||||||||||||||||
01/06/13 | 30/06/2013 | 30 | Interest Posting | 3.43 | 806.49 | 809.92 | 3.335058098 | 3.335058098 | 813.255058098 | end of posting period | 30 | 809.92 | 3.335058098 = 3.343.34 | +0.004941902 | |||||
122 | 813.26 | 13.26 |
Transaction | Date | Amount | Balance(EOD) | Number of Days | Cumulative Balance |
---|---|---|---|---|---|
Balance | 28th Feb 2013 | 0 | 0 | - | 0 |
Deposit | 1st Mar 2013 | 1200 | 1200 | 1 | 1200 |
Withdrawal | 2nd Mar 2013 | 100 | 1100 | 8 | 8800 |
Withdrawal | 10th Mar 2013 | 400 | 700 | 5 | 3500 |
Deposit | 15th Mar 2013 | 200 | 900 | 1 | 900 |
Withdrawal | 16th Mar 2013 | 900 | 0 | 2 | 0 |
Deposit | 18th Mar 2013 | 200 | 200 | 3 | 600 |
Deposit | 21st Mar 2013 | 700 | 900 | 10 | 7000 |
Withdrawal | 31st Mar 2013 | 100 | 800 | 1 | 800 |
31 Days | 22800 |
...