Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

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_2

Step: 3

blur-text-image_3

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

Rethinking Clinical Audit Psychotherapy Services In The NHS

Authors: Rachael Davenhill, Matthew Patrick

1st Edition

0415162084, 978-0415162081

More Books

Students also viewed these Accounting questions