| 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 | |||||||||||||
| Admission | 0% | 0 | 0 | 0 | 1,000 | 1,000 | 1,500 | 1,800 | 2,000 | 1,600 | 1,400 | 1,200 | 1,000 |
| Rentals | 0% | 0 | 0 | 0 | 750 | 750 | 1,250 | 1,500 | 1,700 | 1,375 | 1,150 | 900 | 750 |
| Paint Balls | 0% | 0 | 0 | 0 | 2,000 | 2,000 | 3,000 | 3,800 | 4,000 | 3,000 | 2,500 | 2,200 | 2,000 |
| Food | 0% | 0 | 0 | 0 | 500 | 500 | 760 | 760 | 860 | 950 | 900 | 650 | 600 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 0 | 0 | 0 | 4,250 | 4,250 | 6,510 | 7,860 | 8,560 | 6,925 | 5,950 | 4,950 | 4,350 | |
| 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 | |
| Admission | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | |
| Rentals | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Paint Balls | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | |
| Food | £10.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Admission | £0 | £0 | £0 | £12,000 | £12,000 | £18,000 | £21,600 | £24,000 | £19,200 | £16,800 | £14,400 | £12,000 | |
| Rentals | £0 | £0 | £0 | £11,250 | £11,250 | £18,750 | £22,500 | £25,500 | £20,625 | £17,250 | £13,500 | £11,250 | |
| Paint Balls | £0 | £0 | £0 | £50,000 | £50,000 | £75,000 | £95,000 | £100,000 | £75,000 | £62,500 | £55,000 | £50,000 | |
| Food | £0 | £0 | £0 | £2,500 | £2,500 | £3,800 | £3,800 | £4,300 | £4,750 | £4,500 | £3,250 | £3,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| 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 | |
| Admission | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Rentals | 0.00% | £0.00 | £0.00 | £0.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 |
| Paint Balls | 0.00% | £0.00 | £0.00 | £0.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Food | 0.00% | £0.00 | £0.00 | £0.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Admission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rentals | £0 | £0 | £0 | £750 | £750 | £1,250 | £1,500 | £1,700 | £1,375 | £1,150 | £900 | £750 | |
| Paint Balls | £0 | £0 | £0 | £6,000 | £6,000 | £9,000 | £11,400 | £12,000 | £9,000 | £7,500 | £6,600 | £6,000 | |
| Food | £0 | £0 | £0 | £500 | £500 | £760 | £760 | £860 | £950 | £900 | £650 | £600 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £7,250 | £7,250 | £11,010 | £13,660 | £14,560 | £11,325 | £9,550 | £8,150 | £7,350 | |
| 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 | ||
| Manager | 0% | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Accountant | 0% | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Assistant Manager | 0% | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Facility Maintenance | 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 |
| Counter Staff | 0% | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Concession Person | 0% | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Referee/Safety Inspectors | 0% | £0 | £0 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £7,500 | £11,000 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| Direct Cost of Sales | £0 | £0 | £0 | £7,250 | £7,250 | £11,010 | £13,660 | £14,560 | £11,325 | £9,550 | £8,150 | £7,350 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £7,250 | £7,250 | £11,010 | £13,660 | £14,560 | £11,325 | £9,550 | £8,150 | £7,350 | |
| Gross Margin | £0 | £0 | £0 | £68,500 | £68,500 | £104,540 | £129,240 | £139,240 | £108,250 | £91,500 | £78,000 | £68,900 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 90.43% | 90.43% | 90.47% | 90.44% | 90.53% | 90.53% | 90.55% | 90.54% | 90.36% | |
| Expenses | |||||||||||||
| Payroll | £7,500 | £11,000 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £20,000 | £50,000 | £50,000 | £45,000 | £45,000 | £45,000 | £45,000 | £23,000 | £22,000 | £21,000 | |
| Depreciation | £0 | £0 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £1,000 | £1,000 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Insurance | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Payroll Taxes | 15% | £1,125 | £1,650 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £15,625 | £20,650 | £60,225 | £91,025 | £91,025 | £86,025 | £86,025 | £86,025 | £86,025 | £64,025 | £63,025 | £62,025 | |
| Profit Before Interest and Taxes | (£15,625) | (£20,650) | (£60,225) | (£22,525) | (£22,525) | £18,515 | £43,215 | £53,215 | £22,225 | £27,475 | £14,975 | £6,875 | |
| EBITDA | (£15,625) | (£20,650) | (£59,625) | (£21,925) | (£21,925) | £19,115 | £43,815 | £53,815 | £22,825 | £28,075 | £15,575 | £7,475 | |
| Interest Expense | £1,237 | £1,224 | £1,211 | £1,198 | £1,185 | £1,172 | £1,159 | £1,146 | £1,133 | £1,120 | £1,107 | £1,094 | |
| Taxes Incurred | (£5,059) | (£6,562) | (£18,431) | (£7,117) | (£7,113) | £5,203 | £12,617 | £15,621 | £6,328 | £7,907 | £4,160 | £1,734 | |
| Net Profit | (£11,803) | (£15,312) | (£43,005) | (£16,606) | (£16,597) | £12,140 | £29,439 | £36,448 | £14,765 | £18,449 | £9,708 | £4,047 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -21.92% | -21.91% | 10.51% | 20.60% | 23.70% | 12.35% | 18.26% | 11.27% | 5.31% | |
| 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 | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| 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 | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| 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 | £7,500 | £11,000 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | |
| Bill Payments | £143 | £4,304 | £4,665 | £16,516 | £63,265 | £64,754 | £79,740 | £88,341 | £89,672 | £72,465 | £52,357 | £46,683 | |
| Subtotal Spent on Operations | £7,643 | £15,304 | £32,165 | £44,016 | £90,765 | £92,254 | £107,240 | £115,841 | £117,172 | £99,965 | £79,857 | £74,183 | |
| 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,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | |
| 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 | £9,206 | £16,866 | £33,727 | £45,579 | £92,327 | £93,816 | £108,803 | £117,404 | £118,734 | £101,528 | £81,420 | £75,745 | |
| Net Cash Flow | (£9,206) | (£16,866) | (£33,727) | £30,171 | (£16,577) | £21,734 | £34,097 | £36,396 | £841 | (£478) | £4,730 | £505 | |
| Cash Balance | £159,594 | £142,728 | £109,001 | £139,172 | £122,595 | £144,329 | £178,426 | £214,822 | £215,663 | £215,185 | £219,915 | £220,420 | |
| 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 | £168,800 | £159,594 | £142,728 | £109,001 | £139,172 | £122,595 | £144,329 | £178,426 | £214,822 | £215,663 | £215,185 | £219,915 | £220,420 |
| Inventory | £9,000 | £9,000 | £9,000 | £9,000 | £7,975 | £7,975 | £12,111 | £15,026 | £16,016 | £12,458 | £10,505 | £8,965 | £8,085 |
| Other Current Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Total Current Assets | £192,800 | £183,594 | £166,728 | £133,001 | £162,147 | £145,570 | £171,440 | £208,452 | £245,838 | £243,120 | £240,690 | £243,880 | £243,505 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £600 | £1,200 | £1,800 | £2,400 | £3,000 | £3,600 | £4,200 | £4,800 | £5,400 | £6,000 |
| Total Long-term Assets | £128,000 | £128,000 | £128,000 | £127,400 | £126,800 | £126,200 | £125,600 | £125,000 | £124,400 | £123,800 | £123,200 | £122,600 | £122,000 |
| Total Assets | £320,800 | £311,594 | £294,728 | £260,401 | £288,947 | £271,770 | £297,040 | £333,452 | £370,238 | £366,920 | £363,890 | £366,480 | £365,505 |
| 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 | £4,160 | £4,168 | £14,408 | £61,123 | £62,105 | £76,798 | £85,333 | £87,234 | £70,714 | £50,797 | £45,242 | £41,782 |
| 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 | £4,160 | £4,168 | £14,408 | £61,123 | £62,105 | £76,798 | £85,333 | £87,234 | £70,714 | £50,797 | £45,242 | £41,782 |
| Long-term Liabilities | £150,000 | £148,438 | £146,875 | £145,313 | £143,750 | £142,188 | £140,625 | £139,063 | £137,500 | £135,938 | £134,375 | £132,813 | £131,250 |
| Total Liabilities | £150,000 | £152,597 | £151,043 | £159,721 | £204,873 | £204,293 | £217,423 | £224,396 | £224,734 | £206,651 | £185,172 | £178,055 | £173,032 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) |
| Earnings | £0 | (£11,803) | (£27,115) | (£70,120) | (£86,726) | (£103,323) | (£91,183) | (£61,744) | (£25,295) | (£10,531) | £7,918 | £17,626 | £21,672 |
| Total Capital | £170,800 | £158,997 | £143,685 | £100,680 | £84,074 | £67,477 | £79,617 | £109,056 | £145,505 | £160,269 | £178,718 | £188,426 | £192,472 |
| Total Liabilities and Capital | £320,800 | £311,594 | £294,728 | £260,401 | £288,947 | £271,770 | £297,040 | £333,452 | £370,238 | £366,920 | £363,890 | £366,480 | £365,505 |
| Net Worth | £170,800 | £158,997 | £143,685 | £100,680 | £84,074 | £67,477 | £79,617 | £109,056 | £145,505 | £160,269 | £178,718 | £188,426 | £192,472 |
| 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 | |||||||||||||
| Admission | 0% | 0 | 0 | 0 | 1,000 | 1,000 | 1,500 | 1,800 | 2,000 | 1,600 | 1,400 | 1,200 | 1,000 |
| Rentals | 0% | 0 | 0 | 0 | 750 | 750 | 1,250 | 1,500 | 1,700 | 1,375 | 1,150 | 900 | 750 |
| Paint Balls | 0% | 0 | 0 | 0 | 2,000 | 2,000 | 3,000 | 3,800 | 4,000 | 3,000 | 2,500 | 2,200 | 2,000 |
| Food | 0% | 0 | 0 | 0 | 500 | 500 | 760 | 760 | 860 | 950 | 900 | 650 | 600 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 0 | 0 | 0 | 4,250 | 4,250 | 6,510 | 7,860 | 8,560 | 6,925 | 5,950 | 4,950 | 4,350 | |
| 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 | |
| Admission | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | |
| Rentals | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | |
| Paint Balls | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | £25.00 | |
| Food | £10.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| Admission | £0 | £0 | £0 | £12,000 | £12,000 | £18,000 | £21,600 | £24,000 | £19,200 | £16,800 | £14,400 | £12,000 | |
| Rentals | £0 | £0 | £0 | £11,250 | £11,250 | £18,750 | £22,500 | £25,500 | £20,625 | £17,250 | £13,500 | £11,250 | |
| Paint Balls | £0 | £0 | £0 | £50,000 | £50,000 | £75,000 | £95,000 | £100,000 | £75,000 | £62,500 | £55,000 | £50,000 | |
| Food | £0 | £0 | £0 | £2,500 | £2,500 | £3,800 | £3,800 | £4,300 | £4,750 | £4,500 | £3,250 | £3,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| 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 | |
| Admission | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Rentals | 0.00% | £0.00 | £0.00 | £0.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 |
| Paint Balls | 0.00% | £0.00 | £0.00 | £0.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| Food | 0.00% | £0.00 | £0.00 | £0.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 | £1.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Admission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rentals | £0 | £0 | £0 | £750 | £750 | £1,250 | £1,500 | £1,700 | £1,375 | £1,150 | £900 | £750 | |
| Paint Balls | £0 | £0 | £0 | £6,000 | £6,000 | £9,000 | £11,400 | £12,000 | £9,000 | £7,500 | £6,600 | £6,000 | |
| Food | £0 | £0 | £0 | £500 | £500 | £760 | £760 | £860 | £950 | £900 | £650 | £600 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £7,250 | £7,250 | £11,010 | £13,660 | £14,560 | £11,325 | £9,550 | £8,150 | £7,350 | |
| 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 | ||
| Manager | 0% | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Accountant | 0% | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Assistant Manager | 0% | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Facility Maintenance | 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 |
| Counter Staff | 0% | £0 | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 |
| Concession Person | 0% | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Referee/Safety Inspectors | 0% | £0 | £0 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £7,500 | £11,000 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | |
| 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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| Direct Cost of Sales | £0 | £0 | £0 | £7,250 | £7,250 | £11,010 | £13,660 | £14,560 | £11,325 | £9,550 | £8,150 | £7,350 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £7,250 | £7,250 | £11,010 | £13,660 | £14,560 | £11,325 | £9,550 | £8,150 | £7,350 | |
| Gross Margin | £0 | £0 | £0 | £68,500 | £68,500 | £104,540 | £129,240 | £139,240 | £108,250 | £91,500 | £78,000 | £68,900 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 90.43% | 90.43% | 90.47% | 90.44% | 90.53% | 90.53% | 90.55% | 90.54% | 90.36% | |
| Expenses | |||||||||||||
| Payroll | £7,500 | £11,000 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £20,000 | £50,000 | £50,000 | £45,000 | £45,000 | £45,000 | £45,000 | £23,000 | £22,000 | £21,000 | |
| Depreciation | £0 | £0 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £1,000 | £1,000 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | |
| Insurance | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Payroll Taxes | 15% | £1,125 | £1,650 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 | £4,125 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £15,625 | £20,650 | £60,225 | £91,025 | £91,025 | £86,025 | £86,025 | £86,025 | £86,025 | £64,025 | £63,025 | £62,025 | |
| Profit Before Interest and Taxes | (£15,625) | (£20,650) | (£60,225) | (£22,525) | (£22,525) | £18,515 | £43,215 | £53,215 | £22,225 | £27,475 | £14,975 | £6,875 | |
| EBITDA | (£15,625) | (£20,650) | (£59,625) | (£21,925) | (£21,925) | £19,115 | £43,815 | £53,815 | £22,825 | £28,075 | £15,575 | £7,475 | |
| Interest Expense | £1,237 | £1,224 | £1,211 | £1,198 | £1,185 | £1,172 | £1,159 | £1,146 | £1,133 | £1,120 | £1,107 | £1,094 | |
| Taxes Incurred | (£5,059) | (£6,562) | (£18,431) | (£7,117) | (£7,113) | £5,203 | £12,617 | £15,621 | £6,328 | £7,907 | £4,160 | £1,734 | |
| Net Profit | (£11,803) | (£15,312) | (£43,005) | (£16,606) | (£16,597) | £12,140 | £29,439 | £36,448 | £14,765 | £18,449 | £9,708 | £4,047 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -21.92% | -21.91% | 10.51% | 20.60% | 23.70% | 12.35% | 18.26% | 11.27% | 5.31% | |
| 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 | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| 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 | £0 | £0 | £0 | £75,750 | £75,750 | £115,550 | £142,900 | £153,800 | £119,575 | £101,050 | £86,150 | £76,250 | |
| 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 | £7,500 | £11,000 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | £27,500 | |
| Bill Payments | £143 | £4,304 | £4,665 | £16,516 | £63,265 | £64,754 | £79,740 | £88,341 | £89,672 | £72,465 | £52,357 | £46,683 | |
| Subtotal Spent on Operations | £7,643 | £15,304 | £32,165 | £44,016 | £90,765 | £92,254 | £107,240 | £115,841 | £117,172 | £99,965 | £79,857 | £74,183 | |
| 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,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | £1,563 | |
| 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 | £9,206 | £16,866 | £33,727 | £45,579 | £92,327 | £93,816 | £108,803 | £117,404 | £118,734 | £101,528 | £81,420 | £75,745 | |
| Net Cash Flow | (£9,206) | (£16,866) | (£33,727) | £30,171 | (£16,577) | £21,734 | £34,097 | £36,396 | £841 | (£478) | £4,730 | £505 | |
| Cash Balance | £159,594 | £142,728 | £109,001 | £139,172 | £122,595 | £144,329 | £178,426 | £214,822 | £215,663 | £215,185 | £219,915 | £220,420 | |
| 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 | £168,800 | £159,594 | £142,728 | £109,001 | £139,172 | £122,595 | £144,329 | £178,426 | £214,822 | £215,663 | £215,185 | £219,915 | £220,420 |
| Inventory | £9,000 | £9,000 | £9,000 | £9,000 | £7,975 | £7,975 | £12,111 | £15,026 | £16,016 | £12,458 | £10,505 | £8,965 | £8,085 |
| Other Current Assets | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 | £15,000 |
| Total Current Assets | £192,800 | £183,594 | £166,728 | £133,001 | £162,147 | £145,570 | £171,440 | £208,452 | £245,838 | £243,120 | £240,690 | £243,880 | £243,505 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 | £128,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £600 | £1,200 | £1,800 | £2,400 | £3,000 | £3,600 | £4,200 | £4,800 | £5,400 | £6,000 |
| Total Long-term Assets | £128,000 | £128,000 | £128,000 | £127,400 | £126,800 | £126,200 | £125,600 | £125,000 | £124,400 | £123,800 | £123,200 | £122,600 | £122,000 |
| Total Assets | £320,800 | £311,594 | £294,728 | £260,401 | £288,947 | £271,770 | £297,040 | £333,452 | £370,238 | £366,920 | £363,890 | £366,480 | £365,505 |
| 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 | £4,160 | £4,168 | £14,408 | £61,123 | £62,105 | £76,798 | £85,333 | £87,234 | £70,714 | £50,797 | £45,242 | £41,782 |
| 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 | £4,160 | £4,168 | £14,408 | £61,123 | £62,105 | £76,798 | £85,333 | £87,234 | £70,714 | £50,797 | £45,242 | £41,782 |
| Long-term Liabilities | £150,000 | £148,438 | £146,875 | £145,313 | £143,750 | £142,188 | £140,625 | £139,063 | £137,500 | £135,938 | £134,375 | £132,813 | £131,250 |
| Total Liabilities | £150,000 | £152,597 | £151,043 | £159,721 | £204,873 | £204,293 | £217,423 | £224,396 | £224,734 | £206,651 | £185,172 | £178,055 | £173,032 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) | (£79,200) |
| Earnings | £0 | (£11,803) | (£27,115) | (£70,120) | (£86,726) | (£103,323) | (£91,183) | (£61,744) | (£25,295) | (£10,531) | £7,918 | £17,626 | £21,672 |
| Total Capital | £170,800 | £158,997 | £143,685 | £100,680 | £84,074 | £67,477 | £79,617 | £109,056 | £145,505 | £160,269 | £178,718 | £188,426 | £192,472 |
| Total Liabilities and Capital | £320,800 | £311,594 | £294,728 | £260,401 | £288,947 | £271,770 | £297,040 | £333,452 | £370,238 | £366,920 | £363,890 | £366,480 | £365,505 |
| Net Worth | £170,800 | £158,997 | £143,685 | £100,680 | £84,074 | £67,477 | £79,617 | £109,056 | £145,505 | £160,269 | £178,718 | £188,426 | £192,472 |