ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1
Profit & Loss (Cash basis)
2
20172018201920202021
3
4
2017-60 Days-30 DaysMonth 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12Year EndGrowth RateProjectedGrowth RateProjectedGrowth RateProjectedGrowth RateProjectedGrowth RateProjected
5
Income
6
Revenue
7
Capital Raised (Equity)300,0001,700,000------------2,000,0000%2,000,000
8
Sales Ramp Up cashflow(150,000)(75,000)(25,000)(250,000)0%(250,000)
9
Sales (washed sand)146,250146,250146,250146,250146,250146,250146,250146,250146,250146,250146,2501,608,7500%1,608,7502%1,640,9252%1,673,7442%1,707,2182%1,741,363
10
Sales (gravel)60,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,000660,0000%660,0002%673,2002%686,6642%700,3972%714,405
11
Sales (fill)2,5002,5002,5002,5002,5002,5002,5002,5002,5002,5002,50027,5000%27,5002%28,0502%28,6112%29,1832%29,767
12
Total sales + Capital Raised300,0001,700,000-58,750133,750183,750208,750208,750208,750208,750208,750208,750208,750208,7502,046,2504,046,2502,342,1752,389,0192,436,7992,485,535
13
14
Cost of sales
15
Equipment lease254,96522,72222,72222,72222,72222,72222,72222,72222,72222,72222,72222,72222,722272,663272,6630%272,6630%272,6630%272,6630%272,663
16
Power and Water1,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,0001,00012,00012,0002%12,2402%12,4852%12,7342%12,989
17
Insurance2,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,0002,00024,00024,0002%24,4802%24,9702%25,4692%25,978
18
Site Manager wages8,4008,4008,4008,4008,4008,4008,4008,4008,4008,4008,4008,400100,800100,8003%103,8243%106,9393%110,1473%113,451
19
Communications5005005005005005005005005005005005006,0006,0003%6,1803%6,3653%6,5563%6,753
20
Consumables1,7001,7001,7001,7001,7001,7001,7001,7001,7001,7001,7001,70020,40020,4003%21,0123%21,6423%22,2923%22,960
21
ERA Fees6206206206206206206206206206206206207,4407,4400%7,4400%7,4400%7,4400%7,440
22
Rehab1,8251,8251,8251,8251,8251,8251,8251,8251,8251,8251,8251,82521,90021,9003%22,5573%23,2343%23,9313%24,649
23
Fuel 16,00016,00016,00016,00016,00016,00016,00016,00016,00016,00016,00016,000192,000192,0003%197,7603%203,6933%209,8043%216,098
24
Wages 2 x Operators14,00014,00014,00014,00014,00014,00014,00014,00014,00014,00014,00014,000168,000168,0003%173,0403%178,2313%183,5783%189,085
25
Maintenance3,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,00036,00036,0003%37,0803%38,1923%39,3383%40,518
26
Rent + Land debt servicing 12,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,50012,500150,000150,0000%150,0000%150,0000%150,0000%150,000
27
Sales & Marketing/Public Relations4,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,0004,00048,00048,0002%48,9602%49,9392%50,9382%51,957
28
-------------0%-0%-0%-0%-
29
Total cost of sales-254,96588,26788,26788,26788,26788,26788,26788,26788,26788,26788,26788,26788,2671,059,2031,059,2031,077,2361,095,7931,114,8891,134,542
30
31
Gross Margin
300,0001,445,035(88,267)(29,517)45,48395,483120,483120,483120,483120,483120,483120,483120,483120,4831,075,3141,075,3141,264,9391,293,2261,321,9091,350,993
32
33
Expenses
34
Start Up Cost Dep'n (3 yrs)1,186,25032,95132,95132,95132,95132,95132,95132,95132,95132,95132,95132,95132,951395,417395,4170%395,4170%395,417-100%-0%-
35
Site Estblishment Dep'n (3 yrs)461,38712,81612,81612,81612,81612,81612,81612,81612,81612,81612,81612,81612,816153,796153,7960%153,7960%153,796-100%-0%-
36
Equipment deposits (3 yrs)7,0827,0827,0827,0827,0827,0827,0827,0827,0827,0827,0827,08284,98884,9880%84,9880%84,988-100%-0%-
37
Pref Share Equity Repayment (balance)40,00040,00040,0000%40,0000%40,000-100%-0%-
38
Total expenses-1,647,63752,85052,85052,85052,85052,85052,85052,85052,85052,85052,85052,85092,850674,201674,201674,201674,201--
39
40
Total Cash Operating Profit (Loss)300,000(202,602)(141,117)(82,367)(7,367)42,63367,63367,63367,63367,63367,63367,63367,63327,633453,964453,964590,739619,0251,321,9091,350,993
41
42
Cash at Bank300,00097,398(43,719)(126,086)(133,453)(90,820)(23,186)44,447112,080179,713247,346314,979382,612410,245410,245700,9841,120,0292,341,9403,692,933Total
43
15.00%Pref Share Payment Scheme(300,000)(199,980)(99,999)--(599,979)
44
Cash at Bank (post pref share payment)110,245501,0041,020,0302,341,9403,692,933
45
Investor Summary Position
46
Repayment of Opening Equity via Operating costs(674,201)(674,201)(674,201)--
47
20%20% Profit Share to Pref Share holders(30,793)(78,152)(103,805)(264,382)(270,199)(747,330)
48
Total Payment per 5% Equity Position ($100k)(50,250)(47,617)(43,900)(13,219)(13,510)(168,496)
49