Telecom Wireless Business Plan

Start your plan
Start my business plan

Start your own telecom wireless business plan

Cellular Providers

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Personal User Sales 0% $109,615 $123,643 $139,600 $139,600 $139,600 $139,600 $139,600 $139,600 $139,600 $139,600 $174,712 $209,513
Business User Sales 0% $35,650 $35,650 $35,650 $35,650 $35,650 $35,650 $35,650 $35,650 $35,650 $35,650 $31,650 $31,650
Total Sales $145,265 $159,293 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $206,362 $241,163
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Personal User Sales $46,038 $51,930 $58,632 $58,632 $58,632 $58,632 $58,632 $58,632 $58,632 $58,632 $73,379 $87,995
Business User Sales $16,043 $16,043 $16,043 $16,043 $16,043 $16,043 $16,043 $16,043 $16,043 $16,043 $14,243 $14,243
Subtotal Direct Cost of Sales $62,081 $67,973 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $87,622 $102,238
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
CEO 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
CFO 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
HR Manager 0% $4,166 $4,166 $4,166 $4,166 $4,166 $4,166 $4,166 $4,166 $4,166 $4,166 $4,166 $4,166
Regional 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
Office Manager 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
Marketing Staff 0% $4,000 $4,000 $4,000 $4,000 $4,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Retail Staff #1 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
Retail Staff #2 0% $0 $0 $0 $2,500 $2,500 $2,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Retail Staff #3 0% $0 $0 $0 $0 $0 $0 $0 $0 $4,500 $4,500 $4,500 $4,500
Retail Staff #4 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retail Staff #5 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retail Staff #6 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retail Staff #7 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retail Staff #8 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Personnel 0% $1,167 $1,167 $1,167 $2,333 $2,333 $2,333 $2,333 $2,333 $4,000 $4,000 $4,000 $4,000
Total People 6 6 6 8 8 8 8 8 10 10 10 10
Total Payroll $25,083 $25,083 $25,083 $28,749 $28,749 $31,749 $33,749 $33,749 $39,916 $39,916 $39,916 $39,916

Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $145,265 $159,293 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $206,362 $241,163
Direct Cost of Sales $62,081 $67,973 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $87,622 $102,238
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $62,081 $67,973 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $74,675 $87,622 $102,238
Gross Margin $83,184 $91,320 $100,576 $100,576 $100,576 $100,576 $100,576 $100,576 $100,576 $100,576 $118,740 $138,925
Gross Margin % 57.26% 57.33% 57.39% 57.39% 57.39% 57.39% 57.39% 57.39% 57.39% 57.39% 57.54% 57.61%
Expenses
Payroll $25,083 $25,083 $25,083 $28,749 $28,749 $31,749 $33,749 $33,749 $39,916 $39,916 $39,916 $39,916
Marketing/Promotion $33,340 $31,444 $33,838 $37,838 $45,838 $37,838 $37,838 $37,838 $37,838 $37,838 $42,504 $59,724
Depreciation $416 $416 $416 $416 $416 $416 $416 $416 $416 $416 $416 $416
Store Set Up Costs $0 $0 $15,000 $15,000 $0 $0 $0 $15,000 $15,000 $0 $15,000 $15,000
Repairs and Maintenance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $800 $800 $1,600 $1,600 $1,600 $1,600 $1,600 $2,400 $2,400 $2,400 $2,400 $3,200
Insurance $800 $800 $800 $1,600 $1,600 $1,600 $1,600 $2,400 $2,400 $2,400 $2,400 $3,200
Rent $1,500 $1,500 $3,000 $3,000 $3,000 $3,000 $3,000 $4,500 $4,500 $4,500 $4,500 $6,000
Payroll Taxes 15% $3,762 $3,762 $3,762 $4,312 $4,312 $4,762 $5,062 $5,062 $5,987 $5,987 $5,987 $5,987
Legal/Consultants 15% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Inventory Control systems $0 $0 $20,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $66,701 $64,805 $104,499 $93,515 $86,515 $81,965 $84,265 $102,365 $109,457 $94,457 $114,124 $134,444
Profit Before Interest and Taxes $16,483 $26,515 ($3,923) $7,061 $14,061 $18,611 $16,311 ($1,789) ($8,881) $6,119 $4,617 $4,481
EBITDA $16,899 $26,931 ($3,507) $7,477 $14,477 $19,027 $16,727 ($1,373) ($8,465) $6,535 $5,033 $4,897
Interest Expense $14,435 $14,328 $14,222 $14,115 $14,008 $13,902 $13,795 $13,688 $13,582 $13,475 $13,368 $13,262
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit $2,048 $12,187 ($18,145) ($7,054) $52 $4,709 $2,516 ($15,478) ($22,463) ($7,356) ($8,752) ($8,780)
Net Profit/Sales 1.41% 7.65% -10.35% -4.03% 0.03% 2.69% 1.44% -8.83% -12.82% -4.20% -4.24% -3.64%

Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $104,591 $114,691 $126,180 $126,180 $126,180 $126,180 $126,180 $126,180 $126,180 $126,180 $148,581 $173,637
Cash from Receivables $89,353 $90,709 $40,805 $44,751 $49,070 $49,070 $49,070 $49,070 $49,070 $49,070 $49,070 $49,360
Subtotal Cash from Operations $193,944 $205,400 $166,985 $170,931 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $197,651 $222,998
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 $100,000 $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 $293,944 $205,400 $166,985 $170,931 $175,250 $175,250 $175,250 $175,250 $175,250 $175,250 $197,651 $222,998
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $25,083 $25,083 $25,083 $28,749 $28,749 $31,749 $33,749 $33,749 $39,916 $39,916 $39,916 $39,916
Bill Payments $23,164 $151,210 $129,661 $174,531 $152,902 $145,777 $138,382 $139,169 $156,590 $156,878 $143,833 $190,246
Subtotal Spent on Operations $48,247 $176,293 $154,744 $203,280 $181,651 $177,526 $172,131 $172,918 $196,506 $196,794 $183,749 $230,162
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 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $15,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Purchase Other Current Assets $5,000 $0 $12,000 $0 $0 $0 $0 $0 $0 $0 $20,000 $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 $71,047 $189,093 $179,544 $216,080 $194,451 $190,326 $184,931 $185,718 $209,306 $209,594 $216,549 $242,962
Net Cash Flow $222,897 $16,307 ($12,559) ($45,149) ($19,201) ($15,076) ($9,681) ($10,468) ($34,056) ($34,344) ($18,898) ($19,964)
Cash Balance $397,897 $414,204 $401,645 $356,497 $337,295 $322,219 $312,537 $302,069 $268,013 $233,670 $214,772 $194,808

Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $175,000 $397,897 $414,204 $401,645 $356,497 $337,295 $322,219 $312,537 $302,069 $268,013 $233,670 $214,772 $194,808
Accounts Receivable $178,706 $130,027 $83,920 $92,185 $96,504 $96,504 $96,504 $96,504 $96,504 $96,504 $96,504 $105,216 $123,381
Inventory $34,000 $68,289 $74,770 $82,142 $82,142 $82,142 $82,142 $82,142 $82,142 $82,142 $82,142 $96,384 $112,462
Other Current Assets $3,000 $8,000 $8,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $40,000 $40,000
Total Current Assets $390,706 $604,213 $580,894 $595,973 $555,143 $535,942 $520,865 $511,184 $500,716 $466,660 $432,316 $456,371 $470,651
Long-term Assets
Long-term Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Accumulated Depreciation $0 $416 $832 $1,248 $1,664 $2,080 $2,496 $2,912 $3,328 $3,744 $4,160 $4,576 $4,992
Total Long-term Assets $50,000 $49,584 $49,168 $48,752 $48,336 $47,920 $47,504 $47,088 $46,672 $46,256 $45,840 $45,424 $45,008
Total Assets $440,706 $653,797 $630,062 $644,725 $603,479 $583,862 $568,369 $558,272 $547,388 $512,916 $478,156 $501,795 $515,659
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $18,097 $146,940 $123,819 $169,426 $148,035 $141,165 $133,763 $133,950 $151,344 $152,135 $137,532 $182,723 $218,167
Current Borrowing $0 $97,200 $94,400 $91,600 $88,800 $86,000 $83,200 $80,400 $77,600 $74,800 $72,000 $69,200 $66,400
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $18,097 $244,140 $218,219 $261,026 $236,835 $227,165 $216,963 $214,350 $228,944 $226,935 $209,532 $251,923 $284,567
Long-term Liabilities $1,650,000 $1,635,000 $1,625,000 $1,615,000 $1,605,000 $1,595,000 $1,585,000 $1,575,000 $1,565,000 $1,555,000 $1,545,000 $1,535,000 $1,525,000
Total Liabilities $1,668,097 $1,879,140 $1,843,219 $1,876,026 $1,841,835 $1,822,165 $1,801,963 $1,789,350 $1,793,944 $1,781,935 $1,754,532 $1,786,923 $1,809,567
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings ($1,413,246) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391) ($1,227,391)
Earnings $185,855 $2,048 $14,235 ($3,910) ($10,965) ($10,912) ($6,203) ($3,688) ($19,165) ($41,629) ($48,985) ($57,737) ($66,517)
Total Capital ($1,227,391) ($1,225,343) ($1,213,156) ($1,231,301) ($1,238,356) ($1,238,303) ($1,233,594) ($1,231,079) ($1,246,556) ($1,269,019) ($1,276,376) ($1,285,127) ($1,293,908)
Total Liabilities and Capital $440,706 $653,797 $630,062 $644,725 $603,479 $583,862 $568,369 $558,272 $547,388 $512,916 $478,156 $501,795 $515,659
Net Worth ($1,227,391) ($1,225,343) ($1,213,156) ($1,231,301) ($1,238,356) ($1,238,303) ($1,233,594) ($1,231,079) ($1,246,556) ($1,269,019) ($1,276,376) ($1,285,127) ($1,293,908)

Download link edge graphic Download this plan

Start your own telecom wireless business plan

Start your own business plan

LivePlan logo Start planning

Your business plan can look as polished and professional as this sample plan. It's fast and easy, with LivePlan.

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.