| 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 | |||||||||||||
| Chemical manufacturing | 0% | £4,800 | £5,040 | £5,292 | £5,557 | £5,834 | £6,126 | £6,432 | £6,754 | £7,092 | £7,446 | £7,819 | £8,210 |
| Biorefinery start-ups | 0% | £2,400 | £2,640 | £2,904 | £3,194 | £3,514 | £3,865 | £4,252 | £4,677 | £5,145 | £5,659 | £6,225 | £6,847 |
| Agricultural | 0% | £1,200 | £1,260 | £1,323 | £1,389 | £1,459 | £1,532 | £1,608 | £1,689 | £1,773 | £1,862 | £1,955 | £2,052 |
| Utilities | 0% | £2,400 | £2,520 | £2,646 | £2,778 | £2,917 | £3,063 | £3,216 | £3,377 | £3,546 | £3,723 | £3,909 | £4,105 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £10,800 | £11,460 | £12,165 | £12,918 | £13,724 | £14,586 | £15,509 | £16,497 | £17,555 | £18,690 | £19,908 | £21,214 | |
| 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 | |
| Supplies | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Sales & Marketing | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Interest & Depreciation | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Overhead | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| 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 | ||
| Ryan O'Connor | 0% | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £10,800 | £11,460 | £12,165 | £12,918 | £13,724 | £14,586 | £15,509 | £16,497 | £17,555 | £18,690 | £19,908 | £21,214 | |
| Direct Cost of Sales | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Gross Margin | £4,800 | £5,460 | £6,165 | £6,918 | £7,724 | £8,586 | £9,509 | £10,497 | £11,555 | £12,690 | £13,908 | £15,214 | |
| Gross Margin % | 44.44% | 47.64% | 50.68% | 53.55% | 56.28% | 58.86% | 61.31% | 63.63% | 65.82% | 67.90% | 69.86% | 71.72% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | |
| Profit Before Interest and Taxes | (£4,400) | (£3,740) | (£3,035) | (£2,282) | (£1,476) | (£614) | £309 | £1,297 | £2,355 | £3,490 | £4,708 | £6,014 | |
| EBITDA | (£4,400) | (£3,740) | (£3,035) | (£2,282) | (£1,476) | (£614) | £309 | £1,297 | £2,355 | £3,490 | £4,708 | £6,014 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,320) | (£935) | (£759) | (£570) | (£369) | (£154) | £77 | £324 | £589 | £873 | £1,177 | £1,504 | |
| Other Income | |||||||||||||
| Interest Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Income Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expense | |||||||||||||
| Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Other Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,080) | (£2,805) | (£2,276) | (£1,711) | (£1,107) | (£461) | £231 | £972 | £1,766 | £2,618 | £3,531 | £4,511 | |
| Net Profit/Sales | -28.52% | -24.48% | -18.71% | -13.25% | -8.07% | -3.16% | 1.49% | 5.89% | 10.06% | 14.01% | 17.74% | 21.26% | |
| 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 | £2,700 | £2,865 | £3,041 | £3,230 | £3,431 | £3,646 | £3,877 | £4,124 | £4,389 | £4,673 | £4,977 | £5,304 | |
| Cash from Receivables | £0 | £270 | £8,117 | £8,613 | £9,143 | £9,709 | £10,315 | £10,963 | £11,656 | £12,399 | £13,195 | £14,048 | |
| Subtotal Cash from Operations | £2,700 | £3,135 | £11,158 | £11,842 | £12,574 | £13,355 | £14,192 | £15,087 | £16,045 | £17,071 | £18,172 | £19,352 | |
| Additional Cash Received | |||||||||||||
| Non Operating (Other) Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £2,700 | £3,135 | £11,158 | £11,842 | £12,574 | £13,355 | £14,192 | £15,087 | £16,045 | £17,071 | £18,172 | £19,352 | |
| 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | £196 | £5,893 | £6,271 | £6,448 | £6,636 | £6,838 | £7,054 | £7,285 | £7,533 | £7,798 | £8,083 | £8,388 | |
| Subtotal Spent on Operations | £8,196 | £13,893 | £14,271 | £14,448 | £14,636 | £14,838 | £15,054 | £15,285 | £15,533 | £15,798 | £16,083 | £16,388 | |
| Additional Cash Spent | |||||||||||||
| Non Operating (Other) Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £8,196 | £13,893 | £14,271 | £14,448 | £14,636 | £14,838 | £15,054 | £15,285 | £15,533 | £15,798 | £16,083 | £16,388 | |
| Net Cash Flow | (£5,496) | (£10,758) | (£3,113) | (£2,605) | (£2,063) | (£1,483) | (£862) | (£199) | £512 | £1,273 | £2,089 | £2,964 | |
| Cash Balance | £34,504 | £23,746 | £20,633 | £18,028 | £15,965 | £14,482 | £13,620 | £13,421 | £13,933 | £15,206 | £17,295 | £20,259 | |
| 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,000 | £34,504 | £23,746 | £20,633 | £18,028 | £15,965 | £14,482 | £13,620 | £13,421 | £13,933 | £15,206 | £17,295 | £20,259 |
| Accounts Receivable | £0 | £8,100 | £16,425 | £17,432 | £18,508 | £19,659 | £20,889 | £22,206 | £23,616 | £25,126 | £26,745 | £28,481 | £30,344 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £40,000 | £42,604 | £40,171 | £38,065 | £36,536 | £35,624 | £35,372 | £35,826 | £37,037 | £39,060 | £41,952 | £45,777 | £50,603 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £40,000 | £42,604 | £40,171 | £38,065 | £36,536 | £35,624 | £35,372 | £35,826 | £37,037 | £39,060 | £41,952 | £45,777 | £50,603 |
| 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 | £5,684 | £6,056 | £6,227 | £6,409 | £6,603 | £6,812 | £7,035 | £7,273 | £7,529 | £7,803 | £8,098 | £8,413 |
| 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 | £5,684 | £6,056 | £6,227 | £6,409 | £6,603 | £6,812 | £7,035 | £7,273 | £7,529 | £7,803 | £8,098 | £8,413 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £5,684 | £6,056 | £6,227 | £6,409 | £6,603 | £6,812 | £7,035 | £7,273 | £7,529 | £7,803 | £8,098 | £8,413 |
| Paid-in Capital | £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 |
| Retained Earnings | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) |
| Earnings | £0 | (£3,080) | (£5,885) | (£8,161) | (£9,872) | (£10,979) | (£11,440) | (£11,208) | (£10,236) | (£8,470) | (£5,852) | (£2,321) | £2,190 |
| Total Capital | £40,000 | £36,920 | £34,115 | £31,839 | £30,128 | £29,021 | £28,560 | £28,792 | £29,764 | £31,530 | £34,148 | £37,679 | £42,190 |
| Total Liabilities and Capital | £40,000 | £42,604 | £40,171 | £38,065 | £36,536 | £35,624 | £35,372 | £35,826 | £37,037 | £39,060 | £41,952 | £45,777 | £50,603 |
| Net Worth | £40,000 | £36,920 | £34,115 | £31,839 | £30,128 | £29,021 | £28,560 | £28,792 | £29,764 | £31,530 | £34,148 | £37,679 | £42,190 |
| 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 | |||||||||||||
| Chemical manufacturing | 0% | £4,800 | £5,040 | £5,292 | £5,557 | £5,834 | £6,126 | £6,432 | £6,754 | £7,092 | £7,446 | £7,819 | £8,210 |
| Biorefinery start-ups | 0% | £2,400 | £2,640 | £2,904 | £3,194 | £3,514 | £3,865 | £4,252 | £4,677 | £5,145 | £5,659 | £6,225 | £6,847 |
| Agricultural | 0% | £1,200 | £1,260 | £1,323 | £1,389 | £1,459 | £1,532 | £1,608 | £1,689 | £1,773 | £1,862 | £1,955 | £2,052 |
| Utilities | 0% | £2,400 | £2,520 | £2,646 | £2,778 | £2,917 | £3,063 | £3,216 | £3,377 | £3,546 | £3,723 | £3,909 | £4,105 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £10,800 | £11,460 | £12,165 | £12,918 | £13,724 | £14,586 | £15,509 | £16,497 | £17,555 | £18,690 | £19,908 | £21,214 | |
| 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 | |
| Supplies | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Sales & Marketing | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Interest & Depreciation | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Overhead | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| 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 | ||
| Ryan O'Connor | 0% | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Long-term Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £10,800 | £11,460 | £12,165 | £12,918 | £13,724 | £14,586 | £15,509 | £16,497 | £17,555 | £18,690 | £19,908 | £21,214 | |
| Direct Cost of Sales | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Gross Margin | £4,800 | £5,460 | £6,165 | £6,918 | £7,724 | £8,586 | £9,509 | £10,497 | £11,555 | £12,690 | £13,908 | £15,214 | |
| Gross Margin % | 44.44% | 47.64% | 50.68% | 53.55% | 56.28% | 58.86% | 61.31% | 63.63% | 65.82% | 67.90% | 69.86% | 71.72% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | £9,200 | |
| Profit Before Interest and Taxes | (£4,400) | (£3,740) | (£3,035) | (£2,282) | (£1,476) | (£614) | £309 | £1,297 | £2,355 | £3,490 | £4,708 | £6,014 | |
| EBITDA | (£4,400) | (£3,740) | (£3,035) | (£2,282) | (£1,476) | (£614) | £309 | £1,297 | £2,355 | £3,490 | £4,708 | £6,014 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,320) | (£935) | (£759) | (£570) | (£369) | (£154) | £77 | £324 | £589 | £873 | £1,177 | £1,504 | |
| Other Income | |||||||||||||
| Interest Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Income Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expense | |||||||||||||
| Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Expense Account Name | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Other Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£3,080) | (£2,805) | (£2,276) | (£1,711) | (£1,107) | (£461) | £231 | £972 | £1,766 | £2,618 | £3,531 | £4,511 | |
| Net Profit/Sales | -28.52% | -24.48% | -18.71% | -13.25% | -8.07% | -3.16% | 1.49% | 5.89% | 10.06% | 14.01% | 17.74% | 21.26% | |
| 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 | £2,700 | £2,865 | £3,041 | £3,230 | £3,431 | £3,646 | £3,877 | £4,124 | £4,389 | £4,673 | £4,977 | £5,304 | |
| Cash from Receivables | £0 | £270 | £8,117 | £8,613 | £9,143 | £9,709 | £10,315 | £10,963 | £11,656 | £12,399 | £13,195 | £14,048 | |
| Subtotal Cash from Operations | £2,700 | £3,135 | £11,158 | £11,842 | £12,574 | £13,355 | £14,192 | £15,087 | £16,045 | £17,071 | £18,172 | £19,352 | |
| Additional Cash Received | |||||||||||||
| Non Operating (Other) Income | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £2,700 | £3,135 | £11,158 | £11,842 | £12,574 | £13,355 | £14,192 | £15,087 | £16,045 | £17,071 | £18,172 | £19,352 | |
| 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | £196 | £5,893 | £6,271 | £6,448 | £6,636 | £6,838 | £7,054 | £7,285 | £7,533 | £7,798 | £8,083 | £8,388 | |
| Subtotal Spent on Operations | £8,196 | £13,893 | £14,271 | £14,448 | £14,636 | £14,838 | £15,054 | £15,285 | £15,533 | £15,798 | £16,083 | £16,388 | |
| Additional Cash Spent | |||||||||||||
| Non Operating (Other) Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £8,196 | £13,893 | £14,271 | £14,448 | £14,636 | £14,838 | £15,054 | £15,285 | £15,533 | £15,798 | £16,083 | £16,388 | |
| Net Cash Flow | (£5,496) | (£10,758) | (£3,113) | (£2,605) | (£2,063) | (£1,483) | (£862) | (£199) | £512 | £1,273 | £2,089 | £2,964 | |
| Cash Balance | £34,504 | £23,746 | £20,633 | £18,028 | £15,965 | £14,482 | £13,620 | £13,421 | £13,933 | £15,206 | £17,295 | £20,259 | |
| 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,000 | £34,504 | £23,746 | £20,633 | £18,028 | £15,965 | £14,482 | £13,620 | £13,421 | £13,933 | £15,206 | £17,295 | £20,259 |
| Accounts Receivable | £0 | £8,100 | £16,425 | £17,432 | £18,508 | £19,659 | £20,889 | £22,206 | £23,616 | £25,126 | £26,745 | £28,481 | £30,344 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £40,000 | £42,604 | £40,171 | £38,065 | £36,536 | £35,624 | £35,372 | £35,826 | £37,037 | £39,060 | £41,952 | £45,777 | £50,603 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £40,000 | £42,604 | £40,171 | £38,065 | £36,536 | £35,624 | £35,372 | £35,826 | £37,037 | £39,060 | £41,952 | £45,777 | £50,603 |
| 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 | £5,684 | £6,056 | £6,227 | £6,409 | £6,603 | £6,812 | £7,035 | £7,273 | £7,529 | £7,803 | £8,098 | £8,413 |
| 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 | £5,684 | £6,056 | £6,227 | £6,409 | £6,603 | £6,812 | £7,035 | £7,273 | £7,529 | £7,803 | £8,098 | £8,413 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £5,684 | £6,056 | £6,227 | £6,409 | £6,603 | £6,812 | £7,035 | £7,273 | £7,529 | £7,803 | £8,098 | £8,413 |
| Paid-in Capital | £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 |
| Retained Earnings | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) | (£10,000) |
| Earnings | £0 | (£3,080) | (£5,885) | (£8,161) | (£9,872) | (£10,979) | (£11,440) | (£11,208) | (£10,236) | (£8,470) | (£5,852) | (£2,321) | £2,190 |
| Total Capital | £40,000 | £36,920 | £34,115 | £31,839 | £30,128 | £29,021 | £28,560 | £28,792 | £29,764 | £31,530 | £34,148 | £37,679 | £42,190 |
| Total Liabilities and Capital | £40,000 | £42,604 | £40,171 | £38,065 | £36,536 | £35,624 | £35,372 | £35,826 | £37,037 | £39,060 | £41,952 | £45,777 | £50,603 |
| Net Worth | £40,000 | £36,920 | £34,115 | £31,839 | £30,128 | £29,021 | £28,560 | £28,792 | £29,764 | £31,530 | £34,148 | £37,679 | £42,190 |