| 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 | |||||||||||||
| All Services | 0% | £40,000 | £40,000 | £40,000 | £55,000 | £55,000 | £70,000 | £70,000 | £80,000 | £85,000 | £95,000 | £95,000 | £95,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £40,000 | £40,000 | £40,000 | £55,000 | £55,000 | £70,000 | £70,000 | £80,000 | £85,000 | £95,000 | £95,000 | £95,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 | |
| All Services | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| 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 | ||
| Directors | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Multimedia | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Data Communications | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Call Center | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 |
| Conference secr. | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | |
| Total Payroll | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | |
| 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% | 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 | £40,000 | £40,000 | £40,000 | £55,000 | £55,000 | £70,000 | £70,000 | £80,000 | £85,000 | £95,000 | £95,000 | £95,000 | |
| Direct Cost of Sales | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Gross Margin | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Gross Margin % | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | |
| Sales and Marketing and Other Expenses | £11,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 0% | £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,050 | £36,050 | £36,050 | £36,050 | £36,050 | £36,050 | £55,750 | £55,750 | £55,750 | £55,750 | £55,750 | £55,750 | |
| Profit Before Interest and Taxes | (£25,050) | (£16,050) | (£16,050) | (£8,550) | (£8,550) | (£1,050) | (£20,750) | (£15,750) | (£13,250) | (£8,250) | (£8,250) | (£8,250) | |
| EBITDA | (£25,050) | (£16,050) | (£16,050) | (£8,550) | (£8,550) | (£1,050) | (£20,750) | (£15,750) | (£13,250) | (£8,250) | (£8,250) | (£8,250) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£25,050) | (£16,050) | (£16,050) | (£8,550) | (£8,550) | (£1,050) | (£20,750) | (£15,750) | (£13,250) | (£8,250) | (£8,250) | (£8,250) | |
| Net Profit/Sales | -62.63% | -40.13% | -40.13% | -15.55% | -15.55% | -1.50% | -29.64% | -19.69% | -15.59% | -8.68% | -8.68% | -8.68% | |
| 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 | £10,000 | £10,000 | £10,000 | £13,750 | £13,750 | £17,500 | £17,500 | £20,000 | £21,250 | £23,750 | £23,750 | £23,750 | |
| Cash from Receivables | £0 | £1,000 | £30,000 | £30,000 | £30,375 | £41,250 | £41,625 | £52,500 | £52,750 | £60,125 | £64,000 | £71,250 | |
| Subtotal Cash from Operations | £10,000 | £11,000 | £40,000 | £43,750 | £44,125 | £58,750 | £59,125 | £72,500 | £74,000 | £83,875 | £87,750 | £95,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 | £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 | £10,000 | £11,000 | £40,000 | £43,750 | £44,125 | £58,750 | £59,125 | £72,500 | £74,000 | £83,875 | £87,750 | £95,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 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | |
| Bill Payments | £1,912 | £56,317 | £26,350 | £26,875 | £41,825 | £34,375 | £49,325 | £41,700 | £51,842 | £51,858 | £59,167 | £53,850 | |
| Subtotal Spent on Operations | £31,612 | £86,017 | £56,050 | £56,575 | £71,525 | £64,075 | £98,725 | £91,100 | £101,242 | £101,258 | £108,567 | £103,250 | |
| 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 | £31,612 | £86,017 | £56,050 | £56,575 | £71,525 | £64,075 | £98,725 | £91,100 | £101,242 | £101,258 | £108,567 | £103,250 | |
| Net Cash Flow | (£21,612) | (£75,017) | (£16,050) | (£12,825) | (£27,400) | (£5,325) | (£39,600) | (£18,600) | (£27,242) | (£17,383) | (£20,817) | (£8,250) | |
| Cash Balance | £328,388 | £253,372 | £237,322 | £224,497 | £197,097 | £191,772 | £152,172 | £133,572 | £106,330 | £88,947 | £68,130 | £59,880 | |
| 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 | £350,000 | £328,388 | £253,372 | £237,322 | £224,497 | £197,097 | £191,772 | £152,172 | £133,572 | £106,330 | £88,947 | £68,130 | £59,880 |
| Accounts Receivable | £0 | £30,000 | £59,000 | £59,000 | £70,250 | £81,125 | £92,375 | £103,250 | £110,750 | £121,750 | £132,875 | £140,125 | £140,125 |
| Inventory | £0 | £22,000 | £22,000 | £22,000 | £30,250 | £30,250 | £38,500 | £38,500 | £44,000 | £46,750 | £52,250 | £52,250 | £52,250 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £350,000 | £380,388 | £334,372 | £318,322 | £324,997 | £308,472 | £322,647 | £293,922 | £288,322 | £274,830 | £274,072 | £260,505 | £252,255 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 |
| Total Assets | £1,362,400 | £1,392,788 | £1,346,772 | £1,330,722 | £1,337,397 | £1,320,872 | £1,335,047 | £1,306,322 | £1,300,722 | £1,287,230 | £1,286,472 | £1,272,905 | £1,264,655 |
| 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 | £55,438 | £25,472 | £25,472 | £40,697 | £32,722 | £47,947 | £39,972 | £50,122 | £49,880 | £57,372 | £52,055 | £52,055 |
| 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 | £55,438 | £25,472 | £25,472 | £40,697 | £32,722 | £47,947 | £39,972 | £50,122 | £49,880 | £57,372 | £52,055 | £52,055 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £55,438 | £25,472 | £25,472 | £40,697 | £32,722 | £47,947 | £39,972 | £50,122 | £49,880 | £57,372 | £52,055 | £52,055 |
| Paid-in Capital | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 |
| Retained Earnings | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) |
| Earnings | £0 | (£25,050) | (£41,100) | (£57,150) | (£65,700) | (£74,250) | (£75,300) | (£96,050) | (£111,800) | (£125,050) | (£133,300) | (£141,550) | (£149,800) |
| Total Capital | £1,362,400 | £1,337,350 | £1,321,300 | £1,305,250 | £1,296,700 | £1,288,150 | £1,287,100 | £1,266,350 | £1,250,600 | £1,237,350 | £1,229,100 | £1,220,850 | £1,212,600 |
| Total Liabilities and Capital | £1,362,400 | £1,392,788 | £1,346,772 | £1,330,722 | £1,337,397 | £1,320,872 | £1,335,047 | £1,306,322 | £1,300,722 | £1,287,230 | £1,286,472 | £1,272,905 | £1,264,655 |
| Net Worth | £1,362,400 | £1,337,350 | £1,321,300 | £1,305,250 | £1,296,700 | £1,288,150 | £1,287,100 | £1,266,350 | £1,250,600 | £1,237,350 | £1,229,100 | £1,220,850 | £1,212,600 |
| 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 | |||||||||||||
| All Services | 0% | £40,000 | £40,000 | £40,000 | £55,000 | £55,000 | £70,000 | £70,000 | £80,000 | £85,000 | £95,000 | £95,000 | £95,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £40,000 | £40,000 | £40,000 | £55,000 | £55,000 | £70,000 | £70,000 | £80,000 | £85,000 | £95,000 | £95,000 | £95,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 | |
| All Services | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| 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 | ||
| Directors | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 |
| Multimedia | 0% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 |
| Data Communications | 0% | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Call Center | 0% | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £2,700 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 | £5,400 |
| Conference secr. | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | |
| Total Payroll | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | |
| 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% | 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 | £40,000 | £40,000 | £40,000 | £55,000 | £55,000 | £70,000 | £70,000 | £80,000 | £85,000 | £95,000 | £95,000 | £95,000 | |
| Direct Cost of Sales | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Gross Margin | £20,000 | £20,000 | £20,000 | £27,500 | £27,500 | £35,000 | £35,000 | £40,000 | £42,500 | £47,500 | £47,500 | £47,500 | |
| Gross Margin % | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | |
| Expenses | |||||||||||||
| Payroll | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | |
| Sales and Marketing and Other Expenses | £11,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | £2,550 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| 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 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Payroll Taxes | 0% | £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,050 | £36,050 | £36,050 | £36,050 | £36,050 | £36,050 | £55,750 | £55,750 | £55,750 | £55,750 | £55,750 | £55,750 | |
| Profit Before Interest and Taxes | (£25,050) | (£16,050) | (£16,050) | (£8,550) | (£8,550) | (£1,050) | (£20,750) | (£15,750) | (£13,250) | (£8,250) | (£8,250) | (£8,250) | |
| EBITDA | (£25,050) | (£16,050) | (£16,050) | (£8,550) | (£8,550) | (£1,050) | (£20,750) | (£15,750) | (£13,250) | (£8,250) | (£8,250) | (£8,250) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£25,050) | (£16,050) | (£16,050) | (£8,550) | (£8,550) | (£1,050) | (£20,750) | (£15,750) | (£13,250) | (£8,250) | (£8,250) | (£8,250) | |
| Net Profit/Sales | -62.63% | -40.13% | -40.13% | -15.55% | -15.55% | -1.50% | -29.64% | -19.69% | -15.59% | -8.68% | -8.68% | -8.68% | |
| 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 | £10,000 | £10,000 | £10,000 | £13,750 | £13,750 | £17,500 | £17,500 | £20,000 | £21,250 | £23,750 | £23,750 | £23,750 | |
| Cash from Receivables | £0 | £1,000 | £30,000 | £30,000 | £30,375 | £41,250 | £41,625 | £52,500 | £52,750 | £60,125 | £64,000 | £71,250 | |
| Subtotal Cash from Operations | £10,000 | £11,000 | £40,000 | £43,750 | £44,125 | £58,750 | £59,125 | £72,500 | £74,000 | £83,875 | £87,750 | £95,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 | £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 | £10,000 | £11,000 | £40,000 | £43,750 | £44,125 | £58,750 | £59,125 | £72,500 | £74,000 | £83,875 | £87,750 | £95,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 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £29,700 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | £49,400 | |
| Bill Payments | £1,912 | £56,317 | £26,350 | £26,875 | £41,825 | £34,375 | £49,325 | £41,700 | £51,842 | £51,858 | £59,167 | £53,850 | |
| Subtotal Spent on Operations | £31,612 | £86,017 | £56,050 | £56,575 | £71,525 | £64,075 | £98,725 | £91,100 | £101,242 | £101,258 | £108,567 | £103,250 | |
| 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 | £31,612 | £86,017 | £56,050 | £56,575 | £71,525 | £64,075 | £98,725 | £91,100 | £101,242 | £101,258 | £108,567 | £103,250 | |
| Net Cash Flow | (£21,612) | (£75,017) | (£16,050) | (£12,825) | (£27,400) | (£5,325) | (£39,600) | (£18,600) | (£27,242) | (£17,383) | (£20,817) | (£8,250) | |
| Cash Balance | £328,388 | £253,372 | £237,322 | £224,497 | £197,097 | £191,772 | £152,172 | £133,572 | £106,330 | £88,947 | £68,130 | £59,880 | |
| 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 | £350,000 | £328,388 | £253,372 | £237,322 | £224,497 | £197,097 | £191,772 | £152,172 | £133,572 | £106,330 | £88,947 | £68,130 | £59,880 |
| Accounts Receivable | £0 | £30,000 | £59,000 | £59,000 | £70,250 | £81,125 | £92,375 | £103,250 | £110,750 | £121,750 | £132,875 | £140,125 | £140,125 |
| Inventory | £0 | £22,000 | £22,000 | £22,000 | £30,250 | £30,250 | £38,500 | £38,500 | £44,000 | £46,750 | £52,250 | £52,250 | £52,250 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £350,000 | £380,388 | £334,372 | £318,322 | £324,997 | £308,472 | £322,647 | £293,922 | £288,322 | £274,830 | £274,072 | £260,505 | £252,255 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 | £1,012,400 |
| Total Assets | £1,362,400 | £1,392,788 | £1,346,772 | £1,330,722 | £1,337,397 | £1,320,872 | £1,335,047 | £1,306,322 | £1,300,722 | £1,287,230 | £1,286,472 | £1,272,905 | £1,264,655 |
| 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 | £55,438 | £25,472 | £25,472 | £40,697 | £32,722 | £47,947 | £39,972 | £50,122 | £49,880 | £57,372 | £52,055 | £52,055 |
| 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 | £55,438 | £25,472 | £25,472 | £40,697 | £32,722 | £47,947 | £39,972 | £50,122 | £49,880 | £57,372 | £52,055 | £52,055 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £55,438 | £25,472 | £25,472 | £40,697 | £32,722 | £47,947 | £39,972 | £50,122 | £49,880 | £57,372 | £52,055 | £52,055 |
| Paid-in Capital | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 | £2,554,400 |
| Retained Earnings | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) | (£1,192,000) |
| Earnings | £0 | (£25,050) | (£41,100) | (£57,150) | (£65,700) | (£74,250) | (£75,300) | (£96,050) | (£111,800) | (£125,050) | (£133,300) | (£141,550) | (£149,800) |
| Total Capital | £1,362,400 | £1,337,350 | £1,321,300 | £1,305,250 | £1,296,700 | £1,288,150 | £1,287,100 | £1,266,350 | £1,250,600 | £1,237,350 | £1,229,100 | £1,220,850 | £1,212,600 |
| Total Liabilities and Capital | £1,362,400 | £1,392,788 | £1,346,772 | £1,330,722 | £1,337,397 | £1,320,872 | £1,335,047 | £1,306,322 | £1,300,722 | £1,287,230 | £1,286,472 | £1,272,905 | £1,264,655 |
| Net Worth | £1,362,400 | £1,337,350 | £1,321,300 | £1,305,250 | £1,296,700 | £1,288,150 | £1,287,100 | £1,266,350 | £1,250,600 | £1,237,350 | £1,229,100 | £1,220,850 | £1,212,600 |