Marrowstone Advertising

Start your own business plan »

Advertising Consulting 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
Environmental nonprofits 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $9,000 $24,000
Youth development nonprofits 0% $0 $0 $0 $0 $0 $2,000 $4,000 $4,000 $5,000 $5,000 $6,000 $7,000
Cultural nonprofits 0% $0 $0 $0 $0 $7,000 $5,000 $3,000 $26,000 $4,000 $7,000 $10,000 $7,000
Other 0% $0 $0 $0 $0 $0 $0 $7,000 $5,000 $12,000 $5,000 $2,000 $5,000
Total Sales $6,000 $6,000 $6,000 $6,000 $13,000 $13,000 $20,000 $41,000 $27,000 $23,000 $27,000 $43,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
Row 1 $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
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Mr. Curtis Cole- president 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Mrs. Jennie Marks - CFO 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Mr. David Danielson - projects manager 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Mr. Milo Winn - audio-visual director 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Advertising consultant 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Advertising consultant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Graphic artist 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 500% 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
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% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.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 $6,000 $6,000 $6,000 $6,000 $13,000 $13,000 $20,000 $41,000 $27,000 $23,000 $27,000 $43,000
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $500 $500 $500 $500 $500 $500 $500 $700 $700 $700 $700 $700
Total Cost of Sales $500 $500 $500 $500 $500 $500 $500 $700 $700 $700 $700 $700
Gross Margin $5,500 $5,500 $5,500 $5,500 $12,500 $12,500 $19,500 $40,300 $26,300 $22,300 $26,300 $42,300
Gross Margin % 91.67% 91.67% 91.67% 91.67% 96.15% 96.15% 97.50% 98.29% 97.41% 96.96% 97.41% 98.37%
Expenses
Payroll $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Sales and Marketing and Other Expenses $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Depreciation $166 $166 $166 $166 $166 $166 $166 $166 $166 $166 $166 $174
Rent $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250 $2,250
Travel 15% $1,200 $3,000 $1,000 $2,000 $2,000 $3,000 $2,000 $1,000 $2,000 $3,000 $1,000 $3,000
Other $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Total Operating Expenses $21,766 $23,566 $21,566 $22,566 $22,566 $23,566 $22,566 $21,566 $22,566 $23,566 $21,566 $23,574
Profit Before Interest and Taxes ($16,266) ($18,066) ($16,066) ($17,066) ($10,066) ($11,066) ($3,066) $18,734 $3,734 ($1,266) $4,734 $18,726
EBITDA ($16,100) ($17,900) ($15,900) ($16,900) ($9,900) ($10,900) ($2,900) $18,900 $3,900 ($1,100) $4,900 $18,900
Interest Expense $503 $497 $492 $486 $481 $475 $511 $506 $500 $495 $489 $483
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($16,769) ($18,563) ($16,558) ($17,552) ($10,547) ($11,541) ($3,577) $18,228 $3,234 ($1,761) $4,245 $18,243
Net Profit/Sales -279.48% -309.39% -275.96% -292.54% -81.13% -88.78% -17.89% 44.46% 11.98% -7.65% 15.72% 42.42%
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 $1,500 $1,500 $1,500 $1,500 $3,250 $3,250 $5,000 $10,250 $6,750 $5,750 $6,750 $10,750
Cash from Receivables $0 $150 $4,500 $4,500 $4,500 $4,675 $9,750 $9,925 $15,525 $30,400 $20,150 $17,350
Subtotal Cash from Operations $1,500 $1,650 $6,000 $6,000 $7,750 $7,925 $14,750 $20,175 $22,275 $36,150 $26,900 $28,100
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 $5,000 $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 $1,500 $1,500 $0 $0 $0 $0
Subtotal Cash Received $1,500 $1,650 $6,000 $6,000 $7,750 $7,925 $21,250 $21,675 $22,275 $36,150 $26,900 $28,100
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 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Bill Payments $3,253 $7,663 $9,330 $7,425 $8,386 $8,414 $9,343 $8,384 $7,639 $8,633 $9,528 $7,655
Subtotal Spent on Operations $18,253 $22,663 $24,330 $22,425 $23,386 $23,414 $24,343 $23,384 $22,639 $23,633 $24,528 $22,655
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 $666 $666 $666 $666 $666 $666 $666 $666 $666 $666 $666 $666
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 $18,919 $23,329 $24,996 $23,091 $24,052 $24,080 $25,009 $24,050 $23,305 $24,299 $25,194 $23,321
Net Cash Flow ($17,419) ($21,679) ($18,996) ($17,091) ($16,302) ($16,155) ($3,759) ($2,375) ($1,030) $11,851 $1,706 $4,779
Cash Balance $99,881 $78,202 $59,206 $42,115 $25,813 $9,658 $5,899 $3,524 $2,494 $14,345 $16,051 $20,830
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 $117,300 $99,881 $78,202 $59,206 $42,115 $25,813 $9,658 $5,899 $3,524 $2,494 $14,345 $16,051 $20,830
Accounts Receivable $0 $4,500 $8,850 $8,850 $8,850 $14,100 $19,175 $24,425 $45,250 $49,975 $36,825 $36,925 $51,825
Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Current Assets $122,300 $109,381 $92,052 $73,056 $55,965 $44,913 $33,833 $35,324 $53,774 $57,469 $56,170 $57,976 $77,655
Long-term Assets
Long-term Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Accumulated Depreciation $0 $166 $332 $498 $664 $830 $996 $1,162 $1,328 $1,494 $1,660 $1,826 $2,000
Total Long-term Assets $10,000 $9,834 $9,668 $9,502 $9,336 $9,170 $9,004 $8,838 $8,672 $8,506 $8,340 $8,174 $8,000
Total Assets $132,300 $119,215 $101,720 $82,558 $65,301 $54,083 $42,837 $44,162 $62,446 $65,975 $64,510 $66,150 $85,655
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 $3,000 $7,349 $9,084 $7,145 $8,107 $8,101 $9,063 $8,131 $7,352 $8,313 $9,275 $7,336 $9,264
Current Borrowing $16,000 $15,334 $14,668 $14,002 $13,336 $12,670 $12,004 $16,338 $15,672 $15,006 $14,340 $13,674 $13,008
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $19,000 $22,683 $23,752 $21,147 $21,443 $20,771 $21,067 $24,469 $23,024 $23,319 $23,615 $21,010 $22,272
Long-term Liabilities $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Total Liabilities $64,000 $67,683 $68,752 $66,147 $66,443 $65,771 $66,067 $69,469 $68,024 $68,319 $68,615 $66,010 $67,272
Paid-in Capital $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $101,500 $103,000 $103,000 $103,000 $103,000 $103,000
Retained Earnings ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700) ($31,700)
Earnings $0 ($16,769) ($35,332) ($51,890) ($69,442) ($79,988) ($91,529) ($95,107) ($76,878) ($73,644) ($75,405) ($71,160) ($52,917)
Total Capital $68,300 $51,531 $32,968 $16,410 ($1,142) ($11,688) ($23,229) ($25,307) ($5,578) ($2,344) ($4,105) $140 $18,383
Total Liabilities and Capital $132,300 $119,215 $101,720 $82,558 $65,301 $54,083 $42,837 $44,162 $62,446 $65,975 $64,510 $66,150 $85,655
Net Worth $68,300 $51,531 $32,968 $16,410 ($1,142) ($11,688) ($23,229) ($25,307) ($5,578) ($2,344) ($4,105) $140 $18,383