DuPont Analysis of Microsoft
DuPont Analysis Overview
The DuPont Analysis is a type of analysis that provides a more detailed look at a company's Return on Equity (ROE) by breaking it into three main components. The three components are profit margin, asset turnover and a leverage factor. By separating the ROE into these smaller categories, investors can quickly identify how effectively or efficiently a company is using their resources. If any of the three categories is performing poorly then this can lower the overall figure. To calculate a firm's ROE through Du Pont analysis, multiply the profit margin (net income divided by sales), asset turnover (sales divided by assets) and leverage factor (total assets divided by shareholders' equity) together - the higher the result, the higher the return on equity.
Microsoft's Profit Margin
Profit Margin = net income / total revenues
Income Statement
Revenue (ttm): 72.93B
Net Income: 15.46B
Profit Margin
15.46 / 72.93 = 22%
Microsoft's Asset Turnover
Asset turnover = revenue / assets
Revenue (ttm): 72.93B
Assets: 343.30B
Asset turnover = 72.93 / 556.71 = 13.1%
Microsoft's Financial Leverage
Financial Leverage = Assets / Equity
Assets: 68.10B
Equity: 72.58B
Financial Leverage = .94
Summary
Profit Margin = 22%
Asset turnover = 22.7
Financial Leverage = .94
Microsoft is in an industry that makes it more difficult to apply DuPont analysis averages to determine its financial health. Microsoft obviously operates
6. How does Chem-Med 's retum -on- equity ratio (ROE) compare to Pharmacia 's and the industry for 2003? Using the Du Pont method, compare the positions of Chem-Med and Pharmacia. Compute ROE for each company using the following formula:
Microsoft has their dominance of the industry at stake. They could potentially come out on top if left to continue their current tactics. They are masterfully “marketing their products” and it is paying off for them (Love, 1997).
1. What are the factors that likely explain the difference between Microsoft’s market value of equity and its reported book value of equity?
They have expand their business from only on computer software and hardware to online search engine, home gaming devices and smartphone, those business are the popular business in the world, Microsoft is trying to adapt the new market.
1. This question addresses the effect of Microsoft’s software capitalization policy on its financial statements. Ignore any potential tax effects.
2. Wal-Mart’s average ROE for the 1997 fiscal year was 19.7% [$3,525/($18,503+$17,143)/2] while Sears’ average ROE over roughly the same period was 22.0% [$1,188/($5,862+$4,945)/2]. Don Edwards was puzzled by these numbers because of Wal-Mart’s reputation as a premier retailer and Sears’ financial difficulties not long ago. Use the 3-step DuPont method to break down the ROE calculation and determine what is driving the individual performance of each of these two companies during
* Microsoft has retained $18.9 billion in earning over the years. It has over 2.5 times that amount in stockholder equity ($47.29 billion), no
Microsoft was founded in 1975, and is the worldwide leader in software, services, and solutions (Career). Microsoft is proud to offer great products and employ outstanding people. Previous Microsoft CEO, Steve Ballmer once said, “There are many things that are true about Microsoft. We have big goals, big dreams, and big aspirations for the future. We are both competitive with our products and in the way we attract and retain talent. For me, the most important factor is competition for talent, because I know our success comes from the people who work here” (Foley).
Microsoft may feel that there is competitiveness in the relevant market, the facts behind the claims of the rival
Next is Asset turnover with .55 times which is a measure of the efficiency of asset utilization. Finally the equity multiplier with 2.26 which is a measure of financial leverage of the firm. When compared to the traditional ratios we get similar results; Profit margin 25.44% (27% DuPont) versus 18.75% industry average. Asset turnover is .54 (.55 DuPont) versus .50 industry average. Equity multiplier 2.28 times (2.26 times DuPont) versus 2 times industry average. The results show that the DuPont analysis using ROE as the main determinant are very similar to the regular ratios. Furthermore the ROE of the traditional ratio is 31.32% with DuPont being 33.10% versus the industry average of 18.75% shows that the firms ROE is very robust. While the firm has some challenges with respect to liquidity and inventory management, as well as debt management it still is doing a good job with respect to its shareholders. However it could be doing a little better for the stockholders, and needs to address some of the above issues mentioned.
Historically, the Du Pont innovation of (ROI) calculations represents one of the most significant turning points in the history of modern accounting and management, (Hounshell, 1998 ). The 1920’s began the Du Pont system company with methods and calculations from leaders, owners, executives, etc. Furthermore, it was the beginning of the integration of financial accounting, capital accounting, and cost accounting. When it comes to return on assets (ROA), they are a (ROI) measure that evaluates the organization’s return or net income relative to the asset base need to generate the income, (Finkler, Ward, & Calabrese, 2013). The Du Pont Company has been the leader of industrial research. Throughout the years with companies emerging, Du Pont’s method was becoming more prominent with owners and executives needing a method for
Attached is an Income Statement from 2005 to 2007 (Microsoft Corporation Annual Report, 2008). As you can see, revenues and net income have continued to increase over the years. Earnings per share have increased as well. This shows that Microsoft is in a good financial standing. This means they are able to pay their shareholders and increase what they
Microsoft Corporation is a public multinational corporation headquartered in Redmond, Washington, USA that develops, manufactures, licenses, and supports a wide range of products and services predominantly related to computing through its various product divisions. Established on April 4, 1975 to develop
Bill Gates Believed Microsoft’s core source of competitive advantage was the ability to attract, motivate and retain superior people. In attracting employees Microsoft mainly targeted the stars. Stars are the core employees that can add value to the organization through their knowledge, skills and abilities (Boselie, 2010). At Microsoft there has been a hands on mentality made for ambitious people.
The three statements that were provided in this section provide possible investors, competitors, and even those within the company with useful information to make important decisions that could affect their livelihood or the livelihood of Microsoft. Keep in mind that even though financial statements are a solid indicator of how a company is performing, one key principle about must be known when viewing them to make decisions. They do not always provide all of the information that you may need. There are usually underlying topics that could affect the company that are not necessarily showing up on their financial statements. These topics are discussed in other sections of this report on Microsoft.