Question: Round your answers to three (3) decimal points. Given the following balance sheet and income statement on a company, use the DuPont identity to calculate

 Round your answers to three (3) decimal points. Given the following

Round your answers to three (3) decimal points. Given the following balance sheet and income statement on a company, use the DuPont identity to calculate its Return-on-Equity (ROE) in 2019. State the Excel formula that you will use for net profit margin, asset turnover ratio, and leverage, respectively. 1 Balance sheet as at the end of ($'000) 2 Cash 3 Receivables 4 Inventories 5 Other assets 6 Property and equipment 7 Total assets 8 Total liabilities 9 Total equity 10 Total liabilities and equity 11 12 13 Income Statement ($'000) 14 Sales 15 COGS 16 Gross profit 17 Expenses 18 EBIT 19 Tax expense 20 Net income B 2018 50 3,280 5,901 25 700 9,956 7,886 2,070 9,956 2019 100 4,349 6,050 28 643 11,170 6,900 4,270 11,170 2018 38,697 23,605 15,092 13,530 1,562 624 938 2019 45,379 27.227 18,152 14,538 3,614 1,445 2,169 Given the following industry average, interpret the financial performance of the company Industry Average Net profit margin Asset turnover ratio Leverage Accounts receivables turnover Inventory turnover Fixed asset turnover 0.045 5.000 3.300 11.75 6.000 65

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!