|
|

| Sales Forecast |
| Automation |
0% |
£18,000 |
£18,000 |
£18,000 |
£18,000 |
£18,000 |
£18,000 |
£18,000 |
£18,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
| Production Machining |
0% |
£22,000 |
£22,000 |
£22,000 |
£22,000 |
£22,000 |
£22,000 |
£22,000 |
£22,000 |
£22,000 |
£23,000 |
£24,000 |
£25,000 |
| Specialized Manufacturing |
0% |
£59,000 |
£59,000 |
£59,000 |
£59,000 |
£59,000 |
£59,000 |
£59,000 |
£59,000 |
£59,000 |
£59,000 |
£60,000 |
£60,000 |
| Value Added Assembly |
0% |
£63,000 |
£63,000 |
£63,000 |
£63,000 |
£63,000 |
£63,000 |
£63,000 |
£63,000 |
£64,000 |
£64,000 |
£64,000 |
£64,000 |
| Total Sales |
|
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£164,000 |
£165,000 |
£167,000 |
£168,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Automation |
|
£3,700 |
£3,700 |
£3,700 |
£3,700 |
£3,700 |
£3,700 |
£3,700 |
£3,700 |
£3,900 |
£3,900 |
£3,900 |
£3,900 |
| Production Machining |
|
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£4,700 |
£4,700 |
£4,800 |
| Specialized Manufacturing |
|
£12,000 |
£12,000 |
£12,000 |
£12,000 |
£12,000 |
£12,000 |
£12,000 |
£12,000 |
£12,000 |
£12,000 |
£12,200 |
£12,200 |
| Value Added Assembly |
|
£12,900 |
£12,900 |
£12,900 |
£13,000 |
£13,000 |
£13,000 |
£13,000 |
£13,000 |
£13,000 |
£13,000 |
£13,000 |
£13,000 |
| Subtotal Direct Cost of Sales |
|
£33,100 |
£33,100 |
£33,100 |
£33,200 |
£33,200 |
£33,200 |
£33,200 |
£33,200 |
£33,400 |
£33,600 |
£33,800 |
£33,900 |
| Personnel Plan |
| Peter Newton, CEO |
0% |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
| John Abbot, President |
0% |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
£6,250 |
| Chris Manuel, VP Marketing |
0% |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
| Production Manager |
0% |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
£3,750 |
| Administrative Assistant |
0% |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Total People |
|
15 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
15 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
| General Assumptions |
| Plan Month |
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
| Current Interest Rate |
|
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
| Long-term Interest Rate |
|
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
| Tax Rate |
|
30.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
| Other |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£33,100 |
£33,100 |
£33,100 |
£33,200 |
£33,200 |
£33,200 |
£33,200 |
£33,200 |
£33,400 |
£33,600 |
£33,800 |
£33,900 |
| Production Personnel |
|
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
£29,170 |
| Total Cost of Sales |
|
£62,270 |
£62,270 |
£62,270 |
£62,370 |
£62,370 |
£62,370 |
£62,370 |
£62,370 |
£62,570 |
£62,770 |
£62,970 |
£63,070 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£99,730 |
£99,730 |
£99,730 |
£99,630 |
£99,630 |
£99,630 |
£99,630 |
£99,630 |
£101,430 |
£102,230 |
£104,030 |
£104,930 |
| Gross Margin % |
|
61.56% |
61.56% |
61.56% |
61.50% |
61.50% |
61.50% |
61.50% |
61.50% |
61.85% |
61.96% |
62.29% |
62.46% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
| Marketing/Promotion |
|
£13,900 |
£13,900 |
£14,000 |
£13,900 |
£13,900 |
£14,000 |
£13,900 |
£13,900 |
£14,050 |
£14,000 |
£14,100 |
£14,350 |
| Depreciation |
|
£833 |
£833 |
£833 |
£833 |
£833 |
£833 |
£833 |
£833 |
£833 |
£833 |
£833 |
£833 |
| Quality Assurance |
|
£7,700 |
£7,700 |
£7,700 |
£7,700 |
£7,700 |
£7,700 |
£7,700 |
£7,700 |
£7,900 |
£8,000 |
£8,100 |
£8,200 |
| General & Administrative |
|
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
£8,000 |
| Manufacturing & Engineering |
|
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
£10,800 |
| Machining & Systems Building |
|
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
£7,200 |
| Payroll Taxes |
15% |
£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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
£27,547 |
£27,547 |
£27,447 |
£27,447 |
£27,447 |
£27,347 |
£27,447 |
£27,447 |
£28,897 |
£29,647 |
£31,247 |
£31,797 |
| EBITDA |
|
£28,380 |
£28,380 |
£28,280 |
£28,280 |
£28,280 |
£28,180 |
£28,280 |
£28,280 |
£29,730 |
£30,480 |
£32,080 |
£32,630 |
| Interest Expense |
|
£2,917 |
£5,000 |
£4,958 |
£4,500 |
£4,458 |
£4,069 |
£4,028 |
£3,986 |
£3,597 |
£3,555 |
£3,513 |
£3,124 |
| Taxes Incurred |
|
£7,389 |
£5,637 |
£5,622 |
£5,737 |
£5,747 |
£5,819 |
£5,855 |
£5,865 |
£6,325 |
£6,523 |
£6,933 |
£7,168 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
10.64% |
10.44% |
10.41% |
10.62% |
10.64% |
10.78% |
10.84% |
10.86% |
11.57% |
11.86% |
12.46% |
12.80% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£40,500 |
£40,500 |
£40,500 |
£40,500 |
£40,500 |
£40,500 |
£40,500 |
£40,500 |
£41,000 |
£41,250 |
£41,750 |
£42,000 |
| Cash from Receivables |
|
£65,000 |
£69,050 |
£121,500 |
£121,500 |
£121,500 |
£121,500 |
£121,500 |
£121,500 |
£121,500 |
£121,550 |
£123,025 |
£123,800 |
| Subtotal Cash from Operations |
|
£105,500 |
£109,550 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,500 |
£162,800 |
£164,775 |
£165,800 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£250,000 |
£250,000 |
£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 |
|
£355,500 |
£359,550 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,000 |
£162,500 |
£162,800 |
£164,775 |
£165,800 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
£23,750 |
| Bill Payments |
|
£77,903 |
£87,507 |
£100,701 |
£120,543 |
£120,312 |
£120,168 |
£119,955 |
£119,851 |
£119,849 |
£120,675 |
£121,094 |
£121,843 |
| Subtotal Spent on Operations |
|
£101,653 |
£111,257 |
£124,451 |
£144,293 |
£144,062 |
£143,918 |
£143,705 |
£143,601 |
£143,599 |
£144,425 |
£144,844 |
£145,593 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Additional Cash Spent |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales Tax, VAT, HST/GST Paid Out |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Principal Repayment of Current Borrowing |
|
£0 |
£0 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
| Other Liabilities Principal Repayment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Long-term Liabilities Principal Repayment |
|
£0 |
£0 |
£0 |
£50,000 |
£0 |
£41,700 |
£0 |
£0 |
£41,700 |
£0 |
£0 |
£41,700 |
| Purchase Other Current Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Purchase Long-term Assets |
|
£0 |
£0 |
£0 |
£0 |
£120,000 |
£0 |
£150,000 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Dividends |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Spent |
|
£101,653 |
£111,257 |
£129,451 |
£199,293 |
£269,062 |
£190,618 |
£298,705 |
£148,601 |
£190,299 |
£149,425 |
£149,844 |
£192,293 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£313,847 |
£562,140 |
£594,689 |
£557,396 |
£450,334 |
£421,716 |
£285,011 |
£298,410 |
£270,611 |
£283,985 |
£298,917 |
£272,424 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£60,000 |
£313,847 |
£562,140 |
£594,689 |
£557,396 |
£450,334 |
£421,716 |
£285,011 |
£298,410 |
£270,611 |
£283,985 |
£298,917 |
£272,424 |
| Accounts Receivable |
£130,000 |
£186,500 |
£238,950 |
£238,950 |
£238,950 |
£238,950 |
£238,950 |
£238,950 |
£238,950 |
£240,450 |
£242,650 |
£244,875 |
£247,075 |
| Inventory |
£90,000 |
£56,900 |
£36,410 |
£36,410 |
£36,520 |
£36,520 |
£36,520 |
£36,520 |
£36,520 |
£36,740 |
£36,960 |
£37,180 |
£37,290 |
| Other Current Assets |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
£15,000 |
| Total Current Assets |
£295,000 |
£572,247 |
£852,500 |
£885,049 |
£847,866 |
£740,804 |
£712,186 |
£575,481 |
£588,880 |
£562,801 |
£578,595 |
£595,972 |
£571,789 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£100,000 |
£100,000 |
£100,000 |
£100,000 |
£100,000 |
£220,000 |
£220,000 |
£370,000 |
£370,000 |
£370,000 |
£370,000 |
£370,000 |
£370,000 |
| Accumulated Depreciation |
£30,000 |
£30,833 |
£31,666 |
£32,499 |
£33,332 |
£34,165 |
£34,998 |
£35,831 |
£36,664 |
£37,497 |
£38,330 |
£39,163 |
£39,996 |
| Total Long-term Assets |
£70,000 |
£69,167 |
£68,334 |
£67,501 |
£66,668 |
£185,835 |
£185,002 |
£334,169 |
£333,336 |
£332,503 |
£331,670 |
£330,837 |
£330,004 |
| Total Assets |
£365,000 |
£641,414 |
£920,834 |
£952,550 |
£914,534 |
£926,639 |
£897,188 |
£909,650 |
£922,216 |
£895,304 |
£910,265 |
£926,809 |
£901,793 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£75,000 |
£84,173 |
£96,683 |
£116,532 |
£116,306 |
£116,170 |
£115,960 |
£115,857 |
£115,827 |
£116,640 |
£117,032 |
£117,776 |
£117,955 |
| Current Borrowing |
£50,000 |
£50,000 |
£50,000 |
£45,000 |
£40,000 |
£35,000 |
£30,000 |
£25,000 |
£20,000 |
£15,000 |
£10,000 |
£5,000 |
£0 |
| Other Current Liabilities |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
| Subtotal Current Liabilities |
£135,000 |
£144,173 |
£156,683 |
£171,532 |
£166,306 |
£161,170 |
£155,960 |
£150,857 |
£145,827 |
£141,640 |
£137,032 |
£132,776 |
£127,955 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£50,000 |
£300,000 |
£550,000 |
£550,000 |
£500,000 |
£500,000 |
£458,300 |
£458,300 |
£458,300 |
£416,600 |
£416,600 |
£416,600 |
£374,900 |
| Total Liabilities |
£185,000 |
£444,173 |
£706,683 |
£721,532 |
£666,306 |
£661,170 |
£614,260 |
£609,157 |
£604,127 |
£558,240 |
£553,632 |
£549,376 |
£502,855 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
| Retained Earnings |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
£130,000 |
| Earnings |
£0 |
£17,241 |
£34,151 |
£51,018 |
£68,228 |
£85,470 |
£102,928 |
£120,493 |
£138,089 |
£157,064 |
£176,633 |
£197,433 |
£218,938 |
| Total Capital |
£180,000 |
£197,241 |
£214,151 |
£231,018 |
£248,228 |
£265,470 |
£282,928 |
£300,493 |
£318,089 |
£337,064 |
£356,633 |
£377,433 |
£398,938 |
| Total Liabilities and Capital |
£365,000 |
£641,414 |
£920,834 |
£952,550 |
£914,534 |
£926,639 |
£897,188 |
£909,650 |
£922,216 |
£895,304 |
£910,265 |
£926,809 |
£901,793 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£180,000 |
£197,241 |
£214,151 |
£231,018 |
£248,228 |
£265,470 |
£282,928 |
£300,493 |
£318,089 |
£337,064 |
£356,633 |
£377,433 |
£398,938 |
|