Marketing Consulting Business Plan

START YOUR OWN BUSINESS PLAN

Rate this plan
(3/5, 10 votes)

Appendix

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
Paul Berry 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $4,000 $4,000 $4,000 $4,000 $4,000 $5,000
Commission 0% $50 $400 $623 $911 $1,019 $1,559 $1,163 $1,163 $1,703 $2,547 $3,035 $3,179
Programmers 0% $0 $0 $0 $0 $1,200 $1,400 $1,800 $2,500 $3,000 $3,000 $3,300 $3,700
Total People 0 0 0 1 1 1 2 0 0 0 0 0
Total Payroll $3,050 $3,400 $3,623 $3,911 $5,219 $5,959 $6,963 $7,663 $8,703 $9,547 $10,335 $11,879
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
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 $5,250 $10,000 $10,650 $13,890 $16,230 $22,530 $20,050 $22,450 $32,250 $42,470 $47,710 $53,830
Direct Cost of Sales $1,300 $1,600 $2,063 $2,639 $3,093 $4,047 $4,149 $4,746 $6,003 $7,707 $9,227 $10,609
Other 10% $1,000 $1,200 $1,440 $1,728 $2,074 $2,488 $2,986 $3,583 $4,300 $5,160 $6,192 $7,430
Total Cost of Sales $2,300 $2,800 $3,503 $4,367 $5,166 $6,536 $7,135 $8,329 $10,303 $12,867 $15,418 $18,039
Gross Margin $2,950 $7,200 $7,147 $9,523 $11,064 $15,994 $12,915 $14,121 $21,947 $29,603 $32,292 $35,791
Gross Margin % 56.19% 72.00% 67.11% 68.56% 68.17% 70.99% 64.41% 62.90% 68.05% 69.70% 67.68% 66.49%
Expenses
Payroll $3,050 $3,400 $3,623 $3,911 $5,219 $5,959 $6,963 $7,663 $8,703 $9,547 $10,335 $11,879
Sales and Marketing and Other Expenses $1,000 $1,175 $1,393 $1,663 $2,001 $2,422 $2,950 $3,610 $4,439 $5,481 $6,792 $8,445
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment 10% $400 $480 $576 $691 $829 $995 $1,194 $1,433 $1,720 $2,064 $2,477 $2,972
Utilities 10% $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance 10% $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Rent 10% $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Payroll Taxes 20% $610 $680 $725 $782 $1,044 $1,192 $1,393 $1,533 $1,741 $1,909 $2,067 $2,376
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $5,410 $6,085 $6,666 $7,398 $9,443 $10,919 $14,850 $16,589 $18,953 $21,351 $24,021 $28,022
Profit Before Interest and Taxes ($2,460) $1,115 $481 $2,125 $1,621 $5,076 ($1,935) ($2,469) $2,995 $8,252 $8,271 $7,769
EBITDA ($2,460) $1,115 $481 $2,125 $1,621 $5,076 ($1,935) ($2,469) $2,995 $8,252 $8,271 $7,769
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $167 $167 $167 $167
Taxes Incurred ($738) $279 $120 $531 $405 $1,269 ($484) ($617) $707 $2,021 $2,026 $1,900
Net Profit ($1,722) $836 $361 $1,594 $1,216 $3,807 ($1,451) ($1,851) $2,121 $6,064 $6,078 $5,701
Net Profit/Sales -32.80% 8.36% 3.39% 11.48% 7.49% 16.90% -7.24% -8.25% 6.58% 14.28% 12.74% 10.59%
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 $175 $5,408 $10,022 $10,758 $13,968 $16,440 $22,447 $20,130 $22,777 $32,591 $42,645
Subtotal Cash from Operations $0 $175 $5,408 $10,022 $10,758 $13,968 $16,440 $22,447 $20,130 $22,777 $32,591 $42,645
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 $20,000 $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 $7,000 $4,000 $3,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $7,000 $4,175 $8,408 $10,022 $10,758 $13,968 $16,440 $22,447 $40,130 $22,777 $32,591 $42,645
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 $3,050 $3,400 $3,623 $3,911 $5,219 $5,959 $6,963 $7,663 $8,703 $9,547 $10,335 $11,879
Bill Payments $131 $3,983 $5,794 $6,724 $8,432 $9,894 $12,823 $14,608 $16,798 $21,607 $27,007 $31,462
Subtotal Spent on Operations $3,181 $7,383 $9,417 $10,635 $13,651 $15,853 $19,786 $22,271 $25,501 $31,154 $37,342 $43,341
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 $0 $0 $0 $0 $0 $0
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 $3,181 $7,383 $9,417 $10,635 $13,651 $15,853 $19,786 $22,271 $25,501 $31,154 $37,342 $43,341
Net Cash Flow $3,819 ($3,208) ($1,009) ($613) ($2,893) ($1,885) ($3,346) $176 $14,629 ($8,377) ($4,751) ($697)
Cash Balance $23,819 $20,611 $19,602 $18,989 $16,096 $14,211 $10,865 $11,041 $25,670 $17,293 $12,541 $11,845
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 $20,000 $23,819 $20,611 $19,602 $18,989 $16,096 $14,211 $10,865 $11,041 $25,670 $17,293 $12,541 $11,845
Accounts Receivable $0 $5,250 $15,075 $20,317 $24,185 $29,657 $38,219 $41,829 $41,832 $53,952 $73,645 $88,764 $99,950
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $20,000 $29,069 $35,686 $39,919 $43,174 $45,753 $52,430 $52,694 $52,873 $79,622 $90,938 $101,306 $111,795
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 $20,000 $29,069 $35,686 $39,919 $43,174 $45,753 $52,430 $52,694 $52,873 $79,622 $90,938 $101,306 $111,795
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 $3,791 $5,572 $6,444 $8,105 $9,469 $12,339 $14,053 $16,084 $20,712 $25,964 $30,254 $35,041
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $20,000 $20,000 $20,000 $20,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $3,791 $5,572 $6,444 $8,105 $9,469 $12,339 $14,053 $16,084 $40,712 $45,964 $50,254 $55,041
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $3,791 $5,572 $6,444 $8,105 $9,469 $12,339 $14,053 $16,084 $40,712 $45,964 $50,254 $55,041
Paid-in Capital $23,500 $30,500 $34,500 $37,500 $37,500 $37,500 $37,500 $37,500 $37,500 $37,500 $37,500 $37,500 $37,500
Retained Earnings ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500) ($3,500)
Earnings $0 ($1,722) ($886) ($525) $1,069 $2,284 $6,091 $4,640 $2,789 $4,910 $10,974 $17,052 $22,753
Total Capital $20,000 $25,278 $30,114 $33,475 $35,069 $36,284 $40,091 $38,640 $36,789 $38,910 $44,974 $51,052 $56,753
Total Liabilities and Capital $20,000 $29,069 $35,686 $39,919 $43,174 $45,753 $52,430 $52,694 $52,873 $79,622 $90,938 $101,306 $111,795
Net Worth $20,000 $25,278 $30,114 $33,475 $35,069 $36,284 $40,091 $38,640 $36,789 $38,910 $44,974 $51,052 $56,753
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
Monthly Revenue 40% $5,000 $8,000 $7,535 $9,335 $11,135 $14,735 $14,235 $16,635 $23,735 $29,735 $32,535 $37,935
Commission Sales 50% $250 $2,000 $3,115 $4,555 $5,095 $7,795 $5,815 $5,815 $8,515 $12,735 $15,175 $15,895
Total Sales $5,250 $10,000 $10,650 $13,890 $16,230 $22,530 $20,050 $22,450 $32,250 $42,470 $47,710 $53,830
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
Monthly Revenue $1,250 $1,200 $1,440 $1,728 $2,074 $2,488 $2,986 $3,583 $4,300 $5,160 $6,192 $7,430
Commission Sales $50 $400 $623 $911 $1,019 $1,559 $1,163 $1,163 $1,703 $2,547 $3,035 $3,179
Subtotal Direct Cost of Sales $1,300 $1,600 $2,063 $2,639 $3,093 $4,047 $4,149 $4,746 $6,003 $7,707 $9,227 $10,609