Grassroots Wireless

Start your own business plan »

Internet ISP Wireless Business Plan

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
Monthly Internet Service 0% $0 $0 $1,200 $2,112 $2,544 $2,887 $3,543 $3,877 $4,322 $4,899 $5,323 $5,877
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $1,200 $2,112 $2,544 $2,887 $3,543 $3,877 $4,322 $4,899 $5,323 $5,877
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
Administrative costs $0 $0 $60 $106 $127 $144 $177 $194 $216 $245 $266 $294
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $60 $106 $127 $144 $177 $194 $216 $245 $266 $294
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% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Technician 0% $0 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Administration 0% $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Total People 1 2 3 3 3 3 3 3 3 3 3 3
Total Payroll $2,000 $3,800 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300
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 $0 $0 $1,200 $2,112 $2,544 $2,887 $3,543 $3,877 $4,322 $4,899 $5,323 $5,877
Direct Cost of Sales $0 $0 $60 $106 $127 $144 $177 $194 $216 $245 $266 $294
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $60 $106 $127 $144 $177 $194 $216 $245 $266 $294
Gross Margin $0 $0 $1,140 $2,006 $2,417 $2,743 $3,366 $3,683 $4,106 $4,654 $5,057 $5,583
Gross Margin % 0.00% 0.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00%
Expenses
Payroll $2,000 $3,800 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83
Rent $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Utilities $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $300 $570 $795 $795 $795 $795 $795 $795 $795 $795 $795 $795
Other $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Operating Expenses $4,333 $6,403 $8,128 $8,128 $8,128 $8,128 $8,128 $8,128 $8,128 $8,128 $8,128 $8,128
Profit Before Interest and Taxes ($4,333) ($6,403) ($6,988) ($6,122) ($5,711) ($5,385) ($4,762) ($4,445) ($4,022) ($3,474) ($3,071) ($2,545)
EBITDA ($4,250) ($6,320) ($6,905) ($6,039) ($5,628) ($5,302) ($4,679) ($4,362) ($3,939) ($3,391) ($2,988) ($2,462)
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 ($4,333) ($6,403) ($6,988) ($6,122) ($5,711) ($5,385) ($4,762) ($4,445) ($4,022) ($3,474) ($3,071) ($2,545)
Net Profit/Sales 0.00% 0.00% -582.33% -289.85% -224.50% -186.54% -134.41% -114.65% -93.06% -70.91% -57.70% -43.30%
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 $1,200 $2,112 $2,544 $2,887 $3,543 $3,877 $4,322 $4,899 $5,323 $5,877
Subtotal Cash from Operations $0 $0 $1,200 $2,112 $2,544 $2,887 $3,543 $3,877 $4,322 $4,899 $5,323 $5,877
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 $0 $1,200 $2,112 $2,544 $2,887 $3,543 $3,877 $4,322 $4,899 $5,323 $5,877
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 $2,000 $3,800 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300 $5,300
Bill Payments $75 $2,259 $2,530 $2,807 $2,851 $2,873 $2,890 $2,923 $2,940 $2,962 $2,991 $3,012
Subtotal Spent on Operations $2,075 $6,059 $7,830 $8,107 $8,151 $8,173 $8,190 $8,223 $8,240 $8,262 $8,291 $8,312
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 $2,075 $6,059 $7,830 $8,107 $8,151 $8,173 $8,190 $8,223 $8,240 $8,262 $8,291 $8,312
Net Cash Flow ($2,075) ($6,059) ($6,630) ($5,995) ($5,607) ($5,286) ($4,647) ($4,346) ($3,918) ($3,363) ($2,968) ($2,435)
Cash Balance $53,425 $47,366 $40,737 $34,742 $29,135 $23,849 $19,201 $14,856 $10,938 $7,575 $4,607 $2,172
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 $55,500 $53,425 $47,366 $40,737 $34,742 $29,135 $23,849 $19,201 $14,856 $10,938 $7,575 $4,607 $2,172
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $55,500 $53,425 $47,366 $40,737 $34,742 $29,135 $23,849 $19,201 $14,856 $10,938 $7,575 $4,607 $2,172
Long-term Assets
Long-term 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
Accumulated Depreciation $0 $83 $166 $249 $332 $415 $498 $581 $664 $747 $830 $913 $996
Total Long-term Assets $5,000 $4,917 $4,834 $4,751 $4,668 $4,585 $4,502 $4,419 $4,336 $4,253 $4,170 $4,087 $4,004
Total Assets $60,500 $58,342 $52,200 $45,488 $39,410 $33,720 $28,351 $23,620 $19,192 $15,191 $11,745 $8,694 $6,176
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 $2,175 $2,436 $2,712 $2,756 $2,776 $2,793 $2,825 $2,841 $2,862 $2,890 $2,911 $2,938
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 $2,175 $2,436 $2,712 $2,756 $2,776 $2,793 $2,825 $2,841 $2,862 $2,890 $2,911 $2,938
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $2,175 $2,436 $2,712 $2,756 $2,776 $2,793 $2,825 $2,841 $2,862 $2,890 $2,911 $2,938
Paid-in Capital $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000
Retained Earnings ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500) ($9,500)
Earnings $0 ($4,333) ($10,736) ($17,724) ($23,846) ($29,557) ($34,942) ($39,704) ($44,149) ($48,171) ($51,645) ($54,716) ($57,261)
Total Capital $60,500 $56,167 $49,764 $42,776 $36,654 $30,943 $25,558 $20,796 $16,351 $12,329 $8,855 $5,784 $3,239
Total Liabilities and Capital $60,500 $58,342 $52,200 $45,488 $39,410 $33,720 $28,351 $23,620 $19,192 $15,191 $11,745 $8,694 $6,176
Net Worth $60,500 $56,167 $49,764 $42,776 $36,654 $30,943 $25,558 $20,796 $16,351 $12,329 $8,855 $5,784 $3,239