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%