Preview

Financial Statement Analysis of Microsoft

Good Essays
Open Document
Open Document
2233 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Financial Statement Analysis of Microsoft
Ⅰ Introduction
Microsoft is a company that is famous for its various products such as the Windows series. The firm is well known and is frequently cited as an example of good management. However, how good is it? As of December 1st, 2007, one share of Microsoft was approximately $33. Every investor would be curious if that price is reasonable. Also, it is too dangerous to rely completely on intuition or rumor when you buy stocks. Therefore, we decided to analyze Microsoft in a more rational, reasonable, fact-based way, and refer to that information in determining whether to buy Microsoft 's stock or not.
The 10-K financial statement from Microsoft is an enormous document, and it would take too much time to read the entire material. We thus decided to read the report selectively and analyze the company in the following steps: First, we will calculate several useful financial ratios. Second, we will look into the firm 's major accounting policies. Third, we will observe the trend, which shows how the company performed in the recent few years. Fourth, we will compare Microsoft with its competitors.

Ⅱ Body
1. Calculation of Ratios
Here we present several accounting ratios that helped us analyze Microsoft.

Chapter
Ratio
Value(rounded off to three decimals)
2
Financial Leverage Ratio
66384/35600.5=1.865
3
Total Asset Turnover Ratio
51122/66384=0.770
4
Net Profit Margin
14065/51122=0.275
5
Return on Equity
14065/35600.5=0.395
6
Gross Profit Percentage
40429/51122=0.791

Receivables Turnover
51122/10327=4.950
7
Inventory Turnover
10693/1302.5=8.210
8
Fixed Asset Turnover
51122/3697=13.827
9
Current Ratio
40168/23754=1.691

Accounts Payable Turnover
10693/3078=3.474
10
Debt-to-Equity Ratio
32074/31097=1.031
11
Earnings Per Share
Basic 14065/9742=1.44
Diluted 14065/9886=1.42

Dividend Yield
0.4/33.42-0.0120, 1.2%
12
Return on Assets
14065/66384=0.212
13
Quality of Income Ratio
17796/14065=1.265

Capital

You May Also Find These Documents Helpful

  • Powerful Essays

    Kohl's inventory turnover is slightly better by .3 than JC Penney. This might indicate that Kohl's volume of sales in terms of inventory is better than JC Penney.…

    • 934 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Microsoft products are used widely throughout the world with little or few competitors. The corporation can almost be considered a monopoly within its market. When considering its Net income, Microsoft Corporation has demonstrated a high increase in net income since the global financial crisis from 2009 to 2013. The company’s net income increased from approximately 17% to 25% respectively, and the Stockholders ' equity increased from $39,558 million in 2009 to $78,944 million in 2013 approximately 100% within four fiscal years. This has increased the number of investors for the company and will likely bring high return on…

    • 389 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Over the past few years the economy in the United States has taken a downturn. It has been so bad, that some businesses were not able to survive. However, Microsoft Corporation (Microsoft) was not one of those companies. The fiscal strength of Microsoft played a large part in providing the company with the ability and resources to survive the difficult financial markets (Microsoft Corporation, 2009). As a result of the outstanding financial position of the company, Microsoft chose to implement a strategic planning initiative in which the company would repurchase its stock. The $40 billion program would result in increased quarterly dividends and a return to shareholders of close to $14 billion (Microsoft Corporation, 2009).…

    • 1336 Words
    • 5 Pages
    Better Essays
  • Good Essays

    When one is trying to determine the health of a company and the risk involved either in terms of employment or investment opportunity it is wise to either view or create a Financial Statement Analysis. In evaluating each of the methods, as a team it was recognized that each part is a snippet of the financial structure of each of the companies. By analyzing and then comparing the data from the solvency ratio, liquidity ratio and a probability ratio, the team could make a firm decision in Microsoft regarding the present and future financial…

    • 709 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    According to company financials for the 2012 fiscal year, HP current ratio is at 1.09 while Microsoft Corp. ratio is at 2.6 which make HP a lesser candidate to obtain a short-term credit. They would not have enough to pay its current liabilities. Also HP recorded inventories of $6.32B compared to Microsoft $1.14B. If sales for PC’s, tablets, phones and other products dropped, HP would have a difficult time selling its inventory and running the risk of not being able to pay its current liabilities. Microsoft Corp. has a higher inventory turnover rate and a higher cost of goods sold and HP has a lower number of days’ sales in inventory. This means that they take less time than Microsoft Corp. to purchase, sell and replace inventory. Even though HP would have a hard time selling inventory in a crisis, they have managed to have a higher Accounts Receivable Turnover at 5.18, 0.4 more than Microsoft Corp. HP may have a better way of granting and collecting from its creditor.…

    • 1299 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    team prospectus

    • 3514 Words
    • 10 Pages

    Intro: A description of how wide the Microsoft’s products are used in our daily life followed by a question how Microsoft could be so successful.…

    • 3514 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    There is a decline in both the return in investment and return on equity. This shows that the company profit generation in relation to investments is decreasing. The industrial averages of 5.25% for return on investment is higher than that of 3.45% for the company. This shows that the utilization of assets to generate returns is low and not up to the required standards. The industrial average 0f 10.5% for the return on equity is also higher than that of the company which is 7.27%. This shows that the company is not performing up to standards in maximizing shareholders wealth who have contributed capital to the firm. The return per every shilling contributed by investors is low.…

    • 1041 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Carphone Warehouse

    • 7673 Words
    • 31 Pages

    THIS REPORT PROVIDES AN INSIGHT INTO THE MAIN STRATEGIC PROCESSES AND METHODS OF CARPHONE WAREHOUSE (CPW), EUROPE’S BIGGEST INDEPENDENT MOBILE RETAILER. IT AIMS TO PROPOSE VIABLE FUTURE STRATEGIES FOR THE BUSINESS BASED ON THE…

    • 7673 Words
    • 31 Pages
    Powerful Essays
  • Powerful Essays

    This paper will demonstrate my understanding of financial accounting and why generally accepted accounting principles (GAAP) are important. I will discuss how financial statements are used in the marketplace. I will describe each financial statement and tell what it reveals about the business. I will explain how the statements are linked and show examples. I will explain the notes to the financial statements. I will also explain why ratios are used and why they are important.…

    • 3301 Words
    • 14 Pages
    Powerful Essays
  • Satisfactory Essays

    | | BURBERRY | | | NEXT | | PROFITABILITY | | 2010 | 2009 | | 2010 | 2009 | Net Profit Margin | | 13.3% | 0.8% | | 15.6% | 14.6% | Gross Profit Margin | | 62.8% | 55.4% | | 29.3% | 27.8% | ROCE | | 26.8% | 1.7% | | 56.6% | 45.7% |…

    • 1568 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    4. Now complete the tables to develop pro forma financial statements for 1996 and 1998. In making these calculations, assume that the bank is willing to maintain the present credit lines and to grant the requested additional $12750000 of short-term credit effective January 1, 1996. In the analysis, take account of the amounts of inventory and accounts receivable that would be carried if inventory utilization and day’s sales outstanding were set at industry-average levels. also, assume in your forecast that all of SPC's plans and predictions concerning sales and expenses materialize , and that the firm pays no cash dividends during the forecast period. Finally, in your calculations use the cash marketable securities account as the residual balancing figure.…

    • 390 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Financial Statement Analysis

    • 2405 Words
    • 10 Pages

    The process of developing financial statements for a business is to provide supporting documentation to what has been reported as annual or quarterly income. Within the financial statement analysis strengths and weaknesses are identified through the comparison of data from the balance sheet. There are many different ways to interpret the data that is utilized for the analysis; those include but are not limited to comparative statements, schedule of changes in working capital, common size percentages, and ratio analysis. The following paper will be reviewing the financial data from Verizon Communications (VZ). Through the analysis review of the corporations financial and common size statements will be reviewed, as well as financial ratios, a trend analysis and in depth overview of the organization.…

    • 2405 Words
    • 10 Pages
    Powerful Essays
  • Better Essays

    Team E has been charge with the task of preparing an analysis to evaluate Microsoft and IBM’s financial performance. This will be done by using trends, financial ratio analysis, and the firms’ most recent statements of cash flow. Team E will evaluate each firm’s financial performance for the last two years by (1) performing financial ratio analysis, (2) performing trend analysis, and (3) compare and contrast the findings. Team E’s analysis will include:…

    • 2400 Words
    • 10 Pages
    Better Essays
  • Satisfactory Essays

    Financial management is important for any successful business. Good financial management requires proper planning and keeping up with the conditions of the business’ finances situation through ratio analysis and other performance measures. These analysis are done to ultimately keep up with the financial trends in a company and locate their strengths and weaknesses so they can be altered accordingly. In this paper we are going to perform a ratio analysis on Microsoft Corporation paying close attention to the organizations profitability, solvency, and efficiency ratios. We then will compare those ratios to the average ratios within their industry.…

    • 825 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    1. What are the factors that likely explain the difference between Microsoft’s market value of equity and its reported book value of equity?…

    • 935 Words
    • 4 Pages
    Powerful Essays