Back to Skill Marketplace

Fundamentals & Valuation

Revenue Decomposition Engine

Decompose revenue into segment, volume, price, mix, and economic drivers, then quantify cross-segment effects and scenario sensitivity. Use when the user asks what is really driving top-line performance.

Reviewed by AlphioUpdated 26 days ago<1 min setup

Overview

Decompose revenue into segment, volume, price, mix, and economic drivers, then quantify cross-segment effects and scenario sensitivity.

Decompose revenue into segment, volume, price, mix, and economic drivers, then quantify cross-segment effects and scenario sensitivity.

Skill.md

How this skill works

Decompose revenue into segment, volume, price, mix, and economic drivers, then quantify cross-segment effects and scenario sensitivity. Use when the user asks what is really driving top-line performance.

SKILL.mdALPHIO / VERIFIED

Revenue Decomposition Engine

Use This Skill When

  • The user wants to know what actually drove top-line growth or deceleration.
  • Revenue moved in several directions at once across segment, product, customer, geography, or channel.
  • Reported growth may be flattered by easy comps, FX, M&A, pass-through pricing, or mix.
  • The investment question depends on whether growth is structural, cyclical, or low-quality.

Required Inputs

  • Company and time frame being analyzed, including whether the focus is quarter, year, or multi-year trend.
  • Reported revenue by segment, product, geography, or customer cohort when available.
  • Any disclosed price, volume, seat, usage, unit, shipment, or contract data.
  • Commentary on FX, acquisitions, divestitures, policy changes, or one-time items.
  • Optional but useful: peer data, channel checks, or macro indicators tied to demand.

Workflow

  1. Define the revenue architecture. Map how reported revenue is organized and which level of detail is investable.
  2. Reconcile the headline number. Separate reported growth into organic vs inorganic, FX vs constant currency, and recurring vs transactional where relevant.
  3. Build the driver bridge. Attribute growth to price, volume, mix, customer adds, retention, usage, cross-sell, new products, and external factors.
  4. Isolate offsets and interactions. Show which strong drivers were masking weakness elsewhere and whether mix helped or hurt.
  5. Classify driver quality. Distinguish durable drivers from transient ones such as one-off deals, channel fill, temporary pricing, or favorable compare periods.
  6. Stress the forward setup. Identify which drivers are likely to persist, normalize, reverse, or compound.

Output Requirements

  • Quantify the biggest drivers whenever source data supports it; if not, state directional confidence and why.
  • Reconcile the decomposition back to reported revenue growth so the bridge is internally consistent.
  • Separate facts, management assertions, and analyst inferences.
  • Make a clear call on growth quality: high, mixed, or low.
  • End with 2 to 4 monitoring points that would confirm or break the read.

Output Template

Revenue Decomposition

Setup

  • Company / period / reporting basis:
  • What revenue question is being answered:
  • What is included vs excluded from the analysis:

Revenue Architecture

  • Explain how the business makes money: segment, product, customer type, geography, and channel.
  • Note which buckets matter most to valuation and which reported buckets are too broad to be useful.

Growth Bridge

  • Headline growth:
  • Organic growth:
  • Main positive drivers: explain price, volume, mix, new logo, usage, or product effects.
  • Main negative drivers or offsets: explain churn, weakness by segment, normalization, FX, or tougher comps.
  • Include rough sizing or confidence labels for each driver.

Cross-Segment Effects

  • Identify where strength in one area masked deterioration in another.
  • Call out mix shifts that changed reported margins or quality of revenue.
  • Explain whether interactions are temporary accounting noise or real operating signal.

Quality of Growth

  • Durable drivers: describe why they should persist.
  • Lower-quality drivers: describe what is unlikely to repeat.
  • Management narrative vs evidence: note where commentary is well supported or weakly supported.

Forward Sensitivities

  • List the 3 most important variables for the next 2 to 4 quarters.
  • State what would cause growth to inflect up, flatten, or disappoint.
  • End with the single sentence buy-side conclusion on what is really driving the top line.

Quality Checks

  • The bridge adds up to the reported growth rate or clearly explains any residual.
  • Price, volume, mix, and inorganic items are not double-counted.
  • The analysis distinguishes structural demand from accounting, FX, or timing effects.
  • Segment commentary is ranked by importance, not reported in equal weight.
  • The final conclusion says whether growth quality is improving, stable, or deteriorating.

Guardrails

  • Do not label growth "strong" without saying which driver created it.
  • Do not treat pricing as high-quality if it is merely inflation pass-through with weak demand underneath.
  • Do not infer volume from revenue alone when mix or FX could explain the move.
  • Flag missing disclosures instead of filling gaps with fake precision.
  • Avoid management language like "healthy demand" unless backed by data.

Example Prompts

  • Decompose this company's revenue growth into price, volume, mix, and one-time factors.
  • Build a buy-side revenue bridge for the last four quarters and tell me what is durable.
  • Explain whether top-line acceleration came from real demand or easier comps and pricing.

Best used for

When to use it

Decompose revenue into segment, volume, price, mix, and economic drivers, then quantify cross-segment effects and scenario sensitivity. Use when the user asks what is really driving top-line performance.

01 · PRE-MEETING

Prepare a decision brief

The user wants to know what actually drove top-line growth or deceleration. Revenue moved in several directions at once across segment, product, customer, geography, or channel. Reported growth may be flattered by easy comps, FX, M&A, pass-through pricing, or mix. The investment question depends on whether growth is structural, cyclical, or low-quality.

02 · TEAM WORKFLOW

Standardize handoffs

Create consistent research outputs across analysts, portfolio managers, and agents.

03 · LIVE UPDATE

Refresh the thesis

Update scenarios after a new catalyst, KPI release, or earnings result.

Community notes

Built to improve with use.

Feedback will appear here as this skill is used and reviewed.

Leave feedback

Discover more

Related skills

View all
Get Started