Question

In: Accounting

Compute ROA, Profit Margin, and Asset Turnover Refer to the financial information for Target Corporation, presented...

Compute ROA, Profit Margin, and Asset Turnover Refer to the financial information for Target Corporation, presented below: Target Corporation Balance Sheets ($ millions) January 31, 2015 February 1, 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders’ investment Accounts payable $7,759 $7,335 Accrued and other current liabilities 3,886 4,299 Current portion of long-term debt and notes payable 91 1,143 Total current liabilities 11,736 12,777 Long-term debt 12,705 11,429 Deferred income taxes 1,321 1,349 Other noncurrent liabilities 1,645 2,767 Total shareholders’ investment 13,997 16,231 Total liabilities and shareholders’ investment $41,404 $44,553 Target Corporation Income Statement ($ millions) Fiscal year ended January 31, 2015 Sales revenue $72,618 Cost of sales 51,278 Selling, general and administrative expenses 14,676 Depreciation and amortization 2,129 Earnings from continuing operations before interest and income taxes 4,535 Net interest expense 882 Earnings from continuing operations before income taxes 3,653 Provision for income taxes 1,204 Net earnings from continuing operations 2,449 Discontinued operations, net of tax (4,085) Net earnings (loss) $(1,636) a. Compute its return on assets (ROA) for the fiscal year ending January 31, 2015. Compute ROA using net earnings (loss). Assume a statutory tax rate of 35%. Round your answer to one decimal place. Use negative sign with answer, if appropriate. Return on Assets = Answer % b. Disaggregate ROA into profit margin (PM) and asset turnover (AT). Round your answers to one decimal place. Use negative sign with answers, if appropriate. Profit Margin = Answer % Asset Turnover =

Solutions

Expert Solution

Solution:-

a. Compute its return on assets (ROA) for the fiscal year ending January 31, 2015. Compute ROA using net earnings (loss). Assume a statutory tax rate of 35%:-

  • Here, we need to findout the return on assets .
  • Return on assets = [Net income + interest expense ] / average total assets

Where,

Net income = $1,636

interest expense = $882 * (100 % - 35%)

= $546.84

interest expense =  $546.84

average total assets = [ $41,404 + $44,553 ] / 2

= 85,957 / 2

= $42,978.5

Average total assets = $42,978.5

Return on assets = [Net income + interest expense ] / average total assets

= [ $1,636 + $546.84) / $42,978.5

= 0.0507

Return on assets = 5.07%

b. Disaggregate ROA into profit margin (PM) and asset turnover (AT). Round your answers to one decimal place:-

  • Here ,we need to findout the proit margin and asset turnover .

Profit Margin = net income / net sales

Where,

net income = $1,636

net sales = $72,618

Profit Margin = $1,636 /  $72,618

= 0.0225

Profit Margin = 2.25%

Profit Margin = 2.25%

Asserts turnover = Net sales / average toatl assets

Where ,

net sales = $72,618

average total assets = [ $41,404 + $44,553 ] / 2

= 85,957 / 2

= $42,978.5

Average total assets = $42,978.5

Asserts turnover = $72,618 / $42,978.5

= 1.689 times

Asserts turnover = 1.689 times

Related Solutions

Compute the Profit margin (PM), asset turnover (AT), and financial leverage (FL) components of the basic...
Compute the Profit margin (PM), asset turnover (AT), and financial leverage (FL) components of the basic Dupont model. Show that ROE=PMxATxFL for 2016. To assets we $45,550 million in 2014. Which component (S) explain the year over year change in Valero's ROE?
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return...
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return on assets, Return on equity, Earnings per Share, Price-earnings, Cash Dicidend payot, Debt Ratio, Debt-to-Equity, and Times Interest earned Orange Company Income Statement For the Years Ended December 31 2013 2012 Net sales (all on account) $            600,000 $                520,000 Expenses: Cost of Goods Sold $            415,000 $                354,000 Selling and administrative $            120,800 $                114,600 Interest Expense $                7,800 $                    6,000 Income Tax...
ROA Asset Turnover Profit Margin COGS to Revenue Carmax 4.46% 1.02 4.37% 0.87 AutoNation 4.25% 2.01...
ROA Asset Turnover Profit Margin COGS to Revenue Carmax 4.46% 1.02 4.37% 0.87 AutoNation 4.25% 2.01 2.11% 0.83 Does the relative size of the cost of goods sold to revenue ratio help explain the difference in the ROA profit margin and ROA for the two firms?
Figure It Out Corporation has a net profit margin of 8%, a total asset turnover of...
Figure It Out Corporation has a net profit margin of 8%, a total asset turnover of 2 times, total assets of $1 billion, and total equity of $500 million. What were the company’s sales and net profit?
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
Return on Equity (ROE)= Sales Margin* Asset turnover* Gearing ratio ROE= Profit/equity Sales Margin= Profit/Sales Asset...
Return on Equity (ROE)= Sales Margin* Asset turnover* Gearing ratio ROE= Profit/equity Sales Margin= Profit/Sales Asset turnover= Sales/Assets Gearing Ratio= Assets/Equity This formula is important from strategy point of view as higher ROE is possible in a low profit margin business by increasing the asset turnover and by taking debt to increase the capital employed. This Question I need it to answer ---> "good very high level summary of the ratios in this DQ. Can you provide back to me...
Profit margin is 10%, asset turnover is 1.5 times, financial leverage is 2.0 times, earnings per...
Profit margin is 10%, asset turnover is 1.5 times, financial leverage is 2.0 times, earnings per share are $2.00 and dividends per share are $2.50. Which of the following statements is correct: 1. The return on assets is greater than the return on equity             2. The return on equity is greater than the sustainable growth rate             3. The sustainable growth rate is greater than the return on assets             4. The stock is over valued
Calculate ROE given the following information: profit margin = 20%; total asset turnover = 0.64; equity...
Calculate ROE given the following information: profit margin = 20%; total asset turnover = 0.64; equity multiplier = 1.50.
you are gicen the following information for hendrix guitars inc. profit margin 5.7, total asset turnover...
you are gicen the following information for hendrix guitars inc. profit margin 5.7, total asset turnover 1.5, total debt ration .38, payout ratio 35%. calculate the sustainable growth rate.
A firm has a net profit margin of 4.5%, a total asset turnover of 0.72, and...
A firm has a net profit margin of 4.5%, a total asset turnover of 0.72, and a financial leverage multiplier of 1.43. 1. Calculate the firm's ROA and ROE. 2. What is the advantage to using the DuPont system to calculate ROE over the direct calculation of earnings available for common stockholders divided by common stock equity?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT