|
|
| Sales Forecast |
| Private |
0% |
£12,860 |
£10,966 |
£11,435 |
£12,889 |
£13,001 |
£15,777 |
£15,998 |
£24,960 |
£26,522 |
£20,009 |
£19,650 |
£22,103 |
| Public |
0% |
£3,852 |
£7,884 |
£7,200 |
£8,965 |
£8,566 |
£7,600 |
£9,705 |
£11,245 |
£11,780 |
£11,999 |
£12,300 |
£12,089 |
| Other |
0% |
£800 |
£955 |
£900 |
£1,190 |
£2,450 |
£2,133 |
£2,100 |
£4,656 |
£4,500 |
£4,622 |
£4,800 |
£4,688 |
| Total Sales |
|
£17,512 |
£19,805 |
£19,535 |
£23,044 |
£24,017 |
£25,510 |
£27,803 |
£40,861 |
£42,802 |
£36,630 |
£36,750 |
£38,880 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Private |
|
£1,800 |
£1,535 |
£1,601 |
£1,804 |
£1,820 |
£2,209 |
£2,240 |
£3,494 |
£3,713 |
£2,801 |
£2,751 |
£3,094 |
| Public |
|
£385 |
£788 |
£720 |
£897 |
£857 |
£760 |
£971 |
£1,125 |
£1,178 |
£1,200 |
£1,230 |
£1,209 |
| Other |
|
£40 |
£48 |
£45 |
£60 |
£123 |
£107 |
£105 |
£233 |
£225 |
£231 |
£240 |
£234 |
| Subtotal Direct Cost of Sales |
|
£2,226 |
£2,371 |
£2,366 |
£2,760 |
£2,799 |
£3,075 |
£3,315 |
£4,852 |
£5,116 |
£4,232 |
£4,221 |
£4,538 |
| Personnel Plan |
| Event Specialist |
0% |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
£3,000 |
| Site Manager |
0% |
£735 |
£907 |
£735 |
£735 |
£735 |
£735 |
£1,245 |
£1,400 |
£1,245 |
£875 |
£875 |
£875 |
| Other |
0% |
£586 |
£800 |
£586 |
£586 |
£586 |
£586 |
£844 |
£895 |
£844 |
£844 |
£895 |
£895 |
| Total People |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£4,321 |
£4,707 |
£4,321 |
£4,321 |
£4,321 |
£4,321 |
£5,089 |
£5,295 |
£5,089 |
£4,719 |
£4,770 |
£4,770 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£2,226 |
£2,371 |
£2,366 |
£2,760 |
£2,799 |
£3,075 |
£3,315 |
£4,852 |
£5,116 |
£4,232 |
£4,221 |
£4,538 |
| Other Costs of Sales |
|
£15 |
£13 |
£15 |
£16 |
£16 |
£16 |
£19 |
£22 |
£22 |
£13 |
£15 |
£14 |
| Total Cost of Sales |
|
£2,241 |
£2,384 |
£2,381 |
£2,776 |
£2,815 |
£3,091 |
£3,334 |
£4,874 |
£5,138 |
£4,245 |
£4,236 |
£4,552 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£15,271 |
£17,421 |
£17,154 |
£20,268 |
£21,202 |
£22,419 |
£24,469 |
£35,987 |
£37,664 |
£32,385 |
£32,514 |
£34,328 |
| Gross Margin % |
|
87.21% |
87.96% |
87.81% |
87.95% |
88.28% |
87.88% |
88.01% |
88.07% |
88.00% |
88.41% |
88.47% |
88.29% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£4,321 |
£4,707 |
£4,321 |
£4,321 |
£4,321 |
£4,321 |
£5,089 |
£5,295 |
£5,089 |
£4,719 |
£4,770 |
£4,770 |
| Sales & Marketing & Other Expenses |
|
£9,015 |
£10,748 |
£9,982 |
£10,260 |
£10,315 |
£10,415 |
£12,418 |
£18,015 |
£16,615 |
£13,290 |
£11,975 |
£12,965 |
| 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 |
|
£43 |
£43 |
£43 |
£43 |
£43 |
£43 |
£43 |
£43 |
£43 |
£43 |
£43 |
£43 |
| Insurance |
|
£22 |
£22 |
£22 |
£22 |
£22 |
£22 |
£22 |
£22 |
£22 |
£22 |
£22 |
£22 |
| Rent |
|
£120 |
£120 |
£120 |
£120 |
£120 |
£120 |
£120 |
£120 |
£120 |
£120 |
£120 |
£120 |
| Payroll Taxes |
12% |
£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 |
|
£1,750 |
£1,781 |
£2,666 |
£5,502 |
£6,381 |
£7,498 |
£6,777 |
£12,492 |
£15,775 |
£14,191 |
£15,584 |
£16,408 |
| EBITDA |
|
£1,750 |
£1,781 |
£2,666 |
£5,502 |
£6,381 |
£7,498 |
£6,777 |
£12,492 |
£15,775 |
£14,191 |
£15,584 |
£16,408 |
| Interest Expense |
|
£17 |
£50 |
£47 |
£44 |
£41 |
£38 |
£35 |
£33 |
£30 |
£27 |
£24 |
£21 |
| Taxes Incurred |
|
£416 |
£415 |
£629 |
£1,310 |
£1,521 |
£1,790 |
£1,618 |
£2,990 |
£3,779 |
£3,399 |
£3,734 |
£3,933 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
7.52% |
6.64% |
10.19% |
18.00% |
20.06% |
22.22% |
18.43% |
23.17% |
27.96% |
29.39% |
32.18% |
32.03% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£7,005 |
£7,922 |
£7,814 |
£9,218 |
£9,607 |
£10,204 |
£11,121 |
£16,344 |
£17,121 |
£14,652 |
£14,700 |
£15,552 |
| Cash from Receivables |
|
£0 |
£5,604 |
£11,241 |
£11,797 |
£12,844 |
£14,138 |
£14,888 |
£16,040 |
£20,860 |
£25,138 |
£23,706 |
£22,016 |
| Subtotal Cash from Operations |
|
£7,005 |
£13,526 |
£19,055 |
£21,014 |
£22,451 |
£24,342 |
£26,009 |
£32,384 |
£37,981 |
£39,790 |
£38,406 |
£37,568 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£4,000 |
£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 |
|
£7,005 |
£17,526 |
£19,055 |
£21,014 |
£22,451 |
£24,342 |
£26,009 |
£32,384 |
£37,981 |
£39,790 |
£38,406 |
£37,568 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£4,321 |
£4,707 |
£4,321 |
£4,321 |
£4,321 |
£4,321 |
£5,089 |
£5,295 |
£5,089 |
£4,719 |
£4,770 |
£4,770 |
| Bill Payments |
|
£477 |
£14,309 |
£13,919 |
£13,277 |
£15,006 |
£14,951 |
£15,891 |
£18,185 |
£27,728 |
£25,842 |
£20,173 |
£20,204 |
| Subtotal Spent on Operations |
|
£4,798 |
£19,016 |
£18,240 |
£17,598 |
£19,327 |
£19,272 |
£20,980 |
£23,480 |
£32,817 |
£30,561 |
£24,943 |
£24,974 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£350 |
£350 |
£350 |
£350 |
£350 |
£350 |
£350 |
£350 |
£350 |
£350 |
| 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 |
|
£4,798 |
£19,016 |
£18,590 |
£17,948 |
£19,677 |
£19,622 |
£21,330 |
£23,830 |
£33,167 |
£30,911 |
£25,293 |
£25,324 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£4,506 |
£3,016 |
£3,481 |
£6,547 |
£9,321 |
£14,041 |
£18,719 |
£27,273 |
£32,087 |
£40,966 |
£54,079 |
£66,323 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£2,300 |
£4,506 |
£3,016 |
£3,481 |
£6,547 |
£9,321 |
£14,041 |
£18,719 |
£27,273 |
£32,087 |
£40,966 |
£54,079 |
£66,323 |
| Accounts Receivable |
£0 |
£10,507 |
£16,786 |
£17,266 |
£19,296 |
£20,863 |
£22,031 |
£23,825 |
£32,301 |
£37,122 |
£33,963 |
£32,306 |
£33,618 |
| Inventory |
£0 |
£2,448 |
£2,609 |
£2,602 |
£3,037 |
£3,079 |
£3,383 |
£3,647 |
£5,337 |
£5,628 |
£4,655 |
£4,643 |
£4,991 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£2,300 |
£17,462 |
£22,411 |
£23,350 |
£28,880 |
£33,262 |
£39,454 |
£46,191 |
£64,911 |
£74,837 |
£79,584 |
£91,028 |
£104,933 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£2,300 |
£17,462 |
£22,411 |
£23,350 |
£28,880 |
£33,262 |
£39,454 |
£46,191 |
£64,911 |
£74,837 |
£79,584 |
£91,028 |
£104,933 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£13,844 |
£13,478 |
£12,777 |
£14,509 |
£14,423 |
£15,296 |
£17,259 |
£26,860 |
£25,169 |
£19,502 |
£19,470 |
£21,270 |
| Current Borrowing |
£2,000 |
£2,000 |
£6,000 |
£5,650 |
£5,300 |
£4,950 |
£4,600 |
£4,250 |
£3,900 |
£3,550 |
£3,200 |
£2,850 |
£2,500 |
| Other Current Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Current Liabilities |
£2,000 |
£15,844 |
£19,478 |
£18,427 |
£19,809 |
£19,373 |
£19,896 |
£21,509 |
£30,760 |
£28,719 |
£22,702 |
£22,320 |
£23,770 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Liabilities |
£2,000 |
£15,844 |
£19,478 |
£18,427 |
£19,809 |
£19,373 |
£19,896 |
£21,509 |
£30,760 |
£28,719 |
£22,702 |
£22,320 |
£23,770 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
£3,665 |
| Retained Earnings |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
(£3,365) |
| Earnings |
£0 |
£1,318 |
£2,633 |
£4,623 |
£8,771 |
£13,589 |
£19,258 |
£24,381 |
£33,851 |
£45,817 |
£56,582 |
£68,408 |
£80,862 |
| Total Capital |
£300 |
£1,618 |
£2,933 |
£4,923 |
£9,071 |
£13,889 |
£19,558 |
£24,681 |
£34,151 |
£46,117 |
£56,882 |
£68,708 |
£81,162 |
| Total Liabilities and Capital |
£2,300 |
£17,462 |
£22,411 |
£23,350 |
£28,880 |
£33,262 |
£39,454 |
£46,191 |
£64,911 |
£74,837 |
£79,584 |
£91,028 |
£104,933 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£300 |
£1,618 |
£2,933 |
£4,923 |
£9,071 |
£13,889 |
£19,558 |
£24,681 |
£34,151 |
£46,117 |
£56,882 |
£68,708 |
£81,162 |
|