Martin Cove Brewing Company

Start your own business plan »

Microbrewery Business Plan

Appendix

Sales Forecast
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Sales
Microbrews 0% $55,000 $55,000 $60,000 $65,000 $75,000 $85,000 $85,000 $80,000 $80,000 $80,000 $100,000 $70,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $55,000 $55,000 $60,000 $65,000 $75,000 $85,000 $85,000 $80,000 $80,000 $80,000 $100,000 $70,000
Direct Cost of Sales Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Microbrews $16,500 $16,500 $18,000 $19,500 $22,500 $25,500 $25,500 $24,000 $24,000 $24,000 $30,000 $21,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $16,500 $16,500 $18,000 $19,500 $22,500 $25,500 $25,500 $24,000 $24,000 $24,000 $30,000 $21,000
Personnel Plan
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Bottling and Shipping Mgr 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Brewing Mgrs (2) 0% $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Marketing and Sales Mgr 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Bottling Staff 0% $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Shipping Staff 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Total People 11 11 11 11 11 11 11 11 11 11 11 11
Total Payroll $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000
General Assumptions
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
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
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Sales $55,000 $55,000 $60,000 $65,000 $75,000 $85,000 $85,000 $80,000 $80,000 $80,000 $100,000 $70,000
Direct Cost of Sales $16,500 $16,500 $18,000 $19,500 $22,500 $25,500 $25,500 $24,000 $24,000 $24,000 $30,000 $21,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $16,500 $16,500 $18,000 $19,500 $22,500 $25,500 $25,500 $24,000 $24,000 $24,000 $30,000 $21,000
Gross Margin $38,500 $38,500 $42,000 $45,500 $52,500 $59,500 $59,500 $56,000 $56,000 $56,000 $70,000 $49,000
Gross Margin % 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 70.00%
Expenses
Payroll $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000
Sales and Marketing and Other Expenses $5,000 $6,000 $6,000 $5,000 $5,000 $5,000 $5,000 $5,000 $6,000 $5,000 $5,000 $5,000
Depreciation $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Sales Commission $1,650 $1,650 $1,800 $1,950 $2,250 $2,550 $2,550 $2,400 $2,400 $2,400 $3,000 $2,100
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 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Rent $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Payroll Taxes 15% $4,650 $4,650 $4,650 $4,650 $4,650 $4,650 $4,650 $4,650 $4,650 $4,650 $4,650 $4,650
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $46,100 $47,100 $47,250 $46,400 $46,700 $47,000 $47,000 $46,850 $47,850 $46,850 $47,450 $46,550
Profit Before Interest and Taxes ($7,600) ($8,600) ($5,250) ($900) $5,800 $12,500 $12,500 $9,150 $8,150 $9,150 $22,550 $2,450
EBITDA ($6,400) ($7,400) ($4,050) $300 $7,000 $13,700 $13,700 $10,350 $9,350 $10,350 $23,750 $3,650
Interest Expense $331 $328 $325 $322 $319 $317 $314 $311 $308 $305 $303 $300
Taxes Incurred ($2,379) ($2,678) ($1,672) ($367) $1,644 $3,655 $3,656 $2,652 $2,353 $2,653 $6,674 $645
Net Profit ($5,551) ($6,249) ($3,902) ($856) $3,836 $8,528 $8,530 $6,187 $5,489 $6,191 $15,573 $1,505
Net Profit/Sales -10.09% -11.36% -6.50% -1.32% 5.12% 10.03% 10.04% 7.73% 6.86% 7.74% 15.57% 2.15%
Pro Forma Cash Flow
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Cash Received
Cash from Operations
Cash Sales $13,750 $13,750 $15,000 $16,250 $18,750 $21,250 $21,250 $20,000 $20,000 $20,000 $25,000 $17,500
Cash from Receivables $40,000 $41,375 $41,250 $41,375 $45,125 $49,000 $56,500 $63,750 $63,625 $60,000 $60,000 $60,500
Subtotal Cash from Operations $53,750 $55,125 $56,250 $57,625 $63,875 $70,250 $77,750 $83,750 $83,625 $80,000 $85,000 $78,000
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 $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 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $53,750 $55,125 $56,250 $57,625 $63,875 $70,250 $77,750 $83,750 $83,625 $80,000 $85,000 $78,000
Expenditures Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Expenditures from Operations
Cash Spending $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000
Bill Payments $20,883 $26,586 $29,193 $33,418 $35,537 $42,440 $47,462 $44,126 $40,041 $42,287 $42,183 $57,746
Subtotal Spent on Operations $51,883 $57,586 $60,193 $64,418 $66,537 $73,440 $78,462 $75,126 $71,041 $73,287 $73,183 $88,746
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 $335 $335 $335 $335 $335 $335 $335 $335 $335 $335 $335 $335
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 $52,218 $57,921 $60,528 $64,753 $66,872 $73,775 $78,797 $75,461 $71,376 $73,622 $73,518 $89,081
Net Cash Flow $1,532 ($2,796) ($4,278) ($7,128) ($2,997) ($3,525) ($1,047) $8,289 $12,249 $6,378 $11,482 ($11,081)
Cash Balance $81,532 $78,735 $74,457 $67,330 $64,332 $60,807 $59,760 $68,049 $80,298 $86,676 $98,158 $87,077
Pro Forma Balance Sheet
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Assets Starting Balances
Current Assets
Cash $80,000 $81,532 $78,735 $74,457 $67,330 $64,332 $60,807 $59,760 $68,049 $80,298 $86,676 $98,158 $87,077
Accounts Receivable $80,000 $81,250 $81,125 $84,875 $92,250 $103,375 $118,125 $125,375 $121,625 $118,000 $118,000 $133,000 $125,000
Inventory $20,000 $18,150 $18,150 $19,800 $21,450 $24,750 $28,050 $28,050 $26,400 $26,400 $26,400 $33,000 $23,100
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 $185,000 $185,932 $183,010 $184,132 $186,030 $197,457 $211,982 $218,185 $221,074 $229,698 $236,076 $269,158 $240,177
Long-term Assets
Long-term Assets $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Accumulated Depreciation $12,000 $13,200 $14,400 $15,600 $16,800 $18,000 $19,200 $20,400 $21,600 $22,800 $24,000 $25,200 $26,400
Total Long-term Assets $88,000 $86,800 $85,600 $84,400 $83,200 $82,000 $80,800 $79,600 $78,400 $77,200 $76,000 $74,800 $73,600
Total Assets $273,000 $272,732 $268,610 $268,532 $269,230 $279,457 $292,782 $297,785 $299,474 $306,898 $312,076 $343,958 $313,777
Liabilities and Capital Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Current Liabilities
Accounts Payable $20,000 $25,618 $28,081 $32,241 $34,129 $40,855 $45,986 $42,794 $38,631 $40,900 $40,222 $56,866 $25,515
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $20,000 $25,618 $28,081 $32,241 $34,129 $40,855 $45,986 $42,794 $38,631 $40,900 $40,222 $56,866 $25,515
Long-term Liabilities $40,000 $39,665 $39,330 $38,995 $38,660 $38,325 $37,990 $37,655 $37,320 $36,985 $36,650 $36,315 $35,980
Total Liabilities $60,000 $65,283 $67,411 $71,236 $72,789 $79,180 $83,976 $80,449 $75,951 $77,885 $76,872 $93,181 $61,495
Paid-in Capital $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Retained Earnings $109,000 $133,000 $133,000 $133,000 $133,000 $133,000 $133,000 $133,000 $133,000 $133,000 $133,000 $133,000 $133,000
Earnings $24,000 ($5,551) ($11,801) ($15,703) ($16,559) ($12,722) ($4,194) $4,336 $10,524 $16,013 $22,204 $37,777 $39,282
Total Capital $213,000 $207,449 $201,199 $197,297 $196,441 $200,278 $208,806 $217,336 $223,524 $229,013 $235,204 $250,777 $252,282
Total Liabilities and Capital $273,000 $272,732 $268,610 $268,532 $269,230 $279,457 $292,782 $297,785 $299,474 $306,898 $312,076 $343,958 $313,777
Net Worth $213,000 $207,449 $201,199 $197,297 $196,441 $200,278 $208,806 $217,336 $223,524 $229,013 $235,204 $250,777 $252,282