Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Income Statements Tab and Balance Sheets Tab a. Enter information in the blue and yellow cells only. b. DON'T add or delete any rows
2. Income Statements Tab and Balance Sheets Tab a. Enter information in the blue and yellow cells only. b. DON'T add or delete any rows or columns and DON'T round as doing so will result in a zero. c. Complete everything in yellow highlight following the instructions in red; your score will be based on your input in these yellow cells You MUST use cell references and formulas for all amounts when applicable; there should be very few typed or hard-coded numbers Subtotals and Totals - Contiguous amounts: You MUST use the SUM function and reference the cells being added using a colon between the first and last cel UAERCRAMMEF \& EntTrHen Sales prices increased and unit costs of inventory decreased Sales prices decreased and unit costs of inventory increased Sales quantity increased and goods sold decreased Sales quantity decreased and goods sold increased Two of more of these are possible explanations None of these are possible explanations CONSOLIDATED BALANCE SHEETS (in millions, except par value amounts) ASSETS CURRENTASSETS: Cash and Equivalents Marketable Securities Receivables Inventories Other Current Assets TOTAL CURAENT ASSETS PROPERTY AND EQUIPMENT, NET OTHER ASSETS TOTAL ASSETS LAFHITIS AND STOCEHCLOERS' EQUITY CURRENTLAAILTIES: Accounts Payable Other Labilities and Accrued Expenses Income Taxes Payable TOTA CURRENT LABIIIES NONCURRENT LABIUTES: lang-Term Debt other Liabilities TOTA NONCURAENT LABILInES STOCKHCLOERS' EQUITY: Class A Commen Steck, $0.01 par value: 150,000 shares authorized and 203,300 shares iswed Additional Paid-in Capital Retained Earnings Accumulated Other Comprehensive income [losv) Treasury Stock, at Average Cost 17,662 and 16,054 at December 31, 2021 and December 31,2020 , respectively TOTAL STOCKHOLDERS' EQUITY TOTAL LABIUTES ANO STOCKHOLDERS' EQUITY \begin{tabular}{rrr} $398 & 5 & 864 \\ 228 & & 324 \\ 34 & & 11 \\ \cline { 3 - 3 } \cline { 3 - 4 } & & 1,060 \\ \hline \end{tabular} Calculate the following for: 2021 2020 Working Capital (in milliens) Debt Ratio (atapercent) Fermudayfinks r/a r/a n/a
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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