Solved by verified expert:Gather the data of financial statements from 2011 to 2015 and calculate DuPont, Valuation Ratios, Per Share Quantities, Dividend Related Quantities using the attached spreadsheet. Please show math in cell no hard numbers. Reference international financial statement analysis third edition exhibit 17 (page 339) and exhibit 18 (page 341)
mod5_assign1.xlsx
Unformatted Attachment Preview
2011 2012
Return on Equity
(net income/Average
sharholder equity)
Return on Assets
(net income/average total
assets)
Leverage
(Average total assets /
Average shareholder
equity)
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Net Profit Margin
(net Income/Revenue)
Anheser-Busch InBev NV
Molson Coors, LLC
DuPoint
Analysis
Total Asset Turnover
(revenues/average total
asset)
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Tax Burden
(net Income/EBT)
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Interest Burden
(EBT/EBIT)
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
EBIT Margin
(EBIT/revenues)
EBIT Margin
(EBIT/revenues)
Anheser-Busch InBev NV
Molson Coors, LLC
P/E
(Price per share/Earnings
per share)
P/CF
(price per share /
Cashflow per share)
Valuation
Ratio
P/S
(preice per share/Sales
per share)
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
P/BV (price per share /
Book value per share)
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Basic EPS
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Diluted EPS
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Per-Share
Quantities
Cash flow per share
Anheser-Busch InBev NV
Molson Coors, LLC
Per-Share
Quantities
Boston Beer, Inc
EBITDA per share
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Dividends per share
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Dividend Payout Ratio
Anheser-Busch InBev NV
Molson Coors, LLC
DividenRelated
Quantities
Boston Beer, Inc
Retention Rate
Anheser-Busch InBev NV
Molson Coors, LLC
Boston Beer, Inc
Sustianable Growth
Anheser-Busch InBev NV
Molson Coors, LLC
2013 2014 2015
Dashboard
1,5
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
1,0
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,5
Boston Beer, Inc
Anheser-Busch InBev NV
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
1,5
2012
Boston Beer, Inc
2013
2014
Anheser-Busch InBev NV
2015
Molson Coors, LLC
1,0
0,5
0,0
2011
2012
2013
2014
2015
…
Purchase answer to see full
attachment
