| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLIFIED PROFIT AND LOSS | Month-1 | Month-2 | Month-3 | Month-4 | Month-5 | Month-6 | Month-7 | Month-8 | Month-9 | Month-10 | Month-11 | Month-12 | Q1 (Y2) | Q2 (Y2) | Q3 (Y2) | Q4 (Y2) | Q1 (Y3) | Q2 (Y3) | Q3 (Y3) | Q4 (Y3) | Q1 (Y4) | Q2 (Y4) | Q3 (Y4) | Q4 (Y4) | Q1 (Y5) | Q2 (Y5) | Q3 (Y5) | Q4 (Y5) | Q1 (Y6) | Q2 (Y6) | Q3 (Y6) | Q4 (Y6) | ||
2 | |||||||||||||||||||||||||||||||||||
3 | REVENUE | (NOTE (1)) | (NOTE (2)) | ||||||||||||||||||||||||||||||||
4 | PoCs / Integration - Engineerig Services revenue | €0 | €0 | €0 | €25,000 | €25,000 | €50,000 | €50,000 | €50,000 | €50,000 | €100,000 | €100,000 | €125,000 | €375,000 | €195,000 | €255,000 | €405,000 | €405,000 | €390,000 | €480,000 | €465,000 | €570,000 | €540,000 | €720,000 | €780,000 | €900,000 | €825,000 | €840,000 | €690,000 | €660,000 | €705,000 | €735,000 | €675,000 | ||
5 | Subscriptions / DevSeats - Recurring revenue | €0 | €0 | €0 | €1,250 | €1,250 | €2,500 | €2,500 | €2,500 | €2,500 | €5,000 | €5,000 | €6,250 | €18,750 | €108,750 | €138,750 | €191,250 | €240,000 | €465,000 | €660,000 | €701,250 | €900,000 | €1,821,000 | €1,986,000 | €2,247,000 | €2,389,500 | €3,599,250 | €4,108,500 | €4,569,000 | €4,902,000 | €5,458,500 | €6,060,000 | €6,813,000 | ||
6 | OEM Enterprise Clients (ongoing) | 1 | 1 | 1 | 2 | 2 | 2 | 4 | 4 | 4 | 9 | 16 | 24 | 32 | 35 | 38 | 42 | 46 | 50 | 53 | 61 | 69 | 72 | 76 | 78 | 78 | 74 | 69 | 62 | 60 | |||||
7 | Ongoing project with above clients | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 5 | 6 | 6 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | |||||
8 | TOTAL REVENUE | €0 | €0 | €0 | €26,250 | €26,250 | €52,500 | €52,500 | €52,500 | €52,500 | €105,000 | €105,000 | €131,250 | €393,750 | €303,750 | €393,750 | €596,250 | €645,000 | €855,000 | €1,140,000 | €1,166,250 | €1,470,000 | €2,361,000 | €2,706,000 | €3,027,000 | €3,289,500 | €4,424,250 | €4,948,500 | €5,259,000 | €5,562,000 | €6,163,500 | €6,795,000 | €7,488,000 | ||
9 | €603,750 | €1,687,500 | €3,806,250 | €9,564,000 | €17,921,250 | €26,008,500 | |||||||||||||||||||||||||||||
10 | EXPENSES | ||||||||||||||||||||||||||||||||||
11 | Salaries (detailed brakedown in next sheet) | €66,750 | €66,750 | €84,750 | €102,750 | €106,750 | €106,750 | €110,750 | €110,750 | €110,750 | €120,750 | €120,750 | €120,750 | €530,550 | €579,150 | €666,630 | €666,630 | €898,420 | €950,908 | €1,017,392 | €1,017,392 | €1,253,728 | €1,253,728 | €1,336,869 | €1,336,869 | €1,475,186 | €1,475,186 | €1,539,431 | €1,539,431 | €1,678,836 | €1,678,836 | €1,743,081 | €1,743,081 | ||
12 | Headcount summary | 13 | 13 | 16 | 19 | 20 | 20 | 22 | 22 | 22 | 25 | 25 | 25 | 33 | 33 | 37 | 37 | 46 | 46 | 50 | 50 | 60 | 60 | 62 | 62 | 69 | 69 | 72 | 72 | 79 | 79 | 82 | 82 | ||
13 | General & administrative expenses & Subscriptions | €3,250 | €3,250 | €4,000 | €4,750 | €5,000 | €5,000 | €5,500 | €5,500 | €5,500 | €6,250 | €6,250 | €6,250 | €24,750 | €24,750 | €27,750 | €27,750 | €69,000 | €69,000 | €75,000 | €75,000 | €90,000 | €90,000 | €93,000 | €93,000 | €103,500 | €103,500 | €108,000 | €108,000 | €118,500 | €118,500 | €123,000 | €123,000 | ||
14 | Sales & Marketing (including Travel, Expos) | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €10,000 | €30,000 | €30,000 | €30,000 | €30,000 | €90,000 | €90,000 | €90,000 | €90,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | €120,000 | ||
15 | Legal & Accounting expenses | €70,000 | €2,000 | €2,000 | €2,000 | €2,000 | €2,000 | €2,000 | €2,000 | €2,000 | €2,000 | €2,000 | €2,000 | €12,000 | €12,000 | €12,000 | €12,000 | €15,000 | €15,000 | €15,000 | €15,000 | €30,000 | €30,000 | €30,000 | €30,000 | €45,000 | €45,000 | €45,000 | €45,000 | €60,000 | €60,000 | €60,000 | €60,000 | ||
16 | Profesional Memberships & Insurance | €30,000 | €30,000 | €40,000 | €50,000 | €35,000 | €40,000 | €45,000 | €80,000 | €80,000 | €80,000 | €80,000 | €80,000 | ||||||||||||||||||||||
17 | Equipment & External Certification Audit | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | €50,000 | |||||||||||||||||||||||||
18 | TOTAL EXPENSES (MONTHLY / QARTERLY BURN RATE) | €150,000 | €82,000 | €100,750 | €119,500 | €123,750 | €153,750 | €178,250 | €128,250 | €178,250 | €139,000 | €189,000 | €169,000 | €597,300 | €735,900 | €736,380 | €786,380 | €1,072,420 | €1,209,908 | €1,197,392 | €1,237,392 | €1,493,728 | €1,588,728 | €1,579,869 | €1,659,869 | €1,743,686 | €1,873,686 | €1,812,431 | €1,892,431 | €1,977,336 | €2,107,336 | €2,046,081 | €2,176,081 | ||
19 | EBIT (monthly / QUARTERLY result) | -€150,000 | -€82,000 | -€100,750 | -€93,250 | -€97,500 | -€101,250 | -€125,750 | -€75,750 | -€125,750 | -€34,000 | -€84,000 | -€37,750 | -€203,550 | -€432,150 | -€342,630 | -€190,130 | -€427,420 | -€354,908 | -€57,392 | -€71,142 | -€23,728 | €772,272 | €1,126,131 | €1,367,131 | €1,545,814 | €2,550,564 | €3,136,069 | €3,366,569 | €3,584,664 | €4,056,164 | €4,748,919 | €5,311,919 | ||
20 | Tax outside of salaries (coorporate tax, VAT) | ||||||||||||||||||||||||||||||||||
21 | Tax returns (VAT) | ||||||||||||||||||||||||||||||||||
23 | NET INCOME (monthly / QUARTERLY result) | -€150,000 | -€82,000 | -€100,750 | -€93,250 | -€97,500 | -€101,250 | -€125,750 | -€75,750 | -€125,750 | -€34,000 | -€84,000 | -€37,750 | -€203,550 | -€432,150 | -€342,630 | -€190,130 | -€427,420 | -€354,908 | -€57,392 | -€71,142 | -€23,728 | €772,272 | €1,126,131 | €1,367,131 | €1,545,814 | €2,550,564 | €3,136,069 | €3,366,569 | €3,584,664 | €4,056,164 | €4,748,919 | €5,311,919 | ||
24 | Equity Financing | €1,000,000 | €1,000,000 | €500,000 | |||||||||||||||||||||||||||||||
25 | ENDING CASH BALANCE | €850,000 | €768,000 | €1,667,250 | €1,574,000 | €1,476,500 | €1,375,250 | €1,249,500 | €1,173,750 | €1,048,000 | €1,014,000 | €930,000 | €1,392,250 | €1,188,700 | €756,550 | €413,920 | €223,790 | -€203,630 | -€558,537 | -€615,930 | -€687,072 | -€710,800 | €61,471 | €1,187,602 | €2,554,733 | €4,100,547 | €6,651,111 | €9,787,180 | €13,153,749 | €16,738,413 | €20,794,577 | €25,543,496 | €30,855,415 | ||
26 | Month-1 | Month-2 | Month-3 | Month-4 | Month-5 | Month-6 | Month-7 | Month-8 | Month-9 | Month-10 | Month-11 | Month-12 | Q1 (Y2) | Q2 (Y2) | Q3 (Y2) | Q4 (Y2) | Q1 (Y3) | Q2 (Y3) | Q3 (Y3) | Q4 (Y3) | Q1 (Y4) | Q2 (Y4) | Q3 (Y4) | Q4 (Y4) | Q1 (Y5) | Q2 (Y5) | Q3 (Y5) | Q4 (Y5) | Q1 (Y6) | Q2 (Y6) | Q3 (Y6) | Q4 (Y6) | |||
27 | |||||||||||||||||||||||||||||||||||
28 | |||||||||||||||||||||||||||||||||||
29 | NOTE (1): | ||||||||||||||||||||||||||||||||||
30 | Revenue for M1 - M3 set at 0 as current revenue would depend on actual starting date | ||||||||||||||||||||||||||||||||||
31 | |||||||||||||||||||||||||||||||||||
32 | NOTE (2): | ||||||||||||||||||||||||||||||||||
33 | Typical clients have 2 main characteristics: | ||||||||||||||||||||||||||||||||||
34 | (1) Land and expand model - start with one project, than expand | ||||||||||||||||||||||||||||||||||
35 | (2) Start with PoC and Integration phase, than recuring revenue (for each project) | ||||||||||||||||||||||||||||||||||
36 | |||||||||||||||||||||||||||||||||||
37 | |||||||||||||||||||||||||||||||||||
38 | |||||||||||||||||||||||||||||||||||
39 | |||||||||||||||||||||||||||||||||||
40 | |||||||||||||||||||||||||||||||||||
41 | |||||||||||||||||||||||||||||||||||
42 | |||||||||||||||||||||||||||||||||||
43 | |||||||||||||||||||||||||||||||||||
44 | |||||||||||||||||||||||||||||||||||
45 | |||||||||||||||||||||||||||||||||||
46 | |||||||||||||||||||||||||||||||||||
47 | |||||||||||||||||||||||||||||||||||
48 | |||||||||||||||||||||||||||||||||||
49 | |||||||||||||||||||||||||||||||||||
50 | GENERAL SUMMARY | Q1 (Y1) | Q2 (Y1) | Q3 (Y1) | Q4 (Y1) | Q1 (Y2) | Q2 (Y2) | Q3 (Y2) | Q4 (Y2) | Q1 (Y3) | Q2 (Y3) | Q3 (Y3) | Q4 (Y3) | Q1 (Y4) | Q2 (Y4) | Q3 (Y4) | Q4 (Y4) | Q1 (Y5) | Q2 (Y5) | Q3 (Y5) | Q4 (Y5) | Q1 (Y6) | Q2 (Y6) | Q3 (Y6) | Q4 (Y6) | ||||||||||
51 | REVENUE | €0 | €105,000 | €157,500 | €341,250 | €393,750 | €303,750 | €393,750 | €596,250 | €645,000 | €855,000 | €1,140,000 | €1,166,250 | €1,470,000 | €2,361,000 | €2,706,000 | €3,027,000 | €3,289,500 | €4,424,250 | €4,948,500 | €5,259,000 | €5,562,000 | €6,163,500 | €6,795,000 | €7,488,000 | ||||||||||
52 | EXPENSES | €332,750 | €397,000 | €484,750 | €497,000 | €597,300 | €735,900 | €736,380 | €786,380 | €1,072,420 | €1,209,908 | €1,197,392 | €1,237,392 | €1,493,728 | €1,588,728 | €1,579,869 | €1,659,869 | €1,743,686 | €1,873,686 | €1,812,431 | €1,892,431 | €1,977,336 | €2,107,336 | €2,046,081 | €2,176,081 | ||||||||||
53 | €603,750 | €1,687,500 | €3,806,250 | €9,564,000 | €17,921,250 | €26,008,500 | |||||||||||||||||||||||||||||
54 | |||||||||||||||||||||||||||||||||||
55 | |||||||||||||||||||||||||||||||||||
56 | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | |||||||||||||||||||||||||||||
57 | €603,750 | €1,687,500 | €3,806,250 | €9,564,000 | €17,921,250 | €26,008,500 | |||||||||||||||||||||||||||||
58 | |||||||||||||||||||||||||||||||||||
59 | |||||||||||||||||||||||||||||||||||
60 | |||||||||||||||||||||||||||||||||||
61 | |||||||||||||||||||||||||||||||||||
62 | |||||||||||||||||||||||||||||||||||
63 | |||||||||||||||||||||||||||||||||||
64 | |||||||||||||||||||||||||||||||||||
65 | |||||||||||||||||||||||||||||||||||
66 | |||||||||||||||||||||||||||||||||||
67 | |||||||||||||||||||||||||||||||||||
68 | |||||||||||||||||||||||||||||||||||
69 | |||||||||||||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||||||||||
71 | |||||||||||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||||||||||
73 | |||||||||||||||||||||||||||||||||||
74 | |||||||||||||||||||||||||||||||||||
75 | |||||||||||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||||||||||
78 | |||||||||||||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||||||||||
82 |