Spreadsheet: 820446d1678109655-excel-formula-for-inflation-adjusted-amounts-inflation-adjusted-b-1-
Sheet: Sheet1

 | Monrh | Indices | Inflation rate | Conversion factors
 | 2021-12-01 00:00:00 | 2474.51 | 4.22 | 1.61 |  |  | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER
 | 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
 | 2022-03-01 00:00:00 | 2759.83 | 2.26 | 1.44 |  | Agri bank Loan (USD) |  |  |  |  |  |  |  |  |  |  | -64000000
 | 2022-04-01 00:00:00 | 2803.57 | 1.58 | 1.42 |  | AGRIBANK LOAN | -5223589 | 914999.61 | 416666.67 | 416666.67 | 416666.67 | 422167.37 | 333018.45 | 363199.18 | 661426.78 | 1031397.73 | 1909328.65 | 2889777.26
 | 2022-05-01 00:00:00 | 2874.85 | 2.54 | 1.38 |  | BICC SCHOOLS OFFICE |  |  | -860000 | 120000 |  | 175000 |  | -2450000 | 700000 | -14000000 | 7975000 | 2040000
 | 2022-06-01 00:00:00 | 2986.44 | 3.88 | 1.33 |  | Accumulated depreciation | 0
 | 2022-07-01 00:00:00 | 3062.93 | 2.56 | 1.3 |  | Motor Vehicles - @ Valuation | 2170000
 | 2022-08-01 00:00:00 | 3191.19 | 4.19 | 1.25 |  | Depreciation | 0
 | 2022-09-01 00:00:00 | 3342.02 | 4.73 | 1.19 |  | Computer Equipment - Valuation | 2972958 | 34000 | 144423.88 | 26400 |  | 133000 | 52000 | 105000 | 224000 | 351000
 | 2022-10-01 00:00:00 | 3555.9 | 6.4 | 1.12 |  | Depreciation | 0
 | 2022-11-01 00:00:00 | 3760.86 | 5.76 | 1.06 |  | Office Equipment - @  Valuation | 1267770 |  |  |  | 7000 |  |  | 139400
 | 2022-12-01 00:00:00 | 3977.46 | 5.76 | 1 |  | Depreciation | 0
 |  |  |  |  |  | Furniture & Fittings - @ Valuation | 1636609 |  | 67080 |  |  |  |  |  |  |  | 796000
 |  |  |  |  |  | Depreciation | 0
 |  |  |  |  |  | Other Fixed Assets - @ Valuation | 18800
 |  |  |  |  |  | Depreciation | 0
 |  |  |  |  |  | Listed Shares - @ Valuation | 3845
 |  |  |  |  |  | Inventory Control Account | 4441631 |  |  |  |  |  |  | 12373631.83 | 944359.7474 | 1978600.885 | 15513755.666 | 41831997.93
 |  |  |  |  |  | Customer Control Account |  |  |  |  |  |  |  | 7107180.02 | 11177307.91 | 14033992.86 | 29892448.14 | -58118907.43
 |  |  |  |  |  | Staff Loans |  | 60000 |  | -30000 | 315000 | 240000 | -240000 | -210000 | 44800 | -240000 | 80000 | 565200
 |  |  |  |  |  | ALL POS FOREX |  |  |  |  |  |  | 1002.03 | -18770.56 | -16698452.89 | 2549824.42 | 1931265.61 | 14378251.59
 |  |  |  |  |  | Z B BANK 405 | 13894.6 | 98926 | 945322.5502 | 1913327.4 | 8321776.7311 | 2877998.3038 | 4429008.1716 | 774110.2 | 23419639.2663 | 12578138.7454 | -537731.51 | -54715610.46
 |  |  |  |  |  | Z B BANK 200 | 241231.94 | 1232244.6 | -1038781.31 | -80740.54 | -321319.92 | 166232.1062 | -131784.81 | -28749.17 | 32977.3041 | 673857.1246 | -483471.21 | -203386.66
 |  |  |  |  |  | Z B BANK 406 |  |  |  |  | 365495.37 | 907996.5 | 875871.52 | 1103477.85 | 2654987.46 | 953582.07 | 1629960.11 | -8140433.38
 |  |  |  |  |  | AGRIBANK 569 | 81787.61 | 133141.57 | -44566.29 | 371039.93 | 67817.17 | 138434.3 | -774361.52 | 776382.21 | 18395856.63 | 1945204.51 | 491817.49 | -20852461.34
 |  |  |  |  |  | AGRIBANK 828 | 1681.12 | -3244.1 | 3265.24 | 6747.24 | 4217.24 | 67763.48 | 85320.67 | -163416.76 | -1282.76 | 27835.0088 | 42598.4876 | 37287.3473
 |  |  |  |  |  | CASH USD | 7159.93 | 58848 | -1833404 | -2346738 | -7009250 | -2727273 | -6370818 | 1710521 | -24756848 | -6077700 | -22779335.2 | 73489300.2989
 |  |  |  |  |  | CASH RAND | -35740.63 | 21780 | 13540 | -20437.5 | -290958.26 | -970434 | -716544 | -408092.25 | -1871564.06 | -617998.19 | -2193574.65 | 7457471.9109
 |  |  |  |  |  | CASH ZWL | 9403.97 | -2962.15 | 42274.33 | -9798.59 | -914.24 | -12630.74 | -11638.14 | 38276.34 | 203859.46 | 214640.6 | 107482.2 | -392805.92
 |  |  |  |  |  | AGRIBANK  USD 087 |  |  |  |  |  |  | -3500 | -3500 | -3500 | 1751578.0912 | 15492217.7524 | -15129590.85
 |  |  |  |  |  | Bank Transfer | 40000 |  |  | 31900 |  |  |  |  | -0.0239 | -0.01 |  | -0.01
 |  |  |  |  |  | Supplier Control Account | 219109.81 |  |  |  |  |  |  | -9876064.79 | -14533714.26 | -7135053.77 | 2056344.56 | -10435085.89
 |  |  |  |  |  | GRN Accrual Account |  |  |  |  |  |  |  | -111650 | -161103 | -22082.97 | 258422
 |  |  |  |  |  | Acruals  - Staff allowances | -207500 | 191000 | -30000 | 67200 |  | -33200 | -913600 | -351758 | -161000 | 124500 | 62550 | 1251808
 |  |  |  |  |  | PAYE Control Account | 183028.96 | 33391.08 | -66729.18 | -45239.12 | -129678.66 | -147705.11 | 78128.35 | 29314.16 | 241233.95 | -330087.63 | -421319.47 | -456180.74
 |  |  |  |  |  | NSSA Control Account | -40978.4 | 196782.13 | -9803.78 | -14093.85 | -24739.71 | -108460.89 | -9187.61 | -142572.19 | -148701.6 | 108736.66 | -254416.27 | -192577.57
 |  |  |  |  |  | loan interest accrual | -1444166.67 | 236805.56 | 194444.44 | 193750 | 166666.67 | 162847.22 | 137500 | 118402.78 | 94722.22 | 68750 | 47361.11 | 22916.67
 |  |  |  |  |  | ZIMDEF | -6142.22 | 11657.09 | 3967.43 | -9838.02 | -14504.01 | 3581.48 | -16482.23 | -25394.71 | 24773.55 | -42308.95 | -42119.29 | -44342.33
 |  |  |  |  |  | NEC Control | -23275.76 | -13696.66 | -17844 | -16402.94 | -21686 | -21683.49 | -21682.68 | -28194.36 | -28180.28 | -44562.68 | -42526.54 | -33988.6
 |  |  |  |  |  | BONVIE MEDICAL AID | -55321 | -80206 | -80206 | -80207.08 | -127725.63 | -127725.85 | -127720.34 | -589959.11 | -589964.62 | -589961.03 | -589961.03 | 3038957.69
 |  |  |  |  |  | STANDARD DEV FUND | -2824.02 | -2824.02 | -3694 | -4350.18 | -6391 | -7291.89 | -7364.49 | -9441.54 | -10373.37 | -17636.62 | -17567.09 | -18766.92
 |  |  |  |  |  | Leave days accrual |  |  |  |  |  |  |  |  |  |  |  | -2428772.21
 |  |  |  |  |  | Salary & Wages Control | -270704.24 | 421908.39 | 5000 | 24804.15 | -68038.54 | -380307.82 | -60388.57 | -1149081.55 | 108890.26 | -1532401.98 | 2568726.1 | 331593.8
 |  |  |  |  |  | Taxation Payable | -440377
 |  |  |  |  |  | Dividends Payable |  |  | 365312.94 | 196496.86 | 245310 |  |  |  |  | 579895
 |  |  |  |  |  | Vat / Tax Control Account | 464720.09 | 374738.94 | 231358.5 | 680270 | 867345.5 | 1064578.5 |  | 831633.05 | -1382413.33 | 337504.93 | 3123437.79 | 1193690.28
 |  |  |  |  |  | Intercompany -Bulawayo | -480524 | 2323160.25 | 3715868.27 | 1492781.69 | 1647006.94 | -1277049 | 6746075.91 | -3896223.21 | 7669950.44 | -5207466.38 | -244449.47 | -1876442.31
 |  |  |  |  |  | Intercompany - Beitbridge | 104370.32 | -502889.26 | -522927.4 | -181615.73 | -1433686.5 | -172685.5 | -820352 | -833053.52 | -706345.68 | -1545890.44 | 973363.78 | -855117.77
 |  |  |  |  |  | Intercompany - Gwanda | -174513 | -644855.38 | -933199.4 | -504228.62 | -731920.58 | -1057545.44 | -1523247 | -834885 | -2695106.76 | -3121189.55 | -1749781 | 9230575.46
 |  |  |  |  |  | Intercompany - Gweru | -136504.9 | -587122.01 | -393527.19 | -274098 | -964568 | -281773.01 | -405364.01 | -971525.01 | -126910.05 | -1048187.98 | -335440.01 | 3095354.82
 |  |  |  |  |  | Intercompany filabusi |  |  |  |  |  |  |  | 153540.57 | 174775 | -926560 | -1683588.4 | 3925830.37
 |  |  |  |  |  | Opening Balance / Suspense Account | -1406724 | 487126.01 | 1277245.96 | 334629.61 | 243816.69 | 740000 |  |  |  |  |  | -1676094.09
 |  |  |  |  |  | Fuels & Oils-Motor Vehicles | 154600 | 125000 | 145200 | 124272 | 182000 | 265500 | 211000 | 255500 | 310100 | 147000 | 320000 | 329000
 |  |  |  |  |  | Licence fees 2023 |  |  |  |  |  |  |  |  |  |  |  | 942801.28
 |  |  |  |  |  | Generator |  |  |  |  |  |  |  |  |  |  | 1800
 |  |  |  |  |  | Finance & working capital charges
 |  |  |  |  |  | Accounts management fees | 151787.99 | 285056.52 | 313441.52 | 228232.23 | 647845.47 | 499924.27 | 651126.93 | 326002.87 | 866392.21 | 833031.29 | 2581021.7 | 485486.99
 |  |  |  |  |  | Working capital costs |  |  |  |  |  |  | 184722.22 | 251157.4 | 200925.93 | 145833.33 | 2020462.96 | 48611.1
 |  |  |  |  |  | Water & rates | 8284 | 18571 | 39270 | 25280 |  | 4880 |  |  |  | 400000
 |  |  |  |  |  | Electricity | 4900 | 6000 |  |  | 5000 | 6050 | 5000 | 5000 | 13500 | 40125 | 43000 | 28595
 |  |  |  |  |  | Telephone bills | 23750 | 36200 | 24000 | 25200 | 21500 | 29126.86 | 23000 | 60996 | 91200 | 105500 | 121050 | 106200
 |  |  |  |  |  | Internet | 10492 | 7499 | 17500 | 21899 | 21000 | 22149 | 24949 | 25470 | 27945 | 73310 | 41660 | 55000
 |  |  |  |  |  | Rentals |  |  | 266000 | 288000 | 227500 |  | 390000 | 840000 | 815500 | 801500 | 2080000 | 1648000
 |  |  |  |  |  | Employees compensation
 |  |  |  |  |  | Employees basic salaries | 564811.3 | 564811.3 | 847968 | 872175.43 | 1278723.28 | 1485241.28 | 1472533.94 | 1886564.74 | 2072750.67 | 3527312.27 | 3647479.08 | 3757058.62
 |  |  |  |  |  | Casual lablour |  | 0 |  |  |  |  |  |  | 78097.63 |  |  | 900
 |  |  |  |  |  | Canteen provision | 102154.28 | 85144.94 | 97104.98 | 129465.35 | 165617.15 | 204549.99 | 271994.81 | 281735.26 | 410193.29 | 483119.91 | 568791.7 | 514467.33
 |  |  |  |  |  | Casual labour |  | 4600 | 13982 | 13229.66 | 28750 | 27713.08 | 20500 | 57145.73 | 60703 | 75100 | 110670.3 | 243331.7
 |  |  |  |  |  | Employees bonus
 |  |  |  |  |  | Employees welfare | 88419.25 | 151670 | 48000 | 394774.17 | 323000 | 80000 | 170700 | 172060 | 992877.07 | 162000 | 212750 | 212800
 |  |  |  |  |  | Employees medical aid | 127660.5 | 259461 | 160412 | 192491.08 | 264267.63 | 127725.85 | 294866.34 | 589959.11 | 589964.62 | 589961.03 | 589961.03 | -3038957.69
 |  |  |  |  |  | Employees transport expenses | 135020 | 140000 | 195500 | 228300 | 305450 | 458925 | 752350 | 709750 | 616125 | 638005 | 699250 | 809375
 |  |  |  |  |  | Employees training |  |  |  |  | 40358.5 | 40000 | 26800 | 28000 | 121881.8
 |  |  |  |  |  | EmployeesOvertime |  |  |  |  |  |  |  |  |  | 4900
 |  |  |  |  |  | Employees residency allowances | 68000 | 188000 | 81600 | 102000 | 259000 | 256000 | 352000 | 413000 | 308000 | 518000 | 308000 | 396000
 |  |  |  |  |  | Employees leave days |  |  |  |  |  |  |  |  |  |  |  | 2428772.21
 |  |  |  |  |  | Statutory deductions
 |  |  |  |  |  | Standard development fund | 1670.43 | 2824.02 | 3694 | 4350.18 | 6391 | 7291.89 | 7364.49 | 9441.54 | 10373.37 | 17636.62 | 17567.09 | 21942.86
 |  |  |  |  |  | ZimDEF | 7295.88 | 6273.21 | 8448 | 9838.02 | 14504.01 | 16335.13 | 16482.23 | 25394.71 | 27272.83 | 42308.95 | 42119.29 | 44342.33
 |  |  |  |  |  | Employees NEC | 6848.33 | 6848.27 | 8922 | 8201.47 | 10843 | 10841.74 | 10841.34 | 14097.18 | 14090.14 | 22279.84 | 19763.27 | 13818.36
 |  |  |  |  |  | Employees NSSA | 28808.8 | 29466.16 | 35450 | 42553.71 | 56381.54 | 61562.22 | 61537.33 | 79979.52 | 83422.07 | 142210.63 | 143267.58 | 108035.74
 |  |  |  |  |  | Repairs & Maintanance
 |  |  |  |  |  | Buildings | 51660 | 16650 | 18270 | 49428 |  | 269200 | 12300 | 98720 | 28000 | 140000 | 198190 | 80000
 |  |  |  |  |  | Electricals | 360 |  |  |  |  | 15400 |  | 24675 |  |  | 126380
 |  |  |  |  |  | Motor vehicles | 29507 | 129600 | 70800 | 16500 | 112000 | 52788.92 | 173100 | 187720 |  | 67449.58 | 328000 | 762400
 |  |  |  |  |  | Compuer equipment | 4500 | 12000 |  | 3000 | 490 |  |  | 204400 | 96500 | 7000 | 16000 | -139490
 |  |  |  |  |  | Furniture & fittings | 3180 |  |  |  |  | 38800 |  | 70000 |  |  | 264000 | 220548
 |  |  |  |  |  | Administration costs
 |  |  |  |  |  | Accounting & Audit fees |  |  |  |  | 2315360 | 779250 | 454000 | 59500 | 160747 | 148000 | 54400
 |  |  |  |  |  | Advertising & promotion |  |  |  |  |  |  | 40000 | 115500 | 14000 | 131000
 |  |  |  |  |  | Donations |  |  |  |  |  | 16850 |  |  |  | 70000 |  | 88113
 |  |  |  |  |  | Insurance & Licenses | 74702.63 | 182339 | 45275 |  | 64122 | 53550 | 20000 | 154000 | 72090 | 29000 | 412136 | 1681616.32
 |  |  |  |  |  | Postage & Corrier |  |  |  |  |  |  |  | 27300 | 60700 | 29400 | 32800 | 34000
 |  |  |  |  |  | Stationary & Printing | 7710 | 14363.64 | 13580 | 30963.62 | 24349.95 | 50385.34 | 38244.19 | 107865.01 | 100160 | 111480 | 200709.72 | 187317.6
 |  |  |  |  |  | Security expenses
 |  |  |  |  |  | Traveling & Subsistance | 38900 | 12760 | 24120 | 83500 | 33635 | 42440 | 89460 | 812059.98 | 293894.16 | 586530 | 849928 | 1120400
 |  |  |  |  |  | Capacity development-Seniour management |  | 117534 |  |  |  |  |  |  | 4800
 |  |  |  |  |  | Board members compensation | 51848.51 |  | 73795.17 | 71184.44 | 33250 | 94100 | 323449.92 | 56000 | 7000 | 569208 | 32000 | 1185784.96
 |  |  |  |  |  | Cleaning expenses | 225 | 5000 | 4000 | 6295 |  | 9200 |  | 28297 | 42000 | 51740 | 72900 | 114400
 |  |  |  |  |  | Carriage outwards | 22000 | 25000 | 4400 | 40800 | 34300 | 37750 | 36000 | 4900 | 97200 | 15400 | 14600 | 26500
 |  |  |  |  |  | Parking fees | 360 |  | 3400 | 1200 | 2070 | 1760 | 4550 | 8400 | 19070 | 9800 | 9900 | 5850
 |  |  |  |  |  | Computer expenses | 10800 | 10810.9 | 10986.43 | 12000 | 10500 | 130000 | 12000 | 107100 | 87500 | 80500 | 128000 | 463170
 |  |  |  |  |  | profit/loss foreign exchange |  |  |  |  |  |  |  |  |  |  |  | 2438137.75
 |  |  |  |  |  | Sales
 |  |  |  |  |  | Bookshop | -3680924 | -19777672 | -13634353 | -14179168 | -23914167 | -11941091 | -11021935 | 7904667.71 | 9293428.17 | 4609568.87 | 19199169.03 | 42397106.01
 |  |  |  |  |  | Groceries |  |  |  |  |  |  |  | -23012532.9 | -48560348.21 | -20767944.6 | -32188653.61 | -76304539.71
 |  |  |  |  |  | Bookshop |  |  |  |  |  |  |  | -2388349.79 | -1884557.79 | -1536553.02 | -2132510.18 | -1204771.3
 |  |  |  |  |  | Groceries |  |  |  |  |  |  |  | -3056.77 | -178115.72 | -23812.23 | -188646.28 | -4290453.13
 |  |  |  |  |  | Bookshop |  |  |  |  |  |  |  |  |  | -70000 | -39245.41
 |  |  |  |  |  | Cost of Sales / Purchases
 |  |  |  |  |  | Bookshop | 2187188 | 12471414 | 9704607 | 9272968 | 16248287 | 7455309 | 6889532 | -322874.88 | -3096798.79 | -1895511.895 | -16599782.156 | -28300892.36
 |  |  |  |  |  | Groceries |  |  |  |  |  |  |  | 8715260.56 | 31127137.38 | 10729560.37 | 25389891.52 | 48744525.02
 |  |  |  |  |  | Hardware |  |  |  |  |  |  |  | 2129161.64 | 1580843.82 | 1283101.55 | 1742994.33 | 876462.95
 |  |  |  |  |  | Uniforms |  |  |  |  |  |  |  |  | 62286 | 4893 |  | 2562500
 |  |  |  |  |  | ITC |  |  |  |  |  |  |  |  |  | 70000
 |  |  |  |  |  | Inventory Adjustment |  |  |  |  |  |  |  | -471149.79 | 15000 |  |  | -818960
 |  |  |  |  |  | Inventory Count Variance |  |  |  |  |  |  |  | -3693712.67 | 521484.3306 | 67650.69 |  | 3693712.67
 |  |  |  |  |  | Purchase Variance |  |  |  |  |  |  |  | 1680 | -1680 | 533733.75 | -543936.44 | 10204.44
 |  |  |  |  |  | Carriage inwards | 31360 | 133084 | 76481 | 37750 | 101075 | 50000 | 113250 | 293350 | 218100 | 269535 | 438650 | 111200
 |  |  |  |  |  | Packaging Costs | 2430 |  |  |  |  |  |  |  |  |  |  | 14160
 |  |  |  |  |  | Pft/Loss on Foreign Currency Exchange |  |  |  |  |  |  | -1800000 | 17680 |  |  | 320 | 1800000
 |  |  |  |  |  | Discount Received for Cash
 |  |  |  |  |  | Interest Received | -19.41 | -268.61 | -1391.76 | -158.74 | -391.46 | -342.09 | -109.44 | -52.07 | -354.27 | -313.39 | -106.83 | -115
 |  |  |  |  |  | Rent Income | -259000 | -262750 | -311550 | -414750 | -445750 | -533000 | -915500 | -789500 | -789500 | -899500 | -963500 | -1038000