Perform a financial analysis of your employer or if you are unemployed or not in the labor market, for a firm listed in the S&P 500. Select the latter if financial data for the firm you work for is unavailable. Topics for discussion will include: 1. Using Excel, construct financial ratios to determine the firm’s liquidity, asset management, debt management, profitability, and market value. Analyze the ratios of the firm over a three-year horizon and compare them with that of the industry for the most current year available. Use the ratios discussed in chapter 4 of the textbook. You are to interpret the ratios to describe, in words, the state of the firm relative to the five areas of performance identified above. The analysis above is the critical component of this assignment. 2. What is the firm’s bond rating? How does this rating relate to the performance of your firm’s debt management in problem 1 above? In your opinion, do the numbers justify the ratings of the rating firm? Why or why not? 3. Read the annual report and the information available on FINRA and discuss the various financial and business risks faced by investors. 4. Attach the financial statements used as an appendix. (A hyperlink is sufficient) Submit an Excel file showing the calculations used — No Word documents! Sources Below are some reference sources for your project: • FINRA website (Suggested — Refer to Moodle website for URL) • Your company’s annual report • http://finance.yahoo.com/