Acme Consulting

Start your own business plan »

High-Tech Marketing Business Plan

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