Our biggest savings of the year
Marrowstone Advertising
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 |