Martin Cove Brewing Company microbrewery business plan appendix. Martin Cove Brewing is an established producer of hand-crafted lagers, ales, and pilsners. Martin Cove plans on expanding its distribution to larger metro areas, and to larger grocery store chains.

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
Martin Cove Brewing Company microbrewery business plan appendix. Martin Cove Brewing is an established producer of hand-crafted lagers, ales, and pilsners. Martin Cove plans on expanding its distribution to larger metro areas, and to larger grocery store chains.