| 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% | £0 | £10,000 | £14,000 | £13,000 | £16,000 | £17,500 | £18,000 | £18,000 | £20,000 | £20,000 | £20,000 | £22,000 |
| Consumers | 0% | £0 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Janitorial Professionals | 0% | £0 | £10,000 | £6,000 | £11,000 | £13,000 | £13,000 | £15,000 | £15,000 | £15,000 | £16,000 | £18,000 | £17,000 |
| Total Sales | £0 | £21,000 | £21,000 | £26,000 | £31,000 | £32,500 | £35,000 | £36,000 | £38,000 | £39,000 | £41,000 | £42,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 | £0 | £2,000 | £3,000 | £2,800 | £3,500 | £4,000 | £4,500 | £4,500 | £5,500 | £5,500 | £5,500 | £6,000 | |
| Consumers | £0 | £200 | £200 | £400 | £400 | £400 | £400 | £600 | £600 | £600 | £600 | £600 | |
| Janitorial Professionals | £0 | £2,000 | £1,000 | £1,800 | £2,000 | £3,000 | £3,500 | £3,500 | £3,500 | £4,000 | £4,500 | £4,000 | |
| Subtotal Direct Cost of Sales | £0 | £4,200 | £4,200 | £5,000 | £5,900 | £7,400 | £8,400 | £8,600 | £9,600 | £10,100 | £10,600 | £10,600 | |
| 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 | ||
| Charles 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,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Production Staff (3) | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Office Manager/Web Administrator | 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 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | |
| 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 | £0 | £21,000 | £21,000 | £26,000 | £31,000 | £32,500 | £35,000 | £36,000 | £38,000 | £39,000 | £41,000 | £42,000 | |
| Direct Cost of Sales | £0 | £4,200 | £4,200 | £5,000 | £5,900 | £7,400 | £8,400 | £8,600 | £9,600 | £10,100 | £10,600 | £10,600 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £4,200 | £4,200 | £5,000 | £5,900 | £7,400 | £8,400 | £8,600 | £9,600 | £10,100 | £10,600 | £10,600 | |
| Gross Margin | £0 | £16,800 | £16,800 | £21,000 | £25,100 | £25,100 | £26,600 | £27,400 | £28,400 | £28,900 | £30,400 | £31,400 | |
| Gross Margin % | 0.00% | 80.00% | 80.00% | 80.77% | 80.97% | 77.23% | 76.00% | 76.11% | 74.74% | 74.10% | 74.15% | 74.76% | |
| Expenses | |||||||||||||
| Payroll | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | |
| 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% | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | |
| Profit Before Interest and Taxes | (£20,155) | (£3,355) | (£3,355) | £845 | £4,945 | £4,945 | £6,445 | £7,245 | £8,245 | £8,745 | £10,245 | £11,245 | |
| EBITDA | (£19,915) | (£3,115) | (£3,115) | £1,085 | £5,185 | £5,185 | £6,685 | £7,485 | £8,485 | £8,985 | £10,485 | £11,485 | |
| Interest Expense | £824 | £814 | £804 | £794 | £834 | £824 | £812 | £801 | £789 | £777 | £765 | £753 | |
| Taxes Incurred | (£6,294) | (£1,251) | (£1,248) | £15 | £1,233 | £1,236 | £1,690 | £1,933 | £2,237 | £2,391 | £2,844 | £3,148 | |
| Net Profit | (£14,685) | (£2,918) | (£2,911) | £36 | £2,878 | £2,884 | £3,943 | £4,511 | £5,219 | £5,578 | £6,636 | £7,345 | |
| Net Profit/Sales | 0.00% | -13.90% | -13.86% | 0.14% | 9.28% | 8.88% | 11.27% | 12.53% | 13.74% | 14.30% | 16.19% | 17.49% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £10,500 | £10,500 | £13,000 | £15,500 | £16,250 | £17,500 | £18,000 | £19,000 | £19,500 | £20,500 | £21,000 | |
| Cash from Receivables | £0 | £0 | £350 | £10,500 | £10,583 | £13,083 | £15,525 | £16,292 | £17,517 | £18,033 | £19,017 | £19,533 | |
| Subtotal Cash from Operations | £0 | £10,500 | £10,850 | £23,500 | £26,083 | £29,333 | £33,025 | £34,292 | £36,517 | £37,533 | £39,517 | £40,533 | |
| 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 | £6,000 | £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 | £0 | £10,500 | £10,850 | £23,500 | £32,083 | £29,333 | £33,025 | £34,292 | £36,517 | £37,533 | £39,517 | £40,533 | |
| 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,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | |
| Bill Payments | £71 | £2,440 | £11,011 | £11,469 | £14,380 | £16,644 | £18,755 | £19,602 | £19,241 | £21,344 | £21,464 | £22,365 | |
| Subtotal Spent on Operations | £12,371 | £14,740 | £23,311 | £23,769 | £26,680 | £28,944 | £31,055 | £31,902 | £31,541 | £33,644 | £33,764 | £34,665 | |
| 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 | £250 | £250 | £250 | £250 | £250 | £250 | |
| 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,551 | £15,920 | £24,491 | £24,949 | £27,860 | £30,124 | £32,485 | £33,332 | £32,971 | £35,074 | £35,194 | £36,095 | |
| Net Cash Flow | (£13,551) | (£5,420) | (£13,641) | (£1,449) | £4,223 | (£791) | £540 | £959 | £3,545 | £2,460 | £4,323 | £4,438 | |
| Cash Balance | £26,649 | £21,228 | £7,588 | £6,139 | £10,362 | £9,572 | £10,111 | £11,071 | £14,616 | £17,076 | £21,399 | £25,837 | |
| 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 | £40,200 | £26,649 | £21,228 | £7,588 | £6,139 | £10,362 | £9,572 | £10,111 | £11,071 | £14,616 | £17,076 | £21,399 | £25,837 |
| Accounts Receivable | £0 | £0 | £10,500 | £20,650 | £23,150 | £28,067 | £31,233 | £33,208 | £34,917 | £36,400 | £37,867 | £39,350 | £40,817 |
| Inventory | £5,000 | £5,000 | £4,620 | £4,620 | £5,500 | £6,490 | £8,140 | £9,240 | £9,460 | £10,560 | £11,110 | £11,660 | £11,660 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £45,200 | £31,649 | £36,348 | £32,858 | £34,789 | £44,919 | £48,945 | £52,560 | £55,447 | £61,576 | £66,053 | £72,409 | £78,314 |
| 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 | £95,200 | £81,409 | £85,868 | £82,138 | £83,829 | £93,719 | £97,505 | £100,880 | £103,527 | £109,416 | £113,653 | £119,769 | £125,434 |
| 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 | £2,073 | £10,631 | £10,992 | £13,827 | £16,020 | £18,101 | £18,963 | £18,530 | £20,629 | £20,718 | £21,628 | £21,378 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £5,750 | £5,500 | £5,250 | £5,000 | £4,750 | £4,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £2,073 | £10,631 | £10,992 | £13,827 | £22,020 | £24,101 | £24,713 | £24,030 | £25,879 | £25,718 | £26,378 | £25,878 |
| 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 | £100,893 | £108,271 | £107,452 | £109,107 | £116,120 | £117,021 | £116,453 | £114,590 | £115,259 | £113,918 | £113,398 | £111,718 |
| Paid-in Capital | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 |
| Retained Earnings | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) |
| Earnings | £0 | (£14,685) | (£17,603) | (£20,514) | (£20,479) | (£17,601) | (£14,716) | (£10,774) | (£6,262) | (£1,043) | £4,535 | £11,171 | £18,516 |
| Total Capital | (£4,800) | (£19,485) | (£22,403) | (£25,314) | (£25,279) | (£22,401) | (£19,516) | (£15,574) | (£11,062) | (£5,843) | (£265) | £6,371 | £13,716 |
| Total Liabilities and Capital | £95,200 | £81,409 | £85,868 | £82,138 | £83,829 | £93,719 | £97,505 | £100,880 | £103,527 | £109,416 | £113,653 | £119,769 | £125,434 |
| Net Worth | (£4,800) | (£19,485) | (£22,403) | (£25,314) | (£25,279) | (£22,401) | (£19,516) | (£15,574) | (£11,062) | (£5,843) | (£265) | £6,371 | £13,716 |
| 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% | £0 | £10,000 | £14,000 | £13,000 | £16,000 | £17,500 | £18,000 | £18,000 | £20,000 | £20,000 | £20,000 | £22,000 |
| Consumers | 0% | £0 | £1,000 | £1,000 | £2,000 | £2,000 | £2,000 | £2,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Janitorial Professionals | 0% | £0 | £10,000 | £6,000 | £11,000 | £13,000 | £13,000 | £15,000 | £15,000 | £15,000 | £16,000 | £18,000 | £17,000 |
| Total Sales | £0 | £21,000 | £21,000 | £26,000 | £31,000 | £32,500 | £35,000 | £36,000 | £38,000 | £39,000 | £41,000 | £42,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 | £0 | £2,000 | £3,000 | £2,800 | £3,500 | £4,000 | £4,500 | £4,500 | £5,500 | £5,500 | £5,500 | £6,000 | |
| Consumers | £0 | £200 | £200 | £400 | £400 | £400 | £400 | £600 | £600 | £600 | £600 | £600 | |
| Janitorial Professionals | £0 | £2,000 | £1,000 | £1,800 | £2,000 | £3,000 | £3,500 | £3,500 | £3,500 | £4,000 | £4,500 | £4,000 | |
| Subtotal Direct Cost of Sales | £0 | £4,200 | £4,200 | £5,000 | £5,900 | £7,400 | £8,400 | £8,600 | £9,600 | £10,100 | £10,600 | £10,600 | |
| 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 | ||
| Charles 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,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Production Staff (3) | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Office Manager/Web Administrator | 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 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | |
| 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 | £0 | £21,000 | £21,000 | £26,000 | £31,000 | £32,500 | £35,000 | £36,000 | £38,000 | £39,000 | £41,000 | £42,000 | |
| Direct Cost of Sales | £0 | £4,200 | £4,200 | £5,000 | £5,900 | £7,400 | £8,400 | £8,600 | £9,600 | £10,100 | £10,600 | £10,600 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £4,200 | £4,200 | £5,000 | £5,900 | £7,400 | £8,400 | £8,600 | £9,600 | £10,100 | £10,600 | £10,600 | |
| Gross Margin | £0 | £16,800 | £16,800 | £21,000 | £25,100 | £25,100 | £26,600 | £27,400 | £28,400 | £28,900 | £30,400 | £31,400 | |
| Gross Margin % | 0.00% | 80.00% | 80.00% | 80.77% | 80.97% | 77.23% | 76.00% | 76.11% | 74.74% | 74.10% | 74.15% | 74.76% | |
| Expenses | |||||||||||||
| Payroll | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | |
| 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% | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 | £2,115 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | £20,155 | |
| Profit Before Interest and Taxes | (£20,155) | (£3,355) | (£3,355) | £845 | £4,945 | £4,945 | £6,445 | £7,245 | £8,245 | £8,745 | £10,245 | £11,245 | |
| EBITDA | (£19,915) | (£3,115) | (£3,115) | £1,085 | £5,185 | £5,185 | £6,685 | £7,485 | £8,485 | £8,985 | £10,485 | £11,485 | |
| Interest Expense | £824 | £814 | £804 | £794 | £834 | £824 | £812 | £801 | £789 | £777 | £765 | £753 | |
| Taxes Incurred | (£6,294) | (£1,251) | (£1,248) | £15 | £1,233 | £1,236 | £1,690 | £1,933 | £2,237 | £2,391 | £2,844 | £3,148 | |
| Net Profit | (£14,685) | (£2,918) | (£2,911) | £36 | £2,878 | £2,884 | £3,943 | £4,511 | £5,219 | £5,578 | £6,636 | £7,345 | |
| Net Profit/Sales | 0.00% | -13.90% | -13.86% | 0.14% | 9.28% | 8.88% | 11.27% | 12.53% | 13.74% | 14.30% | 16.19% | 17.49% | |
| Pro Forma Cash Flow | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £0 | £10,500 | £10,500 | £13,000 | £15,500 | £16,250 | £17,500 | £18,000 | £19,000 | £19,500 | £20,500 | £21,000 | |
| Cash from Receivables | £0 | £0 | £350 | £10,500 | £10,583 | £13,083 | £15,525 | £16,292 | £17,517 | £18,033 | £19,017 | £19,533 | |
| Subtotal Cash from Operations | £0 | £10,500 | £10,850 | £23,500 | £26,083 | £29,333 | £33,025 | £34,292 | £36,517 | £37,533 | £39,517 | £40,533 | |
| 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 | £6,000 | £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 | £0 | £10,500 | £10,850 | £23,500 | £32,083 | £29,333 | £33,025 | £34,292 | £36,517 | £37,533 | £39,517 | £40,533 | |
| 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,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | £12,300 | |
| Bill Payments | £71 | £2,440 | £11,011 | £11,469 | £14,380 | £16,644 | £18,755 | £19,602 | £19,241 | £21,344 | £21,464 | £22,365 | |
| Subtotal Spent on Operations | £12,371 | £14,740 | £23,311 | £23,769 | £26,680 | £28,944 | £31,055 | £31,902 | £31,541 | £33,644 | £33,764 | £34,665 | |
| 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 | £250 | £250 | £250 | £250 | £250 | £250 | |
| 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,551 | £15,920 | £24,491 | £24,949 | £27,860 | £30,124 | £32,485 | £33,332 | £32,971 | £35,074 | £35,194 | £36,095 | |
| Net Cash Flow | (£13,551) | (£5,420) | (£13,641) | (£1,449) | £4,223 | (£791) | £540 | £959 | £3,545 | £2,460 | £4,323 | £4,438 | |
| Cash Balance | £26,649 | £21,228 | £7,588 | £6,139 | £10,362 | £9,572 | £10,111 | £11,071 | £14,616 | £17,076 | £21,399 | £25,837 | |
| 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 | £40,200 | £26,649 | £21,228 | £7,588 | £6,139 | £10,362 | £9,572 | £10,111 | £11,071 | £14,616 | £17,076 | £21,399 | £25,837 |
| Accounts Receivable | £0 | £0 | £10,500 | £20,650 | £23,150 | £28,067 | £31,233 | £33,208 | £34,917 | £36,400 | £37,867 | £39,350 | £40,817 |
| Inventory | £5,000 | £5,000 | £4,620 | £4,620 | £5,500 | £6,490 | £8,140 | £9,240 | £9,460 | £10,560 | £11,110 | £11,660 | £11,660 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £45,200 | £31,649 | £36,348 | £32,858 | £34,789 | £44,919 | £48,945 | £52,560 | £55,447 | £61,576 | £66,053 | £72,409 | £78,314 |
| 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 | £95,200 | £81,409 | £85,868 | £82,138 | £83,829 | £93,719 | £97,505 | £100,880 | £103,527 | £109,416 | £113,653 | £119,769 | £125,434 |
| 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 | £2,073 | £10,631 | £10,992 | £13,827 | £16,020 | £18,101 | £18,963 | £18,530 | £20,629 | £20,718 | £21,628 | £21,378 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £6,000 | £6,000 | £5,750 | £5,500 | £5,250 | £5,000 | £4,750 | £4,500 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £2,073 | £10,631 | £10,992 | £13,827 | £22,020 | £24,101 | £24,713 | £24,030 | £25,879 | £25,718 | £26,378 | £25,878 |
| 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 | £100,893 | £108,271 | £107,452 | £109,107 | £116,120 | £117,021 | £116,453 | £114,590 | £115,259 | £113,918 | £113,398 | £111,718 |
| Paid-in Capital | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 | £163,000 |
| Retained Earnings | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) | (£167,800) |
| Earnings | £0 | (£14,685) | (£17,603) | (£20,514) | (£20,479) | (£17,601) | (£14,716) | (£10,774) | (£6,262) | (£1,043) | £4,535 | £11,171 | £18,516 |
| Total Capital | (£4,800) | (£19,485) | (£22,403) | (£25,314) | (£25,279) | (£22,401) | (£19,516) | (£15,574) | (£11,062) | (£5,843) | (£265) | £6,371 | £13,716 |
| Total Liabilities and Capital | £95,200 | £81,409 | £85,868 | £82,138 | £83,829 | £93,719 | £97,505 | £100,880 | £103,527 | £109,416 | £113,653 | £119,769 | £125,434 |
| Net Worth | (£4,800) | (£19,485) | (£22,403) | (£25,314) | (£25,279) | (£22,401) | (£19,516) | (£15,574) | (£11,062) | (£5,843) | (£265) | £6,371 | £13,716 |