Dupont Ratios Analysis

Microsoft Corp

Microsoft Corp (MSFT)

$214.24
-1.13 (-0.52%)
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
38.49% = 84.10% * 100.00% * 38.39% * 48.87% * 2.44



ROA = Net Profit Margin * Asset Turnover
15.78% = 32.29% * 48.87%



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.38491960580912865 = 0.3228516660548962 * 0.4887492068132664 * 2.4393882909751037

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