| 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 | |||||||||||||
| Large companies | 0% | £0 | £0 | £1,874 | £1,997 | £4,587 | £4,998 | £5,354 | £6,874 | £7,445 | £7,963 | £8,547 | £9,125 |
| Small companies | 0% | £0 | £0 | £1,255 | £1,458 | £2,547 | £2,754 | £2,914 | £3,874 | £4,554 | £4,998 | £5,347 | £5,901 |
| Total Sales | £0 | £0 | £3,129 | £3,455 | £7,134 | £7,752 | £8,268 | £10,748 | £11,999 | £12,961 | £13,894 | £15,026 | |
| 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 | |
| Large companies | £0 | £0 | £321 | £384 | £1,125 | £1,321 | £1,478 | £1,848 | £2,114 | £2,325 | £2,400 | £2,564 | |
| Small companies | £0 | £0 | £121 | £214 | £457 | £554 | £658 | £854 | £1,010 | £1,121 | £1,145 | £1,300 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £442 | £598 | £1,582 | £1,875 | £2,136 | £2,702 | £3,124 | £3,446 | £3,545 | £3,864 | |
| 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 | ||
| Jeff | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| secretary/ receptionist | 0% | £0 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| account manager | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,000 | £3,700 | £3,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | |
| 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 | £0 | £0 | £3,129 | £3,455 | £7,134 | £7,752 | £8,268 | £10,748 | £11,999 | £12,961 | £13,894 | £15,026 | |
| Direct Cost of Sales | £0 | £0 | £442 | £598 | £1,582 | £1,875 | £2,136 | £2,702 | £3,124 | £3,446 | £3,545 | £3,864 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £442 | £598 | £1,582 | £1,875 | £2,136 | £2,702 | £3,124 | £3,446 | £3,545 | £3,864 | |
| Gross Margin | £0 | £0 | £2,687 | £2,857 | £5,552 | £5,877 | £6,132 | £8,046 | £8,875 | £9,515 | £10,349 | £11,162 | |
| Gross Margin % | 0.00% | 0.00% | 85.87% | 82.69% | 77.82% | 75.81% | 74.17% | 74.86% | 73.96% | 73.41% | 74.49% | 74.28% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £3,700 | £3,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | |
| Sales and Marketing and Other Expenses | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Depreciation | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | 15% | £300 | £555 | £555 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,939 | £5,994 | £5,994 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | |
| Profit Before Interest and Taxes | (£3,939) | (£5,994) | (£3,307) | (£5,587) | (£2,892) | (£2,567) | (£2,312) | (£398) | £431 | £1,071 | £1,905 | £2,718 | |
| EBITDA | (£3,800) | (£5,855) | (£3,168) | (£5,448) | (£2,753) | (£2,428) | (£2,173) | (£259) | £570 | £1,210 | £2,044 | £2,857 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,939) | (£5,994) | (£3,307) | (£5,587) | (£2,892) | (£2,567) | (£2,312) | (£398) | £431 | £1,071 | £1,905 | £2,718 | |
| Net Profit/Sales | 0.00% | 0.00% | -105.69% | -161.71% | -40.54% | -33.11% | -27.96% | -3.70% | 3.59% | 8.26% | 13.71% | 18.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 | £782 | £864 | £1,784 | £1,938 | £2,067 | £2,687 | £3,000 | £3,240 | £3,474 | £3,757 | |
| Cash from Receivables | £0 | £0 | £0 | £78 | £2,355 | £2,683 | £5,366 | £5,827 | £6,263 | £8,092 | £9,023 | £9,744 | |
| Subtotal Cash from Operations | £0 | £0 | £782 | £942 | £4,138 | £4,621 | £7,433 | £8,514 | £9,263 | £11,333 | £12,497 | £13,501 | |
| 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 | £4,000 | £0 | £8,000 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £782 | £942 | £4,138 | £4,621 | £7,433 | £12,514 | £9,263 | £19,333 | £12,497 | £13,501 | |
| 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 | £2,000 | £3,700 | £3,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | |
| Bill Payments | £60 | £1,812 | £2,188 | £3,170 | £3,650 | £4,962 | £4,810 | £5,058 | £5,938 | £6,200 | £6,400 | £6,278 | |
| Subtotal Spent on Operations | £2,060 | £5,512 | £5,888 | £8,870 | £9,350 | £10,662 | £10,510 | £10,758 | £11,638 | £11,900 | £12,100 | £11,978 | |
| 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 | £2,060 | £5,512 | £5,888 | £8,870 | £9,350 | £10,662 | £10,510 | £10,758 | £11,638 | £11,900 | £12,100 | £11,978 | |
| Net Cash Flow | (£2,060) | (£5,512) | (£5,106) | (£7,928) | (£5,212) | (£6,040) | (£3,077) | £1,756 | (£2,376) | £7,432 | £396 | £1,523 | |
| Cash Balance | £39,540 | £34,028 | £28,922 | £20,994 | £15,782 | £9,742 | £6,665 | £8,420 | £6,045 | £13,477 | £13,874 | £15,397 | |
| 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 | £41,600 | £39,540 | £34,028 | £28,922 | £20,994 | £15,782 | £9,742 | £6,665 | £8,420 | £6,045 | £13,477 | £13,874 | £15,397 |
| Accounts Receivable | £0 | £0 | £0 | £2,347 | £4,860 | £7,855 | £10,986 | £11,821 | £14,055 | £16,792 | £18,420 | £19,817 | £21,343 |
| Inventory | £0 | £0 | £0 | £558 | £960 | £1,740 | £2,063 | £2,350 | £2,972 | £3,436 | £3,791 | £3,900 | £4,250 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £41,600 | £39,540 | £34,028 | £31,827 | £26,814 | £25,378 | £22,790 | £20,835 | £25,448 | £26,273 | £35,688 | £37,590 | £40,990 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Accumulated Depreciation | £0 | £139 | £278 | £417 | £556 | £695 | £834 | £973 | £1,112 | £1,251 | £1,390 | £1,529 | £1,668 |
| Total Long-term Assets | £5,000 | £4,861 | £4,722 | £4,583 | £4,444 | £4,305 | £4,166 | £4,027 | £3,888 | £3,749 | £3,610 | £3,471 | £3,332 |
| Total Assets | £46,600 | £44,401 | £38,750 | £36,410 | £31,258 | £29,683 | £26,956 | £24,862 | £29,336 | £30,022 | £39,298 | £41,061 | £44,322 |
| 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 | £1,740 | £2,083 | £3,050 | £3,485 | £4,802 | £4,642 | £4,860 | £5,732 | £5,987 | £6,192 | £6,050 | £6,593 |
| 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 | £1,740 | £2,083 | £3,050 | £3,485 | £4,802 | £4,642 | £4,860 | £5,732 | £5,987 | £6,192 | £6,050 | £6,593 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,740 | £2,083 | £3,050 | £3,485 | £4,802 | £4,642 | £4,860 | £5,732 | £5,987 | £6,192 | £6,050 | £6,593 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £54,000 | £54,000 | £62,000 | £62,000 | £62,000 |
| Retained Earnings | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) |
| Earnings | £0 | (£3,939) | (£9,933) | (£13,240) | (£18,827) | (£21,719) | (£24,286) | (£26,598) | (£26,996) | (£26,565) | (£25,494) | (£23,589) | (£20,871) |
| Total Capital | £46,600 | £42,661 | £36,667 | £33,360 | £27,773 | £24,881 | £22,314 | £20,002 | £23,604 | £24,035 | £33,106 | £35,011 | £37,729 |
| Total Liabilities and Capital | £46,600 | £44,401 | £38,750 | £36,410 | £31,258 | £29,683 | £26,956 | £24,862 | £29,336 | £30,022 | £39,298 | £41,061 | £44,322 |
| Net Worth | £46,600 | £42,661 | £36,667 | £33,360 | £27,773 | £24,881 | £22,314 | £20,002 | £23,604 | £24,035 | £33,106 | £35,011 | £37,729 |
| 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 | |||||||||||||
| Large companies | 0% | £0 | £0 | £1,874 | £1,997 | £4,587 | £4,998 | £5,354 | £6,874 | £7,445 | £7,963 | £8,547 | £9,125 |
| Small companies | 0% | £0 | £0 | £1,255 | £1,458 | £2,547 | £2,754 | £2,914 | £3,874 | £4,554 | £4,998 | £5,347 | £5,901 |
| Total Sales | £0 | £0 | £3,129 | £3,455 | £7,134 | £7,752 | £8,268 | £10,748 | £11,999 | £12,961 | £13,894 | £15,026 | |
| 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 | |
| Large companies | £0 | £0 | £321 | £384 | £1,125 | £1,321 | £1,478 | £1,848 | £2,114 | £2,325 | £2,400 | £2,564 | |
| Small companies | £0 | £0 | £121 | £214 | £457 | £554 | £658 | £854 | £1,010 | £1,121 | £1,145 | £1,300 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £442 | £598 | £1,582 | £1,875 | £2,136 | £2,702 | £3,124 | £3,446 | £3,545 | £3,864 | |
| 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 | ||
| Jeff | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| secretary/ receptionist | 0% | £0 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 | £1,700 |
| account manager | 0% | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 1 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | £2,000 | £3,700 | £3,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | |
| 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 | £0 | £0 | £3,129 | £3,455 | £7,134 | £7,752 | £8,268 | £10,748 | £11,999 | £12,961 | £13,894 | £15,026 | |
| Direct Cost of Sales | £0 | £0 | £442 | £598 | £1,582 | £1,875 | £2,136 | £2,702 | £3,124 | £3,446 | £3,545 | £3,864 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £442 | £598 | £1,582 | £1,875 | £2,136 | £2,702 | £3,124 | £3,446 | £3,545 | £3,864 | |
| Gross Margin | £0 | £0 | £2,687 | £2,857 | £5,552 | £5,877 | £6,132 | £8,046 | £8,875 | £9,515 | £10,349 | £11,162 | |
| Gross Margin % | 0.00% | 0.00% | 85.87% | 82.69% | 77.82% | 75.81% | 74.17% | 74.86% | 73.96% | 73.41% | 74.49% | 74.28% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £3,700 | £3,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | |
| Sales and Marketing and Other Expenses | £0 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Depreciation | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | £139 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| 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 | 15% | £300 | £555 | £555 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 | £1,005 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,939 | £5,994 | £5,994 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | £8,444 | |
| Profit Before Interest and Taxes | (£3,939) | (£5,994) | (£3,307) | (£5,587) | (£2,892) | (£2,567) | (£2,312) | (£398) | £431 | £1,071 | £1,905 | £2,718 | |
| EBITDA | (£3,800) | (£5,855) | (£3,168) | (£5,448) | (£2,753) | (£2,428) | (£2,173) | (£259) | £570 | £1,210 | £2,044 | £2,857 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,939) | (£5,994) | (£3,307) | (£5,587) | (£2,892) | (£2,567) | (£2,312) | (£398) | £431 | £1,071 | £1,905 | £2,718 | |
| Net Profit/Sales | 0.00% | 0.00% | -105.69% | -161.71% | -40.54% | -33.11% | -27.96% | -3.70% | 3.59% | 8.26% | 13.71% | 18.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 | £782 | £864 | £1,784 | £1,938 | £2,067 | £2,687 | £3,000 | £3,240 | £3,474 | £3,757 | |
| Cash from Receivables | £0 | £0 | £0 | £78 | £2,355 | £2,683 | £5,366 | £5,827 | £6,263 | £8,092 | £9,023 | £9,744 | |
| Subtotal Cash from Operations | £0 | £0 | £782 | £942 | £4,138 | £4,621 | £7,433 | £8,514 | £9,263 | £11,333 | £12,497 | £13,501 | |
| 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 | £4,000 | £0 | £8,000 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £782 | £942 | £4,138 | £4,621 | £7,433 | £12,514 | £9,263 | £19,333 | £12,497 | £13,501 | |
| 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 | £2,000 | £3,700 | £3,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | £5,700 | |
| Bill Payments | £60 | £1,812 | £2,188 | £3,170 | £3,650 | £4,962 | £4,810 | £5,058 | £5,938 | £6,200 | £6,400 | £6,278 | |
| Subtotal Spent on Operations | £2,060 | £5,512 | £5,888 | £8,870 | £9,350 | £10,662 | £10,510 | £10,758 | £11,638 | £11,900 | £12,100 | £11,978 | |
| 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 | £2,060 | £5,512 | £5,888 | £8,870 | £9,350 | £10,662 | £10,510 | £10,758 | £11,638 | £11,900 | £12,100 | £11,978 | |
| Net Cash Flow | (£2,060) | (£5,512) | (£5,106) | (£7,928) | (£5,212) | (£6,040) | (£3,077) | £1,756 | (£2,376) | £7,432 | £396 | £1,523 | |
| Cash Balance | £39,540 | £34,028 | £28,922 | £20,994 | £15,782 | £9,742 | £6,665 | £8,420 | £6,045 | £13,477 | £13,874 | £15,397 | |
| 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 | £41,600 | £39,540 | £34,028 | £28,922 | £20,994 | £15,782 | £9,742 | £6,665 | £8,420 | £6,045 | £13,477 | £13,874 | £15,397 |
| Accounts Receivable | £0 | £0 | £0 | £2,347 | £4,860 | £7,855 | £10,986 | £11,821 | £14,055 | £16,792 | £18,420 | £19,817 | £21,343 |
| Inventory | £0 | £0 | £0 | £558 | £960 | £1,740 | £2,063 | £2,350 | £2,972 | £3,436 | £3,791 | £3,900 | £4,250 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £41,600 | £39,540 | £34,028 | £31,827 | £26,814 | £25,378 | £22,790 | £20,835 | £25,448 | £26,273 | £35,688 | £37,590 | £40,990 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Accumulated Depreciation | £0 | £139 | £278 | £417 | £556 | £695 | £834 | £973 | £1,112 | £1,251 | £1,390 | £1,529 | £1,668 |
| Total Long-term Assets | £5,000 | £4,861 | £4,722 | £4,583 | £4,444 | £4,305 | £4,166 | £4,027 | £3,888 | £3,749 | £3,610 | £3,471 | £3,332 |
| Total Assets | £46,600 | £44,401 | £38,750 | £36,410 | £31,258 | £29,683 | £26,956 | £24,862 | £29,336 | £30,022 | £39,298 | £41,061 | £44,322 |
| 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 | £1,740 | £2,083 | £3,050 | £3,485 | £4,802 | £4,642 | £4,860 | £5,732 | £5,987 | £6,192 | £6,050 | £6,593 |
| 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 | £1,740 | £2,083 | £3,050 | £3,485 | £4,802 | £4,642 | £4,860 | £5,732 | £5,987 | £6,192 | £6,050 | £6,593 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,740 | £2,083 | £3,050 | £3,485 | £4,802 | £4,642 | £4,860 | £5,732 | £5,987 | £6,192 | £6,050 | £6,593 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £54,000 | £54,000 | £62,000 | £62,000 | £62,000 |
| Retained Earnings | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) | (£3,400) |
| Earnings | £0 | (£3,939) | (£9,933) | (£13,240) | (£18,827) | (£21,719) | (£24,286) | (£26,598) | (£26,996) | (£26,565) | (£25,494) | (£23,589) | (£20,871) |
| Total Capital | £46,600 | £42,661 | £36,667 | £33,360 | £27,773 | £24,881 | £22,314 | £20,002 | £23,604 | £24,035 | £33,106 | £35,011 | £37,729 |
| Total Liabilities and Capital | £46,600 | £44,401 | £38,750 | £36,410 | £31,258 | £29,683 | £26,956 | £24,862 | £29,336 | £30,022 | £39,298 | £41,061 | £44,322 |
| Net Worth | £46,600 | £42,661 | £36,667 | £33,360 | £27,773 | £24,881 | £22,314 | £20,002 | £23,604 | £24,035 | £33,106 | £35,011 | £37,729 |