Martin Cove Brewing Company
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 |