Spreadsheet: 204715d1357622277-how-to-calculate-interest-on-a-particular-period-interest-1-
Sheet: Interest

 | Invoice date | Invoice  no | Date invoice submitted | Payment due date | Total Amount | Payment date | Payment amount | Interest @ 9% pa
1 | 2009-01-16 00:00:00 | 01-09-0625 | 2009-02-10 00:00:00 | 2009-04-11 00:00:00 | 99744 | 2009-05-03 00:00:00 | 1964030
2 | 2009-01-31 00:00:00 | 01-09-0626 | 2009-02-10 00:00:00 | 2009-04-11 00:00:00 | 683422 | 2009-05-03 00:00:00 | 17083
3 | 2009-02-24 00:00:00 | 02-09-0642 | 2009-02-25 00:00:00 | 2009-04-26 00:00:00 | 1183766 | 2009-06-01 00:00:00 | 110658.47
4 | 2009-02-28 00:00:00 | 02-09-0720 | 2009-03-17 00:00:00 | 2009-05-16 00:00:00 | 1317224 | 2009-06-04 00:00:00 | 1317152
5 | 2009-03-08 00:00:00 | 03-09-0721 | 2009-03-18 00:00:00 | 2009-05-17 00:00:00 | 705510 | 2009-06-29 00:00:00 | 2051844
6 | 2009-03-24 00:00:00 | 03-09-0747 | 2009-03-31 00:00:00 | 2009-05-30 00:00:00 | 770718 | 2009-07-29 00:00:00 | 3938034
7 | 2009-03-31 00:00:00 | 03-09-0793 | 2009-04-01 00:00:00 | 2009-05-31 00:00:00 | 919092 | 2009-11-09 00:00:00 | 5134184
8 | 2009-03-31 00:00:00 | 04-09-0809 | 2009-04-22 00:00:00 | 2009-06-21 00:00:00 | 1333522 | 2010-04-04 00:00:00 | 5109826.32
9 | 2009-04-30 00:00:00 | 04-09-0845 | 2009-05-06 00:00:00 | 2009-07-05 00:00:00 | 913644 | 2010-12-22 00:00:00 | 340280
10 | 2009-04-30 00:00:00 | 04-09-0846 | 2009-05-06 00:00:00 | 2009-07-05 00:00:00 | 869876 | 2011-01-04 00:00:00 | 2500000
11 | 2009-04-30 00:00:00 | 04-09-0847 | 2009-05-06 00:00:00 | 2009-07-05 00:00:00 | 825414 | 2011-03-24 00:00:00 | 340290
12 | 2009-04-30 00:00:00 | 04-09-0931 | 2009-05-29 00:00:00 | 2009-07-28 00:00:00 | 1117762 | 2011-05-17 00:00:00 | 1500000
13 | 2009-05-24 00:00:00 | 05-09-0847 | 2009-05-24 00:00:00 | 2009-07-23 00:00:00 | 876984
14 | 2009-05-31 00:00:00 | 05-09-0935 | 2009-06-06 00:00:00 | 2009-08-05 00:00:00 | 818422
15 | 2009-06-01 00:00:00 | 06-09-0936 | 2009-06-06 00:00:00 | 2009-08-05 00:00:00 | 863424
16 | 2009-05-30 00:00:00 | 06-09-0938 | 2009-06-04 00:00:00 | 2009-08-03 00:00:00 | 1196694
17 | 2009-06-28 00:00:00 | 06-09-0953 | 2009-06-28 00:00:00 | 2009-08-27 00:00:00 | 965208
18 | 2009-06-29 00:00:00 | 06-09-0956 | 2009-06-30 00:00:00 | 2009-08-29 00:00:00 | 827064
19 | 2009-06-30 00:00:00 | 06-09-0961 | 2009-07-09 00:00:00 | 2009-09-07 00:00:00 | 1027320
20 | 2009-06-30 00:00:00 | 06-09-0995 | 2009-08-13 00:00:00 | 2009-10-12 00:00:00 | 1395444
21 | 2009-07-22 00:00:00 | 07-09-1001 | 2009-08-13 00:00:00 | 2009-10-12 00:00:00 | 709554
22 | 2009-07-27 00:00:00 | 07-09-1005 | 2009-08-13 00:00:00 | 2009-10-12 00:00:00 | 621930
23 | 2009-07-27 00:00:00 | 07-09-1006 | 2009-08-13 00:00:00 | 2009-10-12 00:00:00 | 547406
24 | 2009-07-31 00:00:00 | 07-09-1023 | 2009-08-13 00:00:00 | 2009-10-12 00:00:00 | 793762
25 | 2009-08-12 00:00:00 | 08-09-1103 | 2009-09-03 00:00:00 | 2009-11-02 00:00:00 | 586344
26 | 2009-08-31 00:00:00 | 08-09-1110 | 2009-09-13 00:00:00 | 2009-11-12 00:00:00 | 719268
 | 2009-08-31 00:00:00 | 08-09-1119 |  | 1900-02-28 00:00:00 | 765902
28 | 2009-09-21 00:00:00 | 09-09-1180 | 2009-12-09 00:00:00 | 2010-02-07 00:00:00 | 545856
30 | 2009-10-27 00:00:00 | 10-09-1197 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 354870
29 | 2010-05-15 00:00:00 | 12-09-1304 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 322632
31 | 2010-02-15 00:00:00 | 12-09-1305 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 249678
32 | 2010-02-15 00:00:00 | 12-09-1306 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 904888
33 | 2010-02-15 00:00:00 | 01-10-1316 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 636300
34 | 2010-02-15 00:00:00 | 01-10-1317 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 480482
35 | 2010-02-15 00:00:00 | 01-10-1318 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 470480
36 | 2010-01-25 00:00:00 | 01-10-1319 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 573308
37 | 2010-01-19 00:00:00 | 12-09-1307 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 401696
38 | 2010-01-19 00:00:00 | 12-09-1308 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 375576
39 | 2010-01-19 00:00:00 | 12-09-1309 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 424290
40 | 2010-01-19 00:00:00 | 12-10-1310 | 2010-03-02 00:00:00 | 2010-05-01 00:00:00 | 551700
41 | 2010-02-28 00:00:00 | 02-10-1368 | 2010-04-15 00:00:00 | 2010-06-14 00:00:00 | 421848
42 | 2010-02-28 00:00:00 | 02-10-1369 | 2010-04-15 00:00:00 | 2010-06-14 00:00:00 | 731414
43 | 2010-02-28 00:00:00 | 02-10-1370 | 2010-04-15 00:00:00 | 2010-06-14 00:00:00 | 494632
44 | 2010-02-28 00:00:00 | 02-10-1371 | 2010-04-15 00:00:00 | 2010-06-14 00:00:00 | 888080
45 | 2010-05-24 00:00:00 | 05-10-1558 | 2010-05-24 00:00:00 | 2010-07-23 00:00:00 | 514256
46 | 2010-05-24 00:00:00 | 05-10-1559 | 2010-05-24 00:00:00 | 2010-07-23 00:00:00 | 726652
47 | 2010-05-24 00:00:00 | 05-10-1560 | 2010-05-24 00:00:00 | 2010-07-23 00:00:00 | 899642
48 | 2010-05-24 00:00:00 | 05-10-1561 | 2010-05-24 00:00:00 | 2010-07-23 00:00:00 | 775668
49 | 2010-05-24 00:00:00 | 05-10-1562 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 358212
50 | 2010-05-24 00:00:00 | 05-10-1563 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 310092
51 | 2010-05-24 00:00:00 | 05-10-1564 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 295034
52 | 2010-05-24 00:00:00 | 05-10-1565 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 286590
53 | 2010-05-24 00:00:00 | 05-10-1566 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 258852
54 | 2010-05-24 00:00:00 | 05-10-1567 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 288200
55 | 2010-05-24 00:00:00 | 05-10-1568 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 350768
56 | 2010-05-24 00:00:00 | 05-10-1569 | 2010-05-26 00:00:00 | 2010-07-25 00:00:00 | 187278
57 | 2010-06-20 00:00:00 | 06-10-1633 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 63612
58 | 2010-06-20 00:00:00 | 06-10-1634 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 134792
59 | 2010-06-20 00:00:00 | 06-10-1635 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 114332
60 | 2010-06-20 00:00:00 | 06-10-1636 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 102012
61 | 2010-06-20 00:00:00 | 06-10-1637 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 70924
62 | 2010-06-20 00:00:00 | 06-10-1638 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 72304
63 | 2010-06-20 00:00:00 | 06-10-1639 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 62216
64 | 2010-06-20 00:00:00 | 06-10-1640 | 2010-06-24 00:00:00 | 2010-08-23 00:00:00 | 63920
65 | 2010-08-19 00:00:00 | 07-10-1765 | 2010-09-06 00:00:00 | 2010-11-05 00:00:00 | 50628
66 | 2010-08-19 00:00:00 | 07-10-1766 | 2010-09-06 00:00:00 | 2010-11-05 00:00:00 | 54556
67 | 2010-08-19 00:00:00 | 07-10-1767 | 2010-09-06 00:00:00 | 2010-11-05 00:00:00 | 38122
68 | 2010-08-19 00:00:00 | 07-10-1768 | 2010-09-06 00:00:00 | 2010-11-05 00:00:00 | 23520
69 | 2010-09-30 00:00:00 | 09-10-1830 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 28356
70 | 2010-09-30 00:00:00 | 09-10-1831 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 34054
71 | 2010-09-30 00:00:00 | 09-10-1832 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 31200
72 | 2010-09-30 00:00:00 | 09-10-1833 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 23828
73 | 2010-09-30 00:00:00 | 09-10-1834 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 17780
74 | 2010-09-30 00:00:00 | 09-10-1835 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 18840
75 | 2010-09-30 00:00:00 | 09-10-1836 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 15197
76 | 2010-09-30 00:00:00 | 09-10-1837 | 2010-10-06 00:00:00 | 2010-12-05 00:00:00 | 19902
77 | 2010-10-31 00:00:00 | 10-10-1947 | 2010-11-11 00:00:00 | 2011-01-10 00:00:00 | 5156
78 | 2010-10-31 00:00:00 | 10-10-1948 | 2010-11-11 00:00:00 | 2011-01-10 00:00:00 | 14200
79 | 2010-10-31 00:00:00 | 10-10-1949 | 2010-11-11 00:00:00 | 2011-01-10 00:00:00 | 11428
80 | 2010-10-31 00:00:00 | 10-10-1950 | 2010-11-11 00:00:00 | 2011-01-10 00:00:00 | 17208
81 | 2010-10-31 00:00:00 | 10-10-1951 | 2010-11-11 00:00:00 | 2011-01-10 00:00:00 | 19804
82 | 2010-11-14 00:00:00 | 11-10-1956 | 2010-11-25 00:00:00 | 2011-01-24 00:00:00 | 8780
83 | 2010-11-14 00:00:00 | 11-10-1957 | 2010-11-25 00:00:00 | 2011-01-24 00:00:00 | 18768
84 | 2010-11-14 00:00:00 | 11-10-1958 | 2010-11-25 00:00:00 | 2011-01-24 00:00:00 | 16152
85 | 2010-11-14 00:00:00 | 11-10-1959 | 2010-11-25 00:00:00 | 2011-01-24 00:00:00 | 14374
86 | 2010-12-30 00:00:00 | 12-10-2014 | 2010-12-30 00:00:00 | 2011-02-28 00:00:00 | 980832
87 | 2010-12-30 00:00:00 | 12-10-2015 | 2011-01-25 00:00:00 | 2011-03-26 00:00:00 | 18746
88 | 2010-12-30 00:00:00 | 12-10-2060 | 2011-01-25 00:00:00 | 2011-03-26 00:00:00 | 1695
89 | 2011-01-31 00:00:00 | 01-11-2017 | 2011-03-08 00:00:00 | 2011-05-07 00:00:00 | 6362
90 | 2011-02-27 00:00:00 | 02-11-2109 | 2011-04-19 00:00:00 | 2011-06-18 00:00:00 | 8320
91 | 2011-04-26 00:00:00 | 11-04-2202 | 2011-05-02 00:00:00 | 2011-07-01 00:00:00 | 4356
 |  |  |  |  | 39719670
 | Add back credit for semi skilled men |  |  |  | 324252
 | Add interest for late payment