Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

These are three screenshots for the alphabet company income statement, balance sheet, cash flow statement. calculate the following: Gross Profit, Operating Profit, Net Income and

image text in transcribedimage text in transcribedimage text in transcribed

These are three screenshots for the alphabet company income statement, balance sheet, cash flow statement. calculate the following:

Gross Profit, Operating Profit, Net Income and Free Cash Flow (FCF), Cash Coverage Ratio, Current Ratio, Quick ratio, Total debt ratio, Debt-equity ratio, Total asset turnover

Alphabet Inc. Consolidated Income Statement Dec 31, 2016 90,272 (35,138) 55,134 (13,948) (10,485) (6,985) Dec 31, 2015 74,989 (28,164) 46,825 (12,282) (9,047) (6,136) US$ in millions 12 months ended: Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Revenues 161,857 136,819 110,855 Cost of revenues (71,896) (59,549) (45,583) Gross profit 89,961 77,270 65,272 Research and development (26,018) (21,419) (16,625) Sales and marketing (18,464) (16,333) (12,893) General and administrative (9,551) (8,126) (6,872) European Commission fines (1,697) (5,071) (2,736) Income from operations 34,231 26,321 26,146 Interest income 2,427 1,878 1,312 Interest expense (100) (114) (109) Foreign currency exchange gain (loss), net 103 (80) (121) Gain (loss) on debt securities, net 149 1,190 (110) Gain (loss) on equity securities, net 2,649 5,460 73 Performance fees (326) Gain (loss) and impairment from equity method investments, net 390 (120) (156) Other 102 378 158 Other income (expense), net 5,394 8,592 1,047 Income before income taxes 39,625 34,913 27,193 Provision for income taxes (5,282) (4,177) (14,531) Net income 34,343 30,736 12,662 Adjustment Payment to Class C capital stockholders Net income available to all stockholders 34,343 30,736 12,662 Based on:10-K (filing date: 2020-02-04),10-K (filing date: 2019-02-05),10-K (filing date: 2018-02-06),10-K (filing date: 2017-02-03),10-K (filing date: 2016-02-11). 23,716 1,220 (124) (475) (53) (20) 19,360 999 (104) (422) (202) 88 434 24,150 (4,672) 19,478 (182) 291 19,651 (3,303) 16,348 (522) 15,826 19,478 2019 2018 2017 2016 2015 Alphabet Inc. Consolidated Balance Sheet: Assets December 31, 2016 12918 73415 86333 14137 December 31, 2015 16549 56517 73066 11556 450 0 95 1903 268 491 US$ in millions December 31, 2019 December 31, 2018 December 31, 2017 Cash and cash equivalents 18498 16701 10715 Marketable securities 101177 92439 91156 Cash, cash equivalents, and marketable securities 119675 109140 101871 Accounts receivable, net of allowance 25326 20838 18336 Receivable under reverse repurchase agreements 0 0 0 Income taxes receivable, net 2166 355 369 Inventory 999 1107 749 Other current assets 4412 4236 2983 Current assets 152578 135676 124308 Non-marketable investments 13078 13859 7813 Deferred income taxes 721 737 680 Property and equipment, net 73646 59719 42383 Operating lease assets 10941 0 0 Intangible assets, net 1979 2220 2692 Goodwill 20624 17888 16747 Other non-current assets 2342 2693 2672 Non-current assets 123331 97116 72987 Total assets 275909 232792 197295 Based on:10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05),10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03),10-K (filing date: 2016-02-11). 2648 90114 4575 105408 5878 383 5183 251 29016 0 34234 3307 3847 15869 3181 16468 1819 62089 167497 57347 147461 Alphabet Inc. Consolidated Income Statement Dec 31, 2016 90,272 (35,138) 55,134 (13,948) (10,485) (6,985) Dec 31, 2015 74,989 (28,164) 46,825 (12,282) (9,047) (6,136) US$ in millions 12 months ended: Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Revenues 161,857 136,819 110,855 Cost of revenues (71,896) (59,549) (45,583) Gross profit 89,961 77,270 65,272 Research and development (26,018) (21,419) (16,625) Sales and marketing (18,464) (16,333) (12,893) General and administrative (9,551) (8,126) (6,872) European Commission fines (1,697) (5,071) (2,736) Income from operations 34,231 26,321 26,146 Interest income 2,427 1,878 1,312 Interest expense (100) (114) (109) Foreign currency exchange gain (loss), net 103 (80) (121) Gain (loss) on debt securities, net 149 1,190 (110) Gain (loss) on equity securities, net 2,649 5,460 73 Performance fees (326) Gain (loss) and impairment from equity method investments, net 390 (120) (156) Other 102 378 158 Other income (expense), net 5,394 8,592 1,047 Income before income taxes 39,625 34,913 27,193 Provision for income taxes (5,282) (4,177) (14,531) Net income 34,343 30,736 12,662 Adjustment Payment to Class C capital stockholders Net income available to all stockholders 34,343 30,736 12,662 Based on:10-K (filing date: 2020-02-04),10-K (filing date: 2019-02-05),10-K (filing date: 2018-02-06),10-K (filing date: 2017-02-03),10-K (filing date: 2016-02-11). 23,716 1,220 (124) (475) (53) (20) 19,360 999 (104) (422) (202) 88 434 24,150 (4,672) 19,478 (182) 291 19,651 (3,303) 16,348 (522) 15,826 19,478 2019 2018 2017 2016 2015 Alphabet Inc. Consolidated Balance Sheet: Assets December 31, 2016 12918 73415 86333 14137 December 31, 2015 16549 56517 73066 11556 450 0 95 1903 268 491 US$ in millions December 31, 2019 December 31, 2018 December 31, 2017 Cash and cash equivalents 18498 16701 10715 Marketable securities 101177 92439 91156 Cash, cash equivalents, and marketable securities 119675 109140 101871 Accounts receivable, net of allowance 25326 20838 18336 Receivable under reverse repurchase agreements 0 0 0 Income taxes receivable, net 2166 355 369 Inventory 999 1107 749 Other current assets 4412 4236 2983 Current assets 152578 135676 124308 Non-marketable investments 13078 13859 7813 Deferred income taxes 721 737 680 Property and equipment, net 73646 59719 42383 Operating lease assets 10941 0 0 Intangible assets, net 1979 2220 2692 Goodwill 20624 17888 16747 Other non-current assets 2342 2693 2672 Non-current assets 123331 97116 72987 Total assets 275909 232792 197295 Based on:10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05),10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03),10-K (filing date: 2016-02-11). 2648 90114 4575 105408 5878 383 5183 251 29016 0 34234 3307 3847 15869 3181 16468 1819 62089 167497 57347 147461

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

Managerial Accounting

Authors: Stacey Whitecotton, Robert Libby, Fred Phillips

2nd edition

9780077493677, 78025516, 77493672, 9780077826482, 978-0078025518

Students also viewed these Finance questions