Need a Financial Analysis of financial statements and key metrics. Something to

Question

Need a Financial Analysis of financial statements and key metrics. Something to that goes over the key metrics of their financial data to put into report.

Growth Profitability and Financial Ratios for Walt Disney Co Financials 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 TTM Revenue USD Mil 37,843 36,149 38,063 40,893 42,278 45,041 48,813 52,465 55,632 55,137 55,137 Gross Margin % 19.7 15.8 17.7 19 44.5 44.4 45.9 45.9 46.1 45 45 Operating Income USD Mil 7,404 5,205 8,863 9,450 11,540 13,224 14,358 13,873 13,873 Operating Margin % 19.6 14.4 21 21 23.6 25.2 25.8 25.2 25.2 Net Income USD Mil 4,427 3,307 3,963 4,807 5,682 6,136 7,501 8,382 9,391 8,980 8,980 Earnings Per Share USD 2.28 1.76 2.03 2.52 3.13 3.38 4.26 4.9 5.73 5.69 5.69 Dividends USD 0.35 0.35 0.35 0.4 0.6 0.75 0.86 1.81 1.42 1.56 1.56 Payout Ratio % * 15.3 19.9 17.2 15.9 19.8 22.7 20.6 37.6 25.4 27.6 27.4 Shares Mil 1,948 1,875 1,948 1,909 1,818 1,813 1,759 1,709 1,639 1,578 1,578 Book Value Per Share * USD 17.73 18.15 19.62 20.14 22.23 24.19 26.78 27.56 27.5 28.35 27.36 Operating Cash Flow USD Mil 5,446 5,064 6,578 6,994 7,966 9,452 9,780 10,909 13,213 12,343 12,343 Cap Spending USD Mil -1,586 -1,753 -2,110 -3,559 -3,784 -2,796 -3,311 -4,265 -4,773 -3,623 -3,623 Free Cash Flow USD Mil 3,860 3,311 4,468 3,435 4,182 6,656 6,469 6,644 8,440 8,720 8,720 Free Cash Flow Per Share * USD 1.98 1.77 2.29 1.8 2.56 3.03 3.48 3.82 4.71 5.4 Working Capital USD Mil 75 2,955 1,225 1,669 896 2,405 1,884 424 124 -3,706 Key Ratios -> Profitability Margins % of Sales 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 TTM Revenue 100 100 100 100 100 100 100 100 100 100 100 COGS 80.33 84.24 82.33 80.97 55.51 55.58 54.12 54.06 53.91 54.96 54.96 Gross Margin 19.67 15.76 17.67 19.03 44.49 44.42 45.88 45.94 46.09 45.04 45.04 SG&A 18.83 18.57 17.55 16.25 15.74 14.83 14.83 R&D Other 0.1 1.36 4.7 4.87 4.69 4.49 4.54 5.05 5.05 Operating Margin 19.57 14.4 20.96 20.98 23.64 25.21 25.81 25.16 25.16 Net Int Inc & Other -0.01 1.25 17.41 19.67 0.94 0.38 1.45 1.23 0.92 -0.15 -0.15 EBT Margin 19.56 15.65 17.41 19.67 21.9 21.36 25.09 26.43 26.73 25.01 25.01 Profitability 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 TTM Tax Rate % 36.11 36.21 34.92 34.63 33.34 31.02 34.64 36.17 34.15 32.07 32.07 Net Margin % 11.7 9.15 10.41 11.76 13.44 13.62 15.37 15.98 16.88 16.29 16.29 Asset Turnover (Average) 0.61 0.58 0.58 0.58 0.58 0.58 0.59 0.61 0.62 0.59 0.59 Return on Assets % 7.17 5.27 5.99 6.8 7.73 7.86 9.07 9.73 10.42 9.56 9.56 Financial Leverage (Average) 1.93 1.87 1.84 1.93 1.88 1.79 1.87 1.98 2.13 2.32 2.32 Return on Equity % 14.04 10.01 11.12 12.84 14.73 14.41 16.6 18.73 21.39 21.23 21.23 Return on Invested Capital % 10.63 8.06 9.03 10.11 11.42 11.14 12.49 13.97 15.41 14.4 14.4 Interest Coverage 13.14 15.53 19.49 20.62 28.56 42.65 53.33 43 28.2 28.2 Key Ratios -> Growth 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 Latest Qtr Revenue % Year over Year 6.57 -4.48 5.29 7.44 3.39 6.54 8.37 7.48 6.04 -0.89 -2.76 3-Year Average 5.81 1.78 2.34 2.62 5.36 5.77 6.08 7.46 7.29 4.14 5-Year Average 6.94 3.29 3.57 3.59 3.55 3.54 6.19 6.63 6.35 5.45 10-Year Average 5.12 4.44 4.13 4.93 5.26 5.23 4.73 5.09 4.96 4.5 Operating Income % Year over Year 9.19 -29.7 24.03 14.59 8.58 -3.38 -8.11 3-Year Average 21.77 -1.8 -1.62 6.33 5-Year Average 22.38 5.49 9.5 17.26 15.42 10-Year Average 6.96 5.54 8.94 11.22 12.42 10.08 7.42 Net Income % Year over Year -5.55 -25.3 19.84 21.3 18.2 7.99 22.25 11.75 12.04 -4.38 3-Year Average 20.46 -0.67 -5.44 2.78 19.77 15.69 15.99 13.84 15.24 6.18 5-Year Average 28.43 7.12 9.36 7.34 3.93 6.75 17.8 16.16 14.33 9.59 10-Year Average 9.12 9.79 15.72 16.48 17.09 12.33 12.71 10.78 6.72 EPS % Year over Year 1.33 -22.81 15.34 24.14 24.21 7.99 26.04 15.02 16.94 -0.7 3.64 3-Year Average 23.18 2.38 -3.37 3.39 21.16 18.52 19.13 16.11 19.24 10.13 5-Year Average 29.75 9.46 10.72 8.97 6.82 8.19 19.34 19.27 17.86 12.7 10-Year Average 9.86 11 13.54 17.96 18.48 14.29 14.92 13.33 9.72 Key Ratios -> Cash Flow Cash Flow Ratios 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 TTM Operating Cash Flow Growth % YOY 0.46 -7.01 29.9 6.32 13.9 18.65 3.47 11.54 21.12 -6.58 Free Cash Flow Growth % YOY 0.13 -14.22 34.94 -23.12 21.75 59.16 -2.81 2.71 27.03 3.32 Cap Ex as a % of Sales 4.19 4.85 5.54 8.7 8.95 6.21 6.78 8.13 8.58 6.57 6.57 Free Cash Flow/Sales % 10.2 9.16 11.74 8.4 9.89 14.78 13.25 12.66 15.17 15.82 15.82 Free Cash Flow/Net Income 0.87 1 1.13 0.71 0.74 1.08 0.86 0.79 0.9 0.97 0.97 Key Ratios -> Financial Health Balance Sheet Items (in %) 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 Latest Qtr Cash & Short-Term Investments 4.8 5.41 3.93 4.42 4.52 4.84 4.06 4.84 5.01 4.19 4.19 Accounts Receivable 8.6 7.69 8.36 8.57 8.73 8.58 9.29 9.09 9.85 9.01 9.01 Inventory 1.8 2.01 2.08 2.21 2.05 1.83 1.87 1.78 1.51 1.43 1.43 Other Current Assets 3.47 3.72 3.29 3.88 3 2.12 2.8 3.29 2.07 1.95 1.95 Total Current Assets 18.67 18.84 17.66 19.07 18.3 17.37 18.03 19 18.43 16.59 16.59 Net PP&E 28.05 27.88 25.73 27.31 28.72 27.55 27.71 28.55 29.72 29.65 29.65 Intangibles 47.96 37.91 42.17 40.58 40.22 42.71 41.95 39.69 37.77 40.11 40.11 Other Long-Term Assets 5.32 15.37 14.44 13.04 12.75 12.38 12.31 12.75 14.08 13.65 13.65 Total Assets 100 100 100 100 100 100 100 100 100 100 100 Accounts Payable 6.97 6.34 6.38 6.3 6.17 6.03 6.38 6.24 7.45 6.78 6.78 Short-Term Debt 5.65 1.91 3.4 4.24 4.83 1.86 2.57 5.17 4.01 6.44 6.44 Taxes Payable Accrued Liabilities 2.6 2.56 2.14 2.04 2.03 2 2.1 2.04 1.9 2.47 2.47 Other Short-Term Liabilities 3.33 3.35 3.98 4.19 4.08 4.51 4.74 5.07 4.94 4.77 4.77 Total Current Liabilities 18.55 14.15 15.89 16.76 17.11 14.41 15.79 18.52 18.3 20.46 20.46 Long-Term Debt 17.78 18.21 14.64 15.14 14.28 15.73 15.06 14.48 17.91 19.96 19.96 Other Long-Term Liabilities 11.96 14.19 15.25 16.26 15.53 13.95 15.75 16.5 16.78 16.45 16.45 Total Liabilities 48.28 46.55 45.79 48.17 46.92 44.08 46.6 49.51 52.99 56.87 56.87 Total Stockholders' Equity 51.72 53.45 54.21 51.83 53.08 55.92 53.4 50.49 47.01 43.13 43.13 Total Liabilities & Equity 100 100 100 100 100 100 100 100 100 100 100 Liquidity/Financial Health 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 Latest Qtr Current Ratio 1.01 1.33 1.11 1.14 1.07 1.21 1.14 1.03 1.01 0.81 0.81 Quick Ratio 0.72 0.93 0.77 0.77 0.77 0.93 0.85 0.75 0.81 0.65 0.65 Financial Leverage 1.93 1.87 1.84 1.93 1.88 1.79 1.87 1.98 2.13 2.32 2.32 Debt/Equity 0.34 0.35 0.28 0.3 0.28 0.29 0.28 0.29 0.38 0.46 0.46 Key Ratios -> Efficiency Ratios Efficiency 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 2015-09 2016-09 2017-09 TTM Days Sales Outstanding 50.18 51.63 51.01 52.35 52.92 52.7 52.8 52.32 52.72 53.9 53.9 Days Inventory 10.58 14.35 15.8 16.74 17.11 15.51 21.14 20.24 18.01 16.64 16.64 Payables Period 50.07 50.08 49.01 49.38 50.06 48.81 70.94 69.97 75.23 80.39 80.39 Cash Conversion Cycle 10.69 15.9 17.8 19.71 19.97 19.4 3 2.58 -4.49 -9.85 -9.85 Receivables Turnover 7.27 7.07 7.15 6.97 6.9 6.93 6.91 6.98 6.92 6.77 6.77 Inventory Turnover 34.49 25.43 23.1 21.81 21.34 23.54 17.26 18.04 20.26 21.94 21.94 Fixed Assets Turnover 2.16 2.06 2.15 2.18 2.05 2.05 2.14 2.16 2.12 1.98 1.98 Asset Turnover 0.61 0.58 0.58 0.58 0.58 0.58 0.59 0.61 0.62 0.59 0.59

Explanation / Answer

1. Revenue is growing consistently since 2010-09. The figures went down in year 2009-09 from the 2008-09 figures but since then, there have been no looking back. The growth rate has also increased with every passing year.

2. Gross margin is inconsistent and fluctuating over the ten year period. Since the last six years it's been in the range of 44-46%

3. Operating income position is also very inconsistent. There was no income in the 3rd and 4th year of the 10 year period. Operating income has grown from 5th year onwards but current year figure shows less income compared to past year.

4. The financial figures, growth and profitability ratios, the efficiency ratios all show average performance. Consistency is lacking everywhere. The company appears non standard.

Overall the financial health of the company is just okay. Its not too good to rave about neither too bad to worry about. The company needs to work on its inconsistency. Standards of performance needs to improve. Current year efficiency figures for asset turnover, fixed asset turnover, receivables turnover, payables period and DSO all show a decline from past year. The same goes with financial health ratios. Hence the company needs to pay immediate attention to areas where it is lacking or it will have to suffer dire consequences in upcoming years.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.