Compute and Interpret ROA, Profit Margin, and Asset
Turnover of Competitors
Selected balance sheet and income statement information for
McDonald's Corporation and Yum! Brands, Inc., follows (in
millions).
| Sales Revenue | Interest Expense | Net Income | Average Total Assets | |
|---|---|---|---|---|
| McDonalds | $32,853 | $671 | $5,758 | $46,995 |
| Yum! Brands | 15,031 | 180 | 1,196 | 10,375 |
a. Compute the return on assets (ROA) for each company. Assume a
tax rate of 35%. Do not round until your final answer.
Round answer to one decimal place (i.e., 0.2568 = 25.7%).
| McDonalds | Answer |
| Yum! Brands | Answer |
b. Disaggregate ROA into profit margin (PM) and asset turnover
(AT) for each company.
Do not round until your final answers. Round PM and ROA to one
decimal place (i.e., 0.2568 = 25.7%).
Round AT to 3 decimal places.
| PM | X | AT | = | ROA | |
|---|---|---|---|---|---|
| McDonalds | Answer | Answer | Answer | ||
| Yum! Brands | Answer | Answer | Answer |
Compute and Interpret Liquidity and Solvency Ratios
Selected balance sheet, income statement and cash flow statement information from Tesla, Inc. for 2017 and 2016 follows ($ thousands).
| December 31 | 2017 | 2016 |
|---|---|---|
| Cash and cash equivalents | $3,701,247 | $3,726,549 |
| Restricted cash | 156,545 | 106,741 |
| Net receivables | 515,381 | 499,142 |
| Inventory | 2,263,537 | 2,067,454 |
| Other current assets | 268,365 | 194,465 |
| Current assets | 6,905,075 | 6,594,351 |
| Current liabilities | 7,674,670 | 5,827,005 |
| Total liabilities | 23,022,980 | 16,750,167 |
| Stockholders' equity | 5,965,725 | 6,247,242 |
| Year ended December 31, | 2017 |
|---|---|
| Loss before income taxes | $(2,209,032) |
| Interest expense | 504,592 |
| Cash flows from operating activities | (59,432) |
| Capital expenditures | (3,748,147) |
a. Compute the current ratio and quick ratio for each year.
Note: Round answers to two decimal places.
| 2017 | 2016 | |
|---|---|---|
| Current ratio | Answer | Answer |
| Quick ratio | Answer | Answer |
b. Compute the debt-to-equity ratio for 2017 and 2016 and the times-interest-earned ratio for 2017.
Note: Round answers to two decimal places. Use a negative sign with your answer, if appropriate.
| 2017 | 2016 | |
|---|---|---|
| Debt-to-equity ratio | Answer | Answer |
| Times interest earned ratio | Answer |
c. Compute the cash burn rate for 2017.
Note: Round answer to the nearest whole number. Use a negative sign with your answer, if appropriate.
$Answer thousand per day
Common-Size Income Statements
Following is the income statement for Target Corporation. Prepare
Target's common-size income statement for the fiscal year ended
January 28, 2012.
| ($ millions) | Fiscal year ended January 28, 2012 |
|---|---|
| Sales | $70,466 |
| Net credit card revenues | 1,399 |
| Total revenues | 71,865 |
| Cost of sales | 47,860 |
| Selling, general and administrative expenses | 14,106 |
| Credit card expenses | 446 |
| Depreciation and amortization | 2,131 |
| Earnings before interest expense and income taxes | 7,322 |
| Net interest expense | 866 |
| Earnings before income taxes | 6,456 |
| Provision for income taxes | 1,527 |
| Net earnings | $4,929 |
Note: Round your answers to one decimal place (ex: 0.0715 = 7.2%).
| TARGET CORPORATION Common-Size Income Statement |
||
|---|---|---|
| Year Ended January 28, 2012 |
||
| Sales | Answer | |
| Net credit card revenues | Answer | |
| Total revenues | Answer | |
| Cost of sales | Answer | |
| Selling, general and administrative expenses | Answer | |
| Credit card expenses | Answer | |
| Depreciation and amortization | Answer | |
| Earnings before interest expense and income taxes | Answer | |
| Net interest expense | Answer | |
| Earnings before income taxes | Answer | |
| Provision for income taxes | Answer | |
| Net earnings | Answer | |
Computing Turnover Ratios for Companies in Different Industries
Selected data from recent financial statements of The Procter & Gamble Company, CVS Health Corporation, and Valero Energy Corporation are presented below:
| ($ millions) | Procter & Gamble | CVS Health | Valero Energy |
|---|---|---|---|
| Sales | $88,680 | $29,006 | $127,987 |
| Cost of sales | 43,391 | 7,167 | 116,719 |
| Average receivables | 6,172 | 1,257 | 6,645 |
| Average inventories | 7,050 | 113 | 5,285 |
| Average PP&E | 20,835 | 22,448 | 23,923 |
| Average total assets | 135,299 | 32,483 | 40,202 |
a. Compute the asset turnover (AT) ratio for each company. (Round your answers to one decimal place.)
| Asset Turnover | |
|---|---|
| Procter & Gamble | Answer |
| CVS | Answer |
| Valero Energy | Answer |
b. Compute the accounts receivable turnover (ART), inventory turnover (INVT), and PP&E turnover (PPET) for each company. (Round your answers to one decimal place.)
| ART | INVT | PPET | |
|---|---|---|---|
| Procter & Gamble | Answer | Answer | Answer |
| CVS | Answer | Answer | Answer |
| Valero Energy | Answer | Answer | Answer |
| 1) | |||||||
| a) | ROA = Net Income / Average Assets | ||||||
| McDonalds =5,758/46,995 | |||||||
| =12.3% | |||||||
| Yum! Brands = 1,196/10,375= | |||||||
| 11.5% | |||||||
| b) | |||||||
| Profit Margin = Net income / Sales | |||||||
| Asset Turnover Ratio = Sales / Average Assets | |||||||
| ROA = Net Income / Average Assets | |||||||
| McDonalds | |||||||
| [$5758/32853)]*[32853/46995] = 12.3% | |||||||
| 17.5% | * | 69.9% | = | 12.3% | |||
| Yum! Brands | |||||||
| [1,196/15,031]*[15,031/10375]=11.5% | |||||||
| 8.0% | * | 144.9% | = | 11.50% | |||
| 2) | Current Ratio = Current Assets / Current Liabilities | ||||||
| 2017 | 2016 | ||||||
| 0.90 | 1.13 | ||||||
| (6,905,075/7,674,670) | (6,594,351/5,827,005) | ||||||
| Quiick Ratio = Cash and cash equivalents+Net receivables / current liabilities | |||||||
| 2017 | 2016 | ||||||
| 0.55 | 0.73 | ||||||
| (3,701,247+515,381/7674670) | (3,726,549+499,142)/5,827,005 | ||||||
| b) | Debt To Equity Ratio = Total Debt / Equiy | ||||||
| 2017 | 2016 | ||||||
| 3.86 | 2.68 | ||||||
| (23,022,980/5,965,725) | (16,750,167/6,247,242) | ||||||
| Times Interest Earned Ratio = EBIT/ Interest expenses | |||||||
| 2017 | |||||||
| -4.38 | |||||||
| (-2,209,032/504,592) | |||||||
| Cash burn rate = Capital Expenditure/Cash flows from operating activities | |||||||
| 63.07 | |||||||
Compute and Interpret ROA, Profit Margin, and Asset Turnover of Competitors Selected balance sheet and income...
Compute and Interpret ROA, Profit Margin, and Asset Turnover of Competitors Selected balance sheet and income statement information for McDonald's Corporation and Yumi Brands, Inc., follows (in millions). Sales Revenue Interest Expense Net Income Average Total Assets McDonalds $27,441 $571 $4,758 $35,454 Yum! Brands 13,279 1,021 8,520 a. Compute the return on assets (ROA) for each company. Assume a tax rate of 35%. Do not round until your final answer. Round answer to one decimal place (i.e., 0.2568 = 25.7%)....
Please show work so I can follow the process.
Compute and Interpret ROA, Profit Margin, and Asset Turnover of Competitors Selected balance sheet and income statement information for McDonald's Corporation and Yum! Brands, Inc., follows (in millions). McDonalds Yum! Brands Sales Revenue Interest Expense Net Income Average Total Assets $27,441 $571 $4,758 $35,454 13,279 130 1,021 8,520 a. Compute the return on assets (ROA) for each company. Assume a tax rate of 35%. Do not round until your final answer....
Compute ROA, Profit Margin and Asset Turnover for Competitors Selected balance sheet and income statement information from Urban Outfitters, Inc. and TJX Companies, clothing retailers in the high-end and value.priced segments, respectively, follows (in millions). 2014 2014 2014 2013 Company Sales EW* Total Assets Total Assets Urban Outfitters 53.323 $232.4 $1,889 $2.221 TJX Companies 29,078 2.241 11.128 10,201 *EWI = Earnings without interest expense a. Compute the 2014 return on assets (ROA) for both companies. Round answers to one decimal...
5.22. Compute ROA, Profit Margin and Asset Turnover for Competitors Selected balance sheet and income statement information from Urban Outfitters, Inc. and TJX Companies, clothing retailers in the high-end and value-priced segments, respectively, follows. 2014 Earnings 2014 Without Interest 2014 Total 2013 Total Company ($ millions) Sales Expense (EWI) Assets Assets Urban Outfitters ....... ....... $ 3,323 $ 232.4 $ 1,889 $ 2,221 TJX Companies ... ........ 29,078 2,241.0 11,128 10,201 a. Compute the 2014 return on assets (ROA) for...
Compute, Disaggregate, and Interpret Competitors' Rates of Return Selected balance sheet and income statement information for the drug retailers CVS Health Corporation and Walgreen Co, follows. Assume tax rate of 35%. ($ millions) CVS Health Walgreen Sales revenue-2014 $139,367 $76,392 Interest expense-2014 600 156 Net income-2014 4,644 2,031 Total assets-2014 74,252 37,182 Total assets-2013 71,526 35,481 Stockholders' equity-2014 37,963 20,561 Stockholders' equity-2013 37,938 19,454 a. Compute the 2014 return on assets (ROA) for each company. (Round your answers to one...
E4-31. Compute and Interpret RNOA, Profit Margin, and Asset Turnover of Competitors Selected balance sheet and income statement information for drug store retailers CVS Health Corp. and Walgreens Boots Alliance follows. 2015 Net Operating Assets 2015 Sales Company ($ millions) 2014 Net Operating Assets 2015 NOPAT Ticker CVS Health ........... CVS Walgreens Boots Alliance WBA $153,290 103,444 $5,758 3,642 $62,159 42,683 $48,338 22,461 a. Compute the 2015 return on net operating assets (RNOA) for each company. b. Disaggregate RNOA into...
Compute, Disaggregate, and Interpret Competitors' Rates of Return Selected balance sheet and income statement information for the drug retailers CVS Health Corporation and Walgreen Co. follows. Assume tax rate of 35%. CVS Health Walgreen $139,367 $76,392 156 4,644 2,031 74,252 37,182 71,526 35,481 Stockholders' equity-2014 37,963 20,561 Stockholders' equity-2013 37,938 19,454 $ millions) Sales revenue-2014 Interest expense-2014 Net income-2014 Total assets-2014 Total assets-2013 600 a. Compute the 2014 return on assets (ROA) for each company. (Round your answers to one...
Compute ROA, Profit Margin, and Asset Turnover Refer to the financial information for Target Corporation, presented below: Target Corporation Balance Sheets January 31, February 1, ($ millions) 2015 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 59 Accounts payable Accrued and other current liabilities Current portion of long-term...
Please help.
Compute, Disaggregate and Interpret ROE and ROA Selected balance sheet and income statement information from Staples, Inc., follows ($ millions). Sales Interest expense Net income Total Assets Stockholders' Equity 2014 2014 2014 2014 2013 2014 2013 $22,492 $49 $135 $10,314 $11,175 $5,313 $6,141 a. Compute the 2014 return on equity (ROE), return on assets (ROA), and return on financial leverage (ROFL). Round answers to one decimal place (i.e., 0.2568 = 25.7%). Do not round until your final answer....
Mes question oot Compute, Disaggregate and interpret ROE and ROA Income statements for The Gap, Inc., follow along with selected balance sheet information (5 millons The GAP.INC Consolidated Statement of Earnings Fiscal year ended Feb. 2018 Jan. 24. 2017 Net sales $15.855 515516 Cost of goods sold and occupancy expenses 9.79 9.828 Gross profit 6.06 5.6.00 Operating expenses 452 Operating income 1:49 1.191 interest Expense 74 7 Interest income (19 Income before income taxes 1.124 Income taxes 576 Net earnings...