Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Reseach the last two years of financial statements for Alphabet Inc. http://financials.morningstar.com/ratios/r.html?t=GOOG 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 2015-12 TTM Revenue USD
Reseach the last two years of financial statements for Alphabet Inc.
http://financials.morningstar.com/ratios/r.html?t=GOOG
2006-12 | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | TTM | |
---|---|---|---|---|---|---|---|---|---|---|---|
Revenue USD Mil | 10,605 | 16,594 | 21,796 | 23,651 | 29,321 | 37,905 | 46,039 | 55,519 | 66,001 | 74,989 | 85,537 |
Gross Margin % | 60.2 | 59.9 | 60.4 | 62.6 | 64.5 | 65.2 | 62.7 | 60.4 | 61.1 | 62.4 | 61.8 |
Operating Income USD Mil | 3,550 | 5,084 | 6,632 | 8,312 | 10,381 | 11,742 | 13,834 | 15,403 | 16,496 | 19,360 | 22,457 |
Operating Margin % | 33.5 | 30.6 | 30.4 | 35.1 | 35.4 | 31.0 | 30.0 | 27.7 | 25.0 | 25.8 | 26.3 |
Net Income USD Mil | 3,077 | 4,204 | 4,227 | 6,520 | 8,505 | 9,737 | 10,737 | 12,733 | 14,136 | 16,348 | 19,068 |
Earnings Per Share USD | 4.97 | 6.65 | 6.66 | 10.21 | 13.17 | 14.89 | 16.16 | 18.79 | 20.57 | 22.84 | 27.33 |
Dividends USD | |||||||||||
Payout Ratio % * | |||||||||||
Shares Mil | 618 | 632 | 634 | 638 | 646 | 654 | 665 | 678 | 687 | 693 | 696 |
Book Value Per Share * USD | 145.08 | 169.12 | 194.57 | ||||||||
Operating Cash Flow USD Mil | 3,581 | 5,775 | 7,853 | 9,316 | 11,081 | 14,565 | 16,619 | 18,659 | 22,376 | 26,024 | 32,684 |
Cap Spending USD Mil | -1,903 | -2,403 | -2,358 | -810 | -4,018 | -3,438 | -3,273 | -7,358 | -10,959 | -9,915 | -9,201 |
Free Cash Flow USD Mil | 1,678 | 3,373 | 5,494 | 8,506 | 7,063 | 11,127 | 13,346 | 11,301 | 11,417 | 16,109 | 23,483 |
Free Cash Flow Per Share * USD | 16.92 | 21.15 | |||||||||
Working Capital USD Mil | 11,735 | 15,254 | 17,876 | 26,419 | 31,566 | 43,845 | 46,117 | 56,978 | 63,880 | 70,804 | |
Key Ratios
- Profitability
- Growth
- Cash Flow
- Financial Health
- Efficiency Ratios
Margins % of Sales | 2006-12 | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | TTM |
---|---|---|---|---|---|---|---|---|---|---|---|
Revenue | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 |
COGS | 39.84 | 40.07 | 39.56 | 37.39 | 35.53 | 34.79 | 37.31 | 39.61 | 38.93 | 37.56 | 38.19 |
Gross Margin | 60.16 | 59.93 | 60.44 | 62.61 | 64.47 | 65.21 | 62.69 | 60.39 | 61.07 | 62.44 | 61.81 |
SG&A | 15.10 | 16.52 | 17.20 | 15.44 | 16.24 | 19.29 | 19.43 | 19.79 | 21.18 | 20.25 | 19.38 |
R&D | 11.59 | 12.78 | 12.82 | 12.02 | 12.83 | 13.62 | 13.21 | 12.86 | 14.90 | 16.38 | 16.18 |
Other | 1.32 | ||||||||||
Operating Margin | 33.48 | 30.64 | 30.43 | 35.14 | 35.40 | 30.98 | 30.05 | 27.74 | 24.99 | 25.82 | 26.25 |
Net Int Inc & Other | 4.35 | 3.55 | -3.57 | 0.29 | 1.42 | 1.54 | 1.38 | 0.89 | 1.16 | 0.39 | 0.04 |
EBT Margin | 37.82 | 34.19 | 26.86 | 35.44 | 36.82 | 32.52 | 31.43 | 28.64 | 26.15 | 26.21 | 26.30 |
Profitability | 2006-12 | 2007-12 | 2008-12 | 2009-12 | 2010-12 | 2011-12 | 2012-12 | 2013-12 | 2014-12 | 2015-12 | TTM |
---|---|---|---|---|---|---|---|---|---|---|---|
Tax Rate % | 23.28 | 25.91 | 27.79 | 22.20 | 21.22 | 21.00 | 19.41 | 15.74 | 19.30 | 16.81 | 15.23 |
Net Margin % | 29.02 | 25.33 | 19.39 | 27.57 | 29.01 | 25.69 | 21.40 | 21.60 | 21.88 | 21.10 | 22.29 |
Asset Turnover (Average) | 0.74 | 0.76 | 0.76 | 0.65 | 0.60 | 0.58 | 0.60 | 0.58 | 0.55 | 0.54 | 0.56 |
Return on Assets % | 21.41 | 19.19 | 14.80 | 18.05 | 17.30 | 14.93 | 12.91 | 12.62 | 11.93 | 11.36 | 12.54 |
Financial Leverage (Average) | 1.08 | 1.12 | 1.13 | 1.12 | 1.25 | 1.25 | 1.31 | 1.27 | 1.25 | 1.23 | 1.19 |
Return on Equity % | 23.26 | 21.16 | 16.60 | 20.30 | 20.68 | 18.66 | 16.54 | 16.25 | 15.06 | 14.08 | 15.23 |
Return on Invested Capital % | 20.87 | 19.08 | 15.49 | 19.74 | 18.05 | 15.89 | 14.66 | 14.52 | 13.77 | 12.82 | 14.01 |
Interest Coverage | 213.52 | 160.36 | 175.65 | 171.88 | 189.95 | 193.25 | |||||
Then write a financial analysis that applies financial theories, methods, and analytical tools, including capital structure and financial statement ratio analysis.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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