Spreadsheet: 820446d1678109655-excel-formula-for-inflation-adjusted-amounts-inflation-adjusted-b-1-
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 |  | Total 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 |  | 0 |  | 0 | -64000000 | -347773584.9056603 |  | 29457118.08
 | 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 | 2629032.495294118 | 1031397.73 | 5893701.314285714 | 1909328.65 | 10375219.83396226 | 2889777.26 | 16645117.0176
 | 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 | 2782352.941176471 | -14000000 | -80000000 | 7975000 | 43335849.05660377 | 2040000 | 11750400
 | 2022-06-01 00:00:00 | 2986.44 | 3.88 | 1.33 |  | Accumulated depreciation | 0 | 0 |  | 0 |  | 0 |  | 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 |  | 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 | 890352.9411764707 | 351000 | 2005714.285714286
 | 2022-10-01 00:00:00 | 3555.9 | 6.4 | 1.12 |  | Depreciation | 0 | 0 |  | 0 |  | 0 |  | 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 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | Furniture & Fittings - @ Valuation | 1636609 | 5846570.309210526 |  | 0 | 67080 | 105278.3333333333 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 796000 | 4325433.96226415
 |  |  |  |  |  | Depreciation | 0 | 0 |  | 0 |  | 0 |  | 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 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | Listed Shares - @ Valuation | 3845 | 13735.75657894737 |  | 0
 |  |  |  |  |  | Inventory Control Account | 4441631 | 15867142.32236842 |  | 0 |  |  |  |  |  |  |  |  |  |  | 12373631.83 | 41476413.89416 | 944359.7474 | 3753631.601010085 | 1978600.885 | 11306290.77142857 | 15513755.666 | 84301162.86430188 | 41831997.93 | 240952308.0768
 |  |  |  |  |  | Customer Control Account |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7107180.02 | 23823267.42704 | 11177307.91 | 44427450.76831933 | 14033992.86 | 80194244.91428572 | 29892448.14 | 162434435.1758491 | -58118907.43 | -334764906.7968
 |  |  |  |  |  | Staff Loans |  |  | 60000 | 140816.3265306122 |  |  | -30000 | -33380.28169014084 | 315000 | 579782.6086956522 | 240000 | 700150.3759398495 | -240000 | -472615.3846153846 | -210000 | -703920.0000000001 | 44800 | 178070.5882352942 | -240000 | -1371428.571428571 | 80000 | 434716.9811320754 | 565200 | 3255552
 |  |  |  |  |  | ALL POS FOREX |  |  |  |  |  |  |  |  |  |  |  |  | 1002.03 | 1973.228307692307 | -18770.56 | -62918.91712000001 | -16698452.89 | -66372842.15941177 | 2549824.42 | 14570425.25714286 | 1931265.61 | 10494424.44679245 | 14378251.59 | 82818729.1584
 |  |  |  |  |  | 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 | 93088145.99125968 | 12578138.7454 | 71875078.54514286 | -537731.51 | -2922012.733584906 | -54715610.46 | -315161916.2496
 |  |  |  |  |  | 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 | 131077.855792437 | 673857.1246 | 3850612.140571428 | -483471.21 | -2627164.310943396 | -203386.66 | -1171507.1616
 |  |  |  |  |  | Z B BANK 406 |  |  |  |  |  |  |  |  | 365495.37 | 672723.362173913 | 907996.5 | 2648892.045112782 | 875871.52 | 1724793.147076923 | 1103477.85 | 3698857.753200001 | 2654987.46 | 10553017.38302521 | 953582.07 | 5449040.399999999 | 1629960.11 | 8857141.72981132 | -8140433.38 | -46888896.2688
 |  |  |  |  |  | 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 | 73119665.4284874 | 1945204.51 | 11115454.34285714 | 491817.49 | 2672517.681509434 | -20852461.34 | -120110177.3184
 |  |  |  |  |  | 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 | -5098.701512605043 | 27835.0088 | 159057.1931428571 | 42598.4876 | 231478.5741283019 | 37287.3473 | 214775.120448
 |  |  |  |  |  | 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 | -98403269.78151262 | -6077700 | -34729714.28571428 | -22779335.2 | -123782047.8792453 | 73489300.2989 | 423298369.721664
 |  |  |  |  |  | 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 | -7439073.95277311 | -617998.19 | -3531418.228571428 | -2193574.65 | -11919801.87169811 | 7457471.9109 | 42955038.206784
 |  |  |  |  |  | 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 | 810298.5258823531 | 214640.6 | 1226517.714285714 | 107482.2 | 584054.2188679245 | -392805.92 | -2262562.0992
 |  |  |  |  |  | AGRIBANK  USD 087 |  |  |  |  |  | 0 |  |  |  |  |  |  | -3500 | -6892.307692307691 | -3500 | -11732 | -3500 | -13911.76470588235 | 1751578.0912 | 10009017.664 | 15492217.7524 | 84184126.65455094 | -15129590.85 | -87146443.29599999
 |  |  |  |  |  | Bank Transfer | 40000 | 142894.7368421053 |  | 0 |  | 0 | 31900 | 35494.3661971831 |  |  |  |  |  |  |  |  | -0.0239 | -0.09499747899159666 | -0.01 | -0.05714285714285715 |  |  | -0.01 | -0.0576
 |  |  |  |  |  | Supplier Control Account | 219109.81 | 782740.965986842 |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -9876064.79 | -33104569.17608 | -14533714.26 | -57768460.88218488 | -7135053.77 | -40771735.82857142 | 2056344.56 | 11174098.74113207 | -10435085.89 | -60106094.7264
 |  |  |  |  |  | GRN Accrual Account |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | -111650 | -374250.8 | -161103 | -640350.5798319329 | -22082.97 | -126188.4 | 258422 | 1404255.396226415
 |  |  |  |  |  | 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 | -639941.1764705883 | 124500 | 711428.5714285715 | 62550 | 339894.3396226415 | 1251808 | 7210414.08
 |  |  |  |  |  | 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 | 958854.2718487397 | -330087.63 | -1886215.028571429 | -421319.47 | -2289434.101132075 | -456180.74 | -2627601.0624
 |  |  |  |  |  | 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 | -591057.6201680673 | 108736.66 | 621352.3428571429 | -254416.27 | -1382488.410566038 | -192577.57 | -1109246.8032
 |  |  |  |  |  | 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 | 376500.9248739496 | 68750 | 392857.1428571428 | 47361.11 | 257358.4845283019 | 22916.67 | 132000.0192
 |  |  |  |  |  | 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 | 98469.65672268909 | -42308.95 | -241765.4285714286 | -42119.29 | -228874.6324528302 | -44342.33 | -255411.8208
 |  |  |  |  |  | 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 | -112010.6927731093 | -44562.68 | -254643.8857142857 | -42526.54 | -231087.6135849057 | -33988.6 | -195774.336
 |  |  |  |  |  | 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 | -2344985.422352941 | -589961.03 | -3371205.885714286 | -589961.03 | -3205825.974339623 | 3038957.69 | 17504396.2944
 |  |  |  |  |  | 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 | -41231.96647058825 | -17636.62 | -100780.6857142857 | -17567.09 | -95458.90415094339 | -18766.92 | -108097.4592
 |  |  |  |  |  | Leave days accrual |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | -2428772.21 | -13989727.9296
 |  |  |  |  |  | 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 | 432815.907394958 | -1532401.98 | -8756582.742857143 | 2568726.1 | 13958360.69433962 | 331593.8 | 1909980.288
 |  |  |  |  |  | Taxation Payable | -440377 | -1573188.888157895 |  | 0
 |  |  |  |  |  | Dividends Payable |  |  |  |  | 365312.94 | 573338.3641666666 | 196496.86 | 218637.3512676056 | 245310 | 451512.6086956522 |  |  |  |  |  |  |  |  | 579895 | 3313685.714285715
 |  |  |  |  |  | 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 | -5494802.563781514 | 337504.93 | 1928599.6 | 3123437.79 | 16972643.08528302 | 1193690.28 | 6875656.0128
 |  |  |  |  |  | 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 | 30486441.66487395 | -5207466.38 | -29756950.74285714 | -244449.47 | -1328329.195471698 | -1876442.31 | -10808307.7056
 |  |  |  |  |  | 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 | -2807575.686050421 | -1545890.44 | -8833659.657142857 | 973363.78 | 5289222.04981132 | -855117.77 | -4925478.3552
 |  |  |  |  |  | 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 | -10712483.17210084 | -3121189.55 | -17835368.85714286 | -1749781 | -9508243.9245283 | 9230575.46 | 53168114.64960001
 |  |  |  |  |  | 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 | -504440.78697479 | -1048187.98 | -5989645.6 | -335440.01 | -1822768.356226415 | 3095354.82 | 17829243.7632
 |  |  |  |  |  | Intercompany filabusi |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 153540.57 | 514667.9906400001 | 174775 | 694693.9075630252 | -926560 | -5294628.571428572 | -1683588.4 | -9148555.833962264 | 3925830.37 | 22612782.9312
 |  |  |  |  |  | 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 | -9654301.9584
 |  |  |  |  |  | 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 | 1232582.352941177 | 147000 | 840000 | 320000 | 1738867.924528302 | 329000 | 1895040
 |  |  |  |  |  | Licence fees 2023 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 942801.28 | 5430535.3728
 |  |  |  |  |  | Generator |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1800 | 9781.132075471698
 |  |  |  |  |  | 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 | 3443727.019579832 | 833031.29 | 4760178.800000001 | 2581021.7 | 14025174.52075472 | 485486.99 | 2796405.0624
 |  |  |  |  |  | Working capital costs |  |  |  |  |  | 0 |  |  |  |  |  |  | 184722.22 | 363760.6793846154 | 251157.4 | 841879.6048000001 | 200925.93 | 798638.3604201681 | 145833.33 | 833333.3142857142 | 2020462.96 | 10979119.48075472 | 48611.1 | 279999.936
 |  |  |  |  |  | Water & rates | 8284 | 29593.5 | 18571 | 43585 | 39270 | 61632.08333333334 | 25280 | 28128.45070422535 |  |  | 4880 | 14236.39097744361 |  |  |  |  |  |  | 400000 | 2285714.285714286
 |  |  |  |  |  | Electricity | 4900 | 17504.60526315789 | 6000 | 14081.63265306123 |  |  |  |  | 5000 | 9202.898550724638 | 6050 | 17649.62406015037 | 5000 | 9846.153846153846 | 5000 | 16760 | 13500 | 53659.66386554622 | 40125 | 229285.7142857143 | 43000 | 233660.3773584905 | 28595 | 164707.2
 |  |  |  |  |  | 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 | 362500.8403361345 | 105500 | 602857.1428571428 | 121050 | 657781.1320754717 | 106200 | 611712
 |  |  |  |  |  | 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 | 111075.5042016807 | 73310 | 418914.2857142857 | 41660 | 226378.8679245283 | 55000 | 316800
 |  |  |  |  |  | Rentals |  |  |  |  | 266000 | 417472.2222222222 | 288000 | 320450.7042253522 | 227500 | 418731.8840579711 |  |  | 390000 | 768000 | 840000 | 2815680 | 815500 | 3241441.176470589 | 801500 | 4580000 | 2080000 | 11302641.50943396 | 1648000 | 9492480
 |  |  |  |  |  | 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 | 8238748.461428572 | 3527312.27 | 20156070.11428571 | 3647479.08 | 19820263.68 | 3757058.62 | 21640657.6512
 |  |  |  |  |  | Casual lablour |  |  | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 78097.63 | 310421.672184874 |  |  |  |  | 900 | 5184
 |  |  |  |  |  | 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 | 1630432.152689076 | 483119.91 | 2760685.2 | 568791.7 | 3090792.633962264 | 514467.33 | 2963331.8208
 |  |  |  |  |  | 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 | 241281.6722689076 | 75100 | 429142.8571428572 | 110670.3 | 601378.2339622641 | 243331.7 | 1401590.592
 |  |  |  |  |  | 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 | 3946477.765630253 | 162000 | 925714.2857142857 | 212750 | 1156075.471698113 | 212800 | 1225728
 |  |  |  |  |  | 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 | 2344985.422352941 | 589961.03 | 3371205.885714286 | 589961.03 | 3205825.974339623 | -3038957.69 | -17504396.2944
 |  |  |  |  |  | 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 | 2448967.43697479 | 638005 | 3645742.857142857 | 699250 | 3799698.113207547 | 809375 | 4662000
 |  |  |  |  |  | Employees training |  |  |  |  |  | 0 |  |  | 40358.5 | 74283.03623188406 | 40000 | 116691.7293233083 | 26800 | 52775.38461538461 | 28000 | 93856.00000000001 | 121881.8 | 484454.549579832
 |  |  |  |  |  | EmployeesOvertime |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 4900 | 28000
 |  |  |  |  |  | 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 | 1224235.294117647 | 518000 | 2960000 | 308000 | 1673660.37735849 | 396000 | 2280960
 |  |  |  |  |  | Employees leave days |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2428772.21 | 13989727.9296
 |  |  |  |  |  | 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 | 41231.96647058825 | 17636.62 | 100780.6857142857 | 17567.09 | 95458.90415094339 | 21942.86 | 126390.8736
 |  |  |  |  |  | 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 | 108403.7696638656 | 42308.95 | 241765.4285714286 | 42119.29 | 228874.6324528302 | 44342.33 | 255411.8208
 |  |  |  |  |  | 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 | 56005.34638655463 | 22279.84 | 127313.3714285714 | 19763.27 | 107392.8633962264 | 13818.36 | 79593.7536
 |  |  |  |  |  | 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 | 331585.2026050421 | 142210.63 | 812632.1714285715 | 143267.58 | 778510.6233962263 | 108035.74 | 622285.8624
 |  |  |  |  |  | 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 | 111294.1176470588 | 140000 | 800000 | 198190 | 1076956.981132075 | 80000 | 460800
 |  |  |  |  |  | Electricals | 360 | 1286.052631578947 |  | 0 |  |  |  |  |  |  | 15400 | 44926.31578947368 |  |  | 24675 | 82710.6 |  |  |  |  | 126380 | 686744.1509433961
 |  |  |  |  |  | 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 | 385426.1714285715 | 328000 | 1782339.622641509 | 762400 | 4391424
 |  |  |  |  |  | Compuer equipment | 4500 | 16075.65789473684 | 12000 | 28163.26530612245 |  |  | 3000 | 3338.028169014085 | 490 | 901.8840579710146 |  |  |  |  | 204400 | 685148.8 | 96500 | 383567.2268907563 | 7000 | 40000 | 16000 | 86943.39622641509 | -139490 | -803462.4
 |  |  |  |  |  | Furniture & fittings | 3180 | 11360.13157894737 |  | 0 |  |  |  |  |  |  | 38800 | 113190.977443609 |  |  | 70000 | 234640 |  |  |  |  | 264000 | 1434566.037735849 | 220548 | 1270356.48
 |  |  |  |  |  | Administration costs |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Accounting & Audit fees |  |  |  | 0 |  | 0 |  |  | 2315360 | 4261604.63768116 | 779250 | 2273300.751879699 | 454000 | 894030.7692307691 | 59500 | 199444 | 160747 | 638935.5546218489 | 148000 | 845714.2857142857 | 54400 | 295607.5471698113
 |  |  |  |  |  | Advertising & promotion |  |  |  | 0 |  | 0 |  |  |  |  |  |  | 40000 | 78769.23076923077 | 115500 | 387156.0000000001 | 14000 | 55647.05882352942 | 131000 | 748571.4285714286
 |  |  |  |  |  | Donations |  |  |  | 0 |  | 0 |  |  |  |  | 16850 | 49156.3909774436 |  |  |  | 0 |  |  | 70000 | 400000 |  |  | 88113 | 507530.88
 |  |  |  |  |  | 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 | 286542.6050420168 | 29000 | 165714.2857142857 | 412136 | 2239531.471698113 | 1681616.32 | 9686110.0032
 |  |  |  |  |  | Postage & Corrier |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 27300 | 91509.6 | 60700 | 241269.7478991597 | 29400 | 168000 | 32800 | 178233.9622641509 | 34000 | 195840
 |  |  |  |  |  | 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 | 398114.9579831933 | 111480 | 637028.5714285715 | 200709.72 | 1090649.044528302 | 187317.6 | 1078949.376
 |  |  |  |  |  | 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 | 1168167.543529412 | 586530 | 3351600 | 849928 | 4618476.679245283 | 1120400 | 6453504
 |  |  |  |  |  | Capacity development-Seniour management |  |  | 117534 | 275845.1020408163 |  |  |  |  |  |  |  |  |  |  |  | 0 | 4800 | 19078.99159663866
 |  |  |  |  |  | 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 | 27823.52941176471 | 569208 | 3252617.142857143 | 32000 | 173886.7924528302 | 1185784.96 | 6830121.3696
 |  |  |  |  |  | Cleaning expenses | 225 | 803.7828947368421 | 5000 | 11734.69387755102 | 4000 | 6277.777777777777 | 6295 | 7004.295774647888 |  |  | 9200 | 26839.0977443609 |  |  | 28297 | 94851.54400000001 | 42000 | 166941.1764705883 | 51740 | 295657.1428571428 | 72900 | 396135.8490566037 | 114400 | 658944
 |  |  |  |  |  | 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 | 386349.5798319328 | 15400 | 88000 | 14600 | 79335.84905660377 | 26500 | 152640
 |  |  |  |  |  | Parking fees | 360 | 1286.052631578947 |  | 0 | 3400 | 5336.111111111111 | 1200 | 1335.211267605634 | 2070 | 3810 | 1760 | 5134.436090225563 | 4550 | 8960 | 8400 | 28156.8 | 19070 | 75799.243697479 | 9800 | 56000 | 9900 | 53796.22641509434 | 5850 | 33696
 |  |  |  |  |  | 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 | 347794.1176470589 | 80500 | 460000 | 128000 | 695547.1698113207 | 463170 | 2667859.2
 |  |  |  |  |  | profit/loss foreign exchange |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2438137.75 | 14043673.44
 |  |  |  |  |  | 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 | 36939424.57487395 | 4609568.87 | 26340393.54285714 | 19199169.03 | 104327560.0120755 | 42397106.01 | 244207330.6176
 |  |  |  |  |  | Groceries |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -23012532.9 | -77138010.2808 | -48560348.21 | -193017182.3809244 | -20767944.6 | -118673969.1428571 | -32188653.61 | -174911929.050566 | -76304539.71 | -439514148.7296
 |  |  |  |  |  | Bookshop |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -2388349.79 | -8005748.496080001 | -1884557.79 | -7490721.2997479 | -1536553.02 | -8780302.971428571 | -2132510.18 | -11587979.84603774 | -1204771.3 | -6939482.688
 |  |  |  |  |  | Groceries |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -3056.77 | -10246.29304 | -178115.72 | -707972.5677310926 | -23812.23 | -136069.8857142857 | -188646.28 | -1025096.766792453 | -4290453.13 | -24713010.0288
 |  |  |  |  |  | Bookshop |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | -70000 | -400000 | -39245.41 | -213258.0769811321
 |  |  |  |  |  | Cost of Sales / Purchases |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 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 | -12309124.60226891 | -1895511.895 | -10831496.54285714 | -16599782.156 | -90202589.82883018 | -28300892.36 | -163013139.9936
 |  |  |  |  |  | Groceries |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 8715260.56 | 29213553.39712 | 31127137.38 | 123723831.7709244 | 10729560.37 | 61311773.54285714 | 25389891.52 | 137967712.410566 | 48744525.02 | 280768464.1152
 |  |  |  |  |  | Hardware |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 2129161.64 | 7136949.817280001 | 1580843.82 | 6283522.074453782 | 1283101.55 | 7332008.857142857 | 1742994.33 | 9471365.415849056 | 876462.95 | 5048426.591999999
 |  |  |  |  |  | Uniforms |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 62286 | 247573.7647058824 | 4893 | 27960 |  |  | 2562500 | 14760000
 |  |  |  |  |  | ITC |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 0 |  |  | 70000 | 400000
 |  |  |  |  |  | Inventory Adjustment |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -471149.79 | -1579294.09608 | 15000 | 59621.84873949581 |  |  |  |  | -818960 | -4717209.6
 |  |  |  |  |  | Inventory Count Variance |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | -3693712.67 | -12381324.86984 | 521484.3306 | 2072790.658603362 | 67650.69 | 386575.3714285715 |  |  | 3693712.67 | 21275784.9792
 |  |  |  |  |  | Purchase Variance |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1680 | 5631.360000000001 | -1680 | -6677.647058823531 | 533733.75 | 3049907.142857143 | -543936.44 | -2955730.089056603 | 10204.44 | 58777.5744
 |  |  |  |  |  | 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 | 866901.6806722691 | 269535 | 1540200 | 438650 | 2383607.547169811 | 111200 | 640512
 |  |  |  |  |  | Packaging Costs | 2430 | 8680.855263157895 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14160 | 81561.59999999999
 |  |  |  |  |  | Pft/Loss on Foreign Currency Exchange |  |  |  | 0 |  | 0 |  |  |  |  |  |  | -1800000 | -3544615.384615385 | 17680 | 59263.36000000001 |  |  |  |  | 320 | 1738.867924528302 | 1800000 | 10368000
 |  |  |  |  |  | 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 | -1408.148823529412 | -313.39 | -1790.8 | -106.83 | -580.5101886792453 | -115 | -662.4
 |  |  |  |  |  | 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 | -3138096.638655463 | -899500 | -5140000 | -963500 | -5235622.641509433 | -1038000 | -5978880