Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is your summary of this company?s financial condition? Ratios Price/Earning Ratio Price/Cash flow Ratio Market/Book Value Ratio Return On Asset Return On Equity Yahoo

What is your summary of this company?s financial condition?

image text in transcribed Ratios Price/Earning Ratio Price/Cash flow Ratio Market/Book Value Ratio Return On Asset Return On Equity Yahoo 2012 19.68 0.07 2.91 12.91% 14.97% 2013 20.59 0.10 3.05 12.62% 14.80% 2014 26.05 (1.01) 3.60 11.93% 13.82% 2012 22.3 0.00001 17.76 23.07% 27.10% Yahoo 2013 25.4 (0.00004) 34.50 8.06% 10.45% 2014 28.9 0.0001 23.14 19.10% 19.42% Price Price 2012 323.14 2013 400 Cash flow for the year 2012 4795 Book Value 2012 71715 Market value 2012 208,425.30 Average Assets 2012 83186 2013 4120 2014 556.7 2014 -551 2012 15.54 Cash flow for the year 2012 1105388 2013 24.73 2014 35.95 2013 -590188 2014 590326 2013 13074909 2014 38741837 Book Value 2013 87309 2014 104500 2012 14560200 Market value 2013 266,000.00 2013 102359 2014 376,329.20 2012 258,588,708.00 2013 451,141,971.00 2014 896,603,785.00 2014 121026.5 Average Assets 2012 17103253 2013 16954106 2014 39382651.5 2012 3945479 2013 1366281 2014 7521731 2012 0.2371052632 2013 0.0748946702 2014 0.2550577987 Net Profit EPS 2012 2013 2014 Apple Microsof Verizon Industry Current Ratio 4.2166422543 4.5817199 4.8012496 1.11 2.5 1.06 2.07 Quick Ratio 4.1814187068 4.5549409 4.8012496 0.48 Inventory Turnover 40.859405941 60.699531 n/a 27.71 Days Sales Outstanding 57.359740907 54.190221 51.890047 Fixed Asset Turnover 4.2327484393 3.6204914 2.7635138 Total Asset Turnover 0.5349261178 0.5393527 0.5033134 Facebook Yahoo 2012 2013 2014 Debt Ratio 0.0590311094 0.0472863 0.0399366 Liabilities-to-Assets Ratio 0.2354314591 0.2128651 0.2030991 126.05952381 168.26506 163.32673 Times-Interest-Earned EBITDA Coverage Ratio 195.61904762 223.10843 221.17822 21.40% 21.60% 21.88% Profit Margin 14% 13% 13% Basic Earning Power Twitter 0.58 0.3 2.12 2.12 28.79 26.78 50.03 23.58 18.27 140.19 -23.57 -41.18 INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Research and development Sales, General and administrative Other operating expenses Total operating expenses Operating income Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Net income from discontinuing ops Net income Preferred dividend Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA BALANCE SHEET Fiscal year ends in December. USD in millions except per share data. Assets Current assets Cash Cash and cash equivalents Short-term investments Total cash Receivables Inventories Deferred income taxes Prepaid expenses Other current assets Total current assets Non-current assets Property, plant and equipment Gross property, plant and equipment Accumulated Depreciation Net property, plant and equipment Equity and other investments Goodwill Intangible assets Deferred income taxes Other long-term assets Total non-current assets Total assets Liabilities and stockholders' equity Liabilities Current liabilities Short-term debt Accounts payable Taxes payable Accrued liabilities Deferred revenues Other current liabilities Total current liabilities Non-current liabilities Long-term debt Deferred taxes liabilities Deferred revenues Other long-term liabilities Total non-current liabilities Total liabilities Stockholders' equity Common stock Retained earnings Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 2012-12 2013-12 2014-12 50175 59825 66001 20634 25858 25691 29541 33967 40310 6793 9988 7952 12049 9832 13982 16781 12760 84 710 13386 2598 10788 -51 10737 20001 13966 83 613 14496 2282 12214 706 12920 23814 16496 101 864 17259 3331 13928 516 14444 10737 12920 19.43 19.08 21.37 21.02 645 645 16432 665 677 18518 676 687 22339 Industry 2013-12 2014-12 100.00% 100.00% 100.00% 41.12% 43.22% 38.93% 58.88% 56.78% 61.07% 0.00% 0.00% 0.00% 13.54% 13.29% 14.90% 19.91% 20.14% 21.18% 0.00% 0.00% 0.00% 33.44% 33.43% 36.08% 25.43% 23.34% 24.99% 0.17% 0.14% 0.15% 1.42% 1.02% 1.31% 26.68% 24.23% 26.15% 5.18% 3.81% 5.05% 21.50% 20.42% 21.10% -0.10% 1.18% 0.78% 21.40% 21.60% 21.88% 0.00% 0.00% 0.00% 55.75 14444 16.42 16.17 Common Size Income Statement Fiscal year ends in December. USD in mi2012-12 Revenue Cost of revenue Gross profit Operating expenses Research and development Sales, General and administrative Other operating expenses Total operating expenses Operating income Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Net income from discontinuing ops Net income Net income available to common share 2012-12 2013-12 2014-12 14778 33310 48088 7885 505 1144 2132 700 60454 18898 39819 58717 8882 426 1526 2827 508 72886 18347 46048 64395 9383 17697 -5843 11854 1469 10537 7473 23837 -7313 16524 1976 11492 6066 32746 -8863 23883 3079 15599 4607 1322 3412 2173 80685 2011 1976 3280 33344 38034 50448 93798 110920 131133 2549 2012 240 6968 895 1673 14337 3009 2453 24 7986 1062 1374 15908 2009 1715 96 9455 752 2778 16805 2988 1872 100 2786 7746 22083 2236 1947 139 3381 7703 23611 3228 1971 104 4525 9828 26633 Common Size Balance Sheet Fiscal year ends in December. USD in mi2012-12 Assets Current assets Cash Cash and cash equivalents Short-term investments Total cash Receivables Inventories Deferred income taxes Prepaid expenses Other current assets Total current assets Non-current assets Property, plant and equipment Gross property, plant and equipment Accumulated Depreciation Net property, plant and equipment Equity and other investments Goodwill Intangible assets Deferred income taxes Other long-term assets Total non-current assets Total assets WACC Weight of Debt Cost of Debt (YTM) Tax Rate Cost of Debt After Tax CAGR Risk Free Rate Beta* Cost of Equity Weight of Equity Preferred stock WACC n/a 2013-12 15.76% 35.51% 51.27% 8.41% 0.54% 1.22% 2.27% 0.75% 64.45% 0.00% 0.00% 18.87% -6.23% 12.64% 1.57% 11.23% 7.97% 0.00% 2.14% 35.55% 100.00% 17.04% 35.90% 52.94% 8.01% 0.38% 1.38% 2.55% 0.46% 65.71% 0.00% 0.00% 21.49% -6.59% 14.90% 1.78% 10.36% 5.47% 0.00% 1.78% 34.29% 100.00% 34.49 38.41 25.74 2014-12 13.99% 35.12% 49.11% 7.16% 0.00% 1.01% 2.60% 1.66% 61.53% 0.00% 0.00% 24.97% -6.76% 18.21% 2.35% 11.90% 3.51% 0.00% 2.50% 38.47% 100.00% 2012 2013 2014 0.0716745198 0.0566696 0.0477232 2.74% 2.74% 2.74% 0.1940833707 0.1574227 0.1930008 0.0220821156 0.0230866 0.0221118 11.19 11.5 11.22 2.22% 2.22% 2.22% 0.91 0.91 0.91 10.184898 10.466998 10.212198 0.9283254802 0.9433304 0.9522768 n/a n/a Industry 0.99 9.4564830521 9.875146 9.725895 DuPont Equation 22835 25922 28767 48342 61262 75706 538 125 27 71715 87309 104500 93798 110920 131133 Variable Net income EBT EBIT Sales Total Assets Shareholders' equity Financial Year Industry Avg Description Used on GOOG Financials 2012-12 2013-12 2014-12 Net income 10,737 12,920 14,444 Income before taxes 13,386 14,496 17,259 Operating income 12,760 13,966 16,496 Revenue 50,175 59,825 66,001 Total assets 93,798 110,920 131,133 Total stockholders' equi 71,715 87,309 104,500 ROE Calculation Using the Extended Dupont Method Description Formula Financial Year 2012-12 2013-12 2014-12 Tax Burden Interest Burden Sales Margin Asset Turnover Financial Leverage Return on Equity (Net Income / EBT) (EBT / EBIT) (EBIT / Sales) (Sales / Assets) (Assets / Equity) ROE 80% 1.05 25% 53% 131% 15.0% 89% 1.04 23% 54% 127% 14.8% 84% 1.05 25% 50% 125% 13.8% ROE (Net income / Equity) 15.0% 14.8% 13.8% 25.93 0.49 24.15

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

Entrepreneurial Finance

Authors: Chris LeachJ LeachRonald Melicher

3rd Edition

0324561253, 9780324561258

More Books

Students also viewed these Finance questions

Question

d. Is it part of a concentration, minor, or major program?

Answered: 1 week ago