ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
COMPANY NAME: NGWALA INVENTIONS
2
PROJECTED P&L DATE 2022 - DATE 2028
3
4
5
2022202320242025202620272028AssumptionsMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12Month 13Month 14Month 15Month 16Month 17Month 18Month 19Month 20Month 21Month 22Month 23Month 24
6
7
Production
8
Vending Machines814264784151272Annual Growth 80%
9
Cumulative Machines8224895179330602Year 1 Machines8
10
Farmers Serviced800224048329498178963301260222farmers /machine100
11
Ng'wala Bio-Pesticide Litres19200537601159682279424294967922931445328Percentage of Sales40%
12
Ng'wala Bio-Fertilizer Litres4800134402899256986107374198073361332Percentage of Sales10%
13
3rd Party Bio-Pesticide Litres19200537601159682279424294967922931445328Percentage of Sales40%
14
3rd Party Bio-Fertilizer Litres4800134402899256986107374198073361332Percentage of Sales10%
15
Ng'wala Bio-Pesticide Sales13440037632081177615955973006474554605410117297Sale Price ($US)/ ltr7
16
Ng'wala Bio-Fertilizer Sales336009408020294439889975161913865132529324Sale Price / ltr7
17
3rd Party Bio-Pesticide Sales13440037632081177615955973006474554605410117297Sale Price / ltr7
18
3rd Party Bio-Fertilizer Sales336009408020294439889975161913865132529324Sale Price / ltr7
19
Litres sold 48000134400289920569856107374119807333613320litres / month / farmer5
20
Product Sales3360009408002029440398899275161861386513425293241Annual total Litres60
21
22
3rd Party Bio-Pesticide$115,200 $322,560 $695,808 $1,367,654 $2,576,978 $4,753,760 $8,671,968 Purchase Price6
23
3rd Party Bio-Fertilizer$28,800 $80,640 $173,952 $341,914 $644,244 $1,188,440 $2,167,992 Purchase Price6
24
25
Total Revenues$192,000 $537,600 $1,159,680 $2,279,424 $4,294,963 $7,922,934 $14,453,281
26
27
Cost of Goods Sold (COGS)
28
Machine Construction $16,000 $28,800 $51,840 $93,312 $167,962 $302,331 $544,196 Unit2000
29
Ng'wala Bio-Pesticide$76,800 $215,040 $463,872 $911,770 $1,717,985 $3,169,174 $5,781,312 Production Cost4
30
Ng'wala Bio-Fertilizer$19,200 $53,760 $115,968 $227,942 $429,496 $792,293 $1,445,328 Production Cost4
31
Transportation Costs$24,000 $67,200 $144,960 $284,928 $536,870 $990,367 $1,806,660 Trans / ltre0.5
32
Machine Maintenance $800 $1,440 $2,592 $4,666 $8,398 $15,117 $27,210 maint/machine/yr0.05
33
34
Gross Profit$55,200 $171,360 $380,448 $756,806 $1,434,252 $2,653,653 $4,848,575
35
 % Gross Margin29%32%33%33%33%33%34%
36
37
Sales, General and Administration
38
Staff5152535455565
39
Salary Expenses$21,000 $63,000 $105,000 $147,000 $189,000 $231,000 $273,000 pp/month 350annual projection
40
Utilities $3,600 $4,320 $5,184 $6,221 $7,465 $8,958 $10,750 cost/month30020%
41
Marketing$6,720 $18,816 $40,589 $79,780 $150,324 $277,303 $505,865 Marketing % of Sales2%
42
Other SG&A$7,000$8,050 $9,258 $10,646 $12,243 $14,080 $16,191 including legal 15%
43
44
EBITDA$16,880 $77,174 $220,418 $513,160 $1,075,220 $2,122,313 $4,042,769
45
 % EBITDA9%14%19%23%25%27%28%
46
47
Depreciation Expense$320 $576 $1,037 $1,866 $3,359 $6,047 $10,884 2%
48
EBIT $16,560 $76,598 $219,381 $511,293 $1,071,861 $2,116,266 $4,031,885
49
50
Interest Expense$0 $0 $0 $0 $0 $0 $0
51
Tax Provision$2,980.80 $13,787.64 $39,488.56 $92,032.81 $192,934.90 $380,927.88 $725,739.34 Est tax18%
52
53
Net Income$13,579 $62,810 $179,892 $419,261 $878,926 $1,735,338 $3,306,146
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