Complete the attached Financial Ratio Analysis Report with attendant comments following the guidelines below: a. Obtain financial information for a Fortune 500 company (include them with your report). b. Prepare a 2-year trend table of the financial ratios presented in Table 1 for your selected company. Include a brief discussion for one ratio in each category you

c. Compare the ratios calculated against industry averages or a specific competitor for the last fiscal year (2019). d. For a ratio calculated (you need only choose one), write a paragraph interpreting the trends and identify strengths and weaknesses. e. Assess describe the financial condition of the company in 2 or 3 paragraphs f. Briefly discuss other factors beyond the ratios that need to be considered in the assessment of the companys health. g. Identify possible problems you see this company facing in the next year that would require further analysis and exploration. You can copy and paste into Excel:

Table 1	2006	2007	Peer	Competitor Company YYY
Financial Statement company
Coefficients
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