(A)
Adequate information:
Given is the Income Statement and
To Compute:
Five Components as per DuPont formula for determining
- Operating margin
- Asset turnover
- Interest burden
- Financial leverage
- Income tax rate
Introduction:
There are broadly Five components for DuPont calculation which include Operating efficiency, Assets use efficiency, Financial Leverage, Interest burden, Income Tax Rate.
Operating efficiency is measured by profit margin, Assets use efficiency is measured by total asset turnover, financial leverage by the equity multiplier & Interest burden by pretax profit to earnings before interest & taxes and Income tax impact is derived by Profit after tax to profit before tax.
(B)
To Compute:
Discuss impact of the changes in asset turnover and financial leverage on the change of ROE from 2016 to 2019
Introduction:
In simple terms, Return on Equity is the determination of profitability of a company in relation to
Want to see the full answer?
Check out a sample textbook solutionChapter 19 Solutions
Investments, 11th Edition (exclude Access Card)
- Hello! look at the attached images and answer: (a) Calculate ratios for the year ended 31 December 2021 (showing your workings) for Primrose Plc, equivalent to those provided above. i. Return on year-end capital employed ii. Net asset turnover iii. Gross profit margin iv. Net profit margin v. Current ratio vi. Closing inventory holding period vii. Trade receivables’ collection period viii. Trade payables’ payment period ix. Dividend yield x. Dividend cover (b) Analyse the financial performance and position of Primrose Plc for the year ended 31 December 2021 compared to 31 December 2020. (c) Explain the uses and the general limitations of ratio analysis. Thanks a lot!arrow_forwardIncome statement and balance sheet data for The Athletic Attic are provided below.Required: 1. Calculate the following risk ratios for 2021 and 2022: a. Receivables turnover ratio. c. Current ratio. b. Inventory turnover ratio. d. Debt to equity ratio. 2. Calculate the following profitability ratios for 2021 and 2022: a. Gross profit ratio. c. Profit margin. b. Return on assets. d. Asset turnover. 3. Based on the ratios calculated, determine whether overall risk and profitability improved from 2021 to 2022.arrow_forwardRequired: (a) You are required to calculate the following ratios:(i) Gross profit margin(ii) Operating profit margin(iii) Expenses to sales(iv) Return on Capital Employed(v) Asset turnover(vi) Non-current asset turnover(vii) Current Ratio(viii) Quick Ratio(ix) Inventory days(x) Receivables days(xi) Payable days(xii) Interest cover (b) In light of your calculations comment on the performance of the company over thelast two years.arrow_forward
- Hello! look at the attached images and answee the following points: (a) Calculate ratios for the year ended 31 December 2021 (showing your workings) for Primrose Plc, equivalent to those provided above. Return on year-end capital employed Net asset turnover Gross profit margin Net profit margin Current ratio Closing inventory holding period Trade receivables’ collection period viii. Trade payables’ payment period Dividend yield Dividend cover (b) Analyse the financial performance and position of Primrose Plc for the year ended 31 December 2021 compared to 31 December 2020. (c) Explain the uses and the general limitations of ratio analysis. Thank you a lot!arrow_forwardThe image uploaded is the calculation of Access Bank's Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.arrow_forwardREQUIRED Use the information provided in below to answer the following questions for the financial year ended 31 December 2023. Note: Answers to the ratios must be expressed to two decimal places. Comment on the management of debtors and creditors after calculating the relevant ratios. Determine the percentage of the profit after tax that has been retained by the company. Calculate the return on capital employed and comment on your answer. Would prospective lenders be concerned about the relative proportion of borrowed capital and own capital? Motivate your answer by calculating the relevant ratio. Calculate the ratio that measures the efficiency with which the non-current and current assets of company were managed. Comment on the ability of the company to settle its short-term debts under distress conditions. Use a relevant ratio to motivate your answer. INFORMATION The following information was obtained from the financial records of Fiona Limited:arrow_forward
- As part of your analysis, you are required to investigate DEVCON Industries' cash flows and selected ratios. Required: Using the financial statement provided on page 1: (a) Compute the following ratios for DEVCON Industries for 2018 and 2019: i. Return on Equity using Du Pont Identity ii. Earnings Per Share (EPS iii. Price/Earning (P/E) Ratioarrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…arrow_forward
- Use the information provided from Sapphire Ltd to calculate the ratios for 2022 (expressed to two decimal places) that would reflect each of the following:1. The profit of the company relative to sales after deducting the cost of sales.2. The ability of the company to profitably utilize its capital, which includes both debt and equity.3. The proportion of the total assets that are financed by total debt.4. The ability of the company to repay its short-term debts under distress conditions, on the assumption that inventories would have no value at all.5. The portion of the company's profit that is allocated to each outstanding ordinary share.6. An indication of the percentage of profit that has been put back into the company.arrow_forwarda) Calculate the following ratios for 2016 and 2015, showing detailed calculations as to how you arrive at each number. A ROE B Gross profit margin C Total asset turnover D Inventory turnover E Current ratio F Debt-to-equity G Interest coverage ratio. b) Using the financial statements and the ratios calculated above (and any other ratios you like to calculate), discuss the performance of Cobham PLC in 2016. c) Critically discuss the need for the public limited companies to prepare a Statement of Cash Flows and explain the usefulness of the information contained therein from the perspective of a financial analyst.arrow_forwardCalculate the following ratios based on the balance sheet, income statement and cash flow prepared in question ROE Return on Capital Employed (post-tax) Net Profit Margin EBITDA Margin Effective Tax Rate Operating Cost Ratio Gross Profit Margin Total Asset Turnover Ratio Fixed Asset Turnover Ratio Receivables Turnover Ratio Leverage Ratio [Avg. Total Assets / Avg. Total Equity] FCF / EBITDA Interest Coverage Ratio Debt Service Coverage Ratio Basic EPS (Assume Face Value of each share is INR 10) Debt : Equity Ratio Income Statement (INR Cr) Units Mar/14 Saleable Units 4,570 Revenues Gross Revenues INR Cr 2,116 Less: Environment Cess INR Cr 5 Net Revenues INR Cr 2,121 Growth (%) -1.9% Expenses O&M Expenses (% of Project Costs) INR Cr 146 YoY Escalation 5.72% EBITDA INR Cr 1,974 Margin (%) 93.1% Book Depreciation INR Cr 439 Interest Expenses INR…arrow_forward
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning