Selected Company- Microsoft

Peer Company- Select any one from it.

Please show all the calculations.

(http://money.cnn.com/data/dow30/ )

AT&T 11:32 AM 97%-. BUS510 Project . This project may be completed as an individual or a group with a maximum number of 2 people. Select a firm and post it to the Discussion Board on Module 4. Before you post, check that the firm is not already selected. Duplicate firms are not permitted. With your post include your partners name if you decide to complete this project as a group. Firms selected must also be part of the Dow Jones 30 (Do not choose a financial company and you may not choose Nike). . From Hoovers (you may need to refer to your company's annual report if data is missing): Due A) Collect three years of the most recent data from selected firm. Include this original data in your excel sheet. Post the Balance sheet first and then the Income Statement data. statements,_calculate the financial ratios (listed in the tables provided in the previous lecture). Calculate the ratios for your firm for all three years (all calculations must be shown). cUse the Hoovers database to collect information on a peer or group of peer competitors. Use the competitor's data to calculate peer ratios for the most recent period. D) In the excel sheet, next to each ratio, compare the company ratios over time (trend analysis) and with respect to the competitor ratios (peer analysis). Based on these comparisons, determine whether the company is doing well or not over time and relative to a peer. In your analysis include 1-2 sentences indicating you understand the meaning of the ratio and what it tells AT&T 11:32 AM 97%-. BUS510 Project . This project may be completed as an individual or a group with a maximum number of 2 people. Select a firm and post it to the Discussion Board on Module 4. Before you post, check that the firm is not already selected. Duplicate firms are not permitted. With your post include your partners name if you decide to complete this project as a group. Firms selected must also be part of the Dow Jones 30 (Do not choose a financial company and you may not choose Nike). . From Hoovers (you may need to refer to your company's annual report if data is missing): Due A) Collect three years of the most recent data from selected firm. Include this original data in your excel sheet. Post the Balance sheet first and then the Income Statement data. statements,_calculate the financial ratios (listed in the tables provided in the previous lecture). Calculate the ratios for your firm for all three years (all calculations must be shown). cUse the Hoovers database to collect information on a peer or group of peer competitors. Use the competitor's data to calculate peer ratios for the most recent period. D) In the excel sheet, next to each ratio, compare the company ratios over time (trend analysis) and with respect to the competitor ratios (peer analysis). Based on these comparisons, determine whether the company is doing well or not over time and relative to a peer. In your analysis include 1-2 sentences indicating you understand the meaning of the ratio and what it tells