Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

9th Edition

9780073530703

Students also viewed these Finance questions