...
Date | Transaction | Amount |
---|---|---|
01 Mar 2013 | Deposit | 1200 |
02 Mar 2013 | Withdrawal | 100 |
10 Mar 2013 | Withdrawal | 400 |
15 Mar 2013 | Deposit | 200 |
16 Mar 2013 | Withdrawal | 900 |
18 Mar 2012 | Deposit | 200 |
21 Mar 2012 | Deposit | 700 |
31st Mar 2013 | Withdrawal | 100 |
Daily Compounding - Monthly Posting
The account activity breaks down into the following End of Day Balances:
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)
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.370621374 | 1,101.370621374 |
10/03/2013 | 14/03/2013 | 5 | Withdrawal | 400 | 1100 | 700 | 0.480522469 | 1.851143843 | 701.851143843 |
15/03/2013 | 15/03/2013 | 1 | Deposit | 200 | 700 | 900 | 0.123541253 | 1.974685096 | 901.974685096 |
16/03/2013 | 17/03/2013 | 2 | Withdrawal | 900 | 900 | 0 | 0.000541047 | 1.975226142 | 1.975226142 |
18/03/2013 | 20/03/2013 | 3 | Deposit | 200 | 0 | 200 | 0.083014888 | 2.058241031 | 202.058241031 |
21/03/2013 | 30/03/2013 | 10 | Deposit | 700 | 200 | 900 | 1.236458229 | 3.294699260 | 903.294699260 |
31/03/2013 | 31/03/2013 | 1 | Withdrawal | 100 | 900 | 800 | 0.110040370 | 3.404739630 | 803.404739630 |
end of posting period | 31 | 800 | 3.404739630 = 3.40 | ||||||
01/04/13 | 30/04/2013 | 30 | Interest Posting | 3.40 | 800 | 803.40 | |||
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 |
...