...
Monthly Posting so we want to post interest to the account for periods (01 Mar - 31 Mar), (01 Apr - 30 Apr), (01 May - 31 May), (01 Jun - 30 Jun)
Summary:
- Interest earned for march period is 3.404739630 - 3.40 will be posted to clients account mean the client loses out by 0.004739630 in this posting period
Date | Up to & (inclusive) | Days | Type | Amount | Opening Bal | Closing Bal | Interest on Bal | Interest To Date | Bal for Compounding | ||
---|---|---|---|---|---|---|---|---|---|---|---|
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. | 370621374370621375 | 1,101. | 370621374370621375 |
10/03/2013 | 14/03/2013 | 5 | Withdrawal | 400 | 1100 | 700 | 0.480522469 | 1. | 851143843851143844 | 701. | 851143843851143844 |
15/03/2013 | 15/03/2013 | 1 | Deposit | 200 | 700 | 900 | 0.123541253 | 1. | 974685096974685097 | 901. | 974685096974685097 |
16/03/2013 | 17/03/2013 | 2 | Withdrawal | 900 | 900 | 0 | 0.000541047 | 1. | 975226142975226144 | 1. | 975226142975226144 |
18/03/2013 | 20/03/2013 | 3 | Deposit | 200 | 0 | 200 | 0.083014888 | 2. | 058241031058241032 | 202. | 058241031058241032 |
21/03/2013 | 30/03/2013 | 10 | Deposit | 700 | 200 | 900 | 1.236458229 | 3. | 294699260294699261 | 903. | 294699260294699261 |
31/03/2013 | 31/03/2013 | 1 | Withdrawal | 100 | 900 | 800 | 0.110040370 | 3. | 404739630404739631 | 803. | 404739630404739631 |
end of posting period | 31 | 800 | 3.404739630 404739631 = 3.40 | ||||||||
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 | ||||||||
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 | ||||||||
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.34 | ||||||||
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 |
...