Spreadsheet: 27575d1220931529-accumulated-interest-accum-daily-interest
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  |  |  | Date | Description | Debit | Credit | Balance
 |  |  |  |  |  | accum |  | ACTUAL at 6.5% interest |  |  |  | 2008-07-03 00:00:00 | GC 0679-TRANSFER | 3000 |  | 3000
Rate | Date | Description | Debit | Credit | Balance | Interest | Date | Description | Debit | Credit | Balance | 2008-07-18 00:00:00 | PAYMENT - THANK YOU |  | 467 | 2533
6.5 | 2008-07-03 00:00:00 | GC 0679-TRANSFER | 3000 |  | 3000 |  | 2008-07-03 00:00:00 | GC 0679-TRANSFER | 3000 |  | 3000 | 2008-07-23 00:00:00 | CHQ#00002-[PHONE] | 1925 |  | 6249
6.5 | 2008-07-18 00:00:00 | PAYMENT - THANK YOU |  | 467 | 2533 | 8.013698630136986 | 2008-07-18 00:00:00 | PAYMENT - THANK YOU |  | 467 | 2533 | 2008-07-23 00:00:00 | CHQ#00001-[PHONE] | 1791 |  | 4324
6.5 | 2008-07-23 00:00:00 | CHQ#00001-[PHONE] | 1791 |  | 4324 | 10.2691095890411 | 2008-07-23 00:00:00 | CHQ#00001-[PHONE] | 1791 |  | 4324 | 2008-07-31 00:00:00 | INTEREST | 20.28 |  | 6269.28
6.5 | 2008-07-23 00:00:00 | CHQ#00002-[PHONE] | 1925 |  | 6249 |  | 2008-07-23 00:00:00 | CHQ#00002-[PHONE] | 1925 |  | 6249 | 2008-08-01 00:00:00 | PAYMENT - THANK YOU |  | 467 | 5802.28
6.5 | 2008-07-31 00:00:00 | INTEREST | 20.28 |  | 6269.28 | 20.2846301369863 | 2008-07-31 00:00:00 | INTEREST | 20.28 |  | 6269.28 | 2008-08-12 00:00:00 | CHQ#00003-[PHONE] | 288.75 |  | 6091.03
6.5 | 2008-08-01 00:00:00 | PAYMENT - THANK YOU |  | 467 | 5802.28 |  | 2008-08-01 00:00:00 | PAYMENT - THANK YOU |  | 467 | 5802.28 | 2008-08-21 00:00:00 | CHQ#00005-[PHONE] | 2731.68 |  | 9195.46
6.5 | 2008-08-12 00:00:00 | CHQ#00003-[PHONE] | 288.75 |  | 6091.03 | 11.3661101369863 | 2008-08-12 00:00:00 | CHQ#00003-[PHONE] | 288.75 |  | 6091.03 | 2008-08-21 00:00:00 | CHQ#00006-[PHONE] | 372.75 |  | 6463.78
6.5 | 2008-08-21 00:00:00 | CHQ#00006-[PHONE] | 372.75 |  | 6463.78 |  | 2008-08-21 00:00:00 | CHQ#00006-[PHONE] | 372.75 |  | 6463.78 | 2008-08-29 00:00:00 | INTEREST | 39.14 |  | 9234.6
6.5 | 2008-08-21 00:00:00 | CHQ#00005-[PHONE] | 2731.68 |  | 9195.46 | 21.12844589041096 | 2008-08-21 00:00:00 | CHQ#00005-[PHONE] | 2731.68 |  | 9195.46 | 2008-09-02 00:00:00 | CHQ#00007-[PHONE] | 173.25 |  | 9407.85
6.5 | 2008-08-29 00:00:00 | INTEREST |  |  |  | 39.1414702739726 | 2008-08-29 00:00:00 | INTEREST | 39.14 |  | 9234.6 | 2008-09-04 00:00:00 | CHQ#00009-[PHONE] | 294 |  | 9701.85
 | 2008-08-31 00:00:00 |  | 39.14 |  | 9234.6 |  |  |  |  |  |  | 2008-09-05 00:00:00 | PAYMENT - THANK YOU |  | 467 | 9234.85
6.5 | 2008-09-02 00:00:00 | CHQ#00007-[PHONE] | 173.25 |  | 9407.85 | 3.289035616438357
6.5 | 2008-09-04 00:00:00 | CHQ#00009-[PHONE] | 294 |  | 9701.85 | 6.639776712328768 |  |  |  |  |  | daily
6.5 | 2008-09-05 00:00:00 | PAYMENT - THANK YOU |  | 467 | 9234.85 | 8.367503424657535 | Date | Description | Debit | Credit | Balance | interest | accrued interest
6.5 |  |  |  |  |  |  | 2008-07-03 00:00:00 | GC 0679-TRANSFER | 3000 |  | 3000 | 0.5342465753424658 |  | 8.013698630136986 | 15 | 8.013698630136986
6.5 |  |  |  |  |  |  | 2008-07-04 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 1.068493150684932
6.5 |  | 15 |  |  |  |  | 2008-07-05 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 1.602739726027397
6.5 |  |  |  |  |  | ` | 2008-07-06 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 2.136986301369863
6.5 |  |  |  |  |  |  | 2008-07-07 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 2.671232876712329
6.5 |  |  |  |  |  |  | 2008-07-08 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 3.205479452054794
6.5 |  |  |  |  |  |  | 2008-07-09 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 3.73972602739726
6.5 |  |  |  |  |  |  | 2008-07-10 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 4.273972602739726
6.5 |  |  |  |  |  |  | 2008-07-11 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 4.808219178082192
6.5 | ACCRINTM(issue,maturity,rate,par,basis) |  |  |  |  |  | 2008-07-12 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 5.342465753424658
6.5 | This is a chequebook where every cheque is a debt. |  |  |  |  |  | 2008-07-13 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 5.876712328767123
6.5 |  |  |  |  |  |  | 2008-07-14 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 6.410958904109589
6.5 |  |  |  |  |  |  | 2008-07-15 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 6.945205479452055
6.5 |  |  |  |  |  |  | 2008-07-16 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 7.47945205479452
6.5 |  |  |  |  |  |  | 2008-07-17 00:00:00 |  |  |  | 3000 | 0.5342465753424658 | 8.013698630136986 | 8.013698630136986
6.5 |  |  |  |  |  |  | 2008-07-18 00:00:00 | PAYMENT - THANK YOU |  | 467 | 2533 | 0.4510821917808219 | 8.464780821917808 | 2.25541095890411
6.5 |  |  |  |  |  |  | 2008-07-19 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 8.91586301369863 | 10.2691095890411
6.5 |  |  |  |  |  |  | 2008-07-20 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 9.366945205479452
6.5 |  |  |  |  |  |  | 2008-07-21 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 9.818027397260273
6.5 |  |  |  |  |  |  | 2008-07-22 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 10.2691095890411
6.5 |  |  |  |  |  |  | 2008-07-23 00:00:00 | CHQ#00001-[PHONE] | 1791 |  | 4324 | 0.770027397260274 | 11.03913698630137
6.5 |  |  |  |  |  |  | 2008-07-24 00:00:00 | CHQ#00002-[PHONE] | 1925 |  | 6249 | 1.112835616438356 | 12.15197260273973
6.5 |  |  |  |  |  |  | 2008-07-25 00:00:00 |  |  |  | 13106 | 2.333945205479452 | 14.48591780821918
6.5 |  |  |  |  |  |  | 2008-07-26 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 14.937
6.5 |  |  |  |  |  |  | 2008-07-27 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 15.38808219178082
6.5 |  |  |  |  |  |  | 2008-07-28 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 15.83916438356164
6.5 |  |  |  |  |  |  | 2008-07-29 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 16.29024657534247
6.5 |  |  |  |  |  |  | 2008-07-30 00:00:00 |  |  |  | 2533 | 0.4510821917808219 | 16.74132876712329
6.5 |  | 0 |  |  |  |  | 2008-07-31 00:00:00 | INTEREST | 20.28 |  | 6269.28 | 1.116447123287671 | 0
6.5 |  | 0 |  |  |  |  | 2008-08-01 00:00:00 | PAYMENT - THANK YOU |  | 467 | 5802.28 | 1.033282739726027 | 1.033282739726027
6.5 |  | 0 |  |  |  |  | 2008-08-02 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 2.066565479452055
6.5 |  | 0 |  |  |  |  | 2008-08-03 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 3.099848219178082
6.5 |  | 0 |  |  |  |  | 2008-08-04 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 4.133130958904109
6.5 |  | 0 |  |  |  |  | 2008-08-05 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 5.166413698630137
6.5 |  | 0 |  |  |  |  | 2008-08-06 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 6.199696438356165
6.5 |  | 0 |  |  |  |  | 2008-08-07 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 7.232979178082193
6.5 |  | 0 |  |  |  |  | 2008-08-08 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 8.26626191780822
6.5 |  | 0 |  |  |  |  | 2008-08-09 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 9.299544657534248
6.5 |  | 0 |  |  |  |  | 2008-08-10 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 10.33282739726028
6.5 |  | 0 |  |  |  |  | 2008-08-11 00:00:00 |  |  |  | 5802.28 | 1.033282739726027 | 11.3661101369863
6.5 |  | 0 |  |  |  |  | 2008-08-12 00:00:00 | CHQ#00003-[PHONE] | 288.75 |  | 6091.03 | 1.08470397260274 | 12.45081410958904 | 11.3661101369863 | 12.45081410958904
6.5 |  | 0 |  |  |  |  | 2008-08-13 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 13.53551808219178
6.5 |  | 0 |  |  |  |  | 2008-08-14 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 14.62022205479452
6.5 |  | 0 |  |  |  |  | 2008-08-15 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 15.70492602739726
6.5 |  | 0 |  |  |  |  | 2008-08-16 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 16.78963
6.5 |  |  |  |  |  |  | 2008-08-17 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 17.87433397260274
6.5 |  |  |  |  |  |  | 2008-08-18 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 18.95903794520548
6.5 |  |  |  |  |  |  | 2008-08-19 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 20.04374191780822
6.5 |  |  |  |  |  |  | 2008-08-20 00:00:00 |  |  |  | 6091.03 | 1.08470397260274 | 21.12844589041095 | 9.762335753424656 | 21.12844589041096
6.5 |  |  |  |  |  |  | 2008-08-21 00:00:00 | CHQ#00006-[PHONE] | 372.75 |  | 6463.78
6.5 |  |  |  |  |  |  | 2008-08-21 00:00:00 | CHQ#00005-[PHONE] | 2731.68 |  | 9195.46 | 1.637547671232876 | 22.76599356164383
6.5 |  |  |  |  |  |  | 2008-08-22 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 24.40354123287671
6.5 |  |  |  |  |  |  | 2008-08-23 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 26.04108890410959
6.5 |  |  |  |  |  |  | 2008-08-24 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 27.67863657534246
6.5 |  |  |  |  |  |  | 2008-08-25 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 29.31618424657534
6.5 |  |  |  |  |  |  | 2008-08-26 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 30.95373191780822
6.5 |  |  |  |  |  |  | 2008-08-27 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 32.59127958904109
6.5 |  |  |  |  |  |  | 2008-08-28 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 34.22882726027397
6.5 |  |  |  |  |  |  | 2008-08-29 00:00:00 | INTEREST | 39.14 |  | 9195.46 | 1.637547671232876 | 35.86637493150684
6.5 |  |  |  |  |  |  | 2008-08-30 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 37.50392260273971
6.5 |  |  |  |  |  |  | 2008-08-31 00:00:00 |  |  |  | 9195.46 | 1.637547671232876 | 39.14147027397259 | 18.01302438356164 | 39.1414702739726
6.5 |  |  |  |  |  |  | 2008-09-01 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-02 00:00:00 |  |  |  |  |  |  | 39.1414702739726
6.5 |  |  |  |  |  |  | 2008-09-03 00:00:00 |  |  |  |  | 10
6.5 |  |  |  |  |  |  | 2008-09-04 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-05 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-06 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-07 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-08 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-09 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-10 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-11 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-12 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-13 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-14 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-15 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-16 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-17 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-18 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-19 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-20 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-21 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-22 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-23 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-24 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-25 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-26 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-27 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-28 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-29 00:00:00
6.5 |  |  |  |  |  |  | 2008-09-30 00:00:00
6.5 |  |  |  |  |  |  | 2008-10-01 00:00:00
6.5 |  |  |  |  |  |  | 2008-10-02 00:00:00
6.5 |  |  |  |  |  |  | 2008-10-03 00:00:00
6.5 |  |  |  |  |  |  | 2008-10-04 00:00:00
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5
6.5