| 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 | |||||||||||||
| Auto Parts | 0% | £0 | £0 | £20,000 | £26,000 | £30,000 | £36,000 | £40,000 | £44,000 | £48,000 | £50,000 | £56,000 | £60,000 |
| Auto Lubricants | 0% | £0 | £0 | £8,000 | £12,000 | £12,000 | £16,000 | £20,000 | £20,000 | £24,000 | £24,000 | £26,000 | £24,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £28,000 | £38,000 | £42,000 | £52,000 | £60,000 | £64,000 | £72,000 | £74,000 | £82,000 | £84,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 | |
| Auto Parts | £0 | £0 | £10,000 | £13,000 | £15,000 | £18,000 | £20,000 | £22,000 | £24,000 | £25,000 | £23,000 | £30,000 | |
| Auto Lubricants | £0 | £0 | £4,000 | £6,000 | £6,000 | £8,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,000 | £12,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £36,000 | £42,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 | ||
| James Dunn | 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 |
| 4 Facility Staff | 0% | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 |
| 2 Sales Staff | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | |
| 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 | £0 | £0 | £28,000 | £38,000 | £42,000 | £52,000 | £60,000 | £64,000 | £72,000 | £74,000 | £82,000 | £84,000 | |
| Direct Cost of Sales | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £36,000 | £42,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £36,000 | £42,000 | |
| Gross Margin | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £46,000 | £42,000 | |
| Gross Margin % | 0.00% | 0.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 56.10% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £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 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | |
| Payroll Taxes | 15% | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | |
| Profit Before Interest and Taxes | (£21,730) | (£21,730) | (£7,730) | (£2,730) | (£730) | £4,270 | £8,270 | £10,270 | £14,270 | £15,270 | £24,270 | £20,270 | |
| EBITDA | (£21,730) | (£21,730) | (£7,730) | (£2,730) | (£730) | £4,270 | £8,270 | £10,270 | £14,270 | £15,270 | £24,270 | £20,270 | |
| Interest Expense | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Taxes Incurred | (£6,769) | (£6,769) | (£2,569) | (£1,069) | (£469) | £1,031 | £2,231 | £2,831 | £4,031 | £4,331 | £7,031 | £5,831 | |
| Net Profit | (£15,794) | (£15,794) | (£5,994) | (£2,494) | (£1,094) | £2,406 | £5,206 | £6,606 | £9,406 | £10,106 | £16,406 | £13,606 | |
| Net Profit/Sales | 0.00% | 0.00% | -21.41% | -6.56% | -2.61% | 4.63% | 8.68% | 10.32% | 13.06% | 13.66% | 20.01% | 16.20% | |
| 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 | £7,000 | £9,500 | £10,500 | £13,000 | £15,000 | £16,000 | £18,000 | £18,500 | £20,500 | £21,000 | |
| Cash from Receivables | £0 | £0 | £0 | £700 | £21,250 | £28,600 | £31,750 | £39,200 | £45,100 | £48,200 | £54,050 | £55,700 | |
| Subtotal Cash from Operations | £0 | £0 | £7,000 | £10,200 | £31,750 | £41,600 | £46,750 | £55,200 | £63,100 | £66,700 | £74,550 | £76,700 | |
| 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 | £0 | £0 | £7,000 | £10,200 | £31,750 | £41,600 | £46,750 | £55,200 | £63,100 | £66,700 | £74,550 | £76,700 | |
| 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 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | |
| Bill Payments | (£406) | (£798) | (£266) | £3,844 | £5,314 | £6,231 | £16,894 | £43,008 | £43,641 | £50,728 | £48,778 | £48,711 | |
| Subtotal Spent on Operations | £15,794 | £15,402 | £15,934 | £20,044 | £21,514 | £22,431 | £33,094 | £59,208 | £59,841 | £66,928 | £64,978 | £64,911 | |
| 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 | £15,794 | £15,402 | £15,934 | £20,044 | £21,514 | £22,431 | £33,094 | £59,208 | £59,841 | £66,928 | £64,978 | £64,911 | |
| Net Cash Flow | (£15,794) | (£15,402) | (£8,934) | (£9,844) | £10,236 | £19,169 | £13,656 | (£4,008) | £3,259 | (£228) | £9,572 | £11,789 | |
| Cash Balance | £67,206 | £51,803 | £42,869 | £33,025 | £43,260 | £62,429 | £76,085 | £72,077 | £75,336 | £75,109 | £84,681 | £96,470 | |
| 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 | £83,000 | £67,206 | £51,803 | £42,869 | £33,025 | £43,260 | £62,429 | £76,085 | £72,077 | £75,336 | £75,109 | £84,681 | £96,470 |
| Accounts Receivable | £0 | £0 | £0 | £21,000 | £48,800 | £59,050 | £69,450 | £82,700 | £91,500 | £100,400 | £107,700 | £115,150 | £122,450 |
| Inventory | £100,000 | £100,000 | £100,000 | £86,000 | £67,000 | £46,000 | £28,600 | £33,000 | £35,200 | £39,600 | £40,700 | £39,600 | £46,200 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £183,000 | £167,206 | £151,803 | £149,869 | £148,825 | £148,310 | £160,479 | £191,785 | £198,777 | £215,336 | £223,509 | £239,431 | £265,120 |
| 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 | £183,000 | £167,206 | £151,803 | £149,869 | £148,825 | £148,310 | £160,479 | £191,785 | £198,777 | £215,336 | £223,509 | £239,431 | £265,120 |
| 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 | £0 | £392 | £4,452 | £5,902 | £6,482 | £16,245 | £42,345 | £42,732 | £49,885 | £47,952 | £47,469 | £59,552 |
| 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 | £0 | £392 | £4,452 | £5,902 | £6,482 | £16,245 | £42,345 | £42,732 | £49,885 | £47,952 | £47,469 | £59,552 |
| Long-term Liabilities | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 |
| Total Liabilities | £100,000 | £100,000 | £100,392 | £104,452 | £105,902 | £106,482 | £116,245 | £142,345 | £142,732 | £149,885 | £147,952 | £147,469 | £159,552 |
| Paid-in Capital | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Retained Earnings | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) |
| Earnings | £0 | (£15,794) | (£31,589) | (£37,583) | (£40,077) | (£41,172) | (£38,766) | (£33,560) | (£26,955) | (£17,549) | (£7,443) | £8,962 | £22,568 |
| Total Capital | £83,000 | £67,206 | £51,411 | £45,417 | £42,923 | £41,828 | £44,234 | £49,440 | £56,045 | £65,451 | £75,557 | £91,962 | £105,568 |
| Total Liabilities and Capital | £183,000 | £167,206 | £151,803 | £149,869 | £148,825 | £148,310 | £160,479 | £191,785 | £198,777 | £215,336 | £223,509 | £239,431 | £265,120 |
| Net Worth | £83,000 | £67,206 | £51,411 | £45,417 | £42,923 | £41,828 | £44,234 | £49,440 | £56,045 | £65,451 | £75,557 | £91,962 | £105,568 |
| 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 | |||||||||||||
| Auto Parts | 0% | £0 | £0 | £20,000 | £26,000 | £30,000 | £36,000 | £40,000 | £44,000 | £48,000 | £50,000 | £56,000 | £60,000 |
| Auto Lubricants | 0% | £0 | £0 | £8,000 | £12,000 | £12,000 | £16,000 | £20,000 | £20,000 | £24,000 | £24,000 | £26,000 | £24,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £0 | £28,000 | £38,000 | £42,000 | £52,000 | £60,000 | £64,000 | £72,000 | £74,000 | £82,000 | £84,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 | |
| Auto Parts | £0 | £0 | £10,000 | £13,000 | £15,000 | £18,000 | £20,000 | £22,000 | £24,000 | £25,000 | £23,000 | £30,000 | |
| Auto Lubricants | £0 | £0 | £4,000 | £6,000 | £6,000 | £8,000 | £10,000 | £10,000 | £12,000 | £12,000 | £13,000 | £12,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £36,000 | £42,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 | ||
| James Dunn | 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 |
| 4 Facility Staff | 0% | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 | £7,200 |
| 2 Sales Staff | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | |
| 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 | £0 | £0 | £28,000 | £38,000 | £42,000 | £52,000 | £60,000 | £64,000 | £72,000 | £74,000 | £82,000 | £84,000 | |
| Direct Cost of Sales | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £36,000 | £42,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £36,000 | £42,000 | |
| Gross Margin | £0 | £0 | £14,000 | £19,000 | £21,000 | £26,000 | £30,000 | £32,000 | £36,000 | £37,000 | £46,000 | £42,000 | |
| Gross Margin % | 0.00% | 0.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 56.10% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | |
| Sales and Marketing and Other Expenses | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £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 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | |
| Payroll Taxes | 15% | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 | £2,430 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | £21,730 | |
| Profit Before Interest and Taxes | (£21,730) | (£21,730) | (£7,730) | (£2,730) | (£730) | £4,270 | £8,270 | £10,270 | £14,270 | £15,270 | £24,270 | £20,270 | |
| EBITDA | (£21,730) | (£21,730) | (£7,730) | (£2,730) | (£730) | £4,270 | £8,270 | £10,270 | £14,270 | £15,270 | £24,270 | £20,270 | |
| Interest Expense | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | £833 | |
| Taxes Incurred | (£6,769) | (£6,769) | (£2,569) | (£1,069) | (£469) | £1,031 | £2,231 | £2,831 | £4,031 | £4,331 | £7,031 | £5,831 | |
| Net Profit | (£15,794) | (£15,794) | (£5,994) | (£2,494) | (£1,094) | £2,406 | £5,206 | £6,606 | £9,406 | £10,106 | £16,406 | £13,606 | |
| Net Profit/Sales | 0.00% | 0.00% | -21.41% | -6.56% | -2.61% | 4.63% | 8.68% | 10.32% | 13.06% | 13.66% | 20.01% | 16.20% | |
| 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 | £7,000 | £9,500 | £10,500 | £13,000 | £15,000 | £16,000 | £18,000 | £18,500 | £20,500 | £21,000 | |
| Cash from Receivables | £0 | £0 | £0 | £700 | £21,250 | £28,600 | £31,750 | £39,200 | £45,100 | £48,200 | £54,050 | £55,700 | |
| Subtotal Cash from Operations | £0 | £0 | £7,000 | £10,200 | £31,750 | £41,600 | £46,750 | £55,200 | £63,100 | £66,700 | £74,550 | £76,700 | |
| 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 | £0 | £0 | £7,000 | £10,200 | £31,750 | £41,600 | £46,750 | £55,200 | £63,100 | £66,700 | £74,550 | £76,700 | |
| 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 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | £16,200 | |
| Bill Payments | (£406) | (£798) | (£266) | £3,844 | £5,314 | £6,231 | £16,894 | £43,008 | £43,641 | £50,728 | £48,778 | £48,711 | |
| Subtotal Spent on Operations | £15,794 | £15,402 | £15,934 | £20,044 | £21,514 | £22,431 | £33,094 | £59,208 | £59,841 | £66,928 | £64,978 | £64,911 | |
| 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 | £15,794 | £15,402 | £15,934 | £20,044 | £21,514 | £22,431 | £33,094 | £59,208 | £59,841 | £66,928 | £64,978 | £64,911 | |
| Net Cash Flow | (£15,794) | (£15,402) | (£8,934) | (£9,844) | £10,236 | £19,169 | £13,656 | (£4,008) | £3,259 | (£228) | £9,572 | £11,789 | |
| Cash Balance | £67,206 | £51,803 | £42,869 | £33,025 | £43,260 | £62,429 | £76,085 | £72,077 | £75,336 | £75,109 | £84,681 | £96,470 | |
| 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 | £83,000 | £67,206 | £51,803 | £42,869 | £33,025 | £43,260 | £62,429 | £76,085 | £72,077 | £75,336 | £75,109 | £84,681 | £96,470 |
| Accounts Receivable | £0 | £0 | £0 | £21,000 | £48,800 | £59,050 | £69,450 | £82,700 | £91,500 | £100,400 | £107,700 | £115,150 | £122,450 |
| Inventory | £100,000 | £100,000 | £100,000 | £86,000 | £67,000 | £46,000 | £28,600 | £33,000 | £35,200 | £39,600 | £40,700 | £39,600 | £46,200 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £183,000 | £167,206 | £151,803 | £149,869 | £148,825 | £148,310 | £160,479 | £191,785 | £198,777 | £215,336 | £223,509 | £239,431 | £265,120 |
| 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 | £183,000 | £167,206 | £151,803 | £149,869 | £148,825 | £148,310 | £160,479 | £191,785 | £198,777 | £215,336 | £223,509 | £239,431 | £265,120 |
| 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 | £0 | £392 | £4,452 | £5,902 | £6,482 | £16,245 | £42,345 | £42,732 | £49,885 | £47,952 | £47,469 | £59,552 |
| 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 | £0 | £392 | £4,452 | £5,902 | £6,482 | £16,245 | £42,345 | £42,732 | £49,885 | £47,952 | £47,469 | £59,552 |
| Long-term Liabilities | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 |
| Total Liabilities | £100,000 | £100,000 | £100,392 | £104,452 | £105,902 | £106,482 | £116,245 | £142,345 | £142,732 | £149,885 | £147,952 | £147,469 | £159,552 |
| Paid-in Capital | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Retained Earnings | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) | (£67,000) |
| Earnings | £0 | (£15,794) | (£31,589) | (£37,583) | (£40,077) | (£41,172) | (£38,766) | (£33,560) | (£26,955) | (£17,549) | (£7,443) | £8,962 | £22,568 |
| Total Capital | £83,000 | £67,206 | £51,411 | £45,417 | £42,923 | £41,828 | £44,234 | £49,440 | £56,045 | £65,451 | £75,557 | £91,962 | £105,568 |
| Total Liabilities and Capital | £183,000 | £167,206 | £151,803 | £149,869 | £148,825 | £148,310 | £160,479 | £191,785 | £198,777 | £215,336 | £223,509 | £239,431 | £265,120 |
| Net Worth | £83,000 | £67,206 | £51,411 | £45,417 | £42,923 | £41,828 | £44,234 | £49,440 | £56,045 | £65,451 | £75,557 | £91,962 | £105,568 |