|
|

| Sales Forecast |
| Technology Integration Fee (one-time) |
0% |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
1 |
1 |
| Annual Membership Fee |
0% |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
| Return Processing Fees |
0% |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
6,618 |
13,236 |
19,854 |
26,472 |
| Product Exchange Fees |
0% |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
3,309 |
3,309 |
3,309 |
3,309 |
| Total Unit Sales |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9,928 |
16,546 |
23,164 |
29,782 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Technology Integration Fee (one-time) |
|
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
£60,000.00 |
| Annual Membership Fee |
|
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
| Return Processing Fees |
|
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
£2.50 |
| Product Exchange Fees |
|
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
£2.10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Technology Integration Fee (one-time) |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£60,000 |
£60,000 |
£60,000 |
£60,000 |
| Annual Membership Fee |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Return Processing Fees |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£16,545 |
£33,090 |
£49,635 |
£66,180 |
| Product Exchange Fees |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£6,949 |
£6,949 |
£6,949 |
£6,949 |
| Total Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£83,494 |
£100,039 |
£116,584 |
£133,129 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Technology Integration Fee (one-time) |
0.00% |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
| Annual Membership Fee |
0.00% |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
| Return Processing Fees |
0.00% |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
| Product Exchange Fees |
0.00% |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Technology Integration Fee (one-time) |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Annual Membership Fee |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Return Processing Fees |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Product Exchange Fees |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Personnel Plan |
| Managers |
0% |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
£57,833 |
| Administrative personnel |
0% |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
£23,133 |
| Technical personnel |
0% |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
£34,700 |
| Total People |
|
40 |
40 |
40 |
40 |
40 |
40 |
40 |
40 |
40 |
40 |
40 |
40 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
| 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 |
|
£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 |
| Total Cost of Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£83,494 |
£100,039 |
£116,584 |
£133,129 |
| Gross Margin % |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
100.00% |
100.00% |
100.00% |
100.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
| Sales and Marketing and Other Expenses |
|
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
£136,458 |
| Depreciation |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Telephone |
|
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Software and Web site development |
|
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
£64,750 |
| Office supplies and subscriptions |
|
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
£6,867 |
| Rent |
|
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
£2,900 |
| Legal & Accounting |
|
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
£4,663 |
| Equipment Rental |
|
£21,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
£19,000 |
| Utilities |
|
£580 |
£580 |
£580 |
£580 |
£580 |
£580 |
£580 |
£580 |
£580 |
£580 |
£580 |
£580 |
| Payroll Taxes |
15% |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
£17,350 |
| Hardware & Maintenance |
15% |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
£26,875 |
| Other |
|
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
£20,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
(£418,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£332,615) |
(£316,070) |
(£299,525) |
(£282,980) |
| EBITDA |
|
(£418,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£416,109) |
(£332,615) |
(£316,070) |
(£299,525) |
(£282,980) |
| Interest Expense |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Taxes Incurred |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
-398.37% |
-315.95% |
-256.92% |
-212.56% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Cash from Receivables |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£2,783 |
£84,045 |
£100,590 |
| Subtotal Cash from Operations |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£2,783 |
£84,045 |
£100,590 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£2,000,000 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Received |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£2,000,000 |
£0 |
£2,783 |
£84,045 |
£100,590 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
£115,666 |
| Bill Payments |
|
£10,081 |
£302,376 |
£300,443 |
£300,443 |
£300,443 |
£300,443 |
£300,443 |
£300,443 |
£300,443 |
£300,443 |
£300,443 |
£300,443 |
| Subtotal Spent on Operations |
|
£125,747 |
£418,042 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£125,747 |
£418,042 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
£416,109 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£3,424,253 |
£3,006,210 |
£2,590,101 |
£2,173,993 |
£1,757,884 |
£1,341,775 |
£925,666 |
£2,509,557 |
£2,093,448 |
£1,680,122 |
£1,348,059 |
£1,032,540 |
| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£3,550,000 |
£3,424,253 |
£3,006,210 |
£2,590,101 |
£2,173,993 |
£1,757,884 |
£1,341,775 |
£925,666 |
£2,509,557 |
£2,093,448 |
£1,680,122 |
£1,348,059 |
£1,032,540 |
| Accounts Receivable |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£83,494 |
£180,750 |
£213,288 |
£245,827 |
| Other Current Assets |
£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 |
| Total Current Assets |
£3,600,000 |
£3,474,253 |
£3,056,210 |
£2,640,101 |
£2,223,993 |
£1,807,884 |
£1,391,775 |
£975,666 |
£2,559,557 |
£2,226,942 |
£1,910,872 |
£1,611,347 |
£1,328,367 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Accumulated Depreciation |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Long-term Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Assets |
£3,600,000 |
£3,474,253 |
£3,056,210 |
£2,640,101 |
£2,223,993 |
£1,807,884 |
£1,391,775 |
£975,666 |
£2,559,557 |
£2,226,942 |
£1,910,872 |
£1,611,347 |
£1,328,367 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|