Our biggest savings of the year
Pie in the Sky Wi-Fi
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 | |||||||||||||
Enterprise Plan Revenue | 0% | $0 | $0 | $0 | $10,000 | $10,000 | $20,000 | $20,000 | $20,000 | $30,000 | $30,000 | $30,000 | $30,000 |
ISP Plan Revenue | 0% | $0 | $0 | $0 | $10,000 | $10,000 | $20,000 | $20,000 | $20,000 | $30,000 | $30,000 | $30,000 | $30,000 |
Monthly – Enterprise Plan | 0% | $0 | $0 | $0 | $1,500 | $3,000 | $6,000 | $9,000 | $12,000 | $16,500 | $21,000 | $25,500 | $30,000 |
Monthly – ISP Plan | 0% | $0 | $0 | $0 | $750 | $1,500 | $3,000 | $4,500 | $6,000 | $8,250 | $10,500 | $12,750 | $15,000 |
Total Sales | $0 | $0 | $0 | $22,250 | $24,500 | $49,000 | $53,500 | $58,000 | $84,750 | $91,500 | $98,250 | $105,000 | |
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 | |
Enterprise Plan Revenue | $0 | $0 | $0 | $6,000 | $6,000 | $12,000 | $12,000 | $12,000 | $18,000 | $18,000 | $18,000 | $18,000 | |
ISP Plan Revenue | $0 | $0 | $0 | $6,000 | $6,000 | $12,000 | $12,000 | $12,000 | $18,000 | $18,000 | $18,000 | $18,000 | |
Monthly – Enterprise Plan | $0 | $0 | $0 | $800 | $1,600 | $3,200 | $4,800 | $6,400 | $8,800 | $11,200 | $13,600 | $16,000 | |
Monthly – ISP Plan | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $12,800 | $13,600 | $27,200 | $28,800 | $30,400 | $44,800 | $47,200 | $49,600 | $52,000 |
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 | $0 | $22,250 | $24,500 | $49,000 | $53,500 | $58,000 | $84,750 | $91,500 | $98,250 | $105,000 | |
Direct Cost of Sales | $0 | $0 | $0 | $12,800 | $13,600 | $27,200 | $28,800 | $30,400 | $44,800 | $47,200 | $49,600 | $52,000 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $12,800 | $13,600 | $27,200 | $28,800 | $30,400 | $44,800 | $47,200 | $49,600 | $52,000 | |
Gross Margin | $0 | $0 | $0 | $9,450 | $10,900 | $21,800 | $24,700 | $27,600 | $39,950 | $44,300 | $48,650 | $53,000 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 42.47% | 44.49% | 44.49% | 46.17% | 47.59% | 47.14% | 48.42% | 49.52% | 50.48% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $0 | $7,000 | $7,000 | $27,000 | $30,500 | $30,500 | $34,000 | $34,000 | $37,500 | $37,500 | |
Marketing/Promotion | 2% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales Commissions | 10% | $0 | $0 | $0 | $3,338 | $3,675 | $7,350 | $8,025 | $8,700 | $12,713 | $13,725 | $14,738 | $15,750 |
Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Office Rent | $0 | $0 | $0 | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Telephone | $50 | $50 | $50 | $50 | $50 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Internet & Utilities | $0 | $0 | $0 | $0 | $0 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Computer Supplies and Maintenance | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Travel | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Insurance | 15% | $0 | $0 | $0 | $0 | $0 | $200 | $200 | $200 | $200 | $200 | $200 | $200 |
Misc. | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Total Operating Expenses | $800 | $800 | $2,300 | $15,138 | $15,475 | $41,950 | $46,125 | $46,800 | $54,313 | $55,325 | $59,838 | $60,850 | |
Profit Before Interest and Taxes | ($800) | ($800) | ($2,300) | ($5,688) | ($4,575) | ($20,150) | ($21,425) | ($19,200) | ($14,363) | ($11,025) | ($11,188) | ($7,850) | |
EBITDA | ($800) | ($800) | ($2,300) | ($5,688) | ($4,575) | ($20,150) | ($21,425) | ($19,200) | ($14,363) | ($11,025) | ($11,188) | ($7,850) | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $823 | $814 | $804 | $794 | $784 | $774 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($800) | ($800) | ($2,300) | ($5,688) | ($4,575) | ($20,150) | ($22,248) | ($20,014) | ($15,166) | ($11,819) | ($11,971) | ($8,624) | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | -25.56% | -18.67% | -41.12% | -41.59% | -34.51% | -17.90% | -12.92% | -12.18% | -8.21% |
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 | $0 | $16,688 | $18,375 | $36,750 | $40,125 | $43,500 | $63,563 | $68,625 | $73,688 | $78,750 | |
Cash from Receivables | $0 | $0 | $0 | $0 | $2,967 | $5,863 | $9,392 | $12,850 | $13,975 | $18,067 | $22,088 | $23,775 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $16,688 | $21,342 | $42,613 | $49,517 | $56,350 | $77,538 | $86,692 | $95,775 | $102,525 | |
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 | $100,000 | $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 | $100,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $0 | $100,000 | $16,688 | $21,342 | $42,613 | $149,517 | $56,350 | $77,538 | $86,692 | $95,775 | $102,525 | |
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 | $0 | $0 | $0 | $7,000 | $7,000 | $27,000 | $30,500 | $30,500 | $34,000 | $34,000 | $37,500 | $37,500 | |
Bill Payments | $27 | $800 | $850 | $2,921 | $20,975 | $22,744 | $42,253 | $45,324 | $48,127 | $66,030 | $69,432 | $72,835 | |
Subtotal Spent on Operations | $27 | $800 | $850 | $9,921 | $27,975 | $49,744 | $72,753 | $75,824 | $82,127 | $100,030 | $106,932 | $110,335 | |
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 | $1,190 | $1,190 | $1,190 | $1,190 | $1,190 | $1,190 | |
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 | $27 | $800 | $850 | $9,921 | $27,975 | $49,744 | $73,943 | $77,014 | $83,317 | $101,220 | $108,122 | $111,525 | |
Net Cash Flow | ($27) | ($800) | $99,150 | $6,766 | ($6,634) | ($7,132) | $75,573 | ($20,664) | ($5,779) | ($14,528) | ($12,347) | ($9,000) | |
Cash Balance | $33,473 | $32,673 | $131,823 | $138,590 | $131,956 | $124,824 | $200,398 | $179,734 | $173,954 | $159,426 | $147,079 | $138,080 |
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 | $33,500 | $33,473 | $32,673 | $131,823 | $138,590 | $131,956 | $124,824 | $200,398 | $179,734 | $173,954 | $159,426 | $147,079 | $138,080 |
Accounts Receivable | $0 | $0 | $0 | $0 | $5,563 | $8,721 | $15,108 | $19,092 | $20,742 | $27,954 | $32,763 | $35,238 | $37,713 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $33,500 | $33,473 | $32,673 | $131,823 | $144,152 | $140,677 | $139,933 | $219,489 | $200,475 | $201,908 | $192,189 | $182,317 | $175,792 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $33,500 | $33,473 | $32,673 | $131,823 | $144,152 | $140,677 | $139,933 | $219,489 | $200,475 | $201,908 | $192,189 | $182,317 | $175,792 |
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 | $773 | $773 | $2,223 | $20,240 | $21,339 | $40,745 | $43,740 | $45,930 | $63,719 | $67,008 | $70,297 | $73,586 |
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 | $773 | $773 | $2,223 | $20,240 | $21,339 | $40,745 | $43,740 | $45,930 | $63,719 | $67,008 | $70,297 | $73,586 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $98,810 | $97,620 | $96,430 | $95,240 | $94,050 | $92,860 |
Total Liabilities | $0 | $773 | $773 | $2,223 | $20,240 | $21,339 | $40,745 | $142,550 | $143,550 | $160,149 | $162,248 | $164,347 | $166,446 |
Paid-in Capital | $50,000 | $50,000 | $50,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 |
Retained Earnings | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) | ($16,500) |
Earnings | $0 | ($800) | ($1,600) | ($3,900) | ($9,588) | ($14,163) | ($34,313) | ($56,561) | ($76,574) | ($91,741) | ($103,559) | ($115,530) | ($124,154) |
Total Capital | $33,500 | $32,700 | $31,900 | $129,600 | $123,913 | $119,338 | $99,188 | $76,939 | $56,926 | $41,760 | $29,941 | $17,970 | $9,346 |
Total Liabilities and Capital | $33,500 | $33,473 | $32,673 | $131,823 | $144,152 | $140,677 | $139,933 | $219,489 | $200,475 | $201,908 | $192,189 | $182,317 | $175,792 |
Net Worth | $33,500 | $32,700 | $31,900 | $129,600 | $123,913 | $119,338 | $99,188 | $76,939 | $56,926 | $41,760 | $29,941 | $17,970 | $9,346 |