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 | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Profit & Loss (Cash basis) | ||||||||||||||||||||||||||||||||
2 | 2017 | 2018 | 2019 | 2020 | 2021 | ||||||||||||||||||||||||||||
3 | |||||||||||||||||||||||||||||||||
4 | 2017 | -60 Days | -30 Days | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year End | Growth Rate | Projected | Growth Rate | Projected | Growth Rate | Projected | Growth Rate | Projected | Growth Rate | Projected | |||||||
5 | Income | ||||||||||||||||||||||||||||||||
6 | Revenue | ||||||||||||||||||||||||||||||||
7 | Capital Raised (Equity) | 300,000 | 1,700,000 | - | - | - | - | - | - | - | - | - | - | - | - | 2,000,000 | 0% | 2,000,000 | |||||||||||||||
8 | Sales Ramp Up cashflow | (150,000) | (75,000) | (25,000) | (250,000) | 0% | (250,000) | ||||||||||||||||||||||||||
9 | Sales (washed sand) | 146,250 | 146,250 | 146,250 | 146,250 | 146,250 | 146,250 | 146,250 | 146,250 | 146,250 | 146,250 | 146,250 | 1,608,750 | 0% | 1,608,750 | 2% | 1,640,925 | 2% | 1,673,744 | 2% | 1,707,218 | 2% | 1,741,363 | ||||||||||
10 | Sales (gravel) | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 60,000 | 660,000 | 0% | 660,000 | 2% | 673,200 | 2% | 686,664 | 2% | 700,397 | 2% | 714,405 | ||||||||||
11 | Sales (fill) | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 2,500 | 27,500 | 0% | 27,500 | 2% | 28,050 | 2% | 28,611 | 2% | 29,183 | 2% | 29,767 | ||||||||||
12 | Total sales + Capital Raised | 300,000 | 1,700,000 | - | 58,750 | 133,750 | 183,750 | 208,750 | 208,750 | 208,750 | 208,750 | 208,750 | 208,750 | 208,750 | 208,750 | 2,046,250 | 4,046,250 | 2,342,175 | 2,389,019 | 2,436,799 | 2,485,535 | ||||||||||||
13 | |||||||||||||||||||||||||||||||||
14 | Cost of sales | ||||||||||||||||||||||||||||||||
15 | Equipment lease | 254,965 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 22,722 | 272,663 | 272,663 | 0% | 272,663 | 0% | 272,663 | 0% | 272,663 | 0% | 272,663 | |||||||||
16 | Power and Water | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 1,000 | 12,000 | 12,000 | 2% | 12,240 | 2% | 12,485 | 2% | 12,734 | 2% | 12,989 | ||||||||||
17 | Insurance | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 2,000 | 24,000 | 24,000 | 2% | 24,480 | 2% | 24,970 | 2% | 25,469 | 2% | 25,978 | ||||||||||
18 | Site Manager wages | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 8,400 | 100,800 | 100,800 | 3% | 103,824 | 3% | 106,939 | 3% | 110,147 | 3% | 113,451 | ||||||||||
19 | Communications | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 6,000 | 6,000 | 3% | 6,180 | 3% | 6,365 | 3% | 6,556 | 3% | 6,753 | ||||||||||
20 | Consumables | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 1,700 | 20,400 | 20,400 | 3% | 21,012 | 3% | 21,642 | 3% | 22,292 | 3% | 22,960 | ||||||||||
21 | ERA Fees | 620 | 620 | 620 | 620 | 620 | 620 | 620 | 620 | 620 | 620 | 620 | 620 | 7,440 | 7,440 | 0% | 7,440 | 0% | 7,440 | 0% | 7,440 | 0% | 7,440 | ||||||||||
22 | Rehab | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 1,825 | 21,900 | 21,900 | 3% | 22,557 | 3% | 23,234 | 3% | 23,931 | 3% | 24,649 | ||||||||||
23 | Fuel | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 16,000 | 192,000 | 192,000 | 3% | 197,760 | 3% | 203,693 | 3% | 209,804 | 3% | 216,098 | ||||||||||
24 | Wages 2 x Operators | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 14,000 | 168,000 | 168,000 | 3% | 173,040 | 3% | 178,231 | 3% | 183,578 | 3% | 189,085 | ||||||||||
25 | Maintenance | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 3,000 | 36,000 | 36,000 | 3% | 37,080 | 3% | 38,192 | 3% | 39,338 | 3% | 40,518 | ||||||||||
26 | Rent + Land debt servicing | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 12,500 | 150,000 | 150,000 | 0% | 150,000 | 0% | 150,000 | 0% | 150,000 | 0% | 150,000 | ||||||||||
27 | Sales & Marketing/Public Relations | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 48,000 | 48,000 | 2% | 48,960 | 2% | 49,939 | 2% | 50,938 | 2% | 51,957 | ||||||||||
28 | - | - | - | - | - | - | - | - | - | - | - | - | - | 0% | - | 0% | - | 0% | - | 0% | - | ||||||||||||
29 | Total cost of sales | - | 254,965 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 88,267 | 1,059,203 | 1,059,203 | 1,077,236 | 1,095,793 | 1,114,889 | 1,134,542 | ||||||||||||
30 | |||||||||||||||||||||||||||||||||
31 | Gross Margin | 300,000 | 1,445,035 | (88,267) | (29,517) | 45,483 | 95,483 | 120,483 | 120,483 | 120,483 | 120,483 | 120,483 | 120,483 | 120,483 | 120,483 | 1,075,314 | 1,075,314 | 1,264,939 | 1,293,226 | 1,321,909 | 1,350,993 | ||||||||||||
32 | |||||||||||||||||||||||||||||||||
33 | Expenses | ||||||||||||||||||||||||||||||||
34 | Start Up Cost Dep'n (3 yrs) | 1,186,250 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 32,951 | 395,417 | 395,417 | 0% | 395,417 | 0% | 395,417 | -100% | - | 0% | - | |||||||||
35 | Site Estblishment Dep'n (3 yrs) | 461,387 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 12,816 | 153,796 | 153,796 | 0% | 153,796 | 0% | 153,796 | -100% | - | 0% | - | |||||||||
36 | Equipment deposits (3 yrs) | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 7,082 | 84,988 | 84,988 | 0% | 84,988 | 0% | 84,988 | -100% | - | 0% | - | ||||||||||
37 | Pref Share Equity Repayment (balance) | 40,000 | 40,000 | 40,000 | 0% | 40,000 | 0% | 40,000 | -100% | - | 0% | - | |||||||||||||||||||||
38 | Total expenses | - | 1,647,637 | 52,850 | 52,850 | 52,850 | 52,850 | 52,850 | 52,850 | 52,850 | 52,850 | 52,850 | 52,850 | 52,850 | 92,850 | 674,201 | 674,201 | 674,201 | 674,201 | - | - | ||||||||||||
39 | |||||||||||||||||||||||||||||||||
40 | Total Cash Operating Profit (Loss) | 300,000 | (202,602) | (141,117) | (82,367) | (7,367) | 42,633 | 67,633 | 67,633 | 67,633 | 67,633 | 67,633 | 67,633 | 67,633 | 27,633 | 453,964 | 453,964 | 590,739 | 619,025 | 1,321,909 | 1,350,993 | ||||||||||||
41 | |||||||||||||||||||||||||||||||||
42 | Cash at Bank | 300,000 | 97,398 | (43,719) | (126,086) | (133,453) | (90,820) | (23,186) | 44,447 | 112,080 | 179,713 | 247,346 | 314,979 | 382,612 | 410,245 | 410,245 | 700,984 | 1,120,029 | 2,341,940 | 3,692,933 | Total | ||||||||||||
43 | 15.00% | Pref Share Payment Scheme | (300,000) | (199,980) | (99,999) | - | - | (599,979) | |||||||||||||||||||||||||
44 | Cash at Bank (post pref share payment) | 110,245 | 501,004 | 1,020,030 | 2,341,940 | 3,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 |