Use the following data for Apple and Dell (in $ million):
Apple | Dell | |
Profit (operating income) | $6,275 | $3,190 |
Sales revenue | $32,479 | $61,101 |
Investment (total assets) | $32,460 | $27,031 |
Required:
a) compute the ROI for each company.
Apple ROI= % (if you get say 12.5%, enter 12.5, not
12.5% or 0.125)
Dell ROI= %
b) use the DuPont method to decompose ROI into ROI = profit margin
* asset turnover.
In other words, compute profit margin and asset turnover for each
company:
Apple profit margin= , asset
turnover= (Enter both as a fraction of 1, not as
percentage. I.e., if the profit margin is 0.045 (4.5%) and asset
turnover is 3.42 (342%), enter 0.045 and 3.42)
Dell profit margin= , asset turnover=
If you multiply profit margin * asset turnover, you should get the
ROI from part (a)
c) Which company has higher profit margin?(1=Apple, 2=Dell)
d) Which company has higher asset turnover? 1=Apple, 2=Dell)
a) ROI = Net income/Investment
Apple ROI = 6275/32460 = 19.3
Dell ROI = 3190/27031 = 11.8
b) Calculate following
Profit margin | Turnover | |
Apple | 6275/32479 = 0.193 | 32479/32460 = 1.00 |
Dell | 3190/61101 = 0.052 | 61101/27031 = 2.26 |
c) Highest profit margin = Apple
d) Highest turnover = Dell
Use the following data for Apple and Dell (in $ million): Apple Dell Profit (operating income)...
2. -13.33 points Question 2 (performance evaluation, DuPont method) Use the following data for Apple and Dell (in 5 million): Apple Dell Profit Operating income) 56,275 $3,190 Sales revenue 532.479 561,101 Investment (total assets) 532.460 527,031 Required: a) compute the ROI for each company. Apple ROI- % (if you get say 12.5%, enter 12.5, not 12.5% or 0.125) Dell ROI | | b) use the DuPont method to decompose ROI into ROI = profit margin asset turnover. In other words,...
Question 1 (performance evaluation: RI, ROI) Generic Motors Corporation has two divisions, Kadillack and Chevrolay. Their performance for last year is as follows. Kadillack Chevrolay Investment (operating assets) $200 million $800 million Profit $40 million $120 million The required rate of return (cost of capital) for Generic Motors is 10% a year. Required: a) What is the return on investment (ROI) for each division? Kadillack ROI = 0 % (enter say 9.5% as 9.5, not as 0.095 and not as...
Qucstion 2: DuPont method In year 2016, Apple Inc. had profit margin of 27.8% a) The profit margin indicates that Apple has t generated 27.8 cents of profit per dollar of sales and asset turnover of 670 Le t generated 57 cents of annual sales per do ar o e as O high pricing power it can charge high prices relative to costs O high production efficiency-it has very low costs Olow pricing power it cannot charge high prices relative...
Question 2: DuPont method In year 2016, Apple Inc. had profit margin of 27.8% (i.e., it generated 27.8 cents of profit per dollar of sales) and asset turnover of 0.670 (i.e., it generated 67.0 cents of annual sales per dollar of assets). a) The profit margin indicates that Apple has high pricing power -- it can charge high prices relative to costs C high production efficiency -- it has very low costs o low pricing power -- it cannot charge...
Profit Margin, Investment Turnover, and ROI Briggs Company has operating income of $36,000, invested assets of $180,000, and sales of $720,000. Use the DuPont formula to compute the return on investment. a. Profit margin % b. Investment turnover c. Return on investment %
Profit Margin, Investment Turnover, and ROI Briggs Company has operating income of $17,982, invested assets of $74,000, and sales of $199,800. Use the DuPont formula to compute the return on investment. If required, round your answers to two decimal places. a. Profit margin b. Investment turnover c. Return on investment
Margin, Turnover, Return on Investment, Average Operating Assets Elway Company provided the following income statement for the last year: Sales $893,070,000 Less: Variable expenses 546,442,000 Contribution margin $346,628,000 Less: Fixed expenses 198,614,000 Operating income $148,014,000 At the beginning of last year, Elway had $38,632,000 in operating assets. At the end of the year, Elway had 541,363,000 in operating assets. Required: 1. Compute average operating assets. 2. Compute the margin (as a percent) and turnover ratios for last year. If required,...
Compute RNOA, Net Operating Profit Margin, and NOA Turnover Selected balance sheet and income statement information for Netflix Inc. the world's leading Internet entertainment service, follows. 2018 Net 2017 Net 2018 2018 Operating Operating Revenue NOPAT Assets Assets $15,794,341 $1,506,681 $11,804,340 $7,258,593 Company ($ thousands) Ticker Netflix, Inc NFLX a. Compute return on net operating assets (RNOA). Note: Round percentage to one decimal places (for example, enter 6.7% for 6.6555%). % b. Disaggregate RNOA into net operating profit margin (NOPM)...
Compute RNOA, Net Operating Profit Margin, and NOA Turnover for Competitors Selected balance sheet and income statement information for the fiscal year ended February 2, 2019, for Abercrombie & Fitch Co. and TJX Companies Inc., clothing retailers in the high-end and value-priced segments, respectively, follows. Current Prior Year Net Year Net Operating Operating Assets Assets Company ($ millions) Ticker Abercrombie & Fitch ANE TJX Companies TJX Sales NOPAT $3,590.10 $87.40 38,972.90 3,066.70 $792.30 $877.30 4,252.00 4,114.30 Compute the following ratios...
Problem 1: Financial Statement Ratio Analysis (40 points total) Use the following financial statements for Dell, Inc. to answer the questions which follow: BALANCE SHEET (SMil) 2017 10,298 2018 7,972 % 28.9 2019 9,092 % 34.3 40.2 Cash & Short Term Investments Accounts Receivable Inventory Other Current Assets Total Current Assets Net Fixed Assets Intangibles Other Long Term Assets Total Assets 6,152 24.0 660 2.6 2,829 11.3 19.939 76.6 2,409 8.7 0 0 3,287 14.7 25,635 100.0 7,693 27.9 1,180...