Marrowstone Advertising advertising consulting business plan appendix. Marrowstone Advertising Consultants will provide comprehensive marketing consultation and produce of advertising campaigns for the nonprofit industry.

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
Marrowstone Advertising advertising consulting business plan appendix. Marrowstone Advertising Consultants will provide comprehensive marketing consultation and produce of advertising campaigns for the nonprofit industry.