| 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 | |||||||||||||
| Hot Teas | 0% | £1,500 | £2,500 | £3,000 | £3,000 | £3,200 | £4,000 | £6,000 | £6,200 | £6,500 | £6,000 | £5,500 | £5,000 |
| Iced Teas | 0% | £2,500 | £3,000 | £3,800 | £3,400 | £2,000 | £1,400 | £800 | £600 | £500 | £900 | £1,500 | £2,000 |
| Pastries | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Chocolate | 0% | £3,000 | £5,000 | £8,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £14,000 | £7,000 | £9,000 | £7,000 |
| Tea Paraphernalia | 0% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Gift Baskets | 0% | £200 | £220 | £225 | £250 | £300 | £300 | £800 | £200 | £600 | £200 | £400 | £200 |
| Loose Teas | 0% | £600 | £500 | £500 | £600 | £700 | £950 | £1,100 | £1,000 | £1,000 | £1,100 | £1,000 | £1,100 |
| Total Sales | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| 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 | |
| Hot Teas | £450 | £750 | £900 | £900 | £960 | £1,200 | £1,800 | £1,860 | £1,950 | £1,800 | £1,650 | £1,500 | |
| Iced Teas | £800 | £960 | £1,216 | £1,088 | £640 | £448 | £256 | £192 | £160 | £288 | £480 | £640 | |
| Pastries | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | |
| Chocolate | £1,350 | £2,250 | £3,600 | £3,150 | £3,150 | £3,150 | £3,150 | £3,150 | £6,300 | £3,150 | £4,050 | £3,150 | |
| Tea Paraphernalia | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Gift Baskets | £80 | £88 | £90 | £100 | £120 | £120 | £320 | £80 | £240 | £80 | £160 | £80 | |
| Loose Teas | £240 | £200 | £200 | £240 | £280 | £380 | £440 | £400 | £400 | £440 | £400 | £440 | |
| Subtotal Direct Cost of Sales | £3,837 | £5,165 | £6,923 | £6,395 | £6,067 | £6,215 | £6,883 | £6,599 | £9,967 | £6,675 | £7,657 | £6,727 | |
| 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 | ||
| Earl Grey | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Lady Grey | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part-time tea-tenders | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,400 | £1,400 | £1,000 | £1,400 | £1,000 | £1,400 | £1,000 |
| Total People | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 4 | 3 | 4 | 4 | |
| Total Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,900 | £3,900 | £3,500 | £3,900 | £3,500 | £3,900 | £3,500 | |
| 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 | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | |
| Long-term Interest Rate | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.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 | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| Direct Cost of Sales | £3,837 | £5,165 | £6,923 | £6,395 | £6,067 | £6,215 | £6,883 | £6,599 | £9,967 | £6,675 | £7,657 | £6,727 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,837 | £5,165 | £6,923 | £6,395 | £6,067 | £6,215 | £6,883 | £6,599 | £9,967 | £6,675 | £7,657 | £6,727 | |
| Gross Margin | £5,413 | £7,505 | £10,052 | £9,305 | £8,583 | £8,885 | £10,267 | £9,851 | £14,083 | £9,975 | £11,193 | £10,023 | |
| Gross Margin % | 58.52% | 59.23% | 59.22% | 59.27% | 58.59% | 58.84% | 59.87% | 59.88% | 58.56% | 59.91% | 59.38% | 59.84% | |
| Expenses | |||||||||||||
| Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,900 | £3,900 | £3,500 | £3,900 | £3,500 | £3,900 | £3,500 | |
| Marketing/Promotion | £1,500 | £300 | £300 | £300 | £300 | £300 | £600 | £300 | £600 | £300 | £300 | £300 | |
| Depreciation | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Utilities | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £900 | £900 | |
| Monthly disposable supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Payroll Taxes | 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,753 | £6,553 | £6,553 | £6,553 | £6,553 | £6,953 | £7,253 | £6,553 | £7,253 | £6,553 | £7,232 | £6,832 | |
| Profit Before Interest and Taxes | (£2,340) | £952 | £3,499 | £2,752 | £2,030 | £1,932 | £3,014 | £3,298 | £6,830 | £3,422 | £3,961 | £3,191 | |
| EBITDA | (£2,225) | £1,067 | £3,614 | £2,867 | £2,145 | £2,047 | £3,129 | £3,413 | £6,945 | £3,537 | £4,076 | £3,306 | |
| Interest Expense | £408 | £402 | £396 | £390 | £385 | £379 | £373 | £367 | £362 | £356 | £350 | £345 | |
| Taxes Incurred | (£824) | £165 | £931 | £709 | £494 | £466 | £792 | £879 | £1,941 | £920 | £1,083 | £854 | |
| Net Profit | (£1,923) | £385 | £2,172 | £1,653 | £1,152 | £1,087 | £1,849 | £2,052 | £4,528 | £2,146 | £2,528 | £1,993 | |
| Net Profit/Sales | -20.79% | 3.04% | 12.80% | 10.53% | 7.86% | 7.20% | 10.78% | 12.47% | 18.83% | 12.89% | 13.41% | 11.90% | |
| 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 | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| Subtotal Cash from Operations | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 6.00% | £555 | £760 | £1,019 | £942 | £879 | £906 | £1,029 | £987 | £1,443 | £999 | £1,131 | £1,005 |
| 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 | £9,805 | £13,430 | £17,994 | £16,642 | £15,529 | £16,006 | £18,179 | £17,437 | £25,493 | £17,649 | £19,981 | £17,755 | |
| 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,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,900 | £3,900 | £3,500 | £3,900 | £3,500 | £3,900 | £3,500 | |
| Bill Payments | £124 | £3,870 | £8,353 | £13,013 | £9,840 | £9,544 | £10,222 | £11,969 | £10,762 | £18,814 | £7,471 | £13,279 | |
| Subtotal Spent on Operations | £3,624 | £7,370 | £11,853 | £16,513 | £13,340 | £13,444 | £14,122 | £15,469 | £14,662 | £22,314 | £11,371 | £16,779 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £555 | £760 | £1,019 | £942 | £879 | £906 | £1,029 | £987 | £1,443 | £999 | £1,131 | £1,005 | |
| 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 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | |
| 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,924 | £8,875 | £13,616 | £18,199 | £14,964 | £15,094 | £15,896 | £17,201 | £16,850 | £24,057 | £13,247 | £18,528 | |
| Net Cash Flow | £4,881 | £4,555 | £4,377 | (£1,557) | £565 | £912 | £2,283 | £236 | £8,643 | (£6,408) | £6,734 | (£773) | |
| Cash Balance | £19,881 | £24,436 | £28,814 | £27,256 | £27,822 | £28,733 | £31,016 | £31,252 | £39,895 | £33,486 | £40,220 | £39,446 | |
| 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 | £15,000 | £19,881 | £24,436 | £28,814 | £27,256 | £27,822 | £28,733 | £31,016 | £31,252 | £39,895 | £33,486 | £40,220 | £39,446 |
| Inventory | £10,000 | £6,163 | £5,682 | £7,615 | £7,035 | £6,674 | £6,837 | £7,571 | £7,259 | £10,964 | £7,343 | £8,423 | £7,400 |
| Other Current Assets | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 |
| Total Current Assets | £31,605 | £32,649 | £36,723 | £43,034 | £40,896 | £41,100 | £42,175 | £45,192 | £45,116 | £57,463 | £47,434 | £55,248 | £53,451 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 |
| Accumulated Depreciation | £0 | £115 | £230 | £345 | £460 | £575 | £690 | £805 | £920 | £1,035 | £1,150 | £1,265 | £1,380 |
| Total Long-term Assets | £13,808 | £13,693 | £13,578 | £13,463 | £13,348 | £13,233 | £13,118 | £13,003 | £12,888 | £12,773 | £12,658 | £12,543 | £12,428 |
| Total Assets | £45,413 | £46,342 | £50,301 | £56,497 | £54,244 | £54,333 | £55,293 | £58,195 | £58,004 | £70,236 | £60,092 | £67,791 | £65,879 |
| 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 | £3,597 | £7,915 | £12,684 | £9,523 | £9,205 | £9,822 | £11,620 | £10,122 | £18,571 | £7,025 | £12,941 | £9,782 |
| 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 | £3,597 | £7,915 | £12,684 | £9,523 | £9,205 | £9,822 | £11,620 | £10,122 | £18,571 | £7,025 | £12,941 | £9,782 |
| Long-term Liabilities | £53,633 | £52,888 | £52,143 | £51,399 | £50,654 | £49,909 | £49,164 | £48,419 | £47,674 | £46,930 | £46,185 | £45,440 | £44,695 |
| Total Liabilities | £53,633 | £56,485 | £60,059 | £64,083 | £60,176 | £59,114 | £58,986 | £60,040 | £57,796 | £65,501 | £53,210 | £58,381 | £54,477 |
| Paid-in Capital | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 |
| Retained Earnings | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) |
| Earnings | £0 | (£1,923) | (£1,538) | £634 | £2,288 | £3,440 | £4,527 | £6,376 | £8,427 | £12,955 | £15,102 | £17,629 | £19,622 |
| Total Capital | (£8,220) | (£10,143) | (£9,758) | (£7,586) | (£5,932) | (£4,780) | (£3,693) | (£1,844) | £207 | £4,735 | £6,882 | £9,409 | £11,402 |
| Total Liabilities and Capital | £45,413 | £46,342 | £50,301 | £56,497 | £54,244 | £54,333 | £55,293 | £58,195 | £58,004 | £70,236 | £60,092 | £67,791 | £65,879 |
| Net Worth | (£8,220) | (£10,143) | (£9,758) | (£7,586) | (£5,932) | (£4,780) | (£3,693) | (£1,844) | £207 | £4,735 | £6,882 | £9,409 | £11,402 |
| 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 | |||||||||||||
| Hot Teas | 0% | £1,500 | £2,500 | £3,000 | £3,000 | £3,200 | £4,000 | £6,000 | £6,200 | £6,500 | £6,000 | £5,500 | £5,000 |
| Iced Teas | 0% | £2,500 | £3,000 | £3,800 | £3,400 | £2,000 | £1,400 | £800 | £600 | £500 | £900 | £1,500 | £2,000 |
| Pastries | 0% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Chocolate | 0% | £3,000 | £5,000 | £8,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £14,000 | £7,000 | £9,000 | £7,000 |
| Tea Paraphernalia | 0% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Gift Baskets | 0% | £200 | £220 | £225 | £250 | £300 | £300 | £800 | £200 | £600 | £200 | £400 | £200 |
| Loose Teas | 0% | £600 | £500 | £500 | £600 | £700 | £950 | £1,100 | £1,000 | £1,000 | £1,100 | £1,000 | £1,100 |
| Total Sales | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| 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 | |
| Hot Teas | £450 | £750 | £900 | £900 | £960 | £1,200 | £1,800 | £1,860 | £1,950 | £1,800 | £1,650 | £1,500 | |
| Iced Teas | £800 | £960 | £1,216 | £1,088 | £640 | £448 | £256 | £192 | £160 | £288 | £480 | £640 | |
| Pastries | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | £792 | |
| Chocolate | £1,350 | £2,250 | £3,600 | £3,150 | £3,150 | £3,150 | £3,150 | £3,150 | £6,300 | £3,150 | £4,050 | £3,150 | |
| Tea Paraphernalia | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Gift Baskets | £80 | £88 | £90 | £100 | £120 | £120 | £320 | £80 | £240 | £80 | £160 | £80 | |
| Loose Teas | £240 | £200 | £200 | £240 | £280 | £380 | £440 | £400 | £400 | £440 | £400 | £440 | |
| Subtotal Direct Cost of Sales | £3,837 | £5,165 | £6,923 | £6,395 | £6,067 | £6,215 | £6,883 | £6,599 | £9,967 | £6,675 | £7,657 | £6,727 | |
| 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 | ||
| Earl Grey | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Lady Grey | 0% | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Part-time tea-tenders | 0% | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,400 | £1,400 | £1,000 | £1,400 | £1,000 | £1,400 | £1,000 |
| Total People | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 4 | 3 | 4 | 4 | |
| Total Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,900 | £3,900 | £3,500 | £3,900 | £3,500 | £3,900 | £3,500 | |
| 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 | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | 9.50% | |
| Long-term Interest Rate | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.25% | 9.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 | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| Direct Cost of Sales | £3,837 | £5,165 | £6,923 | £6,395 | £6,067 | £6,215 | £6,883 | £6,599 | £9,967 | £6,675 | £7,657 | £6,727 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,837 | £5,165 | £6,923 | £6,395 | £6,067 | £6,215 | £6,883 | £6,599 | £9,967 | £6,675 | £7,657 | £6,727 | |
| Gross Margin | £5,413 | £7,505 | £10,052 | £9,305 | £8,583 | £8,885 | £10,267 | £9,851 | £14,083 | £9,975 | £11,193 | £10,023 | |
| Gross Margin % | 58.52% | 59.23% | 59.22% | 59.27% | 58.59% | 58.84% | 59.87% | 59.88% | 58.56% | 59.91% | 59.38% | 59.84% | |
| Expenses | |||||||||||||
| Payroll | £3,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,900 | £3,900 | £3,500 | £3,900 | £3,500 | £3,900 | £3,500 | |
| Marketing/Promotion | £1,500 | £300 | £300 | £300 | £300 | £300 | £600 | £300 | £600 | £300 | £300 | £300 | |
| Depreciation | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | £115 | |
| Rent | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Utilities | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £621 | £900 | £900 | |
| Monthly disposable supplies | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Payroll Taxes | 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £7,753 | £6,553 | £6,553 | £6,553 | £6,553 | £6,953 | £7,253 | £6,553 | £7,253 | £6,553 | £7,232 | £6,832 | |
| Profit Before Interest and Taxes | (£2,340) | £952 | £3,499 | £2,752 | £2,030 | £1,932 | £3,014 | £3,298 | £6,830 | £3,422 | £3,961 | £3,191 | |
| EBITDA | (£2,225) | £1,067 | £3,614 | £2,867 | £2,145 | £2,047 | £3,129 | £3,413 | £6,945 | £3,537 | £4,076 | £3,306 | |
| Interest Expense | £408 | £402 | £396 | £390 | £385 | £379 | £373 | £367 | £362 | £356 | £350 | £345 | |
| Taxes Incurred | (£824) | £165 | £931 | £709 | £494 | £466 | £792 | £879 | £1,941 | £920 | £1,083 | £854 | |
| Net Profit | (£1,923) | £385 | £2,172 | £1,653 | £1,152 | £1,087 | £1,849 | £2,052 | £4,528 | £2,146 | £2,528 | £1,993 | |
| Net Profit/Sales | -20.79% | 3.04% | 12.80% | 10.53% | 7.86% | 7.20% | 10.78% | 12.47% | 18.83% | 12.89% | 13.41% | 11.90% | |
| 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 | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| Subtotal Cash from Operations | £9,250 | £12,670 | £16,975 | £15,700 | £14,650 | £15,100 | £17,150 | £16,450 | £24,050 | £16,650 | £18,850 | £16,750 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 6.00% | £555 | £760 | £1,019 | £942 | £879 | £906 | £1,029 | £987 | £1,443 | £999 | £1,131 | £1,005 |
| 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 | £9,805 | £13,430 | £17,994 | £16,642 | £15,529 | £16,006 | £18,179 | £17,437 | £25,493 | £17,649 | £19,981 | £17,755 | |
| 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,500 | £3,500 | £3,500 | £3,500 | £3,500 | £3,900 | £3,900 | £3,500 | £3,900 | £3,500 | £3,900 | £3,500 | |
| Bill Payments | £124 | £3,870 | £8,353 | £13,013 | £9,840 | £9,544 | £10,222 | £11,969 | £10,762 | £18,814 | £7,471 | £13,279 | |
| Subtotal Spent on Operations | £3,624 | £7,370 | £11,853 | £16,513 | £13,340 | £13,444 | £14,122 | £15,469 | £14,662 | £22,314 | £11,371 | £16,779 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £555 | £760 | £1,019 | £942 | £879 | £906 | £1,029 | £987 | £1,443 | £999 | £1,131 | £1,005 | |
| 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 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | £745 | |
| 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,924 | £8,875 | £13,616 | £18,199 | £14,964 | £15,094 | £15,896 | £17,201 | £16,850 | £24,057 | £13,247 | £18,528 | |
| Net Cash Flow | £4,881 | £4,555 | £4,377 | (£1,557) | £565 | £912 | £2,283 | £236 | £8,643 | (£6,408) | £6,734 | (£773) | |
| Cash Balance | £19,881 | £24,436 | £28,814 | £27,256 | £27,822 | £28,733 | £31,016 | £31,252 | £39,895 | £33,486 | £40,220 | £39,446 | |
| 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 | £15,000 | £19,881 | £24,436 | £28,814 | £27,256 | £27,822 | £28,733 | £31,016 | £31,252 | £39,895 | £33,486 | £40,220 | £39,446 |
| Inventory | £10,000 | £6,163 | £5,682 | £7,615 | £7,035 | £6,674 | £6,837 | £7,571 | £7,259 | £10,964 | £7,343 | £8,423 | £7,400 |
| Other Current Assets | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 | £6,605 |
| Total Current Assets | £31,605 | £32,649 | £36,723 | £43,034 | £40,896 | £41,100 | £42,175 | £45,192 | £45,116 | £57,463 | £47,434 | £55,248 | £53,451 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 | £13,808 |
| Accumulated Depreciation | £0 | £115 | £230 | £345 | £460 | £575 | £690 | £805 | £920 | £1,035 | £1,150 | £1,265 | £1,380 |
| Total Long-term Assets | £13,808 | £13,693 | £13,578 | £13,463 | £13,348 | £13,233 | £13,118 | £13,003 | £12,888 | £12,773 | £12,658 | £12,543 | £12,428 |
| Total Assets | £45,413 | £46,342 | £50,301 | £56,497 | £54,244 | £54,333 | £55,293 | £58,195 | £58,004 | £70,236 | £60,092 | £67,791 | £65,879 |
| 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 | £3,597 | £7,915 | £12,684 | £9,523 | £9,205 | £9,822 | £11,620 | £10,122 | £18,571 | £7,025 | £12,941 | £9,782 |
| 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 | £3,597 | £7,915 | £12,684 | £9,523 | £9,205 | £9,822 | £11,620 | £10,122 | £18,571 | £7,025 | £12,941 | £9,782 |
| Long-term Liabilities | £53,633 | £52,888 | £52,143 | £51,399 | £50,654 | £49,909 | £49,164 | £48,419 | £47,674 | £46,930 | £46,185 | £45,440 | £44,695 |
| Total Liabilities | £53,633 | £56,485 | £60,059 | £64,083 | £60,176 | £59,114 | £58,986 | £60,040 | £57,796 | £65,501 | £53,210 | £58,381 | £54,477 |
| Paid-in Capital | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 | £10,330 |
| Retained Earnings | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) | (£18,550) |
| Earnings | £0 | (£1,923) | (£1,538) | £634 | £2,288 | £3,440 | £4,527 | £6,376 | £8,427 | £12,955 | £15,102 | £17,629 | £19,622 |
| Total Capital | (£8,220) | (£10,143) | (£9,758) | (£7,586) | (£5,932) | (£4,780) | (£3,693) | (£1,844) | £207 | £4,735 | £6,882 | £9,409 | £11,402 |
| Total Liabilities and Capital | £45,413 | £46,342 | £50,301 | £56,497 | £54,244 | £54,333 | £55,293 | £58,195 | £58,004 | £70,236 | £60,092 | £67,791 | £65,879 |
| Net Worth | (£8,220) | (£10,143) | (£9,758) | (£7,586) | (£5,932) | (£4,780) | (£3,693) | (£1,844) | £207 | £4,735 | £6,882 | £9,409 | £11,402 |