earnings margin momentum analyzer

The problem

Manually calculating margin trends and efficiency ratios from financial statements is slow and prone to spreadsheet errors. Analysts often struggle to distinguish between temporary spikes and genuine operational momentum across multiple reporting periods.

What it does

• Calculates multi-period Gross, EBITDA, and EBIT margins using standardized formulas.
• Measures operational efficiency through revenue per employee, asset turnover, and OpEx ratios.
• Quantifies geographic risk using the Herfindahl-Hirschman Index (HHI) for revenue concentration.
• Identifies margin momentum by comparing latest performance against historical averages to detect acceleration or deceleration.
• Structures findings into a standardized report covering growth, efficiency, and key risk items.

Why this beats prompting it yourself

Generic prompts often miss subtle margin distortions or fail to apply consistent period-over-period comparisons. This skill enforces rigorous financial logic, including EBITDA estimation when missing and HHI calculations for concentration risk, ensuring a professional-grade analysis every time.

Use cases

• Conducting due diligence on a target company's historical profitability trends.
• Benchmarking internal quarterly performance against historical efficiency metrics.
• Identifying geographic concentration risks during portfolio reviews.
• Analyzing operating leverage and margin sustainability for earnings reports.

Known limitations

Requires income statements and geographic revenue breakdowns for full utility. Does not provide forward-looking guidance or valuation modeling.