Compute the following equations using the information provided. Please show work.
- AVG COLLECTION PERIOD- Accounts receivable/ (credit sales/ 365)
- INVENTORY TURNOVER- Cost of sales/ Average inventory
- FIXED ASSET TURNOVER- Sales/ Fixed assets
- TOTAL ASSET TURNOVER- Sales/ Total Assets
- DEBT RATIO- Total debt- Total assets
- DEBT TO EQUITY RATIO- Total Debt/ Total Equity
- TIMES INTEREST EARNED- Earnings before interest & taxes (EBIT)/ Interest charges
- FIXED CHARGE COVERAGE- EBIT+ Lease payments/ Interest + Lease Payments+ Preferred stock Dividends before tax+ before tax sinking fund
- GROSS PROFIT MARGIN- Sales- Cost of Sales/ Sales
- NET PROFIT MARGIN- Earnings after taxes (EAT)/ Sales
- RETURN ON INVESTMENT- Earnings after taxes (EAT)/ Total Assets
- RETURN ON SE- Earnings after taxes (EAT)/ Stockholders Equity
CONSOLIDATED BALANCE SHEETS (In millions, except per share data) 2018 2017 As Adjusted $ 109 $ 224 116 342 458 2,803 190 333 2.437 189 2,959 3,938 147 677 3,451 4,281 61 661 $ 7,721 $ 8,454 $ 847 $ Assets Current assets: Cash in banks and in transit Cash short-term investments Cash and cash equivalents Merchandise inventory Prepaid expenses and other Total current assets Property and equipment Prepaid pension Other assets Total Assets Liabilities and Stockholders' Equity Current liabilities: Merchandise accounts payable Other accounts payable and accrued expenses Current portion of capital leases, financing obligation and note payable Current maturities of long-term debt Total current liabilities Long-term capital leases, financing obligation and note payable Long-term debt Deferred taxes Other liabilities Total Liabilities Stockholders' Equity Common stock (1) Additional paid-in capital Reinvested earnings (accumulated deficit) Accumulated other comprehensive income (loss) Total Stockholders' Equity Total Liabilities and Stockholders' Equity 973 1.156 995 8 92 8 232 1.942 204 3.716 131 558 6,551 2,369 212 3,780 143 567 7,071 158 4,713 (3,373) (328) 1,170 7,721 156 4,705 (3,118) (360) 1.383 8.454 $ (1) 1.25 billion shares of common stock are authorized with a par value of $0.50 per share. The total shares issued and outstanding were 316.1 million and 312.0 million as of February 2, 2019 and February 3, 2018, respectively. Table of Contents CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME/LOSS) ($ in millions) 2018 2017 As Adjusted 2016 As Adjusted $ (255) (118) (17) 38 4 (2) 4 Net income (loss) Other comprehensive income (loss), net of tax: Retirement benefit plans Net actuarial gain (los) arising during the period) Prior service credit (cost) arising during the period ) Reclassification of net actuarial gain) loss from a settlement (3) Reclassification for net actuarial (gain) loss (4) Reclassification for amortization of prior service (credit) cost (5) Reclassification of prior service credit) cost from a curtailment (6) Cash flow hedges Gain (loss) on interest rate swaps) Reclassification for periodic settlements (8) Foreign currency translation Unrealized gain (los) Total other comprehensive income (loss), net of tax Total comprehensive income (loss), net of tax 16 4 3 6 (9) (2) IT " (1) (223) (5 CONSOLIDATED BALANCE SHEETS (In millions, except per share data) 2018 2017 As Adjusted $ 109 $ 224 116 342 458 2,803 190 333 2.437 189 2,959 3,938 147 677 3,451 4,281 61 661 $ 7,721 $ 8,454 $ 847 $ Assets Current assets: Cash in banks and in transit Cash short-term investments Cash and cash equivalents Merchandise inventory Prepaid expenses and other Total current assets Property and equipment Prepaid pension Other assets Total Assets Liabilities and Stockholders' Equity Current liabilities: Merchandise accounts payable Other accounts payable and accrued expenses Current portion of capital leases, financing obligation and note payable Current maturities of long-term debt Total current liabilities Long-term capital leases, financing obligation and note payable Long-term debt Deferred taxes Other liabilities Total Liabilities Stockholders' Equity Common stock (1) Additional paid-in capital Reinvested earnings (accumulated deficit) Accumulated other comprehensive income (loss) Total Stockholders' Equity Total Liabilities and Stockholders' Equity 973 1.156 995 8 92 8 232 1.942 204 3.716 131 558 6,551 2,369 212 3,780 143 567 7,071 158 4,713 (3,373) (328) 1,170 7,721 156 4,705 (3,118) (360) 1.383 8.454 $ (1) 1.25 billion shares of common stock are authorized with a par value of $0.50 per share. The total shares issued and outstanding were 316.1 million and 312.0 million as of February 2, 2019 and February 3, 2018, respectively. Table of Contents CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME/LOSS) ($ in millions) 2018 2017 As Adjusted 2016 As Adjusted $ (255) (118) (17) 38 4 (2) 4 Net income (loss) Other comprehensive income (loss), net of tax: Retirement benefit plans Net actuarial gain (los) arising during the period) Prior service credit (cost) arising during the period ) Reclassification of net actuarial gain) loss from a settlement (3) Reclassification for net actuarial (gain) loss (4) Reclassification for amortization of prior service (credit) cost (5) Reclassification of prior service credit) cost from a curtailment (6) Cash flow hedges Gain (loss) on interest rate swaps) Reclassification for periodic settlements (8) Foreign currency translation Unrealized gain (los) Total other comprehensive income (loss), net of tax Total comprehensive income (loss), net of tax 16 4 3 6 (9) (2) IT " (1) (223) (5
