|
|
Page
1
2
3
4
5
6
7
8
9
10
| Sales Forecast |
| RST-PAL pallets |
£18.50/£22.50 (5th yr) |
£646,464 |
£1,292,928 |
£1,864,800 |
£1,939,392 |
£1,864,800 |
£1,864,800 |
£1,939,392 |
£1,939,392 |
£1,939,392 |
£1,939,392 |
£1,864,800 |
£1,939,392 |
| Subsidies |
£30/ton |
£26,208 |
£52,416 |
£75,600 |
£78,624 |
£75,600 |
£75,600 |
£78,624 |
£78,624 |
£78,624 |
£78,624 |
£78,624 |
£75,600 |
| Total Sales |
|
£672,672 |
£1,345,344 |
£1,940,400 |
£2,018,016 |
£1,940,400 |
£1,940,400 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£1,943,424 |
£2,014,992 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Recycled Rubber |
125% |
£43,680 |
£87,360 |
£126,025 |
£131,040 |
£126,000 |
£126,000 |
£131,040 |
£131,040 |
£131,040 |
£131,040 |
£126,000 |
£131,040 |
| Recycled Plastic |
90% |
£31,450 |
£62,899 |
£90,738 |
£94,349 |
£90,720 |
£90,720 |
£94,349 |
£94,349 |
£94,349 |
£94,349 |
£90,720 |
£94,349 |
| Binders System |
650% |
£227,136 |
£454,272 |
£655,330 |
£681,408 |
£655,200 |
£655,200 |
£681,408 |
£681,408 |
£681,408 |
£681,408 |
£655,200 |
£681,408 |
| Subtotal Direct Cost of Sales |
|
£302,266 |
£604,531 |
£872,093 |
£906,797 |
£871,920 |
£871,920 |
£906,797 |
£906,797 |
£906,797 |
£906,797 |
£871,920 |
£906,797 |

| Personnel Plan |
| Texas plant manager |
|
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
| Texas office worker |
|
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Receptionist (x2) |
£6.50/hr |
£1,040 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
£2,080 |
| Data entry (x1) |
£6.50/hr |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
£1,040 |
| Foreman (x3) |
£2,200/mo |
£2,200 |
£4,400 |
£6,600 |
£6,600 |
£6,600 |
£6,600 |
£6,800 |
£7,000 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
| Line operator (x6) |
£8.25/hr |
£3,432 |
£6,864 |
£10,296 |
£10,296 |
£10,296 |
£10,296 |
£10,296 |
£10,296 |
£10,296 |
£10,296 |
£10,296 |
£10,296 |
| Loader (x6) |
£7.25/hr |
£3,016 |
£6,032 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
| Batcher (x6) |
£7.50/hr |
£3,120 |
£6,240 |
£9,360 |
£9,360 |
£9,360 |
£9,360 |
£9,360 |
£9,360 |
£9,360 |
£9,360 |
£9,360 |
£9,360 |
| Conveyer worker (x12) |
£6.50/hr |
£5,408 |
£10,816 |
£16,224 |
£16,224 |
£16,224 |
£16,224 |
£16,224 |
£16,224 |
£16,224 |
£16,224 |
£16,224 |
£16,224 |
| Assembly lead (x4) |
£7.25/hr |
£3,016 |
£3,016 |
£6,032 |
£6,032 |
£6,032 |
£6,032 |
£6,032 |
£6,032 |
£6,032 |
£6,032 |
£6,032 |
£6,032 |
| Assembly helper (x4) |
£6.50/hr |
£2,704 |
£2,704 |
£5,408 |
£5,408 |
£5,408 |
£5,408 |
£5,408 |
£5,408 |
£5,408 |
£5,408 |
£5,408 |
£5,408 |
| Cutter (x12) |
£7.25/hr |
£12,064 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
£18,096 |
| Forklift operator (x6) |
£7.25/hr |
£6,032 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
£9,048 |
| Maint. Supervisor |
£7.50/hr |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
£1,560 |
| Maint. helper (x3) |
£6.50/hr |
£1,352 |
£2,704 |
£4,056 |
£4,056 |
£4,056 |
£4,056 |
£4,056 |
£4,056 |
£4,056 |
£4,056 |
£4,056 |
£4,056 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£51,184 |
£79,800 |
£104,048 |
£104,048 |
£104,048 |
£104,048 |
£104,248 |
£104,448 |
£104,648 |
£104,648 |
£104,648 |
£104,648 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Marketing Director |
|
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
| Marketing Secretary |
|
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,200 |
£2,200 |
£2,200 |
£2,200 |
£2,200 |
£2,200 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,700 |
£6,700 |
£6,700 |
£6,700 |
£6,700 |
£6,700 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| President - Dan Radke |
|
£6,000 |
£6,000 |
£6,500 |
£6,500 |
£7,500 |
£7,500 |
£8,000 |
£8,000 |
£8,500 |
£8,500 |
£8,500 |
£8,500 |
| Vice Pres. - Elie Banenson |
|
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£7,000 |
£7,000 |
£7,500 |
£7,500 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
| Office Manager |
|
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,300 |
£3,300 |
£3,300 |
£3,300 |
£3,300 |
£3,300 |
| Receptionist (x2) |
|
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
| Office workers (x2) |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£16,500 |
£16,500 |
£17,000 |
£17,000 |
£19,000 |
£19,000 |
£21,800 |
£21,800 |
£22,800 |
£22,800 |
£22,800 |
£22,800 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Name or Title |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Name or Title |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total People |
|
33 |
56 |
74 |
74 |
74 |
74 |
75 |
75 |
75 |
75 |
75 |
75 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£73,684 |
£102,300 |
£127,048 |
£127,048 |
£129,048 |
£129,048 |
£132,748 |
£132,948 |
£134,148 |
£134,148 |
£134,148 |
£134,148 |
| General Assumptions |
| Plan Month |
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
| Current Interest Rate |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
| Long-term Interest Rate |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
| Tax Rate |
|
30.00% |
34.00% |
34.00% |
34.00% |
34.00% |
34.00% |
34.00% |
34.00% |
34.00% |
34.00% |
34.00% |
34.00% |
| Other |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£302,266 |
£604,531 |
£872,093 |
£906,797 |
£871,920 |
£871,920 |
£906,797 |
£906,797 |
£906,797 |
£906,797 |
£871,920 |
£906,797 |
| Production Payroll |
|
£51,184 |
£79,800 |
£104,048 |
£104,048 |
£104,048 |
£104,048 |
£104,248 |
£104,448 |
£104,648 |
£104,648 |
£104,648 |
£104,648 |
| Other Costs of Goods |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£353,450 |
£684,331 |
£976,141 |
£1,010,845 |
£975,968 |
£975,968 |
£1,011,045 |
£1,011,245 |
£1,011,445 |
£1,011,445 |
£976,568 |
£1,011,445 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£319,222 |
£661,013 |
£964,259 |
£1,007,171 |
£964,432 |
£964,432 |
£1,006,971 |
£1,006,771 |
£1,006,571 |
£1,006,571 |
£966,856 |
£1,003,547 |
| Gross Margin % |
|
47.46% |
49.13% |
49.69% |
49.91% |
49.70% |
49.70% |
49.90% |
49.89% |
49.88% |
49.88% |
49.75% |
49.80% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales and Marketing Payroll |
|
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,700 |
£6,700 |
£6,700 |
£6,700 |
£6,700 |
£6,700 |
| Advertising/Promotion |
|
£3,500 |
£3,500 |
£4,500 |
£4,500 |
£5,000 |
£5,000 |
£6,000 |
£6,000 |
£7,500 |
£7,500 |
£10,000 |
£10,000 |
| Royalties |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£96,970 |
£96,970 |
£96,970 |
£96,970 |
£93,240 |
£96,970 |
| Other Sales and Marketing Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales and Marketing Expenses |
|
£9,500 |
£9,500 |
£10,500 |
£10,500 |
£11,000 |
£11,000 |
£109,670 |
£109,670 |
£111,170 |
£111,170 |
£109,940 |
£113,670 |
| Sales and Marketing % |
|
1.41% |
0.71% |
0.54% |
0.52% |
0.57% |
0.57% |
5.43% |
5.43% |
5.51% |
5.51% |
5.66% |
5.64% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| General and Administrative Payroll |
|
£16,500 |
£16,500 |
£17,000 |
£17,000 |
£19,000 |
£19,000 |
£21,800 |
£21,800 |
£22,800 |
£22,800 |
£22,800 |
£22,800 |
| Sales and Marketing and Other Expenses |
|
£6,000 |
£6,000 |
£7,000 |
£7,000 |
£7,500 |
£7,500 |
£105,470 |
£105,470 |
£106,970 |
£106,970 |
£105,740 |
£109,470 |
| Depreciation |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Rent |
|
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
| Office Expenses |
|
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Accounting |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Legal |
|
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Travel |
|
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
| Insurance (property & casualty) |
|
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Payroll Taxes & Benefits Payroll Burden |
23% |
£27,675 |
£27,675 |
£28,290 |
£28,290 |
£30,750 |
£30,750 |
£35,055 |
£35,055 |
£36,285 |
£36,285 |
£36,285 |
£36,285 |
| Other General and Administrative Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total General and Administrative Expenses |
|
£64,675 |
£64,675 |
£66,790 |
£66,790 |
£71,750 |
£71,750 |
£176,825 |
£176,825 |
£180,555 |
£180,555 |
£179,325 |
£183,055 |
| General and Administrative % |
|
9.61% |
4.81% |
3.44% |
3.31% |
3.70% |
3.70% |
8.76% |
8.76% |
8.95% |
8.95% |
9.23% |
9.08% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Other Payroll |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Consultants |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Machine Maintenance |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Miscellaneous Expenses |
|
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
| Total Other Expenses |
|
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
£12,500 |
| Other % |
|
1.86% |
0.93% |
0.64% |
0.62% |
0.64% |
0.64% |
0.62% |
0.62% |
0.62% |
0.62% |
0.64% |
0.62% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
£232,547 |
£574,338 |
£874,469 |
£917,381 |
£869,182 |
£869,182 |
£707,976 |
£707,776 |
£702,346 |
£702,346 |
£665,091 |
£694,322 |
| EBITDA |
|
£232,547 |
£574,338 |
£874,469 |
£917,381 |
£869,182 |
£869,182 |
£707,976 |
£707,776 |
£702,346 |
£702,346 |
£665,091 |
£694,322 |
| Interest Expense |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Taxes Incurred |
|
£69,764 |
£195,275 |
£297,319 |
£311,910 |
£295,522 |
£295,522 |
£240,712 |
£240,644 |
£238,798 |
£238,798 |
£226,131 |
£236,069 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
24.20% |
28.18% |
29.74% |
30.00% |
29.56% |
29.56% |
23.15% |
23.15% |
22.97% |
22.97% |
22.59% |
22.74% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£672,672 |
£1,345,344 |
£1,940,400 |
£2,018,016 |
£1,940,400 |
£1,940,400 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£1,943,424 |
£2,014,992 |
| Cash from Receivables |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash from Operations |
|
£672,672 |
£1,345,344 |
£1,940,400 |
£2,018,016 |
£1,940,400 |
£1,940,400 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£1,943,424 |
£2,014,992 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Additional Cash Received |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales Tax, VAT, HST/GST Received |
0.00% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Current Borrowing |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Other Liabilities (interest-free) |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Long-term Liabilities |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Sales of Other Current Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Sales of Long-term Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Investment Received |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Received |
|
£672,672 |
£1,345,344 |
£1,940,400 |
£2,018,016 |
£1,940,400 |
£1,940,400 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£2,018,016 |
£1,943,424 |
£2,014,992 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|