Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If I wanted to make an B/S Excel file out of the following data for year 2019 ONLY would I use the exact items and
If I wanted to make an B/S Excel file out of the following data for year 2019 ONLY would I use the exact items and as they are already ordered?
BALANCE SHEETS
(In millions) | |||
June 30, | 2019 | 2018 | |
Assets | |||
Current assets: | |||
Cash and cash equivalents | $11,356 | $11,946 | |
Short-term investments | 122,463 | 121,822 | |
Total cash, cash equivalents, and short-term investments | 133,819 | 133,768 | |
Accounts receivable, net of allowance for doubtful accounts of $411 and $377 | 29,524 | 26,481 | |
Inventories | 2,063 | 2,662 | |
Other | 10,146 | 6,751 | |
Total current assets | 175,552 | 169,662 | |
Property and equipment, net of accumulated depreciation of $35,330 and $29,223 | 36,477 | 29,460 | |
Operating lease right-of-use assets | 7,379 | 6,686 | |
Equity investments | 2,649 | 1,862 | |
Goodwill | 42,026 | 35,683 | |
Intangible assets, net | 7,750 | 8,053 | |
Other long-term assets | 14,723 | 7,442 | |
Total assets | $286,556 | $258,848 | |
Liabilities and stockholders equity | |||
Current liabilities: | |||
Accounts payable | $9,382 | $8,617 | |
Current portion of long-term debt | 5,516 | 3,998 | |
Accrued compensation | 6,830 | 6,103 | |
Short-term income taxes | 5,665 | 2,121 | |
Short-term unearned revenue | 32,676 | 28,905 | |
Other | 9,351 | 8,744 | |
Total current liabilities | 69,420 | 58,488 | |
Long-term debt | 66,662 | 72,242 | |
Long-term income taxes | 29,612 | 30,265 | |
Long-term unearned revenue | 4,530 | 3,815 | |
Deferred income taxes | 233 | 541 | |
Operating lease liabilities | 6,188 | 5,568 | |
Other long-term liabilities | 7,581 | 5,211 | |
Total liabilities | 184,226 | 176,130 | |
Commitments and contingencies | |||
Stockholders equity: | |||
Common stock and paid-in capital shares authorized 24,000; outstanding 7,643 and 7,677 | 78,520 | 71,223 | |
Retained earnings | 24,150 | 13,682 | |
Accumulated other comprehensive loss | (340) | (2,187) | |
Total stockholders equity | 102,330 | 82,718 | |
Total liabilities and stockholders equity | $286,556 | $258,848 |
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