The following table gives abbreviated balance sheets and income statements for E

Question

The following table gives abbreviated balance sheets and income statements for Estée Lauder Companies. Assume a corporate tax rate of 35%. ($ in millions) End of Year Start of Year Balance Sheet Assets Current assets: Cash and marketable securities $1,253 $1,121 Accounts receivable 946 746 Inventories 996 827 Other current assets 492 428 Total current assets 3,687 3,121 Fixed assets: Tangible fixed assets Property, plant, and equipment 2,862 2,525 Less accumulated depreciation 1,719 1,501 Net fixed assets 1,143 1,024 Other long-term assets 1,444 1,191 Total assets $6,274 $5,336 Liabilities and Shareholders’ Equity Current liabilities: Debt due for repayment $ 138 $ 23 Accounts payable 1,805 1,549 Total current liabilities 1,943 1,572 Long-term debt 1,080 1,205 Other long-term liabilities 621 610 Total liabilities 3,627 3,370 Total shareholders' equity 2,629 1,948 Total liabilities and shareholders’ $6,274 $5,336 equity Income Statement Net sales $8,810 Cost of goods sold 1,937 Selling, general, and administrative expenses 5,486 Depreciation 298 Earnings before interest and taxes (EBIT) 1,089 Interest expense 64 Taxable income 1,025 Tax 322 Net income $ 703 Dividends 148 Addition to retained earnings 555 Where appropriate use assets at start of year rather than average assets. a. Calculate the return on assets. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Return on assets % b. Calculate the operating profit margin. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Operating profit margin % c. Calculate the sales-to-assets ratio. (Round your answer to 2 decimal places.) Sales-to-assets ratio d. Calculate the inventory turnover. (Round your answer to 2 decimal places.) Inventory turnover e. Calculate the debt-equity ratio. (Round your answer to 2 decimal places.) Debt-equity ratio f. Calculate the current ratio. (Round your answer to 3 decimal places.) Current ratio g. Calculate the quick ratio. (Round your answer to 4 decimal places.) Quick ratio

Explanation / Answer

a) Return on Assets: = EBIT(1-T)/Average Total Assets = (1089*0.65)/{(6274+5336)*0.5} 12.19% b) Operating Profit Margin = Operating profit/Net Sales = 1089/8810 12.36% c) Sales to Assets Ratio = Net Sales/Average Total Assets = 8810/{(6274+5336)*0.5} 1.52 d) Inventory Turnover ratio = Cost of goods sold/Average Inventory = 1937/{(996+827(*0.5} 2.13 e) Debt Equity Ratio = Long term debt/Equity = (1080+621)/2629 = 0.65 f) Current Ratio = Current assets/current liabilities = 3687/1943 1.90 g) Quick ratio = Quick Assets/Current liabilities = (1253+946)/1943 1.13

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.