Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What does the calculated data from below IMAGE tell us about Dunder Mifflin, Inc.? Provide an analysis that includes comparison to industry averages as well
What does the calculated data from below IMAGE tell us about Dunder Mifflin, Inc.? Provide an analysis that includes comparison to industry averages as well as year to year comparison. Is Dunder Mifflin, Inc. performing better in 2016 compared to 2015? Support your response.
2016 2015 Industry Avg 6.08% 11.79% 6.10% 9.02% 8.94% 16.21% 8.79% 13.14% 5.78% 13.65% 5.90% 10.04% Common Size Balance Sheets Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets 2016 9.3% 0.7% 17.0% 27.1% 54.1% 45.9% 100.0% 2015 11.1% 0.4% 17.0% 25.8% 54.3% 45.7% 100.0% 2.95 61.83 2.19 1.00 2.85 62.99 2.15 0.98 1.95 59.85 2.17 1.05 Ratio Analysis Profitability Ratios Profit Margin Basic Earning Power Return on Assets Return on Equity Asset Management Ratios Inventory Turnover (Total COGS/Inventor Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover Liquidity Ratios Current Ratio Quick Ratio Debt Management Ratios Debt Ratio (Total debt-to-assets) Liabilities-to-assets ratio Times-interest-earned ratio EBITDA coverage ratio Market Value Ratios Earnings per share Price-to-earnings ratio Cash flow per share Price-to-cash flow ratio Book Value per share Market-to-book ratio 3.39 1.69 3.23 1.69 3.25 1.75 22.4% 32.4% 7.25 2.53 22.9% 33.1% 10.34 2.89 23.0% 32.2% 8.75 2.74 Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity 2016 6.4% 3.7% 5.9% 16.0% 16.5% 32.4% 53.7% 13.9% 67.6% 100.0% 2015 6.5% 3.7% 6.6% 16.8% 16.3% 33.1% 53.0% 13.8% 66.9% 100.0% NA $3.81 22.04 $7.62 11.03 $42.24 1.99 $5.51 16.69 $9.19 10.01 $41.97 2.19 18.17 NA 9.54 NA 2.00 ROE = ROE = ROE = Common Size Income Statements Sales COGS except excluding depr. and amort. Depreciation and Amortization Other operating expenses EBIT Interest Expense EBT Taxes (40%) Net Income PM 9.02% 13.14% 2016 100.0% 73.4% 6.1% 8.7% 11.7% 1.6% 10.1% 4.1% 6.1% 2016 2015 2015 100.0% 68.9% 6.0% 8.6% 16.5% 1.6% 14.9% 6.0% 8.9%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started