look-02-cost-structure

To calculate expense ratios and detect cost-structure mismatches, derive four key expense ratios (sales, admin, financial, R&D) from consolidated annual reports and flag years where expense growth misaligns with revenue growth.

You need consolidated annual financial reports filtered by an end_date of Dec 31, visible as of your target date, to compute annual cost-structure indicators and derive the four expense ratios with their year-over-year changes.

Yes, you can use DuckDB to backtest cost-structure rules across multiple years by querying consolidated annual reports, calculating expense ratios, and validating revenue-expense alignment over your configured lookback period.

Yes, the cost-structure analysis output supports JSON formats for downstream automation, returning both markdown and JSON payloads containing yearly expense ratios and growth-mismatch evidences for your target stock.

Filtering annual reports to an end_date of Dec 31 ensures accurate expense ratio computation by standardizing annual aggregation, preventing mixed periods from skewing the year-over-year changes and cost-structure mismatch alerts.