Arrow Electronics, Inc. (ARW) Margin Analysis

Arrow Electronics, Inc.

ARW (NYSE)

(%)

Models
Arrow Electronics, Inc. Margin Analysis

# --- Years and Quarters
assumptions.set({
    "timeseries": "annual",
    "data": {
        "#years": """
            4
        """,
        "#quarters": """
            8
        """,
    },
    "titles": {
        "#years": "Years",
        "#quarters": "Quarters",
    },
    "properties": {
        "width": "responsive",
        "title": "Years and Quarters",
        "id": "component-1",
        "bindTo": None
    },
    "descriptions": {
        "#years": r"""
The number of historical years used to render the annual chart and tables.
        """,
        "#quarters": r"""
The number of historical quarters used to render the quarterly chart and tables.
        """,
    }
})

# Render description block
model.render_description({
    "data": r"""
## Margin Analysis Report

Margins refer to the ratio between a financial report item and the revenue (example: Net Income Margin = Net Income / Revenue).

This analysis provides annual and quarterly sections for reporting key financial margins.
""",
    "properties": {
        "width": "responsive"
    }
})

# Render description block
model.render_description({
    "data": r"""
## Annual Section

The annual section uses annual data to calculate margins and growth rates.
""",
    "properties": {
        "width": "full"
    }
})

# --- Income Statement Margins
data.compute({
    "user:%revenueGrowthRate": """
        ( income:revenue / income:revenue:-1 ) - 1
    """,
    "user:%grossMargin": """
        income:grossProfit / income:revenue
    """,
    "user:%operatingMargin": """
        income:operatingIncome / income:revenue
    """,
    "user:%netMargin": """
        income:netIncome / income:revenue
    """,
}, forecast=0, timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "income:revenue": "Revenue",
        "user:%revenueGrowthRate": "Revenue Growth Rate",
        "income:costOfRevenue": "Cost of Revenue",
        "income:grossProfit": "Gross Profit",
        "user:%grossMargin": "Gross Margin",
        "income:operatingIncome": "Operating Income",
        "user:%operatingMargin": "Operating Margin",
        "income:netIncome": "Net Income",
        "user:%netMargin": "Net Margin",
    },
    "start": data.get("""
        -assumption:#years
    """),
    "end": 0,
    "properties": {
        "title": "Income Statement Margins",
        "order": "descending",
        "number_format": "M",
        "include_ltm": True,
        "display_averages": False,
        "width": "responsive"
    }
})

# --- Cash Flow Statement Margins
data.compute({
    "user:%cashFromOperatingActivitiesMargin": """
        flow:netCashProvidedByOperatingActivities / income:revenue
    """,
    "user:%freeCashFlowMargin": """
        flow:freeCashFlow / income:revenue
    """,
    "user:%depreciationAndAmortizationMargin": """
        flow:depreciationAndAmortization / income:revenue
    """,
    "user:%capitalExpenditureMargin": """
        flow:capitalExpenditure / income:revenue
    """,
}, forecast=0, timeseries="annual")

model.render_table({
    "timeseries": "annual",
    "data": {
        "income:revenue": "Revenue",
        "flow:netCashProvidedByOperatingActivities": "Cash from Operating Activities",
        "user:%cashFromOperatingActivitiesMargin": "Cash from Operating Activities Margin",
        "flow:freeCashFlow": "Free Cash Flow",
        "user:%freeCashFlowMargin": "Free Cash Flow Margin",
        "flow:depreciationAndAmortization": "Depreciation and Amortization",
        "user:%depreciationAndAmortizationMargin": "Depreciation and Amortization Margin",
        "flow:capitalExpenditure": "Capital Expenditure",
        "user:%capitalExpenditureMargin": "Capital Expenditure Margin",
    },
    "start": data.get("""
        -assumption:#years
    """),
    "end": 0,
    "properties": {
        "title": "Cash Flow Statement Margins",
        "order": "descending",
        "number_format": "M",
        "include_ltm": True,
        "display_averages": False,
        "width": "responsive"
    }
})

model.render_chart({
    "timeseries": "annual",
    "data": {
        "user:%grossMargin": "Gross Margin",
        "user:%operatingMargin": "Operating Margin",
        "user:%netMargin": "Net Margin",
        "user:%freeCashFlowMargin": "Free Cash Flow Margin",
    },
    "start": data.get("""
        -assumption:#years
    """),
    "end": 0,
    "properties": {
        "title": "Annual Chart",
        "include_ltm": False,
        "set_editable": [],
        "hidden_keys": [],
        "bar_keys": ["user:%grossMargin", "user:%operatingMargin", "user:%netMargin", "user:%freeCashFlowMargin"],
        "width": "full"
    }
})

# Render description block
model.render_description({
    "data": r"""
## Quarterly Section

The quarterly section uses quarterly data to calculate margins and growth rates.
""",
    "properties": {
        "width": "full"
    }
})

model.render_table({
    "timeseries": "quarterly",
    "data": {
        "income:revenue": "Revenue",
        "user:%revenueGrowthRate": "Revenue Growth Rate",
        "income:costOfRevenue": "Cost of Revenue",
        "income:grossProfit": "Gross Profit",
        "user:%grossMargin": "Gross Margin",
        "income:operatingIncome": "Operating Income",
        "user:%operatingMargin": "Operating Margin",
        "income:netIncome": "Net Income",
        "user:%netMargin": "Net Margin",
    },
    "start": data.get("""
        -assumption:#quarters
    """),
    "end": 0,
    "properties": {
        "title": "Income Statement Margins",
        "order": "descending",
        "number_format": "M",
        "display_averages": False,
        "width": "responsive"
    }
})

model.render_table({
    "timeseries": "quarterly",
    "data": {
        "income:revenue": "Revenue",
        "flow:netCashProvidedByOperatingActivities": "Cash from Operating Activities",
        "user:%cashFromOperatingActivitiesMargin": "Cash from Operating Activities Margin",
        "flow:freeCashFlow": "Free Cash Flow",
        "user:%freeCashFlowMargin": "Free Cash Flow Margin",
        "flow:depreciationAndAmortization": "Depreciation and Amortization",
        "user:%depreciationAndAmortizationMargin": "Depreciation and Amortization Margin",
        "flow:capitalExpenditure": "Capital Expenditure",
        "user:%capitalExpenditureMargin": "Capital Expenditure Margin",
    },
    "start": data.get("""
        -assumption:#quarters
    """),
    "end": 0,
    "properties": {
        "title": "Cash Flow Statement Margins",
        "order": "descending",
        "number_format": "M",
        "display_averages": False,
        "width": "responsive"
    }
})

model.render_chart({
    "timeseries": "quarterly",
    "data": {
        "user:%grossMargin": "Gross Margin",
        "user:%operatingMargin": "Operating Margin",
        "user:%netMargin": "Net Margin",
        "user:%freeCashFlowMargin": "Free Cash Flow Margin",
    },
    "start": data.get("""
        -assumption:#quarters
    """),
    "end": 0,
    "properties": {
        "title": "Quarterly Chart",
        "set_editable": [],
        "hidden_keys": [],
        "bar_keys": ["user:%grossMargin", "user:%operatingMargin", "user:%netMargin", "user:%freeCashFlowMargin"],
        "width": "full"
    }
})

Years and Quarters

Years Years The number of historical years used to render the annual chart and tables.	#
Quarters Quarters The number of historical quarters used to render the quarterly chart and tables.	#

Margin Analysis Report

Margins refer to the ratio between a financial report item and the revenue (example: Net Income Margin = Net Income / Revenue).

This analysis provides annual and quarterly sections for reporting key financial margins.

Annual Section

The annual section uses annual data to calculate margins and growth rates.

Income Statement Margins

Monetary values in USD amounts except #	LTM Mar 15	2025 Dec 31	2024 Dec 31	2023 Dec 31	2022 Dec 31
Revenue	30,853	30,853	27,923	33,107	37,124
Revenue Growth Rate	0%	10.49%	-15.66%	-10.82%	7.68%
Cost of Revenue	27,420	27,524	24,631	28,958	32,288
Gross Profit	3,433	3,329	3,292	4,149	4,837
Gross Margin	11.13%	10.79%	11.79%	12.53%	13.03%
Operating Income	863.5	938.3	768.6	1,471	2,068
Operating Margin	2.8%	3.04%	2.75%	4.44%	5.57%
Net Income	571.3	571.3	392.1	903.5	1,427
Net Margin	1.85%	1.85%	1.4%	2.73%	3.84%

Cash Flow Statement Margins

Monetary values in USD amounts except #	LTM Mar 15	2025 Dec 31	2024 Dec 31	2023 Dec 31	2022 Dec 31
Revenue	30,853	30,853	27,923	33,107	37,124
Cash from Operating Activities	64.05	64.05	1,130	705.4	-33.08
Cash from Operating Activities Margin	0.208%	0.208%	4.05%	2.13%	-0.089%
Free Cash Flow	36.67	-37.2	1,038	622.2	-111.9
Free Cash Flow Margin	0.119%	-0.121%	3.72%	1.88%	-0.301%
Depreciation and Amortization	137.8	137.8	163	181.1	187.4
Depreciation and Amortization Margin	0.446%	0.446%	0.584%	0.547%	0.505%
Capital Expenditure	-27.38	-101.3	-92.7	-83.28	-78.84
Capital Expenditure Margin	-0.089%	-0.328%	-0.332%	-0.252%	-0.212%

Annual Chart

Monetary values in USD

{"sectionId": "section-chart-1", "sectionType": "chart", "title": "Annual Chart", "timeseries": "annual", "series": [{"label": "Gross Margin", "mappingKey": "user:%grossMargin", "data": [{"l": "2022", "x": "2022-12-31", "y": 13.03}, {"l": "2023", "x": "2023-12-31", "y": 12.53}, {"l": "2024", "x": "2024-12-31", "y": 11.79}, {"l": "2025", "x": "2025-12-31", "y": 10.79}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "annual", "hidden": false}, {"label": "Operating Margin", "mappingKey": "user:%operatingMargin", "data": [{"l": "2022", "x": "2022-12-31", "y": 5.57}, {"l": "2023", "x": "2023-12-31", "y": 4.44}, {"l": "2024", "x": "2024-12-31", "y": 2.75}, {"l": "2025", "x": "2025-12-31", "y": 3.04}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "annual", "hidden": false}, {"label": "Net Margin", "mappingKey": "user:%netMargin", "data": [{"l": "2022", "x": "2022-12-31", "y": 3.84}, {"l": "2023", "x": "2023-12-31", "y": 2.73}, {"l": "2024", "x": "2024-12-31", "y": 1.4}, {"l": "2025", "x": "2025-12-31", "y": 1.85}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "annual", "hidden": false}, {"label": "Free Cash Flow Margin", "mappingKey": "user:%freeCashFlowMargin", "data": [{"l": "2022", "x": "2022-12-31", "y": -0.301}, {"l": "2023", "x": "2023-12-31", "y": 1.88}, {"l": "2024", "x": "2024-12-31", "y": 3.72}, {"l": "2025", "x": "2025-12-31", "y": -0.121}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "annual", "hidden": false}], "editableDates": {}, "properties": {"display_table": false}, "width": "full"}

Quarterly Section

The quarterly section uses quarterly data to calculate margins and growth rates.

Income Statement Margins

Monetary values in USD amounts except #	2025 (Q4) Dec 31	2025 (Q3) Sep 27	2025 (Q2) Jun 28	2025 (Q1) Mar 29	2024 (Q4) Dec 31	2024 (Q3) Sep 28
Revenue	8,746	7,713	7,580	6,814	7,283	6,823
Revenue Growth Rate	13.41%	1.75%	11.24%	-6.44%	6.73%
Cost of Revenue	7,772	6,877	6,731	6,040	6,480	6,038
Gross Profit	974.8	835.3	848.7	774	803.3	784.8
Gross Margin	11.14%	10.83%	11.2%	11.36%	11.03%	11.5%
Operating Income	335.3	179	190.6	158.6	195.1	175.3
Operating Margin	3.83%	2.32%	2.51%	2.33%	2.68%	2.57%
Net Income	194.6	109.2	187.7	79.72	99.21	100.6
Net Margin	2.23%	1.42%	2.48%	1.17%	1.36%	1.47%

Cash Flow Statement Margins

Monetary values in USD amounts except #	2025 (Q4) Dec 31	2025 (Q3) Sep 27	2025 (Q2) Jun 28	2025 (Q1) Mar 29	2024 (Q4) Dec 31	2024 (Q3) Sep 28
Revenue	8,746	7,713	7,580	6,814	7,283	6,823
Cash from Operating Activities	199.9	-281.7	-205.9	351.7	326.5	80.56
Cash from Operating Activities Margin	2.29%	-3.65%	-2.72%	5.16%	4.48%	1.18%
Free Cash Flow	172.6	-238.1	-224.5	326.7	303.9	62.04
Free Cash Flow Margin	1.97%	-3.09%	-2.96%	4.79%	4.17%	0.909%
Depreciation and Amortization	33.98	32.79	35.16	35.81	39.64	40.59
Depreciation and Amortization Margin	0.389%	0.425%	0.464%	0.526%	0.544%	0.595%
Capital Expenditure	-27.38	43.6	-18.62	-24.98	-22.55	-18.52
Capital Expenditure Margin	-0.313%	0.565%	-0.246%	-0.367%	-0.31%	-0.271%

Quarterly Chart

Monetary values in USD

{"sectionId": "section-chart-2", "sectionType": "chart", "title": "Quarterly Chart", "timeseries": "quarterly", "series": [{"label": "Gross Margin", "mappingKey": "user:%grossMargin", "data": [{"l": "2024 (Q3)", "x": "2024-09-28", "y": 11.5}, {"l": "2024 (Q4)", "x": "2024-12-31", "y": 11.03}, {"l": "2025 (Q1)", "x": "2025-03-29", "y": 11.36}, {"l": "2025 (Q2)", "x": "2025-06-28", "y": 11.2}, {"l": "2025 (Q3)", "x": "2025-09-27", "y": 10.83}, {"l": "2025 (Q4)", "x": "2025-12-31", "y": 11.14}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}, {"label": "Operating Margin", "mappingKey": "user:%operatingMargin", "data": [{"l": "2024 (Q3)", "x": "2024-09-28", "y": 2.57}, {"l": "2024 (Q4)", "x": "2024-12-31", "y": 2.68}, {"l": "2025 (Q1)", "x": "2025-03-29", "y": 2.33}, {"l": "2025 (Q2)", "x": "2025-06-28", "y": 2.51}, {"l": "2025 (Q3)", "x": "2025-09-27", "y": 2.32}, {"l": "2025 (Q4)", "x": "2025-12-31", "y": 3.83}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}, {"label": "Net Margin", "mappingKey": "user:%netMargin", "data": [{"l": "2024 (Q3)", "x": "2024-09-28", "y": 1.47}, {"l": "2024 (Q4)", "x": "2024-12-31", "y": 1.36}, {"l": "2025 (Q1)", "x": "2025-03-29", "y": 1.17}, {"l": "2025 (Q2)", "x": "2025-06-28", "y": 2.48}, {"l": "2025 (Q3)", "x": "2025-09-27", "y": 1.42}, {"l": "2025 (Q4)", "x": "2025-12-31", "y": 2.22}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}, {"label": "Free Cash Flow Margin", "mappingKey": "user:%freeCashFlowMargin", "data": [{"l": "2024 (Q3)", "x": "2024-09-28", "y": 0.909}, {"l": "2024 (Q4)", "x": "2024-12-31", "y": 4.17}, {"l": "2025 (Q1)", "x": "2025-03-29", "y": 4.79}, {"l": "2025 (Q2)", "x": "2025-06-28", "y": -2.96}, {"l": "2025 (Q3)", "x": "2025-09-27", "y": -3.09}, {"l": "2025 (Q4)", "x": "2025-12-31", "y": 1.97}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}], "editableDates": {}, "properties": {"display_table": false}, "width": "full"}