Spreadsheet: 754771d1636492557-calculating-8-threads-cash-flow-template-r1
Sheet: Monthly Actual

Phase | Phase Description | Year | Year Amount | January | February | March | April | May | June | July | August | September | October | November | December
9700 |  | 2020 | 0 |  |  |  |  |  |  |  |  |  | 167493.53 | 88300.44 | -255793.97
AC0002 |  | 2021 | 1522.5 |  |  |  | 1522.5
AC0004 |  | 2021 | 9920.4 |  |  |  |  | 9920.4
AC0005 |  | 2021 | 12362.91 |  | 7208.89 |  |  |  | 5154.02
AC0006 |  | 2021 | 12100 |  | 12100
AC0007 |  | 2021 | 3602.5 |  | 3602.5
AC0008 |  | 2021 | -5965.43 |  |  |  |  |  | -6272.53 |  |  | 307.1
AC0009 |  | 2021 | 650 |  |  |  |  |  | 650
AC0011 |  | 2021 | 6320 |  |  |  |  |  |  |  | 6320
AC0015 |  | 2021 | 19463.43 |  |  |  | 18605.43 | 858
AC0016 |  | 2021 | 1958.25 |  |  |  |  |  |  |  | 1958.25
AC0017 |  | 2021 | 72965.52 |  |  |  |  |  |  |  | 2796.95 | 70168.57
AC0020 |  | 2021 | 1634.85 |  |  |  |  |  |  |  | 1634.85
AC0021 |  | 2021 | 0 |  |  |  |  |  |  |  |  |  | 0
AC0022 |  | 2021 | -2850 |  |  |  |  |  |  |  |  | -2850
AC0023 |  | 2021 | 29267.7 |  |  |  |  |  |  |  |  | 29267.7
AC2001 |  | 2020 | 6000 |  |  |  |  |  |  |  |  |  |  | 6000
AC2001 |  | 2021 | 4056 |  | 4056
AC2002 |  | 2021 | 5500 |  | 5500
AC2003 |  | 2021 | 26957.98 |  |  |  |  | 19370 | 37.98 |  |  | 4300 | 3250
AC2004 |  | 2020 | 4250 |  |  |  |  |  |  |  |  |  |  | 4250
AC2009 |  | 2021 | 350 |  | 350
AC2011 |  | 2021 | 17251.58 | 1598.42 | -1349.07 | 14797.94 |  | 1635.36 | 568.93
AC2012 |  | 2021 | 560 |  |  | 560
AC2014 |  | 2021 | 1080 |  | 1080
AC2035 |  | 2021 | 804.72 |  |  |  |  |  |  | 804.72
AC3015 |  | 2021 | 11032.38 |  |  | 360 |  | 2811.23 | 1725 | 2647 | 796.25 | 1352.9 | 1340
AC3032 |  | 2021 | 1252.78 |  |  |  |  |  | 434.78 | 818
AC5001 |  | 2021 | -500 |  |  |  |  |  | -500
AC5010 |  | 2021 | -1000 |  |  |  |  |  | -1000
AC5017 |  | 2021 | 2187.5 |  |  |  | 2187.5
AC5018 |  | 2021 | 15560 |  |  | 15560
AC5028 |  | 2021 | 1700 |  |  |  |  |  |  |  |  | 1700
ADMTEL.01 |  | 2020 | 383.63 |  |  |  |  |  |  |  |  |  |  | 153 | 230.63
ADMTEL.01 |  | 2021 | 3377.09 |  | 102 | 2098.12 |  | 102 |  |  |  | 1074.97
ADMTI.01 |  | 2020 | 730.88 |  |  |  |  |  |  |  |  | 219.4 | 219.4 | 292.08
ADMTI.01 |  | 2021 | 1186.59 |  |  |  | 1186.59
COVID19 |  | 2020 | 134.7 |  |  |  |  |  |  |  |  |  | 37.1 |  | 97.6
COVID19 |  | 2021 | 8507.93 | 2409.3 |  | 3269 | 1838.85 | 1255.32 | 1476.84 | 17.52 |  | -1758.9
E0020 |  | 2020 | 12110 |  |  |  |  |  |  |  |  | 12110
E0030 |  | 2020 | 19709 |  |  |  |  |  |  |  |  | 19709
E0030 |  | 2021 | 27967 |  |  |  | 9150 |  |  | 10687 |  |  | 8130
E0130 |  | 2020 | 5839.61 |  |  |  |  |  |  |  |  | 155.75 | 1983.33 | 1513.8 | 2186.73
E0130 |  | 2021 | 18273.1 | 1651.12 | 1540.76 | 1641.45 | 5287.81 | 2758.25 | 2637.88 | 2008.95 | 1190.26 | -443.38
[NAME] |  | 2020 | 38326.11 |  |  |  |  |  |  |  |  | 7861 | 10362.05 | 8932.6 | 11170.46
[NAME] |  | 2021 | 29947.15 | 9910.76 | 9817.36 | 5562.96 | 1767.17 | 1312.4 | 1261.2 | 315.3
E0133 |  | 2020 | 5790.03 |  |  |  |  |  |  |  |  | 1318.65 | 2593.4 | 1877.98
E0133 |  | 2021 | 420 |  |  |  |  |  |  | 420
E0149 |  | 2020 | 450.47 |  |  |  |  |  |  |  |  |  |  | 450.47
E0149 |  | 2021 | 35019.34 | 16624.98 | 113.98 | 5637.84 |  | 8885.83 | 3756.71
E0151.01 |  | 2020 | 256.29 |  |  |  |  |  |  |  |  | 26.68 | 122.09 | 61.44 | 46.08
E0151.01 |  | 2021 | 2195.73 | 895.93 | 519.52 | 720.76 | 59.52
E0151.02 |  | 2020 | 165.75 |  |  |  |  |  |  |  |  |  |  |  | 165.75
E0151.02 |  | 2021 | 2173.77 |  | 373.77 |  | 1800
E0152 |  | 2020 | 287.55 |  |  |  |  |  |  |  |  |  |  | 287.55
E0152 |  | 2021 | 6262.28 | 795 | 3552 | 0 |  | 57.14 | 1858.14
E0153 |  | 2020 | 2839.88 |  |  |  |  |  |  |  |  |  | 1800 | 1031.34 | 8.54
E0153 |  | 2021 | 8408.25 | 1004.5 | 495 | 4247.5 |  | 2016.25 |  | 255 | 390
E0156 |  | 2020 | 3172.96 |  |  |  |  |  |  |  |  |  | 3068.19 | 38.4 | 66.37
E0156 |  | 2021 | 2107.22 | 1066.32 | 717.66 | 142.14 | 37.2 | 127.63 | 16.27
E0162 |  | 2021 | 89.29 |  |  | 89.29
E0164 |  | 2021 | 3350.24 | 466.46 | 0 | 421.72 | 791.74 |  | 995.66 | 396.19 |  | 278.47
[NAME] |  | 2020 | 14939.78 |  |  |  |  |  |  |  |  | 4173.38 | 4613.94 | 4843.56 | 1308.9
[NAME] |  | 2021 | 12377.71 | 2377.66 | 2096.29 | 4758.73 | 1943.08 | 429.64 | 80.93 | 530.55 | 184.14 | -14.62 | -8.69
E0170 |  | 2021 | 11.19 |  | 11.19
E0189 |  | 2020 | 2421.13 |  |  |  |  |  |  |  | 172.2 | 1321.48 | 832.3 | 38.38 | 56.77
E0189 |  | 2021 | 8196.62 | 1650.65 | 470.97 | 989.3 | 3951.84 | 1096.58 |  |  |  | 37.28
[NAME] |  | 2020 | 3632.57 |  |  |  |  |  |  |  |  |  | 518.43 | 1333.66 | 1780.48
[NAME] |  | 2021 | 15250.73 | 7268.35 | 722.27 | 7936.33 | -814.27 |  | 138.05
E0195 |  | 2020 | 2500 |  |  |  |  |  |  |  |  |  |  | 2500
E0195 |  | 2021 | 650.39 | 550.3 |  |  |  |  | 100.09
E0221 |  | 2020 | 1000 |  |  |  |  |  |  |  |  | 1000
E0221 |  | 2021 | 4962.5 | 4962.5
E0310 |  | 2020 | 30000 |  |  |  |  |  |  |  |  |  |  | 30000
E0310 |  | 2021 | 117620 |  | 70000 |  | 25000 | 22620
E0315 |  | 2020 | 3611.15 |  |  |  |  |  |  |  |  |  |  | 3494.65 | 116.5
E0315 |  | 2021 | 7428.92 |  | 207.96 | 2368.88 | 979.2 | 2794.57 | 353 | 725.31
E0320 |  | 2021 | 73485 | 70350.75 |  | 3134.25
E0330 |  | 2020 | 33929.26 |  |  |  |  |  |  |  |  |  | 13757.13 | 20172.13
E0330 |  | 2021 | 49190.89 | 32429.75 | 13316.99 | 3444.15
E0335 |  | 2020 | 30.39 |  |  |  |  |  |  |  |  |  | 30.39
E0335 |  | 2021 | 6050 |  | 2150 |  |  | 1100 |  |  |  | 2800
E0405 |  | 2020 | 15793.18 |  |  |  |  |  |  |  |  |  |  | 15793.18
E0405 |  | 2021 | 134206.82 | 79039.62 |  | 21502.92 | 33664.28
E0550 |  | 2020 | 2120.4 |  |  |  |  |  |  |  |  |  | 2120.4
E0550 |  | 2021 | 6487.6 |  |  | 6487.6
E0610 |  | 2020 | 166.49 |  |  |  |  |  |  |  |  |  |  |  | 166.49
E0610 |  | 2021 | 67693.95 | 5774.04 | 4129.17 | 11744.43 | 6802.71 | 11644.06 | 7507.47 | 1704.33 | 12669.9 | 592.84 | 5125
E0640 |  | 2021 | 5270 |  |  | 5270
E0729 |  | 2021 | 12500 | 7200 |  | 5300
E0736 |  | 2021 | 18495 |  | 8300 |  | 8200 |  | 1995
E0751 |  | 2021 | 344.96 |  |  |  |  |  |  |  | 344.96
E0810 |  | 2021 | 15995 | 15995
E0920 |  | 2021 | 6000 |  |  |  |  | 6000
E0962 |  | 2021 | 2313 |  |  |  |  |  |  | 1873.53 |  | 439.47
E0991 |  | 2021 | 6650 |  |  | 3750 |  | 1570 |  | 1330
E1044 |  | 2021 | 1856.5 |  |  |  |  |  | 1856.5
E1090 |  | 2021 | 700 |  |  |  |  | 700
E2201 |  | 2021 | 672400 |  |  |  | 354200 | 209345 | 14355 |  |  | 94500
E2205.01 |  | 2020 | 72876.75 |  |  |  |  |  |  |  |  |  |  |  | 72876.75
E2205.01 |  | 2021 | 214631 |  |  | 24662 | 174836 | 15133
E2605.01 |  | 2021 | 290000 | 21005.95 |  | 87272.6 | 130318.79 |  | 42236 |  |  | 9166.66
E3105 |  | 2020 | 414406.35 |  |  |  |  |  |  |  |  | 0 |  |  | 414406.35
E3105 |  | 2021 | 75563.79 |  | 67955.98 | 2082.81 |  | 5525
E3231 |  | 2021 | 118750 | 88125 |  |  |  |  | 30625
REGULS |  | 2020 | 464773.11 |  |  |  |  |  |  |  | 37036.96 | -27922.38 | 26095.63 | 13342.54 | 416220.36
REGULS |  | 2021 | -464773.11 | -464773.11 | 158657.8 | 183959.66 | -251617.84 | -38550.67 | -28209.36 | 5207.3 | 197021.44 | -201363.6 | -25104.73