Dupont Ratios Analysis

Microsoft Corporation

Microsoft Corporation (MSFT)

0.2 (+0.10%)

ROE = Net IncomeAverage Total EquityROE = Net IncomePretax IncomeTax Burden  Net IncomePretax IncomeInterest Burden  E B I TRevenueReturn On Sales (ROS)Profit Margin  RevenueAverage Total AssetsAssets TurnoverROA  Average Total AssetsAverage Total EquityEquity Multiplier(Financial Leverage)ROE~=~\underbrace{\dfrac{Net~Income}{Average~Total~Equity}}_{\text{ROE}}~=~\underbrace{\underbrace{\underbrace{\dfrac{Net~Income}{Pretax~Income}}_{\text{Tax~Burden}}~*~\underbrace{\dfrac{Net~Income}{Pretax~Income}}_{\text{Interest Burden}}~*~\underbrace{\dfrac{E~B~I~T}{Revenue}}_{\text{Return~On~Sales~(ROS)}}}_{\text{Profit~Margin}}~*~\underbrace{\dfrac{Revenue}{Average~Total~Assets}}_{\text{Assets~Turnover}}}_{\text{ROA}}~*~\underbrace{\dfrac{Average~Total~Assets}{Average~Total~Equity}}_{\text{Equity~Multiplier(Financial~Leverage)}}

ROE = NI/EBT * EBT/EBIT * EBIT/Revenue * Asset Turnover * Company Equity Multiplier
37.43% = 83.49% * 100.15% * 37.03% * 47.46% * 2.55

ROA = Net Profit Margin * Asset Turnover
14.70% = 30.96% * 47.46%

The company's tax burden is (Net income ÷ Pretax profit). This is the proportion of the company's profits retained after paying income taxes. [NI/EBT]
The company's interest burden is (Pretax income ÷ EBIT). This will be 1.00 for a firm with no debt or financial leverage. [EBT/EBIT]
The company's operating income margin or return on sales (ROS) is (EBIT ÷ Revenue). This is the operating income per dollar of sales. [EBIT/Revenue]
The company's asset turnover (ATO) is (Revenue ÷ Average Total Assets).
The company's equity multiplier is (Average Total Assets ÷ Average Total Equity). This is a measure of financial leverage.

ROE = (Profit margin)*(Asset turnover)*(Equity multiplier) = (Net profit/Sales)*(Sales/Average Total Assets)*(Average Total Assets/Average Equity) = (Net Profit/Equity)
0.37429841763592103 = 0.3096248645247002 * 0.4746424790332912 * 2.5469214903976196

Profitability (measured by profit margin)
Asset efficiency (measured by asset turnover)
Financial leverage (measured by equity multiplier)