Answered step by step
Verified Expert Solution
Link Copied!

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
* Indicates calendar year-end data information

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Personal Financial Planning

Authors: Lawrence J. Gitman, Michael D. Joehnk

11th Edition

0324422865, 978-0324422863

More Books

Students also viewed these Finance questions

Question

What courses do your students assist with teaching this semester?

Answered: 1 week ago