| 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 | |||||||||||||
| Wholesale Distributors | 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 |
| Landscaping Professionals | 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 | |
| Wholesale Distributors | £4,000 | £4,000 | £4,000 | £4,400 | £6,000 | £6,300 | £8,000 | £8,200 | £9,000 | £10,000 | £10,000 | £12,000 | |
| Landscaping Professionals | £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 | ||
| Chales Marshall | 0% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Production Manager | 0% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Production Staff (3) | 0% | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £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 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| Sales and Marketing and Other Expenses | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | |
| Profit Before Interest and Taxes | (£3,700) | (£3,700) | (£2,700) | (£1,180) | (£900) | £2,220 | £2,600 | £2,360 | £4,500 | £4,300 | £6,300 | £6,800 | |
| EBITDA | (£3,460) | (£3,460) | (£2,460) | (£940) | (£660) | £2,460 | £2,840 | £2,600 | £4,740 | £4,540 | £6,540 | £7,040 | |
| Interest Expense | £827 | £820 | £813 | £807 | £800 | £793 | £787 | £780 | £773 | £767 | £760 | £753 | |
| Taxes Incurred | (£1,358) | (£1,356) | (£1,054) | (£596) | (£510) | £428 | £544 | £474 | £1,118 | £1,060 | £1,662 | £1,814 | |
| Net Profit | (£3,169) | (£3,164) | (£2,459) | (£1,391) | (£1,190) | £999 | £1,269 | £1,106 | £2,609 | £2,473 | £3,878 | £4,233 | |
| Net Profit/Sales | -16.68% | -16.65% | -12.30% | -6.32% | -4.96% | 3.63% | 4.23% | 3.69% | 7.91% | 7.27% | 10.77% | 10.85% | |
| 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,700 | £5,700 | £6,000 | £6,600 | £7,200 | £8,250 | £9,000 | £9,000 | £9,900 | £10,200 | £10,800 | £11,700 | |
| Cash from Receivables | £0 | £443 | £13,300 | £13,323 | £14,047 | £15,447 | £16,882 | £19,308 | £21,000 | £21,070 | £23,123 | £23,847 | |
| Subtotal Cash from Operations | £5,700 | £6,143 | £19,300 | £19,923 | £21,247 | £23,697 | £25,882 | £28,308 | £30,900 | £31,270 | £33,923 | £35,547 | |
| 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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £5,700 | £6,143 | £19,300 | £19,923 | £21,247 | £33,697 | £25,882 | £28,308 | £30,900 | £31,270 | £33,923 | £35,547 | |
| 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 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| Bill Payments | £218 | £6,529 | £6,567 | £7,985 | £12,901 | £16,437 | £16,417 | £20,359 | £18,591 | £20,748 | £22,183 | £21,662 | |
| Subtotal Spent on Operations | £10,618 | £16,929 | £16,967 | £18,385 | £23,301 | £26,837 | £26,817 | £30,759 | £28,991 | £31,148 | £32,583 | £32,062 | |
| 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 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| 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 | £11,418 | £17,729 | £17,767 | £19,185 | £24,101 | £27,637 | £27,617 | £31,559 | £29,791 | £31,948 | £33,383 | £32,862 | |
| Net Cash Flow | (£5,718) | (£11,585) | £1,533 | £739 | (£2,854) | £6,060 | (£1,736) | (£3,251) | £1,109 | (£678) | £541 | £2,685 | |
| Cash Balance | £16,482 | £4,897 | £6,430 | £7,169 | £4,315 | £10,375 | £8,639 | £5,388 | £6,497 | £5,820 | £6,361 | £9,045 | |
| 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 | £22,200 | £16,482 | £4,897 | £6,430 | £7,169 | £4,315 | £10,375 | £8,639 | £5,388 | £6,497 | £5,820 | £6,361 | £9,045 |
| Accounts Receivable | £0 | £13,300 | £26,157 | £26,857 | £28,933 | £31,687 | £35,490 | £39,608 | £41,300 | £43,400 | £46,130 | £48,207 | £51,660 |
| Inventory | £20,000 | £15,000 | £10,000 | £6,000 | £6,028 | £7,920 | £8,338 | £10,670 | £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 | £42,200 | £44,782 | £41,054 | £39,287 | £42,130 | £43,921 | £54,203 | £58,917 | £57,622 | £61,777 | £65,150 | £67,767 | £76,655 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,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 | £50,000 | £49,760 | £49,520 | £49,280 | £49,040 | £48,800 | £48,560 | £48,320 | £48,080 | £47,840 | £47,600 | £47,360 | £47,120 |
| Total Assets | £92,200 | £94,542 | £90,574 | £88,567 | £91,170 | £92,721 | £102,763 | £107,237 | £105,702 | £109,617 | £112,750 | £115,127 | £123,775 |
| 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 | £6,311 | £6,307 | £7,559 | £12,353 | £15,894 | £15,737 | £19,742 | £17,901 | £20,007 | £21,466 | £20,766 | £25,981 |
| 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 | £6,311 | £6,307 | £7,559 | £12,353 | £15,894 | £15,737 | £19,742 | £17,901 | £20,007 | £21,466 | £20,766 | £25,981 |
| Long-term Liabilities | £100,000 | £99,200 | £98,400 | £97,600 | £96,800 | £96,000 | £95,200 | £94,400 | £93,600 | £92,800 | £92,000 | £91,200 | £90,400 |
| Total Liabilities | £100,000 | £105,511 | £104,707 | £105,159 | £109,153 | £111,894 | £110,937 | £114,142 | £111,501 | £112,807 | £113,466 | £111,966 | £116,381 |
| Paid-in Capital | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £110,000 | £110,000 | £110,000 | £110,000 | £110,000 | £110,000 | £110,000 |
| Retained Earnings | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) |
| Earnings | £0 | (£3,169) | (£6,333) | (£8,792) | (£10,183) | (£11,373) | (£10,374) | (£9,105) | (£7,999) | (£5,390) | (£2,917) | £961 | £5,194 |
| Total Capital | (£7,800) | (£10,969) | (£14,133) | (£16,592) | (£17,983) | (£19,173) | (£8,174) | (£6,905) | (£5,799) | (£3,190) | (£717) | £3,161 | £7,394 |
| Total Liabilities and Capital | £92,200 | £94,542 | £90,574 | £88,567 | £91,170 | £92,721 | £102,763 | £107,237 | £105,702 | £109,617 | £112,750 | £115,127 | £123,775 |
| Net Worth | (£7,800) | (£10,969) | (£14,133) | (£16,592) | (£17,983) | (£19,173) | (£8,174) | (£6,905) | (£5,799) | (£3,190) | (£717) | £3,161 | £7,394 |
| 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 | |||||||||||||
| Wholesale Distributors | 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 |
| Landscaping Professionals | 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 | |
| Wholesale Distributors | £4,000 | £4,000 | £4,000 | £4,400 | £6,000 | £6,300 | £8,000 | £8,200 | £9,000 | £10,000 | £10,000 | £12,000 | |
| Landscaping Professionals | £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 | ||
| Chales Marshall | 0% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Production Manager | 0% | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 | £2,800 |
| Production Staff (3) | 0% | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
| Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Sales | £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 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| Sales and Marketing and Other Expenses | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| 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,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 | £1,560 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | £17,700 | |
| Profit Before Interest and Taxes | (£3,700) | (£3,700) | (£2,700) | (£1,180) | (£900) | £2,220 | £2,600 | £2,360 | £4,500 | £4,300 | £6,300 | £6,800 | |
| EBITDA | (£3,460) | (£3,460) | (£2,460) | (£940) | (£660) | £2,460 | £2,840 | £2,600 | £4,740 | £4,540 | £6,540 | £7,040 | |
| Interest Expense | £827 | £820 | £813 | £807 | £800 | £793 | £787 | £780 | £773 | £767 | £760 | £753 | |
| Taxes Incurred | (£1,358) | (£1,356) | (£1,054) | (£596) | (£510) | £428 | £544 | £474 | £1,118 | £1,060 | £1,662 | £1,814 | |
| Net Profit | (£3,169) | (£3,164) | (£2,459) | (£1,391) | (£1,190) | £999 | £1,269 | £1,106 | £2,609 | £2,473 | £3,878 | £4,233 | |
| Net Profit/Sales | -16.68% | -16.65% | -12.30% | -6.32% | -4.96% | 3.63% | 4.23% | 3.69% | 7.91% | 7.27% | 10.77% | 10.85% | |
| 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,700 | £5,700 | £6,000 | £6,600 | £7,200 | £8,250 | £9,000 | £9,000 | £9,900 | £10,200 | £10,800 | £11,700 | |
| Cash from Receivables | £0 | £443 | £13,300 | £13,323 | £14,047 | £15,447 | £16,882 | £19,308 | £21,000 | £21,070 | £23,123 | £23,847 | |
| Subtotal Cash from Operations | £5,700 | £6,143 | £19,300 | £19,923 | £21,247 | £23,697 | £25,882 | £28,308 | £30,900 | £31,270 | £33,923 | £35,547 | |
| 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 | £10,000 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £5,700 | £6,143 | £19,300 | £19,923 | £21,247 | £33,697 | £25,882 | £28,308 | £30,900 | £31,270 | £33,923 | £35,547 | |
| 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 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | £10,400 | |
| Bill Payments | £218 | £6,529 | £6,567 | £7,985 | £12,901 | £16,437 | £16,417 | £20,359 | £18,591 | £20,748 | £22,183 | £21,662 | |
| Subtotal Spent on Operations | £10,618 | £16,929 | £16,967 | £18,385 | £23,301 | £26,837 | £26,817 | £30,759 | £28,991 | £31,148 | £32,583 | £32,062 | |
| 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 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| 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 | £11,418 | £17,729 | £17,767 | £19,185 | £24,101 | £27,637 | £27,617 | £31,559 | £29,791 | £31,948 | £33,383 | £32,862 | |
| Net Cash Flow | (£5,718) | (£11,585) | £1,533 | £739 | (£2,854) | £6,060 | (£1,736) | (£3,251) | £1,109 | (£678) | £541 | £2,685 | |
| Cash Balance | £16,482 | £4,897 | £6,430 | £7,169 | £4,315 | £10,375 | £8,639 | £5,388 | £6,497 | £5,820 | £6,361 | £9,045 | |
| 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 | £22,200 | £16,482 | £4,897 | £6,430 | £7,169 | £4,315 | £10,375 | £8,639 | £5,388 | £6,497 | £5,820 | £6,361 | £9,045 |
| Accounts Receivable | £0 | £13,300 | £26,157 | £26,857 | £28,933 | £31,687 | £35,490 | £39,608 | £41,300 | £43,400 | £46,130 | £48,207 | £51,660 |
| Inventory | £20,000 | £15,000 | £10,000 | £6,000 | £6,028 | £7,920 | £8,338 | £10,670 | £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 | £42,200 | £44,782 | £41,054 | £39,287 | £42,130 | £43,921 | £54,203 | £58,917 | £57,622 | £61,777 | £65,150 | £67,767 | £76,655 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,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 | £50,000 | £49,760 | £49,520 | £49,280 | £49,040 | £48,800 | £48,560 | £48,320 | £48,080 | £47,840 | £47,600 | £47,360 | £47,120 |
| Total Assets | £92,200 | £94,542 | £90,574 | £88,567 | £91,170 | £92,721 | £102,763 | £107,237 | £105,702 | £109,617 | £112,750 | £115,127 | £123,775 |
| 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 | £6,311 | £6,307 | £7,559 | £12,353 | £15,894 | £15,737 | £19,742 | £17,901 | £20,007 | £21,466 | £20,766 | £25,981 |
| 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 | £6,311 | £6,307 | £7,559 | £12,353 | £15,894 | £15,737 | £19,742 | £17,901 | £20,007 | £21,466 | £20,766 | £25,981 |
| Long-term Liabilities | £100,000 | £99,200 | £98,400 | £97,600 | £96,800 | £96,000 | £95,200 | £94,400 | £93,600 | £92,800 | £92,000 | £91,200 | £90,400 |
| Total Liabilities | £100,000 | £105,511 | £104,707 | £105,159 | £109,153 | £111,894 | £110,937 | £114,142 | £111,501 | £112,807 | £113,466 | £111,966 | £116,381 |
| Paid-in Capital | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £100,000 | £110,000 | £110,000 | £110,000 | £110,000 | £110,000 | £110,000 | £110,000 |
| Retained Earnings | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) | (£107,800) |
| Earnings | £0 | (£3,169) | (£6,333) | (£8,792) | (£10,183) | (£11,373) | (£10,374) | (£9,105) | (£7,999) | (£5,390) | (£2,917) | £961 | £5,194 |
| Total Capital | (£7,800) | (£10,969) | (£14,133) | (£16,592) | (£17,983) | (£19,173) | (£8,174) | (£6,905) | (£5,799) | (£3,190) | (£717) | £3,161 | £7,394 |
| Total Liabilities and Capital | £92,200 | £94,542 | £90,574 | £88,567 | £91,170 | £92,721 | £102,763 | £107,237 | £105,702 | £109,617 | £112,750 | £115,127 | £123,775 |
| Net Worth | (£7,800) | (£10,969) | (£14,133) | (£16,592) | (£17,983) | (£19,173) | (£8,174) | (£6,905) | (£5,799) | (£3,190) | (£717) | £3,161 | £7,394 |