| 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 | |||||||||||||
| <£1 million worth customers | 0% | £0 | £0 | £0 | £2,500 | £3,545 | £4,545 | £5,878 | £6,335 | £7,474 | £7,558 | £8,255 | £8,656 |
| >£1 million worth customers | 0% | £0 | £0 | £0 | £0 | £0 | £2,136 | £2,763 | £2,977 | £3,513 | £3,552 | £3,880 | £4,068 |
| Total Sales | £0 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| 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 | |
| <£1 million worth customers | £0 | £0 | £0 | £375 | £532 | £682 | £882 | £950 | £1,121 | £1,134 | £1,238 | £1,298 | |
| >£1 million worth customers | £0 | £0 | £0 | £0 | £0 | £320 | £414 | £447 | £527 | £533 | £582 | £610 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £375 | £532 | £1,002 | £1,296 | £1,397 | £1,648 | £1,667 | £1,820 | £1,909 | |
| 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 | ||
| Sarah | 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 |
| Steve | 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 |
| Account Manager | 0% | £0 | £0 | £1,500 | £2,000 | £2,500 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Administrative Assistant | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Bookkeeper | 0% | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Research Assistant | 0% | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total People | 2 | 3 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £5,000 | £5,750 | £9,750 | £10,250 | £10,750 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | |
| 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 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| Direct Cost of Sales | £0 | £0 | £0 | £375 | £532 | £1,002 | £1,296 | £1,397 | £1,648 | £1,667 | £1,820 | £1,909 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £375 | £532 | £1,002 | £1,296 | £1,397 | £1,648 | £1,667 | £1,820 | £1,909 | |
| Gross Margin | £0 | £0 | £0 | £2,125 | £3,013 | £5,679 | £7,345 | £7,916 | £9,339 | £9,444 | £10,315 | £10,816 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,750 | £9,750 | £10,250 | £10,750 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | |
| Rent | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 15% | £750 | £863 | £1,463 | £1,538 | £1,613 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 |
| Other | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Total Operating Expenses | £7,167 | £8,030 | £12,630 | £13,205 | £13,780 | £14,355 | £14,355 | £14,355 | £14,355 | £14,355 | £14,355 | £14,355 | |
| Profit Before Interest and Taxes | (£7,167) | (£8,030) | (£12,630) | (£11,080) | (£10,766) | (£8,676) | (£7,010) | (£6,439) | (£5,016) | (£4,911) | (£4,040) | (£3,539) | |
| EBITDA | (£6,850) | (£7,713) | (£12,313) | (£10,763) | (£10,449) | (£8,359) | (£6,693) | (£6,122) | (£4,699) | (£4,594) | (£3,723) | (£3,222) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £25 | £25 | £23 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,167) | (£8,030) | (£12,630) | (£11,080) | (£10,766) | (£8,676) | (£7,010) | (£6,439) | (£5,016) | (£4,936) | (£4,065) | (£3,561) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -443.18% | -303.70% | -129.85% | -81.13% | -69.14% | -45.65% | -44.43% | -33.50% | -27.99% | |
| 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 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| 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 | £3,000 | £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 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £14,110 | £12,135 | £12,724 | |
| 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 | £5,000 | £5,750 | £9,750 | £10,250 | £10,750 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | |
| Bill Payments | £62 | £1,854 | £1,983 | £2,578 | £3,020 | £3,262 | £3,799 | £4,087 | £4,193 | £4,437 | £4,484 | £4,636 | |
| Subtotal Spent on Operations | £5,062 | £7,604 | £11,733 | £12,828 | £13,770 | £14,512 | £15,049 | £15,337 | £15,443 | £15,687 | £15,734 | £15,886 | |
| 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 | £300 | |
| 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 | £5,062 | £7,604 | £11,733 | £12,828 | £13,770 | £14,512 | £15,049 | £15,337 | £15,443 | £15,687 | £15,734 | £16,186 | |
| Net Cash Flow | (£5,062) | (£7,604) | (£11,733) | (£10,328) | (£10,225) | (£7,831) | (£6,409) | (£6,025) | (£4,456) | (£1,577) | (£3,599) | (£3,461) | |
| Cash Balance | £73,938 | £66,335 | £54,602 | £44,275 | £34,049 | £26,218 | £19,809 | £13,785 | £9,329 | £7,752 | £4,153 | £692 | |
| 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 | £79,000 | £73,938 | £66,335 | £54,602 | £44,275 | £34,049 | £26,218 | £19,809 | £13,785 | £9,329 | £7,752 | £4,153 | £692 |
| Other Current Assets | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 |
| Total Current Assets | £86,000 | £80,938 | £73,335 | £61,602 | £51,275 | £41,049 | £33,218 | £26,809 | £20,785 | £16,329 | £14,752 | £11,153 | £7,692 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 |
| Accumulated Depreciation | £0 | £317 | £634 | £951 | £1,268 | £1,585 | £1,902 | £2,219 | £2,536 | £2,853 | £3,170 | £3,487 | £3,804 |
| Total Long-term Assets | £19,000 | £18,683 | £18,366 | £18,049 | £17,732 | £17,415 | £17,098 | £16,781 | £16,464 | £16,147 | £15,830 | £15,513 | £15,196 |
| Total Assets | £105,000 | £99,621 | £91,701 | £79,651 | £69,007 | £58,464 | £50,316 | £43,590 | £37,249 | £32,476 | £30,582 | £26,666 | £22,888 |
| 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 | £1,788 | £1,897 | £2,477 | £2,912 | £3,136 | £3,663 | £3,947 | £4,045 | £4,288 | £4,330 | £4,478 | £4,561 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £2,700 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £1,788 | £1,897 | £2,477 | £2,912 | £3,136 | £3,663 | £3,947 | £4,045 | £4,288 | £7,330 | £7,478 | £7,261 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,788 | £1,897 | £2,477 | £2,912 | £3,136 | £3,663 | £3,947 | £4,045 | £4,288 | £7,330 | £7,478 | £7,261 |
| Paid-in Capital | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 |
| Retained Earnings | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) |
| Earnings | £0 | (£7,167) | (£15,197) | (£27,826) | (£38,906) | (£49,672) | (£58,347) | (£65,357) | (£71,796) | (£76,812) | (£81,748) | (£85,813) | (£89,374) |
| Total Capital | £105,000 | £97,833 | £89,804 | £77,174 | £66,095 | £55,328 | £46,653 | £39,643 | £33,204 | £28,188 | £23,252 | £19,187 | £15,626 |
| Total Liabilities and Capital | £105,000 | £99,621 | £91,701 | £79,651 | £69,007 | £58,464 | £50,316 | £43,590 | £37,249 | £32,476 | £30,582 | £26,666 | £22,888 |
| Net Worth | £105,000 | £97,833 | £89,804 | £77,174 | £66,095 | £55,328 | £46,653 | £39,643 | £33,204 | £28,188 | £23,252 | £19,187 | £15,626 |
| 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 | |||||||||||||
| <£1 million worth customers | 0% | £0 | £0 | £0 | £2,500 | £3,545 | £4,545 | £5,878 | £6,335 | £7,474 | £7,558 | £8,255 | £8,656 |
| >£1 million worth customers | 0% | £0 | £0 | £0 | £0 | £0 | £2,136 | £2,763 | £2,977 | £3,513 | £3,552 | £3,880 | £4,068 |
| Total Sales | £0 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| 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 | |
| <£1 million worth customers | £0 | £0 | £0 | £375 | £532 | £682 | £882 | £950 | £1,121 | £1,134 | £1,238 | £1,298 | |
| >£1 million worth customers | £0 | £0 | £0 | £0 | £0 | £320 | £414 | £447 | £527 | £533 | £582 | £610 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £375 | £532 | £1,002 | £1,296 | £1,397 | £1,648 | £1,667 | £1,820 | £1,909 | |
| 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 | ||
| Sarah | 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 |
| Steve | 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 |
| Account Manager | 0% | £0 | £0 | £1,500 | £2,000 | £2,500 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Administrative Assistant | 0% | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 |
| Bookkeeper | 0% | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 |
| Research Assistant | 0% | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 |
| Total People | 2 | 3 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £5,000 | £5,750 | £9,750 | £10,250 | £10,750 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | |
| 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 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| Direct Cost of Sales | £0 | £0 | £0 | £375 | £532 | £1,002 | £1,296 | £1,397 | £1,648 | £1,667 | £1,820 | £1,909 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £375 | £532 | £1,002 | £1,296 | £1,397 | £1,648 | £1,667 | £1,820 | £1,909 | |
| Gross Margin | £0 | £0 | £0 | £2,125 | £3,013 | £5,679 | £7,345 | £7,916 | £9,339 | £9,444 | £10,315 | £10,816 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | 85.00% | |
| Expenses | |||||||||||||
| Payroll | £5,000 | £5,750 | £9,750 | £10,250 | £10,750 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | £317 | |
| Rent | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | £650 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Payroll Taxes | 15% | £750 | £863 | £1,463 | £1,538 | £1,613 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 | £1,688 |
| Other | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Total Operating Expenses | £7,167 | £8,030 | £12,630 | £13,205 | £13,780 | £14,355 | £14,355 | £14,355 | £14,355 | £14,355 | £14,355 | £14,355 | |
| Profit Before Interest and Taxes | (£7,167) | (£8,030) | (£12,630) | (£11,080) | (£10,766) | (£8,676) | (£7,010) | (£6,439) | (£5,016) | (£4,911) | (£4,040) | (£3,539) | |
| EBITDA | (£6,850) | (£7,713) | (£12,313) | (£10,763) | (£10,449) | (£8,359) | (£6,693) | (£6,122) | (£4,699) | (£4,594) | (£3,723) | (£3,222) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £25 | £25 | £23 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£7,167) | (£8,030) | (£12,630) | (£11,080) | (£10,766) | (£8,676) | (£7,010) | (£6,439) | (£5,016) | (£4,936) | (£4,065) | (£3,561) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -443.18% | -303.70% | -129.85% | -81.13% | -69.14% | -45.65% | -44.43% | -33.50% | -27.99% | |
| 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 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £11,110 | £12,135 | £12,724 | |
| 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 | £3,000 | £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 | £0 | £0 | £2,500 | £3,545 | £6,681 | £8,641 | £9,312 | £10,987 | £14,110 | £12,135 | £12,724 | |
| 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 | £5,000 | £5,750 | £9,750 | £10,250 | £10,750 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | £11,250 | |
| Bill Payments | £62 | £1,854 | £1,983 | £2,578 | £3,020 | £3,262 | £3,799 | £4,087 | £4,193 | £4,437 | £4,484 | £4,636 | |
| Subtotal Spent on Operations | £5,062 | £7,604 | £11,733 | £12,828 | £13,770 | £14,512 | £15,049 | £15,337 | £15,443 | £15,687 | £15,734 | £15,886 | |
| 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 | £300 | |
| 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 | £5,062 | £7,604 | £11,733 | £12,828 | £13,770 | £14,512 | £15,049 | £15,337 | £15,443 | £15,687 | £15,734 | £16,186 | |
| Net Cash Flow | (£5,062) | (£7,604) | (£11,733) | (£10,328) | (£10,225) | (£7,831) | (£6,409) | (£6,025) | (£4,456) | (£1,577) | (£3,599) | (£3,461) | |
| Cash Balance | £73,938 | £66,335 | £54,602 | £44,275 | £34,049 | £26,218 | £19,809 | £13,785 | £9,329 | £7,752 | £4,153 | £692 | |
| 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 | £79,000 | £73,938 | £66,335 | £54,602 | £44,275 | £34,049 | £26,218 | £19,809 | £13,785 | £9,329 | £7,752 | £4,153 | £692 |
| Other Current Assets | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 | £7,000 |
| Total Current Assets | £86,000 | £80,938 | £73,335 | £61,602 | £51,275 | £41,049 | £33,218 | £26,809 | £20,785 | £16,329 | £14,752 | £11,153 | £7,692 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 | £19,000 |
| Accumulated Depreciation | £0 | £317 | £634 | £951 | £1,268 | £1,585 | £1,902 | £2,219 | £2,536 | £2,853 | £3,170 | £3,487 | £3,804 |
| Total Long-term Assets | £19,000 | £18,683 | £18,366 | £18,049 | £17,732 | £17,415 | £17,098 | £16,781 | £16,464 | £16,147 | £15,830 | £15,513 | £15,196 |
| Total Assets | £105,000 | £99,621 | £91,701 | £79,651 | £69,007 | £58,464 | £50,316 | £43,590 | £37,249 | £32,476 | £30,582 | £26,666 | £22,888 |
| 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 | £1,788 | £1,897 | £2,477 | £2,912 | £3,136 | £3,663 | £3,947 | £4,045 | £4,288 | £4,330 | £4,478 | £4,561 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £3,000 | £3,000 | £2,700 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £1,788 | £1,897 | £2,477 | £2,912 | £3,136 | £3,663 | £3,947 | £4,045 | £4,288 | £7,330 | £7,478 | £7,261 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £1,788 | £1,897 | £2,477 | £2,912 | £3,136 | £3,663 | £3,947 | £4,045 | £4,288 | £7,330 | £7,478 | £7,261 |
| Paid-in Capital | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 |
| Retained Earnings | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) | (£20,000) |
| Earnings | £0 | (£7,167) | (£15,197) | (£27,826) | (£38,906) | (£49,672) | (£58,347) | (£65,357) | (£71,796) | (£76,812) | (£81,748) | (£85,813) | (£89,374) |
| Total Capital | £105,000 | £97,833 | £89,804 | £77,174 | £66,095 | £55,328 | £46,653 | £39,643 | £33,204 | £28,188 | £23,252 | £19,187 | £15,626 |
| Total Liabilities and Capital | £105,000 | £99,621 | £91,701 | £79,651 | £69,007 | £58,464 | £50,316 | £43,590 | £37,249 | £32,476 | £30,582 | £26,666 | £22,888 |
| Net Worth | £105,000 | £97,833 | £89,804 | £77,174 | £66,095 | £55,328 | £46,653 | £39,643 | £33,204 | £28,188 | £23,252 | £19,187 | £15,626 |