| 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 | |||||||||||||
| Iron Mikes | 0% | £12,240 | £5,508 | £5,508 | £2,754 | £2,754 | £2,754 | £5,508 | £12,240 | £12,240 | £12,240 | £12,240 | £12,240 |
| Pitching Lanes | 0% | £6,120 | £6,120 | £2,754 | £1,377 | £1,377 | £1,377 | £2,754 | £6,120 | £6,120 | £6,120 | £6,120 | £6,120 |
| Hitting league | 0% | £0 | £0 | £0 | £0 | £6,000 | £3,000 | £6,000 | £0 | £6,000 | £0 | £6,000 | £0 |
| Instructor fees collected | 0% | £200 | £300 | £400 | £400 | £400 | £400 | £400 | £500 | £600 | £700 | £800 | £800 |
| Skills & Drills League registration fees | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £900 | £900 | £0 |
| Utility Lanes | 0% | £6,120 | £6,120 | £2,754 | £1,377 | £1,377 | £1,377 | £2,754 | £6,120 | £6,120 | £6,120 | £6,120 | £6,120 |
| Total Sales | £24,680 | £18,048 | £11,416 | £5,908 | £11,908 | £8,908 | £17,416 | £24,980 | £31,080 | £26,080 | £32,180 | £25,280 | |
| 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 | |
| Skills & Drills League prizes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £450 | £450 | £0 | |
| Instructor fees paid | 80% | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £560 | £640 | £640 |
| Row 3 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £1,010 | £1,090 | £640 | |
| 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 | ||
| Owner | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Bookkeeper | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Part time #1 | 0% | £600 | £600 | £700 | £400 | £400 | £400 | £600 | £700 | £800 | £800 | £800 | £800 |
| Part time #2 | 0% | £600 | £600 | £700 | £0 | £0 | £0 | £600 | £700 | £800 | £800 | £800 | £800 |
| Total People | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £4,700 | £4,700 | £4,900 | £3,900 | £3,900 | £3,900 | £4,700 | £4,900 | £5,100 | £5,100 | £5,100 | £5,100 | |
| 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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.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 | £24,680 | £18,048 | £11,416 | £5,908 | £11,908 | £8,908 | £17,416 | £24,980 | £31,080 | £26,080 | £32,180 | £25,280 | |
| Direct Cost of Sales | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £1,010 | £1,090 | £640 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £1,010 | £1,090 | £640 | |
| Gross Margin | £24,520 | £17,808 | £11,096 | £5,588 | £11,588 | £8,588 | £17,096 | £24,580 | £30,600 | £25,070 | £31,090 | £24,640 | |
| Gross Margin % | 99.35% | 98.67% | 97.20% | 94.58% | 97.31% | 96.41% | 98.16% | 98.40% | 98.46% | 96.13% | 96.61% | 97.47% | |
| Expenses | |||||||||||||
| Payroll | £4,700 | £4,700 | £4,900 | £3,900 | £3,900 | £3,900 | £4,700 | £4,900 | £5,100 | £5,100 | £5,100 | £5,100 | |
| Marketing/Promotion | £1,200 | £500 | £500 | £100 | £750 | £100 | £100 | £100 | £250 | £250 | £250 | £500 | |
| Depreciation | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | |
| Rent | £5,734 | £5,734 | £5,734 | £5,734 | £5,734 | £5,734 | £8,600 | £8,600 | £8,600 | £8,600 | £8,600 | £8,600 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Equipment Repair and Maintenance | £306 | £306 | £138 | £69 | £295 | £69 | £138 | £306 | £306 | £367 | £367 | £367 | |
| Ball and bat replacement | 15% | £122 | £122 | £55 | £28 | £28 | £28 | £55 | £122 | £122 | £122 | £122 | £122 |
| Other (incl. property taxes) | £850 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | |
| Total Operating Expenses | £13,841 | £13,116 | £13,080 | £11,584 | £12,460 | £11,584 | £15,346 | £15,782 | £16,132 | £16,193 | £16,193 | £16,443 | |
| Profit Before Interest and Taxes | £10,679 | £4,692 | (£1,984) | (£5,996) | (£872) | (£2,996) | £1,750 | £8,798 | £14,468 | £8,877 | £14,897 | £8,197 | |
| EBITDA | £11,108 | £5,121 | (£1,556) | (£5,567) | (£444) | (£2,567) | £2,178 | £9,227 | £14,897 | £9,305 | £15,325 | £8,625 | |
| Interest Expense | £467 | £467 | £467 | £459 | £451 | £443 | £436 | £428 | £420 | £412 | £404 | £397 | |
| Taxes Incurred | £3,064 | £1,268 | (£735) | (£1,936) | (£397) | (£1,032) | £394 | £2,511 | £4,214 | £2,539 | £4,348 | £2,340 | |
| Net Profit | £7,149 | £2,958 | (£1,716) | (£4,518) | (£926) | (£2,408) | £920 | £5,859 | £9,834 | £5,925 | £10,145 | £5,460 | |
| Net Profit/Sales | 28.97% | 16.39% | -15.03% | -76.48% | -7.78% | -27.03% | 5.28% | 23.46% | 31.64% | 22.72% | 31.52% | 21.60% | |
| 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 | £22,212 | £16,243 | £10,274 | £5,317 | £10,717 | £8,017 | £15,674 | £22,482 | £27,972 | £23,472 | £28,962 | £22,752 | |
| Cash from Receivables | £0 | £82 | £2,446 | £1,783 | £1,123 | £611 | £1,181 | £919 | £1,767 | £2,518 | £3,091 | £2,628 | |
| Subtotal Cash from Operations | £22,212 | £16,325 | £12,720 | £7,100 | £11,840 | £8,628 | £16,855 | £23,401 | £29,739 | £25,990 | £32,053 | £25,380 | |
| 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 | £22,212 | £16,325 | £12,720 | £7,100 | £11,840 | £8,628 | £16,855 | £23,401 | £29,739 | £25,990 | £32,053 | £25,380 | |
| 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 | £4,700 | £4,700 | £4,900 | £3,900 | £3,900 | £3,900 | £4,700 | £4,900 | £5,100 | £5,100 | £5,100 | £5,100 | |
| Bill Payments | £413 | £12,321 | £9,890 | £7,746 | £6,178 | £8,455 | £7,133 | £11,448 | £13,856 | £15,681 | £14,689 | £16,433 | |
| Subtotal Spent on Operations | £5,113 | £17,021 | £14,790 | £11,646 | £10,078 | £12,355 | £11,833 | £16,348 | £18,956 | £20,781 | £19,789 | £21,533 | |
| 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 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | |
| 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 | £5,113 | £17,021 | £14,790 | £12,813 | £11,245 | £13,522 | £13,000 | £17,515 | £20,123 | £21,948 | £20,956 | £22,700 | |
| Net Cash Flow | £17,099 | (£696) | (£2,069) | (£5,713) | £596 | (£4,894) | £3,856 | £5,886 | £9,616 | £4,042 | £11,098 | £2,681 | |
| Cash Balance | £20,099 | £19,403 | £17,333 | £11,620 | £12,216 | £7,322 | £11,178 | £17,064 | £26,679 | £30,722 | £41,820 | £44,500 | |
| 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 | £3,000 | £20,099 | £19,403 | £17,333 | £11,620 | £12,216 | £7,322 | £11,178 | £17,064 | £26,679 | £30,722 | £41,820 | £44,500 |
| Accounts Receivable | £0 | £2,468 | £4,191 | £2,886 | £1,694 | £1,762 | £2,042 | £2,603 | £4,182 | £5,523 | £5,612 | £5,739 | £5,639 |
| Other Current Assets | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 |
| Total Current Assets | £14,150 | £33,717 | £34,743 | £31,369 | £24,464 | £25,128 | £20,514 | £24,930 | £32,395 | £43,352 | £47,484 | £58,709 | £61,289 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 |
| Accumulated Depreciation | £0 | £429 | £857 | £1,286 | £1,714 | £2,143 | £2,571 | £3,000 | £3,429 | £3,857 | £4,286 | £4,714 | £5,143 |
| Total Long-term Assets | £36,000 | £35,571 | £35,143 | £34,714 | £34,286 | £33,857 | £33,429 | £33,000 | £32,571 | £32,143 | £31,714 | £31,286 | £30,857 |
| Total Assets | £50,150 | £69,288 | £69,886 | £66,084 | £58,750 | £58,985 | £53,943 | £57,930 | £64,967 | £75,495 | £79,198 | £89,994 | £92,146 |
| 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 | £11,989 | £9,630 | £7,543 | £5,895 | £8,222 | £6,754 | £10,989 | £13,333 | £15,194 | £14,139 | £15,957 | £13,815 |
| 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 | £11,989 | £9,630 | £7,543 | £5,895 | £8,222 | £6,754 | £10,989 | £13,333 | £15,194 | £14,139 | £15,957 | £13,815 |
| Long-term Liabilities | £70,000 | £70,000 | £70,000 | £70,000 | £68,833 | £67,667 | £66,500 | £65,333 | £64,167 | £63,000 | £61,833 | £60,667 | £59,500 |
| Total Liabilities | £70,000 | £81,989 | £79,630 | £77,543 | £74,728 | £75,889 | £73,254 | £76,322 | £77,499 | £78,194 | £75,972 | £76,623 | £73,315 |
| Paid-in Capital | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Retained Earnings | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) |
| Earnings | £0 | £7,149 | £10,106 | £8,391 | £3,872 | £2,946 | £539 | £1,458 | £7,318 | £17,151 | £23,076 | £33,221 | £38,681 |
| Total Capital | (£19,850) | (£12,701) | (£9,744) | (£11,459) | (£15,978) | (£16,904) | (£19,311) | (£18,392) | (£12,532) | (£2,699) | £3,226 | £13,371 | £18,831 |
| Total Liabilities and Capital | £50,150 | £69,288 | £69,886 | £66,084 | £58,750 | £58,985 | £53,943 | £57,930 | £64,967 | £75,495 | £79,198 | £89,994 | £92,146 |
| Net Worth | (£19,850) | (£12,701) | (£9,744) | (£11,459) | (£15,978) | (£16,904) | (£19,311) | (£18,392) | (£12,532) | (£2,699) | £3,226 | £13,371 | £18,831 |
| 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 | |||||||||||||
| Iron Mikes | 0% | £12,240 | £5,508 | £5,508 | £2,754 | £2,754 | £2,754 | £5,508 | £12,240 | £12,240 | £12,240 | £12,240 | £12,240 |
| Pitching Lanes | 0% | £6,120 | £6,120 | £2,754 | £1,377 | £1,377 | £1,377 | £2,754 | £6,120 | £6,120 | £6,120 | £6,120 | £6,120 |
| Hitting league | 0% | £0 | £0 | £0 | £0 | £6,000 | £3,000 | £6,000 | £0 | £6,000 | £0 | £6,000 | £0 |
| Instructor fees collected | 0% | £200 | £300 | £400 | £400 | £400 | £400 | £400 | £500 | £600 | £700 | £800 | £800 |
| Skills & Drills League registration fees | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £900 | £900 | £0 |
| Utility Lanes | 0% | £6,120 | £6,120 | £2,754 | £1,377 | £1,377 | £1,377 | £2,754 | £6,120 | £6,120 | £6,120 | £6,120 | £6,120 |
| Total Sales | £24,680 | £18,048 | £11,416 | £5,908 | £11,908 | £8,908 | £17,416 | £24,980 | £31,080 | £26,080 | £32,180 | £25,280 | |
| 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 | |
| Skills & Drills League prizes | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £450 | £450 | £0 | |
| Instructor fees paid | 80% | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £560 | £640 | £640 |
| Row 3 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £1,010 | £1,090 | £640 | |
| 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 | ||
| Owner | 0% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Bookkeeper | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Part time #1 | 0% | £600 | £600 | £700 | £400 | £400 | £400 | £600 | £700 | £800 | £800 | £800 | £800 |
| Part time #2 | 0% | £600 | £600 | £700 | £0 | £0 | £0 | £600 | £700 | £800 | £800 | £800 | £800 |
| Total People | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £4,700 | £4,700 | £4,900 | £3,900 | £3,900 | £3,900 | £4,700 | £4,900 | £5,100 | £5,100 | £5,100 | £5,100 | |
| 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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.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 | £24,680 | £18,048 | £11,416 | £5,908 | £11,908 | £8,908 | £17,416 | £24,980 | £31,080 | £26,080 | £32,180 | £25,280 | |
| Direct Cost of Sales | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £1,010 | £1,090 | £640 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £160 | £240 | £320 | £320 | £320 | £320 | £320 | £400 | £480 | £1,010 | £1,090 | £640 | |
| Gross Margin | £24,520 | £17,808 | £11,096 | £5,588 | £11,588 | £8,588 | £17,096 | £24,580 | £30,600 | £25,070 | £31,090 | £24,640 | |
| Gross Margin % | 99.35% | 98.67% | 97.20% | 94.58% | 97.31% | 96.41% | 98.16% | 98.40% | 98.46% | 96.13% | 96.61% | 97.47% | |
| Expenses | |||||||||||||
| Payroll | £4,700 | £4,700 | £4,900 | £3,900 | £3,900 | £3,900 | £4,700 | £4,900 | £5,100 | £5,100 | £5,100 | £5,100 | |
| Marketing/Promotion | £1,200 | £500 | £500 | £100 | £750 | £100 | £100 | £100 | £250 | £250 | £250 | £500 | |
| Depreciation | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | £429 | |
| Rent | £5,734 | £5,734 | £5,734 | £5,734 | £5,734 | £5,734 | £8,600 | £8,600 | £8,600 | £8,600 | £8,600 | £8,600 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Equipment Repair and Maintenance | £306 | £306 | £138 | £69 | £295 | £69 | £138 | £306 | £306 | £367 | £367 | £367 | |
| Ball and bat replacement | 15% | £122 | £122 | £55 | £28 | £28 | £28 | £55 | £122 | £122 | £122 | £122 | £122 |
| Other (incl. property taxes) | £850 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | £825 | |
| Total Operating Expenses | £13,841 | £13,116 | £13,080 | £11,584 | £12,460 | £11,584 | £15,346 | £15,782 | £16,132 | £16,193 | £16,193 | £16,443 | |
| Profit Before Interest and Taxes | £10,679 | £4,692 | (£1,984) | (£5,996) | (£872) | (£2,996) | £1,750 | £8,798 | £14,468 | £8,877 | £14,897 | £8,197 | |
| EBITDA | £11,108 | £5,121 | (£1,556) | (£5,567) | (£444) | (£2,567) | £2,178 | £9,227 | £14,897 | £9,305 | £15,325 | £8,625 | |
| Interest Expense | £467 | £467 | £467 | £459 | £451 | £443 | £436 | £428 | £420 | £412 | £404 | £397 | |
| Taxes Incurred | £3,064 | £1,268 | (£735) | (£1,936) | (£397) | (£1,032) | £394 | £2,511 | £4,214 | £2,539 | £4,348 | £2,340 | |
| Net Profit | £7,149 | £2,958 | (£1,716) | (£4,518) | (£926) | (£2,408) | £920 | £5,859 | £9,834 | £5,925 | £10,145 | £5,460 | |
| Net Profit/Sales | 28.97% | 16.39% | -15.03% | -76.48% | -7.78% | -27.03% | 5.28% | 23.46% | 31.64% | 22.72% | 31.52% | 21.60% | |
| 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 | £22,212 | £16,243 | £10,274 | £5,317 | £10,717 | £8,017 | £15,674 | £22,482 | £27,972 | £23,472 | £28,962 | £22,752 | |
| Cash from Receivables | £0 | £82 | £2,446 | £1,783 | £1,123 | £611 | £1,181 | £919 | £1,767 | £2,518 | £3,091 | £2,628 | |
| Subtotal Cash from Operations | £22,212 | £16,325 | £12,720 | £7,100 | £11,840 | £8,628 | £16,855 | £23,401 | £29,739 | £25,990 | £32,053 | £25,380 | |
| 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 | £22,212 | £16,325 | £12,720 | £7,100 | £11,840 | £8,628 | £16,855 | £23,401 | £29,739 | £25,990 | £32,053 | £25,380 | |
| 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 | £4,700 | £4,700 | £4,900 | £3,900 | £3,900 | £3,900 | £4,700 | £4,900 | £5,100 | £5,100 | £5,100 | £5,100 | |
| Bill Payments | £413 | £12,321 | £9,890 | £7,746 | £6,178 | £8,455 | £7,133 | £11,448 | £13,856 | £15,681 | £14,689 | £16,433 | |
| Subtotal Spent on Operations | £5,113 | £17,021 | £14,790 | £11,646 | £10,078 | £12,355 | £11,833 | £16,348 | £18,956 | £20,781 | £19,789 | £21,533 | |
| 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 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | £1,167 | |
| 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 | £5,113 | £17,021 | £14,790 | £12,813 | £11,245 | £13,522 | £13,000 | £17,515 | £20,123 | £21,948 | £20,956 | £22,700 | |
| Net Cash Flow | £17,099 | (£696) | (£2,069) | (£5,713) | £596 | (£4,894) | £3,856 | £5,886 | £9,616 | £4,042 | £11,098 | £2,681 | |
| Cash Balance | £20,099 | £19,403 | £17,333 | £11,620 | £12,216 | £7,322 | £11,178 | £17,064 | £26,679 | £30,722 | £41,820 | £44,500 | |
| 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 | £3,000 | £20,099 | £19,403 | £17,333 | £11,620 | £12,216 | £7,322 | £11,178 | £17,064 | £26,679 | £30,722 | £41,820 | £44,500 |
| Accounts Receivable | £0 | £2,468 | £4,191 | £2,886 | £1,694 | £1,762 | £2,042 | £2,603 | £4,182 | £5,523 | £5,612 | £5,739 | £5,639 |
| Other Current Assets | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 | £11,150 |
| Total Current Assets | £14,150 | £33,717 | £34,743 | £31,369 | £24,464 | £25,128 | £20,514 | £24,930 | £32,395 | £43,352 | £47,484 | £58,709 | £61,289 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 | £36,000 |
| Accumulated Depreciation | £0 | £429 | £857 | £1,286 | £1,714 | £2,143 | £2,571 | £3,000 | £3,429 | £3,857 | £4,286 | £4,714 | £5,143 |
| Total Long-term Assets | £36,000 | £35,571 | £35,143 | £34,714 | £34,286 | £33,857 | £33,429 | £33,000 | £32,571 | £32,143 | £31,714 | £31,286 | £30,857 |
| Total Assets | £50,150 | £69,288 | £69,886 | £66,084 | £58,750 | £58,985 | £53,943 | £57,930 | £64,967 | £75,495 | £79,198 | £89,994 | £92,146 |
| 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 | £11,989 | £9,630 | £7,543 | £5,895 | £8,222 | £6,754 | £10,989 | £13,333 | £15,194 | £14,139 | £15,957 | £13,815 |
| 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 | £11,989 | £9,630 | £7,543 | £5,895 | £8,222 | £6,754 | £10,989 | £13,333 | £15,194 | £14,139 | £15,957 | £13,815 |
| Long-term Liabilities | £70,000 | £70,000 | £70,000 | £70,000 | £68,833 | £67,667 | £66,500 | £65,333 | £64,167 | £63,000 | £61,833 | £60,667 | £59,500 |
| Total Liabilities | £70,000 | £81,989 | £79,630 | £77,543 | £74,728 | £75,889 | £73,254 | £76,322 | £77,499 | £78,194 | £75,972 | £76,623 | £73,315 |
| Paid-in Capital | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Retained Earnings | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) | (£27,850) |
| Earnings | £0 | £7,149 | £10,106 | £8,391 | £3,872 | £2,946 | £539 | £1,458 | £7,318 | £17,151 | £23,076 | £33,221 | £38,681 |
| Total Capital | (£19,850) | (£12,701) | (£9,744) | (£11,459) | (£15,978) | (£16,904) | (£19,311) | (£18,392) | (£12,532) | (£2,699) | £3,226 | £13,371 | £18,831 |
| Total Liabilities and Capital | £50,150 | £69,288 | £69,886 | £66,084 | £58,750 | £58,985 | £53,943 | £57,930 | £64,967 | £75,495 | £79,198 | £89,994 | £92,146 |
| Net Worth | (£19,850) | (£12,701) | (£9,744) | (£11,459) | (£15,978) | (£16,904) | (£19,311) | (£18,392) | (£12,532) | (£2,699) | £3,226 | £13,371 | £18,831 |