| 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 | |||||||||||||
| Mothers' Attire | 0% | £2,250 | £4,500 | £7,500 | £11,250 | £13,500 | £14,500 | £15,000 | £12,500 | £10,000 | £8,500 | £6,000 | £5,000 |
| Bridesmaids' Attire | 0% | £2,142 | £3,213 | £5,712 | £10,710 | £10,353 | £11,424 | £14,280 | £11,424 | £9,282 | £9,282 | £7,140 | £6,426 |
| Flower Girl Dresses | 0% | £200 | £300 | £350 | £800 | £900 | £900 | £1,050 | £1,000 | £950 | £850 | £700 | £650 |
| Shoes | 0% | £250 | £400 | £1,000 | £1,500 | £1,900 | £2,000 | £2,250 | £2,100 | £1,500 | £1,500 | £1,000 | £900 |
| Other Accessories | 0% | £425 | £500 | £1,000 | £1,625 | £1,700 | £2,100 | £2,100 | £1,800 | £1,550 | £1,300 | £1,000 | £850 |
| Total Sales | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| 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 | |
| Clothing | £0 | £0 | £4,226 | £7,538 | £12,673 | £16,687 | £15,617 | £12,248 | £11,178 | £6,843 | £6,314 | £5,773 | |
| Shoes and Other Accessories | £405 | £540 | £1,200 | £1,470 | £1,620 | £1,320 | £1,140 | £720 | £570 | £540 | £480 | £480 | |
| Subtotal Direct Cost of Sales | £405 | £540 | £5,426 | £9,008 | £14,293 | £18,007 | £16,757 | £12,968 | £11,748 | £7,383 | £6,794 | £6,253 | |
| 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 | ||
| Dagny Taggart, Owner | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part Time Sales Associate 1 | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Part Time Sales Associate 2 | 0% | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 |
| Part Time Sales Associate 3 | 0% | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | |
| 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 | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | |
| Long-term Interest Rate | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | |
| 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 | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| Direct Cost of Sales | £405 | £540 | £5,426 | £9,008 | £14,293 | £18,007 | £16,757 | £12,968 | £11,748 | £7,383 | £6,794 | £6,253 | |
| Credit Card Fees | £76 | £128 | £224 | £373 | £408 | £445 | £499 | £415 | £335 | £309 | £228 | £199 | |
| Total Cost of Sales | £481 | £668 | £5,650 | £9,381 | £14,701 | £18,452 | £17,256 | £13,383 | £12,083 | £7,691 | £7,022 | £6,452 | |
| Gross Margin | £4,786 | £8,245 | £9,912 | £16,504 | £13,652 | £12,472 | £17,424 | £15,441 | £11,199 | £13,741 | £8,818 | £7,374 | |
| Gross Margin % | 90.87% | 92.50% | 63.69% | 63.76% | 48.15% | 40.33% | 50.24% | 53.57% | 48.10% | 64.11% | 55.67% | 53.33% | |
| Expenses | |||||||||||||
| Payroll | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | |
| Sales and Marketing and Other Expenses | £1,500 | £500 | £500 | £2,000 | £700 | £700 | £700 | £700 | £700 | £2,500 | £700 | £700 | |
| Depreciation | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | |
| Rent including triple nets | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Payroll Taxes | 15% | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 |
| Supplies | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Repairs and Maintenance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Professional Fees | £100 | £100 | £500 | £500 | £1,000 | £500 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Taxes and Licenses | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £0 | £1,000 | £0 | £0 |
| New Sample Inventory | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £1,000 | £1,000 | £4,000 | £2,000 | £2,000 | |
| Total Operating Expenses | £10,724 | £9,724 | £12,124 | £13,624 | £12,824 | £12,324 | £11,924 | £11,024 | £10,924 | £16,724 | £11,924 | £11,924 | |
| Profit Before Interest and Taxes | (£5,938) | (£1,479) | (£2,212) | £2,880 | £828 | £148 | £5,500 | £4,417 | £275 | (£2,983) | (£3,106) | (£4,550) | |
| EBITDA | (£5,758) | (£1,299) | (£2,032) | £3,060 | £1,008 | £328 | £5,680 | £4,597 | £455 | (£2,803) | (£2,926) | (£4,370) | |
| Interest Expense | £333 | £327 | £322 | £316 | £310 | £305 | £299 | £293 | £288 | £282 | £276 | £271 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£6,271) | (£1,807) | (£2,534) | £2,564 | £517 | (£156) | £5,201 | £4,124 | (£13) | (£3,265) | (£3,382) | (£4,821) | |
| Net Profit/Sales | -119.06% | -20.27% | -16.28% | 9.91% | 1.82% | -0.51% | 15.00% | 14.31% | -0.06% | -15.23% | -21.35% | -34.87% | |
| 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 | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| Subtotal Cash from Operations | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| 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 | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| 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 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | |
| Bill Payments | £1,280 | £8,361 | £7,523 | £9,984 | £12,115 | £28,000 | £32,190 | £25,112 | £17,839 | £19,145 | £17,111 | £15,817 | |
| Subtotal Spent on Operations | £3,840 | £10,921 | £10,083 | £12,544 | £14,675 | £30,560 | £34,750 | £27,672 | £20,399 | £21,705 | £19,671 | £18,377 | |
| 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,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £4,925 | £12,006 | £11,168 | £13,629 | £15,760 | £31,645 | £35,835 | £28,757 | £21,484 | £22,790 | £20,756 | £19,462 | |
| Net Cash Flow | £342 | (£3,093) | £4,394 | £12,256 | £12,593 | (£721) | (£1,155) | £67 | £1,798 | (£1,358) | (£4,916) | (£5,636) | |
| Cash Balance | £22,242 | £19,149 | £23,544 | £35,799 | £48,392 | £47,671 | £46,516 | £46,583 | £48,381 | £47,023 | £42,107 | £36,471 | |
| 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 | £21,900 | £22,242 | £19,149 | £23,544 | £35,799 | £48,392 | £47,671 | £46,516 | £46,583 | £48,381 | £47,023 | £42,107 | £36,471 |
| Inventory | £28,350 | £27,945 | £27,405 | £21,979 | £12,971 | £15,722 | £19,807 | £18,433 | £14,264 | £12,923 | £8,121 | £7,473 | £6,878 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £51,250 | £51,187 | £47,554 | £46,522 | £49,770 | £65,114 | £68,478 | £65,949 | £61,847 | £62,304 | £56,144 | £50,580 | £44,349 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 |
| Accumulated Depreciation | £0 | £180 | £360 | £540 | £720 | £900 | £1,080 | £1,260 | £1,440 | £1,620 | £1,800 | £1,980 | £2,160 |
| Total Long-term Assets | £8,500 | £8,320 | £8,140 | £7,960 | £7,780 | £7,600 | £7,420 | £7,240 | £7,060 | £6,880 | £6,700 | £6,520 | £6,340 |
| Total Assets | £59,750 | £59,507 | £55,694 | £54,482 | £57,550 | £72,714 | £75,898 | £73,189 | £68,907 | £69,184 | £62,844 | £57,100 | £50,689 |
| 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 | £1,000 | £8,113 | £7,192 | £9,599 | £11,187 | £26,919 | £31,344 | £24,519 | £17,198 | £18,573 | £16,583 | £15,306 | £14,802 |
| 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 | £1,000 | £8,113 | £7,192 | £9,599 | £11,187 | £26,919 | £31,344 | £24,519 | £17,198 | £18,573 | £16,583 | £15,306 | £14,802 |
| Long-term Liabilities | £65,000 | £63,915 | £62,830 | £61,745 | £60,660 | £59,575 | £58,490 | £57,405 | £56,320 | £55,235 | £54,150 | £53,065 | £51,980 |
| Total Liabilities | £66,000 | £72,028 | £70,022 | £71,344 | £71,847 | £86,494 | £89,834 | £81,924 | £73,518 | £73,808 | £70,733 | £68,371 | £66,782 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) |
| Earnings | £0 | (£6,271) | (£8,077) | (£10,611) | (£8,047) | (£7,530) | (£7,686) | (£2,486) | £1,639 | £1,626 | (£1,640) | (£5,022) | (£9,842) |
| Total Capital | (£6,250) | (£12,521) | (£14,327) | (£16,861) | (£14,297) | (£13,780) | (£13,936) | (£8,736) | (£4,611) | (£4,624) | (£7,890) | (£11,272) | (£16,092) |
| Total Liabilities and Capital | £59,750 | £59,507 | £55,694 | £54,482 | £57,550 | £72,714 | £75,898 | £73,189 | £68,907 | £69,184 | £62,844 | £57,100 | £50,689 |
| Net Worth | (£6,250) | (£12,521) | (£14,327) | (£16,861) | (£14,297) | (£13,780) | (£13,936) | (£8,736) | (£4,611) | (£4,624) | (£7,890) | (£11,272) | (£16,092) |
| 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 | |||||||||||||
| Mothers' Attire | 0% | £2,250 | £4,500 | £7,500 | £11,250 | £13,500 | £14,500 | £15,000 | £12,500 | £10,000 | £8,500 | £6,000 | £5,000 |
| Bridesmaids' Attire | 0% | £2,142 | £3,213 | £5,712 | £10,710 | £10,353 | £11,424 | £14,280 | £11,424 | £9,282 | £9,282 | £7,140 | £6,426 |
| Flower Girl Dresses | 0% | £200 | £300 | £350 | £800 | £900 | £900 | £1,050 | £1,000 | £950 | £850 | £700 | £650 |
| Shoes | 0% | £250 | £400 | £1,000 | £1,500 | £1,900 | £2,000 | £2,250 | £2,100 | £1,500 | £1,500 | £1,000 | £900 |
| Other Accessories | 0% | £425 | £500 | £1,000 | £1,625 | £1,700 | £2,100 | £2,100 | £1,800 | £1,550 | £1,300 | £1,000 | £850 |
| Total Sales | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| 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 | |
| Clothing | £0 | £0 | £4,226 | £7,538 | £12,673 | £16,687 | £15,617 | £12,248 | £11,178 | £6,843 | £6,314 | £5,773 | |
| Shoes and Other Accessories | £405 | £540 | £1,200 | £1,470 | £1,620 | £1,320 | £1,140 | £720 | £570 | £540 | £480 | £480 | |
| Subtotal Direct Cost of Sales | £405 | £540 | £5,426 | £9,008 | £14,293 | £18,007 | £16,757 | £12,968 | £11,748 | £7,383 | £6,794 | £6,253 | |
| 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 | ||
| Dagny Taggart, Owner | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Part Time Sales Associate 1 | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Part Time Sales Associate 2 | 0% | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 |
| Part Time Sales Associate 3 | 0% | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 | £580 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | |
| 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 | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | |
| Long-term Interest Rate | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | 6.25% | |
| 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 | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| Direct Cost of Sales | £405 | £540 | £5,426 | £9,008 | £14,293 | £18,007 | £16,757 | £12,968 | £11,748 | £7,383 | £6,794 | £6,253 | |
| Credit Card Fees | £76 | £128 | £224 | £373 | £408 | £445 | £499 | £415 | £335 | £309 | £228 | £199 | |
| Total Cost of Sales | £481 | £668 | £5,650 | £9,381 | £14,701 | £18,452 | £17,256 | £13,383 | £12,083 | £7,691 | £7,022 | £6,452 | |
| Gross Margin | £4,786 | £8,245 | £9,912 | £16,504 | £13,652 | £12,472 | £17,424 | £15,441 | £11,199 | £13,741 | £8,818 | £7,374 | |
| Gross Margin % | 90.87% | 92.50% | 63.69% | 63.76% | 48.15% | 40.33% | 50.24% | 53.57% | 48.10% | 64.11% | 55.67% | 53.33% | |
| Expenses | |||||||||||||
| Payroll | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | |
| Sales and Marketing and Other Expenses | £1,500 | £500 | £500 | £2,000 | £700 | £700 | £700 | £700 | £700 | £2,500 | £700 | £700 | |
| Depreciation | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | £180 | |
| Rent including triple nets | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | £4,400 | |
| Utilities | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Insurance | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Payroll Taxes | 15% | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 | £384 |
| Supplies | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Repairs and Maintenance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Professional Fees | £100 | £100 | £500 | £500 | £1,000 | £500 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Taxes and Licenses | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £0 | £1,000 | £0 | £0 |
| New Sample Inventory | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £1,000 | £1,000 | £4,000 | £2,000 | £2,000 | |
| Total Operating Expenses | £10,724 | £9,724 | £12,124 | £13,624 | £12,824 | £12,324 | £11,924 | £11,024 | £10,924 | £16,724 | £11,924 | £11,924 | |
| Profit Before Interest and Taxes | (£5,938) | (£1,479) | (£2,212) | £2,880 | £828 | £148 | £5,500 | £4,417 | £275 | (£2,983) | (£3,106) | (£4,550) | |
| EBITDA | (£5,758) | (£1,299) | (£2,032) | £3,060 | £1,008 | £328 | £5,680 | £4,597 | £455 | (£2,803) | (£2,926) | (£4,370) | |
| Interest Expense | £333 | £327 | £322 | £316 | £310 | £305 | £299 | £293 | £288 | £282 | £276 | £271 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£6,271) | (£1,807) | (£2,534) | £2,564 | £517 | (£156) | £5,201 | £4,124 | (£13) | (£3,265) | (£3,382) | (£4,821) | |
| Net Profit/Sales | -119.06% | -20.27% | -16.28% | 9.91% | 1.82% | -0.51% | 15.00% | 14.31% | -0.06% | -15.23% | -21.35% | -34.87% | |
| 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 | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| Subtotal Cash from Operations | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| 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 | £5,267 | £8,913 | £15,562 | £25,885 | £28,353 | £30,924 | £34,680 | £28,824 | £23,282 | £21,432 | £15,840 | £13,826 | |
| 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 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | |
| Bill Payments | £1,280 | £8,361 | £7,523 | £9,984 | £12,115 | £28,000 | £32,190 | £25,112 | £17,839 | £19,145 | £17,111 | £15,817 | |
| Subtotal Spent on Operations | £3,840 | £10,921 | £10,083 | £12,544 | £14,675 | £30,560 | £34,750 | £27,672 | £20,399 | £21,705 | £19,671 | £18,377 | |
| 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,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | £1,085 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £4,925 | £12,006 | £11,168 | £13,629 | £15,760 | £31,645 | £35,835 | £28,757 | £21,484 | £22,790 | £20,756 | £19,462 | |
| Net Cash Flow | £342 | (£3,093) | £4,394 | £12,256 | £12,593 | (£721) | (£1,155) | £67 | £1,798 | (£1,358) | (£4,916) | (£5,636) | |
| Cash Balance | £22,242 | £19,149 | £23,544 | £35,799 | £48,392 | £47,671 | £46,516 | £46,583 | £48,381 | £47,023 | £42,107 | £36,471 | |
| 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 | £21,900 | £22,242 | £19,149 | £23,544 | £35,799 | £48,392 | £47,671 | £46,516 | £46,583 | £48,381 | £47,023 | £42,107 | £36,471 |
| Inventory | £28,350 | £27,945 | £27,405 | £21,979 | £12,971 | £15,722 | £19,807 | £18,433 | £14,264 | £12,923 | £8,121 | £7,473 | £6,878 |
| Other Current Assets | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Total Current Assets | £51,250 | £51,187 | £47,554 | £46,522 | £49,770 | £65,114 | £68,478 | £65,949 | £61,847 | £62,304 | £56,144 | £50,580 | £44,349 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 | £8,500 |
| Accumulated Depreciation | £0 | £180 | £360 | £540 | £720 | £900 | £1,080 | £1,260 | £1,440 | £1,620 | £1,800 | £1,980 | £2,160 |
| Total Long-term Assets | £8,500 | £8,320 | £8,140 | £7,960 | £7,780 | £7,600 | £7,420 | £7,240 | £7,060 | £6,880 | £6,700 | £6,520 | £6,340 |
| Total Assets | £59,750 | £59,507 | £55,694 | £54,482 | £57,550 | £72,714 | £75,898 | £73,189 | £68,907 | £69,184 | £62,844 | £57,100 | £50,689 |
| 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 | £1,000 | £8,113 | £7,192 | £9,599 | £11,187 | £26,919 | £31,344 | £24,519 | £17,198 | £18,573 | £16,583 | £15,306 | £14,802 |
| 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 | £1,000 | £8,113 | £7,192 | £9,599 | £11,187 | £26,919 | £31,344 | £24,519 | £17,198 | £18,573 | £16,583 | £15,306 | £14,802 |
| Long-term Liabilities | £65,000 | £63,915 | £62,830 | £61,745 | £60,660 | £59,575 | £58,490 | £57,405 | £56,320 | £55,235 | £54,150 | £53,065 | £51,980 |
| Total Liabilities | £66,000 | £72,028 | £70,022 | £71,344 | £71,847 | £86,494 | £89,834 | £81,924 | £73,518 | £73,808 | £70,733 | £68,371 | £66,782 |
| Paid-in Capital | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Retained Earnings | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) | (£36,250) |
| Earnings | £0 | (£6,271) | (£8,077) | (£10,611) | (£8,047) | (£7,530) | (£7,686) | (£2,486) | £1,639 | £1,626 | (£1,640) | (£5,022) | (£9,842) |
| Total Capital | (£6,250) | (£12,521) | (£14,327) | (£16,861) | (£14,297) | (£13,780) | (£13,936) | (£8,736) | (£4,611) | (£4,624) | (£7,890) | (£11,272) | (£16,092) |
| Total Liabilities and Capital | £59,750 | £59,507 | £55,694 | £54,482 | £57,550 | £72,714 | £75,898 | £73,189 | £68,907 | £69,184 | £62,844 | £57,100 | £50,689 |
| Net Worth | (£6,250) | (£12,521) | (£14,327) | (£16,861) | (£14,297) | (£13,780) | (£13,936) | (£8,736) | (£4,611) | (£4,624) | (£7,890) | (£11,272) | (£16,092) |