Spreadsheet: 820435d1678108347-excel-formula-for-inflation-adjusted-amounts-inflation-adjusted
Sheet: Sheet2

 |  |  | Kindly asking for excel formula for Inflation adjusted amounts  using inflation rate and conversion factor as shown in the desired solution - inflation adjusted columns
 |  |  |  |  |  |  | Desired Solution
 | Monrh | Indices | Inflation rate | Conversion factors |  |  | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted
 | 2021-12-01 00:00:00 | 2474.51 | 4.22 | 1.61 |  |  | 2022-01-01 00:00:00 |  | 2022-02-01 00:00:00 |  | 2022-03-01 00:00:00 |  | 2022-04-01 00:00:00 |  | 2022-05-01 00:00:00 |  | 2022-06-01 00:00:00 |  | 2022-07-01 00:00:00 |  | 2022-08-01 00:00:00 |  | 2022-09-01 00:00:00 |  | 2022-10-01 00:00:00 |  | 2022-11-01 00:00:00 |  | 2022-12-01 00:00:00
 | 2022-01-01 00:00:00 | 2608.79 | 5.43 | 1.52 |  | Retained Income / (Accumulated Loss) | 2618350
 | 2022-02-01 00:00:00 | 2698.89 | 3.45 | 1.47 |  | Revaluation Reserve | -6608757 | -23608914.80921052 |  | 0
 | 2022-03-01 00:00:00 | 2759.83 | 2.26 | 1.44 |  | Agri bank Loan (USD) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  | -64000000
 | 2022-04-01 00:00:00 | 2803.57 | 1.58 | 1.42 |  | AGRIBANK LOAN | -5223589 | -18660584.38815789 | 914999.61 | 2147448.064285714 | 416666.67 | 653935.1904166667 | 416666.67 | 463615.0271830986 | 416666.67 | 766908.2186956522 | 422167.37 | 1231586.011729323 | 333018.45 | 655790.1784615384 | 363199.18 | 1217443.65136 | 661426.78 |  | 1031397.73 |  | 1909328.65 |  | 2889777.26
 | 2022-05-01 00:00:00 | 2874.85 | 2.54 | 1.38 |  | BICC SCHOOLS OFFICE |  |  |  |  | -860000 | -1349722.222222222 | 120000 | 133521.1267605634 |  |  | 175000 | 510526.3157894736 |  |  | -2450000 | -8212400.000000001 | 700000 |  | -14000000 |  | 7975000 |  | 2040000
 | 2022-06-01 00:00:00 | 2986.44 | 3.88 | 1.33 |  | Accumulated depreciation | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2022-07-01 00:00:00 | 3062.93 | 2.56 | 1.3 |  | Motor Vehicles - @ Valuation | 2170000 | 7752039.47368421 |  | 0
 | 2022-08-01 00:00:00 | 3191.19 | 4.19 | 1.25 |  | Depreciation | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2022-09-01 00:00:00 | 3342.02 | 4.73 | 1.19 |  | Computer Equipment - Valuation | 2972958 | 10620501.27631579 | 34000 | 79795.91836734694 | 144423.88 | 226665.2561111111 | 26400 | 29374.64788732395 |  |  | 133000 | 387999.9999999999 | 52000 | 102400 | 105000 | 351960.0000000001 | 224000 |  | 351000
 | 2022-10-01 00:00:00 | 3555.9 | 6.4 | 1.12 |  | Depreciation | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 2022-11-01 00:00:00 | 3760.86 | 5.76 | 1.06 |  | Office Equipment - @  Valuation | 1267770 | 4528941.513157895 |  | 0 |  |  |  |  | 7000 | 12884.05797101449 |  |  |  |  | 139400 | 467268.8
 | 2022-12-01 00:00:00 | 3977.46 | 5.76 | 1 |  | Depreciation | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | Furniture & Fittings - @ Valuation | 1636609 | 5846570.309210526 |  | 0 | 67080 | 105278.3333333333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 796000
 |  |  |  |  |  | Depreciation | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | Other Fixed Assets - @ Valuation | 18800 | 67160.52631578947 |  | 0
 |  |  |  |  |  | Depreciation | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | Listed Shares - @ Valuation | 3845 | 13735.75657894737 |  | 0
 |  |  |  |  |  | Inventory Control Account | 4441631 | 15867142.32236842 |  | 0 |  |  |  |  |  |  |  |  |  |  | 12373631.83 | 41476413.89416 | 944359.7474 |  | 1978600.885 |  | 15513755.666 |  | 41831997.93
 |  |  |  |  |  | Customer Control Account |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7107180.02 | 23823267.42704 | 11177307.91 |  | 14033992.86 |  | 29892448.14 |  | -58118907.43
 |  |  |  |  |  | Staff Loans |  |  | 60000 | 140816.3265306122 |  |  | -30000 | -33380.28169014084 | 315000 | 579782.6086956522 | 240000 | 700150.3759398495 | -240000 | -472615.3846153846 | -210000 | -703920.0000000001 | 44800 |  | -240000 |  | 80000 |  | 565200
 |  |  |  |  |  | ALL POS FOREX |  |  |  |  |  |  |  |  |  |  |  |  | 1002.03 | 1973.228307692307 | -18770.56 | -62918.91712000001 | -16698452.89 |  | 2549824.42 |  | 1931265.61 |  | 14378251.59
 |  |  |  |  |  | Z B BANK 405 | 13894.6 | 49636.63026315789 | 98926 | 232173.2653061225 | 945322.5502 | 1483631.224619444 | 1913327.4 | 2128913.585915493 | 8321776.7311 | 15316893.40361884 | 2877998.3038 | 8395964.976499246 | 4429008.1716 | 8721739.16868923 | 774110.2 | 2594817.3904 | 23419639.2663 |  | 12578138.7454 |  | -537731.51 |  | -54715610.46
 |  |  |  |  |  | Z B BANK 200 | 241231.94 | 861769.3646052631 | 1232244.6 | 2892002.632653062 | -1038781.31 | -1630309.555972222 | -80740.54 | -89838.06563380282 | -321319.92 | -591414.9252173913 | 166232.1062 | 484947.7985383458 | -131784.81 | -259514.7027692308 | -28749.17 | -96367.21784 | 32977.3041 |  | 673857.1246 |  | -483471.21 |  | -203386.66
 |  |  |  |  |  | Z B BANK 406 |  |  |  |  |  |  |  |  | 365495.37 | 672723.362173913 | 907996.5 | 2648892.045112782 | 875871.52 | 1724793.147076923 | 1103477.85 | 3698857.753200001 | 2654987.46 |  | 953582.07 |  | 1629960.11 |  | -8140433.38
 |  |  |  |  |  | AGRIBANK 569 | 81787.61 | 292175.4751973684 | 133141.57 | 312475.1132653062 | -44566.29 | -69944.31625 | 371039.93 | 412847.2460563381 | 67817.17 | 124822.9071014493 | 138434.3 | 403853.4466165412 | -774361.52 | -1524896.531692308 | 776382.21 | 2602433.16792 | 18395856.63 |  | 1945204.51 |  | 491817.49 |  | -20852461.34
 |  |  |  |  |  | AGRIBANK 828 | 1681.12 | 6005.579999999999 | -3244.1 | -7613.704081632653 | 3265.24 | 5124.612777777777 | 6747.24 | 7507.492394366197 | 4217.24 | 7762.166376811595 | 67763.48 | 197685.9416541353 | 85320.67 | 168016.0886153846 | -163416.76 | -547772.97952 | -1282.76 |  | 27835.0088 |  | 42598.4876 |  | 37287.3473
 |  |  |  |  |  | CASH USD | 7159.93 | 25577.90782894737 | 58848 | 138112.6530612245 | -1833404 | -2877425.722222222 | -2346738 | -2611159.183098592 | -7009250 | -12901083.33333333 | -2727273 | -7956255.067669172 | -6370818 | -12545610.83076923 | 1710521 | 5733666.392000001 | -24756848 |  | -6077700 |  | -22779335.2 |  | 73489300.2989
 |  |  |  |  |  | CASH RAND | -35740.63 | -127678.6979605263 | 21780 | 51116.32653061225 | 13540 | 21250.27777777778 | -20437.5 | -22740.31690140845 | -290958.26 | -535531.8698550726 | -970434 | -2831040.541353383 | -716544 | -1411040.492307692 | -408092.25 | -1367925.222 | -1871564.06 |  | -617998.19 |  | -2193574.65 |  | 7457471.9109
 |  |  |  |  |  | CASH ZWL | 9403.97 | 33594.44546052631 | -2962.15 | -6951.984693877552 | 42274.33 | 66347.21236111112 | -9798.59 | -10902.65647887324 | -914.24 | -1682.731594202899 | -12630.74 | -36847.57233082706 | -11638.14 | -22918.18338461538 | 38276.34 | 128302.29168 | 203859.46 |  | 214640.6 |  | 107482.2 |  | -392805.92
 |  |  |  |  |  | AGRIBANK  USD 087 |  |  |  |  |  | 0 |  |  |  |  |  |  | -3500 | -6892.307692307691 | -3500 | -11732 | -3500 |  | 1751578.0912 |  | 15492217.7524 |  | -15129590.85
 |  |  |  |  |  | Bank Transfer | 40000 | 142894.7368421053 |  | 0 |  | 0 | 31900 | 35494.3661971831 |  |  |  |  |  |  |  |  | -0.0239 |  | -0.01 |  |  |  | -0.01
 |  |  |  |  |  | Supplier Control Account | 219109.81 | 782740.965986842 |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -9876064.79 | -33104569.17608 | -14533714.26 |  | -7135053.77 |  | 2056344.56 |  | -10435085.89
 |  |  |  |  |  | GRN Accrual Account |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | -111650 | -374250.8 | -161103 |  | -22082.97 |  | 258422
 |  |  |  |  |  | Acruals  - Staff allowances | -207500 | -741266.447368421 | 191000 | 448265.306122449 | -30000 | -47083.33333333334 | 67200 | 74771.8309859155 |  |  | -33200 | -96854.13533834585 | -913600 | -1799089.230769231 | -351758 | -1179092.816 | -161000 |  | 124500 |  | 62550 |  | 1251808
 |  |  |  |  |  | PAYE Control Account | 183028.96 | 653846.8768421052 | 33391.08 | 78366.82040816327 | -66729.18 | -104727.7408333333 | -45239.12 | -50336.48563380283 | -129678.66 | -238683.9104347827 | -147705.11 | -430899.1178947368 | 78128.35 | 153852.7507692308 | 29314.16 | 98261.06432 | 241233.95 |  | -330087.63 |  | -421319.47 |  | -456180.74
 |  |  |  |  |  | NSSA Control Account | -40978.4 | -146389.9421052632 | 196782.13 | 461835.6112244898 | -9803.78 | -15386.48805555556 | -14093.85 | -15681.88943661972 | -24739.71 | -45535.40826086957 | -108460.89 | -316412.2204511278 | -9187.61 | -18092.52430769231 | -142572.19 | -477901.98088 | -148701.6 |  | 108736.66 |  | -254416.27 |  | -192577.57
 |  |  |  |  |  | loan interest accrual | -1444166.67 | -5159095.406644736 | 236805.56 | 555768.1510204081 | 194444.44 | 305169.7461111111 | 193750 | 215580.985915493 | 166666.67 | 306763.2911594203 | 162847.22 | 475073.0929323308 | 137500 | 270769.2307692308 | 118402.78 | 396886.11856 | 94722.22 |  | 68750 |  | 47361.11 |  | 22916.67
 |  |  |  |  |  | ZIMDEF | -6142.22 | -21942.2727631579 | 11657.09 | 27358.47653061225 | 3967.43 | 6226.660972222222 | -9838.02 | -10946.52929577465 | -14504.01 | -26695.78652173913 | 3581.48 | 10448.22736842105 | -16482.23 | -32457.31446153846 | -25394.71 | -85123.06792 | 24773.55 |  | -42308.95 |  | -42119.29 |  | -44342.33
 |  |  |  |  |  | NEC Control | -23275.76 | -83149.59 | -13696.66 | -32145.2224489796 | -17844 | -28005.16666666667 | -16402.94 | -18251.15859154929 | -21686 | -39914.8115942029 | -21683.49 | -63257.09864661653 | -21682.68 | -42698.20061538462 | -28194.36 | -94507.49472000002 | -28180.28 |  | -44562.68 |  | -42526.54 |  | -33988.6
 |  |  |  |  |  | BONVIE MEDICAL AID | -55321 | -197626.9934210526 | -80206 | -188238.5714285714 | -80206 | -125878.8611111111 | -80207.08 | -89244.49746478874 | -127725.63 | -235089.2030434783 | -127725.85 | -372613.7578947368 | -127720.34 | -251510.8233846154 | -589959.11 | -1977542.93672 | -589964.62 |  | -589961.03 |  | -589961.03 |  | 3038957.69
 |  |  |  |  |  | STANDARD DEV FUND | -2824.02 | -10088.43986842105 | -2824.02 | -6627.802040816327 | -3694 | -5797.527777777777 | -4350.18 | -4840.341126760564 | -6391 | -11763.14492753623 | -7291.89 | -21272.58135338346 | -7364.49 | -14502.38030769231 | -9441.54 | -31648.04208000001 | -10373.37 |  | -17636.62 |  | -17567.09 |  | -18766.92
 |  |  |  |  |  | Leave days accrual |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2428772.21
 |  |  |  |  |  | Salary & Wages Control | -270704.24 | -967055.2784210525 | 421908.39 | 990193.1602040817 | 5000 | 7847.222222222222 | 24804.15 | 27598.9838028169 | -68038.54 | -125230.3562318841 | -380307.82 | -1109469.429774436 | -60388.57 | -118919.0301538461 | -1149081.55 | -3851721.3556 | 108890.26 |  | -1532401.98 |  | 2568726.1 |  | 331593.8
 |  |  |  |  |  | Taxation Payable | -440377 | -1573188.888157895 |  | 0
 |  |  |  |  |  | Dividends Payable |  |  |  |  | 365312.94 | 573338.3641666666 | 196496.86 | 218637.3512676056 | 245310 | 451512.6086956522 |  |  |  |  |  |  |  |  | 579895
 |  |  |  |  |  | Vat / Tax Control Account | 464720.09 | 1660151.374144737 | 374738.94 | 879489.3489795919 | 231358.5 | 363104.3125 | 680270 | 756920.1408450705 | 867345.5 | 1596418.528985507 | 1064578.5 | 3105687.654135338 |  |  | 831633.05 | 2787633.9836 | -1382413.33 |  | 337504.93 |  | 3123437.79 |  | 1193690.28
 |  |  |  |  |  | Intercompany -Bulawayo | -480524 | -1716608.763157895 | 2323160.25 | 5452314.87244898 | 3715868.27 | 5831848.812638889 | 1492781.69 | 1660982.443802817 | 1647006.94 | 3031447.556231884 | -1277049 | -3725526.406015037 | 6746075.91 | 13284580.25353846 | -3896223.21 | -13060140.19992 | 7669950.44 |  | -5207466.38 |  | -244449.47 |  | -1876442.31
 |  |  |  |  |  | Intercompany - Beitbridge | 104370.32 | 372849.2352631579 | -502889.26 | -1180250.304081633 | -522927.4 | -820705.5027777778 | -181615.73 | -202079.4742253521 | -1433686.5 | -2638814.282608696 | -172685.5 | -503774.2406015037 | -820352 | -1615462.4 | -833053.52 | -2792395.399040001 | -706345.68 |  | -1545890.44 |  | 973363.78 |  | -855117.77
 |  |  |  |  |  | Intercompany - Gwanda | -174513 | -623424.7302631579 | -644855.38 | -1513436.095918367 | -933199.4 | -1464604.613888889 | -504228.62 | -561043.1123943662 | -731920.58 | -1347158.168985507 | -1057545.44 | -3085170.155789473 | -1523247 | -2999624.861538461 | -834885 | -2798534.52 | -2695106.76 |  | -3121189.55 |  | -1749781 |  | 9230575.46
 |  |  |  |  |  | Intercompany - Gweru | -136504.9 | -487645.7940789473 | -587122.01 | -1377939.41122449 | -393527.19 | -617619.0620833334 | -274098 | -304982.2816901408 | -964568 | -1775364.289855073 | -281773.01 | -822014.4953383458 | -405364.01 | -798255.2812307692 | -971525.01 | -3256551.83352 | -126910.05 |  | -1048187.98 |  | -335440.01 |  | 3095354.82
 |  |  |  |  |  | Intercompany filabusi |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 153540.57 | 514667.9906400001 | 174775 |  | -926560 |  | -1683588.4 |  | 3925830.37
 |  |  |  |  |  | Opening Balance / Suspense Account | -1406724 | -5025336.394736842 | 487126.01 | 1143254.921428571 | 1277245.96 | 2004566.576111111 | 334629.61 | 372334.3547887324 | 243816.69 | 448764.0526086957 | 740000 | 2158796.992481203 |  |  |  |  |  |  |  |  |  |  | -1676094.09
 |  |  |  |  |  | Fuels & Oils-Motor Vehicles | 154600 | 552288.1578947369 | 125000 | 293367.3469387755 | 145200 | 227883.3333333333 | 124272 | 138274.4788732395 | 182000 | 334985.5072463768 | 265500 | 774541.3533834586 | 211000 | 415507.6923076923 | 255500 | 856436.0000000001 | 310100 |  | 147000 |  | 320000 |  | 329000
 |  |  |  |  |  | Licence fees 2023 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  | 942801.28
 |  |  |  |  |  | Generator |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1800
 |  |  |  |  |  | Finance & working capital charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Accounts management fees | 151787.99 | 542242.6221710526 | 285056.52 | 669010.2000000001 | 313441.52 | 491929.0522222223 | 228232.23 | 253948.5376056338 | 647845.47 | 1192411.227391304 | 499924.27 | 1458425.689924812 | 651126.93 | 1282219.185230769 | 326002.87 | 1092761.62024 | 866392.21 |  | 833031.29 |  | 2581021.7 |  | 485486.99
 |  |  |  |  |  | Working capital costs |  |  |  |  |  | 0 |  |  |  |  |  |  | 184722.22 | 363760.6793846154 | 251157.4 | 841879.6048000001 | 200925.93 |  | 145833.33 |  | 2020462.96 |  | 48611.1
 |  |  |  |  |  | Water & rates | 8284 | 29593.5 | 18571 | 43585 | 39270 | 61632.08333333334 | 25280 | 28128.45070422535 |  |  | 4880 | 14236.39097744361 |  |  |  |  |  |  | 400000
 |  |  |  |  |  | Electricity | 4900 | 17504.60526315789 | 6000 | 14081.63265306123 |  |  |  |  | 5000 | 9202.898550724638 | 6050 | 17649.62406015037 | 5000 | 9846.153846153846 | 5000 | 16760 | 13500 |  | 40125 |  | 43000 |  | 28595
 |  |  |  |  |  | Telephone bills | 23750 | 84843.75 | 36200 | 84959.1836734694 | 24000 | 37666.66666666666 | 25200 | 28039.43661971831 | 21500 | 39572.46376811594 | 29126.86 | 84971.59157894737 | 23000 | 45292.30769230769 | 60996 | 204458.592 | 91200 |  | 105500 |  | 121050 |  | 106200
 |  |  |  |  |  | Internet | 10492 | 37481.28947368421 | 7499 | 17599.69387755102 | 17500 | 27465.27777777778 | 21899 | 24366.49295774648 | 21000 | 38652.17391304348 | 22149 | 64615.12781954886 | 24949 | 49130.33846153846 | 25470 | 85375.44 | 27945 |  | 73310 |  | 41660 |  | 55000
 |  |  |  |  |  | Rentals |  |  |  |  | 266000 | 417472.2222222222 | 288000 | 320450.7042253522 | 227500 | 418731.8840579711 |  |  | 390000 | 768000 | 840000 | 2815680 | 815500 |  | 801500 |  | 2080000 |  | 1648000
 |  |  |  |  |  | Employees compensation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Employees basic salaries | 564811.3 | 2017714.051973684 | 564811.3 | 1325577.540816327 | 847968 | 1330838.666666667 | 872175.43 | 970448.717887324 | 1278723.28 | 2353592.124057971 | 1485241.28 | 4332884.335639097 | 1472533.94 | 2899759.143384615 | 1886564.74 | 6323765.00848 | 2072750.67 |  | 3527312.27 |  | 3647479.08 |  | 3757058.62
 |  |  |  |  |  | Casual lablour |  |  | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 78097.63 |  |  |  |  |  | 900
 |  |  |  |  |  | Canteen provision | 102154.28 | 364932.7239473684 | 85144.94 | 199829.9612244898 | 97104.98 | 152400.8713888889 | 129465.35 | 144052.9950704226 | 165617.15 | 304831.565942029 | 204549.99 | 596732.3016541352 | 271994.81 | 535620.548923077 | 281735.26 | 944376.5915200001 | 410193.29 |  | 483119.91 |  | 568791.7 |  | 514467.33
 |  |  |  |  |  | Casual labour |  |  | 4600 | 10795.91836734694 | 13982 | 21943.97222222222 | 13229.66 | 14720.32591549296 | 28750 | 52916.66666666667 | 27713.08 | 80847.1807518797 | 20500 | 40369.23076923077 | 57145.73 | 191552.48696 | 60703 |  | 75100 |  | 110670.3 |  | 243331.7
 |  |  |  |  |  | Employees bonus |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Employees welfare | 88419.25 | 315866.1365131579 | 151670 | 355960.2040816327 | 48000 | 75333.33333333333 | 394774.17 | 439255.7666197183 | 323000 | 594507.2463768116 | 80000 | 233383.4586466165 | 170700 | 336147.6923076923 | 172060 | 576745.1200000001 | 992877.07 |  | 162000 |  | 212750 |  | 212800
 |  |  |  |  |  | Employees medical aid | 127660.5 | 456050.3388157894 | 259461 | 608939.0816326531 | 160412 | 251757.7222222222 | 192491.08 | 214180.2157746479 | 264267.63 | 486405.637826087 | 127725.85 | 372613.7578947368 | 294866.34 | 580659.8695384616 | 589959.11 | 1977542.93672 | 589964.62 |  | 589961.03 |  | 589961.03 |  | -3038957.69
 |  |  |  |  |  | Employees transport expenses | 135020 | 482341.1842105263 | 140000 | 328571.4285714286 | 195500 | 306826.3888888889 | 228300 | 254023.9436619719 | 305450 | 562205.0724637682 | 458925 | 1338818.796992481 | 752350 | 1481550.769230769 | 709750 | 2379082 | 616125 |  | 638005 |  | 699250 |  | 809375
 |  |  |  |  |  | Employees training |  |  |  |  |  | 0 |  |  | 40358.5 | 74283.03623188406 | 40000 | 116691.7293233083 | 26800 | 52775.38461538461 | 28000 | 93856.00000000001 | 121881.8
 |  |  |  |  |  | EmployeesOvertime |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 4900
 |  |  |  |  |  | Employees residency allowances | 68000 | 242921.0526315789 | 188000 | 441224.4897959184 | 81600 | 128066.6666666667 | 102000 | 113492.9577464789 | 259000 | 476710.1449275363 | 256000 | 746827.0676691729 | 352000 | 693169.2307692308 | 413000 | 1384376 | 308000 |  | 518000 |  | 308000 |  | 396000
 |  |  |  |  |  | Employees leave days |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2428772.21
 |  |  |  |  |  | Statutory deductions |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Standard development fund | 1670.43 | 5967.391381578947 | 2824.02 | 6627.802040816327 | 3694 | 5797.527777777777 | 4350.18 | 4840.341126760564 | 6391 | 11763.14492753623 | 7291.89 | 21272.58135338346 | 7364.49 | 14502.38030769231 | 9441.54 | 31648.04208000001 | 10373.37 |  | 17636.62 |  | 17567.09 |  | 21942.86
 |  |  |  |  |  | ZimDEF | 7295.88 | 26063.57131578947 | 6273.21 | 14722.83979591837 | 8448 | 13258.66666666667 | 9838.02 | 10946.52929577465 | 14504.01 | 26695.78652173913 | 16335.13 | 47654.36421052631 | 16482.23 | 32457.31446153846 | 25394.71 | 85123.06792 | 27272.83 |  | 42308.95 |  | 42119.29 |  | 44342.33
 |  |  |  |  |  | Employees NEC | 6848.33 | 24464.75782894737 | 6848.27 | 16072.47040816327 | 8922 | 14002.58333333333 | 8201.47 | 9125.579295774647 | 10843 | 19957.40579710145 | 10841.74 | 31628.5347368421 | 10841.34 | 21349.10030769231 | 14097.18 | 47253.74736000001 | 14090.14 |  | 22279.84 |  | 19763.27 |  | 13818.36
 |  |  |  |  |  | Employees NSSA | 28808.8 | 102915.6473684211 | 29466.16 | 69155.27346938776 | 35450 | 55636.80555555555 | 42553.71 | 47348.49422535211 | 56381.54 | 103774.7185507246 | 61562.22 | 179595.0478195488 | 61537.33 | 121181.2036923077 | 79979.52 | 268091.35104 | 83422.07 |  | 142210.63 |  | 143267.58 |  | 108035.74
 |  |  |  |  |  | Repairs & Maintanance |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Buildings | 51660 | 184548.5526315789 | 16650 | 39076.5306122449 | 18270 | 28673.75 | 49428 | 54997.35211267606 |  |  | 269200 | 785335.3383458646 | 12300 | 24221.53846153846 | 98720 | 330909.44 | 28000 |  | 140000 |  | 198190 |  | 80000
 |  |  |  |  |  | Electricals | 360 | 1286.052631578947 |  | 0 |  |  |  |  |  |  | 15400 | 44926.31578947368 |  |  | 24675 | 82710.6 |  |  |  |  | 126380
 |  |  |  |  |  | Motor vehicles | 29507 | 105409.875 | 129600 | 304163.2653061225 | 70800 | 111116.6666666667 | 16500 | 18359.15492957747 | 112000 | 206144.9275362319 | 52788.92 | 154000.7590977443 | 173100 | 340873.8461538461 | 187720 | 629237.4400000001 |  |  | 67449.58 |  | 328000 |  | 762400
 |  |  |  |  |  | Compuer equipment | 4500 | 16075.65789473684 | 12000 | 28163.26530612245 |  |  | 3000 | 3338.028169014085 | 490 | 901.8840579710146 |  |  |  |  | 204400 | 685148.8 | 96500 |  | 7000 |  | 16000 |  | -139490
 |  |  |  |  |  | Furniture & fittings | 3180 | 11360.13157894737 |  | 0 |  |  |  |  |  |  | 38800 | 113190.977443609 |  |  | 70000 | 234640 |  |  |  |  | 264000 |  | 220548
 |  |  |  |  |  | Administration costs |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Accounting & Audit fees |  |  |  | 0 |  | 0 |  |  | 2315360 | 4261604.63768116 | 779250 | 2273300.751879699 | 454000 | 894030.7692307691 | 59500 | 199444 | 160747 |  | 148000 |  | 54400
 |  |  |  |  |  | Advertising & promotion |  |  |  | 0 |  | 0 |  |  |  |  |  |  | 40000 | 78769.23076923077 | 115500 | 387156.0000000001 | 14000 |  | 131000
 |  |  |  |  |  | Donations |  |  |  | 0 |  | 0 |  |  |  |  | 16850 | 49156.3909774436 |  |  |  | 0 |  |  | 70000 |  |  |  | 88113
 |  |  |  |  |  | Insurance & Licenses | 74702.63 | 266865.316381579 | 182339 | 427938.4693877551 | 45275 | 71056.59722222222 |  |  | 64122 | 118021.6521739131 | 53550 | 156221.0526315789 | 20000 | 39384.61538461538 | 154000 | 516208.0000000001 | 72090 |  | 29000 |  | 412136 |  | 1681616.32
 |  |  |  |  |  | Postage & Corrier |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 27300 | 91509.6 | 60700 |  | 29400 |  | 32800 |  | 34000
 |  |  |  |  |  | Stationary & Printing | 7710 | 27542.96052631579 | 14363.64 | 33710.58367346939 | 13580 | 21313.05555555555 | 30963.62 | 34452.4785915493 | 24349.95 | 44818.02391304349 | 50385.34 | 146988.8114285714 | 38244.19 | 75311.6356923077 | 107865.01 | 361563.51352 | 100160 |  | 111480 |  | 200709.72 |  | 187317.6
 |  |  |  |  |  | Security expenses |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Traveling & Subsistance | 38900 | 138965.1315789474 | 12760 | 29946.93877551021 | 24120 | 37855 | 83500 | 92908.45070422535 | 33635 | 61907.89855072465 | 42440 | 123809.9248120301 | 89460 | 176167.3846153846 | 812059.98 | 2722025.05296 | 293894.16 |  | 586530 |  | 849928 |  | 1120400
 |  |  |  |  |  | Capacity development-Seniour management |  |  | 117534 | 275845.1020408163 |  |  |  |  |  |  |  |  |  |  |  | 0 | 4800
 |  |  |  |  |  | Board members compensation | 51848.51 | 185221.9798026316 |  | 0 | 73795.17 | 115817.4195833333 | 71184.44 | 79205.221971831 | 33250 | 61199.27536231885 | 94100 | 274517.2932330827 | 323449.92 | 636947.5347692308 | 56000 | 187712 | 7000 |  | 569208 |  | 32000 |  | 1185784.96
 |  |  |  |  |  | Cleaning expenses | 225 | 803.7828947368421 | 5000 | 11734.69387755102 | 4000 | 6277.777777777777 | 6295 | 7004.295774647888 |  |  | 9200 | 26839.0977443609 |  |  | 28297 | 94851.54400000001 | 42000 |  | 51740 |  | 72900 |  | 114400
 |  |  |  |  |  | Carriage outwards | 22000 | 78592.1052631579 | 25000 | 58673.4693877551 | 4400 | 6905.555555555556 | 40800 | 45397.18309859155 | 34300 | 63131.88405797102 | 37750 | 110127.8195488722 | 36000 | 70892.30769230769 | 4900 | 16424.8 | 97200 |  | 15400 |  | 14600 |  | 26500
 |  |  |  |  |  | Parking fees | 360 | 1286.052631578947 |  | 0 | 3400 | 5336.111111111111 | 1200 | 1335.211267605634 | 2070 | 3810 | 1760 | 5134.436090225563 | 4550 | 8960 | 8400 | 28156.8 | 19070 |  | 9800 |  | 9900 |  | 5850
 |  |  |  |  |  | Computer expenses | 10800 | 38581.57894736842 | 10810.9 | 25372.52040816327 | 10986.43 | 17242.59152777778 | 12000 | 13352.11267605634 | 10500 | 19326.08695652174 | 130000 | 379248.1203007518 | 12000 | 23630.76923076923 | 107100 | 358999.2 | 87500 |  | 80500 |  | 128000 |  | 463170
 |  |  |  |  |  | profit/loss foreign exchange |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2438137.75
 |  |  |  |  |  | Sales |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Bookshop | -3680924 | -13149616.65789474 | -19777672 | -46416985.30612245 | -13634353 | -21398359.56944444 | -14179168 | -15776820.73239437 | -23914167 | -44015930.5652174 | -11941091 | -34835663.96992481 | -11021935 | -21704733.53846154 | 7904667.71 | 26496446.16392 | 9293428.17 |  | 4609568.87 |  | 19199169.03 |  | 42397106.01
 |  |  |  |  |  | Groceries |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -23012532.9 | -77138010.2808 | -48560348.21 |  | -20767944.6 |  | -32188653.61 |  | -76304539.71
 |  |  |  |  |  | Bookshop |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -2388349.79 | -8005748.496080001 | -1884557.79 |  | -1536553.02 |  | -2132510.18 |  | -1204771.3
 |  |  |  |  |  | Groceries |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -3056.77 | -10246.29304 | -178115.72 |  | -23812.23 |  | -188646.28 |  | -4290453.13
 |  |  |  |  |  | Bookshop |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | -70000 |  | -39245.41
 |  |  |  |  |  | Cost of Sales / Purchases |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Bookshop | 2187188 | 7813441.342105263 | 12471414 | 29269645.10204082 | 9704607 | 15230841.54166667 | 9272968 | 10317809.46478873 | 16248287 | 29906267.3768116 | 7455309 | 21749322.4962406 | 6889532 | 13567078.4 | -322874.88 | -1082276.59776 | -3096798.79 |  | -1895511.895 |  | -16599782.156 |  | -28300892.36
 |  |  |  |  |  | Groceries |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 8715260.56 | 29213553.39712 | 31127137.38 |  | 10729560.37 |  | 25389891.52 |  | 48744525.02
 |  |  |  |  |  | Hardware |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 2129161.64 | 7136949.817280001 | 1580843.82 |  | 1283101.55 |  | 1742994.33 |  | 876462.95
 |  |  |  |  |  | Uniforms |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 62286 |  | 4893 |  |  |  | 2562500
 |  |  |  |  |  | ITC |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 70000
 |  |  |  |  |  | Inventory Adjustment |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -471149.79 | -1579294.09608 | 15000 |  |  |  |  |  | -818960
 |  |  |  |  |  | Inventory Count Variance |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -3693712.67 | -12381324.86984 | 521484.3306 |  | 67650.69 |  |  |  | 3693712.67
 |  |  |  |  |  | Purchase Variance |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1680 | 5631.360000000001 | -1680 |  | 533733.75 |  | -543936.44 |  | 10204.44
 |  |  |  |  |  | Carriage inwards | 31360 | 112029.4736842105 | 133084 | 312340 | 76481 | 120032.6805555555 | 37750 | 42003.52112676056 | 101075 | 186036.5942028986 | 50000 | 145864.6616541353 | 113250 | 223015.3846153846 | 293350 | 983309.2000000001 | 218100 |  | 269535 |  | 438650 |  | 111200
 |  |  |  |  |  | Packaging Costs | 2430 | 8680.855263157895 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14160
 |  |  |  |  |  | Pft/Loss on Foreign Currency Exchange |  |  |  | 0 |  | 0 |  |  |  |  |  |  | -1800000 | -3544615.384615385 | 17680 | 59263.36000000001 |  |  |  |  | 320 |  | 1800000
 |  |  |  |  |  | Discount Received for Cash |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Interest Received | -19.41 | -69.33967105263157 | -268.61 | -630.411224489796 | -1391.76 | -2184.29 | -158.74 | -176.6261971830986 | -391.46 | -720.5133333333333 | -342.09 | -997.9768421052629 | -109.44 | -215.5126153846154 | -52.07 | -174.53864 | -354.27 |  | -313.39 |  | -106.83 |  | -115
 |  |  |  |  |  | Rent Income | -259000 | -925243.4210526316 | -262750 | -616658.1632653062 | -311550 | -488960.4166666667 | -414750 | -461482.3943661972 | -445750 | -820438.4057971016 | -533000 | -1554917.293233082 | -915500 | -1802830.769230769 | -789500 | -2646404 | -789500 |  | -899500 |  | -963500 |  | -1038000