ROI analysis using DuPont model.
a. Firm D has net income of $27,900, sales of $930,000, and average total
assets of $465,000. Calculate the firm's margin, turnover, and ROI.
b. Firm E has net income of $75,000, sales of $1,250,000, and ROI of 15%.
Calculate the firm's turnover and average total assets.
c. Firm F has ROI of 12.6%, average total assets of $1,730,159, and turnover
of 1.4. Calculate the firm's sales, margin, and net income.
The solution provides ROI Analysis using DuPont Model in excel.