Home / Questions / How to convert a balance sheet to a common size balance sheet, including excel formulas

How to convert a balance sheet to a common size balance sheet, including excel formulas

How to convert a balance sheet to a common size balance sheet, including excel formulas

Consolidated Balance Sheet USD ($)
Dec. 31, 2018
$in Millions
Assets
Cash and cash equivalents
$9,342
Time deposits
950
Marketable securities
53
Accounts and notes receivable (less
allowance: 2018 $869; 2017- $490)
15,050
Inventories:
Crude oil and petroleum products
3,383
Chemicals
487
Materials, supplies and other
1,834
Total inventories
5,704
Prepaid expenses and other current
2,922
assets
34,021
Total Current Assets
Long-term receivables, net
1,942
Investments and advances
35,546
340,244
Properties, plant and equipment, at cost
Less: Accumulated depreciation,
depletion and amortization
171,037
Properties, plant and equipment, net
169,207
Deferred charges and other assets
6,766
Goodwill
4,518
Assets held for sale
1,863
253,863
Total Assets
Liabilities and Equity
Short-term debt
5,726
Accounts payable
13,953
Accrued liabilities
4,927
Federal and other taxes on income
1,628
Other taxes payable
937
Total Current Liabilities
27,171
Long-term debt
[1)
28,733
Deferred credits and other noncurrent
19,742
obligations
Noncurrent deferred income taxes
15,921
6,654
Noncurrent employee benefit plans
Total Liabilities
[2]
98,221
Preferred stock (authorized 100,000,000
shares; $1.00 par value; none issued)
0
Common stock (authorized
6,000,000,000 shares; $0.75 par value;
1,832
2,442,676,580 shares issued at
December 31, 2018 and 2017)
Capital in excess of par value
17,112
Retained earnings
180,987
Accumulated other comprehensive
(3,544)
losses
Deferred compensation and benefit plan
(240)
trust
Treasury stock, at cost (2018
539,838,890 shares; 2017-
(41,593)
537,974,695)
Total Chevron Corporation Stockholders
Equity
154,554
1,088
Noncontrolling interests
Total Equity
155,642
Total Liabilities and Equity
253,863

Sep 22 2020 Read more Less More

Answer (Solved)

question Subscribe To Get Solution

Recent Questions

Chat Now

Welcome to Live Chat

Welcome to MyCourseHelp Services, World's leading Academic solutions provider with Millions of Happy Students.

Please fill in the form