forecasts for the next five years at Mountain Man and do what$-$if scenarios of their future sales revenue and whether or not launching the Mountain Man light beer is a good decision based on financial analysis. For this DQ you need to download the Mountain Man Workbook. Note the formulas are embedded in the worksheets, what you need to do is insert the data found in the case study into the worksheets. Work on the financial analysis worksheet first. The purpose of this worksheet is to let us know if sales continue to decline at $5\%$ per year and we do not launch the light beer, how many years it will take before we just breakeven and from that point on we lose money.

The key worksheet is the projection worksheet. Here you need to enter information on barrels sold, decline rates, cost of goods sold, etc. Note the worksheet I have told you where to find this data. The key here is to determine the net present value $($NPV$)$ of the decision of whether we launch the light beer or nfft$.$ We do not want to make decisions in the future on a gut instinct but based on quantitative analysis based on your projections of what could happen in the future.

Please respond by midnight Wednesday, April $17$th and then respond to two other classmates and comment on their post by midnight Friday, April $19$th$.$ Keep in mind as you finish this you have your quantitative analysis $($appendix$)$ completed for the case study, and you have your recommendation!