| 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 | |||||||||||||
| Retainer Consulting | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Project Consulting | 0% | £0 | £0 | £10,000 | £20,000 | £30,000 | £40,000 | £20,000 | £10,000 | £30,000 | £45,000 | £50,000 | £15,000 |
| Market Research | 0% | £0 | £0 | £0 | £4,000 | £8,000 | £15,000 | £10,000 | £5,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Strategic Reports | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £10,000 | £10,000 | £20,000 | £34,000 | £58,000 | £75,000 | £50,000 | £35,000 | £70,000 | £85,000 | £90,000 | £55,000 | |
| 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 | |
| Retainer Consulting | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Project Consulting | £0 | £0 | £1,500 | £3,500 | £5,000 | £6,500 | £3,500 | £1,500 | £5,000 | £7,500 | £8,500 | £2,500 | |
| Market Research | £0 | £0 | £0 | £2,000 | £6,000 | £10,000 | £6,000 | £4,000 | £14,000 | £14,000 | £14,000 | £14,000 | |
| Strategic Reports | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £2,500 | £2,500 | £4,000 | £8,000 | £13,500 | £19,000 | £12,000 | £8,000 | £21,500 | £24,000 | £25,000 | £19,000 | |
| 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 | 140% | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Consultants | 125% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Editorial/graphic | 120% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 |
| VP Marketing | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 |
| Sales people | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Office Manager | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 |
| Secretarial | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,750 | £1,750 | £1,750 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 7 | 7 | 7 | |
| Total Payroll | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £27,250 | £27,250 | £27,250 | |
| 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 | £10,000 | £10,000 | £20,000 | £34,000 | £58,000 | £75,000 | £50,000 | £35,000 | £70,000 | £85,000 | £90,000 | £55,000 | |
| Direct Cost of Sales | £2,500 | £2,500 | £4,000 | £8,000 | £13,500 | £19,000 | £12,000 | £8,000 | £21,500 | £24,000 | £25,000 | £19,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,500 | £2,500 | £4,000 | £8,000 | £13,500 | £19,000 | £12,000 | £8,000 | £21,500 | £24,000 | £25,000 | £19,000 | |
| Gross Margin | £7,500 | £7,500 | £16,000 | £26,000 | £44,500 | £56,000 | £38,000 | £27,000 | £48,500 | £61,000 | £65,000 | £36,000 | |
| Gross Margin % | 75.00% | 75.00% | 80.00% | 76.47% | 76.72% | 74.67% | 76.00% | 77.14% | 69.29% | 71.76% | 72.22% | 65.45% | |
| Expenses | |||||||||||||
| Payroll | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £27,250 | £27,250 | £27,250 | |
| Marketing/Promotion | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Payroll Taxes | 14% | £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 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £33,800 | £44,050 | £44,050 | £44,050 | |
| Profit Before Interest and Taxes | (£21,300) | (£21,300) | (£12,800) | (£2,800) | £15,700 | £27,200 | £9,200 | (£1,800) | £14,700 | £16,950 | £20,950 | (£8,050) | |
| EBITDA | (£21,300) | (£21,300) | (£12,800) | (£2,800) | £15,700 | £27,200 | £9,200 | (£1,800) | £14,700 | £16,950 | £20,950 | (£8,050) | |
| Interest Expense | £417 | £416 | £583 | £582 | £582 | £665 | £664 | £664 | £663 | £663 | £663 | £662 | |
| Taxes Incurred | (£6,515) | (£6,515) | (£4,015) | (£1,015) | £4,536 | £7,961 | £2,561 | (£739) | £4,211 | £4,886 | £6,086 | (£2,613) | |
| Net Profit | (£15,202) | (£15,201) | (£9,368) | (£2,367) | £10,583 | £18,575 | £5,975 | (£1,725) | £9,826 | £11,401 | £14,201 | (£6,098) | |
| Net Profit/Sales | -152.02% | -152.01% | -46.84% | -6.96% | 18.25% | 24.77% | 11.95% | -4.93% | 14.04% | 13.41% | 15.78% | -11.09% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £5,333 | £10,000 | £15,333 | £27,467 | £46,800 | £67,067 | £61,667 | £42,000 | £53,667 | £78,000 | £87,667 | |
| Subtotal Cash from Operations | £0 | £5,333 | £10,000 | £15,333 | £27,467 | £46,800 | £67,067 | £61,667 | £42,000 | £53,667 | £78,000 | £87,667 | |
| 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 | £20,000 | £0 | £0 | £10,000 | £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 | £50,000 | £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 | £8,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £50,000 | £5,333 | £30,000 | £15,333 | £35,467 | £56,800 | £67,067 | £61,667 | £42,000 | £53,667 | £78,000 | £87,667 | |
| 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 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £27,250 | £27,250 | £27,250 | |
| Bill Payments | £790 | £13,202 | £13,340 | £17,601 | £24,736 | £35,717 | £44,012 | £31,782 | £25,340 | £43,280 | £46,422 | £48,059 | |
| Subtotal Spent on Operations | £12,790 | £25,202 | £25,340 | £29,601 | £36,736 | £47,717 | £56,012 | £43,782 | £42,340 | £70,530 | £73,672 | £75,309 | |
| 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 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £100 | |
| 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 | £12,790 | £25,252 | £25,390 | £29,651 | £36,786 | £47,767 | £56,062 | £43,832 | £42,390 | £70,580 | £73,722 | £75,409 | |
| Net Cash Flow | £37,210 | (£19,918) | £4,610 | (£14,318) | (£1,319) | £9,033 | £11,005 | £17,835 | (£390) | (£16,913) | £4,278 | £12,258 | |
| Cash Balance | £87,560 | £67,642 | £72,251 | £57,934 | £56,615 | £65,647 | £76,652 | £94,487 | £94,097 | £77,184 | £81,462 | £93,719 | |
| 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 | £50,350 | £87,560 | £67,642 | £72,251 | £57,934 | £56,615 | £65,647 | £76,652 | £94,487 | £94,097 | £77,184 | £81,462 | £93,719 |
| Accounts Receivable | £0 | £10,000 | £14,667 | £24,667 | £43,333 | £73,867 | £102,067 | £85,000 | £58,333 | £86,333 | £117,667 | £129,667 | £97,000 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £50,350 | £97,560 | £82,308 | £96,918 | £101,267 | £130,481 | £167,714 | £161,652 | £152,820 | £180,431 | £194,851 | £211,128 | £190,719 |
| 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 | £50,350 | £97,560 | £82,308 | £96,918 | £101,267 | £130,481 | £167,714 | £161,652 | £152,820 | £180,431 | £194,851 | £211,128 | £190,719 |
| 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 | £350 | £12,762 | £12,761 | £16,789 | £23,555 | £34,237 | £42,944 | £30,957 | £23,900 | £41,735 | £44,804 | £46,930 | £32,720 |
| Current Borrowing | £0 | £0 | £0 | £20,000 | £20,000 | £20,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £350 | £12,762 | £12,761 | £36,789 | £43,555 | £54,237 | £72,944 | £60,957 | £53,900 | £71,735 | £74,804 | £76,930 | £62,720 |
| Long-term Liabilities | £0 | £50,000 | £49,950 | £49,900 | £49,850 | £49,800 | £49,750 | £49,700 | £49,650 | £49,600 | £49,550 | £49,500 | £49,400 |
| Total Liabilities | £350 | £62,762 | £62,711 | £86,689 | £93,405 | £104,037 | £122,694 | £110,657 | £103,550 | £121,335 | £124,354 | £126,430 | £112,120 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 |
| Retained Earnings | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Earnings | £0 | (£15,202) | (£30,403) | (£39,771) | (£42,138) | (£31,555) | (£12,981) | (£7,006) | (£8,730) | £1,095 | £12,496 | £26,698 | £20,600 |
| Total Capital | £50,000 | £34,798 | £19,597 | £10,229 | £7,862 | £26,445 | £45,019 | £50,994 | £49,270 | £59,096 | £70,496 | £84,698 | £78,600 |
| Total Liabilities and Capital | £50,350 | £97,560 | £82,308 | £96,918 | £101,267 | £130,481 | £167,714 | £161,652 | £152,820 | £180,431 | £194,851 | £211,128 | £190,719 |
| Net Worth | £50,000 | £34,798 | £19,597 | £10,229 | £7,862 | £26,445 | £45,019 | £50,994 | £49,270 | £59,096 | £70,496 | £84,698 | £78,600 |
| 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 | |||||||||||||
| Retainer Consulting | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Project Consulting | 0% | £0 | £0 | £10,000 | £20,000 | £30,000 | £40,000 | £20,000 | £10,000 | £30,000 | £45,000 | £50,000 | £15,000 |
| Market Research | 0% | £0 | £0 | £0 | £4,000 | £8,000 | £15,000 | £10,000 | £5,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Strategic Reports | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £10,000 | £10,000 | £20,000 | £34,000 | £58,000 | £75,000 | £50,000 | £35,000 | £70,000 | £85,000 | £90,000 | £55,000 | |
| 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 | |
| Retainer Consulting | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Project Consulting | £0 | £0 | £1,500 | £3,500 | £5,000 | £6,500 | £3,500 | £1,500 | £5,000 | £7,500 | £8,500 | £2,500 | |
| Market Research | £0 | £0 | £0 | £2,000 | £6,000 | £10,000 | £6,000 | £4,000 | £14,000 | £14,000 | £14,000 | £14,000 | |
| Strategic Reports | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £2,500 | £2,500 | £4,000 | £8,000 | £13,500 | £19,000 | £12,000 | £8,000 | £21,500 | £24,000 | £25,000 | £19,000 | |
| 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 | 140% | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 |
| Consultants | 125% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Editorial/graphic | 120% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £6,000 |
| VP Marketing | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £5,000 | £5,000 | £5,000 |
| Sales people | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Office Manager | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 |
| Secretarial | 110% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,750 | £1,750 | £1,750 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 7 | 7 | 7 | |
| Total Payroll | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £27,250 | £27,250 | £27,250 | |
| 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 | £10,000 | £10,000 | £20,000 | £34,000 | £58,000 | £75,000 | £50,000 | £35,000 | £70,000 | £85,000 | £90,000 | £55,000 | |
| Direct Cost of Sales | £2,500 | £2,500 | £4,000 | £8,000 | £13,500 | £19,000 | £12,000 | £8,000 | £21,500 | £24,000 | £25,000 | £19,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £2,500 | £2,500 | £4,000 | £8,000 | £13,500 | £19,000 | £12,000 | £8,000 | £21,500 | £24,000 | £25,000 | £19,000 | |
| Gross Margin | £7,500 | £7,500 | £16,000 | £26,000 | £44,500 | £56,000 | £38,000 | £27,000 | £48,500 | £61,000 | £65,000 | £36,000 | |
| Gross Margin % | 75.00% | 75.00% | 80.00% | 76.47% | 76.72% | 74.67% | 76.00% | 77.14% | 69.29% | 71.76% | 72.22% | 65.45% | |
| Expenses | |||||||||||||
| Payroll | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £27,250 | £27,250 | £27,250 | |
| Marketing/Promotion | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | £13,500 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Utilities | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | 0% | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Payroll Taxes | 14% | £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 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £28,800 | £33,800 | £44,050 | £44,050 | £44,050 | |
| Profit Before Interest and Taxes | (£21,300) | (£21,300) | (£12,800) | (£2,800) | £15,700 | £27,200 | £9,200 | (£1,800) | £14,700 | £16,950 | £20,950 | (£8,050) | |
| EBITDA | (£21,300) | (£21,300) | (£12,800) | (£2,800) | £15,700 | £27,200 | £9,200 | (£1,800) | £14,700 | £16,950 | £20,950 | (£8,050) | |
| Interest Expense | £417 | £416 | £583 | £582 | £582 | £665 | £664 | £664 | £663 | £663 | £663 | £662 | |
| Taxes Incurred | (£6,515) | (£6,515) | (£4,015) | (£1,015) | £4,536 | £7,961 | £2,561 | (£739) | £4,211 | £4,886 | £6,086 | (£2,613) | |
| Net Profit | (£15,202) | (£15,201) | (£9,368) | (£2,367) | £10,583 | £18,575 | £5,975 | (£1,725) | £9,826 | £11,401 | £14,201 | (£6,098) | |
| Net Profit/Sales | -152.02% | -152.01% | -46.84% | -6.96% | 18.25% | 24.77% | 11.95% | -4.93% | 14.04% | 13.41% | 15.78% | -11.09% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £5,333 | £10,000 | £15,333 | £27,467 | £46,800 | £67,067 | £61,667 | £42,000 | £53,667 | £78,000 | £87,667 | |
| Subtotal Cash from Operations | £0 | £5,333 | £10,000 | £15,333 | £27,467 | £46,800 | £67,067 | £61,667 | £42,000 | £53,667 | £78,000 | £87,667 | |
| 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 | £20,000 | £0 | £0 | £10,000 | £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 | £50,000 | £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 | £8,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £50,000 | £5,333 | £30,000 | £15,333 | £35,467 | £56,800 | £67,067 | £61,667 | £42,000 | £53,667 | £78,000 | £87,667 | |
| 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 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £17,000 | £27,250 | £27,250 | £27,250 | |
| Bill Payments | £790 | £13,202 | £13,340 | £17,601 | £24,736 | £35,717 | £44,012 | £31,782 | £25,340 | £43,280 | £46,422 | £48,059 | |
| Subtotal Spent on Operations | £12,790 | £25,202 | £25,340 | £29,601 | £36,736 | £47,717 | £56,012 | £43,782 | £42,340 | £70,530 | £73,672 | £75,309 | |
| 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 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £100 | |
| 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 | £12,790 | £25,252 | £25,390 | £29,651 | £36,786 | £47,767 | £56,062 | £43,832 | £42,390 | £70,580 | £73,722 | £75,409 | |
| Net Cash Flow | £37,210 | (£19,918) | £4,610 | (£14,318) | (£1,319) | £9,033 | £11,005 | £17,835 | (£390) | (£16,913) | £4,278 | £12,258 | |
| Cash Balance | £87,560 | £67,642 | £72,251 | £57,934 | £56,615 | £65,647 | £76,652 | £94,487 | £94,097 | £77,184 | £81,462 | £93,719 | |
| 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 | £50,350 | £87,560 | £67,642 | £72,251 | £57,934 | £56,615 | £65,647 | £76,652 | £94,487 | £94,097 | £77,184 | £81,462 | £93,719 |
| Accounts Receivable | £0 | £10,000 | £14,667 | £24,667 | £43,333 | £73,867 | £102,067 | £85,000 | £58,333 | £86,333 | £117,667 | £129,667 | £97,000 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £50,350 | £97,560 | £82,308 | £96,918 | £101,267 | £130,481 | £167,714 | £161,652 | £152,820 | £180,431 | £194,851 | £211,128 | £190,719 |
| 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 | £50,350 | £97,560 | £82,308 | £96,918 | £101,267 | £130,481 | £167,714 | £161,652 | £152,820 | £180,431 | £194,851 | £211,128 | £190,719 |
| 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 | £350 | £12,762 | £12,761 | £16,789 | £23,555 | £34,237 | £42,944 | £30,957 | £23,900 | £41,735 | £44,804 | £46,930 | £32,720 |
| Current Borrowing | £0 | £0 | £0 | £20,000 | £20,000 | £20,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £350 | £12,762 | £12,761 | £36,789 | £43,555 | £54,237 | £72,944 | £60,957 | £53,900 | £71,735 | £74,804 | £76,930 | £62,720 |
| Long-term Liabilities | £0 | £50,000 | £49,950 | £49,900 | £49,850 | £49,800 | £49,750 | £49,700 | £49,650 | £49,600 | £49,550 | £49,500 | £49,400 |
| Total Liabilities | £350 | £62,762 | £62,711 | £86,689 | £93,405 | £104,037 | £122,694 | £110,657 | £103,550 | £121,335 | £124,354 | £126,430 | £112,120 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 | £58,000 |
| Retained Earnings | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Earnings | £0 | (£15,202) | (£30,403) | (£39,771) | (£42,138) | (£31,555) | (£12,981) | (£7,006) | (£8,730) | £1,095 | £12,496 | £26,698 | £20,600 |
| Total Capital | £50,000 | £34,798 | £19,597 | £10,229 | £7,862 | £26,445 | £45,019 | £50,994 | £49,270 | £59,096 | £70,496 | £84,698 | £78,600 |
| Total Liabilities and Capital | £50,350 | £97,560 | £82,308 | £96,918 | £101,267 | £130,481 | £167,714 | £161,652 | £152,820 | £180,431 | £194,851 | £211,128 | £190,719 |
| Net Worth | £50,000 | £34,798 | £19,597 | £10,229 | £7,862 | £26,445 | £45,019 | £50,994 | £49,270 | £59,096 | £70,496 | £84,698 | £78,600 |