Financial Statement Analysis

Background:
You are to determine the financial ratios of the company and explain if they support the business strategy or if they indicate something that needs further analysis.

Deliverables:
This is an individual assignment. You will be expected to have someone peer review your work. Submit your Word file with your write up and your Excel file with your calculations by email. Make sure to label your files “Project 1_your name”.

Your Task:

Part 1: Financial Statement Analysis
• Pick a publicly listed company
• Go to https://finance.yahoo.com and search for your company either by name or ticker
• Then select “Financials” to see the Income Statement and Balance Sheet for the last years
• Mark the ANNUAL income statements and balance sheets and copy them into separate sheets in Excel; name the sheets accordingly
• For all four years of annual statements, at a minimum calculate the following ratios in a separate sheet. DO other ratios if it adds to the analysis.
Do all your calculations in Excel! See your notes/the textbook for the formulas.
• Liquidity ratios:
• Current ratio
• Quick ratio
• Leverage ratios:
• Total debt ratio
• Turnover ratios:
• Inventory turnover
• Receivables turnover
• Total asset turnover

• Profitability ratios:
• Profit margin
• Return on assets
• Return on equity
• Provide a brief summary of the company’s key startegies.
• Using the ratios for the most recent year (2018), discuss the financial health of the company. Your discussion should include your conclusions regarding its liquidity, indebtedness, efficiency with which it uses its assets and profitability. Link the ratios back to the business strategy and indicate if the ratios support the strategy or indicate areas of concern.
• Conduct a time-trend analysis and compare each ratio over the four years. Did the liquidity, leverage, asset utilization and profitability improve or deteriorate over time? Discuss your findings and does the tine-trend of the ratios support the strategy or indicate areas of concern.

• Based on your financial statement analysis, do the ratios and time trend look reasonable or do they indicate issues.