Create 1 Excel Sheet for all Financials (3 Statements for 3 years)

P&L

Balance Sheet

Cash Flow Statements

For the year 2019 is no cashflow data available. Also don't have any debt Capital

Profit and Loss For years ended March 2019, 2020, and 2021 Account 2021 2020 2019 171.099,85 Turnover Sales Subscriptions - SaaS Sales Services Overage- ID&V Total Turnover 521.581,98 24.843,42 27.377,45 40.176,00 89.641,33 546.425,40 260.741,18 67.553,45 0,00 Cost of Sales Cost of Sales - Hosting Costs - AWS Cost of Sales - External Services - Other Penetration Testing Total Cost of Sales - 16.658,33 (32.507,60) (90.931,93) (10.500,00) (133.939,53) (23.943,93) (88.483,94) (8.800,00) (121.227,87) -9.180,00 (25.838,33) Gross Profit 412.485,87 139.513,31 41.715,12 Selling and Distribution Costs Sales and Marketing Sales Consultancy Sales Salaries 0,00 0,00 0,00 (13.737,50) (142.912,29) (53.989,79) (14.950,45) 0,00 Marketing Salaries CSM Salaries (54.683,16) (25.666,09) 0,00 0,00 0,00 0,00 (15.526,80) (472,11) (341,85) (169,15) (28.694,61) (5.698,78) (3.467,37) (211,21) 0,00 Travel - International Sales and Marketing) Travel - National (Sales and Marketing) Travel National (admin) Subsistence - Sales and Marketing Entertainment -0% - Sales and Marketing Advertising & Marketing Marketing Events (including conferences and awards) Conferencing and investor events (admin) Pleo default account Total Sales and Marketing Total Selling and Distribution Costs (276,77) (161,18) (54.622,91) 0,00 (281,70) 0,00 (6.647,86) 0,00 (53.776,61) (24.400,93) (706,66) 0,00 0,00 (65,80) 0,00 0,00 (281.530,65) (281.530,65) (197.474,57) (197.474,57) (22.456,36) (22.456,36) Administrative Costs Premises Costs Rent (23.316,96) (37.065,61) (5.280,00) 32,37 (428,26) 1.291,85 Rates Light, Power, Heating Total Premises Costs Administrative Costs Staff Costs (23.316,96) (42.313,24) 863,59 (226.511.24) (332.575,21) (387.767,59) (242.298,73) (261.331,35) (107.842,20) Directors' Remuneration Technical Salaries Employers National Insurance Pension Costs 0,00 0,00 0.00 0,00 Total Staff Costs (720.342,80) (10.278,06) (1.344,00) (345.975,50) (3.750,00) (1.300,00) (81042) (58 261,33) 0,00 (21.692,77) 0,00 0,00 (503.630,08) (40.263,00) (18.160,00) (10 406,68) (400,00) (23.828.45) (1.622,02) (164,95) (209,93) (603,48) 0.00 (15.379,88) (4.627,95) (151,50) (668,12) (448,80) (79,59) (26.23) 426,86 0,00 (230.45) 0,00 (22.715,82) (3.988,00) (154,50) (55.762,76) (3.366,89) 0,00 (928,16) Legal Expenses Legal and Professional Raise Costs Only Administrative IT costs and consumables (notcostofsales) Nivo developmentcosts Recruitment, Staff Training, Employment Veting & other staffrelated costs Insurance Bank Fees Go cardless fees and other fees deducted from income Subscriptions Charitable and Political Donations Audit & Accountancy fees Telephone & Internet Printing & Stationery Postage, Freight & Courier Bank Revaluations Subsistence - Admin only Entertaining 0%-Admin only Entertainment- 100% business -employee only events General Expenses Realised Currency Gains Foreign exchange Bad debtprovision P&L Depreciation Expense Information Security Total Administrative Costs Total Administrative Costs (1.737,36) (348.45) (184,10) (446,19) (292,00) (8,19) 0,00 0,00 (184,60) (21,71) 0.00 0 (449,10) (35,05) (872,48 0,00 0 (2.826,90) 0.00 (204,52) (78,59) 0,00 (48,31) 0,00 (4.974,00) 0,00 (1.138,35) (19,04) (332,51) (528.48) (14.555,06) (14.674,75) (912.155,00) (935 471,96) (6.188,83) 0,00 (9.581,55) 0,00 (649 480,99) (691.794,23) (357.617,33) (356.753,74) Total Overheads (1.217.002,61) (889.268,80) (379.210,10) Other Operating Income Other Revenue 0,69 13,04 44,69 Total Other Operating Income 0,69 13,04 44,69 Operating Profit (804.516,05) (749.742.45) (337 450,29) Interest Paid Interest Paid Total Interest Paid (1.180,00) 0,00 0.00 (1.180,00) 0,00 0,00 Interest Received Interest Income Total Interest Received 1.269,44 5.281,88 164,08 1.269,44 5.281,88 164,08 Profit on Ordinary Activities Before Taxation (804426,61) (744.460,57) (337286,21) Taxation R&D Tax Credits - rebates Total Taxation 133.458,00 180.739,00 80.740,64 133 458,00 180.739,00 80.740,64 Profit after Taxation (670.968,61) (563.721,57) (256.545,57) Balance Sheet For years ended March 2019, 2020, and 2021 Account 2021 2020 2019 Non Current Assets Tangible Fixed Assets: Computer Equipment 25.299,00 0,00 34.332,00 34.332,00 25.299,00 0,00 Current Assets Cash at Bank Accounts Receivable Prepayments 762.792,00 36.785,00 3.322,00 568.768,00 900,00 1.201.711,00 64.984,00 19.914,00 180.739,00 0,00 Other Debtors 0,00 0,00 VAT Receivable 0,00 0,00 0,00 Total Current Assets Total Assets 802.899,00 837.231,00 1.467.348,00 1.492.647,00 569.668,00 569.668,00 Creditors: due within one year Directors Loan Account PAYE Pensions Credit Card Accounts Payable Accruals Deferred Income VAT Payable 0,00 (32.452,00) (2.719,00) 0,00 (33.732,00) (52.975,00) (121.312,00) (16.518,00) 0,00 (25.298,00) (2.380,00) (219,00) (13.658,00) (16.720,00) (44.539,00) (7.882,00) (9.600,00) (11.613,00) (591,00) (97,00) 0,00 (12.844,00) (7.699,00) (2.405,00) Total Current Liabilities (259.708,00) (110.696,00) (44.849,00) Net Current Assets Total Assets less Current Liabilities Net Assets 543.191,00 577.523,00 1.356.652,00 1.381.951,00 1.381.951,00 524.819,00 524.819,00 524.819,00 577.523,00 338,00 Capital and Reserves Share Capital Share Premium Current Year Earnings/ (Losses) Retained Earnings /(Losses) 338,00 954.962,00 2.375.815,00 568,00 2.375.584,00 (804.427,00) (994.202,00) 577.523,00 (563.721,00) (430.481,00) 1.381.951,00 (256.545,00) (173.936,00) 524.819,00 Cash Flow Statements For years ended March 2019, 2020, and 2021 2021 2020 2019 2019 2021 (791.961,00) 2020 (743.413,00) Account EBITDA Changes in Working Capital: (Increase) / Decrease in Trade and Other Receivables Increase/(Decrease) in Trade and Other Payables Increase / (Decrease) in PAYE, VAT & Taxation 225.529,00 135.622,00 15.390,00 (88.318,00) 46.518,00 19.189,00 376.541,00 (22.611,00) Cash Inflow/ (outflow) from operations Cash flows from investing activities: Purchase of Fixed Assets Disposal of Assets Investments Capital Introduced Employee Loan Interest Received Interest Paid Cash flows from Investing Activities (23.588,00) 0,00 0,00 0,00 0,00 1.270,00 (1.180,00) (31.487,00) 0,00 0.00 1.420.853,00 0,00 5.281,00 0,00 (23.498,00) 1.394.647,00 Cash flows from Financing Activities Cash flows from Taxation Increasel (Decrease) in Cash 0,00 0,00 (438.918,00) 0,00 0,00 628.623,00 Opening Bank Closing Bank 1.201.711,00 762.793,00 568.768,00 1.197.391,00 Movement in Bank Balance (438.918,00)| 628.623,00 Profit and Loss For years ended March 2019, 2020, and 2021 Account 2021 2020 2019 171.099,85 Turnover Sales Subscriptions - SaaS Sales Services Overage- ID&V Total Turnover 521.581,98 24.843,42 27.377,45 40.176,00 89.641,33 546.425,40 260.741,18 67.553,45 0,00 Cost of Sales Cost of Sales - Hosting Costs - AWS Cost of Sales - External Services - Other Penetration Testing Total Cost of Sales - 16.658,33 (32.507,60) (90.931,93) (10.500,00) (133.939,53) (23.943,93) (88.483,94) (8.800,00) (121.227,87) -9.180,00 (25.838,33) Gross Profit 412.485,87 139.513,31 41.715,12 Selling and Distribution Costs Sales and Marketing Sales Consultancy Sales Salaries 0,00 0,00 0,00 (13.737,50) (142.912,29) (53.989,79) (14.950,45) 0,00 Marketing Salaries CSM Salaries (54.683,16) (25.666,09) 0,00 0,00 0,00 0,00 (15.526,80) (472,11) (341,85) (169,15) (28.694,61) (5.698,78) (3.467,37) (211,21) 0,00 Travel - International Sales and Marketing) Travel - National (Sales and Marketing) Travel National (admin) Subsistence - Sales and Marketing Entertainment -0% - Sales and Marketing Advertising & Marketing Marketing Events (including conferences and awards) Conferencing and investor events (admin) Pleo default account Total Sales and Marketing Total Selling and Distribution Costs (276,77) (161,18) (54.622,91) 0,00 (281,70) 0,00 (6.647,86) 0,00 (53.776,61) (24.400,93) (706,66) 0,00 0,00 (65,80) 0,00 0,00 (281.530,65) (281.530,65) (197.474,57) (197.474,57) (22.456,36) (22.456,36) Administrative Costs Premises Costs Rent (23.316,96) (37.065,61) (5.280,00) 32,37 (428,26) 1.291,85 Rates Light, Power, Heating Total Premises Costs Administrative Costs Staff Costs (23.316,96) (42.313,24) 863,59 (226.511.24) (332.575,21) (387.767,59) (242.298,73) (261.331,35) (107.842,20) Directors' Remuneration Technical Salaries Employers National Insurance Pension Costs 0,00 0,00 0.00 0,00 Total Staff Costs (720.342,80) (10.278,06) (1.344,00) (345.975,50) (3.750,00) (1.300,00) (81042) (58 261,33) 0,00 (21.692,77) 0,00 0,00 (503.630,08) (40.263,00) (18.160,00) (10 406,68) (400,00) (23.828.45) (1.622,02) (164,95) (209,93) (603,48) 0.00 (15.379,88) (4.627,95) (151,50) (668,12) (448,80) (79,59) (26.23) 426,86 0,00 (230.45) 0,00 (22.715,82) (3.988,00) (154,50) (55.762,76) (3.366,89) 0,00 (928,16) Legal Expenses Legal and Professional Raise Costs Only Administrative IT costs and consumables (notcostofsales) Nivo developmentcosts Recruitment, Staff Training, Employment Veting & other staffrelated costs Insurance Bank Fees Go cardless fees and other fees deducted from income Subscriptions Charitable and Political Donations Audit & Accountancy fees Telephone & Internet Printing & Stationery Postage, Freight & Courier Bank Revaluations Subsistence - Admin only Entertaining 0%-Admin only Entertainment- 100% business -employee only events General Expenses Realised Currency Gains Foreign exchange Bad debtprovision P&L Depreciation Expense Information Security Total Administrative Costs Total Administrative Costs (1.737,36) (348.45) (184,10) (446,19) (292,00) (8,19) 0,00 0,00 (184,60) (21,71) 0.00 0 (449,10) (35,05) (872,48 0,00 0 (2.826,90) 0.00 (204,52) (78,59) 0,00 (48,31) 0,00 (4.974,00) 0,00 (1.138,35) (19,04) (332,51) (528.48) (14.555,06) (14.674,75) (912.155,00) (935 471,96) (6.188,83) 0,00 (9.581,55) 0,00 (649 480,99) (691.794,23) (357.617,33) (356.753,74) Total Overheads (1.217.002,61) (889.268,80) (379.210,10) Other Operating Income Other Revenue 0,69 13,04 44,69 Total Other Operating Income 0,69 13,04 44,69 Operating Profit (804.516,05) (749.742.45) (337 450,29) Interest Paid Interest Paid Total Interest Paid (1.180,00) 0,00 0.00 (1.180,00) 0,00 0,00 Interest Received Interest Income Total Interest Received 1.269,44 5.281,88 164,08 1.269,44 5.281,88 164,08 Profit on Ordinary Activities Before Taxation (804426,61) (744.460,57) (337286,21) Taxation R&D Tax Credits - rebates Total Taxation 133.458,00 180.739,00 80.740,64 133 458,00 180.739,00 80.740,64 Profit after Taxation (670.968,61) (563.721,57) (256.545,57) Balance Sheet For years ended March 2019, 2020, and 2021 Account 2021 2020 2019 Non Current Assets Tangible Fixed Assets: Computer Equipment 25.299,00 0,00 34.332,00 34.332,00 25.299,00 0,00 Current Assets Cash at Bank Accounts Receivable Prepayments 762.792,00 36.785,00 3.322,00 568.768,00 900,00 1.201.711,00 64.984,00 19.914,00 180.739,00 0,00 Other Debtors 0,00 0,00 VAT Receivable 0,00 0,00 0,00 Total Current Assets Total Assets 802.899,00 837.231,00 1.467.348,00 1.492.647,00 569.668,00 569.668,00 Creditors: due within one year Directors Loan Account PAYE Pensions Credit Card Accounts Payable Accruals Deferred Income VAT Payable 0,00 (32.452,00) (2.719,00) 0,00 (33.732,00) (52.975,00) (121.312,00) (16.518,00) 0,00 (25.298,00) (2.380,00) (219,00) (13.658,00) (16.720,00) (44.539,00) (7.882,00) (9.600,00) (11.613,00) (591,00) (97,00) 0,00 (12.844,00) (7.699,00) (2.405,00) Total Current Liabilities (259.708,00) (110.696,00) (44.849,00) Net Current Assets Total Assets less Current Liabilities Net Assets 543.191,00 577.523,00 1.356.652,00 1.381.951,00 1.381.951,00 524.819,00 524.819,00 524.819,00 577.523,00 338,00 Capital and Reserves Share Capital Share Premium Current Year Earnings/ (Losses) Retained Earnings /(Losses) 338,00 954.962,00 2.375.815,00 568,00 2.375.584,00 (804.427,00) (994.202,00) 577.523,00 (563.721,00) (430.481,00) 1.381.951,00 (256.545,00) (173.936,00) 524.819,00 Cash Flow Statements For years ended March 2019, 2020, and 2021 2021 2020 2019 2019 2021 (791.961,00) 2020 (743.413,00) Account EBITDA Changes in Working Capital: (Increase) / Decrease in Trade and Other Receivables Increase/(Decrease) in Trade and Other Payables Increase / (Decrease) in PAYE, VAT & Taxation 225.529,00 135.622,00 15.390,00 (88.318,00) 46.518,00 19.189,00 376.541,00 (22.611,00) Cash Inflow/ (outflow) from operations Cash flows from investing activities: Purchase of Fixed Assets Disposal of Assets Investments Capital Introduced Employee Loan Interest Received Interest Paid Cash flows from Investing Activities (23.588,00) 0,00 0,00 0,00 0,00 1.270,00 (1.180,00) (31.487,00) 0,00 0.00 1.420.853,00 0,00 5.281,00 0,00 (23.498,00) 1.394.647,00 Cash flows from Financing Activities Cash flows from Taxation Increasel (Decrease) in Cash 0,00 0,00 (438.918,00) 0,00 0,00 628.623,00 Opening Bank Closing Bank 1.201.711,00 762.793,00 568.768,00 1.197.391,00 Movement in Bank Balance (438.918,00)| 628.623,00