Vantage Analytics: Profits Down Despite Flat Revenue
Vantage Analytics is a B2B SaaS business in India. The CEO has asked for help understanding a sharp fall in profitability.
Revenue moved from ₹1189 Cr to ₹1177 Cr over the past year, while operating margin fell from 20% to 17% — a drop of 3 percentage points and roughly ₹38 Cr of operating profit.
What the finance team has established so far:
- Sales volume changed by -3%
- Average realised price changed by -2%
- Input costs per unit rose 17%
- Fixed overhead rose 8%
The COO believes the problem is "the sales team discounting too aggressively". The Head of Sales believes it is "procurement failing to control input costs". The CEO wants an evidence-based answer, not an argument.
drivers
- volume change pct
- -3
- fixed overhead change pct
- 8
- realised price change pct
- -2
- input cost per unit change pct
- 17
profit bridge
- revenue last year cr
- 1189
- revenue this year cr
- 1177
- operating margin last pct
- 20
- operating margin this pct
- 17
Diagnose the profit decline and recommend a response. Provide:
- Analysis — structure the problem and isolate what actually drove the margin fall.
- Risks — what your recommendation depends on.
- Recommendation — prioritised actions with expected impact.
Show the arithmetic behind your conclusion.
100 points, 60% to pass.
- root cause25
- recommendation25
- problem structuring25
- quantitative analysis25
Reveal suggested structure
Profit = (Price × Volume) − (Variable cost × Volume) − Fixed cost
- Decompose the change: how much of the margin fall is price, how much volume, how much unit cost, how much overhead?
- Size each driver before forming a hypothesis.
- Test the two stakeholder claims against the numbers.
- Prioritise by size of impact and speed of fix.