Mountain Man Excel

Only available on StudyMode
  • Download(s) : 373
  • Published : October 23, 2011
Open Document
Text Preview
| | | | | | | | | | | | | | | | | |
Mountain Man Brewing Company | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | |
Financial Projections|  | | | | | | | | | | |
 |  |  |  |  |  |  |  | | | | | | | | | | |  | 2005| 2006| 2007| 2008| 2009| 2010| Assumptions| | | | | | | | | | | Revenues from MM beer| $50,440,000.00| $ 49,431,200.00 | $ 48,442,576.00 | $ 47,473,724.48 | $ 46,524,249.99 | $ 45,593,764.99 | 2% Decrease in Market Size | | | | | | | | | Contribution (Gross Margin)| $ 15,636,400.00 | $15,323,672.00| $15,017,198.56| $14,716,854.59| $14,422,517.50| $14,134,067.15| Exhibit 1| | | | | | | | | | | Loss of Contribution| n.a.| $ 766,183.60 | $ 750,859.93 | $ 735,842.73 | $ 721,125.87 | $ 706,703.36 | 5% Loss due to light beer entry| | | | | | | | Launch Advertising Costs| n.a.| $ 750,000.00 | | | | | Section Challenges Ahead| | | | | | | | | Incremental SG&A expenditures| n.a.| $ 900,000.00 | $ 900,000.00 | $ 900,000.00 | $ 900,000.00 | $ 900,000.00 | Section Challenges Ahead| | | | | | | | | Incremental costs associated with light product| $ 2,416,183.60 | $ 1,650,859.93 | $ 1,635,842.73 | $ 1,621,125.87 | $ 1,606,703.36 | | | | | | | | | | | | | 34803600| $ 34,107,528.00 | $ 33,425,377.44 | $ 32,756,869.89 | $ 32,101,732.49 | $ 31,459,697.84 | COGS 69%| | | | | | | | | | E.C. Light Beer Market| | | | | | | | | | | | | | | | | Assumed market for Light Beer| 18744303| $ 19,494,075.12 | $ 20,273,838.12...
tracking img