segment-rollup

name	segment-rollup
description	Use when modeling a multi-segment company that discloses segment net sales and segment Adjusted EBITDA (ASU 2023-07) but not segment COGS or operating income - rolls segment P&Ls into a consolidated forecast and reconciles total segment Adjusted EBITDA to the disclosed total. Generated for Fox Factory (PVG/AAG/SSG).

Segment Roll-Up (generated for Fox Factory)

Why this skill exists

The standard openfpa skills model a single entity. Fox Factory reports three segments (PVG, AAG, SSG) and, under ASU 2023-07, discloses net sales and Adjusted EBITDA per segment - but not segment COGS or operating income (.fpa/business-profile.md). The base engine has no segment concept, so this skill was generated to bridge the gap. It cites these profile facts:

• Three reportable segments; segment metric is Adjusted EBITDA, not gross profit.
• Segment-level working capital, debt, and tax are not disclosed - those stay consolidated. So segments drive the P&L down to Adjusted EBITDA only; the consolidated layer owns everything below.

The model shape

segment net sales + Adj EBITDA margin  (PVG, AAG, SSG)
        │  roll_up_segments()            → total net sales + total Adj EBITDA
        │  segments_to_channels(cogs_pct)→ revenue channels for the engine
        ▼
consolidated EntityConfig (blended COGS%, opex, D&A, capex, WC days, debt, tax)
        │  cashflow_from_config()
        ▼
consolidated P&L + indirect cash flow (revenue → … → FCF)

How to use

1. Build one pyfpa.Segment per segment from disclosed net sales and Adjusted-EBITDA margin (adjusted_ebitda / net_sales).
2. roll_up_segments(segments) → total net sales + total Adjusted EBITDA. Reconcile that total to the disclosed segment-footnote total - it must tie.
3. segments_to_channels(segments, cogs_pct=<consolidated blended rate>) → revenue channels. The blended COGS% is applied to every segment (segment COGS isn't disclosed), so the channels sum back to consolidated COGS by construction.
4. Feed the channels into a consolidated EntityConfig and run cashflow_from_config. Set the single adjusted_opex line to gross_profit − total_adjusted_ebitda so engine EBITDA ties to segment Adj EBITDA.
5. Keep the goodwill impairment and discrete tax items out of the engine and in a documented bridge to GAAP net income - the lean engine models the operating business, not one-time non-cash charges.

Reference implementation

examples/foxfactory/foxf_model.py (reconciliation_config, phase_a_model, forecast_year) and pyfpa.analysis.segments.

Guardrail

This skill lives in the client's skills/generated/ namespace - it is specific to a three-segment, Adjusted-EBITDA-reporting company and must never be promoted into the public openfpa template.