| 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 | |||||||||||||
| Independent bicycle shops | 0% | £0 | £3,455 | £8,544 | £12,457 | £15,478 | £17,454 | £18,854 | £25,855 | £22,787 | £21,987 | £20,254 | £20,114 |
| Chain bicycle shops | 0% | £0 | £2,246 | £5,554 | £8,097 | £10,061 | £11,345 | £12,255 | £16,806 | £14,812 | £14,292 | £13,165 | £13,074 |
| Total Sales | £0 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| 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 | |
| Independent bicycle shops | £0 | £1,728 | £4,272 | £6,229 | £7,739 | £8,727 | £9,427 | £12,928 | £11,394 | £10,994 | £10,127 | £10,057 | |
| Chain bicycle shops | £0 | £1,123 | £2,777 | £4,049 | £5,030 | £5,673 | £6,128 | £8,403 | £7,406 | £7,146 | £6,583 | £6,537 | |
| Subtotal Direct Cost of Sales | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| 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 | ||
| Dan | 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 |
| Full time administrative | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Full time sales | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Full time sales | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Full time order fullfillment | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Total People | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £3,000 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,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% | 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 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| Direct Cost of Sales | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| Gross Margin | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| Gross Margin % | 0.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Sales and Marketing and Other Expenses | £100 | £700 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £700 | £100 | £100 | |
| Depreciation | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Payroll Taxes | 15% | £450 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £8,563 | £16,523 | £15,923 | £15,923 | £15,923 | £15,923 | £15,923 | £15,923 | £15,923 | £16,523 | £15,923 | £15,923 | |
| Profit Before Interest and Taxes | (£8,563) | (£13,673) | (£8,874) | (£5,646) | (£3,154) | (£1,523) | (£368) | £5,407 | £2,876 | £1,616 | £787 | £671 | |
| EBITDA | (£8,150) | (£13,260) | (£8,461) | (£5,233) | (£2,741) | (£1,110) | £45 | £5,820 | £3,289 | £2,029 | £1,200 | £1,084 | |
| 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 | (£8,563) | (£13,673) | (£8,874) | (£5,646) | (£3,154) | (£1,523) | (£368) | £5,407 | £2,876 | £1,616 | £787 | £671 | |
| Net Profit/Sales | 0.00% | -239.84% | -62.95% | -27.47% | -12.35% | -5.29% | -1.18% | 12.68% | 7.65% | 4.46% | 2.35% | 2.02% | |
| 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 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| Subtotal Cash from Operations | £0 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| 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 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| 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,000 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Bill Payments | £172 | £5,202 | £6,945 | £13,969 | £19,994 | £21,644 | £22,324 | £23,297 | £33,405 | £22,192 | £24,027 | £21,291 | |
| Subtotal Spent on Operations | £3,172 | £14,602 | £16,345 | £23,369 | £29,394 | £31,044 | £31,724 | £32,697 | £42,805 | £31,592 | £33,427 | £30,691 | |
| 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 | £3,172 | £14,602 | £16,345 | £23,369 | £29,394 | £31,044 | £31,724 | £32,697 | £42,805 | £31,592 | £33,427 | £30,691 | |
| Net Cash Flow | (£3,172) | (£8,901) | (£2,247) | (£2,815) | (£3,855) | (£2,245) | (£615) | £9,964 | (£5,206) | £4,687 | (£8) | £2,497 | |
| Cash Balance | £25,778 | £16,877 | £14,630 | £11,815 | £7,959 | £5,715 | £5,100 | £15,064 | £9,858 | £14,545 | £14,536 | £17,033 | |
| 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 | £28,950 | £25,778 | £16,877 | £14,630 | £11,815 | £7,959 | £5,715 | £5,100 | £15,064 | £9,858 | £14,545 | £14,536 | £17,033 |
| Inventory | £10,000 | £10,000 | £7,150 | £7,754 | £11,305 | £14,046 | £15,840 | £17,110 | £23,463 | £20,679 | £19,953 | £18,381 | £18,253 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £38,950 | £35,778 | £24,027 | £22,383 | £23,120 | £22,006 | £21,554 | £22,210 | £38,527 | £30,537 | £34,498 | £32,917 | £35,287 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 |
| Accumulated Depreciation | £0 | £413 | £826 | £1,239 | £1,652 | £2,065 | £2,478 | £2,891 | £3,304 | £3,717 | £4,130 | £4,543 | £4,956 |
| Total Long-term Assets | £24,750 | £24,337 | £23,924 | £23,511 | £23,098 | £22,685 | £22,272 | £21,859 | £21,446 | £21,033 | £20,620 | £20,207 | £19,794 |
| Total Assets | £63,700 | £60,115 | £47,951 | £45,894 | £46,218 | £44,691 | £43,826 | £44,069 | £59,973 | £51,570 | £55,118 | £53,124 | £55,081 |
| 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 | £4,978 | £6,486 | £13,304 | £19,273 | £20,900 | £21,559 | £22,171 | £32,667 | £21,388 | £23,319 | £20,539 | £21,824 |
| 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 | £4,978 | £6,486 | £13,304 | £19,273 | £20,900 | £21,559 | £22,171 | £32,667 | £21,388 | £23,319 | £20,539 | £21,824 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £4,978 | £6,486 | £13,304 | £19,273 | £20,900 | £21,559 | £22,171 | £32,667 | £21,388 | £23,319 | £20,539 | £21,824 |
| Paid-in Capital | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Retained Earnings | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) |
| Earnings | £0 | (£8,563) | (£22,236) | (£31,110) | (£36,756) | (£39,909) | (£41,433) | (£41,801) | (£36,394) | (£33,518) | (£31,901) | (£31,115) | (£30,444) |
| Total Capital | £63,700 | £55,137 | £41,464 | £32,590 | £26,944 | £23,791 | £22,267 | £21,899 | £27,306 | £30,182 | £31,799 | £32,585 | £33,256 |
| Total Liabilities and Capital | £63,700 | £60,115 | £47,951 | £45,894 | £46,218 | £44,691 | £43,826 | £44,069 | £59,973 | £51,570 | £55,118 | £53,124 | £55,081 |
| Net Worth | £63,700 | £55,137 | £41,464 | £32,590 | £26,944 | £23,791 | £22,267 | £21,899 | £27,306 | £30,182 | £31,799 | £32,585 | £33,256 |
| 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 | |||||||||||||
| Independent bicycle shops | 0% | £0 | £3,455 | £8,544 | £12,457 | £15,478 | £17,454 | £18,854 | £25,855 | £22,787 | £21,987 | £20,254 | £20,114 |
| Chain bicycle shops | 0% | £0 | £2,246 | £5,554 | £8,097 | £10,061 | £11,345 | £12,255 | £16,806 | £14,812 | £14,292 | £13,165 | £13,074 |
| Total Sales | £0 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| 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 | |
| Independent bicycle shops | £0 | £1,728 | £4,272 | £6,229 | £7,739 | £8,727 | £9,427 | £12,928 | £11,394 | £10,994 | £10,127 | £10,057 | |
| Chain bicycle shops | £0 | £1,123 | £2,777 | £4,049 | £5,030 | £5,673 | £6,128 | £8,403 | £7,406 | £7,146 | £6,583 | £6,537 | |
| Subtotal Direct Cost of Sales | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| 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 | ||
| Dan | 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 |
| Full time administrative | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Full time sales | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Full time sales | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Full time order fullfillment | 0% | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 |
| Total People | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £3,000 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,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% | 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 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| Direct Cost of Sales | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| Gross Margin | £0 | £2,850 | £7,049 | £10,277 | £12,769 | £14,400 | £15,555 | £21,330 | £18,799 | £18,139 | £16,710 | £16,594 | |
| Gross Margin % | 0.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Sales and Marketing and Other Expenses | £100 | £700 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £700 | £100 | £100 | |
| Depreciation | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | £413 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Rent | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Payroll Taxes | 15% | £450 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 | £1,410 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £8,563 | £16,523 | £15,923 | £15,923 | £15,923 | £15,923 | £15,923 | £15,923 | £15,923 | £16,523 | £15,923 | £15,923 | |
| Profit Before Interest and Taxes | (£8,563) | (£13,673) | (£8,874) | (£5,646) | (£3,154) | (£1,523) | (£368) | £5,407 | £2,876 | £1,616 | £787 | £671 | |
| EBITDA | (£8,150) | (£13,260) | (£8,461) | (£5,233) | (£2,741) | (£1,110) | £45 | £5,820 | £3,289 | £2,029 | £1,200 | £1,084 | |
| 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 | (£8,563) | (£13,673) | (£8,874) | (£5,646) | (£3,154) | (£1,523) | (£368) | £5,407 | £2,876 | £1,616 | £787 | £671 | |
| Net Profit/Sales | 0.00% | -239.84% | -62.95% | -27.47% | -12.35% | -5.29% | -1.18% | 12.68% | 7.65% | 4.46% | 2.35% | 2.02% | |
| 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 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| Subtotal Cash from Operations | £0 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| 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 | £5,701 | £14,098 | £20,554 | £25,539 | £28,799 | £31,109 | £42,661 | £37,599 | £36,279 | £33,419 | £33,188 | |
| 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,000 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | £9,400 | |
| Bill Payments | £172 | £5,202 | £6,945 | £13,969 | £19,994 | £21,644 | £22,324 | £23,297 | £33,405 | £22,192 | £24,027 | £21,291 | |
| Subtotal Spent on Operations | £3,172 | £14,602 | £16,345 | £23,369 | £29,394 | £31,044 | £31,724 | £32,697 | £42,805 | £31,592 | £33,427 | £30,691 | |
| 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 | £3,172 | £14,602 | £16,345 | £23,369 | £29,394 | £31,044 | £31,724 | £32,697 | £42,805 | £31,592 | £33,427 | £30,691 | |
| Net Cash Flow | (£3,172) | (£8,901) | (£2,247) | (£2,815) | (£3,855) | (£2,245) | (£615) | £9,964 | (£5,206) | £4,687 | (£8) | £2,497 | |
| Cash Balance | £25,778 | £16,877 | £14,630 | £11,815 | £7,959 | £5,715 | £5,100 | £15,064 | £9,858 | £14,545 | £14,536 | £17,033 | |
| 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 | £28,950 | £25,778 | £16,877 | £14,630 | £11,815 | £7,959 | £5,715 | £5,100 | £15,064 | £9,858 | £14,545 | £14,536 | £17,033 |
| Inventory | £10,000 | £10,000 | £7,150 | £7,754 | £11,305 | £14,046 | £15,840 | £17,110 | £23,463 | £20,679 | £19,953 | £18,381 | £18,253 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £38,950 | £35,778 | £24,027 | £22,383 | £23,120 | £22,006 | £21,554 | £22,210 | £38,527 | £30,537 | £34,498 | £32,917 | £35,287 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 | £24,750 |
| Accumulated Depreciation | £0 | £413 | £826 | £1,239 | £1,652 | £2,065 | £2,478 | £2,891 | £3,304 | £3,717 | £4,130 | £4,543 | £4,956 |
| Total Long-term Assets | £24,750 | £24,337 | £23,924 | £23,511 | £23,098 | £22,685 | £22,272 | £21,859 | £21,446 | £21,033 | £20,620 | £20,207 | £19,794 |
| Total Assets | £63,700 | £60,115 | £47,951 | £45,894 | £46,218 | £44,691 | £43,826 | £44,069 | £59,973 | £51,570 | £55,118 | £53,124 | £55,081 |
| 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 | £4,978 | £6,486 | £13,304 | £19,273 | £20,900 | £21,559 | £22,171 | £32,667 | £21,388 | £23,319 | £20,539 | £21,824 |
| 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 | £4,978 | £6,486 | £13,304 | £19,273 | £20,900 | £21,559 | £22,171 | £32,667 | £21,388 | £23,319 | £20,539 | £21,824 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £4,978 | £6,486 | £13,304 | £19,273 | £20,900 | £21,559 | £22,171 | £32,667 | £21,388 | £23,319 | £20,539 | £21,824 |
| Paid-in Capital | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 | £65,000 |
| Retained Earnings | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) | (£1,300) |
| Earnings | £0 | (£8,563) | (£22,236) | (£31,110) | (£36,756) | (£39,909) | (£41,433) | (£41,801) | (£36,394) | (£33,518) | (£31,901) | (£31,115) | (£30,444) |
| Total Capital | £63,700 | £55,137 | £41,464 | £32,590 | £26,944 | £23,791 | £22,267 | £21,899 | £27,306 | £30,182 | £31,799 | £32,585 | £33,256 |
| Total Liabilities and Capital | £63,700 | £60,115 | £47,951 | £45,894 | £46,218 | £44,691 | £43,826 | £44,069 | £59,973 | £51,570 | £55,118 | £53,124 | £55,081 |
| Net Worth | £63,700 | £55,137 | £41,464 | £32,590 | £26,944 | £23,791 | £22,267 | £21,899 | £27,306 | £30,182 | £31,799 | £32,585 | £33,256 |