Question

In: Accounting

Return on Investment, Financial Leverage, and DuPont Analysis The following tables provide information from the recent...

Return on Investment, Financial Leverage, and DuPont Analysis
The following tables provide information from the recent annual reports of HD Rinker, AG.

Balance sheets 2016 2015 2014 2013
Total assets € 6,108 € 6,451 € 7,173 € 6,972
Total liabilities 5,970 4,974 4,989 5,097
Total shareholders' equity 138 1,477 2,184 1,875
Income statements 52 weeks ended 2016 2015 2014
Sales revenue € 10,364 € 9,613 € 8,632
Earnings before interest and taxes 1,473 1,459 887
Interest expense 246 208 237
Earnings before income taxes 1,227 1,251 650
Income tax expense 377 446 202
Net earnings € 850 € 805 € 448

a. Calculate HD Rinker’s return on equity (ROE) for fiscal years 2016, 2015, and 2014.
Round answers to one decimal place (i.e., 0.2568 = 25.7%). Do not round until your final answer.

2016 Answer %
2015 Answer %
2014 Answer %

b. Calculate HD Rinker’s return on assets (ROA) and return on financial leverage (ROFL) for each year.
Round answers to one decimal place (i.e., 0.2568 = 25.7%). Do not round until your final answer.

ROA ROFL
2016 Answer % Answer %
2015 Answer % Answer %
2014 Answer % Answer %

c. Use the DuPont formulation in the Business Insight on page 230 to analyze the variations in HD Rinker's ROE over this period. Calculate net profit margin, asset turnover, and financial leverage.
Do not round until your final answer. Round answers to one decimal place (i.e., 0.2568 = 25.7%).

NPM AT FL
2016 Answer % Answer Answer
2015 Answer % Answer Answer
2014 Answer % Answer Answer

Solutions

Expert Solution

A) Calculation for ROE

ROE = net earnings or net income / average shareholder equity

ROE for 2014 = € 448 / [( € 1,875 + € 2,184) /2] = 22.07%

ROE for 2015 = € 805 / [( € 2,184 + € 1,477)/2] = 43.98%

ROE for 2016 = € 850 / [ ( € 1,477 + € 138)/2] = 105.26%

B) Calculation for ROA

ROA = net income / average total assets

ROA for 2014 = € 448/ [ ( € 6,972 + € 7,173)/2] = 6.33%

ROA for 2015.= € 805 / [ ( € 7,173 + € 6,451)/2] = 11.82%

ROA for 2016 = € 850/ [( € 6,451 + € 6,108)/2] = 13.54%

Calculation for ROFL

ROFL = ROE - ROA

ROFL for 2014 = 22.07 % - 6.33 % = 15.74%

ROFL for 2015 = 43.98 % - 11.82 % = 32.16%

ROFL for 2016 = 105.26% - 13.54% = 91.72%

C) Calculation for net profit margin

Net profit margin = net earnings / net sales

Net profit margin for 2014 = € 448/ € 8,632 = 5.19%

Net profit margin for.2015 = € 805/ € 9,613 = 8.37%

Net profit margin for 2016 = € 850/ € 10,364 = 8.20%

Calculation for assets turn over ratio

Assets turn over ratio = net sales / average total assets

Assets turn over ratio for 2014 = € 8,632/ [ (€ 6,972 + € 7,173)/2] = 122.05%

Assets turn over ratio for 2015 = € 9,613/[( € 7,173 + €6,451)/2] = 141.11%

Assets turn over ratio for 2016 = € 10,364/ [( € 6,451 + € 6,108)/2] = 165.04%

Calculation for financial leverage

Financial leverage = EBIT/ [ EBIT - interest ]

Financial leverage for 2014 = € 887 / [ € 887 - € 237] = 136.46%

Financial leverage for 2015 = € 1,459 / [ € 1,459 - € 208] = 116.63%

Financial leverage for 2016 = € 1,473 / [ €1,473 - € 246] = 120.05%


Related Solutions

A) Define the following terms/concepts used in financial management: Capital Financial Leverage Perpetuity Dupont Analysis Dividend...
A) Define the following terms/concepts used in financial management: Capital Financial Leverage Perpetuity Dupont Analysis Dividend payout ratio Investment Beta factor Management Indenture Capital market Capital structure Portfolio theory Goodwill Bearer bonds
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $649,000 Cost of goods sold 363,000 Gross profit $286,000 Selling and administrative expense 100,000 Operating income $186,000 Interest expense 50,000 Income before tax $136,000 Income tax expense (40%) 54,400 Net income $81,600 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $659,000 Cost of goods sold 397,000 Gross profit $262,000 Selling and administrative expense 100,000 Operating income $162,000 Interest expense 50,000 Income before tax $112,000 Income tax expense (40%) 44,800 Net income $67,200 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen Company: Sales revenue $657,000 Cost of goods sold 387,000 Gross profit $270,000 Selling and administrative expense 100,000 Operating income $170,000 Interest expense 50,000 Income before tax $120,000 Income tax expense (40%) 48,000 Net income $72,000 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Explain how financial leverage at investment banks differ from financial leverage at more traditional commercial banks....
Explain how financial leverage at investment banks differ from financial leverage at more traditional commercial banks. What is the benefit of this leverage? What are the primary risks associated with the financial manager?
DuPont Analysis of Return on Equity 1. Using the following table, calculate the ROE in each...
DuPont Analysis of Return on Equity 1. Using the following table, calculate the ROE in each year using the simple formula. 2. Use the three step DuPont ROE process and show your work. 3. Summarize the findings in your DuPont ROE analysis. Select Financial Data for ABC Corp. 2017 2018 2019 Sales 20,000 22,000 25,000 Net Income 1,000 1,500 1,600 Total Assets 20,000 20,000 30,000 Total Equity 15,000 16,000 15,000
Describe how to use DuPont identity in financial analysis.
Describe how to use DuPont identity in financial analysis.
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $3 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio 3.62x Fixed assets turnover 5.36x Debt-to-capital ratio 16.99% Total assets turnover 3.02x Times interest earned 28.62x Profit margin 8.80% EBITDA...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio 4.08x Fixed assets turnover 7.36x Debt-to-capital ratio 20.46% Total assets turnover 3.03x Times interest earned 17.84x Profit margin 10.29% EBITDA...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of...
DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm's financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm's financial statements are as follows: Industry Average Ratios Current ratio 3.17x Fixed assets turnover 6.73x Debt-to-capital ratio 20.40% Total assets turnover 3.78x Times interest earned 22.72x Profit margin 8.24% EBITDA...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT