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) |