Excel Corporation BALANCE SHEETS (In millions) June 30, Assets 2019 2018 2017 2019 2018 2017 Current assets: Cash and cash equivalents $ 11,356 $ 11,946 $ 7,663 ? ? ? Short-term investments $ 122,463 $ 121,822 $ 125,318? ? ? Accounts receivable, net of allowance for doubtful accounts of $411 and $377 $ 29,524 $ 26,481 $ 22,431 ? ? ? Inventories $ 2,063 $ 2,662 $ 2,181 ? ? ? Other $ 10,146 $ 6,751 $ 5,103 ? ? ? Total current assets $ 175,552 $ 169,662 $ 162,696 ? ? ? Property and equipment, net of accumulated depreciation of $35,330 and $29,223 $ 36,477 $ 29,460 $ 23,734 ? ? ? Operating lease right-of-use assets $ 7,379 $ 6,686 $ 6,555 ? ? ? Equity investments $ 2,649 $ 1,862 $ 6,023 ? ? ? Goodwill $ 42,026 $ 35,683 $ 35,122 ? ? ? Intangible assets, net $ 7,750 $ 8,053 $ 10,106 ? ? ? Other long-term assets Total assets Liabilities and stockholders' equity $ 14,723 $ 7,442 $ 6,076 ? ? ? $ 286,556 $ 258,848 $ 250,312 ? ? ? Current liabilities: Accounts payable Short Term Debt Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes $ 9,382 $ 8,617 $ 7,390 ? ? ? $ $ $ 9,072 ? ? ? $ 5,516 $ 3,998 $ 1,049 ? ? ? $ 6,830 $ 6,103 $ 5,819 ? ? ? $ 5,665 $ 2,121 $ 718? ? ? $ 32,676 $ 28,905 $ 24,013 ? ? ? $ 9,351 $ 8,744 $ 7,684 ? ? ? $ 69,420 $ 58,488 $ 55,745 ? ? ? $ 66,662 $ 72,242 $ 76,073 ? ? ? $ 29,612 $ 30,265 $ 13,485 ? ? ? $ 4,530 $ 3,815 $ 2,643 ? ? ? $ 233 $ 541 $ 5,734 ? ? ? $ 6,188 $ 5,568 $ 5,372 ? ? ? $ 7,581 $ 5,211 $ 3,549 ? ? ? $ 184,226 $ 176,130 $ 162,601 ? ? ? Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity: Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 a $ 78,520 $ 71,223 $ 69,315 ? ? ? Retained earnings $ 24,150 $ 13,682 $ 17,769 ? ? ? Accumulated other comprehensive loss $ (340) $ (2,187) $ 627? ? ? Total stockholders' equity $ 102,330 $ 82,718 $ 87,7112 ? ? Total liabilities and stockholders' equity $ 286,556 $ 258,848 $ 250,312 ? ? ?
Excel Corporation BALANCE SHEETS (In millions) June 30, Assets 2019 2018 2017 2019 2018 2017 Current assets: Cash and cash equivalents $ 11,356 $ 11,946 $ 7,663 ? ? ? Short-term investments $ 122,463 $ 121,822 $ 125,318? ? ? Accounts receivable, net of allowance for doubtful accounts of $411 and $377 $ 29,524 $ 26,481 $ 22,431 ? ? ? Inventories $ 2,063 $ 2,662 $ 2,181 ? ? ? Other $ 10,146 $ 6,751 $ 5,103 ? ? ? Total current assets $ 175,552 $ 169,662 $ 162,696 ? ? ? Property and equipment, net of accumulated depreciation of $35,330 and $29,223 $ 36,477 $ 29,460 $ 23,734 ? ? ? Operating lease right-of-use assets $ 7,379 $ 6,686 $ 6,555 ? ? ? Equity investments $ 2,649 $ 1,862 $ 6,023 ? ? ? Goodwill $ 42,026 $ 35,683 $ 35,122 ? ? ? Intangible assets, net $ 7,750 $ 8,053 $ 10,106 ? ? ? Other long-term assets Total assets Liabilities and stockholders' equity $ 14,723 $ 7,442 $ 6,076 ? ? ? $ 286,556 $ 258,848 $ 250,312 ? ? ? Current liabilities: Accounts payable Short Term Debt Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes $ 9,382 $ 8,617 $ 7,390 ? ? ? $ $ $ 9,072 ? ? ? $ 5,516 $ 3,998 $ 1,049 ? ? ? $ 6,830 $ 6,103 $ 5,819 ? ? ? $ 5,665 $ 2,121 $ 718? ? ? $ 32,676 $ 28,905 $ 24,013 ? ? ? $ 9,351 $ 8,744 $ 7,684 ? ? ? $ 69,420 $ 58,488 $ 55,745 ? ? ? $ 66,662 $ 72,242 $ 76,073 ? ? ? $ 29,612 $ 30,265 $ 13,485 ? ? ? $ 4,530 $ 3,815 $ 2,643 ? ? ? $ 233 $ 541 $ 5,734 ? ? ? $ 6,188 $ 5,568 $ 5,372 ? ? ? $ 7,581 $ 5,211 $ 3,549 ? ? ? $ 184,226 $ 176,130 $ 162,601 ? ? ? Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity: Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 a $ 78,520 $ 71,223 $ 69,315 ? ? ? Retained earnings $ 24,150 $ 13,682 $ 17,769 ? ? ? Accumulated other comprehensive loss $ (340) $ (2,187) $ 627? ? ? Total stockholders' equity $ 102,330 $ 82,718 $ 87,7112 ? ? Total liabilities and stockholders' equity $ 286,556 $ 258,848 $ 250,312 ? ? ?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Find the Common Size and Trend Analysis for three years for the
Transcribed Image Text:Excel Corporation
BALANCE SHEETS
(In millions)
June 30,
Assets
2019
2018
2017
2019
2018
2017
Current assets:
Cash and cash equivalents
$
11,356 $
11,946 $
7,663 ?
?
?
Short-term investments
$
122,463 $
121,822 $
125,318?
?
?
Accounts receivable, net of allowance for doubtful accounts of $411 and $377
$
29,524 $
26,481 $
22,431 ?
?
?
Inventories
$
2,063 $
2,662 $
2,181 ?
?
?
Other
$
10,146 $
6,751 $
5,103 ?
?
?
Total current assets
$
175,552 $
169,662 $
162,696 ?
?
?
Property and equipment, net of accumulated depreciation of $35,330 and $29,223
$
36,477 $
29,460 $
23,734 ?
?
?
Operating lease right-of-use assets
$
7,379 $
6,686 $
6,555 ?
?
?
Equity investments
$
2,649 $
1,862 $
6,023 ?
?
?
Goodwill
$
42,026 $
35,683 $
35,122 ?
?
?
Intangible assets, net
$
7,750 $
8,053 $
10,106 ?
?
?
Other long-term assets
Total assets
Liabilities and stockholders' equity
$
14,723 $
7,442 $
6,076 ?
?
?
$
286,556 $
258,848 $
250,312 ?
?
?
Current liabilities:
Accounts payable
Short Term Debt
Current portion of long-term debt
Accrued compensation
Short-term income taxes
Short-term unearned revenue
Other
Total current liabilities
Long-term debt
Long-term income taxes
Long-term unearned revenue
Deferred income taxes
$
9,382 $
8,617 $
7,390 ?
?
?
$
$
$
9,072 ?
?
?
$
5,516 $
3,998 $
1,049 ?
?
?
$
6,830 $
6,103 $
5,819 ?
?
?
$
5,665 $
2,121 $
718?
?
?
$
32,676 $
28,905 $
24,013 ?
?
?
$
9,351 $
8,744 $
7,684 ?
?
?
$
69,420 $
58,488 $
55,745 ?
?
?
$
66,662 $
72,242 $
76,073 ?
?
?
$
29,612 $
30,265 $
13,485 ?
?
?
$
4,530 $
3,815 $
2,643 ?
?
?
$
233 $
541 $
5,734 ?
?
?
$
6,188 $
5,568 $
5,372 ?
?
?
$
7,581 $
5,211 $
3,549 ?
?
?
$
184,226 $
176,130 $
162,601 ?
?
?
Operating lease liabilities
Other long-term liabilities
Total liabilities
Commitments and contingencies
Stockholders' equity:
Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 a $
78,520 $
71,223 $
69,315 ?
?
?
Retained earnings
$
24,150 $
13,682 $
17,769 ?
?
?
Accumulated other comprehensive loss
$
(340) $
(2,187) $
627?
?
?
Total stockholders' equity
$
102,330 $
82,718 $
87,7112
?
?
Total liabilities and stockholders' equity
$
286,556 $
258,848 $
250,312 ?
?
?
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education