Plan Outline
ISP Business Plan
Web Solutions, Inc.
This sample business plan can be edited directly in Business Plan Pro software.
Appendix
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Dialup Internet Access | 0% | £98,250 | £98,500 | £97,250 | £98,250 | £96,250 | £96,250 | £96,250 | £96,250 | £96,250 | £96,250 | £93,000 | £92,250 |
| High-bandwidth Internet Access | 0% | £9,250 | £9,750 | £9,500 | £9,250 | £8,750 | £8,750 | £8,750 | £8,750 | £8,750 | £8,750 | £7,750 | £7,000 |
| Website and Virtual Domain Hosting | 0% | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 |
| Network Services | 0% | £8,000 | £8,000 | £7,000 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £5,000 | £3,250 |
| Server Colocation | 0% | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 | £6,250 |
| Other | 0% | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 |
| Total Sales | £129,250 | £130,000 | £127,500 | £127,500 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £119,500 | £116,250 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Dialup Internet Access | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | £3,333 | |
| High-bandwidth Internet Access | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Website and Virtual Domain Hosting | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Network Services | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Server Colocation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Other | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Subtotal Direct Cost of Sales | £4,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Donald Williams | 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 |
| Amy Williams | 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 |
| Geena James | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Dialup Services Manager | 0% | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 | £3,750 |
| R & D Manager | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| R & D Researcher | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Technical Support Personnel | 0% | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Technical Support Personnel | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Total People | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | |
| Total Payroll | £24,350 | £24,350 | £24,350 | £24,350 | £24,350 | £24,350 | £26,950 | £26,950 | £26,950 | £26,950 | £26,950 | £26,950 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £129,250 | £130,000 | £127,500 | £127,500 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £125,000 | £119,500 | £116,250 | |
| Direct Cost of Sales | £4,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £4,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | £6,633 | |
| Gross Margin | £124,617 | £123,367 | £120,867 | £120,867 | £118,367 | £118,367 | £118,367 | £118,367 | £118,367 | £118,367 | £112,867 | £109,617 | |
| Gross Margin % | 96.42% | 94.90% | 94.80% | 94.80% | 94.69% | 94.69% | 94.69% | 94.69% | 94.69% | 94.69% | 94.45% | 94.29% | |
| Expenses | |||||||||||||
| Payroll | £24,350 | £24,350 | £24,350 | £24,350 | £24,350 | £24,350 | £26,950 | £26,950 | £26,950 | £26,950 | £26,950 | £26,950 | |
| Sales and Marketing and Other Expenses | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | £3,456 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Legal Fees | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | |
| Utilities | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Insurance | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Mortgage | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | £5,600 | |
| Payroll Taxes | 15% | £3,653 | £3,653 | £3,653 | £3,653 | £3,653 | £3,653 | £4,043 | £4,043 | £4,043 | £4,043 | £4,043 | £4,043 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £37,733 | £37,733 | £37,733 | £37,733 | £37,733 | £37,733 | £40,723 | £40,723 | £40,723 | £40,723 | £40,723 | £40,723 | |
| Profit Before Interest and Taxes | £86,884 | £85,634 | £83,134 | £83,134 | £80,634 | £80,634 | £77,644 | £77,644 | £77,644 | £77,644 | £72,144 | £68,894 | |
| EBITDA | £86,884 | £85,634 | £83,134 | £83,134 | £80,634 | £80,634 | £77,644 | £77,644 | £77,644 | £77,644 | £72,144 | £68,894 | |
| Interest Expense | £5,990 | £5,844 | £5,698 | £5,553 | £5,407 | £5,261 | £5,115 | £4,969 | £4,823 | £4,678 | £4,532 | £4,386 | |
| Taxes Incurred | £24,268 | £19,947 | £19,359 | £19,395 | £18,807 | £18,843 | £18,132 | £18,169 | £18,205 | £18,242 | £16,903 | £16,127 | |
| Net Profit | £56,626 | £59,842 | £58,077 | £58,186 | £56,420 | £56,530 | £54,397 | £54,506 | £54,615 | £54,725 | £50,709 | £48,381 | |
| Net Profit/Sales | 43.81% | 46.03% | 45.55% | 45.64% | 45.14% | 45.22% | 43.52% | 43.60% | 43.69% | 43.78% | 42.43% | 41.62% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £109,863 | £110,500 | £108,375 | £108,375 | £106,250 | £106,250 | £106,250 | £106,250 | £106,250 | £106,250 | £101,575 | £98,813 | |
| Cash from Receivables | £11,750 | £12,396 | £19,391 | £19,488 | £19,125 | £19,113 | £18,750 | £18,750 | £18,750 | £18,750 | £18,750 | £18,723 | |
| Subtotal Cash from Operations | £121,613 | £122,896 | £127,766 | £127,863 | £125,375 | £125,363 | £125,000 | £125,000 | £125,000 | £125,000 | £120,325 | £117,535 | |
| 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 | £121,613 | £122,896 | £127,766 | £127,863 | £125,375 | £125,363 | £125,000 | £125,000 | £125,000 | £125,000 | £120,325 | £117,535 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £24,350 | £24,350 | £24,350 | £24,350 | £24,350 | £24,350 | £26,950 | £26,950 | £26,950 | £26,950 | £26,950 | £26,950 | |
| Bill Payments | £72,297 | £48,192 | £45,783 | £45,070 | £44,940 | £44,226 | £44,105 | £43,650 | £43,540 | £43,431 | £43,276 | £41,810 | |
| Subtotal Spent on Operations | £96,647 | £72,542 | £70,133 | £69,420 | £69,290 | £68,576 | £71,055 | £70,600 | £70,490 | £70,381 | £70,226 | £68,760 | |
| 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 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | £12,500 | |
| 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 | £114,147 | £90,042 | £87,633 | £86,920 | £86,790 | £86,076 | £88,555 | £88,100 | £87,990 | £87,881 | £87,726 | £86,260 | |
| Net Cash Flow | £7,466 | £32,854 | £40,133 | £40,943 | £38,585 | £39,286 | £36,445 | £36,900 | £37,010 | £37,119 | £32,599 | £31,275 | |
| Cash Balance | £120,078 | £152,932 | £193,065 | £234,008 | £272,593 | £311,880 | £348,325 | £385,225 | £422,235 | £459,354 | £491,953 | £523,228 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £112,613 | £120,078 | £152,932 | £193,065 | £234,008 | £272,593 | £311,880 | £348,325 | £385,225 | £422,235 | £459,354 | £491,953 | £523,228 |
| Accounts Receivable | £23,500 | £31,138 | £38,241 | £37,975 | £37,613 | £37,238 | £36,875 | £36,875 | £36,875 | £36,875 | £36,875 | £36,050 | £34,765 |
| Other Current Assets | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 | £34,650 |
| Total Current Assets | £170,763 | £185,866 | £225,824 | £265,690 | £306,271 | £344,481 | £383,405 | £419,850 | £456,750 | £493,760 | £530,879 | £562,653 | £592,643 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 | £331,650 |
| Total Assets | £502,413 | £517,516 | £557,474 | £597,340 | £637,921 | £676,131 | £715,055 | £751,500 | £788,400 | £825,410 | £862,529 | £894,303 | £924,293 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £70,688 | £46,665 | £44,281 | £43,571 | £43,465 | £42,755 | £42,650 | £42,198 | £42,093 | £41,987 | £41,881 | £40,446 | £39,555 |
| Current Borrowing | £90,337 | £85,337 | £80,337 | £75,337 | £70,337 | £65,337 | £60,337 | £55,337 | £50,337 | £45,337 | £40,337 | £35,337 | £30,337 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £161,025 | £132,002 | £124,618 | £118,908 | £113,802 | £108,092 | £102,987 | £97,535 | £92,430 | £87,324 | £82,218 | £75,783 | £69,892 |
| Long-term Liabilities | £645,975 | £633,475 | £620,975 | £608,475 | £595,975 | £583,475 | £570,975 | £558,475 | £545,975 | £533,475 | £520,975 | £508,475 | £495,975 |
| Total Liabilities | £807,000 | £765,477 | £745,593 | £727,383 | £709,777 | £691,567 | £673,962 | £656,010 | £638,405 | £620,799 | £603,193 | £584,258 | £565,867 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) | (£304,587) |
| Earnings | £0 | £56,626 | £116,468 | £174,544 | £232,730 | £289,151 | £345,680 | £400,077 | £454,583 | £509,198 | £563,923 | £614,632 | £663,013 |
| Total Capital | (£304,587) | (£247,961) | (£188,119) | (£130,043) | (£71,857) | (£15,436) | £41,093 | £95,490 | £149,996 | £204,611 | £259,336 | £310,045 | £358,426 |
| Total Liabilities and Capital | £502,413 | £517,516 | £557,474 | £597,340 | £637,921 | £676,131 | £715,055 | £751,500 | £788,400 | £825,410 | £862,529 | £894,303 | £924,293 |
| Net Worth | (£304,587) | (£247,961) | (£188,119) | (£130,043) | (£71,857) | (£15,436) | £41,093 | £95,490 | £149,996 | £204,611 | £259,336 | £310,045 | £358,426 |
