| 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 | |||||||||||||
| Combined Annual Revenue Streams | £0 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £0 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| 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 | |
| Combined Annual Revenue Streams | 60% | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 | |
| 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 | ||
| Owner | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Managers (2) | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Full-time staff (4) | £0 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| Temp staff | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Total People | 0 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £0 | £8,000 | £11,000 | £11,000 | £11,000 | £11,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| 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 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| Direct Cost of Sales | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 | |
| Gross Margin | £0 | £0 | £6,320 | £13,720 | £14,360 | £15,080 | £15,800 | £16,960 | £17,360 | £18,280 | £19,800 | £19,983 | |
| Gross Margin % | 0.00% | 0.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £8,000 | £11,000 | £11,000 | £11,000 | £11,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Sales & Marketing and Other Expenses | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Building Build-Out (£20,000) | £10,000 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Lights, Audio, Bumper | £10,000 | £10,000 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Permits & Licenses (Beer & Wine) | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £12,000 | £0 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Legal and Accounting | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Consulting | £500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes & Employee Benefits | 7% | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 |
| General and Adminstrative Expenses | 15% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Other | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Operating Expenses | £42,775 | £33,275 | £29,275 | £22,275 | £22,275 | £22,275 | £23,275 | £23,275 | £23,275 | £23,275 | £23,275 | £23,275 | |
| Profit Before Interest and Taxes | (£42,775) | (£33,275) | (£22,955) | (£8,555) | (£7,915) | (£7,195) | (£7,475) | (£6,315) | (£5,915) | (£4,995) | (£3,475) | (£3,292) | |
| EBITDA | (£42,775) | (£33,275) | (£22,955) | (£8,555) | (£7,915) | (£7,195) | (£7,475) | (£6,315) | (£5,915) | (£4,995) | (£3,475) | (£3,292) | |
| 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 | (£42,775) | (£33,275) | (£22,955) | (£8,555) | (£7,915) | (£7,195) | (£7,475) | (£6,315) | (£5,915) | (£4,995) | (£3,475) | (£3,292) | |
| Net Profit/Sales | 0.00% | 0.00% | -145.28% | -24.94% | -22.05% | -19.08% | -18.92% | -14.89% | -13.63% | -10.93% | -7.02% | -6.59% | |
| 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 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| Subtotal Cash from Operations | £0 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| 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 | £150,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £150,000 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| 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 | £0 | £8,000 | £11,000 | £11,000 | £11,000 | £11,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Bill Payments | £1,426 | £42,192 | £25,437 | £30,275 | £34,577 | £33,092 | £34,201 | £35,308 | £37,160 | £37,517 | £39,123 | £41,537 | |
| Subtotal Spent on Operations | £1,426 | £50,192 | £36,437 | £41,275 | £45,577 | £44,092 | £46,201 | £47,308 | £49,160 | £49,517 | £51,123 | £53,537 | |
| 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 | £1,426 | £50,192 | £36,437 | £41,275 | £45,577 | £44,092 | £46,201 | £47,308 | £49,160 | £49,517 | £51,123 | £53,537 | |
| Net Cash Flow | £148,574 | (£50,192) | (£20,637) | (£6,975) | (£9,677) | (£6,392) | (£6,701) | (£4,908) | (£5,760) | (£3,817) | (£1,623) | (£3,580) | |
| Cash Balance | £149,574 | £99,383 | £78,746 | £71,771 | £62,093 | £55,701 | £49,000 | £44,092 | £38,331 | £34,514 | £32,890 | £29,310 | |
| 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 | £1,000 | £149,574 | £99,383 | £78,746 | £71,771 | £62,093 | £55,701 | £49,000 | £44,092 | £38,331 | £34,514 | £32,890 | £29,310 |
| Inventory | £0 | £0 | £0 | £2,370 | £5,145 | £5,385 | £5,655 | £5,925 | £6,360 | £6,510 | £6,855 | £7,425 | £7,494 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £1,000 | £149,574 | £99,383 | £81,116 | £76,916 | £67,478 | £61,356 | £54,925 | £50,452 | £44,841 | £41,369 | £40,315 | £36,804 |
| 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 | £1,000 | £149,574 | £99,383 | £81,116 | £76,916 | £67,478 | £61,356 | £54,925 | £50,452 | £44,841 | £41,369 | £40,315 | £36,804 |
| 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 | £41,349 | £24,432 | £29,121 | £33,476 | £31,953 | £33,026 | £34,070 | £35,912 | £36,216 | £37,739 | £40,160 | £39,940 |
| 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 | £41,349 | £24,432 | £29,121 | £33,476 | £31,953 | £33,026 | £34,070 | £35,912 | £36,216 | £37,739 | £40,160 | £39,940 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £41,349 | £24,432 | £29,121 | £33,476 | £31,953 | £33,026 | £34,070 | £35,912 | £36,216 | £37,739 | £40,160 | £39,940 |
| Paid-in Capital | £40,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 |
| Retained Earnings | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) |
| Earnings | £0 | (£42,775) | (£76,050) | (£99,005) | (£107,560) | (£115,475) | (£122,670) | (£130,145) | (£136,460) | (£142,375) | (£147,370) | (£150,845) | (£154,137) |
| Total Capital | £1,000 | £108,225 | £74,950 | £51,995 | £43,440 | £35,525 | £28,330 | £20,855 | £14,540 | £8,625 | £3,630 | £155 | (£3,137) |
| Total Liabilities and Capital | £1,000 | £149,574 | £99,383 | £81,116 | £76,916 | £67,478 | £61,356 | £54,925 | £50,452 | £44,841 | £41,369 | £40,315 | £36,804 |
| Net Worth | £1,000 | £108,225 | £74,950 | £51,995 | £43,440 | £35,525 | £28,330 | £20,855 | £14,540 | £8,625 | £3,630 | £155 | (£3,137) |
| 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 | |||||||||||||
| Combined Annual Revenue Streams | £0 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £0 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| 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 | |
| Combined Annual Revenue Streams | 60% | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 | |
| 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 | ||
| Owner | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Managers (2) | £0 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | |
| Full-time staff (4) | £0 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | |
| Temp staff | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Total People | 0 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £0 | £8,000 | £11,000 | £11,000 | £11,000 | £11,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| 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 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| Direct Cost of Sales | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £9,480 | £20,580 | £21,540 | £22,620 | £23,700 | £25,440 | £26,040 | £27,420 | £29,700 | £29,974 | |
| Gross Margin | £0 | £0 | £6,320 | £13,720 | £14,360 | £15,080 | £15,800 | £16,960 | £17,360 | £18,280 | £19,800 | £19,983 | |
| Gross Margin % | 0.00% | 0.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | |
| Expenses | |||||||||||||
| Payroll | £0 | £8,000 | £11,000 | £11,000 | £11,000 | £11,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Sales & Marketing and Other Expenses | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | £2,126 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Building Build-Out (£20,000) | £10,000 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Lights, Audio, Bumper | £10,000 | £10,000 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Permits & Licenses (Beer & Wine) | £5,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £12,000 | £0 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Legal and Accounting | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Consulting | £500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes & Employee Benefits | 7% | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 | £149 |
| General and Adminstrative Expenses | 15% | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Other | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Total Operating Expenses | £42,775 | £33,275 | £29,275 | £22,275 | £22,275 | £22,275 | £23,275 | £23,275 | £23,275 | £23,275 | £23,275 | £23,275 | |
| Profit Before Interest and Taxes | (£42,775) | (£33,275) | (£22,955) | (£8,555) | (£7,915) | (£7,195) | (£7,475) | (£6,315) | (£5,915) | (£4,995) | (£3,475) | (£3,292) | |
| EBITDA | (£42,775) | (£33,275) | (£22,955) | (£8,555) | (£7,915) | (£7,195) | (£7,475) | (£6,315) | (£5,915) | (£4,995) | (£3,475) | (£3,292) | |
| 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 | (£42,775) | (£33,275) | (£22,955) | (£8,555) | (£7,915) | (£7,195) | (£7,475) | (£6,315) | (£5,915) | (£4,995) | (£3,475) | (£3,292) | |
| Net Profit/Sales | 0.00% | 0.00% | -145.28% | -24.94% | -22.05% | -19.08% | -18.92% | -14.89% | -13.63% | -10.93% | -7.02% | -6.59% | |
| 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 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| Subtotal Cash from Operations | £0 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| 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 | £150,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £150,000 | £0 | £15,800 | £34,300 | £35,900 | £37,700 | £39,500 | £42,400 | £43,400 | £45,700 | £49,500 | £49,957 | |
| 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 | £0 | £8,000 | £11,000 | £11,000 | £11,000 | £11,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | £12,000 | |
| Bill Payments | £1,426 | £42,192 | £25,437 | £30,275 | £34,577 | £33,092 | £34,201 | £35,308 | £37,160 | £37,517 | £39,123 | £41,537 | |
| Subtotal Spent on Operations | £1,426 | £50,192 | £36,437 | £41,275 | £45,577 | £44,092 | £46,201 | £47,308 | £49,160 | £49,517 | £51,123 | £53,537 | |
| 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 | £1,426 | £50,192 | £36,437 | £41,275 | £45,577 | £44,092 | £46,201 | £47,308 | £49,160 | £49,517 | £51,123 | £53,537 | |
| Net Cash Flow | £148,574 | (£50,192) | (£20,637) | (£6,975) | (£9,677) | (£6,392) | (£6,701) | (£4,908) | (£5,760) | (£3,817) | (£1,623) | (£3,580) | |
| Cash Balance | £149,574 | £99,383 | £78,746 | £71,771 | £62,093 | £55,701 | £49,000 | £44,092 | £38,331 | £34,514 | £32,890 | £29,310 | |
| 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 | £1,000 | £149,574 | £99,383 | £78,746 | £71,771 | £62,093 | £55,701 | £49,000 | £44,092 | £38,331 | £34,514 | £32,890 | £29,310 |
| Inventory | £0 | £0 | £0 | £2,370 | £5,145 | £5,385 | £5,655 | £5,925 | £6,360 | £6,510 | £6,855 | £7,425 | £7,494 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £1,000 | £149,574 | £99,383 | £81,116 | £76,916 | £67,478 | £61,356 | £54,925 | £50,452 | £44,841 | £41,369 | £40,315 | £36,804 |
| 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 | £1,000 | £149,574 | £99,383 | £81,116 | £76,916 | £67,478 | £61,356 | £54,925 | £50,452 | £44,841 | £41,369 | £40,315 | £36,804 |
| 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 | £41,349 | £24,432 | £29,121 | £33,476 | £31,953 | £33,026 | £34,070 | £35,912 | £36,216 | £37,739 | £40,160 | £39,940 |
| 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 | £41,349 | £24,432 | £29,121 | £33,476 | £31,953 | £33,026 | £34,070 | £35,912 | £36,216 | £37,739 | £40,160 | £39,940 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £41,349 | £24,432 | £29,121 | £33,476 | £31,953 | £33,026 | £34,070 | £35,912 | £36,216 | £37,739 | £40,160 | £39,940 |
| Paid-in Capital | £40,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 | £190,260 |
| Retained Earnings | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) | (£39,260) |
| Earnings | £0 | (£42,775) | (£76,050) | (£99,005) | (£107,560) | (£115,475) | (£122,670) | (£130,145) | (£136,460) | (£142,375) | (£147,370) | (£150,845) | (£154,137) |
| Total Capital | £1,000 | £108,225 | £74,950 | £51,995 | £43,440 | £35,525 | £28,330 | £20,855 | £14,540 | £8,625 | £3,630 | £155 | (£3,137) |
| Total Liabilities and Capital | £1,000 | £149,574 | £99,383 | £81,116 | £76,916 | £67,478 | £61,356 | £54,925 | £50,452 | £44,841 | £41,369 | £40,315 | £36,804 |
| Net Worth | £1,000 | £108,225 | £74,950 | £51,995 | £43,440 | £35,525 | £28,330 | £20,855 | £14,540 | £8,625 | £3,630 | £155 | (£3,137) |