Analyze Starbucks financial statements for the prior five years. Include the following items as supplemental schedules to the analysis, prepared as individual worksheets within an Excel spreadsheet:
- Horizontal analysis of the prior five years' income statement and balance sheet.
- Vertical analysis of the prior five years' income statement and balance sheet.
- Calculation of at least five significant liquidity ratios for each of the five years analyzed.
- Calculation of at least five significant profitability ratios for each of the five years analyzed.
- Calculation of at least five significant long-term debt-paying ratios for each of the five years analyzed.
- Calculation of at least five significant investor ratios for each of the five years analyzed.
Prepare a paper (10-15 pages) that analyzes the financial strengths and weaknesses of the company examined.
1. Reference significant items found on the income statement, balance sheet, and statement of cash flows (2 pages min.)
2. Reference significant items found in the horizontal analysis and vertical analysis (2 pages min.)
3. Reference significant items found in the ratio analysis (2 pages min.)
4. Competitor analysis and comparison to industry averages (2 pages min.)
5. Summary identifying whether the company would be attractive to investors and/or creditors (2 pages min.)