| 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 | |||||||||||||
| Total Revenue | 0% | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,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 | |
| Total Costs | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,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 | ||
| Bree Sallee | 0% | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Other | 0% | £0 | £0 | £560 | £560 | £560 | £560 | £0 | £0 | £0 | £0 | £560 | £560 |
| Cashier 1 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Cashier 2 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Cashier 3 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Cashier 4 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Total People | 5 | 5 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 5 | 6 | 6 | |
| Total Payroll | £3,840 | £3,840 | £4,400 | £4,400 | £4,400 | £4,400 | £3,840 | £3,840 | £3,840 | £3,840 | £4,400 | £4,400 | |
| 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 | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| Direct Cost of Sales | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | |
| Gross Margin | £4,500 | £8,000 | £10,500 | £13,000 | £12,500 | £12,000 | £10,500 | £8,000 | £8,000 | £9,000 | £11,000 | £12,000 | |
| Gross Margin % | 36.00% | 50.00% | 56.76% | 59.09% | 58.14% | 60.00% | 56.76% | 50.00% | 50.00% | 52.94% | 57.89% | 57.14% | |
| Expenses | |||||||||||||
| Payroll | £3,840 | £3,840 | £4,400 | £4,400 | £4,400 | £4,400 | £3,840 | £3,840 | £3,840 | £3,840 | £4,400 | £4,400 | |
| Sales and Marketing and Other Expenses | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £576 | £576 | £660 | £660 | £660 | £660 | £576 | £576 | £576 | £576 | £660 | £660 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £6,722 | £6,722 | £7,366 | £7,366 | £7,366 | £7,366 | £6,722 | £6,722 | £6,722 | £6,722 | £7,366 | £7,366 | |
| Profit Before Interest and Taxes | (£2,222) | £1,278 | £3,134 | £5,634 | £5,134 | £4,634 | £3,778 | £1,278 | £1,278 | £2,278 | £3,634 | £4,634 | |
| EBITDA | (£2,222) | £1,278 | £3,134 | £5,634 | £5,134 | £4,634 | £3,778 | £1,278 | £1,278 | £2,278 | £3,634 | £4,634 | |
| Interest Expense | £408 | £399 | £391 | £382 | £373 | £365 | £356 | £347 | £339 | £330 | £321 | £313 | |
| Taxes Incurred | (£789) | £220 | £686 | £1,313 | £1,190 | £1,067 | £856 | £233 | £235 | £487 | £828 | £1,080 | |
| Net Profit | (£1,841) | £659 | £2,058 | £3,939 | £3,571 | £3,202 | £2,567 | £698 | £705 | £1,461 | £2,485 | £3,241 | |
| Net Profit/Sales | -14.73% | 4.12% | 11.12% | 17.90% | 16.61% | 16.01% | 13.87% | 4.36% | 4.40% | 8.59% | 13.08% | 15.43% | |
| 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 | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| Subtotal Cash from Operations | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| 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 | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| 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 | £3,840 | £3,840 | £4,400 | £4,400 | £4,400 | £4,400 | £3,840 | £3,840 | £3,840 | £3,840 | £4,400 | £4,400 | |
| Bill Payments | £83 | £2,534 | £3,519 | £4,293 | £11,627 | £13,455 | £11,324 | £12,072 | £11,462 | £11,464 | £11,713 | £12,193 | |
| Subtotal Spent on Operations | £3,923 | £6,374 | £7,919 | £8,693 | £16,027 | £17,855 | £15,164 | £15,912 | £15,302 | £15,304 | £16,113 | £16,593 | |
| 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 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,041 | £1,041 | £1,041 | £1,041 | |
| 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 | £4,965 | £7,416 | £8,961 | £9,735 | £17,069 | £18,897 | £16,206 | £16,954 | £16,343 | £16,345 | £17,154 | £17,634 | |
| Net Cash Flow | £7,535 | £8,584 | £9,539 | £12,265 | £4,431 | £1,103 | £2,294 | (£954) | (£343) | £655 | £1,846 | £3,366 | |
| Cash Balance | £10,035 | £18,618 | £28,157 | £40,422 | £44,854 | £45,957 | £48,250 | £47,296 | £46,953 | £47,609 | £49,455 | £52,820 | |
| 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 | £2,500 | £10,035 | £18,618 | £28,157 | £40,422 | £44,854 | £45,957 | £48,250 | £47,296 | £46,953 | £47,609 | £49,455 | £52,820 |
| Inventory | £36,000 | £28,000 | £20,000 | £12,000 | £9,900 | £9,900 | £8,800 | £8,800 | £8,800 | £8,800 | £8,800 | £8,800 | £9,900 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £38,500 | £38,035 | £38,618 | £40,157 | £50,322 | £54,754 | £54,757 | £57,050 | £56,096 | £55,753 | £56,409 | £58,255 | £62,720 |
| 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 | £38,500 | £38,035 | £38,618 | £40,157 | £50,322 | £54,754 | £54,757 | £57,050 | £56,096 | £55,753 | £56,409 | £58,255 | £62,720 |
| 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 | £2,418 | £3,384 | £3,908 | £11,176 | £13,078 | £10,921 | £11,690 | £11,080 | £11,074 | £11,309 | £11,712 | £13,977 |
| Current Borrowing | £50,000 | £48,958 | £47,916 | £46,874 | £45,832 | £44,790 | £43,748 | £42,706 | £41,664 | £40,623 | £39,582 | £38,541 | £37,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £50,000 | £51,376 | £51,300 | £50,782 | £57,008 | £57,868 | £54,669 | £54,396 | £52,744 | £51,697 | £50,891 | £50,253 | £51,477 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £50,000 | £51,376 | £51,300 | £50,782 | £57,008 | £57,868 | £54,669 | £54,396 | £52,744 | £51,697 | £50,891 | £50,253 | £51,477 |
| Paid-in Capital | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 |
| Retained Earnings | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) |
| Earnings | £0 | (£1,841) | (£1,182) | £876 | £4,815 | £8,385 | £11,587 | £14,154 | £14,852 | £15,557 | £17,018 | £19,502 | £22,743 |
| Total Capital | (£11,500) | (£13,341) | (£12,682) | (£10,624) | (£6,685) | (£3,115) | £87 | £2,654 | £3,352 | £4,057 | £5,518 | £8,002 | £11,243 |
| Total Liabilities and Capital | £38,500 | £38,035 | £38,618 | £40,157 | £50,322 | £54,754 | £54,757 | £57,050 | £56,096 | £55,753 | £56,409 | £58,255 | £62,720 |
| Net Worth | (£11,500) | (£13,341) | (£12,682) | (£10,624) | (£6,685) | (£3,115) | £87 | £2,654 | £3,352 | £4,057 | £5,518 | £8,002 | £11,243 |
| 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 | |||||||||||||
| Total Revenue | 0% | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,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 | |
| Total Costs | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,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 | ||
| Bree Sallee | 0% | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Other | 0% | £0 | £0 | £560 | £560 | £560 | £560 | £0 | £0 | £0 | £0 | £560 | £560 |
| Cashier 1 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Cashier 2 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Cashier 3 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Cashier 4 | 0% | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 | £560 |
| Total People | 5 | 5 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 5 | 6 | 6 | |
| Total Payroll | £3,840 | £3,840 | £4,400 | £4,400 | £4,400 | £4,400 | £3,840 | £3,840 | £3,840 | £3,840 | £4,400 | £4,400 | |
| 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 | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| Direct Cost of Sales | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £8,000 | £8,000 | £8,000 | £9,000 | £9,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £9,000 | |
| Gross Margin | £4,500 | £8,000 | £10,500 | £13,000 | £12,500 | £12,000 | £10,500 | £8,000 | £8,000 | £9,000 | £11,000 | £12,000 | |
| Gross Margin % | 36.00% | 50.00% | 56.76% | 59.09% | 58.14% | 60.00% | 56.76% | 50.00% | 50.00% | 52.94% | 57.89% | 57.14% | |
| Expenses | |||||||||||||
| Payroll | £3,840 | £3,840 | £4,400 | £4,400 | £4,400 | £4,400 | £3,840 | £3,840 | £3,840 | £3,840 | £4,400 | £4,400 | |
| Sales and Marketing and Other Expenses | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | £381 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | £425 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £576 | £576 | £660 | £660 | £660 | £660 | £576 | £576 | £576 | £576 | £660 | £660 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £6,722 | £6,722 | £7,366 | £7,366 | £7,366 | £7,366 | £6,722 | £6,722 | £6,722 | £6,722 | £7,366 | £7,366 | |
| Profit Before Interest and Taxes | (£2,222) | £1,278 | £3,134 | £5,634 | £5,134 | £4,634 | £3,778 | £1,278 | £1,278 | £2,278 | £3,634 | £4,634 | |
| EBITDA | (£2,222) | £1,278 | £3,134 | £5,634 | £5,134 | £4,634 | £3,778 | £1,278 | £1,278 | £2,278 | £3,634 | £4,634 | |
| Interest Expense | £408 | £399 | £391 | £382 | £373 | £365 | £356 | £347 | £339 | £330 | £321 | £313 | |
| Taxes Incurred | (£789) | £220 | £686 | £1,313 | £1,190 | £1,067 | £856 | £233 | £235 | £487 | £828 | £1,080 | |
| Net Profit | (£1,841) | £659 | £2,058 | £3,939 | £3,571 | £3,202 | £2,567 | £698 | £705 | £1,461 | £2,485 | £3,241 | |
| Net Profit/Sales | -14.73% | 4.12% | 11.12% | 17.90% | 16.61% | 16.01% | 13.87% | 4.36% | 4.40% | 8.59% | 13.08% | 15.43% | |
| 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 | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| Subtotal Cash from Operations | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| 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 | £12,500 | £16,000 | £18,500 | £22,000 | £21,500 | £20,000 | £18,500 | £16,000 | £16,000 | £17,000 | £19,000 | £21,000 | |
| 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 | £3,840 | £3,840 | £4,400 | £4,400 | £4,400 | £4,400 | £3,840 | £3,840 | £3,840 | £3,840 | £4,400 | £4,400 | |
| Bill Payments | £83 | £2,534 | £3,519 | £4,293 | £11,627 | £13,455 | £11,324 | £12,072 | £11,462 | £11,464 | £11,713 | £12,193 | |
| Subtotal Spent on Operations | £3,923 | £6,374 | £7,919 | £8,693 | £16,027 | £17,855 | £15,164 | £15,912 | £15,302 | £15,304 | £16,113 | £16,593 | |
| 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 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,042 | £1,041 | £1,041 | £1,041 | £1,041 | |
| 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 | £4,965 | £7,416 | £8,961 | £9,735 | £17,069 | £18,897 | £16,206 | £16,954 | £16,343 | £16,345 | £17,154 | £17,634 | |
| Net Cash Flow | £7,535 | £8,584 | £9,539 | £12,265 | £4,431 | £1,103 | £2,294 | (£954) | (£343) | £655 | £1,846 | £3,366 | |
| Cash Balance | £10,035 | £18,618 | £28,157 | £40,422 | £44,854 | £45,957 | £48,250 | £47,296 | £46,953 | £47,609 | £49,455 | £52,820 | |
| 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 | £2,500 | £10,035 | £18,618 | £28,157 | £40,422 | £44,854 | £45,957 | £48,250 | £47,296 | £46,953 | £47,609 | £49,455 | £52,820 |
| Inventory | £36,000 | £28,000 | £20,000 | £12,000 | £9,900 | £9,900 | £8,800 | £8,800 | £8,800 | £8,800 | £8,800 | £8,800 | £9,900 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £38,500 | £38,035 | £38,618 | £40,157 | £50,322 | £54,754 | £54,757 | £57,050 | £56,096 | £55,753 | £56,409 | £58,255 | £62,720 |
| 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 | £38,500 | £38,035 | £38,618 | £40,157 | £50,322 | £54,754 | £54,757 | £57,050 | £56,096 | £55,753 | £56,409 | £58,255 | £62,720 |
| 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 | £2,418 | £3,384 | £3,908 | £11,176 | £13,078 | £10,921 | £11,690 | £11,080 | £11,074 | £11,309 | £11,712 | £13,977 |
| Current Borrowing | £50,000 | £48,958 | £47,916 | £46,874 | £45,832 | £44,790 | £43,748 | £42,706 | £41,664 | £40,623 | £39,582 | £38,541 | £37,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £50,000 | £51,376 | £51,300 | £50,782 | £57,008 | £57,868 | £54,669 | £54,396 | £52,744 | £51,697 | £50,891 | £50,253 | £51,477 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £50,000 | £51,376 | £51,300 | £50,782 | £57,008 | £57,868 | £54,669 | £54,396 | £52,744 | £51,697 | £50,891 | £50,253 | £51,477 |
| Paid-in Capital | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 | £216,000 |
| Retained Earnings | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) | (£227,500) |
| Earnings | £0 | (£1,841) | (£1,182) | £876 | £4,815 | £8,385 | £11,587 | £14,154 | £14,852 | £15,557 | £17,018 | £19,502 | £22,743 |
| Total Capital | (£11,500) | (£13,341) | (£12,682) | (£10,624) | (£6,685) | (£3,115) | £87 | £2,654 | £3,352 | £4,057 | £5,518 | £8,002 | £11,243 |
| Total Liabilities and Capital | £38,500 | £38,035 | £38,618 | £40,157 | £50,322 | £54,754 | £54,757 | £57,050 | £56,096 | £55,753 | £56,409 | £58,255 | £62,720 |
| Net Worth | (£11,500) | (£13,341) | (£12,682) | (£10,624) | (£6,685) | (£3,115) | £87 | £2,654 | £3,352 | £4,057 | £5,518 | £8,002 | £11,243 |