|
|

| Sales Forecast |
| Retainer Consulting |
0% |
£46,000 |
£46,000 |
£46,000 |
£46,000 |
£46,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
£50,000 |
| Project Consulting |
0% |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
£40,000 |
| Market Research & Industrial Analyses |
0% |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
| Feasibility Studies |
0% |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
£30,000 |
| Strategic Analysis and Reports |
0% |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
| Other |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£171,000 |
£171,000 |
£171,000 |
£171,000 |
£171,000 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Retainer Consulting |
|
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
£9,670 |
| Project Consulting |
|
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
£7,810 |
| Market Research & Industrial Analyses |
|
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
| Feasibility Studies |
|
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
£6,000 |
| Strategic Analysis and Reports |
|
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
£4,880 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |

| Personnel Plan |
| Vice President Sales & Marketing |
0% |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
| Technical Sales B2B |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Technical Sales B2C |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Secretary - Sales & Marketing Office |
0% |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Vice President Operations |
0% |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
| Senior Consultant - Marketing |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Senior Consultant - Finance Management |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Senior Consultant - Strategic Management |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Secretary - Operations Office |
0% |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| VP Internal Business Management |
0% |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
| Accountant |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Legal Officer |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| Administrative Officer |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| HRD Officer |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| President/CEO |
0% |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
£4,000 |
| Secretary to the CEO |
0% |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
| Bookkeeper |
0% |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Clerical |
0% |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Clerical |
0% |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Clerical |
0% |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Clerical |
0% |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Total People |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
| General Assumptions |
| Plan Month |
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
| Current Interest Rate |
|
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
| Long-term Interest Rate |
|
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
9.00% |
| Tax Rate |
|
25.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 |
|
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
£34,360 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£136,640 |
£136,640 |
£136,640 |
£136,640 |
£136,640 |
£140,640 |
£140,640 |
£140,640 |
£140,640 |
£140,640 |
£140,640 |
£140,640 |
| Gross Margin % |
|
79.91% |
79.91% |
79.91% |
79.91% |
79.91% |
80.37% |
80.37% |
80.37% |
80.37% |
80.37% |
80.37% |
80.37% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
| Sales and Marketing and Other Expenses |
|
£10,500 |
£4,500 |
£2,000 |
£12,500 |
£2,000 |
£2,000 |
£8,000 |
£15,000 |
£2,000 |
£2,000 |
£19,500 |
£5,000 |
| Depreciation |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Leased Equipment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Utilities |
|
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
| Insurance |
|
£180 |
£180 |
£180 |
£180 |
£180 |
£180 |
£180 |
£180 |
£180 |
£180 |
£180 |
£180 |
| Office Rent |
|
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
£3,200 |
| Payroll Taxes |
15% |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
£3,390 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
£96,170 |
£102,170 |
£104,670 |
£94,170 |
£104,670 |
£108,670 |
£102,670 |
£95,670 |
£108,670 |
£108,670 |
£91,170 |
£105,670 |
| EBITDA |
|
£96,170 |
£102,170 |
£104,670 |
£94,170 |
£104,670 |
£108,670 |
£102,670 |
£95,670 |
£108,670 |
£108,670 |
£91,170 |
£105,670 |
| Interest Expense |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Taxes Incurred |
|
£24,043 |
£25,543 |
£26,168 |
£23,543 |
£26,168 |
£27,168 |
£25,668 |
£23,918 |
£27,168 |
£27,168 |
£22,793 |
£26,418 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
42.18% |
44.81% |
45.91% |
41.30% |
45.91% |
46.57% |
44.00% |
41.00% |
46.57% |
46.57% |
39.07% |
45.29% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£85,500 |
£85,500 |
£85,500 |
£85,500 |
£85,500 |
£87,500 |
£87,500 |
£87,500 |
£87,500 |
£87,500 |
£87,500 |
£87,500 |
| Cash from Receivables |
|
£59,219 |
£62,069 |
£85,500 |
£85,500 |
£85,500 |
£85,500 |
£85,567 |
£87,500 |
£87,500 |
£87,500 |
£87,500 |
£87,500 |
| Subtotal Cash from Operations |
|
£144,719 |
£147,569 |
£171,000 |
£171,000 |
£171,000 |
£173,000 |
£173,067 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£144,719 |
£147,569 |
£171,000 |
£171,000 |
£171,000 |
£173,000 |
£173,067 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
£175,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
£22,600 |
| Bill Payments |
|
£7,542 |
£76,123 |
£71,710 |
£70,160 |
£77,510 |
£69,931 |
£71,048 |
£75,573 |
£80,323 |
£70,898 |
£71,335 |
£83,660 |
| Subtotal Spent on Operations |
|
£30,142 |
£98,723 |
£94,310 |
£92,760 |
£100,110 |
£92,531 |
£93,648 |
£98,173 |
£102,923 |
£93,498 |
£93,935 |
£106,260 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other Liabilities Principal Repayment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Long-term Liabilities Principal Repayment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Purchase Other Current Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Purchase Long-term Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Dividends |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Spent |
|
£30,142 |
£98,723 |
£94,310 |
£92,760 |
£100,110 |
£92,531 |
£93,648 |
£98,173 |
£102,923 |
£93,498 |
£93,935 |
£106,260 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£770,663 |
£819,509 |
£896,199 |
£974,439 |
£1,045,329 |
£1,125,798 |
£1,205,217 |
£1,282,045 |
£1,354,122 |
£1,435,625 |
£1,516,690 |
£1,585,430 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£656,086 |
£770,663 |
£819,509 |
£896,199 |
£974,439 |
£1,045,329 |
£1,125,798 |
£1,205,217 |
£1,282,045 |
£1,354,122 |
£1,435,625 |
£1,516,690 |
£1,585,430 |
| Accounts Receivable |
£118,438 |
£144,719 |
£168,150 |
£168,150 |
£168,150 |
£168,150 |
£170,150 |
£172,083 |
£172,083 |
£172,083 |
£172,083 |
£172,083 |
£172,083 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£774,524 |
£915,382 |
£987,659 |
£1,064,349 |
£1,142,589 |
£1,213,479 |
£1,295,948 |
£1,377,301 |
£1,454,128 |
£1,526,206 |
£1,607,708 |
£1,688,773 |
£1,757,513 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
| Accumulated Depreciation |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Long-term Assets |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
£126,588 |
| Total Assets |
£901,112 |
£1,041,969 |
£1,114,247 |
£1,190,937 |
£1,269,177 |
£1,340,067 |
£1,422,536 |
£1,503,888 |
£1,580,716 |
£1,652,793 |
£1,734,296 |
£1,815,361 |
£1,884,101 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |