Wendy Lewis Only*****

I need for you to research The Boston Beer Company, Inc. Then calculate the following an excel spreadsheet. (All works must be shown)

Please graph the below figures using either a Flow chart, Cause and Effect (Fishbone) Diagram, Pareto Chart, Control Charts, Histograms, or Scatter Diagrams. (All work must be shown on excel sheet)

• Calculate the 5-year projected income.

• Calculate a 5-year projected cash flow.

• Calculate net present value (NPV).

• Calculate the internal rate of return (IRR).

• Based on information above, would you recommend acquiring this company? Why or why not?

Also, identify increasing revenues by 8%, each year expenses by 10%, each year tax rate by 25%, and discount rate by 10%