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