NonStopLeo
New Member
- Joined
- Mar 25, 2010
- Messages
- 38
Dear Friends
I need a formula to amortize my expenses in below sheet. I want in Column L monthly amortization on the basis, if full month is used then it should calculate for 30 days, if not full month then calculate based on day used in that month.
Days in year base should be 30 days. Kindly help.
[TABLE="width: 1226"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2"]COMPANY NAME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]INSURANCE AMORTIZATION[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Opening[/TD]
[TD][/TD]
[TD][/TD]
[TD] Closing [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[TD]28-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cost[/TD]
[TD="colspan: 2"]Opening[/TD]
[TD="colspan: 2"] Closing [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S.No[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Ref No[/TD]
[TD]Description[/TD]
[TD]No of Days[/TD]
[TD]AMOUNT[/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD] Charge for the Month [/TD]
[TD] Prepaid Balance [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1-Oct-17[/TD]
[TD]31-Dec-17[/TD]
[TD]BPV-8417[/TD]
[TD]ADCO Fujairah[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]11-Oct-17[/TD]
[TD]7-Feb-18[/TD]
[TD]BPV-8489[/TD]
[TD]Mirfa Land - Bouroge[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 110.00[/TD]
[TD] 5,243.97[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 286.03[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6-Feb-17[/TD]
[TD]5-Feb-18[/TD]
[TD]6677[/TD]
[TD]01/4102/41/2017/50[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 355.00[/TD]
[TD] 2,681.78[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 30.22[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]15763[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 330.00[/TD]
[TD] 2,052.10[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 167.90[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]15-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]14988[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 316.00[/TD]
[TD] 2,977.59[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 254.41[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1-Apr-17[/TD]
[TD]31-Mar-18[/TD]
[TD]W/C[/TD]
[TD]01/1151/11/2016/38[/TD]
[TD] 360.00[/TD]
[TD] 4,588.00[/TD]
[TD] 300.00[/TD]
[TD] 3,823.33[/TD]
[TD] 330.00[/TD]
[TD] 4,205.67[/TD]
[TD] 382.33[/TD]
[TD] 382.33[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]11-Jul-17[/TD]
[TD]28-Feb-18[/TD]
[TD]78427[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 227.00[/TD]
[TD] 1,681.13[/TD]
[TD] 200.00[/TD]
[TD] 1,481.17[/TD]
[TD] 227.00[/TD]
[TD] 1,681.13[/TD]
[TD] 199.96[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]20-Jul-17[/TD]
[TD]15-Jan-18[/TD]
[TD]99609[/TD]
[TD]01/4102/41/2017/251[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]28-Jul-17[/TD]
[TD]25-Jan-18[/TD]
[TD]56570[/TD]
[TD]01/4102/41/2017/259[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]7-Aug-17[/TD]
[TD]30-Jul-18[/TD]
[TD]70691[/TD]
[TD]01/4102/41/2017/263[/TD]
[TD] 353.00[/TD]
[TD] 2,182.00[/TD]
[TD] 174.00[/TD]
[TD] 1,075.55[/TD]
[TD] 204.00[/TD]
[TD] 1,260.99[/TD]
[TD] 185.44[/TD]
[TD] 921.01[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]17-Aug-17[/TD]
[TD]16-Aug-18[/TD]
[TD]93187[/TD]
[TD]01/4102/41/2017/268[/TD]
[TD] 359.00[/TD]
[TD] 2,500.00[/TD]
[TD] 164.00[/TD]
[TD] 1,142.06[/TD]
[TD] 194.00[/TD]
[TD] 1,350.97[/TD]
[TD] 208.91[/TD]
[TD] 1,149.03[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]27-Aug-17[/TD]
[TD]26-Aug-18[/TD]
[TD]87816[/TD]
[TD]01/4102/41/2017/287[/TD]
[TD] 359.00[/TD]
[TD] 6,050.00[/TD]
[TD] 154.00[/TD]
[TD] 2,595.26[/TD]
[TD] 184.00[/TD]
[TD] 3,100.84[/TD]
[TD] 505.57[/TD]
[TD] 2,949.16[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]25-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]85151[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 126.00[/TD]
[TD] 1,888.35[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 404.65[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]23-Aug-17[/TD]
[TD]15-Feb-18[/TD]
[TD]68521[/TD]
[TD]01/4102/41/2017/274[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 158.00[/TD]
[TD] 1,194.19[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 105.81[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]10-Sep-17[/TD]
[TD]9-Sep-18[/TD]
[TD]16999[/TD]
[TD]01/4102/41/2017/303[/TD]
[TD] 359.00[/TD]
[TD] 2,345.00[/TD]
[TD] 141.00[/TD]
[TD] 921.02[/TD]
[TD] 171.00[/TD]
[TD] 1,116.98[/TD]
[TD] 195.96[/TD]
[TD] 1,228.02[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]18-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]99717[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 133.00[/TD]
[TD] 885.28[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 179.72[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]30-Oct-17[/TD]
[TD]30-Apr-18[/TD]
[TD]54234[/TD]
[TD]05/4102/41/2017/191[/TD]
[TD] 180.00[/TD]
[TD] 2,470.00[/TD]
[TD] 91.00[/TD]
[TD] 1,248.72[/TD]
[TD] 121.00[/TD]
[TD] 1,660.39[/TD]
[TD] 411.67[/TD]
[TD] 809.61[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]26-Oct-17[/TD]
[TD]20-Apr-18[/TD]
[TD]68137[/TD]
[TD]05/4102/41/2017/189[/TD]
[TD] 174.00[/TD]
[TD] 2,308.00[/TD]
[TD] 95.00[/TD]
[TD] 1,260.11[/TD]
[TD] 125.00[/TD]
[TD] 1,658.05[/TD]
[TD] 397.93[/TD]
[TD] 649.95[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]26-Oct-17[/TD]
[TD]15-Oct-18[/TD]
[TD]98959[/TD]
[TD]05/4102/41/2017/175[/TD]
[TD] 349.00[/TD]
[TD] 1,728.00[/TD]
[TD] 95.00[/TD]
[TD] 470.37[/TD]
[TD] 125.00[/TD]
[TD] 618.91[/TD]
[TD] 148.54[/TD]
[TD] 1,109.09[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]2-Nov-17[/TD]
[TD]30-Apr-18[/TD]
[TD]75941[/TD]
[TD]05/4102/41/2017/193[/TD]
[TD] 178.00[/TD]
[TD] 1,922.00[/TD]
[TD] 89.00[/TD]
[TD] 961.00[/TD]
[TD] 118.00[/TD]
[TD] 1,274.13[/TD]
[TD] 313.13[/TD]
[TD] 647.87[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]10-Nov-17[/TD]
[TD]5-May-18[/TD]
[TD]53892[/TD]
[TD]05/4102/41/2017/197[/TD]
[TD] 175.00[/TD]
[TD] 2,416.00[/TD]
[TD] 81.00[/TD]
[TD] 1,118.26[/TD]
[TD] 110.00[/TD]
[TD] 1,518.63[/TD]
[TD] 400.37[/TD]
[TD] 897.37[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]9-Nov-17[/TD]
[TD]8-Dec-18[/TD]
[TD]96115[/TD]
[TD]05/4102/41/2017/198[/TD]
[TD] 389.00[/TD]
[TD] 1,790.00[/TD]
[TD] 82.00[/TD]
[TD] 377.33[/TD]
[TD] 111.00[/TD]
[TD] 510.77[/TD]
[TD] 133.44[/TD]
[TD] 1,279.23[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]67183[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 62.00[/TD]
[TD] 389.42[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 169.58[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]16574[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 62.00[/TD]
[TD] 390.11[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 169.89[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]6-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]97201[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 55.00[/TD]
[TD] 346.77[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 170.23[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]27-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]64160[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 64.00[/TD]
[TD] 960.70[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 405.30[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]11-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]26890[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 50.00[/TD]
[TD] 331.82[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 179.18[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]13-Dec-17[/TD]
[TD]12-Dec-18[/TD]
[TD]85170[/TD]
[TD]05/4102/41/2017/218[/TD]
[TD] 359.00[/TD]
[TD] 3,202.00[/TD]
[TD] 48.00[/TD]
[TD] 428.12[/TD]
[TD] 77.00[/TD]
[TD] 686.78[/TD]
[TD] 258.66[/TD]
[TD] 2,515.22[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]28-Dec-17[/TD]
[TD]27-Dec-18[/TD]
[TD]65705[/TD]
[TD]05/4102/41/2017/237[/TD]
[TD] 359.00[/TD]
[TD] 4,410.00[/TD]
[TD] 33.00[/TD]
[TD] 405.38[/TD]
[TD] 62.00[/TD]
[TD] 761.62[/TD]
[TD] 356.24[/TD]
[TD] 3,648.38[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]21-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]74061[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 40.00[/TD]
[TD] 174.33[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 117.67[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]TOTAL[/TD]
[TD] [/TD]
[TD] 69,702.13[/TD]
[TD] [/TD]
[TD] 44,777.09[/TD]
[TD] [/TD]
[TD] 51,515.85[/TD]
[TD] 6,738.75[/TD]
[TD] 18,186.28[/TD]
[/TR]
</tbody>[/TABLE]
I need a formula to amortize my expenses in below sheet. I want in Column L monthly amortization on the basis, if full month is used then it should calculate for 30 days, if not full month then calculate based on day used in that month.
Days in year base should be 30 days. Kindly help.
[TABLE="width: 1226"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 2"]COMPANY NAME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]INSURANCE AMORTIZATION[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Opening[/TD]
[TD][/TD]
[TD][/TD]
[TD] Closing [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[TD]28-Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cost[/TD]
[TD="colspan: 2"]Opening[/TD]
[TD="colspan: 2"] Closing [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S.No[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Ref No[/TD]
[TD]Description[/TD]
[TD]No of Days[/TD]
[TD]AMOUNT[/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD]No of Days[/TD]
[TD] Amortization [/TD]
[TD] Charge for the Month [/TD]
[TD] Prepaid Balance [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1-Oct-17[/TD]
[TD]31-Dec-17[/TD]
[TD]BPV-8417[/TD]
[TD]ADCO Fujairah[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] 90.00[/TD]
[TD] 3,600.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]11-Oct-17[/TD]
[TD]7-Feb-18[/TD]
[TD]BPV-8489[/TD]
[TD]Mirfa Land - Bouroge[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 110.00[/TD]
[TD] 5,243.97[/TD]
[TD] 116.00[/TD]
[TD] 5,530.00[/TD]
[TD] 286.03[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6-Feb-17[/TD]
[TD]5-Feb-18[/TD]
[TD]6677[/TD]
[TD]01/4102/41/2017/50[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 355.00[/TD]
[TD] 2,681.78[/TD]
[TD] 359.00[/TD]
[TD] 2,712.00[/TD]
[TD] 30.22[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]15763[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 330.00[/TD]
[TD] 2,052.10[/TD]
[TD] 357.00[/TD]
[TD] 2,220.00[/TD]
[TD] 167.90[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]15-Mar-17[/TD]
[TD]28-Feb-18[/TD]
[TD]14988[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 316.00[/TD]
[TD] 2,977.59[/TD]
[TD] 343.00[/TD]
[TD] 3,232.00[/TD]
[TD] 254.41[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1-Apr-17[/TD]
[TD]31-Mar-18[/TD]
[TD]W/C[/TD]
[TD]01/1151/11/2016/38[/TD]
[TD] 360.00[/TD]
[TD] 4,588.00[/TD]
[TD] 300.00[/TD]
[TD] 3,823.33[/TD]
[TD] 330.00[/TD]
[TD] 4,205.67[/TD]
[TD] 382.33[/TD]
[TD] 382.33[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]11-Jul-17[/TD]
[TD]28-Feb-18[/TD]
[TD]78427[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 227.00[/TD]
[TD] 1,681.13[/TD]
[TD] 200.00[/TD]
[TD] 1,481.17[/TD]
[TD] 227.00[/TD]
[TD] 1,681.13[/TD]
[TD] 199.96[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]20-Jul-17[/TD]
[TD]15-Jan-18[/TD]
[TD]99609[/TD]
[TD]01/4102/41/2017/251[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] 175.00[/TD]
[TD] 1,127.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]28-Jul-17[/TD]
[TD]25-Jan-18[/TD]
[TD]56570[/TD]
[TD]01/4102/41/2017/259[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] 177.00[/TD]
[TD] 3,226.00[/TD]
[TD] - [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]7-Aug-17[/TD]
[TD]30-Jul-18[/TD]
[TD]70691[/TD]
[TD]01/4102/41/2017/263[/TD]
[TD] 353.00[/TD]
[TD] 2,182.00[/TD]
[TD] 174.00[/TD]
[TD] 1,075.55[/TD]
[TD] 204.00[/TD]
[TD] 1,260.99[/TD]
[TD] 185.44[/TD]
[TD] 921.01[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]17-Aug-17[/TD]
[TD]16-Aug-18[/TD]
[TD]93187[/TD]
[TD]01/4102/41/2017/268[/TD]
[TD] 359.00[/TD]
[TD] 2,500.00[/TD]
[TD] 164.00[/TD]
[TD] 1,142.06[/TD]
[TD] 194.00[/TD]
[TD] 1,350.97[/TD]
[TD] 208.91[/TD]
[TD] 1,149.03[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]27-Aug-17[/TD]
[TD]26-Aug-18[/TD]
[TD]87816[/TD]
[TD]01/4102/41/2017/287[/TD]
[TD] 359.00[/TD]
[TD] 6,050.00[/TD]
[TD] 154.00[/TD]
[TD] 2,595.26[/TD]
[TD] 184.00[/TD]
[TD] 3,100.84[/TD]
[TD] 505.57[/TD]
[TD] 2,949.16[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]25-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]85151[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 126.00[/TD]
[TD] 1,888.35[/TD]
[TD] 153.00[/TD]
[TD] 2,293.00[/TD]
[TD] 404.65[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]23-Aug-17[/TD]
[TD]15-Feb-18[/TD]
[TD]68521[/TD]
[TD]01/4102/41/2017/274[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 158.00[/TD]
[TD] 1,194.19[/TD]
[TD] 172.00[/TD]
[TD] 1,300.00[/TD]
[TD] 105.81[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]10-Sep-17[/TD]
[TD]9-Sep-18[/TD]
[TD]16999[/TD]
[TD]01/4102/41/2017/303[/TD]
[TD] 359.00[/TD]
[TD] 2,345.00[/TD]
[TD] 141.00[/TD]
[TD] 921.02[/TD]
[TD] 171.00[/TD]
[TD] 1,116.98[/TD]
[TD] 195.96[/TD]
[TD] 1,228.02[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]18-Sep-17[/TD]
[TD]28-Feb-18[/TD]
[TD]99717[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 133.00[/TD]
[TD] 885.28[/TD]
[TD] 160.00[/TD]
[TD] 1,065.00[/TD]
[TD] 179.72[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]30-Oct-17[/TD]
[TD]30-Apr-18[/TD]
[TD]54234[/TD]
[TD]05/4102/41/2017/191[/TD]
[TD] 180.00[/TD]
[TD] 2,470.00[/TD]
[TD] 91.00[/TD]
[TD] 1,248.72[/TD]
[TD] 121.00[/TD]
[TD] 1,660.39[/TD]
[TD] 411.67[/TD]
[TD] 809.61[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]26-Oct-17[/TD]
[TD]20-Apr-18[/TD]
[TD]68137[/TD]
[TD]05/4102/41/2017/189[/TD]
[TD] 174.00[/TD]
[TD] 2,308.00[/TD]
[TD] 95.00[/TD]
[TD] 1,260.11[/TD]
[TD] 125.00[/TD]
[TD] 1,658.05[/TD]
[TD] 397.93[/TD]
[TD] 649.95[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]26-Oct-17[/TD]
[TD]15-Oct-18[/TD]
[TD]98959[/TD]
[TD]05/4102/41/2017/175[/TD]
[TD] 349.00[/TD]
[TD] 1,728.00[/TD]
[TD] 95.00[/TD]
[TD] 470.37[/TD]
[TD] 125.00[/TD]
[TD] 618.91[/TD]
[TD] 148.54[/TD]
[TD] 1,109.09[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]2-Nov-17[/TD]
[TD]30-Apr-18[/TD]
[TD]75941[/TD]
[TD]05/4102/41/2017/193[/TD]
[TD] 178.00[/TD]
[TD] 1,922.00[/TD]
[TD] 89.00[/TD]
[TD] 961.00[/TD]
[TD] 118.00[/TD]
[TD] 1,274.13[/TD]
[TD] 313.13[/TD]
[TD] 647.87[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]10-Nov-17[/TD]
[TD]5-May-18[/TD]
[TD]53892[/TD]
[TD]05/4102/41/2017/197[/TD]
[TD] 175.00[/TD]
[TD] 2,416.00[/TD]
[TD] 81.00[/TD]
[TD] 1,118.26[/TD]
[TD] 110.00[/TD]
[TD] 1,518.63[/TD]
[TD] 400.37[/TD]
[TD] 897.37[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]9-Nov-17[/TD]
[TD]8-Dec-18[/TD]
[TD]96115[/TD]
[TD]05/4102/41/2017/198[/TD]
[TD] 389.00[/TD]
[TD] 1,790.00[/TD]
[TD] 82.00[/TD]
[TD] 377.33[/TD]
[TD] 111.00[/TD]
[TD] 510.77[/TD]
[TD] 133.44[/TD]
[TD] 1,279.23[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]67183[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 62.00[/TD]
[TD] 389.42[/TD]
[TD] 89.00[/TD]
[TD] 559.00[/TD]
[TD] 169.58[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]29-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]16574[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 62.00[/TD]
[TD] 390.11[/TD]
[TD] 89.00[/TD]
[TD] 560.00[/TD]
[TD] 169.89[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]6-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]97201[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 55.00[/TD]
[TD] 346.77[/TD]
[TD] 82.00[/TD]
[TD] 517.00[/TD]
[TD] 170.23[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]27-Nov-17[/TD]
[TD]28-Feb-18[/TD]
[TD]64160[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 64.00[/TD]
[TD] 960.70[/TD]
[TD] 91.00[/TD]
[TD] 1,366.00[/TD]
[TD] 405.30[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]11-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]26890[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 50.00[/TD]
[TD] 331.82[/TD]
[TD] 77.00[/TD]
[TD] 511.00[/TD]
[TD] 179.18[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]13-Dec-17[/TD]
[TD]12-Dec-18[/TD]
[TD]85170[/TD]
[TD]05/4102/41/2017/218[/TD]
[TD] 359.00[/TD]
[TD] 3,202.00[/TD]
[TD] 48.00[/TD]
[TD] 428.12[/TD]
[TD] 77.00[/TD]
[TD] 686.78[/TD]
[TD] 258.66[/TD]
[TD] 2,515.22[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]28-Dec-17[/TD]
[TD]27-Dec-18[/TD]
[TD]65705[/TD]
[TD]05/4102/41/2017/237[/TD]
[TD] 359.00[/TD]
[TD] 4,410.00[/TD]
[TD] 33.00[/TD]
[TD] 405.38[/TD]
[TD] 62.00[/TD]
[TD] 761.62[/TD]
[TD] 356.24[/TD]
[TD] 3,648.38[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]21-Dec-17[/TD]
[TD]28-Feb-18[/TD]
[TD]74061[/TD]
[TD]01/4111/41/2017/14[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 40.00[/TD]
[TD] 174.33[/TD]
[TD] 67.00[/TD]
[TD] 292.00[/TD]
[TD] 117.67[/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]TOTAL[/TD]
[TD] [/TD]
[TD] 69,702.13[/TD]
[TD] [/TD]
[TD] 44,777.09[/TD]
[TD] [/TD]
[TD] 51,515.85[/TD]
[TD] 6,738.75[/TD]
[TD] 18,186.28[/TD]
[/TR]
</tbody>[/TABLE]