Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

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

Auditor Going Concern Reporting A Review Of Global Research And Future Research Opportunities

Authors: Marshall A. Geiger, Anna Gold, Philip Wallage

1st Edition

0367649489, 978-0367649487

More Books

Students also viewed these Accounting questions

Question

5. Have you stressed the topics relevance to your audience?

Answered: 1 week ago