FINANCE MARKET HOMEWORK HELP.

case3_mountain_man_2014.xlsx

Contribution MM Light

	Contribution per Barrel of MM Light
MMBC revenue in 2005		Exhibit 1
MMBC barrel production in 2005		Section MM The Company and the Brand
Revenue per barrel
Variable cost per barrel		Section Challenges Ahead
Contribution per barrel of MM Lager
Additional costof light beer per barrel		Section Challenges Ahead
Contribution per barrel of MM Light

Mountain Man Brewing Company
Financial Projections
	2005	2006	2007	2008	2009	2010	Assumptions
Revenues from MM beer	$50,440,000.00 Cecilia Alvarez: Cecilia Alvarez: Exhibit 1						2% Decrease in Market Size
Contribution (Gross Margin)	$ 15,636,400.00 Cecilia Alvarez: Cecilia Alvarez: Exhibit 1						Exhibit 1
Loss of Contribution	n.a.						5% Loss due to light beer entry
Launch Advertising Costs	n.a.						Section Challenges Ahead
Incremental SG&A expenditures	n.a.						Section Challenges Ahead
Incremental costs associated with light product
E.C. Light Beer Market
Assumed market for Light Beer	18744303 Cecilia Alvarez: Cecilia Alvarez: Exhibit 5	Cecilia Alvarez: Cecilia Alvarez: Exhibit 1	Cecilia Alvarez: Cecilia Alvarez: Exhibit 1					4% Market Growth
Market Share for Mountain Man Light	n.a.						From section Chris's Decision.
Barrels Sold of Mountain Man Light	n.a.
Contribution of Light Product	n.a.						Hint: Get the contribution per barrel of Mountain Man Light In the first work sheet Cecilia Alvarez: Cecilia Alvarez: Get contribution per barrel of MM substract additional costs to get contribution of MML
Net Change in Contribution	n.a.
Discount Factor							12% (Footnote #6)
Present Value
5 Year NPV (2006-2010)