ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
Jan-22Feb-22Mar-22Mar-22Apr-22May-22Jun-22Jul-22Aug-22Sep-22Oct-22Nov-22Total 2022Jan-23Feb-23Mar-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Total 2023
3
4
PRO-FORMA P&L ($)
5
6
Revenues178,550200,668223,452247,218271,519301,569332,635364,319401,784440,617484,574529,2503,976,153567,609612,322659,027706,997756,575813,828872,631938,6091,007,2921,078,3281,156,5291,242,37710,412,123
7
8
CoGS36,97248,58246,27867,27861,10473,31380,70979,08791,852134,892133,269132,616985,953157,827164,175181,872186,607207,789215,120233,764259,992263,230295,148306,307323,9322,795,763
9
% of revenues
21%24%21%27%23%24%24%22%23%31%28%25%25%28%27%28%26%27%26%27%28%26%27%26%26%27%
10
11
Gross Profit
141,578152,086177,174179,939210,415228,255251,926285,231309,932305,724351,305396,6342,990,200409,782448,147477,154520,389548,786598,708638,867678,618744,062783,180850,222918,4457,616,360
12
% of revenues
79%76%79%73%77%76%76%78%77%69%72%75%75%72%73%72%74%73%74%73%72%74%73%74%74%73%
13
14
Operating Costs
15
16
R&D89,36089,360120,440108,440132,500145,220148,090202,000198,030216,280208,280230,6701,888,670233,030229,030229,030229,030229,030229,030229,030229,030229,030229,030229,030229,0302,752,360
17
% of revenues
50%45%54%44%49%48%45%55%49%49%43%44%47%41%37%35%32%30%28%26%24%23%21%20%18%26%
18
19
S&M59,25095,500131,250133,250143,250191,250215,300217,300227,300237,300259,900265,9002,176,750275,900285,900295,900305,900315,900373,650371,650381,650391,650401,650411,650437,9004,249,300
20
% of revenues
33%48%59%54%53%63%65%60%57%54%54%50%55%49%47%45%43%42%46%43%41%39%37%36%35%41%
21
22
G&A117,228150,533105,873106,261166,676153,728180,232157,566198,139168,781195,679199,8881,900,583192,905215,066201,026217,050248,154225,666241,957216,355250,890237,541251,026210,9442,708,581
23
% of revenues
66%75%47%43%61%51%54%43%49%38%40%38%48%34%35%31%31%33%28%28%23%25%22%22%17%26%
24
25
Total Operating Costs
265,838335,393357,563347,951442,426490,198543,622576,866623,469622,361663,859696,4585,966,003701,835729,996725,956751,980793,084828,346842,637827,035871,570868,221891,706877,8749,710,241
26
% of revenues
149%167%160%141%163%163%163%158%155%141%137%132%150%124%119%110%106%105%102%97%88%87%81%77%71%93%
27
28
EBIT-124,259-183,307-180,389-168,012-232,011-261,943-291,696-291,634-313,537-316,637-312,553-299,824-2,975,803-292,053-281,849-248,802-231,590-244,298-229,639-203,769-148,418-127,508-85,042-41,48540,571-2,093,881
29
30
OPERATING CASH FLOW ($)
31
Cash inflow329,550395,668402,452410,218418,519487,569497,635508,319579,784592,617474,574489,2505,586,153709,609852,822872,027892,497914,5751,064,8281,090,6311,178,6091,269,2921,302,3281,272,0291,370,37712,789,623
32
Cash outflow
274,919355,015417,801378,969466,710585,802578,631604,543741,311701,113739,7681,107,3746,951,956800,607834,796925,814878,252939,6581,059,932998,2251,007,8121,181,2641,082,6341,116,6391,680,37112,506,004
33
Total operating cashflow
54,63140,653-15,34931,248-48,191-98,233-80,996-96,224-161,527-108,497-265,193-618,124-1,365,803-90,99818,026-53,78714,245-25,0834,89692,406170,79788,027219,693155,390-309,994283,619
34
35
BANK BALANCE ($)
36
Starting bank balance
500,0005,554,6315,595,2835,579,9355,611,1835,562,9925,464,7585,383,7635,287,5385,126,0115,017,5144,752,3214,134,1974,043,1994,061,2254,007,4384,021,6833,996,6004,001,4964,093,9024,264,6994,352,7274,572,4204,727,810
37
Cash from financing
5,000,000000000000005,000,0000000000000000
38
Cash from operations
54,63140,653-15,34931,248-48,191-98,233-80,996-96,224-161,527-108,497-265,193-618,124-1,365,803-90,99818,026-53,78714,245-25,0834,89692,406170,79788,027219,693155,390-309,994283,619
39
Ending bank balance
5,554,6315,595,2835,579,9355,611,1835,562,9925,464,7585,383,7635,287,5385,126,0115,017,5144,752,3214,134,1974,043,1994,061,2254,007,4384,021,6833,996,6004,001,4964,093,9024,264,6994,352,7274,572,4204,727,8104,417,817
40
41
Disclaimer: Please be aware that his model may be inaccurate, incorrect or misleading.
42
Use it at your own risk, yada yada yada.
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100