Spreadsheet: 818858d1677083765-loan-amortization-sheet-is-not-dynamic-problem-excel
Sheet: Monthly Financials (2)

 |  | Monthly Financials
 |  | Period Start Date |  |  |  |  | 2022-01-01 00:00:00
 |  | Period End Date
 |  | Year
 |  | Year Counter
 |  | Month Counter (Cumulative) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Month Identifier |  |  | Opening Balance
 |  | Income Statement
 |  | Revenue
 |  | Hakika Products
 |  |  | Organic
 |  |  | Avomax
 |  |  | BioLime
 |  |  | NPK
 |  |  | PereMix
 |  |  | [NAME]
 |  |  | Onion
 |  | Sub Total |  |  |  |  | 28475000 | 35964500 | 46645909.41 | 64032000 | 5827000 | 2110500 | 12995000 | 4969000 | 0 | 0 | 9472000 | 33500500
 |  | Trading Products
 |  |  | Crop Produce
 |  |  | [NAME]
 |  |  | Mineral Fertilisers
 |  | Sub Total |  |  |  |  | 0 | 0 | 0 |  |  | 42602500 | 75479750 | 37585250 | 23862000 | 2817000 | 402209920 | 251311280
 |  | Total Revenue
 |  | Cost of Sales
 |  | Hakika Products
 |  |  | Organic
 |  |  | Avomax
 |  |  | BioLime
 |  |  | NPK
 |  |  | PereMix
 |  |  | [NAME]
 |  |  | Onion
 |  | Sub Total |  |  |  |  | 0 | 3542600 | 3582200 | 4237200 | 0 | 720000 | -1398000 | 40317953.21 | 0 | 0 | 35267632.65 | 41827744.08
 |  | Trading Products
 |  |  | Crop Produce
 |  |  | [NAME]
 |  |  | Mineral Fertilisers
 |  | Sub Total |  |  |  |  | 0 | 0 | 0 | 0 | 16350000 | 32510500 | 87662500 | 25943750 | 18704000 | 2858640 | 285293720.09 | 206872154.01
 |  | Total Cost of Sales
 |  | Gross Profit
 |  | Other Income
 |  |  | Interest Income |  |  |  | 0 | 0 | 5597.94 | 0 | 0 | 1325.67 | 0 | 0 | 18236.07 | 0 | 0 | 0
 |  |  | Income from consulting |  |  |  | 0 | 0 | 0 | 0 | 43760328.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Grant Income |  |  |  | 0 | 36307476.97 | 0 | 0 | 20000000 | 47281962.61 | 8455178.94 | 175071491.74 | 0 | 176522814.32 | 0 | 0
 |  |  | Miscellanous Income |  |  |  | 0 | 0 | 0 | 577514 | 0 | 40000000 | 17320000 | 10000000 | 5000000 | 10000000 | 94135 | 94135
 |  | Total Other Income
 |  | Operating Costs
 |  |  | Advertising |  |  |  | 1150000 | 2000000 | 1850000 | 0 | 720000 | 0 | 300000 | 1205000 | 770000 | 700000 | 50000 | 1560000
 |  |  | Allowance and Per diem |  |  |  | 310000 | 416000 | 225000 | 1367000 | 6426875 | 940000 | 3225000 | 4275000 | 12562404.54 | 892520 | 1486480 | 7405000
 |  |  | Bank Fees |  |  |  | 4856.28 | 115864.27 | 224108.2 | 123734.55 | 112068.68 | 245901 | 1210283.84 | 564460.88 | 1711898.79 | 411803.47 | 379788.37 | 256122.16
 |  |  | Bank Revaluations |  |  |  | -11091.71 | 455100.37 | 1061521.82 | -261930.31 | 106171.47 | 541192.55 | 3378085.77 | 681102.83 | 211591.01 | 2379201.75 | -327236.24 | -265082.58
 |  |  | Board Member Fees |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500000 | 0 | 0 | 0 | 0
 |  |  | BRELA |  |  |  | 0 | 0 | 22000 | 0 | 0 | 0 | 22000 | 0 | 0 | 0 | 0 | 389000
 |  |  | Business Development |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 3475500 | 0 | 30000 | 0 | 0 | 0
 |  |  | Carriage Inwards |  |  |  | 0 | 1000000 | 0 | 0 | 0 | 0 | 120000 | 120000 | 0 | 508000 | 6965000 | 2000000
 |  |  | Carriage Outwards |  |  |  | 0 | 1224000 | 1075000 | 465000 | 0 | 0 | 0 | 0 | 0 | 0 | 11040000 | 2090000
 |  |  | Casual Labours |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 90000 | 84000 | 0 | 26000 | 96000 | 0
 |  |  | Cleaning |  |  |  | 0 | 0 | 0 | 30000 | 0 | 0 | 0 | 24000 | 0 | 65000 | 60000 | 25000
 |  |  | Consulting & Accounting |  |  |  | 1630000 | 500000 | 7213843.78 | 0 | 730000 | 30000 | 4485000 | 2142367 | 7085192.31 | 6868846.16 | 6664772.73 | 4384816.34
 |  |  | Contractor Costs |  |  |  | 0 | 1050000 | 0 | 2756500 | 0 | 150000 | 6079766.54 | 0 | 0 | 0 | 0 | 0
 |  |  | Disbursements and refunds |  |  |  | 0 | 55000 | 0 | 0 | 0 | 200000 | 0 | 0 | -1000000 | 0 | -17000000 | 17023760
 |  |  | Disposal of asset |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 80000000 | 0 | 0 | 0 | 0 | 0
 |  |  | Exhibition Expenses |  |  |  | 0 | 0 | 304000 | 0 | 114000 | 0 | 4743027.5 | 2966877.5 | 0 | 0 | 0 | 0
 |  |  | Fines and Penalties |  |  |  | 0 | 0 | 0 | 0 | 100000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Freight & Courier |  |  |  | 250000 | 208600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Income Tax Expense |  |  |  | 250000 | 0 | 250000 | 0 | 0 | 250000 | 0 | 0 | 250000 | 0 | 0 | 2250000
 |  |  | Insurance |  |  |  | 0 | 0 | 120000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Internships |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 200000 | 660000 | 780000 | 655000 | 989615 | 1120000
 |  |  | Laboratory analysis and Research |  |  |  | 1103506.11 | 0 | 0 | 0 | 0 | 1268083.1 | 1320000 | 2339500 | 2892487.15 | 654000 | 150000 | 180000
 |  |  | Legal expenses |  |  |  | 0 | 0 | 300000 | 0 | 100000 | 540000 | 0 | 750000 | 60000 | 0 | 0 | 75000
 |  |  | Licenses and Fees |  |  |  | 300000 | 0 | 2473980 | 0 | 301000 | 0 | 5700 | 12000 | 3001653.27 | 0 | 270000 | 686793.55
 |  |  | Loading and offloading Charges |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 30000 | 40000 | 0 | 112500 | 882000 | 338618
 |  |  | Marketing & Promotion |  |  |  | 0 | 0 | 1000000 | 0 | 0 | 0 | 450000 | 2250000 | 440000 | 591500 | 0 | 2525000
 |  |  | Miscellenous Expenses |  |  |  | 50000 | 0 | 0 | 0 | 84000 | 318045 | 5280000 | 1349500 | 0 | 0 | 14220000 | 0
 |  |  | Motor Vehicle Expenses |  |  |  | 99500 | 180000 | 239100 | 1414344 | 212500 | 218620 | 425000 | 766500 | 58300 | 150000 | 71000 | 220000
 |  |  | [NAME] |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 961348.1 | 1233370.77 | 1549840 | 1549840 | 1464200
 |  |  | Office Expenses |  |  |  | 450000 | 250000 | 0 | 855000 | 530000 | 225680 | 776840 | 63000 | 85500 | 2435800 | 3258500 | 44000
 |  |  | Printing & Stationery |  |  |  | 0 | 60000 | 74900 | 0 | 0 | 21000 | 3295300 | 505400 | 1338030 | 250000 | 613900 | 436300
 |  |  | Realised Currency Gains |  |  |  | 353067.65 | 0 | 54130.77 | 0 | 0 | 0 | -16057.27 | -990.72 | -54540.85 | 0 | 0 | -73852.67
 |  |  | Relocation costs |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5736500 | 2299000 | 0
 |  |  | Rent |  |  |  | 0 | 0 | 0 | 0 | 0 | 3000000 | 0 | 3369600 | 47815362.16 | 0 | 1000000 | 27424
 |  |  | Repairs and Maintenance |  |  |  | 248000 | 1312500 | 195000 | 1406000 | 266000 | 352000 | 232000 | 0 | 0 | 11447860 | 1702000 | 0
 |  |  | Sales Commission |  |  |  | 0 | 0 | 0 | 320000 | 2475146 | 0 | 0 | 0 | 50000 | 0 | 0 | 0
 |  |  | SDL |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 493348.31 | 619936 | 619936 | 585680
 |  |  | Security |  |  |  | 0 | 0 | 1020000 | 110000 | 40000 | 560000 | 320000 | 479000 | 340000 | 340000 | 568387.1 | 812000
 |  |  | Spare parts and other fabrication equipment |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 5072495.88 | 0 | 0 | 6548604 | 3680460 | 918800
 |  |  | Staff Donations |  |  |  | 5500000 | 8166680 | 333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300000 | 1000000
 |  |  | Staff Meals |  |  |  | 21000 | 0 | 81000 | 261600 | 6000 | 152000 | 32000 | 257000 | 491234.72 | 0 | 22000 | 0
 |  |  | Staff Refreshments |  |  |  | 0 | 1500000 | 0 | 100000 | 0 | 0 | 200000 | 2411820.64 | 0 | 1000 | 8000 | 409500
 |  |  | Stamp duty |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 63696 | 0 | 0 | 0
 |  |  | Subscriptions |  |  |  | 0 | 0 | 0 | 0 | 0 | 100000 | 672461.71 | 1721687.7 | 0 | 0 | 300000 | 40000
 |  |  | Telephone & Internet |  |  |  | 135000 | 155000 | 110000 | 395000 | 112500 | 72000 | 71000 | 76700 | 69000 | 261500 | 183000 | 376999.17
 |  |  | Trainings |  |  |  | 0 | 0 | 217000 | 414000 | 0 | 0 | 0 | 3770000 | 1800000 | 0 | 0 | 1135000
 |  |  | Transport |  |  |  | 1230400 | 1451600 | 915000 | 668000 | 1505957 | 1220663 | 4443600 | 1892930.7 | 9045422.91 | 1333500 | 315000 | 3263154
 |  |  | Travel - International |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5410017.6 | 0 | 0 | 1855200 | 0
 |  |  | Unrealised Currency Gains |  |  |  | -336476.57 | -1029.19 | 79918.43 | 290503.76 | -123843.34 | 138184.28 | 154621.24 | 97748.68 | 146098.46 | -46954.29 | -308623.18 | -185122.81
 |  |  | Utilities |  |  |  | 123514.8 | 26874.1 | 236951.85 | 352068.55 | 0 | 16796.3 | 21835.2 | 568475.9 | 195349.3 | 520155.56 | 552000 | 440311.12
 |  |  | Wages and Salaries |  |  |  | 0 | 14563760 | 15888860 | 15032068 | 8849760 | 17741093 | 375000 | 17320336.5 | 12433707.69 | 17810400 | 16562920 | 16954000.33
 |  |  | WCF |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48067 | 61668.54 | 77492 | 77492 | 73210
 |  |  | Witholding tax |  |  |  | 0 | 0 | 559.79 | 0 | 0 | 132.57 | 0 | 78019.35 | 313938.99 | 327307.69 | 313409.09 | 3780833.33
 |  | Total Operating Costs
 |  |  | Staff Costs
 |  |  | Marketing
 |  |  | Rent & leasing
 |  |  | Communication
 |  |  | Stationery
 |  |  | Utilities
 |  |  | Cleaning Costs
 |  |  | Carriage Inwards
 |  |  | Carriage Outwards
 |  |  | Research and laboratory
 |  |  | Motor Vehicle Expenses
 |  |  | Office Expenses
 |  |  | Security
 |  |  | Stamp duty
 |  |  | Subscriptions
 |  |  | Trainings
 |  |  | Witholding Tax
 |  |  | Factory supplies
 |  |  | Preventive and protective gear
 |  |  | Local transport
 |  |  | Parking fee
 |  |  | Equipments
 |  |  | Maintenance of buildings
 |  |  | Maintenance of equipment
 |  | Total Operating Costs
 | Operating Profit
 |  |  | Depreciation
 |  |  | Amortisation
 | Profits before interest and tax
 |  |  | Interest paid
 |  |  | Grants received
 | Profit before tax
 |  |  | Taxation
 | Profit after tax
 | Dividends declared
 | Retained profit for the year
 | Balance Sheet
 | Long Term Assets
 |  | Tangible Fixed Assets |  |  | 311827330.37 |  | 288180828.22 | 285886803.91 | 284092435.27 | 281601660.33 | 278720071.41 | 283300185.1700001 | 231293675.76 | 233180577.65 | 234135463.26 | 232799373.73 | 249737711.07 | 293295454.78
 |  | Intangible Fixed Assets |  |  | 1222828400 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1222828400
 |  | Investments in subsidiaries |  |  | 5536338.58 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5536338.58 | 5536338.58 | 5536338.58 | 5536338.58
 |  | Other Non-Current Investments |  |  | 220055.19 |  | 8840937 | 8840937 | 8840937 | 8840937 | 8840937 | 8840937 | 8840937 | 8840937 | 8840937 | 8840937 | 8840937 | 220055.19
 |  | Other Investments |  |  |  |  | 0 | 0 | 0 | 7627721.19 | 7627721.19 | 7627721.19 | 7627721.19 | 7627721.19 | 7627721.19 | 7627721.19 | 7627721.19 | 0
 | Total Long Term Assets
 | Current Assets
 |  | Accounts Receivable |  |  | 51467999.99999999 |  | 67582500 | 62952500 | 73323000 | 75139564 | 73920000 | 68318000 | 72382750 | 72670500 | 46540500 | 44565500 | 28757500 | 51468000
 |  | Advances to sub-grantees |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18355082.03 | 18355082.03 | 38355082.03 | 38355082.03
 |  | Staff Loan and Advances |  |  |  |  | 600000 | 600000 | 470000 | 470000 | 470000 | 140000 | 2297500 | 17918035.19 | 15714266.14 | 23285066.14 | 28529006.14 | 31264306.14
 |  | Inventory |  |  | 30530186.04 |  | 49598364 | 58219614 | 58219614 | 58219614 | 58219614 | 71339614 | 78551614 | 40118410.79 | 44168410.79 | 123581410.79 | 371389621.05 | 226576722.96
 |  | Cash |  |  | -1312850 |  | 26538700.11 | 50177721.25 | 21413807.34 | 28242069.58 | 59032995.72 | 120718879.13 | 57258548.86 | 226072324.56 | 124691182.76 | 155811353.14 | 117085803.84 | 97278872.72
 | Total Current Assets
 | Total Assets
 | Equity
 |  | Issued Share Capital |  |  | 450000000 |  | 60570160 | 60570160 | 60570160 | 60570160 | 60570160 | 60570160 | 60570160 | 60570160 | 60570160 | 60570160 | 60570160 | 450000000.61
 |  | [NAME] |  |  | 248619767.75 |  | 91044982.39 | 121615618.5 | 125502983.57 | 155261890.43 | 182949495.05 | 250478523.29 | 148979391.91 | 245009470.95 | 146819878.56 | 266254651.01 | 290972319.74 | 248619767.75
 |  | Dividends |  |  |  |  | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000 | -2500000
 | Total Equity
 | Non-Current Liabilities
 |  | Long Term Loans |  |  | 70616574.19999999 |  | 63326219.11 | 59503988.11 | 58035254.11 | 41899604.87 | 39576105.87 | 37252606.87 | 22267718.73 | 55125892.66 | 52802393.66 | 52802393.66 | 36064470.65000001 | 70616574.19999999
 |  | Accruals |  |  | 2350000 |  | 2350000 | 2350000 | 2350000 | 2350000 | 2350000 | 2350000 | 2350000 | 2350000 | 2350000 | 2350000 | 2350000 | 2350000
 |  | Intercompany Transactions |  |  | 13121922 |  | -2164000 | 6221340 | -15101795 | 721333.95 | 8413643 | 17650422 | 24650422 | 24650422 | 24650422 | 25621922 | 13121922 | 13121922
 |  | Subsidy |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 48078300
 | Total Non-Current Liabilities
 | Current Liabilities
 |  | Account Payable |  |  | 111501228.57 |  | 57407008.13 | 55605978.94 | 48432582.37 | 33037086.13 | 32169742.79 | 31401751.72 | 35922072.96 | 53887065.26 | 45966062.12 | 44460725.99 | 262254558.57 | 111501228.57
 |  | Equity Project |  |  |  |  | 6442144.09 | 0 | 5760137.95 | 5499298.11 | 0 | 0 | 5750268.6 | 0 | 5357495.16 | 0 | 0 | 0
 |  | Shareholder Advances |  |  | 1009093833 |  | 148118243.61 | 148118243.61 | 148118243.61 | 148118243.61 | 148118243.61 | 148118243.61 | 148118243.61 | 148118243.61 | 148118243.61 | 148118243.61 | 167641523.61 | 1009093833
 |  | Tax liability |  |  | 14496572 |  | 16746572 | 15194747 | 15194747 | 15194747 | 15194747 | 14974427 | 12155267 | 12155267 | 12155267 | 12137267 | 12137267 | 12137267
 |  | Wage Payable |  |  | 4124000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7072782.9 | 9330779.54 | 10910820 | 13572820 | 4124000
 | Total Current Liabilities
 | Total Equity and Liabilities
 | Net assets
 | Check
 | Cashflow Statement
 | Profit after Tax
 | Adjustment for:
 |  | Depreciation
 |  | Amortisation
 | Changes in working capital
 |  | Receivables
 |  | Payables
 |  | Inventory
 | Net cash generated from operations
 | Cashflow from Investing Activities
 |  | Tangible capital expenditure
 |  | Intangible capital expenditure
 | Net cash generated from Investing Activties
 | Cashflow from Financing Activities
 |  | Equity Issued
 |  | [NAME]
 |  | Net loans
 | Net Cash Generated from financing activitoes
 | Cash Account
 |  | Opening Cash balance |  |  | -1312850
 |  | Cash movement in the year
 | Closing cash balance