|
|
Once the equipment arrives and is installed, production ramps up rather quickly, with sales beginning in the sixth month after funding. Positive cash flow and net profit are achieved within the first year.
7.1 Important Assumptions
- Replay has allowed for 30 days to collect receivables due to knowledge and experience with customers in the industry.
- Inventory turnover is predicted at 12 times, which is extremely conservative.
- The personnel burden includes contribution by the Company to employee health care.
- We have allowed for Accounts Receivable financing of 70% at an interest rate of 12% per annum.
- It is assumed that additional extrusion lines will be added in the second year, with down payments of 33% at time of order and balance paid at time of shipment (see Cash Flow for details). These will be purchased as long-term assets out of the cash flows of the business.
- General annual growth rates of 5% have been assumed on all sales prices and material and labor costs.
| General Assumptions |
| Plan Month |
1 |
2 |
3 |
4 |
5 |
| Current Interest Rate |
12.00% |
12.00% |
12.00% |
12.00% |
12.00% |
| Long-term Interest Rate |
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
| Tax Rate |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
| Other |
0 |
0 |
0 |
0 |
0 |
7.2 Break-even Analysis
With fixed costs of about £184,000 per month in the first year, and variable unit costs at roughly 52% of prices, we need to produce and sell 715,963 units per month to break even. We will far exceed the break-even point in our first full month of sales.
| Break-even Analysis |
|
|
| Monthly Units Break-even |
558,698 |
| Monthly Revenue Break-even |
£291,763 |
|
|
| Average Per-Unit Revenue |
£0.52 |
| Average Per-Unit Variable Cost |
£0.27 |
| Estimated Monthly Fixed Cost |
£143,708 |
7.3 Projected Profit and Loss
The rapid growth of sales in year one and two is due primarily to increase in capacity over that period, as we add new extrusion equipment. The plan assumes the sale of all production capacity as it is added. The favorable gross margin projections are in part due to the vertical integration of the two processes. Our Managements' ability to handle all initial sales and marketing allows us to predict virtually no sales or marketing expense.

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
£7,651,875 |
£12,863,010 |
£13,618,605 |
£14,222,535 |
£15,002,962 |
| Production Payroll |
£953,657 |
£1,713,013 |
£1,963,829 |
£2,062,020 |
£2,165,121 |
| Packaging |
£150,791 |
£315,538 |
£391,699 |
£411,284 |
£431,463 |
| Sales Commission |
£733,102 |
£1,501,893 |
£1,871,678 |
£1,965,261 |
£2,063,524 |
| Total Cost of Sales |
£9,489,425 |
£16,393,454 |
£17,845,811 |
£18,661,100 |
£19,663,071 |
|
|
|
|
|
|
| Gross Margin |
£5,589,676 |
£15,160,320 |
£21,324,090 |
£22,467,295 |
£23,483,244 |
| Gross Margin % |
37.07% |
48.05% |
54.44% |
54.63% |
54.43% |
|
|
|
|
|
|
|
|
|
|
|
|
| Sales and Marketing Payroll |
£0 |
£0 |
£0 |
£0 |
£0 |
| Advertising/Promotion |
£6,000 |
£50,000 |
£100,000 |
£150,000 |
£200,000 |
| Travel |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales and Marketing Expenses |
£6,000 |
£50,000 |
£100,000 |
£150,000 |
£200,000 |
| Sales and Marketing % |
0.04% |
0.16% |
0.26% |
0.36% |
0.46% |
|
|
|
|
|
|
| General and Administrative Payroll |
£362,200 |
£585,417 |
£630,189 |
£678,747 |
£731,440 |
| Sales and Marketing and Other Expenses |
£0 |
£0 |
£0 |
£0 |
£0 |
| Depreciation |
£241,740 |
£164,182 |
£562,908 |
£562,908 |
£562,908 |
| Payroll Burden |
£0 |
£0 |
£0 |
£0 |
£0 |
| Office Equipment Rent |
£6,000 |
£6,000 |
£8,000 |
£8,000 |
£8,000 |
| Office Supplies/Expense |
£12,000 |
£15,000 |
£20,000 |
£22,500 |
£25,000 |
| Travel & Entertainment |
£16,000 |
£30,000 |
£35,000 |
£40,000 |
£45,000 |
| Leased Vehicles |
£18,000 |
£25,000 |
£30,000 |
£30,000 |
£30,000 |
| Utilities |
£678,560 |
£1,419,920 |
£1,762,646 |
£1,850,778 |
£1,941,584 |
| Insurance |
£24,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
| Misc Plant & Maintainence Supplies |
£60,000 |
£63,000 |
£66,150 |
£69,458 |
£72,930 |
| Other |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total General and Administrative Expenses |
£1,418,500 |
£2,333,519 |
£3,139,893 |
£3,287,391 |
£3,441,862 |
| General and Administrative % |
9.41% |
7.40% |
8.02% |
7.99% |
7.98% |
|
|
|
|
|
|
| Other Payroll |
£0 |
£0 |
£0 |
£0 |
£0 |
| Misc (contingency) |
£0 |
£0 |
£0 |
£0 |
£0 |
| Prof Fees ( Includ legal & accounting) |
£300,000 |
£0 |
£0 |
£0 |
£0 |
| Total Other Expenses |
£300,000 |
£0 |
£0 |
£0 |
£0 |
| Other % |
1.99% |
0.00% |
0.00% |
0.00% |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
£3,865,176 |
£12,776,801 |
£18,084,197 |
£19,029,904 |
£19,841,382 |
| EBITDA |
£4,106,916 |
£12,940,983 |
£18,647,105 |
£19,592,812 |
£20,404,290 |
| Interest Expense |
£60,568 |
£54,464 |
£48,064 |
£41,664 |
£35,264 |
| Taxes Incurred |
£1,141,382 |
£3,816,701 |
£5,410,840 |
£5,696,472 |
£5,941,835 |
|
|
|
|
|
|
| Net Profit/Sales |
17.66% |
28.22% |
32.23% |
32.32% |
32.13% |
7.4 Projected Cash Flow
Cash flow is predicted to turn positive in the sixth month of operations, which is the tenth month after funding. The Cash Flow table shows our planned repayment of the long-term loan, as well as the purchase of new extrusion equipment in the first two year of the plan. Dividends to founders and the outside investor are shown near the bottom of the table.

| Pro Forma Cash Flow |
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
| Cash Sales |
£0 |
£0 |
£0 |
£0 |
£0 |
| Cash from Receivables |
£13,094,219 |
£29,385,192 |
£38,167,380 |
£40,870,596 |
£42,880,693 |
| Subtotal Cash from Operations |
£13,094,219 |
£29,385,192 |
£38,167,380 |
£40,870,596 |
£42,880,693 |
|
|
|
|
|
|
| Additional Cash Received |
|
|
|
|
|
| Sales Tax, VAT, HST/GST Received |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Current Borrowing |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Other Liabilities (interest-free) |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Long-term Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
| Sales of Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
| Sales of Long-term Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Investment Received |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Received |
£13,094,219 |
£29,385,192 |
£38,167,380 |
£40,870,596 |
£42,880,693 |
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
| Cash Spending |
£1,315,857 |
£2,298,430 |
£2,594,018 |
£2,740,767 |
£2,896,561 |
| Bill Payments |
£9,964,116 |
£20,249,582 |
£23,199,277 |
£24,484,625 |
£25,763,227 |
| Subtotal Spent on Operations |
£11,279,973 |
£22,548,012 |
£25,793,295 |
£27,225,392 |
£28,659,789 |
|
|
|
|
|
|
| Additional Cash Spent |
|
|
|
|
|
| Sales Tax, VAT, HST/GST Paid Out |
£0 |
£0 |
£0 |
£0 |
£0 |
| Principal Repayment of Current Borrowing |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other Liabilities Principal Repayment |
£0 |
£0 |
£0 |
£0 |
£0 |
| Long-term Liabilities Principal Repayment |
£79,200 |
£80,000 |
£80,000 |
£80,000 |
£80,000 |
| Purchase Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
| Purchase Long-term Assets |
£1,591,000 |
£3,229,000 |
£0 |
£0 |
£0 |
| Dividends |
£0 |
£3,000,000 |
£8,000,000 |
£10,000,000 |
£10,000,000 |
| Subtotal Cash Spent |
£12,950,173 |
£28,857,012 |
£33,873,295 |
£37,305,392 |
£38,739,789 |
|
|
|
|
|
|
| Cash Balance |
£4,934,046 |
£5,462,225 |
£9,756,310 |
£13,321,514 |
£17,462,419 |
7.5 Projected Balance Sheet
The vertical integration, immediate sales contracts and rapid ramp up of production combine to project a Net Worth at the end of year one in excess of the total invested capital. By staying on plan, the Company will achieve rapid growth compared to invested capital.

| Pro Forma Balance Sheet |
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
| Cash |
£4,934,046 |
£5,462,225 |
£9,756,310 |
£13,321,514 |
£17,462,419 |
| Accounts Receivable |
£1,984,881 |
£4,153,463 |
£5,155,983 |
£5,413,782 |
£5,679,403 |
| Inventory |
£510,125 |
£857,534 |
£907,907 |
£953,302 |
£1,000,075 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£7,429,052 |
£10,473,222 |
£15,820,200 |
£19,688,599 |
£24,141,898 |
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
| Long-term Assets |
£1,591,000 |
£4,820,000 |
£4,820,000 |
£4,820,000 |
£4,820,000 |
| Accumulated Depreciation |
£241,740 |
£405,922 |
£968,830 |
£1,531,738 |
£2,094,646 |
| Total Long-term Assets |
£1,349,260 |
£4,414,078 |
£3,851,170 |
£3,288,262 |
£2,725,354 |
| Total Assets |
£8,778,312 |
£14,887,300 |
£19,671,370 |
£22,976,861 |
£26,867,252 |
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
| Accounts Payable |
£1,404,286 |
£1,687,638 |
£1,926,415 |
£2,020,138 |
£2,126,247 |
| Current Borrowing |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other Current Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Current Liabilities |
£1,404,286 |
£1,687,638 |
£1,926,415 |
£2,020,138 |
£2,126,247 |
|
|
|
|
|
|
| Long-term Liabilities |
£720,800 |
£640,800 |
£560,800 |
£480,800 |
£400,800 |
| Total Liabilities |
£2,125,086 |
£2,328,438 |
£2,487,215 |
£2,500,938 |
£2,527,047 |
|
|
|
|
|
|
| Paid-in Capital |
£4,200,000 |
£4,200,000 |
£4,200,000 |
£4,200,000 |
£4,200,000 |
| Retained Earnings |
(£210,000) |
(£546,774) |
£358,862 |
£2,984,155 |
£6,275,923 |
| Earnings |
£2,663,226 |
£8,905,636 |
£12,625,293 |
£13,291,768 |
£13,864,282 |
| Total Capital |
£6,653,226 |
£12,558,862 |
£17,184,155 |
£20,475,923 |
£24,340,205 |
| Total Liabilities and Capital |
£8,778,312 |
£14,887,300 |
£19,671,370 |
£22,976,861 |
£26,867,252 |
|
|
|
|
|
|
| Net Worth |
£6,653,226 |
£12,558,862 |
£17,184,155 |
£20,475,923 |
£24,340,205 |
7.6 Business Ratios
Standard business ratios are included in the following table, along with comparison ratios for the Thermoplastic Materials industry (SIC Code 2821.02). The ratios show a plan for healthy growth. Our return on investment increases each year and will allow for new equipment to be financed internally should the Company choose to do so. While the ratios indicate rapid growth and profitability, it may be explained in part by the fact of the integration of three business sections into the one facility. Our ratios differ significantly from the rest of the industry because of our ability to use low-cost recycled materials to manufacture our products.

| Ratio Analysis |
| Sales Growth |
0.00% |
109.26% |
24.14% |
5.00% |
4.91% |
9.27% |
|
|
|
|
|
|
|
| Accounts Receivable |
22.61% |
27.90% |
26.21% |
23.56% |
21.14% |
24.83% |
| Inventory |
5.81% |
5.76% |
4.62% |
4.15% |
3.72% |
11.53% |
| Other Current Assets |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
32.03% |
| Total Current Assets |
84.63% |
70.35% |
80.42% |
85.69% |
89.86% |
68.39% |
| Long-term Assets |
15.37% |
29.65% |
19.58% |
14.31% |
10.14% |
31.61% |
| Total Assets |
100.00% |
100.00% |
100.00% |
100.00% |
100.00% |
100.00% |
|
|
|
|
|
|
|
| Current Liabilities |
16.00% |
11.34% |
9.79% |
8.79% |
7.91% |
26.62% |
| Long-term Liabilities |
8.21% |
4.30% |
2.85% |
2.09% |
1.49% |
25.26% |
| Total Liabilities |
24.21% |
15.64% |
12.64% |
10.88% |
9.41% |
51.88% |
| Net Worth |
75.79% |
84.36% |
87.36% |
89.12% |
90.59% |
48.12% |
|
|
|
|
|
|
|
| Sales |
100.00% |
100.00% |
100.00% |
100.00% |
100.00% |
100.00% |
| Gross Margin |
37.07% |
48.05% |
54.44% |
54.63% |
54.43% |
28.02% |
| Selling, General & Administrative Expenses |
22.36% |
22.63% |
24.36% |
24.16% |
24.37% |
15.89% |
| Advertising Expenses |
0.04% |
0.17% |
0.27% |
0.38% |
0.48% |
0.17% |
| Profit Before Interest and Taxes |
25.63% |
40.49% |
46.17% |
46.27% |
45.99% |
2.46% |
|
|
|
|
|
|
|
| Current |
5.29 |
6.21 |
8.21 |
9.75 |
11.35 |
1.79 |
| Quick |
4.93 |
5.70 |
7.74 |
9.27 |
10.88 |
1.22 |
| Total Debt to Total Assets |
24.21% |
15.64% |
12.64% |
10.88% |
9.41% |
57.88% |
| Pre-tax Return on Net Worth |
57.18% |
101.30% |
104.96% |
92.73% |
81.37% |
2.22% |
| Pre-tax Return on Assets |
43.34% |
85.46% |
91.69% |
82.64% |
73.72% |
5.28% |
|
|
|
|
|
|
|
| Net Profit Margin |
17.66% |
28.22% |
32.23% |
32.32% |
32.13% |
n.a |
| Return on Equity |
40.03% |
70.91% |
73.47% |
64.91% |
56.96% |
n.a |
|
|
|
|
|
|
|
| Accounts Receivable Turnover |
7.60 |
7.60 |
7.60 |
7.60 |
7.60 |
n.a |
| Collection Days |
29 |
36 |
43 |
47 |
47 |
n.a |
| Inventory Turnover |
24.00 |
18.81 |
15.43 |
15.28 |
15.36 |
n.a |
| Accounts Payable Turnover |
8.10 |
12.17 |
12.17 |
12.17 |
12.17 |
n.a |
| Payment Days |
27 |
27 |
28 |
29 |
29 |
n.a |
| Total Asset Turnover |
1.72 |
2.12 |
1.99 |
1.79 |
1.61 |
n.a |
|
|
|
|
|
|
|
| Debt to Net Worth |
0.32 |
0.19 |
0.14 |
0.12 |
0.10 |
n.a |
| Current Liab. to Liab. |
0.66 |
0.72 |
0.77 |
0.81 |
0.84 |
n.a |
|
|
|
|
|
|
|
| Net Working Capital |
£6,024,766 |
£8,785,584 |
£13,893,785 |
£17,668,461 |
£22,015,651 |
n.a |
| Interest Coverage |
63.82 |
234.59 |
376.25 |
456.75 |
562.65 |
n.a |
|
|
|
|
|
|
|
| Assets to Sales |
0.58 |
0.47 |
0.50 |
0.56 |
0.62 |
n.a |
| Current Debt/Total Assets |
16% |
11% |
10% |
9% |
8% |
n.a |
| Acid Test |
3.51 |
3.24 |
5.06 |
6.59 |
8.21 |
n.a |
| Sales/Net Worth |
2.27 |
2.51 |
2.28 |
2.01 |
1.77 |
n.a |
| Dividend Payout |
0.00 |
0.34 |
0.63 |
0.75 |
0.72 |
n.a |
7.7 Long-term Plan
The plan calls for maximum production rate for flake in the sixth month from funding. Approximately one third of that production will be converted into extruded sheet beginning approximately at the same time. A second sheet extruder, which will also consume one third of the flake produced, is planned to be added at the end of year one, coming on line mid year two. A third extruder, which is planned to produce high-strength strapping, is expected to come on line late in year two. By the beginning of year three, it is expected that all of the 46,200,000 lbs. of RPET cleaned & recycled annually will be converted into extruded products. Up until this time, excess flake produced will be sold to other extruder companies.
The plan assumes a 5% increase in the sales price of all products and a 5% increase in the cost of raw materials and labor in each of years 2 through 5.
The result of the above is rapid growth in revenue and profit through year three, and moderate growth in years four and five, assuming no expansion of capacity during that time.
7.8 Replay's Exit Strategy
Management is indifferent as to the question of looking to sell the Company after 4-5 years or retaining ownership and the resulting annual cash flow. They will look to the investors for their direction and will generally support their wishes.
Recent information on private sales of similar industry companies has indicated that transactions under £25 million have averaged 5.3 times EBITDA, while transactions in the range of £25-250 million have averaged over 7 times EBITDA.
Such multiples would put the potential sales price of Replay, after 4-5 years of operation, in excess of £100 million based on current projections.
|