Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DateTransactionAmount
01 Mar 2013Deposit1200
02 Mar 2013Withdrawal100
10 Mar 2013Withdrawal400
15 Mar 2013Deposit200
16 Mar 2013Withdrawal900
18 Mar 2012Deposit200
21 Mar 2012Deposit700
31st Mar 2013Withdrawal100

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)

 

DateUp to & (inclusive)DaysTypeAmountOpening BalClosing BalInterest on BalInterest To DateBal for Compounding

01/03/2013

01/03/20131Deposit1200012000.1643835620.1643835621200.164383562
02/03/201309/03/20138Withdrawal100120011001.2062378131.3706213741,101.370621374
10/03/201314/03/20135Withdrawal40011007000.4805224691.851143843701.851143843
15/03/201315/03/20131Deposit2007009000.1235412531.974685096901.974685096
16/03/201317/03/20132Withdrawal90090000.0005410471.9752261421.975226142
18/03/201320/03/20133Deposit20002000.0830148882.058241031202.058241031
21/03/201330/03/201310Deposit7002009001.2364582293.294699260903.294699260
31/03/201331/03/20131Withdrawal1009008000.1100403703.404739630803.404739630
 end of posting period31   8003.404739630 = 3.40  
01/04/1330/04/201330Interest Posting3.40800803.40   
          
          
          

 

 

 

 

 

TransactionDateAmountBalance(EOD)Number of DaysCumulative Balance
Balance28th Feb 201300-0
Deposit1st Mar 20131200120011200
Withdrawal2nd Mar 2013100110088800
Withdrawal10th Mar 201340070053500
Deposit15th Mar 20132009001900
Withdrawal16th Mar 2013900020
Deposit18th Mar 20132002003600
Deposit21st Mar 2013700900107000
Withdrawal31st Mar 20131008001800
    31 Days

22800

...