Click here to buy now or call 0845 351 9924
Plan Outline
Wireless DataComm Business Plan
Pie in the Sky Wi-Fi
This sample business plan can be edited directly in Business Plan Pro software.
Appendix
| 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 | |||||||||||||
| Enterprise Plan Revenue | 0% | £0 | £0 | £0 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| ISP Plan Revenue | 0% | £0 | £0 | £0 | £10,000 | £10,000 | £20,000 | £20,000 | £20,000 | £30,000 | £30,000 | £30,000 | £30,000 |
| Monthly - Enterprise Plan | 0% | £0 | £0 | £0 | £1,500 | £3,000 | £6,000 | £9,000 | £12,000 | £16,500 | £21,000 | £25,500 | £30,000 |
| Monthly - ISP Plan | 0% | £0 | £0 | £0 | £750 | £1,500 | £3,000 | £4,500 | £6,000 | £8,250 | £10,500 | £12,750 | £15,000 |
| Total Sales | £0 | £0 | £0 | £22,250 | £24,500 | £49,000 | £53,500 | £58,000 | £84,750 | £91,500 | £98,250 | £105,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 | |
| Enterprise Plan Revenue | £0 | £0 | £0 | £6,000 | £6,000 | £12,000 | £12,000 | £12,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| ISP Plan Revenue | £0 | £0 | £0 | £6,000 | £6,000 | £12,000 | £12,000 | £12,000 | £18,000 | £18,000 | £18,000 | £18,000 | |
| Monthly - Enterprise Plan | £0 | £0 | £0 | £800 | £1,600 | £3,200 | £4,800 | £6,400 | £8,800 | £11,200 | £13,600 | £16,000 | |
| Monthly - ISP Plan | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £12,800 | £13,600 | £27,200 | £28,800 | £30,400 | £44,800 | £47,200 | £49,600 | £52,000 | |
| 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 | £22,250 | £24,500 | £49,000 | £53,500 | £58,000 | £84,750 | £91,500 | £98,250 | £105,000 | |
| Direct Cost of Sales | £0 | £0 | £0 | £12,800 | £13,600 | £27,200 | £28,800 | £30,400 | £44,800 | £47,200 | £49,600 | £52,000 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £12,800 | £13,600 | £27,200 | £28,800 | £30,400 | £44,800 | £47,200 | £49,600 | £52,000 | |
| Gross Margin | £0 | £0 | £0 | £9,450 | £10,900 | £21,800 | £24,700 | £27,600 | £39,950 | £44,300 | £48,650 | £53,000 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 42.47% | 44.49% | 44.49% | 46.17% | 47.59% | 47.14% | 48.42% | 49.52% | 50.48% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £7,000 | £7,000 | £27,000 | £30,500 | £30,500 | £34,000 | £34,000 | £37,500 | £37,500 | |
| Marketing/Promotion | 2% | £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 | |
| Sales Commissions | 10% | £0 | £0 | £0 | £3,338 | £3,675 | £7,350 | £8,025 | £8,700 | £12,713 | £13,725 | £14,738 | £15,750 |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Office Rent | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Telephone | £50 | £50 | £50 | £50 | £50 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Internet & Utilities | £0 | £0 | £0 | £0 | £0 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | |
| Computer Supplies and Maintenance | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Travel | £0 | £0 | £0 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | |
| Insurance | 15% | £0 | £0 | £0 | £0 | £0 | £200 | £200 | £200 | £200 | £200 | £200 | £200 |
| Misc. | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Total Operating Expenses | £800 | £800 | £2,300 | £15,138 | £15,475 | £41,950 | £46,125 | £46,800 | £54,313 | £55,325 | £59,838 | £60,850 | |
| Profit Before Interest and Taxes | (£800) | (£800) | (£2,300) | (£5,688) | (£4,575) | (£20,150) | (£21,425) | (£19,200) | (£14,363) | (£11,025) | (£11,188) | (£7,850) | |
| EBITDA | (£800) | (£800) | (£2,300) | (£5,688) | (£4,575) | (£20,150) | (£21,425) | (£19,200) | (£14,363) | (£11,025) | (£11,188) | (£7,850) | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £823 | £814 | £804 | £794 | £784 | £774 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£800) | (£800) | (£2,300) | (£5,688) | (£4,575) | (£20,150) | (£22,248) | (£20,014) | (£15,166) | (£11,819) | (£11,971) | (£8,624) | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | -25.56% | -18.67% | -41.12% | -41.59% | -34.51% | -17.90% | -12.92% | -12.18% | -8.21% | |
| 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 | £16,688 | £18,375 | £36,750 | £40,125 | £43,500 | £63,563 | £68,625 | £73,688 | £78,750 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £2,967 | £5,863 | £9,392 | £12,850 | £13,975 | £18,067 | £22,088 | £23,775 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £16,688 | £21,342 | £42,613 | £49,517 | £56,350 | £77,538 | £86,692 | £95,775 | £102,525 | |
| 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 | £100,000 | £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 | £100,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £100,000 | £16,688 | £21,342 | £42,613 | £149,517 | £56,350 | £77,538 | £86,692 | £95,775 | £102,525 | |
| 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 | £0 | £0 | £0 | £7,000 | £7,000 | £27,000 | £30,500 | £30,500 | £34,000 | £34,000 | £37,500 | £37,500 | |
| Bill Payments | £27 | £800 | £850 | £2,921 | £20,975 | £22,744 | £42,253 | £45,324 | £48,127 | £66,030 | £69,432 | £72,835 | |
| Subtotal Spent on Operations | £27 | £800 | £850 | £9,921 | £27,975 | £49,744 | £72,753 | £75,824 | £82,127 | £100,030 | £106,932 | £110,335 | |
| 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 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | £1,190 | |
| 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 | £27 | £800 | £850 | £9,921 | £27,975 | £49,744 | £73,943 | £77,014 | £83,317 | £101,220 | £108,122 | £111,525 | |
| Net Cash Flow | (£27) | (£800) | £99,150 | £6,766 | (£6,634) | (£7,132) | £75,573 | (£20,664) | (£5,779) | (£14,528) | (£12,347) | (£9,000) | |
| Cash Balance | £33,473 | £32,673 | £131,823 | £138,590 | £131,956 | £124,824 | £200,398 | £179,734 | £173,954 | £159,426 | £147,079 | £138,080 | |
| 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 | £33,500 | £33,473 | £32,673 | £131,823 | £138,590 | £131,956 | £124,824 | £200,398 | £179,734 | £173,954 | £159,426 | £147,079 | £138,080 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £5,563 | £8,721 | £15,108 | £19,092 | £20,742 | £27,954 | £32,763 | £35,238 | £37,713 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £33,500 | £33,473 | £32,673 | £131,823 | £144,152 | £140,677 | £139,933 | £219,489 | £200,475 | £201,908 | £192,189 | £182,317 | £175,792 |
| 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 | £33,500 | £33,473 | £32,673 | £131,823 | £144,152 | £140,677 | £139,933 | £219,489 | £200,475 | £201,908 | £192,189 | £182,317 | £175,792 |
| 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 | £773 | £773 | £2,223 | £20,240 | £21,339 | £40,745 | £43,740 | £45,930 | £63,719 | £67,008 | £70,297 | £73,586 |
| 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 | £773 | £773 | £2,223 | £20,240 | £21,339 | £40,745 | £43,740 | £45,930 | £63,719 | £67,008 | £70,297 | £73,586 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £98,810 | £97,620 | £96,430 | £95,240 | £94,050 | £92,860 |
| Total Liabilities | £0 | £773 | £773 | £2,223 | £20,240 | £21,339 | £40,745 | £142,550 | £143,550 | £160,149 | £162,248 | £164,347 | £166,446 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 | £150,000 |
| Retained Earnings | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) | (£16,500) |
| Earnings | £0 | (£800) | (£1,600) | (£3,900) | (£9,588) | (£14,163) | (£34,313) | (£56,561) | (£76,574) | (£91,741) | (£103,559) | (£115,530) | (£124,154) |
| Total Capital | £33,500 | £32,700 | £31,900 | £129,600 | £123,913 | £119,338 | £99,188 | £76,939 | £56,926 | £41,760 | £29,941 | £17,970 | £9,346 |
| Total Liabilities and Capital | £33,500 | £33,473 | £32,673 | £131,823 | £144,152 | £140,677 | £139,933 | £219,489 | £200,475 | £201,908 | £192,189 | £182,317 | £175,792 |
| Net Worth | £33,500 | £32,700 | £31,900 | £129,600 | £123,913 | £119,338 | £99,188 | £76,939 | £56,926 | £41,760 | £29,941 | £17,970 | £9,346 |