Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Compute the following equations using the information provided. Please show work.

  1. AVG COLLECTION PERIOD- Accounts receivable/ (credit sales/ 365)
  2. INVENTORY TURNOVER- Cost of sales/ Average inventory
  3. FIXED ASSET TURNOVER- Sales/ Fixed assets
  4. TOTAL ASSET TURNOVER- Sales/ Total Assets
  5. DEBT RATIO- Total debt- Total assets
  6. DEBT TO EQUITY RATIO- Total Debt/ Total Equity
  7. TIMES INTEREST EARNED- Earnings before interest & taxes (EBIT)/ Interest charges
  8. FIXED CHARGE COVERAGE- EBIT+ Lease payments/ Interest + Lease Payments+ Preferred stock Dividends before tax+ before tax sinking fund
  9. GROSS PROFIT MARGIN- Sales- Cost of Sales/ Sales
  10. NET PROFIT MARGIN- Earnings after taxes (EAT)/ Sales
  11. RETURN ON INVESTMENT- Earnings after taxes (EAT)/ Total Assets
  12. RETURN ON SE- Earnings after taxes (EAT)/ Stockholders Equityimage text in transcribedimage text in transcribed
2017 2016 2015 (116) (513) (213) Table of Contents CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (LOSS) (Sin millions) Net income (loss) Other comprehensive income (loss), net of tax: Retirement benefit plans Net actuarial gain (los) arising during the period 1) Prior service credit/(cost) arising during the period Reclassification of net actuarial (gain) loss from a settlement) 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 (loss) Deferred tax valuation allowance Total other comprehensive income (loss), net of tax Total comprehensive income (loss), net of tax 8 16 4 110 31 2 (23) 6 7 2 (54) (141) (654) (3) See the accompanying notes to the Consolidated Financial Statements. 2017 2016 $ $ 125 762 116 342 458 2,762 190 3,410 4.281 887 2,854 160 3,901 4,599 61 661 8,413 618 9,118 $ $ 973 $ (In millions, except per share data) 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 977 1.164 1,119 8 15 232 2,332 212 3,780 143 567 7,034 263 2,419 219 4,339 204 583 7,764 156 4,705 (3,122) (360) 1,379 8,413 154 4,679 (3.006) (473) 1.354 9,118 $ (1) 1,250 million shares of common stock are authorized with a par value of $0.50 per share. The total shares issued and outstanding were 312.0 million and 308.3 million as of February 3, 2018 and January 28, 2017, respectively. 2017 2016 2015 (116) (513) (213) Table of Contents CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (LOSS) (Sin millions) Net income (loss) Other comprehensive income (loss), net of tax: Retirement benefit plans Net actuarial gain (los) arising during the period 1) Prior service credit/(cost) arising during the period Reclassification of net actuarial (gain) loss from a settlement) 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 (loss) Deferred tax valuation allowance Total other comprehensive income (loss), net of tax Total comprehensive income (loss), net of tax 8 16 4 110 31 2 (23) 6 7 2 (54) (141) (654) (3) See the accompanying notes to the Consolidated Financial Statements. 2017 2016 $ $ 125 762 116 342 458 2,762 190 3,410 4.281 887 2,854 160 3,901 4,599 61 661 8,413 618 9,118 $ $ 973 $ (In millions, except per share data) 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 977 1.164 1,119 8 15 232 2,332 212 3,780 143 567 7,034 263 2,419 219 4,339 204 583 7,764 156 4,705 (3,122) (360) 1,379 8,413 154 4,679 (3.006) (473) 1.354 9,118 $ (1) 1,250 million shares of common stock are authorized with a par value of $0.50 per share. The total shares issued and outstanding were 312.0 million and 308.3 million as of February 3, 2018 and January 28, 2017, respectively

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Statistics Informed Decisions Using Data

Authors: Michael Sullivan III

5th Edition

978-0134135373, 134133536, 134135377, 978-0134133539

Students also viewed these Finance questions