OtherSample model
ESG ROI & Value-Creation Model
View case study
Back to all work
OtherClient engagement
Multi-Year Income Statement Analysis
A segment-level 5-year income statement with common-size, trend, and a 16-metric ratio suite.
Shown anonymised at the client's request.
- Client
- Confidential
- Our role
- Financial Analyst
The engagement
The client needed to understand not just whether revenue and margins were growing, but which segments were driving, or dragging, performance over time.
What we built
A 5-tab analysis: the segment-level 5-year income statement, a vertical (common-size) analysis, a horizontal (year-over-year) analysis, a 16-metric ratio suite, and supporting charts.
The outcome
A complete, chart-backed picture of profitability and margin trends by segment across five years.
Deliverables
- 5-year income statement
- Vertical analysis
- Horizontal analysis
- Ratio analysis
- Supporting charts
Skills & tools
- Income Statement Analysis
- P&L Modeling
- Common-Size Analysis
- Trend Analysis
- Ratio Analysis
- Segment Reporting
- Data Visualization
- Advanced Excel
Deliverable (view only)
ProtectedMulti-Year Income Statement Analysis
Opens in a distraction free, full screen reader. View only, no download.
Downloading, printing and copying are disabled. All work is the property of A&S Financial Consultants and its clients.
Discuss a similar model
Book a free scoping call and we will map out the model your business needs. Available 9:00 AM to 8:00 PM EST, Mon to Fri.
More work
