Answered step by step
Verified Expert Solution
Link Copied!

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

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 Creating Value in a Dynamic Business Environment

Authors: Ronald W. Hilton

9th edition

78110912, 978-0078110917

More Books

Students also viewed these Accounting questions

Question

Using Gauss-Jordan elimination, invert this matrix ONLY 0 0 0 0 1

Answered: 1 week ago

Question

Outline the disadvantages of a learning structure.

Answered: 1 week ago