Compute and Interpret RatiosSelected balance sheet and income statement information from Illinois Tool Works follows.$ millions2019 2018 2017Net operating profit after tax (NOPAT) $2,688 $2.792Net income2.597 2.640Total assetsEquity14,164 13,978 $15,7732,844 3.059 3.059Net operating profit after tax (NOA)Treasury stock8,337 8,894 9,48419.551 18,071 16,029a. Compute profitability measures: RNOA, ROA and ROE for 2019 and 2018 using the numbers as reported by the company.Note: Round answers to one decimal place (ex: 0.2345 = 23.5%).MetricRNOAROAROE20192018%%%b. Adjust equity and total assets for the amount of treasury stock.$ millionsAssets, restated $Equity, restated20192018S2017Using these restated numbers, recompute RNOA, ROA and ROE for both years.Note: Round answers to one decimal place (ex: 0.2345 = 23.5%).MetricRNOAROAROE20192018c. Which profitability measures (from part a or part b) better reflect the company's profit levels during the two years?Of the three measures, which one is least influenced by the company's stock repurchase activity?

b.Adjust equity and total assets for the amount of treasury stock.Equity, restated = Equity reported…

Answered: Compute and Interpret Ratios Selected…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Calculate the FCFE of this financial statement.
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands). Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Financial information Net sales Net operating profit after tax (NOPAT) Net operating assets (NOA) $2,091,242 158,522 428,867 Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions. Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_. Note: When completing the question…
Compute DuPont Analysis Ratios Selected balance sheet and income statement information for Humana Inc., a health and well‑being company, follows. 2018 2017 2018 2018 Net 2018 2017 Stockholders’ Stockholders’ Company ($ millions) Ticker Revenue income Assets Assets Equity Equity Humana Inc HUM $66,610 $11,381 $35,111 $36,876 $19,859 $19,540 Compute the following 2018 ratios for Humana. a. Return on equity (ROE) Note: 1. Select the appropriate numerator and denominator used to compute ROE from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute ROE. Numerator Denominator ROE Answer Answer Answer Answer b. Profit margin (PM) Note: 1. Select the appropriate numerator and denominator used to compute PM from the drop-down menu options. 2. Enter the numerator and denominator amounts to compute PM. Numerator Denominator PM Answer Answer Answer Answer c. Financial leverage…
Selected balance sheet and income statement information from Illinois Tool Works follows. $ millions Net operating profit after tax (NOPAT) $2,897 $3,009 Net income 2,798 2,845 Total assets 15,671 15,465 $17,451 Equity 3,147 3,384 3,384 10,493 Net operating profit after tax (NOA) 9,224 9,840 Treasury stock 21,070 19,475 17,274 a. Compute profitability measures: RNOA, ROA and ROE for 2019 and 2018 using the numbers as reported by the company. Note: Round answers to one decimal place (ex: 0.2345 = 23.5%). Metric RNOA ROA ROE 2019 30.4 % 17.9 % ✓ 88.91 % * $ millions Assets, restated $ Equity, restated b. Adjust equity and total assets for the amount of treasury stock. 2019 2018 34,940 $ 36,741 $ 24,217 ✔ $ 22,859 $ 2019 2018 30.4 % 8.08 % * 2019 2018 2017 11.89% 29.6 % 18.28 % * 84.1 %✔ Using these restated numbers, recompute RNOA, ROA and ROE for both years. Note: Round answers to one decimal place (ex: 0.2345 = 23.5%). Metric RNOA ROA ROE 2018 2017 29.6 % 8.64 % * 13.08% ✔ 34,725…
Compute and Interpret Ratios Selected balance sheet and income statement information from Illinois Tool Works follows. $ millions 2019 2018 2017 Net operating profit after tax (NOPAT) $2,480 $2,575 Net income 2,395 2,435 Total assets 13,561 13,383 $15,102 Equity 2,723 2,929 2,929 Net operating profit after tax (NOA) 7,982 8,516 9,080 Treasury stock 18,033 16,668 14,784 Compute profitability measures: RNOA, ROA and ROE for 2019 and 2018 using the numbers as reported by the company. Note: Round answers to one decimal place (ex: 0.2345 = 23.5%). b. Adjust equity and total assets for the amount of treasury stock. Using these restated numbers, recompute RNOA, ROA and ROE for both years.Note: Round answers to one decimal place (ex: 0.2345 = 23.5%).
Abhaliya
Using functions , complete the “Aggregated Data” worksheet using the “Statementof Income” worksheet.
Computing Financial Statement Measures The following pretax amounts are taken from the adjusted trial balance of Mastery Inc. on December 31, 2020, its annual year-end. Assume that the income tax rate for all items is 25%. The average number of common shares outstanding during the year was 20,000. Balance, retained earnings, December 31, 2019 $ 45,000 Sales revenue 300,000 Cost of goods sold 105,000 Selling expenses 36,000 Administrative expenses 34,000 Gain on sale of investments 10,000 Unrealized holding gain on debt investments, net of tax 4,250 Prior period adjustment, understatement of depreciation from prior period (2019) 20,000 Dividends declared and paid 16,000 Required Compute the following amounts for the year-end financial statements of 2020. Do not use negative signs with any of your answers. Round the per share amount to two decimal places. Item Amount a. Gross profit (2020). b. Operating income (2020). c. Net…
provide reasons for the attached calculated ratios using GSK 2023 annual report and provide non-financail performance analysis examples for GSK 2023.
For Financial year 2021: Current ratio = Current assets / Current liabilities = 43.133 / 29.613 = 1.46 (2.d.p) Debt-to-equity = Total liabilities / Total equity = (29.613 + 25.382) / 47.069 = 1.17 (2.d.p) Return on total assets = Net profit / Average total assets = (-11.195) / 101.964 = -0.11 (2.d.p) Profit margin ratio = Net profit / Net sales = (-11.195) / 81.79 = -0.14 (2.d.p) Debt-to-asset = Total liabilities / Total assets = (29.613 + 25.382) / 101.964 = 0.54 (2.d.p) Cash flow on total assets = Net cash flow from operating activities / Average total assets = 4.717 / 101.964 = 0.05 (2.d.p) For Financial year 2022: Current ratio = Current assets / Current liabilities = 49.476 / 32.754 = 1.51 (2.d.p) Debt-to-equity = Total liabilities / Total equity = (32.754 + 27.625) / 46.732 = 1.29 (2.d.p) Return on total assets = Net profit / Average total assets = (-0.336) / 107.111 = -0.003 (3.d.p) Profit margin ratio = Net profit / Net sales = (-0.336) / 115.56 = -0.003 (3.d.p) Debt-to-asset…
Debt to Equity Total Debt Ratio Times Interest Earned
Return on total assets ratio: net income/ avg. total assets 21,331/(321,195+225,248)/2= 0.07807= 7.8% (Amazon 2020 year) 6.0% (Amazon 2019 year) 6.37% (Walmart 2020 year) Write financial analysis report.

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS