Financial Data & Projections
Break-Even Analysis and Scenario
Gross Sales $1,554,960.00
Gross Profit $ 917,576.00
Gross Profit Margin 73.56%
Total Fixed Costs $ 824,284.00
Break Even $ 1,083,271.00
Cash Remainder $ 135,691.00
Controllable Expenses:
Salaries & Wages $ 370,032.00
Employee Benefits $ 69,649.00
Operating Expenses $ 74,000.00
Marketing $ 25,000.00
Energy & Utility Expenses $ 18,500.00
Administrative Expenses $ 51,500.00
Repair & Maintenance $ 7,500.00
Other $ –
Total Expenses $ 616,181.00
Occupation Costs $ 161,000.00
Interest & Principal $ 37,748.00
Capital Improvements $ 9,355.00
Total Fixed Costs $ 824,284.00
Sources of Capital and Debt
B k Ale House and Brewery
TOTAL START-UP CAPITAL $300,000.00
Loans & Notes $100,000.00
Stock sales $ –
Partnerships $200,000.00
Loans & Notes
Amount Rate Term Source
#1 $100,000.00 10% 5.00 Friends
#2
#3
#4
#5
Partnership Information
Number of partners 2
Amount paid by each partner $100,000.00
Total Capital $300,000.00
% of profits for general partners 50%
% Of profits for limited partners (group) 50%
Interest on principal amounts 10%
TOTAL YEARLY INTEREST $30,000.00
Start-up CostsB k Ale House and Brewery
TOTAL START-UP CAPITAL $300,000.00
Amount Expense Depreciation Amortization Amort Lshld. Balance Sheet
Security Deposit 10,000.00 10,000.00
Construction Rent 10,000.00 10,000.00
Construction Utilities 2,000.00 2,000.00
Liquor License 2,000.00 2,000.00
Yearly License Fees 3,000.00 3,000.00
Utility Deposits 2,300.00 2,300.00
Insurance-Prepaid 2,500.00 2,500.00
Advertising & Promotion 25,000.00 25,000.00
Graphics & Printing 5,000.00 5,000.00
Architects/Decorators 10,000.00 10,000.00
Bank Note Payment
Other Note
Legal & Accounting 3,000.00 3,000.00
Inventory 10,000.00 10,000.00
Uniforms 2,000.00 2,000.00
Contractor Fees
Cash Reserve 80,700.00 80,700.00
Furniture, Equipment 60,000.00 60,000.00
Leasehold Improvements 40,000.00 40,000.00
Payroll, training 5,000.00 5,000.00
Consultants 15,000.00 15,000.00
Research & Development 2,500.00 2,500.00
Landscaping
Debt Consolidation
Employment Agency Fees 10,000.00
Other 10,000.00
TOTALS $300,000 $60,000.00 $92,500.00 $40,000.00 $107,500.00
References
(1999). All that glitters is gold. Tinsiltown online [On-line]. Available http://www.tinsiltown.com/restaurants/microbreweries.htm (1999, August 10).
(1999). Anderson valley brewing. Anderson valley brewing company online [On-line]. Available http://www.avdc.com (1999, August 15).
(1999). Beer institute report. Beer institute online [On-line]. Available http://www.beerinst.org.report/slide1.html (1999, August 13).
(1999). Brewery diagram. John harvard’s brew house [On-line]. Available http://www.johnharvards.com/process/brewery.html (1999, August 13).
Canegie, J. (1997, June). Microbrewy business in North Carolina. North Carolina Times Union, p. MMETROB6.
Carilli, J. (1999, April 26). Craft-brewing industry fact sheet. Institute for brewing studies news and stats [On-line]. Available http://www.aob.org (1999, August 10).
(1999, April 6). Craft brewing industry repeat sales of 5.6 million barrels in 1998. Institute for brewing studies – news and stats [On-line]. Available http://www.aob.org.
(1999). Drinking less, drinking better. Restaurant report [On-line]. Available http://www.restaurantreport.com.
(1999). The history of beer. Beer history online [On-line]. Available http://www.showlearn.com/beer/bhistory.htm (1999, August 13).
(1999). Let’s go to the bop. All about beer [On-line]. Available http://allaboutbeer.com/features/bop.html (1999, August 9).
(1999). Sole proprietorship overview. Getting started – legal structure [On-line]. Available http://www.businesstown.com/gettingstarted/structure-sole.asp (1999, July 25).
(1999). Startup kits – your customers. Entrepreneur magazine – online [On-line]. Available http://www.entrepreneurmag.com/resource/toolkit/microbrew3.hts (1999, July 28).
Wauldron, J. (1999). The bad frog story – it all started with a t-shirt. Bad frog international [On-line]. Available http://www.badgrog.com/about.html.