Acme Consulting
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 | |||||||||||||
| Retainer Consulting | 0% | $10,000 | $10,000 | $10,000 | $10,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
| Project Consulting | 0% | $0 | $0 | $10,000 | $20,000 | $30,000 | $40,000 | $20,000 | $10,000 | $30,000 | $45,000 | $50,000 | $15,000 |
| Market Research | 0% | $0 | $0 | $0 | $4,000 | $8,000 | $15,000 | $10,000 | $5,000 | $20,000 | $20,000 | $20,000 | $20,000 |
| Strategic Reports | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Sales | $10,000 | $10,000 | $20,000 | $34,000 | $58,000 | $75,000 | $50,000 | $35,000 | $70,000 | $85,000 | $90,000 | $55,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 | |
| Retainer Consulting | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
| Project Consulting | $0 | $0 | $1,500 | $3,500 | $5,000 | $6,500 | $3,500 | $1,500 | $5,000 | $7,500 | $8,500 | $2,500 | |
| Market Research | $0 | $0 | $0 | $2,000 | $6,000 | $10,000 | $6,000 | $4,000 | $14,000 | $14,000 | $14,000 | $14,000 | |
| Strategic Reports | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $2,500 | $2,500 | $4,000 | $8,000 | $13,500 | $19,000 | $12,000 | $8,000 | $21,500 | $24,000 | $25,000 | $19,000 | |
| 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 | ||
| Partners | 140% | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 |
| Consultants | 125% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Editorial/graphic | 120% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $6,000 | $6,000 | $6,000 |
| VP Marketing | 110% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,000 | $5,000 | $5,000 | $5,000 |
| Sales people | 110% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Office Manager | 110% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 |
| Secretarial | 110% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,750 | $1,750 | $1,750 |
| Total People | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 7 | 7 | 7 | |
| Total Payroll | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $17,000 | $27,250 | $27,250 | $27,250 | |
| 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 | $10,000 | $10,000 | $20,000 | $34,000 | $58,000 | $75,000 | $50,000 | $35,000 | $70,000 | $85,000 | $90,000 | $55,000 | |
| Direct Cost of Sales | $2,500 | $2,500 | $4,000 | $8,000 | $13,500 | $19,000 | $12,000 | $8,000 | $21,500 | $24,000 | $25,000 | $19,000 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $2,500 | $2,500 | $4,000 | $8,000 | $13,500 | $19,000 | $12,000 | $8,000 | $21,500 | $24,000 | $25,000 | $19,000 | |
| Gross Margin | $7,500 | $7,500 | $16,000 | $26,000 | $44,500 | $56,000 | $38,000 | $27,000 | $48,500 | $61,000 | $65,000 | $36,000 | |
| Gross Margin % | 75.00% | 75.00% | 80.00% | 76.47% | 76.72% | 74.67% | 76.00% | 77.14% | 69.29% | 71.76% | 72.22% | 65.45% | |
| Expenses | |||||||||||||
| Payroll | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $17,000 | $27,250 | $27,250 | $27,250 | |
| Marketing/Promotion | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | $13,500 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Leased Equipment | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Utilities | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Rent | 0% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
| Payroll Taxes | 14% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $28,800 | $28,800 | $28,800 | $28,800 | $28,800 | $28,800 | $28,800 | $28,800 | $33,800 | $44,050 | $44,050 | $44,050 | |
| Profit Before Interest and Taxes | ($21,300) | ($21,300) | ($12,800) | ($2,800) | $15,700 | $27,200 | $9,200 | ($1,800) | $14,700 | $16,950 | $20,950 | ($8,050) | |
| EBITDA | ($21,300) | ($21,300) | ($12,800) | ($2,800) | $15,700 | $27,200 | $9,200 | ($1,800) | $14,700 | $16,950 | $20,950 | ($8,050) | |
| Interest Expense | $417 | $416 | $583 | $582 | $582 | $665 | $664 | $664 | $663 | $663 | $663 | $662 | |
| Taxes Incurred | ($6,515) | ($6,515) | ($4,015) | ($1,015) | $4,536 | $7,961 | $2,561 | ($739) | $4,211 | $4,886 | $6,086 | ($2,613) | |
| Net Profit | ($15,202) | ($15,201) | ($9,368) | ($2,367) | $10,583 | $18,575 | $5,975 | ($1,725) | $9,826 | $11,401 | $14,201 | ($6,098) | |
| Net Profit/Sales | -152.02% | -152.01% | -46.84% | -6.96% | 18.25% | 24.77% | 11.95% | -4.93% | 14.04% | 13.41% | 15.78% | -11.09% | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Cash from Receivables | $0 | $5,333 | $10,000 | $15,333 | $27,467 | $46,800 | $67,067 | $61,667 | $42,000 | $53,667 | $78,000 | $87,667 | |
| Subtotal Cash from Operations | $0 | $5,333 | $10,000 | $15,333 | $27,467 | $46,800 | $67,067 | $61,667 | $42,000 | $53,667 | $78,000 | $87,667 | |
| 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 | $20,000 | $0 | $0 | $10,000 | $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 | $50,000 | $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 | $8,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $50,000 | $5,333 | $30,000 | $15,333 | $35,467 | $56,800 | $67,067 | $61,667 | $42,000 | $53,667 | $78,000 | $87,667 | |
| 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 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $17,000 | $27,250 | $27,250 | $27,250 | |
| Bill Payments | $790 | $13,202 | $13,340 | $17,601 | $24,736 | $35,717 | $44,012 | $31,782 | $25,340 | $43,280 | $46,422 | $48,059 | |
| Subtotal Spent on Operations | $12,790 | $25,202 | $25,340 | $29,601 | $36,736 | $47,717 | $56,012 | $43,782 | $42,340 | $70,530 | $73,672 | $75,309 | |
| 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 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $100 | |
| 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 | $12,790 | $25,252 | $25,390 | $29,651 | $36,786 | $47,767 | $56,062 | $43,832 | $42,390 | $70,580 | $73,722 | $75,409 | |
| Net Cash Flow | $37,210 | ($19,918) | $4,610 | ($14,318) | ($1,319) | $9,033 | $11,005 | $17,835 | ($390) | ($16,913) | $4,278 | $12,258 | |
| Cash Balance | $87,560 | $67,642 | $72,251 | $57,934 | $56,615 | $65,647 | $76,652 | $94,487 | $94,097 | $77,184 | $81,462 | $93,719 | |
| 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 | $50,350 | $87,560 | $67,642 | $72,251 | $57,934 | $56,615 | $65,647 | $76,652 | $94,487 | $94,097 | $77,184 | $81,462 | $93,719 |
| Accounts Receivable | $0 | $10,000 | $14,667 | $24,667 | $43,333 | $73,867 | $102,067 | $85,000 | $58,333 | $86,333 | $117,667 | $129,667 | $97,000 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $50,350 | $97,560 | $82,308 | $96,918 | $101,267 | $130,481 | $167,714 | $161,652 | $152,820 | $180,431 | $194,851 | $211,128 | $190,719 |
| 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 | $50,350 | $97,560 | $82,308 | $96,918 | $101,267 | $130,481 | $167,714 | $161,652 | $152,820 | $180,431 | $194,851 | $211,128 | $190,719 |
| 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 | $350 | $12,762 | $12,761 | $16,789 | $23,555 | $34,237 | $42,944 | $30,957 | $23,900 | $41,735 | $44,804 | $46,930 | $32,720 |
| Current Borrowing | $0 | $0 | $0 | $20,000 | $20,000 | $20,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $350 | $12,762 | $12,761 | $36,789 | $43,555 | $54,237 | $72,944 | $60,957 | $53,900 | $71,735 | $74,804 | $76,930 | $62,720 |
| Long-term Liabilities | $0 | $50,000 | $49,950 | $49,900 | $49,850 | $49,800 | $49,750 | $49,700 | $49,650 | $49,600 | $49,550 | $49,500 | $49,400 |
| Total Liabilities | $350 | $62,762 | $62,711 | $86,689 | $93,405 | $104,037 | $122,694 | $110,657 | $103,550 | $121,335 | $124,354 | $126,430 | $112,120 |
| Paid-in Capital | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 | $58,000 |
| Retained Earnings | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Earnings | $0 | ($15,202) | ($30,403) | ($39,771) | ($42,138) | ($31,555) | ($12,981) | ($7,006) | ($8,730) | $1,095 | $12,496 | $26,698 | $20,600 |
| Total Capital | $50,000 | $34,798 | $19,597 | $10,229 | $7,862 | $26,445 | $45,019 | $50,994 | $49,270 | $59,096 | $70,496 | $84,698 | $78,600 |
| Total Liabilities and Capital | $50,350 | $97,560 | $82,308 | $96,918 | $101,267 | $130,481 | $167,714 | $161,652 | $152,820 | $180,431 | $194,851 | $211,128 | $190,719 |
| Net Worth | $50,000 | $34,798 | $19,597 | $10,229 | $7,862 | $26,445 | $45,019 | $50,994 | $49,270 | $59,096 | $70,496 | $84,698 | $78,600 |
By 
