| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Beverage Sales | 0% | £44,600 | £77,100 | £96,300 | £131,700 | £152,800 | £167,100 | £165,700 | £155,200 | £134,900 | £108,500 | £76,800 | £35,400 |
| Food Sales | 0% | £4,900 | £6,300 | £7,100 | £7,900 | £9,100 | £9,900 | £10,000 | £9,400 | £8,700 | £7,500 | £6,600 | £6,100 |
| Admission Sales | 0% | £34,100 | £56,800 | £74,600 | £76,900 | £75,100 | £82,900 | £88,440 | £87,000 | £82,400 | £74,200 | £60,400 | £43,900 |
| Total Sales | £83,600 | £140,200 | £178,000 | £216,500 | £237,000 | £259,900 | £264,140 | £251,600 | £226,000 | £190,200 | £143,800 | £85,400 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Beverage Sales | 25% | £11,150 | £19,275 | £24,075 | £32,925 | £38,200 | £41,775 | £41,425 | £38,800 | £33,725 | £27,125 | £19,200 | £8,850 |
| Food Sales | 33% | £1,617 | £2,079 | £2,343 | £2,607 | £3,003 | £3,267 | £3,300 | £3,102 | £2,871 | £2,475 | £2,178 | £2,013 |
| Admission Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £12,767 | £21,354 | £26,418 | £35,532 | £41,203 | £45,042 | £44,725 | £41,902 | £36,596 | £29,600 | £21,378 | £10,863 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Salaried Staff | 0% | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 |
| Hourly Staff | 0% | £5,100 | £8,700 | £9,400 | £9,500 | £9,900 | £10,600 | £10,900 | £10,700 | £9,500 | £8,500 | £7,600 | £6,800 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £28,828 | £32,428 | £33,128 | £33,228 | £33,628 | £34,328 | £34,628 | £34,428 | £33,228 | £32,228 | £31,328 | £30,528 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £83,600 | £140,200 | £178,000 | £216,500 | £237,000 | £259,900 | £264,140 | £251,600 | £226,000 | £190,200 | £143,800 | £85,400 | |
| Direct Cost of Sales | £12,767 | £21,354 | £26,418 | £35,532 | £41,203 | £45,042 | £44,725 | £41,902 | £36,596 | £29,600 | £21,378 | £10,863 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £12,767 | £21,354 | £26,418 | £35,532 | £41,203 | £45,042 | £44,725 | £41,902 | £36,596 | £29,600 | £21,378 | £10,863 | |
| Gross Margin | £70,833 | £118,846 | £151,582 | £180,968 | £195,797 | £214,858 | £219,415 | £209,698 | £189,404 | £160,600 | £122,422 | £74,537 | |
| Gross Margin % | 84.73% | 84.77% | 85.16% | 83.59% | 82.61% | 82.67% | 83.07% | 83.35% | 83.81% | 84.44% | 85.13% | 87.28% | |
| Expenses | |||||||||||||
| Payroll | £28,828 | £32,428 | £33,128 | £33,228 | £33,628 | £34,328 | £34,628 | £34,428 | £33,228 | £32,228 | £31,328 | £30,528 | |
| Sales and Marketing and Other Expenses | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Fees--Credit Card | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | |
| Fees--Professional | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | |
| Taxes--Admission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes--Excise | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | |
| Taxes--Property | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | |
| Utilities | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Insurance | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | |
| Rent | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Payroll Taxes | 17% | £4,901 | £5,513 | £5,632 | £5,649 | £5,717 | £5,836 | £5,887 | £5,853 | £5,649 | £5,479 | £5,326 | £5,190 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £113,510 | £117,722 | £118,541 | £118,658 | £119,126 | £119,945 | £120,296 | £120,062 | £118,658 | £117,488 | £116,435 | £115,499 | |
| Profit Before Interest and Taxes | (£42,677) | £1,124 | £33,041 | £62,310 | £76,671 | £94,913 | £99,119 | £89,636 | £70,746 | £43,112 | £5,987 | (£40,962) | |
| EBITDA | (£42,677) | £1,124 | £33,041 | £62,310 | £76,671 | £94,913 | £99,119 | £89,636 | £70,746 | £43,112 | £5,987 | (£40,962) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£12,803) | £281 | £8,260 | £15,578 | £19,168 | £23,728 | £24,780 | £22,409 | £17,687 | £10,778 | £1,497 | (£10,240) | |
| Net Profit | (£29,874) | £843 | £24,781 | £46,733 | £57,503 | £71,185 | £74,339 | £67,227 | £53,060 | £32,334 | £4,490 | (£30,721) | |
| Net Profit/Sales | -35.73% | 0.60% | 13.92% | 21.59% | 24.26% | 27.39% | 28.14% | 26.72% | 23.48% | 17.00% | 3.12% | -35.97% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £75,240 | £126,180 | £160,200 | £194,850 | £213,300 | £233,910 | £237,726 | £226,440 | £203,400 | £171,180 | £129,420 | £76,860 | |
| Cash from Receivables | £0 | £279 | £8,549 | £14,146 | £17,928 | £21,718 | £23,776 | £26,004 | £26,372 | £25,075 | £22,481 | £18,865 | |
| Subtotal Cash from Operations | £75,240 | £126,459 | £168,749 | £208,996 | £231,228 | £255,628 | £261,502 | £252,444 | £229,772 | £196,255 | £151,901 | £95,725 | |
| 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 | £75,240 | £126,459 | £168,749 | £208,996 | £231,228 | £255,628 | £261,502 | £252,444 | £229,772 | £196,255 | £151,901 | £95,725 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £28,828 | £32,428 | £33,128 | £33,228 | £33,628 | £34,328 | £34,628 | £34,428 | £33,228 | £32,228 | £31,328 | £30,528 | |
| Bill Payments | £3,040 | £92,029 | £116,684 | £126,358 | £146,749 | £152,323 | £158,484 | £154,558 | £146,407 | £133,345 | £117,309 | £98,130 | |
| Subtotal Spent on Operations | £31,868 | £124,457 | £149,812 | £159,586 | £180,377 | £186,651 | £193,112 | £188,986 | £179,635 | £165,573 | £148,637 | £128,658 | |
| 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 | £31,868 | £124,457 | £149,812 | £159,586 | £180,377 | £186,651 | £193,112 | £188,986 | £179,635 | £165,573 | £148,637 | £128,658 | |
| Net Cash Flow | £43,372 | £2,002 | £18,937 | £49,410 | £50,851 | £68,977 | £68,391 | £63,458 | £50,137 | £30,682 | £3,264 | (£32,933) | |
| Cash Balance | £118,372 | £120,374 | £139,311 | £188,720 | £239,571 | £308,548 | £376,939 | £440,397 | £490,534 | £521,216 | £524,480 | £491,547 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £75,000 | £118,372 | £120,374 | £139,311 | £188,720 | £239,571 | £308,548 | £376,939 | £440,397 | £490,534 | £521,216 | £524,480 | £491,547 |
| Accounts Receivable | £0 | £8,360 | £22,101 | £31,353 | £38,857 | £44,628 | £48,900 | £51,538 | £50,694 | £46,921 | £40,867 | £32,766 | £22,441 |
| Inventory | £7,500 | £14,044 | £23,489 | £29,060 | £39,085 | £45,323 | £49,546 | £49,198 | £46,092 | £40,256 | £32,560 | £23,516 | £12,653 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £82,500 | £140,776 | £165,965 | £199,723 | £266,662 | £329,523 | £406,994 | £477,674 | £537,183 | £577,711 | £594,643 | £580,762 | £526,640 |
| 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 | £82,500 | £140,776 | £165,965 | £199,723 | £266,662 | £329,523 | £406,994 | £477,674 | £537,183 | £577,711 | £594,643 | £580,762 | £526,640 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £88,150 | £112,495 | £121,473 | £141,679 | £147,036 | £153,323 | £149,663 | £141,945 | £129,413 | £114,011 | £95,639 | £72,239 |
| 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 | £0 | £88,150 | £112,495 | £121,473 | £141,679 | £147,036 | £153,323 | £149,663 | £141,945 | £129,413 | £114,011 | £95,639 | £72,239 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £88,150 | £112,495 | £121,473 | £141,679 | £147,036 | £153,323 | £149,663 | £141,945 | £129,413 | £114,011 | £95,639 | £72,239 |
| Paid-in Capital | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 |
| Retained Earnings | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) |
| Earnings | £0 | (£29,874) | (£29,031) | (£4,250) | £42,483 | £99,986 | £171,171 | £245,511 | £312,738 | £365,798 | £398,132 | £402,622 | £371,901 |
| Total Capital | £82,500 | £52,626 | £53,469 | £78,250 | £124,983 | £182,486 | £253,671 | £328,011 | £395,238 | £448,298 | £480,632 | £485,122 | £454,401 |
| Total Liabilities and Capital | £82,500 | £140,776 | £165,965 | £199,723 | £266,662 | £329,523 | £406,994 | £477,674 | £537,183 | £577,711 | £594,643 | £580,762 | £526,640 |
| Net Worth | £82,500 | £52,626 | £53,469 | £78,250 | £124,983 | £182,486 | £253,671 | £328,011 | £395,238 | £448,298 | £480,632 | £485,122 | £454,401 |
| Sales Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | |||||||||||||
| Beverage Sales | 0% | £44,600 | £77,100 | £96,300 | £131,700 | £152,800 | £167,100 | £165,700 | £155,200 | £134,900 | £108,500 | £76,800 | £35,400 |
| Food Sales | 0% | £4,900 | £6,300 | £7,100 | £7,900 | £9,100 | £9,900 | £10,000 | £9,400 | £8,700 | £7,500 | £6,600 | £6,100 |
| Admission Sales | 0% | £34,100 | £56,800 | £74,600 | £76,900 | £75,100 | £82,900 | £88,440 | £87,000 | £82,400 | £74,200 | £60,400 | £43,900 |
| Total Sales | £83,600 | £140,200 | £178,000 | £216,500 | £237,000 | £259,900 | £264,140 | £251,600 | £226,000 | £190,200 | £143,800 | £85,400 | |
| Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Beverage Sales | 25% | £11,150 | £19,275 | £24,075 | £32,925 | £38,200 | £41,775 | £41,425 | £38,800 | £33,725 | £27,125 | £19,200 | £8,850 |
| Food Sales | 33% | £1,617 | £2,079 | £2,343 | £2,607 | £3,003 | £3,267 | £3,300 | £3,102 | £2,871 | £2,475 | £2,178 | £2,013 |
| Admission Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £12,767 | £21,354 | £26,418 | £35,532 | £41,203 | £45,042 | £44,725 | £41,902 | £36,596 | £29,600 | £21,378 | £10,863 | |
| Personnel Plan | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Salaried Staff | 0% | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 | £23,728 |
| Hourly Staff | 0% | £5,100 | £8,700 | £9,400 | £9,500 | £9,900 | £10,600 | £10,900 | £10,700 | £9,500 | £8,500 | £7,600 | £6,800 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £28,828 | £32,428 | £33,128 | £33,228 | £33,628 | £34,328 | £34,628 | £34,428 | £33,228 | £32,228 | £31,328 | £30,528 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £83,600 | £140,200 | £178,000 | £216,500 | £237,000 | £259,900 | £264,140 | £251,600 | £226,000 | £190,200 | £143,800 | £85,400 | |
| Direct Cost of Sales | £12,767 | £21,354 | £26,418 | £35,532 | £41,203 | £45,042 | £44,725 | £41,902 | £36,596 | £29,600 | £21,378 | £10,863 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £12,767 | £21,354 | £26,418 | £35,532 | £41,203 | £45,042 | £44,725 | £41,902 | £36,596 | £29,600 | £21,378 | £10,863 | |
| Gross Margin | £70,833 | £118,846 | £151,582 | £180,968 | £195,797 | £214,858 | £219,415 | £209,698 | £189,404 | £160,600 | £122,422 | £74,537 | |
| Gross Margin % | 84.73% | 84.77% | 85.16% | 83.59% | 82.61% | 82.67% | 83.07% | 83.35% | 83.81% | 84.44% | 85.13% | 87.28% | |
| Expenses | |||||||||||||
| Payroll | £28,828 | £32,428 | £33,128 | £33,228 | £33,628 | £34,328 | £34,628 | £34,428 | £33,228 | £32,228 | £31,328 | £30,528 | |
| Sales and Marketing and Other Expenses | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | £34,298 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Fees--Credit Card | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | £897 | |
| Fees--Professional | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | £625 | |
| Taxes--Admission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes--Excise | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | £32,628 | |
| Taxes--Property | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | £208 | |
| Utilities | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Insurance | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | £1,875 | |
| Rent | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | |
| Payroll Taxes | 17% | £4,901 | £5,513 | £5,632 | £5,649 | £5,717 | £5,836 | £5,887 | £5,853 | £5,649 | £5,479 | £5,326 | £5,190 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £113,510 | £117,722 | £118,541 | £118,658 | £119,126 | £119,945 | £120,296 | £120,062 | £118,658 | £117,488 | £116,435 | £115,499 | |
| Profit Before Interest and Taxes | (£42,677) | £1,124 | £33,041 | £62,310 | £76,671 | £94,913 | £99,119 | £89,636 | £70,746 | £43,112 | £5,987 | (£40,962) | |
| EBITDA | (£42,677) | £1,124 | £33,041 | £62,310 | £76,671 | £94,913 | £99,119 | £89,636 | £70,746 | £43,112 | £5,987 | (£40,962) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£12,803) | £281 | £8,260 | £15,578 | £19,168 | £23,728 | £24,780 | £22,409 | £17,687 | £10,778 | £1,497 | (£10,240) | |
| Net Profit | (£29,874) | £843 | £24,781 | £46,733 | £57,503 | £71,185 | £74,339 | £67,227 | £53,060 | £32,334 | £4,490 | (£30,721) | |
| Net Profit/Sales | -35.73% | 0.60% | 13.92% | 21.59% | 24.26% | 27.39% | 28.14% | 26.72% | 23.48% | 17.00% | 3.12% | -35.97% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £75,240 | £126,180 | £160,200 | £194,850 | £213,300 | £233,910 | £237,726 | £226,440 | £203,400 | £171,180 | £129,420 | £76,860 | |
| Cash from Receivables | £0 | £279 | £8,549 | £14,146 | £17,928 | £21,718 | £23,776 | £26,004 | £26,372 | £25,075 | £22,481 | £18,865 | |
| Subtotal Cash from Operations | £75,240 | £126,459 | £168,749 | £208,996 | £231,228 | £255,628 | £261,502 | £252,444 | £229,772 | £196,255 | £151,901 | £95,725 | |
| 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 | £75,240 | £126,459 | £168,749 | £208,996 | £231,228 | £255,628 | £261,502 | £252,444 | £229,772 | £196,255 | £151,901 | £95,725 | |
| Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £28,828 | £32,428 | £33,128 | £33,228 | £33,628 | £34,328 | £34,628 | £34,428 | £33,228 | £32,228 | £31,328 | £30,528 | |
| Bill Payments | £3,040 | £92,029 | £116,684 | £126,358 | £146,749 | £152,323 | £158,484 | £154,558 | £146,407 | £133,345 | £117,309 | £98,130 | |
| Subtotal Spent on Operations | £31,868 | £124,457 | £149,812 | £159,586 | £180,377 | £186,651 | £193,112 | £188,986 | £179,635 | £165,573 | £148,637 | £128,658 | |
| 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 | £31,868 | £124,457 | £149,812 | £159,586 | £180,377 | £186,651 | £193,112 | £188,986 | £179,635 | £165,573 | £148,637 | £128,658 | |
| Net Cash Flow | £43,372 | £2,002 | £18,937 | £49,410 | £50,851 | £68,977 | £68,391 | £63,458 | £50,137 | £30,682 | £3,264 | (£32,933) | |
| Cash Balance | £118,372 | £120,374 | £139,311 | £188,720 | £239,571 | £308,548 | £376,939 | £440,397 | £490,534 | £521,216 | £524,480 | £491,547 | |
| Pro Forma Balance Sheet | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £75,000 | £118,372 | £120,374 | £139,311 | £188,720 | £239,571 | £308,548 | £376,939 | £440,397 | £490,534 | £521,216 | £524,480 | £491,547 |
| Accounts Receivable | £0 | £8,360 | £22,101 | £31,353 | £38,857 | £44,628 | £48,900 | £51,538 | £50,694 | £46,921 | £40,867 | £32,766 | £22,441 |
| Inventory | £7,500 | £14,044 | £23,489 | £29,060 | £39,085 | £45,323 | £49,546 | £49,198 | £46,092 | £40,256 | £32,560 | £23,516 | £12,653 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £82,500 | £140,776 | £165,965 | £199,723 | £266,662 | £329,523 | £406,994 | £477,674 | £537,183 | £577,711 | £594,643 | £580,762 | £526,640 |
| 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 | £82,500 | £140,776 | £165,965 | £199,723 | £266,662 | £329,523 | £406,994 | £477,674 | £537,183 | £577,711 | £594,643 | £580,762 | £526,640 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £88,150 | £112,495 | £121,473 | £141,679 | £147,036 | £153,323 | £149,663 | £141,945 | £129,413 | £114,011 | £95,639 | £72,239 |
| 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 | £0 | £88,150 | £112,495 | £121,473 | £141,679 | £147,036 | £153,323 | £149,663 | £141,945 | £129,413 | £114,011 | £95,639 | £72,239 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £88,150 | £112,495 | £121,473 | £141,679 | £147,036 | £153,323 | £149,663 | £141,945 | £129,413 | £114,011 | £95,639 | £72,239 |
| Paid-in Capital | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 | £567,750 |
| Retained Earnings | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) | (£485,250) |
| Earnings | £0 | (£29,874) | (£29,031) | (£4,250) | £42,483 | £99,986 | £171,171 | £245,511 | £312,738 | £365,798 | £398,132 | £402,622 | £371,901 |
| Total Capital | £82,500 | £52,626 | £53,469 | £78,250 | £124,983 | £182,486 | £253,671 | £328,011 | £395,238 | £448,298 | £480,632 | £485,122 | £454,401 |
| Total Liabilities and Capital | £82,500 | £140,776 | £165,965 | £199,723 | £266,662 | £329,523 | £406,994 | £477,674 | £537,183 | £577,711 | £594,643 | £580,762 | £526,640 |
| Net Worth | £82,500 | £52,626 | £53,469 | £78,250 | £124,983 | £182,486 | £253,671 | £328,011 | £395,238 | £448,298 | £480,632 | £485,122 | £454,401 |