See attached

Overview:

In the discussion this week, you selected a publicly traded company to research. In this Financial Analysis assignment, you will obtain your company's key financial ratios and create an Excel worksheet. 

Instructions:

Using the company that you chose in this week's Discussion, develop a ratio analysis using the Mergent Database and Excel.

1. Create an Excel worksheet that lists all downloaded (+/- 20) financial ratios, the calculations, and the purpose of each ratio.  (This is general, and not specific to your company’s performance.)

   1. Include the following headings in your worksheet.

      Ratio	Calculation	Purpose
      Name of ratio	How it is calculated	What does the ratio measure? If the ratio increases, does this mean the company is improving or declining?

   2.  

2. Save your worksheet.

3. If you have not already done so, follow the instructions in the Ratios section on page 4 of the Mergent Online Database Instructions.docx to download the Ratios worksheet for your company (link located under the assignment title above).

4. For the ratio analysis, use the worksheet you created and the Ratios worksheet that you saved from Mergent.

5. How did your company perform over time in regard to the following ratios?  (This is separate from above, and specific to your company’s performance.) 
   

   1. Current Ratio

   2. Inventory Turnover – if your company does not have inventory, use Receivables Turnover or Accounts Payable Turnover

   3. Total Debt to Equity

   4. Return on Equity (ROE)

   5. Book Value Per Share

6. Document your analysis on the Mergent Ratio Worksheet

7. Submit your file to this assignment area.