Cellular Providers

Start your own business plan »

Telecom Wireless Business Plan

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)