| 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 | ||
| Unit Sales | |||||||||||||
| Lasertag | 0% | 6,400 | 5,319 | 6,054 | 6,693 | 6,134 | 5,194 | 4,837 | 4,962 | 5,815 | 6,535 | 6,715 | 6,876 |
| Video Games | 0% | 8,345 | 8,973 | 8,076 | 7,806 | 7,537 | 7,178 | 6,550 | 5,832 | 5,832 | 6,999 | 8,076 | 8,076 |
| Makoto | 0% | 1,393 | 1,625 | 1,858 | 1,858 | 1,672 | 1,533 | 1,393 | 1,161 | 1,161 | 1,625 | 1,858 | 2,090 |
| Soft Drinks and Snacks | 0% | 656 | 547 | 609 | 662 | 550 | 591 | 537 | 508 | 518 | 590 | 651 | 667 |
| Souvenirs | 0% | 5 | 6 | 7 | 8 | 7 | 5 | 3 | 2 | 2 | 3 | 5 | 7 |
| Total Unit Sales | 16,799 | 16,470 | 16,604 | 17,027 | 15,900 | 14,501 | 13,320 | 12,465 | 13,328 | 15,752 | 17,305 | 17,716 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Lasertag | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Video Games | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | |
| Makoto | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | |
| Soft Drinks and Snacks | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | |
| Souvenirs | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | |
| Sales | |||||||||||||
| Lasertag | £32,000 | £26,595 | £30,270 | £33,465 | £30,670 | £25,970 | £24,185 | £24,810 | £29,075 | £32,675 | £33,575 | £34,380 | |
| Video Games | £4,173 | £4,487 | £4,038 | £3,903 | £3,769 | £3,589 | £3,275 | £2,916 | £2,916 | £3,500 | £4,038 | £4,038 | |
| Makoto | £1,393 | £1,625 | £1,858 | £1,858 | £1,672 | £1,533 | £1,393 | £1,161 | £1,161 | £1,625 | £1,858 | £2,090 | |
| Soft Drinks and Snacks | £492 | £410 | £457 | £497 | £413 | £443 | £403 | £381 | £389 | £443 | £488 | £500 | |
| Souvenirs | £48 | £57 | £67 | £76 | £67 | £48 | £29 | £19 | £19 | £29 | £48 | £67 | |
| Total Sales | £38,105 | £33,174 | £36,689 | £39,799 | £36,590 | £31,583 | £29,284 | £29,287 | £33,560 | £38,271 | £40,007 | £41,075 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Lasertag | 10.00% | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 |
| Video Games | 50.00% | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 |
| Makoto | 10.00% | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 |
| Soft Drinks and Snacks | 50.00% | £0.38 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 |
| Souvenirs | 75.00% | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 |
| Direct Cost of Sales | |||||||||||||
| Lasertag | £3,200 | £2,660 | £3,027 | £3,347 | £3,067 | £2,597 | £2,419 | £2,481 | £2,908 | £3,268 | £3,358 | £3,438 | |
| Video Games | £2,086 | £2,243 | £2,019 | £1,952 | £1,884 | £1,795 | £1,638 | £1,458 | £1,458 | £1,750 | £2,019 | £2,019 | |
| Makoto | £139 | £163 | £186 | £186 | £167 | £153 | £139 | £116 | £116 | £163 | £186 | £209 | |
| Soft Drinks and Snacks | £246 | £41 | £46 | £50 | £41 | £44 | £40 | £38 | £39 | £44 | £49 | £50 | |
| Souvenirs | £36 | £43 | £50 | £57 | £50 | £36 | £21 | £14 | £14 | £21 | £36 | £50 | |
| Subtotal Direct Cost of Sales | £5,707 | £5,149 | £5,327 | £5,590 | £5,210 | £4,625 | £4,257 | £4,107 | £4,535 | £5,245 | £5,647 | £5,766 | |
| 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 | ||
| General Manager | 50% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Shift Manager | 0% | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 |
| Laser Tag attendants | 6% | £1,920 | £1,596 | £1,816 | £2,008 | £1,840 | £1,558 | £1,451 | £1,489 | £1,745 | £1,961 | £2,015 | £2,063 |
| Arcade attendants | 43% | £1,794 | £1,929 | £1,736 | £1,678 | £1,620 | £1,543 | £1,408 | £1,254 | £1,254 | £1,505 | £1,736 | £1,736 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £6,657 | £6,468 | £6,496 | £6,629 | £6,404 | £6,044 | £5,802 | £5,685 | £5,941 | £6,408 | £6,694 | £6,742 | |
| 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 | £38,105 | £33,174 | £36,689 | £39,799 | £36,590 | £31,583 | £29,284 | £29,287 | £33,560 | £38,271 | £40,007 | £41,075 | |
| Direct Cost of Sales | £5,707 | £5,149 | £5,327 | £5,590 | £5,210 | £4,625 | £4,257 | £4,107 | £4,535 | £5,245 | £5,647 | £5,766 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £5,707 | £5,149 | £5,327 | £5,590 | £5,210 | £4,625 | £4,257 | £4,107 | £4,535 | £5,245 | £5,647 | £5,766 | |
| Gross Margin | £32,398 | £28,025 | £31,362 | £34,208 | £31,380 | £26,958 | £25,027 | £25,180 | £29,025 | £33,025 | £34,360 | £35,309 | |
| Gross Margin % | 85.02% | 84.48% | 85.48% | 85.95% | 85.76% | 85.36% | 85.46% | 85.98% | 86.49% | 86.29% | 85.89% | 85.96% | |
| Expenses | |||||||||||||
| Payroll | £6,657 | £6,468 | £6,496 | £6,629 | £6,404 | £6,044 | £5,802 | £5,685 | £5,941 | £6,408 | £6,694 | £6,742 | |
| Marketing/Promotion | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Depreciation | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | |
| Rent | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| Utilities | £410 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | |
| Insurance | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | |
| Professional Fees | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Telephone | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Supplies | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Bank & Credit Card Fees | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | |
| New Game Software | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Miscellaneous | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Total Operating Expenses | £19,449 | £19,479 | £19,507 | £19,641 | £19,415 | £19,056 | £18,814 | £18,697 | £18,953 | £19,420 | £19,705 | £19,754 | |
| Profit Before Interest and Taxes | £12,949 | £8,545 | £11,855 | £14,567 | £11,965 | £7,902 | £6,213 | £6,482 | £10,072 | £13,605 | £14,655 | £15,555 | |
| EBITDA | £13,439 | £9,035 | £12,344 | £15,057 | £12,454 | £8,392 | £6,703 | £6,972 | £10,561 | £14,095 | £15,144 | £16,045 | |
| Interest Expense | £768 | £759 | £750 | £741 | £731 | £722 | £713 | £704 | £694 | £685 | £676 | £667 | |
| Taxes Incurred | £3,654 | £2,336 | £3,331 | £4,148 | £3,370 | £2,154 | £1,650 | £1,734 | £2,813 | £3,876 | £4,194 | £4,467 | |
| Net Profit | £8,526 | £5,450 | £7,773 | £9,679 | £7,863 | £5,026 | £3,850 | £4,045 | £6,564 | £9,044 | £9,785 | £10,422 | |
| Net Profit/Sales | 22.38% | 16.43% | 21.19% | 24.32% | 21.49% | 15.91% | 13.15% | 13.81% | 19.56% | 23.63% | 24.46% | 25.37% | |
| 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 | £28,579 | £24,880 | £27,517 | £29,849 | £27,442 | £23,687 | £21,963 | £21,965 | £25,170 | £28,703 | £30,005 | £30,806 | |
| Cash from Receivables | £318 | £9,485 | £8,323 | £9,198 | £9,923 | £9,106 | £7,877 | £7,321 | £7,357 | £8,429 | £9,582 | £10,011 | |
| Subtotal Cash from Operations | £28,896 | £34,365 | £35,840 | £39,047 | £37,365 | £32,793 | £29,840 | £29,286 | £32,527 | £37,132 | £39,587 | £40,817 | |
| 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 | £28,896 | £34,365 | £35,840 | £39,047 | £37,365 | £32,793 | £29,840 | £29,286 | £32,527 | £37,132 | £39,587 | £40,817 | |
| 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 | £6,657 | £6,468 | £6,496 | £6,629 | £6,404 | £6,044 | £5,802 | £5,685 | £5,941 | £6,408 | £6,694 | £6,742 | |
| Bill Payments | £843 | £25,125 | £20,538 | £22,057 | £23,083 | £21,579 | £19,705 | £18,959 | £19,052 | £20,841 | £22,702 | £23,247 | |
| Subtotal Spent on Operations | £7,500 | £31,593 | £27,034 | £28,686 | £29,487 | £27,623 | £25,507 | £24,645 | £24,993 | £27,250 | £29,396 | £29,989 | |
| 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 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | |
| 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 | £8,510 | £32,603 | £28,044 | £29,696 | £30,497 | £28,633 | £26,517 | £25,655 | £26,003 | £28,260 | £30,406 | £30,999 | |
| Net Cash Flow | £20,386 | £1,762 | £7,796 | £9,351 | £6,868 | £4,159 | £3,323 | £3,632 | £6,524 | £8,872 | £9,181 | £9,818 | |
| Cash Balance | £30,386 | £32,148 | £39,944 | £49,295 | £56,164 | £60,323 | £63,646 | £67,277 | £73,801 | £82,674 | £91,855 | £101,672 | |
| 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 | £10,000 | £30,386 | £32,148 | £39,944 | £49,295 | £56,164 | £60,323 | £63,646 | £67,277 | £73,801 | £82,674 | £91,855 | £101,672 |
| Accounts Receivable | £0 | £9,209 | £8,017 | £8,867 | £9,618 | £8,842 | £7,632 | £7,077 | £7,078 | £8,110 | £9,249 | £9,668 | £9,926 |
| Inventory | £0 | £2,854 | £2,575 | £2,664 | £2,795 | £2,605 | £2,312 | £2,128 | £2,054 | £2,267 | £2,623 | £2,823 | £2,883 |
| Other Current Assets | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 |
| Total Current Assets | £14,480 | £46,929 | £47,220 | £55,955 | £66,189 | £72,091 | £74,748 | £77,331 | £80,889 | £88,659 | £99,025 | £108,826 | £118,961 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 |
| Accumulated Depreciation | £0 | £490 | £979 | £1,469 | £1,958 | £2,448 | £2,938 | £3,427 | £3,917 | £4,406 | £4,896 | £5,385 | £5,875 |
| Total Long-term Assets | £47,267 | £46,777 | £46,288 | £45,798 | £45,309 | £44,819 | £44,329 | £43,840 | £43,350 | £42,861 | £42,371 | £41,882 | £41,392 |
| Total Assets | £61,747 | £93,706 | £93,508 | £101,753 | £111,497 | £116,910 | £119,077 | £121,171 | £124,239 | £131,520 | £141,396 | £150,708 | £160,353 |
| 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 | £24,443 | £19,804 | £21,286 | £22,362 | £20,921 | £19,073 | £18,326 | £18,359 | £20,085 | £21,928 | £22,464 | £22,698 |
| 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 | £24,443 | £19,804 | £21,286 | £22,362 | £20,921 | £19,073 | £18,326 | £18,359 | £20,085 | £21,928 | £22,464 | £22,698 |
| Long-term Liabilities | £84,844 | £83,834 | £82,824 | £81,814 | £80,804 | £79,794 | £78,784 | £77,774 | £76,764 | £75,754 | £74,744 | £73,734 | £72,724 |
| Total Liabilities | £84,844 | £108,277 | £102,628 | £103,100 | £103,166 | £100,715 | £97,857 | £96,100 | £95,123 | £95,839 | £96,672 | £96,198 | £95,422 |
| Paid-in Capital | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 |
| Retained Earnings | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) |
| Earnings | £0 | £8,526 | £13,977 | £21,750 | £31,429 | £39,292 | £44,318 | £48,168 | £52,213 | £58,777 | £67,821 | £77,606 | £88,028 |
| Total Capital | (£23,097) | (£14,571) | (£9,120) | (£1,347) | £8,332 | £16,195 | £21,221 | £25,071 | £29,116 | £35,680 | £44,724 | £54,509 | £64,931 |
| Total Liabilities and Capital | £61,747 | £93,706 | £93,508 | £101,753 | £111,497 | £116,910 | £119,077 | £121,171 | £124,239 | £131,520 | £141,396 | £150,708 | £160,353 |
| Net Worth | (£23,097) | (£14,571) | (£9,120) | (£1,347) | £8,332 | £16,195 | £21,221 | £25,071 | £29,116 | £35,680 | £44,724 | £54,509 | £64,931 |
| 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 | ||
| Unit Sales | |||||||||||||
| Lasertag | 0% | 6,400 | 5,319 | 6,054 | 6,693 | 6,134 | 5,194 | 4,837 | 4,962 | 5,815 | 6,535 | 6,715 | 6,876 |
| Video Games | 0% | 8,345 | 8,973 | 8,076 | 7,806 | 7,537 | 7,178 | 6,550 | 5,832 | 5,832 | 6,999 | 8,076 | 8,076 |
| Makoto | 0% | 1,393 | 1,625 | 1,858 | 1,858 | 1,672 | 1,533 | 1,393 | 1,161 | 1,161 | 1,625 | 1,858 | 2,090 |
| Soft Drinks and Snacks | 0% | 656 | 547 | 609 | 662 | 550 | 591 | 537 | 508 | 518 | 590 | 651 | 667 |
| Souvenirs | 0% | 5 | 6 | 7 | 8 | 7 | 5 | 3 | 2 | 2 | 3 | 5 | 7 |
| Total Unit Sales | 16,799 | 16,470 | 16,604 | 17,027 | 15,900 | 14,501 | 13,320 | 12,465 | 13,328 | 15,752 | 17,305 | 17,716 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Lasertag | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Video Games | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | |
| Makoto | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | |
| Soft Drinks and Snacks | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | £0.75 | |
| Souvenirs | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | £9.50 | |
| Sales | |||||||||||||
| Lasertag | £32,000 | £26,595 | £30,270 | £33,465 | £30,670 | £25,970 | £24,185 | £24,810 | £29,075 | £32,675 | £33,575 | £34,380 | |
| Video Games | £4,173 | £4,487 | £4,038 | £3,903 | £3,769 | £3,589 | £3,275 | £2,916 | £2,916 | £3,500 | £4,038 | £4,038 | |
| Makoto | £1,393 | £1,625 | £1,858 | £1,858 | £1,672 | £1,533 | £1,393 | £1,161 | £1,161 | £1,625 | £1,858 | £2,090 | |
| Soft Drinks and Snacks | £492 | £410 | £457 | £497 | £413 | £443 | £403 | £381 | £389 | £443 | £488 | £500 | |
| Souvenirs | £48 | £57 | £67 | £76 | £67 | £48 | £29 | £19 | £19 | £29 | £48 | £67 | |
| Total Sales | £38,105 | £33,174 | £36,689 | £39,799 | £36,590 | £31,583 | £29,284 | £29,287 | £33,560 | £38,271 | £40,007 | £41,075 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Lasertag | 10.00% | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 | £0.50 |
| Video Games | 50.00% | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 | £0.25 |
| Makoto | 10.00% | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 | £0.10 |
| Soft Drinks and Snacks | 50.00% | £0.38 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 | £0.08 |
| Souvenirs | 75.00% | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 | £7.13 |
| Direct Cost of Sales | |||||||||||||
| Lasertag | £3,200 | £2,660 | £3,027 | £3,347 | £3,067 | £2,597 | £2,419 | £2,481 | £2,908 | £3,268 | £3,358 | £3,438 | |
| Video Games | £2,086 | £2,243 | £2,019 | £1,952 | £1,884 | £1,795 | £1,638 | £1,458 | £1,458 | £1,750 | £2,019 | £2,019 | |
| Makoto | £139 | £163 | £186 | £186 | £167 | £153 | £139 | £116 | £116 | £163 | £186 | £209 | |
| Soft Drinks and Snacks | £246 | £41 | £46 | £50 | £41 | £44 | £40 | £38 | £39 | £44 | £49 | £50 | |
| Souvenirs | £36 | £43 | £50 | £57 | £50 | £36 | £21 | £14 | £14 | £21 | £36 | £50 | |
| Subtotal Direct Cost of Sales | £5,707 | £5,149 | £5,327 | £5,590 | £5,210 | £4,625 | £4,257 | £4,107 | £4,535 | £5,245 | £5,647 | £5,766 | |
| 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 | ||
| General Manager | 50% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Shift Manager | 0% | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 | £1,443 |
| Laser Tag attendants | 6% | £1,920 | £1,596 | £1,816 | £2,008 | £1,840 | £1,558 | £1,451 | £1,489 | £1,745 | £1,961 | £2,015 | £2,063 |
| Arcade attendants | 43% | £1,794 | £1,929 | £1,736 | £1,678 | £1,620 | £1,543 | £1,408 | £1,254 | £1,254 | £1,505 | £1,736 | £1,736 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £6,657 | £6,468 | £6,496 | £6,629 | £6,404 | £6,044 | £5,802 | £5,685 | £5,941 | £6,408 | £6,694 | £6,742 | |
| 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 | £38,105 | £33,174 | £36,689 | £39,799 | £36,590 | £31,583 | £29,284 | £29,287 | £33,560 | £38,271 | £40,007 | £41,075 | |
| Direct Cost of Sales | £5,707 | £5,149 | £5,327 | £5,590 | £5,210 | £4,625 | £4,257 | £4,107 | £4,535 | £5,245 | £5,647 | £5,766 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £5,707 | £5,149 | £5,327 | £5,590 | £5,210 | £4,625 | £4,257 | £4,107 | £4,535 | £5,245 | £5,647 | £5,766 | |
| Gross Margin | £32,398 | £28,025 | £31,362 | £34,208 | £31,380 | £26,958 | £25,027 | £25,180 | £29,025 | £33,025 | £34,360 | £35,309 | |
| Gross Margin % | 85.02% | 84.48% | 85.48% | 85.95% | 85.76% | 85.36% | 85.46% | 85.98% | 86.49% | 86.29% | 85.89% | 85.96% | |
| Expenses | |||||||||||||
| Payroll | £6,657 | £6,468 | £6,496 | £6,629 | £6,404 | £6,044 | £5,802 | £5,685 | £5,941 | £6,408 | £6,694 | £6,742 | |
| Marketing/Promotion | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Depreciation | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | £490 | |
| Rent | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| Utilities | £410 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | £630 | |
| Insurance | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | £912 | |
| Professional Fees | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Telephone | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Supplies | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Bank & Credit Card Fees | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | £110 | |
| New Game Software | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Miscellaneous | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Total Operating Expenses | £19,449 | £19,479 | £19,507 | £19,641 | £19,415 | £19,056 | £18,814 | £18,697 | £18,953 | £19,420 | £19,705 | £19,754 | |
| Profit Before Interest and Taxes | £12,949 | £8,545 | £11,855 | £14,567 | £11,965 | £7,902 | £6,213 | £6,482 | £10,072 | £13,605 | £14,655 | £15,555 | |
| EBITDA | £13,439 | £9,035 | £12,344 | £15,057 | £12,454 | £8,392 | £6,703 | £6,972 | £10,561 | £14,095 | £15,144 | £16,045 | |
| Interest Expense | £768 | £759 | £750 | £741 | £731 | £722 | £713 | £704 | £694 | £685 | £676 | £667 | |
| Taxes Incurred | £3,654 | £2,336 | £3,331 | £4,148 | £3,370 | £2,154 | £1,650 | £1,734 | £2,813 | £3,876 | £4,194 | £4,467 | |
| Net Profit | £8,526 | £5,450 | £7,773 | £9,679 | £7,863 | £5,026 | £3,850 | £4,045 | £6,564 | £9,044 | £9,785 | £10,422 | |
| Net Profit/Sales | 22.38% | 16.43% | 21.19% | 24.32% | 21.49% | 15.91% | 13.15% | 13.81% | 19.56% | 23.63% | 24.46% | 25.37% | |
| 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 | £28,579 | £24,880 | £27,517 | £29,849 | £27,442 | £23,687 | £21,963 | £21,965 | £25,170 | £28,703 | £30,005 | £30,806 | |
| Cash from Receivables | £318 | £9,485 | £8,323 | £9,198 | £9,923 | £9,106 | £7,877 | £7,321 | £7,357 | £8,429 | £9,582 | £10,011 | |
| Subtotal Cash from Operations | £28,896 | £34,365 | £35,840 | £39,047 | £37,365 | £32,793 | £29,840 | £29,286 | £32,527 | £37,132 | £39,587 | £40,817 | |
| 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 | £28,896 | £34,365 | £35,840 | £39,047 | £37,365 | £32,793 | £29,840 | £29,286 | £32,527 | £37,132 | £39,587 | £40,817 | |
| 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 | £6,657 | £6,468 | £6,496 | £6,629 | £6,404 | £6,044 | £5,802 | £5,685 | £5,941 | £6,408 | £6,694 | £6,742 | |
| Bill Payments | £843 | £25,125 | £20,538 | £22,057 | £23,083 | £21,579 | £19,705 | £18,959 | £19,052 | £20,841 | £22,702 | £23,247 | |
| Subtotal Spent on Operations | £7,500 | £31,593 | £27,034 | £28,686 | £29,487 | £27,623 | £25,507 | £24,645 | £24,993 | £27,250 | £29,396 | £29,989 | |
| 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 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | £1,010 | |
| 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 | £8,510 | £32,603 | £28,044 | £29,696 | £30,497 | £28,633 | £26,517 | £25,655 | £26,003 | £28,260 | £30,406 | £30,999 | |
| Net Cash Flow | £20,386 | £1,762 | £7,796 | £9,351 | £6,868 | £4,159 | £3,323 | £3,632 | £6,524 | £8,872 | £9,181 | £9,818 | |
| Cash Balance | £30,386 | £32,148 | £39,944 | £49,295 | £56,164 | £60,323 | £63,646 | £67,277 | £73,801 | £82,674 | £91,855 | £101,672 | |
| 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 | £10,000 | £30,386 | £32,148 | £39,944 | £49,295 | £56,164 | £60,323 | £63,646 | £67,277 | £73,801 | £82,674 | £91,855 | £101,672 |
| Accounts Receivable | £0 | £9,209 | £8,017 | £8,867 | £9,618 | £8,842 | £7,632 | £7,077 | £7,078 | £8,110 | £9,249 | £9,668 | £9,926 |
| Inventory | £0 | £2,854 | £2,575 | £2,664 | £2,795 | £2,605 | £2,312 | £2,128 | £2,054 | £2,267 | £2,623 | £2,823 | £2,883 |
| Other Current Assets | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 | £4,480 |
| Total Current Assets | £14,480 | £46,929 | £47,220 | £55,955 | £66,189 | £72,091 | £74,748 | £77,331 | £80,889 | £88,659 | £99,025 | £108,826 | £118,961 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 | £47,267 |
| Accumulated Depreciation | £0 | £490 | £979 | £1,469 | £1,958 | £2,448 | £2,938 | £3,427 | £3,917 | £4,406 | £4,896 | £5,385 | £5,875 |
| Total Long-term Assets | £47,267 | £46,777 | £46,288 | £45,798 | £45,309 | £44,819 | £44,329 | £43,840 | £43,350 | £42,861 | £42,371 | £41,882 | £41,392 |
| Total Assets | £61,747 | £93,706 | £93,508 | £101,753 | £111,497 | £116,910 | £119,077 | £121,171 | £124,239 | £131,520 | £141,396 | £150,708 | £160,353 |
| 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 | £24,443 | £19,804 | £21,286 | £22,362 | £20,921 | £19,073 | £18,326 | £18,359 | £20,085 | £21,928 | £22,464 | £22,698 |
| 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 | £24,443 | £19,804 | £21,286 | £22,362 | £20,921 | £19,073 | £18,326 | £18,359 | £20,085 | £21,928 | £22,464 | £22,698 |
| Long-term Liabilities | £84,844 | £83,834 | £82,824 | £81,814 | £80,804 | £79,794 | £78,784 | £77,774 | £76,764 | £75,754 | £74,744 | £73,734 | £72,724 |
| Total Liabilities | £84,844 | £108,277 | £102,628 | £103,100 | £103,166 | £100,715 | £97,857 | £96,100 | £95,123 | £95,839 | £96,672 | £96,198 | £95,422 |
| Paid-in Capital | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 |
| Retained Earnings | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) | (£50,097) |
| Earnings | £0 | £8,526 | £13,977 | £21,750 | £31,429 | £39,292 | £44,318 | £48,168 | £52,213 | £58,777 | £67,821 | £77,606 | £88,028 |
| Total Capital | (£23,097) | (£14,571) | (£9,120) | (£1,347) | £8,332 | £16,195 | £21,221 | £25,071 | £29,116 | £35,680 | £44,724 | £54,509 | £64,931 |
| Total Liabilities and Capital | £61,747 | £93,706 | £93,508 | £101,753 | £111,497 | £116,910 | £119,077 | £121,171 | £124,239 | £131,520 | £141,396 | £150,708 | £160,353 |
| Net Worth | (£23,097) | (£14,571) | (£9,120) | (£1,347) | £8,332 | £16,195 | £21,221 | £25,071 | £29,116 | £35,680 | £44,724 | £54,509 | £64,931 |