| 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 | |||||||||||||
| CHILDassure soap (day care) | 45% | £1,250 | £1,813 | £2,628 | £3,811 | £5,526 | £8,012 | £11,618 | £16,846 | £24,426 | £35,418 | £51,356 | £74,466 |
| HEALTHassure/FOODassure | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £1,250 | £1,813 | £2,628 | £3,811 | £5,526 | £8,012 | £11,618 | £16,846 | £24,426 | £35,418 | £51,356 | £74,466 | |
| 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 | |
| CHILDassure soap (day care) | 40% | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 |
| HEALTHassure/FOODassure | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 | |
| 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 | ||
| Devon Nevius | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Kevin Meinert | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Inventory Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Sales Associate | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Research and Development | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| 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 | £1,250 | £1,813 | £2,628 | £3,811 | £5,526 | £8,012 | £11,618 | £16,846 | £24,426 | £35,418 | £51,356 | £74,466 | |
| Direct Cost of Sales | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 | |
| Gross Margin | £750 | £1,088 | £1,577 | £2,286 | £3,315 | £4,807 | £6,971 | £10,107 | £14,656 | £21,251 | £30,814 | £44,680 | |
| Gross Margin % | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| Payroll Taxes | 15% | £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 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Telecommunications | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Travel | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Warehousing | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Other General and Administrative Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Total Operating Expenses | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | |
| Profit Before Interest and Taxes | (£6,000) | (£5,663) | (£5,173) | (£4,464) | (£3,435) | (£1,943) | £221 | £3,357 | £7,906 | £14,501 | £24,064 | £37,930 | |
| EBITDA | (£6,000) | (£5,663) | (£5,173) | (£4,464) | (£3,435) | (£1,943) | £221 | £3,357 | £7,906 | £14,501 | £24,064 | £37,930 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,800) | (£1,699) | (£1,552) | (£1,339) | (£1,030) | (£583) | £66 | £1,007 | £2,372 | £4,350 | £7,219 | £11,379 | |
| Net Profit | (£4,200) | (£3,964) | (£3,621) | (£3,124) | (£2,404) | (£1,360) | £154 | £2,350 | £5,534 | £10,150 | £16,844 | £26,551 | |
| Net Profit/Sales | -336.00% | -218.69% | -137.79% | -81.99% | -43.51% | -16.97% | 1.33% | 13.95% | 22.66% | 28.66% | 32.80% | 35.65% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £667 | £1,550 | £2,248 | £3,259 | £4,725 | £6,852 | £9,935 | £14,406 | £20,889 | £30,288 | £43,918 | |
| Subtotal Cash from Operations | £0 | £667 | £1,550 | £2,248 | £3,259 | £4,725 | £6,852 | £9,935 | £14,406 | £20,889 | £30,288 | £43,918 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £667 | £1,550 | £2,248 | £3,259 | £4,725 | £6,852 | £9,935 | £14,406 | £20,889 | £30,288 | £43,918 | |
| 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 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| Bill Payments | £5 | £153 | £256 | £405 | £621 | £935 | £1,389 | £2,048 | £3,651 | £24,251 | £38,626 | £56,042 | |
| Subtotal Spent on Operations | £4,805 | £4,953 | £5,056 | £5,205 | £5,421 | £5,735 | £6,189 | £6,848 | £8,451 | £29,051 | £43,426 | £60,842 | |
| 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 | £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 | £4,805 | £4,953 | £5,056 | £5,205 | £5,421 | £5,735 | £6,189 | £6,848 | £8,451 | £29,051 | £43,426 | £60,842 | |
| Net Cash Flow | (£4,805) | (£4,287) | (£3,506) | (£2,958) | (£2,162) | (£1,009) | £663 | £3,088 | £5,955 | (£8,162) | (£13,138) | (£16,923) | |
| Cash Balance | £71,895 | £67,608 | £64,102 | £61,144 | £58,982 | £57,973 | £58,636 | £61,723 | £67,678 | £59,516 | £46,378 | £29,455 | |
| 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 | £76,700 | £71,895 | £67,608 | £64,102 | £61,144 | £58,982 | £57,973 | £58,636 | £61,723 | £67,678 | £59,516 | £46,378 | £29,455 |
| Accounts Receivable | £0 | £1,250 | £2,396 | £3,474 | £5,037 | £7,304 | £10,591 | £15,357 | £22,267 | £32,287 | £46,817 | £67,884 | £98,432 |
| Inventory | £50,000 | £49,500 | £48,775 | £47,724 | £46,199 | £43,989 | £40,784 | £36,137 | £29,399 | £39,082 | £56,669 | £82,169 | £119,146 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £126,700 | £122,645 | £118,779 | £115,300 | £112,381 | £110,275 | £109,348 | £110,130 | £113,390 | £139,047 | £163,001 | £196,432 | £247,032 |
| 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 | £126,700 | £122,645 | £118,779 | £115,300 | £112,381 | £110,275 | £109,348 | £110,130 | £113,390 | £139,047 | £163,001 | £196,432 | £247,032 |
| 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 | £145 | £243 | £385 | £591 | £889 | £1,322 | £1,949 | £2,859 | £22,982 | £36,786 | £53,372 | £77,422 |
| 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 | £145 | £243 | £385 | £591 | £889 | £1,322 | £1,949 | £2,859 | £22,982 | £36,786 | £53,372 | £77,422 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £145 | £243 | £385 | £591 | £889 | £1,322 | £1,949 | £2,859 | £22,982 | £36,786 | £53,372 | £77,422 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) |
| Earnings | £0 | (£4,200) | (£8,164) | (£11,785) | (£14,909) | (£17,314) | (£18,674) | (£18,519) | (£16,169) | (£10,635) | (£485) | £16,360 | £42,911 |
| Total Capital | £126,700 | £122,500 | £118,536 | £114,915 | £111,791 | £109,386 | £108,026 | £108,181 | £110,531 | £116,065 | £126,215 | £143,060 | £169,611 |
| Total Liabilities and Capital | £126,700 | £122,645 | £118,779 | £115,300 | £112,381 | £110,275 | £109,348 | £110,130 | £113,390 | £139,047 | £163,001 | £196,432 | £247,032 |
| Net Worth | £126,700 | £122,500 | £118,536 | £114,915 | £111,791 | £109,386 | £108,026 | £108,181 | £110,531 | £116,065 | £126,215 | £143,060 | £169,611 |
| 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 | |||||||||||||
| CHILDassure soap (day care) | 45% | £1,250 | £1,813 | £2,628 | £3,811 | £5,526 | £8,012 | £11,618 | £16,846 | £24,426 | £35,418 | £51,356 | £74,466 |
| HEALTHassure/FOODassure | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £1,250 | £1,813 | £2,628 | £3,811 | £5,526 | £8,012 | £11,618 | £16,846 | £24,426 | £35,418 | £51,356 | £74,466 | |
| 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 | |
| CHILDassure soap (day care) | 40% | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 |
| HEALTHassure/FOODassure | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 | |
| 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 | ||
| Devon Nevius | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Kevin Meinert | 0% | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 | £2,400 |
| Inventory Manager | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Sales Associate | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Research and Development | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| 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 | £1,250 | £1,813 | £2,628 | £3,811 | £5,526 | £8,012 | £11,618 | £16,846 | £24,426 | £35,418 | £51,356 | £74,466 | |
| Direct Cost of Sales | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £500 | £725 | £1,051 | £1,524 | £2,210 | £3,205 | £4,647 | £6,738 | £9,770 | £14,167 | £20,542 | £29,786 | |
| Gross Margin | £750 | £1,088 | £1,577 | £2,286 | £3,315 | £4,807 | £6,971 | £10,107 | £14,656 | £21,251 | £30,814 | £44,680 | |
| Gross Margin % | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |
| Expenses | |||||||||||||
| Payroll | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| Payroll Taxes | 15% | £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 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | £700 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Insurance | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Telecommunications | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Travel | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Warehousing | 15% | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 |
| Other General and Administrative Expenses | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Total Operating Expenses | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | £6,750 | |
| Profit Before Interest and Taxes | (£6,000) | (£5,663) | (£5,173) | (£4,464) | (£3,435) | (£1,943) | £221 | £3,357 | £7,906 | £14,501 | £24,064 | £37,930 | |
| EBITDA | (£6,000) | (£5,663) | (£5,173) | (£4,464) | (£3,435) | (£1,943) | £221 | £3,357 | £7,906 | £14,501 | £24,064 | £37,930 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,800) | (£1,699) | (£1,552) | (£1,339) | (£1,030) | (£583) | £66 | £1,007 | £2,372 | £4,350 | £7,219 | £11,379 | |
| Net Profit | (£4,200) | (£3,964) | (£3,621) | (£3,124) | (£2,404) | (£1,360) | £154 | £2,350 | £5,534 | £10,150 | £16,844 | £26,551 | |
| Net Profit/Sales | -336.00% | -218.69% | -137.79% | -81.99% | -43.51% | -16.97% | 1.33% | 13.95% | 22.66% | 28.66% | 32.80% | 35.65% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £667 | £1,550 | £2,248 | £3,259 | £4,725 | £6,852 | £9,935 | £14,406 | £20,889 | £30,288 | £43,918 | |
| Subtotal Cash from Operations | £0 | £667 | £1,550 | £2,248 | £3,259 | £4,725 | £6,852 | £9,935 | £14,406 | £20,889 | £30,288 | £43,918 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £667 | £1,550 | £2,248 | £3,259 | £4,725 | £6,852 | £9,935 | £14,406 | £20,889 | £30,288 | £43,918 | |
| 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 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | £4,800 | |
| Bill Payments | £5 | £153 | £256 | £405 | £621 | £935 | £1,389 | £2,048 | £3,651 | £24,251 | £38,626 | £56,042 | |
| Subtotal Spent on Operations | £4,805 | £4,953 | £5,056 | £5,205 | £5,421 | £5,735 | £6,189 | £6,848 | £8,451 | £29,051 | £43,426 | £60,842 | |
| 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 | £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 | £4,805 | £4,953 | £5,056 | £5,205 | £5,421 | £5,735 | £6,189 | £6,848 | £8,451 | £29,051 | £43,426 | £60,842 | |
| Net Cash Flow | (£4,805) | (£4,287) | (£3,506) | (£2,958) | (£2,162) | (£1,009) | £663 | £3,088 | £5,955 | (£8,162) | (£13,138) | (£16,923) | |
| Cash Balance | £71,895 | £67,608 | £64,102 | £61,144 | £58,982 | £57,973 | £58,636 | £61,723 | £67,678 | £59,516 | £46,378 | £29,455 | |
| 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 | £76,700 | £71,895 | £67,608 | £64,102 | £61,144 | £58,982 | £57,973 | £58,636 | £61,723 | £67,678 | £59,516 | £46,378 | £29,455 |
| Accounts Receivable | £0 | £1,250 | £2,396 | £3,474 | £5,037 | £7,304 | £10,591 | £15,357 | £22,267 | £32,287 | £46,817 | £67,884 | £98,432 |
| Inventory | £50,000 | £49,500 | £48,775 | £47,724 | £46,199 | £43,989 | £40,784 | £36,137 | £29,399 | £39,082 | £56,669 | £82,169 | £119,146 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £126,700 | £122,645 | £118,779 | £115,300 | £112,381 | £110,275 | £109,348 | £110,130 | £113,390 | £139,047 | £163,001 | £196,432 | £247,032 |
| 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 | £126,700 | £122,645 | £118,779 | £115,300 | £112,381 | £110,275 | £109,348 | £110,130 | £113,390 | £139,047 | £163,001 | £196,432 | £247,032 |
| 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 | £145 | £243 | £385 | £591 | £889 | £1,322 | £1,949 | £2,859 | £22,982 | £36,786 | £53,372 | £77,422 |
| 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 | £145 | £243 | £385 | £591 | £889 | £1,322 | £1,949 | £2,859 | £22,982 | £36,786 | £53,372 | £77,422 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £145 | £243 | £385 | £591 | £889 | £1,322 | £1,949 | £2,859 | £22,982 | £36,786 | £53,372 | £77,422 |
| Paid-in Capital | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 | £250,000 |
| Retained Earnings | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) | (£123,300) |
| Earnings | £0 | (£4,200) | (£8,164) | (£11,785) | (£14,909) | (£17,314) | (£18,674) | (£18,519) | (£16,169) | (£10,635) | (£485) | £16,360 | £42,911 |
| Total Capital | £126,700 | £122,500 | £118,536 | £114,915 | £111,791 | £109,386 | £108,026 | £108,181 | £110,531 | £116,065 | £126,215 | £143,060 | £169,611 |
| Total Liabilities and Capital | £126,700 | £122,645 | £118,779 | £115,300 | £112,381 | £110,275 | £109,348 | £110,130 | £113,390 | £139,047 | £163,001 | £196,432 | £247,032 |
| Net Worth | £126,700 | £122,500 | £118,536 | £114,915 | £111,791 | £109,386 | £108,026 | £108,181 | £110,531 | £116,065 | £126,215 | £143,060 | £169,611 |