Task:
Each student will perform Vertical Analysis (VA) and Horizontal Analysis (HA) for both the Balance Sheet and the Income Statement of Lululemon Athletica Inc. and individually submit their excel workbook.
Requirements:
1. Submit one Excel workbook with two separate tabs:
- Balance Sheet (VA & HA)
- Income Statement (VA & HA)
2. Include two years of analysis that spans three years for both the Balance Sheet and Income Statement using Crocs, Inc.s 2025 and 2024 annual 10-K filings.
3. Vertical Analysis (VA):
- Balance Sheet each line item as a % of Total Assets
- Income Statement each line item as a % of Total Revenue
- Must use formulas to calculate percentages (no hard-coded values)
4. Horizontal Analysis (HA):
- Include columns for both dollar changes and percentage changes from one year to the next.
- Must use formulas for all changes.
Points (16 total):
- Balance Sheet VA = 4 points
- Balance Sheet HA = 4 points
- Income Statement VA = 4 points
- Income Statement HA = 4 points
Presentation & Accuracy:
- Workbook and colmuns must be clearly labeled, organized, and easy to read.
- All formulas must be correct and consistently applied.
Requirements: however long it says

Leave a Reply
You must be logged in to post a comment.