For the following problems 3336 use the data from the Narrow
For the following problems (33-36), use the data from the Narrow Falls Lumber\'s Income Statement and Balance Sheet.
33. Calculate the total debt ratio for
2015:_____________________
34. Calculate the Days\' sales in inventory for
2015:_____________________
(hint, you must first calculate the inventory turnover)
35. What is the equity multiplier for 2015?
A. 1.71
B. 1.87
C. 1.44
D. 1.82
E. 1.92
36. What are the values for the three components of the DuPont identity for 2015?
A. 11.08%; .9289; 1.8679
B. 11.08%; 1.0765; 1.8679
C. 11.08%; .9289; .5354
D. 7.75%; 1.0765; .5354
E. 7.75%; 1.0765; 1.8679
Solution
33. Total debt ratio for 2015 = total liabilities/total assets
= (78900+50000+295600)/913600
= 0.46
34. Inventory turnover = cost of goods sold/ inventory = 542800/99500 = 5.46
Days sales in inventory = 365/inventory turnover = 365/5.46
= 66.91
35. Equity multiplier = total assets/total equity = 913600/(170000+319100)
= 1.87 (1.8679)
36. 3 components of DuPont = net profit margin, asset turnover and equity multiplier
Net profit margin = 94000/848600 = 11.08%
Asset turnover = sales/ assets = 848600/ 913600 = 0.9289
Equity multiplier = 1.8679 (as calculated in 35)
Hence the answer is option “A” – 11.08%, 0.9289, 1.8679
