| 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 | |||||||||||||
| Supermarkets | 0% | £14,000 | £14,000 | £14,000 | £16,000 | £16,000 | £17,500 | £18,000 | £18,000 | £20,000 | £20,000 | £20,000 | £22,000 |
| Neighborhood Markets | 0% | £5,000 | £5,000 | £6,000 | £6,000 | £8,000 | £10,000 | £12,000 | £12,000 | £13,000 | £14,000 | £16,000 | £17,000 |
| Total Sales | £19,000 | £19,000 | £20,000 | £22,000 | £24,000 | £27,500 | £30,000 | £30,000 | £33,000 | £34,000 | £36,000 | £39,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 | |
| Supermarkets | £4,000 | £4,000 | £4,000 | £4,400 | £6,000 | £6,300 | £8,000 | £8,200 | £9,000 | £10,000 | £10,000 | £12,000 | |
| Neighborhood Markets | £1,000 | £1,000 | £1,000 | £1,080 | £1,200 | £1,280 | £1,700 | £1,740 | £1,800 | £2,000 | £2,000 | £2,500 | |
| Subtotal Direct Cost of Sales | £5,000 | £5,000 | £5,000 | £5,480 | £7,200 | £7,580 | £9,700 | £9,940 | £10,800 | £12,000 | £12,000 | £14,500 | |
| 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 | ||
| Raymond Garcia | 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 |
| Jose Arroyo | 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 |
| Delivery Persons | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Office Manager | 0% | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| 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 | £19,000 | £19,000 | £20,000 | £22,000 | £24,000 | £27,500 | £30,000 | £30,000 | £33,000 | £34,000 | £36,000 | £39,000 | |
| Direct Cost of Sales | £5,000 | £5,000 | £5,000 | £5,480 | £7,200 | £7,580 | £9,700 | £9,940 | £10,800 | £12,000 | £12,000 | £14,500 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £5,000 | £5,000 | £5,000 | £5,480 | £7,200 | £7,580 | £9,700 | £9,940 | £10,800 | £12,000 | £12,000 | £14,500 | |
| Gross Margin | £14,000 | £14,000 | £15,000 | £16,520 | £16,800 | £19,920 | £20,300 | £20,060 | £22,200 | £22,000 | £24,000 | £24,500 | |
| Gross Margin % | 73.68% | 73.68% | 75.00% | 75.09% | 70.00% | 72.44% | 67.67% | 66.87% | 67.27% | 64.71% | 66.67% | 62.82% | |
| Expenses | |||||||||||||
| Payroll | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | |
| Profit Before Interest and Taxes | (£4,230) | (£4,230) | (£3,230) | (£1,710) | (£1,430) | £1,690 | £2,070 | £1,830 | £3,970 | £3,770 | £5,770 | £6,270 | |
| EBITDA | (£3,990) | (£3,990) | (£2,990) | (£1,470) | (£1,190) | £1,930 | £2,310 | £2,070 | £4,210 | £4,010 | £6,010 | £6,510 | |
| Interest Expense | £824 | £814 | £804 | £794 | £784 | £774 | £765 | £755 | £745 | £735 | £725 | £715 | |
| Taxes Incurred | (£1,516) | (£1,513) | (£1,210) | (£751) | (£664) | £275 | £392 | £323 | £968 | £911 | £1,513 | £1,666 | |
| Net Profit | (£3,537) | (£3,531) | (£2,824) | (£1,753) | (£1,550) | £641 | £914 | £753 | £2,258 | £2,125 | £3,531 | £3,888 | |
| Net Profit/Sales | -18.62% | -18.58% | -14.12% | -7.97% | -6.46% | 2.33% | 3.05% | 2.51% | 6.84% | 6.25% | 9.81% | 9.97% | |
| 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 | £4,750 | £4,750 | £5,000 | £5,500 | £6,000 | £6,875 | £7,500 | £7,500 | £8,250 | £8,500 | £9,000 | £9,750 | |
| Cash from Receivables | £0 | £475 | £14,250 | £14,275 | £15,050 | £16,550 | £18,088 | £20,688 | £22,500 | £22,575 | £24,775 | £25,550 | |
| Subtotal Cash from Operations | £4,750 | £5,225 | £19,250 | £19,775 | £21,050 | £23,425 | £25,588 | £28,188 | £30,750 | £31,075 | £33,775 | £35,300 | |
| 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 | £4,750 | £5,225 | £19,250 | £19,775 | £21,050 | £23,425 | £25,588 | £28,188 | £30,750 | £31,075 | £33,775 | £35,300 | |
| 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 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Bill Payments | £157 | £4,697 | £4,700 | £4,999 | £5,435 | £5,541 | £6,443 | £6,738 | £12,520 | £18,899 | £20,331 | £19,808 | |
| Subtotal Spent on Operations | £12,757 | £17,297 | £17,300 | £17,599 | £18,035 | £18,141 | £19,043 | £19,338 | £25,120 | £31,499 | £32,931 | £32,408 | |
| 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 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | |
| 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 | £13,937 | £18,477 | £18,480 | £18,779 | £19,215 | £19,321 | £20,223 | £20,518 | £26,300 | £32,679 | £34,111 | £33,588 | |
| Net Cash Flow | (£9,187) | (£13,252) | £770 | £996 | £1,835 | £4,104 | £5,365 | £7,670 | £4,450 | (£1,604) | (£336) | £1,712 | |
| Cash Balance | £95,513 | £82,261 | £83,031 | £84,027 | £85,862 | £89,966 | £95,331 | £103,000 | £107,451 | £105,847 | £105,511 | £107,223 | |
| 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 | £104,700 | £95,513 | £82,261 | £83,031 | £84,027 | £85,862 | £89,966 | £95,331 | £103,000 | £107,451 | £105,847 | £105,511 | £107,223 |
| Accounts Receivable | £0 | £14,250 | £28,025 | £28,775 | £31,000 | £33,950 | £38,025 | £42,438 | £44,250 | £46,500 | £49,425 | £51,650 | £55,350 |
| Inventory | £60,000 | £55,000 | £50,000 | £45,000 | £39,520 | £32,320 | £24,740 | £15,040 | £10,934 | £11,880 | £13,200 | £13,200 | £15,950 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £164,700 | £164,763 | £160,286 | £156,806 | £154,547 | £152,132 | £152,731 | £152,808 | £158,184 | £165,831 | £168,472 | £170,361 | £178,523 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Accumulated Depreciation | £0 | £240 | £480 | £720 | £960 | £1,200 | £1,440 | £1,680 | £1,920 | £2,160 | £2,400 | £2,640 | £2,880 |
| Total Long-term Assets | £20,000 | £19,760 | £19,520 | £19,280 | £19,040 | £18,800 | £18,560 | £18,320 | £18,080 | £17,840 | £17,600 | £17,360 | £17,120 |
| Total Assets | £184,700 | £184,523 | £179,806 | £176,086 | £173,587 | £170,932 | £171,291 | £171,128 | £176,264 | £183,671 | £186,072 | £187,721 | £195,643 |
| 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,541 | £4,534 | £4,818 | £5,252 | £5,326 | £6,224 | £6,328 | £11,891 | £18,220 | £19,677 | £18,974 | £24,188 |
| 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,541 | £4,534 | £4,818 | £5,252 | £5,326 | £6,224 | £6,328 | £11,891 | £18,220 | £19,677 | £18,974 | £24,188 |
| Long-term Liabilities | £100,000 | £98,820 | £97,640 | £96,460 | £95,280 | £94,100 | £92,920 | £91,740 | £90,560 | £89,380 | £88,200 | £87,020 | £85,840 |
| Total Liabilities | £100,000 | £103,361 | £102,174 | £101,278 | £100,532 | £99,426 | £99,144 | £98,068 | £102,451 | £107,600 | £107,877 | £105,994 | £110,028 |
| Paid-in Capital | £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 |
| Retained Earnings | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) |
| Earnings | £0 | (£3,537) | (£7,068) | (£9,892) | (£11,645) | (£13,194) | (£12,553) | (£11,640) | (£10,887) | (£8,629) | (£6,505) | (£2,973) | £915 |
| Total Capital | £84,700 | £81,163 | £77,632 | £74,808 | £73,056 | £71,506 | £72,147 | £73,060 | £73,813 | £76,071 | £78,195 | £81,727 | £85,615 |
| Total Liabilities and Capital | £184,700 | £184,523 | £179,806 | £176,086 | £173,587 | £170,932 | £171,291 | £171,128 | £176,264 | £183,671 | £186,072 | £187,721 | £195,643 |
| Net Worth | £84,700 | £81,163 | £77,632 | £74,808 | £73,056 | £71,506 | £72,147 | £73,060 | £73,813 | £76,071 | £78,195 | £81,727 | £85,615 |
| 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 | |||||||||||||
| Supermarkets | 0% | £14,000 | £14,000 | £14,000 | £16,000 | £16,000 | £17,500 | £18,000 | £18,000 | £20,000 | £20,000 | £20,000 | £22,000 |
| Neighborhood Markets | 0% | £5,000 | £5,000 | £6,000 | £6,000 | £8,000 | £10,000 | £12,000 | £12,000 | £13,000 | £14,000 | £16,000 | £17,000 |
| Total Sales | £19,000 | £19,000 | £20,000 | £22,000 | £24,000 | £27,500 | £30,000 | £30,000 | £33,000 | £34,000 | £36,000 | £39,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 | |
| Supermarkets | £4,000 | £4,000 | £4,000 | £4,400 | £6,000 | £6,300 | £8,000 | £8,200 | £9,000 | £10,000 | £10,000 | £12,000 | |
| Neighborhood Markets | £1,000 | £1,000 | £1,000 | £1,080 | £1,200 | £1,280 | £1,700 | £1,740 | £1,800 | £2,000 | £2,000 | £2,500 | |
| Subtotal Direct Cost of Sales | £5,000 | £5,000 | £5,000 | £5,480 | £7,200 | £7,580 | £9,700 | £9,940 | £10,800 | £12,000 | £12,000 | £14,500 | |
| 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 | ||
| Raymond Garcia | 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 |
| Jose Arroyo | 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 |
| Delivery Persons | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Office Manager | 0% | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| 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 | £19,000 | £19,000 | £20,000 | £22,000 | £24,000 | £27,500 | £30,000 | £30,000 | £33,000 | £34,000 | £36,000 | £39,000 | |
| Direct Cost of Sales | £5,000 | £5,000 | £5,000 | £5,480 | £7,200 | £7,580 | £9,700 | £9,940 | £10,800 | £12,000 | £12,000 | £14,500 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £5,000 | £5,000 | £5,000 | £5,480 | £7,200 | £7,580 | £9,700 | £9,940 | £10,800 | £12,000 | £12,000 | £14,500 | |
| Gross Margin | £14,000 | £14,000 | £15,000 | £16,520 | £16,800 | £19,920 | £20,300 | £20,060 | £22,200 | £22,000 | £24,000 | £24,500 | |
| Gross Margin % | 73.68% | 73.68% | 75.00% | 75.09% | 70.00% | 72.44% | 67.67% | 66.87% | 67.27% | 64.71% | 66.67% | 62.82% | |
| Expenses | |||||||||||||
| Payroll | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | £240 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Payroll Taxes | 15% | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 | £1,890 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | £18,230 | |
| Profit Before Interest and Taxes | (£4,230) | (£4,230) | (£3,230) | (£1,710) | (£1,430) | £1,690 | £2,070 | £1,830 | £3,970 | £3,770 | £5,770 | £6,270 | |
| EBITDA | (£3,990) | (£3,990) | (£2,990) | (£1,470) | (£1,190) | £1,930 | £2,310 | £2,070 | £4,210 | £4,010 | £6,010 | £6,510 | |
| Interest Expense | £824 | £814 | £804 | £794 | £784 | £774 | £765 | £755 | £745 | £735 | £725 | £715 | |
| Taxes Incurred | (£1,516) | (£1,513) | (£1,210) | (£751) | (£664) | £275 | £392 | £323 | £968 | £911 | £1,513 | £1,666 | |
| Net Profit | (£3,537) | (£3,531) | (£2,824) | (£1,753) | (£1,550) | £641 | £914 | £753 | £2,258 | £2,125 | £3,531 | £3,888 | |
| Net Profit/Sales | -18.62% | -18.58% | -14.12% | -7.97% | -6.46% | 2.33% | 3.05% | 2.51% | 6.84% | 6.25% | 9.81% | 9.97% | |
| 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 | £4,750 | £4,750 | £5,000 | £5,500 | £6,000 | £6,875 | £7,500 | £7,500 | £8,250 | £8,500 | £9,000 | £9,750 | |
| Cash from Receivables | £0 | £475 | £14,250 | £14,275 | £15,050 | £16,550 | £18,088 | £20,688 | £22,500 | £22,575 | £24,775 | £25,550 | |
| Subtotal Cash from Operations | £4,750 | £5,225 | £19,250 | £19,775 | £21,050 | £23,425 | £25,588 | £28,188 | £30,750 | £31,075 | £33,775 | £35,300 | |
| 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 | £4,750 | £5,225 | £19,250 | £19,775 | £21,050 | £23,425 | £25,588 | £28,188 | £30,750 | £31,075 | £33,775 | £35,300 | |
| 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 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | £12,600 | |
| Bill Payments | £157 | £4,697 | £4,700 | £4,999 | £5,435 | £5,541 | £6,443 | £6,738 | £12,520 | £18,899 | £20,331 | £19,808 | |
| Subtotal Spent on Operations | £12,757 | £17,297 | £17,300 | £17,599 | £18,035 | £18,141 | £19,043 | £19,338 | £25,120 | £31,499 | £32,931 | £32,408 | |
| 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 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | £1,180 | |
| 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 | £13,937 | £18,477 | £18,480 | £18,779 | £19,215 | £19,321 | £20,223 | £20,518 | £26,300 | £32,679 | £34,111 | £33,588 | |
| Net Cash Flow | (£9,187) | (£13,252) | £770 | £996 | £1,835 | £4,104 | £5,365 | £7,670 | £4,450 | (£1,604) | (£336) | £1,712 | |
| Cash Balance | £95,513 | £82,261 | £83,031 | £84,027 | £85,862 | £89,966 | £95,331 | £103,000 | £107,451 | £105,847 | £105,511 | £107,223 | |
| 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 | £104,700 | £95,513 | £82,261 | £83,031 | £84,027 | £85,862 | £89,966 | £95,331 | £103,000 | £107,451 | £105,847 | £105,511 | £107,223 |
| Accounts Receivable | £0 | £14,250 | £28,025 | £28,775 | £31,000 | £33,950 | £38,025 | £42,438 | £44,250 | £46,500 | £49,425 | £51,650 | £55,350 |
| Inventory | £60,000 | £55,000 | £50,000 | £45,000 | £39,520 | £32,320 | £24,740 | £15,040 | £10,934 | £11,880 | £13,200 | £13,200 | £15,950 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £164,700 | £164,763 | £160,286 | £156,806 | £154,547 | £152,132 | £152,731 | £152,808 | £158,184 | £165,831 | £168,472 | £170,361 | £178,523 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Accumulated Depreciation | £0 | £240 | £480 | £720 | £960 | £1,200 | £1,440 | £1,680 | £1,920 | £2,160 | £2,400 | £2,640 | £2,880 |
| Total Long-term Assets | £20,000 | £19,760 | £19,520 | £19,280 | £19,040 | £18,800 | £18,560 | £18,320 | £18,080 | £17,840 | £17,600 | £17,360 | £17,120 |
| Total Assets | £184,700 | £184,523 | £179,806 | £176,086 | £173,587 | £170,932 | £171,291 | £171,128 | £176,264 | £183,671 | £186,072 | £187,721 | £195,643 |
| 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,541 | £4,534 | £4,818 | £5,252 | £5,326 | £6,224 | £6,328 | £11,891 | £18,220 | £19,677 | £18,974 | £24,188 |
| 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,541 | £4,534 | £4,818 | £5,252 | £5,326 | £6,224 | £6,328 | £11,891 | £18,220 | £19,677 | £18,974 | £24,188 |
| Long-term Liabilities | £100,000 | £98,820 | £97,640 | £96,460 | £95,280 | £94,100 | £92,920 | £91,740 | £90,560 | £89,380 | £88,200 | £87,020 | £85,840 |
| Total Liabilities | £100,000 | £103,361 | £102,174 | £101,278 | £100,532 | £99,426 | £99,144 | £98,068 | £102,451 | £107,600 | £107,877 | £105,994 | £110,028 |
| Paid-in Capital | £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 |
| Retained Earnings | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) | (£15,300) |
| Earnings | £0 | (£3,537) | (£7,068) | (£9,892) | (£11,645) | (£13,194) | (£12,553) | (£11,640) | (£10,887) | (£8,629) | (£6,505) | (£2,973) | £915 |
| Total Capital | £84,700 | £81,163 | £77,632 | £74,808 | £73,056 | £71,506 | £72,147 | £73,060 | £73,813 | £76,071 | £78,195 | £81,727 | £85,615 |
| Total Liabilities and Capital | £184,700 | £184,523 | £179,806 | £176,086 | £173,587 | £170,932 | £171,291 | £171,128 | £176,264 | £183,671 | £186,072 | £187,721 | £195,643 |
| Net Worth | £84,700 | £81,163 | £77,632 | £74,808 | £73,056 | £71,506 | £72,147 | £73,060 | £73,813 | £76,071 | £78,195 | £81,727 | £85,615 |