Question

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 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
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
Compute and Interpret ROA, Profit Margin, and Asset Turnover of Competitors Selected balance sheet and income...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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.,...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT