| 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 | |||||||||||||
| Sales | 0% | £81,000 | £81,000 | £81,000 | £175,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £81,000 | £81,000 | £81,000 | £175,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,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 | |
| Sales | £32,000 | £32,000 | £32,000 | £58,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £32,000 | £32,000 | £32,000 | £58,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,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 | ||
| President | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Head of American Division | 0% | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 |
| Vice President American Division | 0% | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Other | 0% | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.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 | £81,000 | £81,000 | £81,000 | £175,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | |
| Direct Cost of Sales | £32,000 | £32,000 | £32,000 | £58,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | |
| Other | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | |
| Total Cost of Sales | £34,750 | £34,750 | £34,750 | £60,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | |
| Gross Margin | £46,250 | £46,250 | £46,250 | £114,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | |
| Gross Margin % | 57.10% | 57.10% | 57.10% | 65.29% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | |
| Expenses | |||||||||||||
| Payroll | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | |
| Sales and Marketing and Other Expenses | £8,350 | £8,350 | £8,350 | £8,900 | £8,275 | £8,350 | £8,350 | £8,350 | £8,350 | £8,350 | £8,350 | £8,350 | |
| Depreciation | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | |
| Leased Equipment | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Utilities | £500 | £500 | £550 | £600 | £575 | £550 | £500 | £500 | £500 | £500 | £550 | £500 | |
| Insurance | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Rent | £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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 12% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £45,842 | £45,842 | £45,892 | £46,492 | £45,842 | £45,892 | £45,842 | £45,842 | £45,842 | £45,842 | £45,892 | £45,842 | |
| Profit Before Interest and Taxes | £408 | £408 | £358 | £67,758 | £408 | £358 | £408 | £408 | £408 | £408 | £358 | £408 | |
| EBITDA | £700 | £700 | £650 | £68,050 | £700 | £650 | £700 | £700 | £700 | £700 | £650 | £700 | |
| Interest Expense | £397 | £395 | £392 | £732 | £729 | £727 | £557 | £555 | £552 | £383 | £381 | £378 | |
| Taxes Incurred | £3 | £3 | (£9) | £16,757 | (£80) | (£92) | (£37) | (£37) | (£36) | £6 | (£6) | £7 | |
| Net Profit | £7 | £10 | (£26) | £50,270 | (£241) | (£276) | (£112) | (£110) | (£108) | £19 | (£17) | £22 | |
| Net Profit/Sales | 0.01% | 0.01% | -0.03% | 28.73% | -0.30% | -0.34% | -0.14% | -0.14% | -0.13% | 0.02% | -0.02% | 0.03% | |
| 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 | £40,500 | £40,500 | £40,500 | £87,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | |
| Cash from Receivables | £0 | £1,350 | £40,500 | £40,500 | £42,067 | £85,933 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | |
| Subtotal Cash from Operations | £40,500 | £41,850 | £81,000 | £128,000 | £82,567 | £126,433 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | |
| 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 | £41,000 | £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 | £40,500 | £41,850 | £81,000 | £169,000 | £82,567 | £126,433 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | |
| 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 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | |
| Bill Payments | £7,207 | £65,861 | £55,999 | £58,444 | £124,982 | £28,603 | £56,279 | £56,120 | £56,118 | £56,112 | £55,991 | £56,024 | |
| Subtotal Spent on Operations | £31,907 | £90,561 | £80,699 | £83,144 | £149,682 | £53,303 | £80,979 | £80,820 | £80,818 | £80,812 | £80,691 | £80,724 | |
| 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 | £20,000 | £0 | £0 | £20,000 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £334 | £334 | £334 | £334 | £333 | £333 | £333 | £333 | £333 | £333 | £333 | £333 | |
| 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 | £32,241 | £90,895 | £81,033 | £83,478 | £150,015 | £53,636 | £101,312 | £81,153 | £81,151 | £101,145 | £81,024 | £81,057 | |
| Net Cash Flow | £8,259 | (£49,045) | (£33) | £85,522 | (£67,448) | £72,797 | (£20,312) | (£153) | (£151) | (£20,145) | (£24) | (£57) | |
| Cash Balance | £78,259 | £29,215 | £29,181 | £114,703 | £47,255 | £120,052 | £99,740 | £99,587 | £99,436 | £79,291 | £79,267 | £79,210 | |
| 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 | £70,000 | £78,259 | £29,215 | £29,181 | £114,703 | £47,255 | £120,052 | £99,740 | £99,587 | £99,436 | £79,291 | £79,267 | £79,210 |
| Accounts Receivable | £0 | £40,500 | £79,650 | £79,650 | £126,650 | £125,083 | £79,650 | £79,650 | £79,650 | £79,650 | £79,650 | £79,650 | £79,650 |
| Inventory | £25,000 | £35,200 | £35,200 | £35,200 | £63,800 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £100,000 | £158,959 | £149,065 | £149,031 | £310,153 | £212,538 | £239,902 | £219,590 | £219,437 | £219,286 | £199,141 | £199,117 | £199,060 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Accumulated Depreciation | £0 | £292 | £584 | £876 | £1,168 | £1,460 | £1,752 | £2,044 | £2,336 | £2,628 | £2,920 | £3,212 | £3,504 |
| Total Long-term Assets | £35,000 | £34,708 | £34,416 | £34,124 | £33,832 | £33,540 | £33,248 | £32,956 | £32,664 | £32,372 | £32,080 | £31,788 | £31,496 |
| Total Assets | £135,000 | £193,667 | £183,481 | £183,155 | £343,985 | £246,078 | £273,150 | £252,546 | £252,101 | £251,658 | £231,221 | £230,905 | £230,556 |
| 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 | £5,000 | £63,994 | £54,132 | £54,166 | £124,060 | £26,727 | £54,408 | £54,249 | £54,248 | £54,246 | £54,123 | £54,158 | £54,120 |
| Current Borrowing | £30,000 | £30,000 | £30,000 | £30,000 | £71,000 | £71,000 | £71,000 | £51,000 | £51,000 | £51,000 | £31,000 | £31,000 | £31,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £35,000 | £93,994 | £84,132 | £84,166 | £195,060 | £97,727 | £125,408 | £105,249 | £105,248 | £105,246 | £85,123 | £85,158 | £85,120 |
| Long-term Liabilities | £20,000 | £19,666 | £19,332 | £18,998 | £18,664 | £18,331 | £17,998 | £17,665 | £17,332 | £16,999 | £16,666 | £16,333 | £16,000 |
| Total Liabilities | £55,000 | £113,660 | £103,464 | £103,164 | £213,724 | £116,058 | £143,406 | £122,914 | £122,580 | £122,245 | £101,789 | £101,491 | £101,120 |
| Paid-in Capital | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 |
| Retained Earnings | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) |
| Earnings | £0 | £7 | £17 | (£9) | £50,261 | £50,020 | £49,744 | £49,632 | £49,521 | £49,413 | £49,431 | £49,414 | £49,437 |
| Total Capital | £80,000 | £80,007 | £80,017 | £79,991 | £130,261 | £130,020 | £129,744 | £129,632 | £129,521 | £129,413 | £129,431 | £129,414 | £129,437 |
| Total Liabilities and Capital | £135,000 | £193,667 | £183,481 | £183,155 | £343,985 | £246,078 | £273,150 | £252,546 | £252,101 | £251,658 | £231,221 | £230,905 | £230,556 |
| Net Worth | £80,000 | £80,007 | £80,017 | £79,991 | £130,261 | £130,020 | £129,744 | £129,632 | £129,521 | £129,413 | £129,431 | £129,414 | £129,437 |
| 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 | |||||||||||||
| Sales | 0% | £81,000 | £81,000 | £81,000 | £175,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £81,000 | £81,000 | £81,000 | £175,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,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 | |
| Sales | £32,000 | £32,000 | £32,000 | £58,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £32,000 | £32,000 | £32,000 | £58,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,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 | ||
| President | 0% | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Head of American Division | 0% | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 | £5,500 |
| Vice President American Division | 0% | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 | £4,500 |
| Other | 0% | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 | £8,700 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.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 | £81,000 | £81,000 | £81,000 | £175,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | |
| Direct Cost of Sales | £32,000 | £32,000 | £32,000 | £58,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | £32,000 | |
| Other | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | £2,750 | |
| Total Cost of Sales | £34,750 | £34,750 | £34,750 | £60,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | £34,750 | |
| Gross Margin | £46,250 | £46,250 | £46,250 | £114,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | £46,250 | |
| Gross Margin % | 57.10% | 57.10% | 57.10% | 65.29% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | 57.10% | |
| Expenses | |||||||||||||
| Payroll | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | |
| Sales and Marketing and Other Expenses | £8,350 | £8,350 | £8,350 | £8,900 | £8,275 | £8,350 | £8,350 | £8,350 | £8,350 | £8,350 | £8,350 | £8,350 | |
| Depreciation | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | £292 | |
| Leased Equipment | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | |
| Utilities | £500 | £500 | £550 | £600 | £575 | £550 | £500 | £500 | £500 | £500 | £550 | £500 | |
| Insurance | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Rent | £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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Payroll Taxes | 12% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £45,842 | £45,842 | £45,892 | £46,492 | £45,842 | £45,892 | £45,842 | £45,842 | £45,842 | £45,842 | £45,892 | £45,842 | |
| Profit Before Interest and Taxes | £408 | £408 | £358 | £67,758 | £408 | £358 | £408 | £408 | £408 | £408 | £358 | £408 | |
| EBITDA | £700 | £700 | £650 | £68,050 | £700 | £650 | £700 | £700 | £700 | £700 | £650 | £700 | |
| Interest Expense | £397 | £395 | £392 | £732 | £729 | £727 | £557 | £555 | £552 | £383 | £381 | £378 | |
| Taxes Incurred | £3 | £3 | (£9) | £16,757 | (£80) | (£92) | (£37) | (£37) | (£36) | £6 | (£6) | £7 | |
| Net Profit | £7 | £10 | (£26) | £50,270 | (£241) | (£276) | (£112) | (£110) | (£108) | £19 | (£17) | £22 | |
| Net Profit/Sales | 0.01% | 0.01% | -0.03% | 28.73% | -0.30% | -0.34% | -0.14% | -0.14% | -0.13% | 0.02% | -0.02% | 0.03% | |
| 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 | £40,500 | £40,500 | £40,500 | £87,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | |
| Cash from Receivables | £0 | £1,350 | £40,500 | £40,500 | £42,067 | £85,933 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | £40,500 | |
| Subtotal Cash from Operations | £40,500 | £41,850 | £81,000 | £128,000 | £82,567 | £126,433 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | |
| 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 | £41,000 | £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 | £40,500 | £41,850 | £81,000 | £169,000 | £82,567 | £126,433 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | £81,000 | |
| 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 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | £24,700 | |
| Bill Payments | £7,207 | £65,861 | £55,999 | £58,444 | £124,982 | £28,603 | £56,279 | £56,120 | £56,118 | £56,112 | £55,991 | £56,024 | |
| Subtotal Spent on Operations | £31,907 | £90,561 | £80,699 | £83,144 | £149,682 | £53,303 | £80,979 | £80,820 | £80,818 | £80,812 | £80,691 | £80,724 | |
| 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 | £20,000 | £0 | £0 | £20,000 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £334 | £334 | £334 | £334 | £333 | £333 | £333 | £333 | £333 | £333 | £333 | £333 | |
| 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 | £32,241 | £90,895 | £81,033 | £83,478 | £150,015 | £53,636 | £101,312 | £81,153 | £81,151 | £101,145 | £81,024 | £81,057 | |
| Net Cash Flow | £8,259 | (£49,045) | (£33) | £85,522 | (£67,448) | £72,797 | (£20,312) | (£153) | (£151) | (£20,145) | (£24) | (£57) | |
| Cash Balance | £78,259 | £29,215 | £29,181 | £114,703 | £47,255 | £120,052 | £99,740 | £99,587 | £99,436 | £79,291 | £79,267 | £79,210 | |
| 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 | £70,000 | £78,259 | £29,215 | £29,181 | £114,703 | £47,255 | £120,052 | £99,740 | £99,587 | £99,436 | £79,291 | £79,267 | £79,210 |
| Accounts Receivable | £0 | £40,500 | £79,650 | £79,650 | £126,650 | £125,083 | £79,650 | £79,650 | £79,650 | £79,650 | £79,650 | £79,650 | £79,650 |
| Inventory | £25,000 | £35,200 | £35,200 | £35,200 | £63,800 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 | £35,200 |
| Other Current Assets | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Total Current Assets | £100,000 | £158,959 | £149,065 | £149,031 | £310,153 | £212,538 | £239,902 | £219,590 | £219,437 | £219,286 | £199,141 | £199,117 | £199,060 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 | £35,000 |
| Accumulated Depreciation | £0 | £292 | £584 | £876 | £1,168 | £1,460 | £1,752 | £2,044 | £2,336 | £2,628 | £2,920 | £3,212 | £3,504 |
| Total Long-term Assets | £35,000 | £34,708 | £34,416 | £34,124 | £33,832 | £33,540 | £33,248 | £32,956 | £32,664 | £32,372 | £32,080 | £31,788 | £31,496 |
| Total Assets | £135,000 | £193,667 | £183,481 | £183,155 | £343,985 | £246,078 | £273,150 | £252,546 | £252,101 | £251,658 | £231,221 | £230,905 | £230,556 |
| 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 | £5,000 | £63,994 | £54,132 | £54,166 | £124,060 | £26,727 | £54,408 | £54,249 | £54,248 | £54,246 | £54,123 | £54,158 | £54,120 |
| Current Borrowing | £30,000 | £30,000 | £30,000 | £30,000 | £71,000 | £71,000 | £71,000 | £51,000 | £51,000 | £51,000 | £31,000 | £31,000 | £31,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £35,000 | £93,994 | £84,132 | £84,166 | £195,060 | £97,727 | £125,408 | £105,249 | £105,248 | £105,246 | £85,123 | £85,158 | £85,120 |
| Long-term Liabilities | £20,000 | £19,666 | £19,332 | £18,998 | £18,664 | £18,331 | £17,998 | £17,665 | £17,332 | £16,999 | £16,666 | £16,333 | £16,000 |
| Total Liabilities | £55,000 | £113,660 | £103,464 | £103,164 | £213,724 | £116,058 | £143,406 | £122,914 | £122,580 | £122,245 | £101,789 | £101,491 | £101,120 |
| Paid-in Capital | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 | £171,000 |
| Retained Earnings | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) | (£91,000) |
| Earnings | £0 | £7 | £17 | (£9) | £50,261 | £50,020 | £49,744 | £49,632 | £49,521 | £49,413 | £49,431 | £49,414 | £49,437 |
| Total Capital | £80,000 | £80,007 | £80,017 | £79,991 | £130,261 | £130,020 | £129,744 | £129,632 | £129,521 | £129,413 | £129,431 | £129,414 | £129,437 |
| Total Liabilities and Capital | £135,000 | £193,667 | £183,481 | £183,155 | £343,985 | £246,078 | £273,150 | £252,546 | £252,101 | £251,658 | £231,221 | £230,905 | £230,556 |
| Net Worth | £80,000 | £80,007 | £80,017 | £79,991 | £130,261 | £130,020 | £129,744 | £129,632 | £129,521 | £129,413 | £129,431 | £129,414 | £129,437 |