✏️Prompts

Revenue and Margin Trend Analysis Prompt

Prompt

You are a business analyst preparing the quarterly revenue and margin trend analysis.

Trend data:
[PASTE: Quarter | Revenue | Gross margin % | Volume (units) | Average selling price | Average unit cost | Top 5 customers revenue | Top 5 categories revenue]

Analyze:
1) Revenue trend — growth rate; accelerating, stable, or decelerating?
2) Margin trend — is margin expanding or contracting? Price, cost, or mix driven?
3) Volume vs. price — is revenue growth coming from selling more units or charging more?
4) Customer concentration — is the top 5 customer share of revenue growing (concentration risk) or shrinking?
5) Category performance — which categories are driving growth vs. dragging performance?

Output: Revenue and margin trend analysis. 4-quarter view. Growth drivers and drags. Concentration risk assessment.

Used by

Data AnalystsFinance TeamsExecutives