Create in excel: common size income statement, trend analysis and proforma for the next three years with the Boston Brewing Company financial summary.

Case 3 Competition in the Craft Brewing Industry in 2017 269 , EXHIBIT 7 Financial Summary for Boston Brewing Company, 2014-2015 (in thousands of $) 2016 2015 2014 Revenue Excise taxes Cost of goods sold Gross profit Advertising, promotional and selling expenses General and administrative expenses Impairment of assets Operating income Interest income Other expense, net Provision for income taxes Net Income $968,994 (62,548) (446,776 459,670 244,213 78,033 (235) 137,659 56 (594) 49,772 $87,349 $1,024,040 64,106) (458,317) 501,617 273,629 71,556 258 156,174 56 (1,220) 56,596 $ 98,414 $966,478 (63,471) (437,996) 465,011 250,696 65,971 1,777 146,567 21 (994) 54,851 $90,743 Source: Boston Beer Company Annual Reports, 2015, 2016 networks. It was the only independent craft brewer A summary of Craft Brew Alliance's financial per Case 3 Competition in the Craft Brewing Industry in 2017 269 , EXHIBIT 7 Financial Summary for Boston Brewing Company, 2014-2015 (in thousands of $) 2016 2015 2014 Revenue Excise taxes Cost of goods sold Gross profit Advertising, promotional and selling expenses General and administrative expenses Impairment of assets Operating income Interest income Other expense, net Provision for income taxes Net Income $968,994 (62,548) (446,776 459,670 244,213 78,033 (235) 137,659 56 (594) 49,772 $87,349 $1,024,040 64,106) (458,317) 501,617 273,629 71,556 258 156,174 56 (1,220) 56,596 $ 98,414 $966,478 (63,471) (437,996) 465,011 250,696 65,971 1,777 146,567 21 (994) 54,851 $90,743 Source: Boston Beer Company Annual Reports, 2015, 2016 networks. It was the only independent craft brewer A summary of Craft Brew Alliance's financial per