| 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 | |||||||||||||
| Malpractice lawsuits | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £5,000 | £7,000 | £7,000 | £9,000 | £9,000 | £9,000 |
| Corporate/business lawsuits | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £9,000 | £11,000 | £13,000 |
| Intellectual property lawsuits | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| General practice lawsuits | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £3,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 |
| Environmental lawsuits | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total Sales | £7,000 | £7,000 | £7,000 | £7,000 | £9,000 | £11,000 | £20,000 | £24,000 | £24,000 | £31,000 | £33,000 | £35,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 | |
| Row 1 | £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 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | ||
| Mr. Radcliffe - President | 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 |
| Mrs. Walters - CFO | 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 |
| Mr. Rinke - Operations Manager | 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 |
| Mr. Orcott - Law Consultant | 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 |
| Computer Forensics Analyst | 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 |
| Computer Forensics Analyst | 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 |
| Computer Forensics Analyst | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Computer Forensics Analyst | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| 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 | £7,000 | £7,000 | £7,000 | £7,000 | £9,000 | £11,000 | £20,000 | £24,000 | £24,000 | £31,000 | £33,000 | £35,000 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Costs of Sales | £500 | £500 | £500 | £500 | £500 | £600 | £700 | £1,000 | £2,000 | £2,000 | £2,000 | £5,000 | |
| Total Cost of Sales | £500 | £500 | £500 | £500 | £500 | £600 | £700 | £1,000 | £2,000 | £2,000 | £2,000 | £5,000 | |
| Gross Margin | £6,500 | £6,500 | £6,500 | £6,500 | £8,500 | £10,400 | £19,300 | £23,000 | £22,000 | £29,000 | £31,000 | £30,000 | |
| Gross Margin % | 92.86% | 92.86% | 92.86% | 92.86% | 94.44% | 94.55% | 96.50% | 95.83% | 91.67% | 93.55% | 93.94% | 85.71% | |
| Expenses | |||||||||||||
| Payroll | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| Sales and Marketing and Other Expenses | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | |
| Travel | £600 | £0 | £600 | £1,000 | £1,000 | £0 | £1,000 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Total Operating Expenses | £25,400 | £24,800 | £25,400 | £25,800 | £25,800 | £24,800 | £25,800 | £24,800 | £25,800 | £25,800 | £25,800 | £25,800 | |
| Profit Before Interest and Taxes | (£18,900) | (£18,300) | (£18,900) | (£19,300) | (£17,300) | (£14,400) | (£6,500) | (£1,800) | (£3,800) | £3,200 | £5,200 | £4,200 | |
| EBITDA | (£18,700) | (£18,100) | (£18,700) | (£19,100) | (£17,100) | (£14,200) | (£6,300) | (£1,600) | (£3,600) | £3,400 | £5,400 | £4,400 | |
| Interest Expense | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£20,317) | (£19,717) | (£20,317) | (£20,717) | (£18,717) | (£15,817) | (£7,917) | (£3,217) | (£5,217) | £1,783 | £3,783 | £2,783 | |
| Net Profit/Sales | -290.24% | -281.67% | -290.24% | -295.95% | -207.96% | -143.79% | -39.58% | -13.40% | -21.74% | 5.75% | 11.46% | 7.95% | |
| 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 | £1,750 | £1,750 | £1,750 | £1,750 | £2,250 | £2,750 | £5,000 | £6,000 | £6,000 | £7,750 | £8,250 | £8,750 | |
| Cash from Receivables | £0 | £175 | £5,250 | £5,250 | £5,250 | £5,300 | £6,800 | £8,475 | £15,100 | £18,000 | £18,175 | £23,300 | |
| Subtotal Cash from Operations | £1,750 | £1,925 | £7,000 | £7,000 | £7,500 | £8,050 | £11,800 | £14,475 | £21,100 | £25,750 | £26,425 | £32,050 | |
| 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 | £1,750 | £1,925 | £7,000 | £7,000 | £7,500 | £8,050 | £11,800 | £14,475 | £21,100 | £25,750 | £26,425 | £32,050 | |
| 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 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| Bill Payments | £44,054 | £9,097 | £8,537 | £9,130 | £9,517 | £9,487 | £8,653 | £9,693 | £9,083 | £11,017 | £11,017 | £11,117 | |
| Subtotal Spent on Operations | £62,054 | £27,097 | £26,537 | £27,130 | £27,517 | £27,487 | £26,653 | £27,693 | £27,083 | £29,017 | £29,017 | £29,117 | |
| 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 | £62,054 | £27,097 | £26,537 | £27,130 | £27,517 | £27,487 | £26,653 | £27,693 | £27,083 | £29,017 | £29,017 | £29,117 | |
| Net Cash Flow | (£60,304) | (£25,172) | (£19,537) | (£20,130) | (£20,017) | (£19,437) | (£14,853) | (£13,218) | (£5,983) | (£3,267) | (£2,592) | £2,933 | |
| Cash Balance | £281,246 | £256,074 | £236,538 | £216,408 | £196,391 | £176,954 | £162,101 | £148,883 | £142,899 | £139,633 | £137,041 | £139,974 | |
| 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 | £341,550 | £281,246 | £256,074 | £236,538 | £216,408 | £196,391 | £176,954 | £162,101 | £148,883 | £142,899 | £139,633 | £137,041 | £139,974 |
| Accounts Receivable | £0 | £5,250 | £10,325 | £10,325 | £10,325 | £11,825 | £14,775 | £22,975 | £32,500 | £35,400 | £40,650 | £47,225 | £50,175 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £341,550 | £286,496 | £266,399 | £246,863 | £226,733 | £208,216 | £191,729 | £185,076 | £181,383 | £178,299 | £180,283 | £184,266 | £190,149 |
| 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 | £200 | £400 | £600 | £800 | £1,000 | £1,200 | £1,400 | £1,600 | £1,800 | £2,000 | £2,200 | £2,400 |
| Total Long-term Assets | £128,000 | £127,800 | £127,600 | £127,400 | £127,200 | £127,000 | £126,800 | £126,600 | £126,400 | £126,200 | £126,000 | £125,800 | £125,600 |
| Total Assets | £469,550 | £414,296 | £393,999 | £374,263 | £353,933 | £335,216 | £318,529 | £311,676 | £307,783 | £304,499 | £306,283 | £310,066 | £315,749 |
| 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 | £43,750 | £8,813 | £8,233 | £8,813 | £9,199 | £9,199 | £8,329 | £9,393 | £8,716 | £10,649 | £10,649 | £10,649 | £13,549 |
| Current Borrowing | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £93,750 | £58,813 | £58,233 | £58,813 | £59,199 | £59,199 | £58,329 | £59,393 | £58,716 | £60,649 | £60,649 | £60,649 | £63,549 |
| Long-term Liabilities | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 |
| Total Liabilities | £213,750 | £178,813 | £178,233 | £178,813 | £179,199 | £179,199 | £178,329 | £179,393 | £178,716 | £180,649 | £180,649 | £180,649 | £183,549 |
| Paid-in Capital | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 |
| Retained Earnings | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) |
| Earnings | £0 | (£20,317) | (£40,033) | (£60,350) | (£81,067) | (£99,783) | (£115,600) | (£123,517) | (£126,733) | (£131,950) | (£130,167) | (£126,383) | (£123,600) |
| Total Capital | £255,800 | £235,483 | £215,767 | £195,450 | £174,733 | £156,017 | £140,200 | £132,283 | £129,067 | £123,850 | £125,633 | £129,417 | £132,200 |
| Total Liabilities and Capital | £469,550 | £414,296 | £393,999 | £374,263 | £353,933 | £335,216 | £318,529 | £311,676 | £307,783 | £304,499 | £306,283 | £310,066 | £315,749 |
| Net Worth | £255,800 | £235,483 | £215,767 | £195,450 | £174,733 | £156,017 | £140,200 | £132,283 | £129,067 | £123,850 | £125,633 | £129,417 | £132,200 |
| 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 | |||||||||||||
| Malpractice lawsuits | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £5,000 | £7,000 | £7,000 | £9,000 | £9,000 | £9,000 |
| Corporate/business lawsuits | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £9,000 | £11,000 | £13,000 |
| Intellectual property lawsuits | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| General practice lawsuits | 0% | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £3,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 |
| Environmental lawsuits | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £5,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total Sales | £7,000 | £7,000 | £7,000 | £7,000 | £9,000 | £11,000 | £20,000 | £24,000 | £24,000 | £31,000 | £33,000 | £35,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 | |
| Row 1 | £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 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | ||
| Mr. Radcliffe - President | 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 |
| Mrs. Walters - CFO | 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 |
| Mr. Rinke - Operations Manager | 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 |
| Mr. Orcott - Law Consultant | 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 |
| Computer Forensics Analyst | 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 |
| Computer Forensics Analyst | 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 |
| Computer Forensics Analyst | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Computer Forensics Analyst | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| 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 | £7,000 | £7,000 | £7,000 | £7,000 | £9,000 | £11,000 | £20,000 | £24,000 | £24,000 | £31,000 | £33,000 | £35,000 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Costs of Sales | £500 | £500 | £500 | £500 | £500 | £600 | £700 | £1,000 | £2,000 | £2,000 | £2,000 | £5,000 | |
| Total Cost of Sales | £500 | £500 | £500 | £500 | £500 | £600 | £700 | £1,000 | £2,000 | £2,000 | £2,000 | £5,000 | |
| Gross Margin | £6,500 | £6,500 | £6,500 | £6,500 | £8,500 | £10,400 | £19,300 | £23,000 | £22,000 | £29,000 | £31,000 | £30,000 | |
| Gross Margin % | 92.86% | 92.86% | 92.86% | 92.86% | 94.44% | 94.55% | 96.50% | 95.83% | 91.67% | 93.55% | 93.94% | 85.71% | |
| Expenses | |||||||||||||
| Payroll | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| Sales and Marketing and Other Expenses | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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 | |
| Travel | £600 | £0 | £600 | £1,000 | £1,000 | £0 | £1,000 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Total Operating Expenses | £25,400 | £24,800 | £25,400 | £25,800 | £25,800 | £24,800 | £25,800 | £24,800 | £25,800 | £25,800 | £25,800 | £25,800 | |
| Profit Before Interest and Taxes | (£18,900) | (£18,300) | (£18,900) | (£19,300) | (£17,300) | (£14,400) | (£6,500) | (£1,800) | (£3,800) | £3,200 | £5,200 | £4,200 | |
| EBITDA | (£18,700) | (£18,100) | (£18,700) | (£19,100) | (£17,100) | (£14,200) | (£6,300) | (£1,600) | (£3,600) | £3,400 | £5,400 | £4,400 | |
| Interest Expense | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | £1,417 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£20,317) | (£19,717) | (£20,317) | (£20,717) | (£18,717) | (£15,817) | (£7,917) | (£3,217) | (£5,217) | £1,783 | £3,783 | £2,783 | |
| Net Profit/Sales | -290.24% | -281.67% | -290.24% | -295.95% | -207.96% | -143.79% | -39.58% | -13.40% | -21.74% | 5.75% | 11.46% | 7.95% | |
| 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 | £1,750 | £1,750 | £1,750 | £1,750 | £2,250 | £2,750 | £5,000 | £6,000 | £6,000 | £7,750 | £8,250 | £8,750 | |
| Cash from Receivables | £0 | £175 | £5,250 | £5,250 | £5,250 | £5,300 | £6,800 | £8,475 | £15,100 | £18,000 | £18,175 | £23,300 | |
| Subtotal Cash from Operations | £1,750 | £1,925 | £7,000 | £7,000 | £7,500 | £8,050 | £11,800 | £14,475 | £21,100 | £25,750 | £26,425 | £32,050 | |
| 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 | £1,750 | £1,925 | £7,000 | £7,000 | £7,500 | £8,050 | £11,800 | £14,475 | £21,100 | £25,750 | £26,425 | £32,050 | |
| 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 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| Bill Payments | £44,054 | £9,097 | £8,537 | £9,130 | £9,517 | £9,487 | £8,653 | £9,693 | £9,083 | £11,017 | £11,017 | £11,117 | |
| Subtotal Spent on Operations | £62,054 | £27,097 | £26,537 | £27,130 | £27,517 | £27,487 | £26,653 | £27,693 | £27,083 | £29,017 | £29,017 | £29,117 | |
| 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 | £62,054 | £27,097 | £26,537 | £27,130 | £27,517 | £27,487 | £26,653 | £27,693 | £27,083 | £29,017 | £29,017 | £29,117 | |
| Net Cash Flow | (£60,304) | (£25,172) | (£19,537) | (£20,130) | (£20,017) | (£19,437) | (£14,853) | (£13,218) | (£5,983) | (£3,267) | (£2,592) | £2,933 | |
| Cash Balance | £281,246 | £256,074 | £236,538 | £216,408 | £196,391 | £176,954 | £162,101 | £148,883 | £142,899 | £139,633 | £137,041 | £139,974 | |
| 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 | £341,550 | £281,246 | £256,074 | £236,538 | £216,408 | £196,391 | £176,954 | £162,101 | £148,883 | £142,899 | £139,633 | £137,041 | £139,974 |
| Accounts Receivable | £0 | £5,250 | £10,325 | £10,325 | £10,325 | £11,825 | £14,775 | £22,975 | £32,500 | £35,400 | £40,650 | £47,225 | £50,175 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £341,550 | £286,496 | £266,399 | £246,863 | £226,733 | £208,216 | £191,729 | £185,076 | £181,383 | £178,299 | £180,283 | £184,266 | £190,149 |
| 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 | £200 | £400 | £600 | £800 | £1,000 | £1,200 | £1,400 | £1,600 | £1,800 | £2,000 | £2,200 | £2,400 |
| Total Long-term Assets | £128,000 | £127,800 | £127,600 | £127,400 | £127,200 | £127,000 | £126,800 | £126,600 | £126,400 | £126,200 | £126,000 | £125,800 | £125,600 |
| Total Assets | £469,550 | £414,296 | £393,999 | £374,263 | £353,933 | £335,216 | £318,529 | £311,676 | £307,783 | £304,499 | £306,283 | £310,066 | £315,749 |
| 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 | £43,750 | £8,813 | £8,233 | £8,813 | £9,199 | £9,199 | £8,329 | £9,393 | £8,716 | £10,649 | £10,649 | £10,649 | £13,549 |
| Current Borrowing | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £93,750 | £58,813 | £58,233 | £58,813 | £59,199 | £59,199 | £58,329 | £59,393 | £58,716 | £60,649 | £60,649 | £60,649 | £63,549 |
| Long-term Liabilities | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 | £120,000 |
| Total Liabilities | £213,750 | £178,813 | £178,233 | £178,813 | £179,199 | £179,199 | £178,329 | £179,393 | £178,716 | £180,649 | £180,649 | £180,649 | £183,549 |
| Paid-in Capital | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 | £297,000 |
| Retained Earnings | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) | (£41,200) |
| Earnings | £0 | (£20,317) | (£40,033) | (£60,350) | (£81,067) | (£99,783) | (£115,600) | (£123,517) | (£126,733) | (£131,950) | (£130,167) | (£126,383) | (£123,600) |
| Total Capital | £255,800 | £235,483 | £215,767 | £195,450 | £174,733 | £156,017 | £140,200 | £132,283 | £129,067 | £123,850 | £125,633 | £129,417 | £132,200 |
| Total Liabilities and Capital | £469,550 | £414,296 | £393,999 | £374,263 | £353,933 | £335,216 | £318,529 | £311,676 | £307,783 | £304,499 | £306,283 | £310,066 | £315,749 |
| Net Worth | £255,800 | £235,483 | £215,767 | £195,450 | £174,733 | £156,017 | £140,200 | £132,283 | £129,067 | £123,850 | £125,633 | £129,417 | £132,200 |