Question
1. Ratio Analysis for two years for company a. Current ratio b. Quick ratio c. Profit Margin on Sales d. Price-Earnings ratio (you will have
1. Ratio Analysis for two years for company a. Current ratio b. Quick ratio c. Profit Margin on Sales d. Price-Earnings ratio (you will have to google stock price on the balance sheet date) e. Debt to Assets ratio
CONSOLIDATED BALANCE SHEETS - USD ($) $ in Millions Dec. 31, 2018 Dec. 31, 2017 Cash and cash equivalents $ 10,019 $ 8,079 Marketable securities 31,095 33,632 Accounts receivable, net of allowances of $229 and $189 as of December 31, 2018 and 2017, respectively 7,587 5,832 Prepaid expenses and other current assets 1,779 1,020 Total current assets 50,480 48,563 Property and equipment, net 24,683 13,721 Intangible assets, net 1,294 1,884 Goodwill 18,301 18,221 Other assets 2,576 2,135 Total assets 97,334 84,524 Current liabilities: Accounts payable 820 380 Partners payable 541 390 Accrued expenses and other current liabilities 5,509 2,892 Deferred revenue and deposits 147 98 Total current liabilities 7,017 3,760 Other liabilities 6,190 6,417 Total liabilities 13,207 10,177 Commitments and contingencies Stockholders' equity: Common stock, $0.000006 par value; 5,000 million Class A shares authorized, 2,385 million and 2,397 million shares issued and outstanding, as of December 31, 2018 and December 31, 2017, respectively; 4,141 million Class B shares authorized, 469 million and 509 million shares issued and outstanding, as of December 31, 2018 and December 31, 2017, respectively. 0 0 Additional paid-in capital 42,906 40,584 Accumulated other comprehensive loss (760) (227) Retained earnings 41,981 33,990 Total stockholders' equity 84,127 74,347 Total liabilities and stockholders' equity $ 97,334 $ 84,524
This is all I have, so what extra do you need?
Horizontal Analysis Balance sheet USD ($) $ in Millions Increase/Decrease 31.12.2018 31.12.2017 Amount Percentage Assets Current Assets Cash and cash equivalents Marketable securities Accounts receivable, net of allowances Prepaid expenses and other current assets 10019 31095 7587 1779 50480 8079 33632 5832 1020 48563 24.01% -7.54% 30.09% 74.41% 3.95% 2537 1755 1917 Non Current Assets Intangible assets, net Goodwill 31.32% 0.44% 1884 590 18301 18221 80 Tangible Assets Property and equipment, net Other assets Total Assets 24683 2576 97334 13721 10962 79.89% 2135 84524 12810 15.16% 20.66% Liabilities & Equity Current Liabilities Accounts payable Partners payable Accrued expenses and other current liabilities Deferred revenue and deposits Total current liabilities 115.79% 38.72% 90.49% 50.00% 86.62% 380 541 5509 147 7017 390 2617 98 3760 3257 Non Current Liabilities Other liabilities Total liabilities 6147 9907 6190 0.70% 13207 3300 33.31% Stockholders' equity Common stock Class A shares Class B shares 2385 469 12 -0.50% 509 -7.86% Additional paid-in capital 42906 2322 5.72% Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 41981 84127 97334 33990 74347 84254 -533 7991 9780 13080 234.80% 23.51% 13.15% 15.52% Horizontal Analysis Balance sheet USD ($) $ in Millions Increase/Decrease 31.12.2018 31.12.2017 Amount Percentage Assets Current Assets Cash and cash equivalents Marketable securities Accounts receivable, net of allowances Prepaid expenses and other current assets 10019 31095 7587 1779 50480 8079 33632 5832 1020 48563 24.01% -7.54% 30.09% 74.41% 3.95% 2537 1755 1917 Non Current Assets Intangible assets, net Goodwill 31.32% 0.44% 1884 590 18301 18221 80 Tangible Assets Property and equipment, net Other assets Total Assets 24683 2576 97334 13721 10962 79.89% 2135 84524 12810 15.16% 20.66% Liabilities & Equity Current Liabilities Accounts payable Partners payable Accrued expenses and other current liabilities Deferred revenue and deposits Total current liabilities 115.79% 38.72% 90.49% 50.00% 86.62% 380 541 5509 147 7017 390 2617 98 3760 3257 Non Current Liabilities Other liabilities Total liabilities 6147 9907 6190 0.70% 13207 3300 33.31% Stockholders' equity Common stock Class A shares Class B shares 2385 469 12 -0.50% 509 -7.86% Additional paid-in capital 42906 2322 5.72% Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 41981 84127 97334 33990 74347 84254 -533 7991 9780 13080 234.80% 23.51% 13.15% 15.52%
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