Solved by verified expert:Create financial ratio’s from 2011 to 2015 for Boston Beer, Anheser Busch, Molson Coors. Looking for Days of inventory on hand (DOH), Receivable Turnover, Days of Sales outstanding, Payable Turnover, Number of days of payable, Current Ratio, Quick Ratio, Cash Ratio, Defensive Ratio, Solvency Ratio, Dedts to Assets, Dedt to Capital, Dedt to Equity, Financial Leverage, Coverage Ratio, Interest Coverage, Fixed Charge coverage, Profitability Ratio, Pretax Margin, Net Profit Margin, Return on Investment, Operating ROA, ROA, Return on total Capital and Return on common equity. Formulas must be in the excel spreadsheet attached.
ratio_analysis.xlsx
Unformatted Attachment Preview
Boston Beer, Inc
Anheser-Busch InBev NV
2011 2012 2013 2014 2015 2011 2012 2013 2014
Activity Ratio
Inventory Turnover
Days of inventory on hand (DOH)
Receivable Turnover
Days of Sales outstanding
Payable Turnover
Number of days of payable
Liquidity
Current Ratio
Quick Ratio
Cash Ratio
Defensive Ratio
Solvency Ratio
Dedts to Assets
Dedt to Capital
Dedt to Equity
Financial Leverage
Coverage Ratio
Interest Coverage
Fixed Charge coverage
Profitability Ratio
Pretax Margin
Net Profit Margin
Return on Investment
Operating ROA
ROA
Return on total Capital
Return on common equity
3.50
0.72
0.51
141
Busch InBev NV
Molson Coors, LLC
2015 2011 2012 2013 2014 2015
…
Purchase answer to see full
attachment
