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

 

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.)
Include the following headings in your worksheet.

If you have not already done so, follow the instructions in the Ratios section on page 4 of the Mergent Online Database Instructions.docx Open this document with ReadSpeaker docReader Download Mergent Online Database Instructions.docxOpen this document with ReadSpeaker docReaderto download the Ratios worksheet for your company.
For the ratio analysis, use the worksheet you created and the Ratios worksheet that you saved from Mergent.
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.)

Current Ratio

Inventory Turnover – if your company does not have inventory, use Receivables Turnover or Accounts Payable Turnover
Total Debt to Equity
Return on Equity (ROE)
Book Value Per Share

Document your analysis on the Mergent Ratio Worksheet