CONSOLIDATED BALANCE SHEETS (in millions, except par value amounts) ASSETS CURRENT ASSETS Cash and Equivalents Marketable Securities Receivables Inventories Other Current Assets TOTAL CURRENT ASSETS PROPERTY AND EQUIPMENT, NET OTHER ASSETS TOTAL ASSETS CURRENT LIABILITIES: Accounts Payable Other Liabilities and Accrued Expenses Income Taxes Payable TOTAL CURRENT LIABILITIES NONCURRENT LIABILITIES: Long-Term Debt Other Liabilities TOTAL NONCURRENT LIABILITIES STOCKHOLDERS' EQUITY: Class A Common Stock, $0.01 par value: 150,000 shares authorized and 103,300 shares issued Additional Paid-In Capital Retained Earnings Accumulated Other Comprehensive Income (Loss) Treasury Stock, at Average Cost-17,662 and 16,054 at December 31, 2021 and December 31, 2020, respectively TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY LIABILITIES AND STOCKHOLDERS' EQUITY Calculate the following for: Current Ratio Working Capital (in millions) Debt Ratio (as a percent) $ $ $ December 31, 600 23 230 690 575 1,485 2,875 1,235 5,595 $ 805 230 35 2021 1,070 2,300 115 2,415 1 503 2,438 3 (835) 11 2021 $ 2020 $ 315 42 420 840 420 2.037 3,220 474 5,731 ****** 840 315 11 1,166 1,840 420 2,260 2020 D..... 735 2,300 (6) (725) $ $ $ Trend Analysis 2020-2021 $ Change 285 (19) (190) (150) 155 (552) (345) 761 (136) (35) (85) 24 (96) 460 (305) 155 (232) 138 (110) Formulas/Links: n/a n/a n/a % Change 0.00% n/a n/a n/a Common-Size Analysis 2021 2020 (Percent of Total Assets) Formulas/Links Trend Analysis 2020-2021 $ Change % Change n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a Common-Size Analysis 2021 2020 (Percent of Total Assets) n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
CONSOLIDATED BALANCE SHEETS (in millions, except par value amounts) ASSETS CURRENT ASSETS Cash and Equivalents Marketable Securities Receivables Inventories Other Current Assets TOTAL CURRENT ASSETS PROPERTY AND EQUIPMENT, NET OTHER ASSETS TOTAL ASSETS CURRENT LIABILITIES: Accounts Payable Other Liabilities and Accrued Expenses Income Taxes Payable TOTAL CURRENT LIABILITIES NONCURRENT LIABILITIES: Long-Term Debt Other Liabilities TOTAL NONCURRENT LIABILITIES STOCKHOLDERS' EQUITY: Class A Common Stock, $0.01 par value: 150,000 shares authorized and 103,300 shares issued Additional Paid-In Capital Retained Earnings Accumulated Other Comprehensive Income (Loss) Treasury Stock, at Average Cost-17,662 and 16,054 at December 31, 2021 and December 31, 2020, respectively TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY LIABILITIES AND STOCKHOLDERS' EQUITY Calculate the following for: Current Ratio Working Capital (in millions) Debt Ratio (as a percent) $ $ $ December 31, 600 23 230 690 575 1,485 2,875 1,235 5,595 $ 805 230 35 2021 1,070 2,300 115 2,415 1 503 2,438 3 (835) 11 2021 $ 2020 $ 315 42 420 840 420 2.037 3,220 474 5,731 ****** 840 315 11 1,166 1,840 420 2,260 2020 D..... 735 2,300 (6) (725) $ $ $ Trend Analysis 2020-2021 $ Change 285 (19) (190) (150) 155 (552) (345) 761 (136) (35) (85) 24 (96) 460 (305) 155 (232) 138 (110) Formulas/Links: n/a n/a n/a % Change 0.00% n/a n/a n/a Common-Size Analysis 2021 2020 (Percent of Total Assets) Formulas/Links Trend Analysis 2020-2021 $ Change % Change n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a Common-Size Analysis 2021 2020 (Percent of Total Assets) n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:AutoSave OFF
Home Insert
X
Paste
E36
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
A
Ready
D 2 - C
Draw Page Layout
Calibri (Body)
V
11
B
I
U
A.
V
V
B
UDENCRUIVIIVIIL & FRITCITOU.
CONSOLIDATED BALANCE SHEETS
Formulas
V
fx
(In millions, except par value amounts)
ASSETS
CURRENT ASSETS:
Cash and Equivalents
Marketable Securities
Receivables
Inventories
Other Current Assets
TOTAL CURRENT ASSETS
PROPERTY AND EQUIPMENT, NET
OTHER ASSETS
TOTAL ASSETS
CURRENT LIABILITIES:
Accounts Payable
Other Liabilities and Accrued Expenses
Income Taxes Payable
TOTAL CURRENT LIABILITIES
NONCURRENT LIABILITIES:
Long-Term Debt
Other Liabilities
TOTAL NONCURRENT LIABILITIES
STOCKHOLDERS' EQUITY:
Class A Common Stock, $0.01 par value: 150,000
shares authorized and 103,300 shares issued
Additional Paid-In Capital
Retained Earnings
Accumulated Other Comprehensive Income (Loss)
Treasury Stock, at Average Cost - 17,662 and
16,054 at December 31, 2021 and December 31, 2020,
respectively
TOTAL STOCKHOLDERS' EQUITY
TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY
Instructions
LIABILITIES AND STOCKHOLDERS' EQUITY
Α Α΄
Calculate the following for:
Current Ratio
Working Capital (in millions)
Debt Ratio (as a percent)
Income Statements
$
$
$
Data
Review
D
December 31,
600
23
230
690
575
1,485
2,875
1,235
5,595 $
805 $
230
35
1,070
2,300
115
2,415
1
503
2,438
3
(835)
C
2021
$
2021
Balance Sheets
E
ab
2020
315
42
420
840
420
2,037
3,220
474
5,731
840
315
11
1,166
1,840
420
2,260
1
735
2,300
(6)
(725)
2020
View
+
F
$
$
$
ab
Tell me
Wrap Text ✓
Merge & Center ✓
G
H
|
Trend Analysis
2020-2021
% Change
285
(19)
(190)
(150)
155
(552)
(345)
761
(136)
(35)
(85)
24
(96)
$ Change
460
(305)
155
(232)
138
9
(110)
Formulas/Links:
n/a
n/a
n/a
0.00%
XEM3 P✓
Accounting
$
V
J
% 9
.00
✈0
K
L
M
Common-Size Analysis
2021
2020
(Percent of Total Assets)
n/a
n/a
n/a
V
Conditional Format
Formatting as Table
Cell
Styles
P
Q
N
O
Formulas/Links
Trend Analysis
2020-2021
$ Change
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
% Change
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
R
Σ
↓
Format
S
T
U
V
Common-Size Analysis
2021
2020
(Percent of Total Assets)
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
n/a
Insert
Delete
1889
B
1.1.9
>
I
Share
Sort &
Filter
W
O.
Find &
Select
X
Comments
Analyze
Data
Y
100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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