| 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 | |||||||||||||
| All services | 0% | £8,500 | £6,800 | £10,800 | £16,800 | £25,800 | £34,800 | £40,800 | £40,800 | £40,800 | £46,800 | £46,800 | £46,800 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £8,500 | £6,800 | £10,800 | £16,800 | £25,800 | £34,800 | £40,800 | £40,800 | £40,800 | £46,800 | £46,800 | £46,800 | |
| 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 | |
| All services | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| 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 | ||
| Partners | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internal Consultants | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | £4,000 | £4,000 | £4,000 |
| External Consultants | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Office Manager | 0% | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Personal Assistant | 0% | £600 | £600 | £600 | £600 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £1,200 |
| Secretarial Staff | 0% | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 |
| Research Staff | 0% | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Other | 0% | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £600 | £600 | £600 | £5,500 | £5,700 | £5,700 | £5,700 | £5,700 | £11,700 | £11,700 | £11,700 | £12,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 | 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 | £8,500 | £6,800 | £10,800 | £16,800 | £25,800 | £34,800 | £40,800 | £40,800 | £40,800 | £46,800 | £46,800 | £46,800 | |
| Direct Cost of Sales | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Gross Margin | £7,250 | £5,300 | £8,550 | £13,800 | £20,800 | £25,300 | £31,300 | £31,300 | £31,300 | £37,300 | £37,300 | £37,300 | |
| Gross Margin % | 85.29% | 77.94% | 79.17% | 82.14% | 80.62% | 72.70% | 76.72% | 76.72% | 76.72% | 79.70% | 79.70% | 79.70% | |
| Expenses | |||||||||||||
| Payroll | £600 | £600 | £600 | £5,500 | £5,700 | £5,700 | £5,700 | £5,700 | £11,700 | £11,700 | £11,700 | £12,100 | |
| Sales and Marketing and Other Expenses | £1,500 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Public Relations | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Payroll Taxes | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,650 | £3,380 | £3,380 | £8,280 | £8,480 | £8,480 | £8,480 | £8,480 | £14,480 | £14,480 | £14,480 | £14,880 | |
| Profit Before Interest and Taxes | £3,600 | £1,920 | £5,170 | £5,520 | £12,320 | £16,820 | £22,820 | £22,820 | £16,820 | £22,820 | £22,820 | £22,420 | |
| EBITDA | £3,600 | £1,920 | £5,170 | £5,520 | £12,320 | £16,820 | £22,820 | £22,820 | £16,820 | £22,820 | £22,820 | £22,420 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £1,080 | £480 | £1,293 | £1,380 | £3,080 | £4,205 | £5,705 | £5,705 | £4,205 | £5,705 | £5,705 | £5,605 | |
| Net Profit | £2,520 | £1,440 | £3,878 | £4,140 | £9,240 | £12,615 | £17,115 | £17,115 | £12,615 | £17,115 | £17,115 | £16,815 | |
| Net Profit/Sales | 29.65% | 21.18% | 35.90% | 24.64% | 35.81% | 36.25% | 41.95% | 41.95% | 30.92% | 36.57% | 36.57% | 35.93% | |
| 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 | £2,125 | £1,700 | £2,700 | £4,200 | £6,450 | £8,700 | £10,200 | £10,200 | £10,200 | £11,700 | £11,700 | £11,700 | |
| Cash from Receivables | £0 | £213 | £6,333 | £5,200 | £8,250 | £12,825 | £19,575 | £26,250 | £30,600 | £30,600 | £30,750 | £35,100 | |
| Subtotal Cash from Operations | £2,125 | £1,913 | £9,033 | £9,400 | £14,700 | £21,525 | £29,775 | £36,450 | £40,800 | £42,300 | £42,450 | £46,800 | |
| 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 | £2,125 | £1,913 | £9,033 | £9,400 | £14,700 | £21,525 | £29,775 | £36,450 | £40,800 | £42,300 | £42,450 | £46,800 | |
| 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 | £600 | £600 | £600 | £5,500 | £5,700 | £5,700 | £5,700 | £5,700 | £11,700 | £11,700 | £11,700 | £12,100 | |
| Bill Payments | £179 | £5,359 | £4,812 | £6,350 | £7,283 | £11,048 | £16,535 | £17,985 | £17,935 | £16,535 | £17,985 | £17,982 | |
| Subtotal Spent on Operations | £779 | £5,959 | £5,412 | £11,850 | £12,983 | £16,748 | £22,235 | £23,685 | £29,635 | £28,235 | £29,685 | £30,082 | |
| 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 | £779 | £5,959 | £5,412 | £11,850 | £12,983 | £16,748 | £22,235 | £23,685 | £29,635 | £28,235 | £29,685 | £30,082 | |
| Net Cash Flow | £1,346 | (£4,047) | £3,620 | (£2,450) | £1,717 | £4,778 | £7,540 | £12,765 | £11,165 | £14,065 | £12,765 | £16,718 | |
| Cash Balance | £21,746 | £17,699 | £21,319 | £18,869 | £20,586 | £25,363 | £32,903 | £45,668 | £56,833 | £70,898 | £83,663 | £100,381 | |
| 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 | £20,400 | £21,746 | £17,699 | £21,319 | £18,869 | £20,586 | £25,363 | £32,903 | £45,668 | £56,833 | £70,898 | £83,663 | £100,381 |
| Accounts Receivable | £0 | £6,375 | £11,263 | £13,030 | £20,430 | £31,530 | £44,805 | £55,830 | £60,180 | £60,180 | £64,680 | £69,030 | £69,030 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £20,400 | £28,121 | £28,961 | £34,349 | £39,299 | £52,116 | £70,168 | £88,733 | £105,848 | £117,013 | £135,578 | £152,693 | £169,411 |
| 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 | £20,400 | £28,121 | £28,961 | £34,349 | £39,299 | £52,116 | £70,168 | £88,733 | £105,848 | £117,013 | £135,578 | £152,693 | £169,411 |
| 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 | £5,201 | £4,601 | £6,112 | £6,921 | £10,498 | £15,936 | £17,386 | £17,386 | £15,936 | £17,386 | £17,386 | £17,289 |
| 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 | £5,201 | £4,601 | £6,112 | £6,921 | £10,498 | £15,936 | £17,386 | £17,386 | £15,936 | £17,386 | £17,386 | £17,289 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £5,201 | £4,601 | £6,112 | £6,921 | £10,498 | £15,936 | £17,386 | £17,386 | £15,936 | £17,386 | £17,386 | £17,289 |
| Paid-in Capital | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Retained Earnings | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) |
| Earnings | £0 | £2,520 | £3,960 | £7,838 | £11,978 | £21,218 | £33,833 | £50,948 | £68,063 | £80,678 | £97,793 | £114,908 | £131,723 |
| Total Capital | £20,400 | £22,920 | £24,360 | £28,238 | £32,378 | £41,618 | £54,233 | £71,348 | £88,463 | £101,078 | £118,193 | £135,308 | £152,123 |
| Total Liabilities and Capital | £20,400 | £28,121 | £28,961 | £34,349 | £39,299 | £52,116 | £70,168 | £88,733 | £105,848 | £117,013 | £135,578 | £152,693 | £169,411 |
| Net Worth | £20,400 | £22,920 | £24,360 | £28,238 | £32,378 | £41,618 | £54,233 | £71,348 | £88,463 | £101,078 | £118,193 | £135,308 | £152,122 |
| 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 | |||||||||||||
| All services | 0% | £8,500 | £6,800 | £10,800 | £16,800 | £25,800 | £34,800 | £40,800 | £40,800 | £40,800 | £46,800 | £46,800 | £46,800 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £8,500 | £6,800 | £10,800 | £16,800 | £25,800 | £34,800 | £40,800 | £40,800 | £40,800 | £46,800 | £46,800 | £46,800 | |
| 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 | |
| All services | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| 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 | ||
| Partners | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Internal Consultants | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £4,000 | £4,000 | £4,000 | £4,000 |
| External Consultants | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Office Manager | 0% | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Personal Assistant | 0% | £600 | £600 | £600 | £600 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £1,200 |
| Secretarial Staff | 0% | £0 | £0 | £0 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 |
| Research Staff | 0% | £0 | £0 | £0 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Other | 0% | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £600 | £600 | £600 | £5,500 | £5,700 | £5,700 | £5,700 | £5,700 | £11,700 | £11,700 | £11,700 | £12,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 | 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 | £8,500 | £6,800 | £10,800 | £16,800 | £25,800 | £34,800 | £40,800 | £40,800 | £40,800 | £46,800 | £46,800 | £46,800 | |
| Direct Cost of Sales | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,250 | £1,500 | £2,250 | £3,000 | £5,000 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | £9,500 | |
| Gross Margin | £7,250 | £5,300 | £8,550 | £13,800 | £20,800 | £25,300 | £31,300 | £31,300 | £31,300 | £37,300 | £37,300 | £37,300 | |
| Gross Margin % | 85.29% | 77.94% | 79.17% | 82.14% | 80.62% | 72.70% | 76.72% | 76.72% | 76.72% | 79.70% | 79.70% | 79.70% | |
| Expenses | |||||||||||||
| Payroll | £600 | £600 | £600 | £5,500 | £5,700 | £5,700 | £5,700 | £5,700 | £11,700 | £11,700 | £11,700 | £12,100 | |
| Sales and Marketing and Other Expenses | £1,500 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | £1,230 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Public Relations | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Payroll Taxes | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,650 | £3,380 | £3,380 | £8,280 | £8,480 | £8,480 | £8,480 | £8,480 | £14,480 | £14,480 | £14,480 | £14,880 | |
| Profit Before Interest and Taxes | £3,600 | £1,920 | £5,170 | £5,520 | £12,320 | £16,820 | £22,820 | £22,820 | £16,820 | £22,820 | £22,820 | £22,420 | |
| EBITDA | £3,600 | £1,920 | £5,170 | £5,520 | £12,320 | £16,820 | £22,820 | £22,820 | £16,820 | £22,820 | £22,820 | £22,420 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £1,080 | £480 | £1,293 | £1,380 | £3,080 | £4,205 | £5,705 | £5,705 | £4,205 | £5,705 | £5,705 | £5,605 | |
| Net Profit | £2,520 | £1,440 | £3,878 | £4,140 | £9,240 | £12,615 | £17,115 | £17,115 | £12,615 | £17,115 | £17,115 | £16,815 | |
| Net Profit/Sales | 29.65% | 21.18% | 35.90% | 24.64% | 35.81% | 36.25% | 41.95% | 41.95% | 30.92% | 36.57% | 36.57% | 35.93% | |
| 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 | £2,125 | £1,700 | £2,700 | £4,200 | £6,450 | £8,700 | £10,200 | £10,200 | £10,200 | £11,700 | £11,700 | £11,700 | |
| Cash from Receivables | £0 | £213 | £6,333 | £5,200 | £8,250 | £12,825 | £19,575 | £26,250 | £30,600 | £30,600 | £30,750 | £35,100 | |
| Subtotal Cash from Operations | £2,125 | £1,913 | £9,033 | £9,400 | £14,700 | £21,525 | £29,775 | £36,450 | £40,800 | £42,300 | £42,450 | £46,800 | |
| 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 | £2,125 | £1,913 | £9,033 | £9,400 | £14,700 | £21,525 | £29,775 | £36,450 | £40,800 | £42,300 | £42,450 | £46,800 | |
| 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 | £600 | £600 | £600 | £5,500 | £5,700 | £5,700 | £5,700 | £5,700 | £11,700 | £11,700 | £11,700 | £12,100 | |
| Bill Payments | £179 | £5,359 | £4,812 | £6,350 | £7,283 | £11,048 | £16,535 | £17,985 | £17,935 | £16,535 | £17,985 | £17,982 | |
| Subtotal Spent on Operations | £779 | £5,959 | £5,412 | £11,850 | £12,983 | £16,748 | £22,235 | £23,685 | £29,635 | £28,235 | £29,685 | £30,082 | |
| 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 | £779 | £5,959 | £5,412 | £11,850 | £12,983 | £16,748 | £22,235 | £23,685 | £29,635 | £28,235 | £29,685 | £30,082 | |
| Net Cash Flow | £1,346 | (£4,047) | £3,620 | (£2,450) | £1,717 | £4,778 | £7,540 | £12,765 | £11,165 | £14,065 | £12,765 | £16,718 | |
| Cash Balance | £21,746 | £17,699 | £21,319 | £18,869 | £20,586 | £25,363 | £32,903 | £45,668 | £56,833 | £70,898 | £83,663 | £100,381 | |
| 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 | £20,400 | £21,746 | £17,699 | £21,319 | £18,869 | £20,586 | £25,363 | £32,903 | £45,668 | £56,833 | £70,898 | £83,663 | £100,381 |
| Accounts Receivable | £0 | £6,375 | £11,263 | £13,030 | £20,430 | £31,530 | £44,805 | £55,830 | £60,180 | £60,180 | £64,680 | £69,030 | £69,030 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £20,400 | £28,121 | £28,961 | £34,349 | £39,299 | £52,116 | £70,168 | £88,733 | £105,848 | £117,013 | £135,578 | £152,693 | £169,411 |
| 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 | £20,400 | £28,121 | £28,961 | £34,349 | £39,299 | £52,116 | £70,168 | £88,733 | £105,848 | £117,013 | £135,578 | £152,693 | £169,411 |
| 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 | £5,201 | £4,601 | £6,112 | £6,921 | £10,498 | £15,936 | £17,386 | £17,386 | £15,936 | £17,386 | £17,386 | £17,289 |
| 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 | £5,201 | £4,601 | £6,112 | £6,921 | £10,498 | £15,936 | £17,386 | £17,386 | £15,936 | £17,386 | £17,386 | £17,289 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £5,201 | £4,601 | £6,112 | £6,921 | £10,498 | £15,936 | £17,386 | £17,386 | £15,936 | £17,386 | £17,386 | £17,289 |
| Paid-in Capital | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Retained Earnings | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) | (£49,600) |
| Earnings | £0 | £2,520 | £3,960 | £7,838 | £11,978 | £21,218 | £33,833 | £50,948 | £68,063 | £80,678 | £97,793 | £114,908 | £131,723 |
| Total Capital | £20,400 | £22,920 | £24,360 | £28,238 | £32,378 | £41,618 | £54,233 | £71,348 | £88,463 | £101,078 | £118,193 | £135,308 | £152,123 |
| Total Liabilities and Capital | £20,400 | £28,121 | £28,961 | £34,349 | £39,299 | £52,116 | £70,168 | £88,733 | £105,848 | £117,013 | £135,578 | £152,693 | £169,411 |
| Net Worth | £20,400 | £22,920 | £24,360 | £28,238 | £32,378 | £41,618 | £54,233 | £71,348 | £88,463 | £101,078 | £118,193 | £135,308 | £152,122 |