Assignment: Complete and submit a 1,400-2,100-word Financial Ratio Analysis Report following the guidelines below:
1) Obtain financial information for a Fortune 500 company. You should begin by obtaining the annual reports for the company (include them with your report). .
2) Prepare a 3 year trend table of the financial ratios presented in Table for your selected company. Include a brief rationale for each ratio you have calculated.
3) Compare the ratios calculated against industry averages.
4) For each ratio calculated, write a paragraph interpreting the trends and identify strengths and weaknesses.
5) Assess the financial condition of the company.
6) Discuss other factors beyond the ratios that need to be considered in the assessment of the company’s health.
7) Discuss how your assessment compares to what management is telling the shareholders in the annual report.
8) Identify possible problems you see this company facing in the next year that would require further analysis and exploration.
Table
|
Financial statement Company XXX
|
Coefficients
|
2004
|
2005
|
2006
|
Competitor Company "YYY"
|
|
|
|
|
|
Leverage ratios
|
|
|
|
|
Long-term debt ratio
|
|
|
|
|
Debt-equity ratio
|
|
|
|
|
Total debt ratio
|
|
|
|
|
Times interest earned
|
|
|
|
|
Cash coverage ratio
|
|
|
|
|
|
|
|
|
|
Liquidity
|
|
|
|
|
NWC to assets
|
|
|
|
|
Current ratio
|
|
|
|
|
Quick ratio
|
|
|
|
|
Cash ratio
|
|
|
|
|
Interval measure
|
|
|
|
|
|
|
|
|
|
Efficiency ratios
|
|
|
|
|
Total asset turnover
|
|
|
|
|
Average collection period
|
|
|
|
|
Inventory turnover
|
|
|
|
|
Days' sales in inventories
|
|
|
|
|
|
|
|
|
|
Profitability ratios
|
|
|
|
|
Net profit margin
|
|
|
|
|
Return on assets
|
|
|
|
|
Return on equity
|
|
|
|
|
Payout ratio
|
|
|
|
|
Plowback ratio
|
|
|
|
|
Growth in equity from plowback
|
|
|
|
|