| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Off-Site Food & Beverage | £50,000 | £52,500 | £55,125 | £57,881 | £60,775 | £63,814 | £67,005 | £69,685 | £72,472 | £75,371 | £78,386 | £81,522 | |
| Sumptuous Ballroom Food & Beverage | £0 | £0 | £5,000 | £5,500 | £6,050 | £6,655 | £7,321 | £8,053 | £8,858 | £9,744 | £10,718 | £11,790 | |
| Subcontracted Services | £25,000 | £25,750 | £26,523 | £27,318 | £28,138 | £28,982 | £29,851 | £30,747 | £31,669 | £32,619 | £33,598 | £34,606 | |
| Ballroom Rentals | £0 | £0 | £5,000 | £7,500 | £11,250 | £13,750 | £16,250 | £18,750 | £21,250 | £23,750 | £25,000 | £26,250 | |
| Staffing | £37,500 | £39,375 | £45,094 | £47,536 | £50,119 | £52,852 | £55,744 | £58,303 | £60,998 | £63,836 | £66,828 | £69,983 | |
| Referral Fees/Commissions | £6,250 | £6,563 | £7,516 | £7,923 | £8,353 | £8,809 | £9,291 | £9,717 | £10,166 | £10,639 | £11,138 | £11,664 | |
| Event Planning | £6,250 | £6,563 | £7,516 | £7,923 | £8,353 | £8,809 | £9,291 | £9,717 | £10,166 | £10,639 | £11,138 | £11,664 | |
| Total Sales | £125,000 | £130,750 | £151,773 | £161,581 | £173,038 | £183,670 | £194,752 | £204,972 | £215,580 | £226,599 | £236,806 | £247,478 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Food and Beverage Cost | 25% | £12,500 | £13,125 | £15,031 | £15,845 | £16,706 | £17,617 | £18,581 | £19,434 | £20,333 | £21,279 | £22,276 | £23,328 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £12,500 | £13,125 | £15,031 | £15,845 | £16,706 | £17,617 | £18,581 | £19,434 | £20,333 | £21,279 | £22,276 | £23,328 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| CEO | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| COO | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Marketing Director | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Salespeople | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Administrative Assistant | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Head Cook | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Assistant Cooks | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Facility Manager | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £125,000 | £130,750 | £151,773 | £161,581 | £173,038 | £183,670 | £194,752 | £204,972 | £215,580 | £226,599 | £236,806 | £247,478 | |
| Direct Cost of Sales | £12,500 | £13,125 | £15,031 | £15,845 | £16,706 | £17,617 | £18,581 | £19,434 | £20,333 | £21,279 | £22,276 | £23,328 | |
| Event Staff | 17% | £21,250 | £22,228 | £25,801 | £27,469 | £29,417 | £31,224 | £33,108 | £34,845 | £36,649 | £38,522 | £40,257 | £42,071 |
| Subcontracted Services | £20,000 | £20,600 | £21,218 | £21,855 | £22,510 | £23,185 | £23,881 | £24,597 | £25,335 | £26,095 | £26,878 | £27,685 | |
| Total Cost of Sales | £53,750 | £55,953 | £62,051 | £65,169 | £68,633 | £72,027 | £75,570 | £78,877 | £82,316 | £85,896 | £89,411 | £93,084 | |
| Gross Margin | £71,250 | £74,798 | £89,722 | £96,412 | £104,405 | £111,643 | £119,182 | £126,095 | £133,263 | £140,703 | £147,395 | £154,395 | |
| Gross Margin % | 57.00% | 57.21% | 59.12% | 59.67% | 60.34% | 60.78% | 61.20% | 61.52% | 61.82% | 62.09% | 62.24% | 62.39% | |
| Expenses | |||||||||||||
| Payroll | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | |
| Marketing/Promotion | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £8,000 | £8,000 | £8,000 | £6,000 | £6,000 | |
| Depreciation | 50000 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £525 | £551 | £579 | £608 | £638 | £670 | £704 | £739 | £776 | £814 | £855 | |
| Insurance | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £9,113 | £9,259 | £9,795 | £10,045 | £10,337 | £10,609 | £10,891 | £11,152 | £11,422 | £11,703 | £11,964 | £12,236 |
| Employee Benefits | 10% | £6,075 | £6,173 | £6,530 | £6,697 | £6,892 | £7,072 | £7,261 | £7,435 | £7,615 | £7,802 | £7,976 | £8,157 |
| Office Expenses | 15% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Facility Cleaning & Maintenance | £6,450 | £6,738 | £7,789 | £8,279 | £8,852 | £9,384 | £9,938 | £10,449 | £10,979 | £11,530 | £12,040 | £12,574 | |
| Total Operating Expenses | £79,471 | £80,028 | £81,999 | £82,933 | £84,022 | £85,036 | £86,093 | £85,072 | £86,088 | £87,144 | £86,127 | £87,155 | |
| Profit Before Interest and Taxes | (£8,221) | (£5,230) | £7,723 | £13,479 | £20,383 | £26,607 | £33,089 | £41,023 | £47,175 | £53,559 | £61,267 | £67,239 | |
| EBITDA | (£5,888) | (£2,897) | £10,057 | £15,812 | £22,717 | £28,941 | £35,422 | £43,356 | £49,508 | £55,892 | £63,601 | £69,573 | |
| Interest Expense | £15,509 | £15,435 | £15,361 | £15,287 | £15,213 | £15,139 | £15,065 | £14,991 | £14,917 | £14,843 | £14,769 | £14,694 | |
| Taxes Incurred | (£7,119) | (£6,200) | (£2,291) | (£542) | £1,551 | £3,441 | £5,407 | £7,810 | £9,677 | £11,615 | £13,950 | £15,763 | |
| Net Profit | (£16,611) | (£14,466) | (£5,346) | (£1,266) | £3,619 | £8,028 | £12,617 | £18,223 | £22,581 | £27,101 | £32,549 | £36,781 | |
| Net Profit/Sales | -13.29% | -11.06% | -3.52% | -0.78% | 2.09% | 4.37% | 6.48% | 8.89% | 10.47% | 11.96% | 13.75% | 14.86% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £62,500 | £65,375 | £75,886 | £80,790 | £86,519 | £91,835 | £97,376 | £102,486 | £107,790 | £113,300 | £118,403 | £123,739 | |
| Cash from Receivables | £72,222 | £69,444 | £64,033 | £70,981 | £78,502 | £83,846 | £89,354 | £94,790 | £100,101 | £105,315 | £110,728 | £116,021 | |
| Subtotal Cash from Operations | £134,722 | £134,819 | £139,920 | £151,771 | £165,021 | £175,681 | £186,730 | £197,276 | £207,891 | £218,614 | £229,131 | £239,761 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 8.00% | £10,000 | £10,460 | £12,142 | £12,926 | £13,843 | £14,694 | £15,580 | £16,398 | £17,246 | £18,128 | £18,944 | £19,798 |
| 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 | £1,870,000 | £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 | £2,014,722 | £145,279 | £152,061 | £164,698 | £178,864 | £190,374 | £202,310 | £213,674 | £225,137 | £236,742 | £248,076 | £259,559 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | |
| Bill Payments | £53,001 | £90,483 | £104,113 | £116,411 | £121,640 | £128,225 | £134,482 | £140,936 | £145,552 | £151,832 | £158,297 | £163,138 | |
| Subtotal Spent on Operations | £92,501 | £129,983 | £143,613 | £155,911 | £161,140 | £167,725 | £173,982 | £180,436 | £185,052 | £191,332 | £197,797 | £202,638 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £10,000 | £10,460 | £12,142 | £12,926 | £13,843 | £14,694 | £15,580 | £16,398 | £17,246 | £18,128 | £18,944 | £19,798 | |
| 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 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | |
| Purchase Other Current Assets | £100,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £2,050,000 | £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 | £2,261,390 | £149,332 | £164,644 | £177,727 | £183,872 | £191,307 | £198,451 | £205,723 | £211,187 | £218,349 | £225,631 | £231,325 | |
| Net Cash Flow | (£246,668) | (£4,053) | (£12,582) | (£13,029) | (£5,008) | (£933) | £3,860 | £7,951 | £13,951 | £18,393 | £22,445 | £28,234 | |
| Cash Balance | £53,332 | £49,279 | £36,697 | £23,668 | £18,660 | £17,727 | £21,587 | £29,538 | £43,488 | £61,882 | £84,327 | £112,561 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £300,000 | £53,332 | £49,279 | £36,697 | £23,668 | £18,660 | £17,727 | £21,587 | £29,538 | £43,488 | £61,882 | £84,327 | £112,561 |
| Accounts Receivable | £108,333 | £98,611 | £94,542 | £106,395 | £116,204 | £124,221 | £132,211 | £140,232 | £147,928 | £155,617 | £163,601 | £171,276 | £178,994 |
| Inventory | £16,000 | £6,250 | £6,563 | £7,516 | £7,923 | £8,353 | £8,809 | £9,291 | £9,717 | £10,166 | £10,639 | £11,138 | £11,664 |
| Other Current Assets | £2,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 |
| Total Current Assets | £426,833 | £260,693 | £252,884 | £253,107 | £250,294 | £253,734 | £261,246 | £273,610 | £289,683 | £311,771 | £338,622 | £369,241 | £405,719 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £90,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 |
| Accumulated Depreciation | £40,000 | £42,333 | £44,667 | £47,000 | £49,333 | £51,667 | £54,000 | £56,333 | £58,667 | £61,000 | £63,333 | £65,667 | £68,000 |
| Total Long-term Assets | £50,000 | £2,097,667 | £2,095,333 | £2,093,000 | £2,090,667 | £2,088,333 | £2,086,000 | £2,083,667 | £2,081,333 | £2,079,000 | £2,076,667 | £2,074,333 | £2,072,000 |
| Total Assets | £476,833 | £2,358,360 | £2,348,217 | £2,346,107 | £2,340,961 | £2,342,068 | £2,347,246 | £2,357,276 | £2,371,017 | £2,390,771 | £2,415,289 | £2,443,574 | £2,477,719 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £50,000 | £87,027 | £100,238 | £112,364 | £117,373 | £123,749 | £129,789 | £136,091 | £140,498 | £146,561 | £152,866 | £157,491 | £163,743 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £50,000 | £87,027 | £100,238 | £112,364 | £117,373 | £123,749 | £129,789 | £136,091 | £140,498 | £146,561 | £152,866 | £157,491 | £163,743 |
| Long-term Liabilities | £0 | £1,861,111 | £1,852,222 | £1,843,333 | £1,834,444 | £1,825,555 | £1,816,666 | £1,807,777 | £1,798,888 | £1,789,999 | £1,781,110 | £1,772,221 | £1,763,332 |
| Total Liabilities | £50,000 | £1,948,138 | £1,952,460 | £1,955,697 | £1,951,817 | £1,949,304 | £1,946,455 | £1,943,868 | £1,939,386 | £1,936,560 | £1,933,976 | £1,929,712 | £1,927,075 |
| Paid-in Capital | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 |
| Retained Earnings | £151,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 |
| Earnings | £75,000 | (£16,611) | (£31,077) | (£36,423) | (£37,689) | (£34,070) | (£26,042) | (£13,425) | £4,797 | £27,378 | £54,479 | £87,029 | £123,810 |
| Total Capital | £426,833 | £410,222 | £395,756 | £390,410 | £389,144 | £392,763 | £400,791 | £413,408 | £431,631 | £454,212 | £481,313 | £513,862 | £550,643 |
| Total Liabilities and Capital | £476,833 | £2,358,360 | £2,348,217 | £2,346,107 | £2,340,961 | £2,342,068 | £2,347,246 | £2,357,276 | £2,371,017 | £2,390,771 | £2,415,289 | £2,443,574 | £2,477,719 |
| Net Worth | £426,833 | £410,222 | £395,756 | £390,410 | £389,144 | £392,763 | £400,791 | £413,408 | £431,631 | £454,212 | £481,313 | £513,862 | £550,643 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Off-Site Food & Beverage | £50,000 | £52,500 | £55,125 | £57,881 | £60,775 | £63,814 | £67,005 | £69,685 | £72,472 | £75,371 | £78,386 | £81,522 | |
| Sumptuous Ballroom Food & Beverage | £0 | £0 | £5,000 | £5,500 | £6,050 | £6,655 | £7,321 | £8,053 | £8,858 | £9,744 | £10,718 | £11,790 | |
| Subcontracted Services | £25,000 | £25,750 | £26,523 | £27,318 | £28,138 | £28,982 | £29,851 | £30,747 | £31,669 | £32,619 | £33,598 | £34,606 | |
| Ballroom Rentals | £0 | £0 | £5,000 | £7,500 | £11,250 | £13,750 | £16,250 | £18,750 | £21,250 | £23,750 | £25,000 | £26,250 | |
| Staffing | £37,500 | £39,375 | £45,094 | £47,536 | £50,119 | £52,852 | £55,744 | £58,303 | £60,998 | £63,836 | £66,828 | £69,983 | |
| Referral Fees/Commissions | £6,250 | £6,563 | £7,516 | £7,923 | £8,353 | £8,809 | £9,291 | £9,717 | £10,166 | £10,639 | £11,138 | £11,664 | |
| Event Planning | £6,250 | £6,563 | £7,516 | £7,923 | £8,353 | £8,809 | £9,291 | £9,717 | £10,166 | £10,639 | £11,138 | £11,664 | |
| Total Sales | £125,000 | £130,750 | £151,773 | £161,581 | £173,038 | £183,670 | £194,752 | £204,972 | £215,580 | £226,599 | £236,806 | £247,478 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Food and Beverage Cost | 25% | £12,500 | £13,125 | £15,031 | £15,845 | £16,706 | £17,617 | £18,581 | £19,434 | £20,333 | £21,279 | £22,276 | £23,328 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £12,500 | £13,125 | £15,031 | £15,845 | £16,706 | £17,617 | £18,581 | £19,434 | £20,333 | £21,279 | £22,276 | £23,328 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| CEO | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | |
| COO | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Marketing Director | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Salespeople | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Administrative Assistant | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Head Cook | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Assistant Cooks | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Facility Manager | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £125,000 | £130,750 | £151,773 | £161,581 | £173,038 | £183,670 | £194,752 | £204,972 | £215,580 | £226,599 | £236,806 | £247,478 | |
| Direct Cost of Sales | £12,500 | £13,125 | £15,031 | £15,845 | £16,706 | £17,617 | £18,581 | £19,434 | £20,333 | £21,279 | £22,276 | £23,328 | |
| Event Staff | 17% | £21,250 | £22,228 | £25,801 | £27,469 | £29,417 | £31,224 | £33,108 | £34,845 | £36,649 | £38,522 | £40,257 | £42,071 |
| Subcontracted Services | £20,000 | £20,600 | £21,218 | £21,855 | £22,510 | £23,185 | £23,881 | £24,597 | £25,335 | £26,095 | £26,878 | £27,685 | |
| Total Cost of Sales | £53,750 | £55,953 | £62,051 | £65,169 | £68,633 | £72,027 | £75,570 | £78,877 | £82,316 | £85,896 | £89,411 | £93,084 | |
| Gross Margin | £71,250 | £74,798 | £89,722 | £96,412 | £104,405 | £111,643 | £119,182 | £126,095 | £133,263 | £140,703 | £147,395 | £154,395 | |
| Gross Margin % | 57.00% | 57.21% | 59.12% | 59.67% | 60.34% | 60.78% | 61.20% | 61.52% | 61.82% | 62.09% | 62.24% | 62.39% | |
| Expenses | |||||||||||||
| Payroll | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | |
| Marketing/Promotion | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £8,000 | £8,000 | £8,000 | £6,000 | £6,000 | |
| Depreciation | 50000 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 | £2,333 |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £525 | £551 | £579 | £608 | £638 | £670 | £704 | £739 | £776 | £814 | £855 | |
| Insurance | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £9,113 | £9,259 | £9,795 | £10,045 | £10,337 | £10,609 | £10,891 | £11,152 | £11,422 | £11,703 | £11,964 | £12,236 |
| Employee Benefits | 10% | £6,075 | £6,173 | £6,530 | £6,697 | £6,892 | £7,072 | £7,261 | £7,435 | £7,615 | £7,802 | £7,976 | £8,157 |
| Office Expenses | 15% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Facility Cleaning & Maintenance | £6,450 | £6,738 | £7,789 | £8,279 | £8,852 | £9,384 | £9,938 | £10,449 | £10,979 | £11,530 | £12,040 | £12,574 | |
| Total Operating Expenses | £79,471 | £80,028 | £81,999 | £82,933 | £84,022 | £85,036 | £86,093 | £85,072 | £86,088 | £87,144 | £86,127 | £87,155 | |
| Profit Before Interest and Taxes | (£8,221) | (£5,230) | £7,723 | £13,479 | £20,383 | £26,607 | £33,089 | £41,023 | £47,175 | £53,559 | £61,267 | £67,239 | |
| EBITDA | (£5,888) | (£2,897) | £10,057 | £15,812 | £22,717 | £28,941 | £35,422 | £43,356 | £49,508 | £55,892 | £63,601 | £69,573 | |
| Interest Expense | £15,509 | £15,435 | £15,361 | £15,287 | £15,213 | £15,139 | £15,065 | £14,991 | £14,917 | £14,843 | £14,769 | £14,694 | |
| Taxes Incurred | (£7,119) | (£6,200) | (£2,291) | (£542) | £1,551 | £3,441 | £5,407 | £7,810 | £9,677 | £11,615 | £13,950 | £15,763 | |
| Net Profit | (£16,611) | (£14,466) | (£5,346) | (£1,266) | £3,619 | £8,028 | £12,617 | £18,223 | £22,581 | £27,101 | £32,549 | £36,781 | |
| Net Profit/Sales | -13.29% | -11.06% | -3.52% | -0.78% | 2.09% | 4.37% | 6.48% | 8.89% | 10.47% | 11.96% | 13.75% | 14.86% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £62,500 | £65,375 | £75,886 | £80,790 | £86,519 | £91,835 | £97,376 | £102,486 | £107,790 | £113,300 | £118,403 | £123,739 | |
| Cash from Receivables | £72,222 | £69,444 | £64,033 | £70,981 | £78,502 | £83,846 | £89,354 | £94,790 | £100,101 | £105,315 | £110,728 | £116,021 | |
| Subtotal Cash from Operations | £134,722 | £134,819 | £139,920 | £151,771 | £165,021 | £175,681 | £186,730 | £197,276 | £207,891 | £218,614 | £229,131 | £239,761 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 8.00% | £10,000 | £10,460 | £12,142 | £12,926 | £13,843 | £14,694 | £15,580 | £16,398 | £17,246 | £18,128 | £18,944 | £19,798 |
| 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 | £1,870,000 | £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 | £2,014,722 | £145,279 | £152,061 | £164,698 | £178,864 | £190,374 | £202,310 | £213,674 | £225,137 | £236,742 | £248,076 | £259,559 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | £39,500 | |
| Bill Payments | £53,001 | £90,483 | £104,113 | £116,411 | £121,640 | £128,225 | £134,482 | £140,936 | £145,552 | £151,832 | £158,297 | £163,138 | |
| Subtotal Spent on Operations | £92,501 | £129,983 | £143,613 | £155,911 | £161,140 | £167,725 | £173,982 | £180,436 | £185,052 | £191,332 | £197,797 | £202,638 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £10,000 | £10,460 | £12,142 | £12,926 | £13,843 | £14,694 | £15,580 | £16,398 | £17,246 | £18,128 | £18,944 | £19,798 | |
| 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 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | £8,889 | |
| Purchase Other Current Assets | £100,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £2,050,000 | £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 | £2,261,390 | £149,332 | £164,644 | £177,727 | £183,872 | £191,307 | £198,451 | £205,723 | £211,187 | £218,349 | £225,631 | £231,325 | |
| Net Cash Flow | (£246,668) | (£4,053) | (£12,582) | (£13,029) | (£5,008) | (£933) | £3,860 | £7,951 | £13,951 | £18,393 | £22,445 | £28,234 | |
| Cash Balance | £53,332 | £49,279 | £36,697 | £23,668 | £18,660 | £17,727 | £21,587 | £29,538 | £43,488 | £61,882 | £84,327 | £112,561 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £300,000 | £53,332 | £49,279 | £36,697 | £23,668 | £18,660 | £17,727 | £21,587 | £29,538 | £43,488 | £61,882 | £84,327 | £112,561 |
| Accounts Receivable | £108,333 | £98,611 | £94,542 | £106,395 | £116,204 | £124,221 | £132,211 | £140,232 | £147,928 | £155,617 | £163,601 | £171,276 | £178,994 |
| Inventory | £16,000 | £6,250 | £6,563 | £7,516 | £7,923 | £8,353 | £8,809 | £9,291 | £9,717 | £10,166 | £10,639 | £11,138 | £11,664 |
| Other Current Assets | £2,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 | £102,500 |
| Total Current Assets | £426,833 | £260,693 | £252,884 | £253,107 | £250,294 | £253,734 | £261,246 | £273,610 | £289,683 | £311,771 | £338,622 | £369,241 | £405,719 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £90,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 | £2,140,000 |
| Accumulated Depreciation | £40,000 | £42,333 | £44,667 | £47,000 | £49,333 | £51,667 | £54,000 | £56,333 | £58,667 | £61,000 | £63,333 | £65,667 | £68,000 |
| Total Long-term Assets | £50,000 | £2,097,667 | £2,095,333 | £2,093,000 | £2,090,667 | £2,088,333 | £2,086,000 | £2,083,667 | £2,081,333 | £2,079,000 | £2,076,667 | £2,074,333 | £2,072,000 |
| Total Assets | £476,833 | £2,358,360 | £2,348,217 | £2,346,107 | £2,340,961 | £2,342,068 | £2,347,246 | £2,357,276 | £2,371,017 | £2,390,771 | £2,415,289 | £2,443,574 | £2,477,719 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £50,000 | £87,027 | £100,238 | £112,364 | £117,373 | £123,749 | £129,789 | £136,091 | £140,498 | £146,561 | £152,866 | £157,491 | £163,743 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £50,000 | £87,027 | £100,238 | £112,364 | £117,373 | £123,749 | £129,789 | £136,091 | £140,498 | £146,561 | £152,866 | £157,491 | £163,743 |
| Long-term Liabilities | £0 | £1,861,111 | £1,852,222 | £1,843,333 | £1,834,444 | £1,825,555 | £1,816,666 | £1,807,777 | £1,798,888 | £1,789,999 | £1,781,110 | £1,772,221 | £1,763,332 |
| Total Liabilities | £50,000 | £1,948,138 | £1,952,460 | £1,955,697 | £1,951,817 | £1,949,304 | £1,946,455 | £1,943,868 | £1,939,386 | £1,936,560 | £1,933,976 | £1,929,712 | £1,927,075 |
| Paid-in Capital | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 | £200,000 |
| Retained Earnings | £151,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 | £226,833 |
| Earnings | £75,000 | (£16,611) | (£31,077) | (£36,423) | (£37,689) | (£34,070) | (£26,042) | (£13,425) | £4,797 | £27,378 | £54,479 | £87,029 | £123,810 |
| Total Capital | £426,833 | £410,222 | £395,756 | £390,410 | £389,144 | £392,763 | £400,791 | £413,408 | £431,631 | £454,212 | £481,313 | £513,862 | £550,643 |
| Total Liabilities and Capital | £476,833 | £2,358,360 | £2,348,217 | £2,346,107 | £2,340,961 | £2,342,068 | £2,347,246 | £2,357,276 | £2,371,017 | £2,390,771 | £2,415,289 | £2,443,574 | £2,477,719 |
| Net Worth | £426,833 | £410,222 | £395,756 | £390,410 | £389,144 | £392,763 | £400,791 | £413,408 | £431,631 | £454,212 | £481,313 | £513,862 | £550,643 |