Industry Averages and Financial Ratios Paper

profileelsonm

Industry Averages and Financial Ratios Paper

 

  • Microsoft Corporation

Watch the Industry Averages and Financial Ratios video and use the industry classification from the financial services website to locate the company's SIC code on the U.S. Department of Labor's website.

 

Find the industry ratios for the company using the Dun & Bradstreet® Key Business Ratios link in the Week 2 Electronic Reserve Readings. If your company's SIC code does not appear in the dropdown menu, choose another company.

 

Assume the inventory ratio is based on a traditional inventory system, but globalized markets and the supply chain make it critical to adopt lean principles to create a more efficient system.

 

Calculate the 14 ratios (show your calculations) for the company using the two most recent annual financial statements found on the financial information website you used earlier. Be careful not to use quarterly information, and include ratios for both years.

 

Note. You can access a downloadable Ratio Guide PDF by clicking the Help Guide link in the upper-right of the Dun & Bradstreet® Key Business Ratios window.

 

Compare the ratios for the company you selected with the appropriate industry ratios including profitability, solvency, and efficiency ratios shown on the Dun & Bradstreet® report.

 

Write a 350-word response about how the company you selected performed compared with the industry.

 

 

 Company Quartiles 2009  2010  2011  
 Statement Sampling Samples: 0 Samples: 0 Samples: 0 
 Profitability & Return Measures UpperMedianLowerUpperMedianLowerUpperMedianLower 
Gross Margin (%)             
Net Profit Margin (%)            
Return on Equity (%)            
Return on Capital (%)            
Return on Assets (%)            
 Solvency UpperMedianLowerUpperMedianLowerUpperMedianLower 
Long Term Debt / Capital            
Long Term Debt / Equity            
Total Debt / Total Capital            
Net Debt / Equity             
Financial Leverage Ratio            
Total Debt / Common Equity            
Total Capital             
 Liquidity UpperMedianLowerUpperMedianLowerUpperMedianLower 
Current Ratio             
Quick Ratio             
 Working Capital UpperMedianLowerUpperMedianLowerUpperMedianLower 
Net Working Capital            
Days Receivable (DSO)            
 Management Effectiveness UpperMedianLowerUpperMedianLowerUpperMedianLower 
Asset Turnover             
Receivable Turnover            
Plant & Equipment Turnover            
Sales / Net Working Capital (times)            
Sales / Cash             
Sales / Inventory             
Sales / Working Capital            
Sales / Fixed Assets             
 Bank & Insurance Ratios UpperMedianLowerUpperMedianLowerUpperMedianLower 
Total Equity / Total Assets (Banks)            
Long Term Debt / Equity            
Net Profit Margin (%)            
Median Variance            
 Profitability & Return Measures Median20102011Median20092011Median20092010 
Gross Margin (%)000000000 
Net Profit Margin (%)000000000 
Return on Equity (%)000000000 
Return on Capital (%)000000000 
Return on Assets (%)000000000 
 Solvency Median20102011Median20092011Median20092010 
Long Term Debt / Capital000000000 
Long Term Debt / Equity000000000 
Total Debt / Total Capital000000000 
Net Debt / Equity000000000 
Financial Leverage Ratio000000000 
Total Debt / Common Equity000000000 
Total Capital000000000 
 Liquidity Median20102011Median20092011Median20092010 
Current Ratio000000000 
Quick Ratio000000000 
 Working Capital Median20102011Median20092011Median20092010 
Net Working Capital000000000 
Days Receivable (DSO)000000000 
 Management Effectiveness Median20102011Median20092011Median20092010 
Asset Turnover000000000 
Receivable Turnover000000000 
Plant & Equipment Turnover000000000 
Sales / Net Working Capital (times)000000000 
Sales / Cash000000000 
Sales / Inventory000000000 
Sales / Working Capital000000000 
Sales / Fixed Assets000000000 
 Bank & Insurance Ratios Median20102011Median20092011Median20092010 
Total Equity / Total Assets (Banks)000000000 
Long Term Debt / Equity000000000 
Net Profit Margin (%)000000000 
           
           
           

 

    • 11 years ago
    • 5
    Answer(0)
    Bids(0)