Question

In: Accounting

Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands)...

Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2013. Show that ROE = PM × AT × FL.

(in thousands)

2013

2012

Net sales

$6,484,892

$6,420,881

Operating income

1,168,103

1,021,015

Interest expense

5,555

6,841

Net income

903,944

776,464

Total assets

6,439,626

6,526,785

Total liabilities

3,188,067

3,459,741

Solutions

Expert Solution

Answer :-

a) Return on Equity (ROE)= Net Income / Average Stockholders' Equity

Net Income for 2013 = $903,944

Now we first find out the Stockholders' Equity.

Total Assets = Total liabilities + Stockholders' Equity

Therefore, Stockholders' Equity = Total Assets - Total liabilities

2013 2012

Total assets

$6,439,626

$6,526,785

Less :- Total liabilities

$3,188,067

$3,459,741

Stockholders' Equity $3,251,559 $3,067,044

Average Shareholders Equity = ( Shareholders Equity of 2013 + Shareholders Equity of 2012) /2

Average Shareholders Equity = ( $3,251,559 + $3,067,044) / 2

Average Shareholders Equity = $3,159,301.5

Return on Equity = $903,944/ $3,159,301.5

Return on Equity = 0.2861 or 28.61%

b) Profit Margin (PM) = Net Income / Net Sales

Net Income for 2013 = $ 903,944

Net Sales = $6,484,892

Profit Margin = $903,944 / $6,484,892

Profit Margin = 0.1394 or 13.94%

c) Asset Turnover (AT)= Net Sales / Average Assets

Net sales = $ 6,484,892

Average Assets = ( Total Assets of 2013 + Total Assets of 2012)/2

Average assets = ( $6,439,626 + $6,526,785 )/2

Average Assets = $6,483,205.5

Asset Turnover = $6,484,892 / $6,483,205.5

Asset Turnover = 1.00

d) Financial leverage (FL)= Average Assets / Average Stockholders' Equity

Average Assets = $6,483,205.5

Average Stockholders' Equity = $3,159,301.5

Financial leverage = $6,483,205.5 / $3,159,301.5

Financial leverage = 2.0521

.

As ROE = PM × AT × FL

=> 28.61% = 13.94% × 1.00 × 2.0521

=> 28.61% = 28.61%

Thus , ROE = PM × AT × FL.


Related Solutions

A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $...
A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2016. Show that ROE = PM × AT × FL. (in thousands) 2016 2015 Net sales $5,456,650 $5,702,613 Operating income 619,233 640,922 Interest expense 95,118 85,270 Net income 318,022 369,416 Total assets 6,493,794 6,535,143 Total liabilities 4,086,012 3,901,889
89) Following are selected data from the comparative income statement and balance sheet for Owens Corporation...
89) Following are selected data from the comparative income statement and balance sheet for Owens Corporation for the years ended December 31, 2014, and 2013: Selected Data                                    2014                      2013 Net sales (all on credit)                $96,000                $93,000 Cost of goods sold                           51,300                  52,500 Gross margin                                    44,700                  40,500 Income from operations                 16,300                  15,000 Interest expense                                 3,000                    3,500 Net income                                          9,800                    9,000 Cash                                                      2,700                    3,500 Accounts receivable, net                10,700                  12,500 Inventory                                           25,000                  30,000 Prepaid expenses                               1,000                       900 Total current assets                         39,400                  46,900 Total...
Salud Company reports the following information. Selected Annual Income Statement Data Selected Year-End Balance Sheet Data...
Salud Company reports the following information. Selected Annual Income Statement Data Selected Year-End Balance Sheet Data Net income $ 450,000 Accounts receivable increase $ 44,400 Depreciation expense 93,500 Prepaid expenses decrease 16,500 Gain on sale of machinery 24,800 Accounts payable increase 8,800 Wages payable decrease 2,500 Use the indirect method to prepare the operating activities section of its statement of cash flows for the year ended December 31. (Amounts to be deducted should be indicated with a minus sign.) Statement...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing retailer in the high-end market) and TJX Companies (clothing retailer in the value-priced market). (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (example: 0.2345 = 23.5%). Income Statement ($ millions) ANF TJX Sales $3,469 $21,942 Cost of goods sold 1,257 Answer% 16,040 Answer% Gross profit 2,212...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet...
Comparing Income Statements and Balance Sheets of Competitors Following are selected income statement and balance sheet data from two retailers: Abercrombie & Fitch (clothing in the high-end market) and TJX Companies (clothing retailer in the value priced market), for the fiscal year ended January 30, 2016. (a) Express each income statement amount as a percentage of sales. Round your answers to one decimal place (ex: 0.2345 = 23.5%) Income Statement ($ thousands) ANF TJX Sales $3,518,680 $30,944,938 Cost of goods...
Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for companies...
Comparing Operating Characteristics Across Industries Following are selected income statement and balance sheet data for companies in different industries. $ millions Sales Cost of Goods Sold Gross Profit Net Income Assets Liabilities Stockholders' Equity Target Corp. $73,785 $51,997 $21,788 $3,363 $40,262 $27,305 $12,957 Nike, Inc. 32,376 17,405 14,971 3,760 21,396 9,138 12,258 Harley-Davidson 5,995 3,620 2,375 752 9,991 8,151 1,840 Cisco Systems 49,247 18,287 30,960 10,739 121,652 58,067 63,585 (a) Compute the following ratios for each company. Round all answers...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for the fiscal year ended January 30, 2020. For Fiscal Year Ended Jan. 30, 2020 ($ millions) Snap Golden Eagle Income statement information: Interest expense $236 $6 Income before interest and taxes 9,296 1,932 Balance sheet information: Cash and cash equivalents 7,946 1,534 Accounts receivable 1,692 478 Current assets 24,309 4,410 Current liabilities 15,971 2,691 Total assets 46,333 9,833 Total liabilities 30,554 3,422 Total stockholders’...
1. The following is selected financial information from Tilly’s, Inc. Prepare the Income Statement, Balance Sheet...
1. The following is selected financial information from Tilly’s, Inc. Prepare the Income Statement, Balance Sheet and Cash Flow for February 2014 and 2013 using the below info. Tillys info ($thousands) Feb 1 2014 Feb 2 2013 Cash and cash equlvalents 25412 17315 Cash flow from operations 43794 41730 Cost of goods sold 343542 317096 Total liabilities 91484 88085 Total assets 232407 205381 Cash flow from financing 1834 22819 Sales revenue 495837 467291 Cash flow from investing (37530) (72326) Other...
Selected data derived from the income statement and balance sheet of National Beverage Co. for a...
Selected data derived from the income statement and balance sheet of National Beverage Co. for a recent year are as follows: 1 Income statement data (in thousands): 2 Net income $49,311.00 3 Gain on disposal of property 1,188.00 4 Depreciation expense 11,580.00 5 Other items involving noncash expense 1,383.00 6 Balance sheet data (in thousands): 7 Increase in accounts receivable 1,746.00 8 Decrease in inventory 990.00 9 Increase in prepaid expenses 605.00 10 Decrease in accounts payable and other current...
Selected data derived from the income statement and balance sheet of National Beverage Co. for a...
Selected data derived from the income statement and balance sheet of National Beverage Co. for a recent year are as follows: 1 Income statement data (in thousands): 2 Net income $43,993.00 3 Depreciation expense 10,651.00 4 Losses on inventory write-down and fixed assets 7.00 5 Other noncash items (187.00) 6 Balance sheet data (in thousands): 7 Increase in accounts receivable 5,679.00 8 Increase in inventory 7,509.00 9 Increase in prepaid expenses 2,239.00 10 Decrease in accounts payable and other current...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT