Albertsons Companies, Inc. (ACI) Margin Analysis

Albertsons Companies, Inc.

ACI (NYSE)

(%)

Models
Albertsons Companies, 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 09	2024 Feb 22	2023 Feb 28	2022 Feb 28	2021 Feb 28
Revenue	81,720	80,391	79,238	77,650	71,887
Revenue Growth Rate	1.65%	1.46%	2.04%	8.02%	3.15%
Cost of Revenue	59,477	58,135	57,192	55,894	51,165
Gross Profit	22,243	22,256	22,046	21,756	20,722
Gross Margin	27.22%	27.68%	27.82%	28.02%	28.83%
Operating Income	1,510	1,546	2,069	2,307	2,437
Operating Margin	1.85%	1.92%	2.61%	2.97%	3.39%
Net Income	870	958.6	1,296	1,514	1,620
Net Margin	1.06%	1.19%	1.64%	1.95%	2.25%

Cash Flow Statement Margins

Monetary values in USD amounts except #	LTM Mar 09	2024 Feb 22	2023 Feb 28	2022 Feb 28	2021 Feb 28
Revenue	81,720	80,391	79,238	77,650	71,887
Cash from Operating Activities	3,976	2,681	2,660	2,854	3,513
Cash from Operating Activities Margin	4.87%	3.33%	3.36%	3.67%	4.89%
Free Cash Flow	2,078	749.4	628.2	700	1,907
Free Cash Flow Margin	2.54%	0.932%	0.793%	0.901%	2.65%
Depreciation and Amortization	1,398	2,499	2,444	2,460	2,305
Depreciation and Amortization Margin	1.71%	3.11%	3.08%	3.17%	3.21%
Capital Expenditure	-1,897	-1,931	-2,031	-2,154	-1,606
Capital Expenditure Margin	-2.32%	-2.4%	-2.56%	-2.77%	-2.23%

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": "2021", "x": "2022-02-28", "y": 28.83}, {"l": "2022", "x": "2023-02-28", "y": 28.02}, {"l": "2023", "x": "2024-02-28", "y": 27.82}, {"l": "2024", "x": "2025-02-22", "y": 27.68}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "annual", "hidden": false}, {"label": "Operating Margin", "mappingKey": "user:%operatingMargin", "data": [{"l": "2021", "x": "2022-02-28", "y": 3.39}, {"l": "2022", "x": "2023-02-28", "y": 2.97}, {"l": "2023", "x": "2024-02-28", "y": 2.61}, {"l": "2024", "x": "2025-02-22", "y": 1.92}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "annual", "hidden": false}, {"label": "Net Margin", "mappingKey": "user:%netMargin", "data": [{"l": "2021", "x": "2022-02-28", "y": 2.25}, {"l": "2022", "x": "2023-02-28", "y": 1.95}, {"l": "2023", "x": "2024-02-28", "y": 1.64}, {"l": "2024", "x": "2025-02-22", "y": 1.19}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "annual", "hidden": false}, {"label": "Free Cash Flow Margin", "mappingKey": "user:%freeCashFlowMargin", "data": [{"l": "2021", "x": "2022-02-28", "y": 2.65}, {"l": "2022", "x": "2023-02-28", "y": 0.901}, {"l": "2023", "x": "2024-02-28", "y": 0.793}, {"l": "2024", "x": "2025-02-22", "y": 0.932}], "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 (Q3) Nov 29	2025 (Q2) Sep 06	2025 (Q1) Jun 14	2024 (Q4) Feb 28	2024 (Q3) Nov 30	2024 (Q2) Sep 07
Revenue	19,124	18,916	24,881	18,800	18,774	18,552
Revenue Growth Rate	1.1%	-23.97%	32.35%		1.2%
Cost of Revenue	13,875	13,809	18,142	13,650	13,528	13,430
Gross Profit	5,249	5,107	6,738	5,149	5,246	5,121
Gross Margin	27.45%	27%	27.08%	27.39%	27.94%	27.61%
Operating Income	489.7	295.3	449.3	276	518.5	292
Operating Margin	2.56%	1.56%	1.81%	1.47%	2.76%	1.57%
Net Income	293.3	168.5	236.4	171.8	400.6	145.5
Net Margin	1.53%	0.891%	0.95%	0.914%	2.13%	0.784%

Cash Flow Statement Margins

Monetary values in USD amounts except #	2025 (Q3) Nov 29	2025 (Q2) Sep 06	2025 (Q1) Jun 14	2024 (Q4) Feb 28	2024 (Q4) Feb 22	2024 (Q3) Nov 30	2024 (Q2) Sep 07
Revenue	19,124	18,916	24,881	18,800		18,774	18,552
Cash from Operating Activities	1,650	813	754.4		758.5	548	413.2
Cash from Operating Activities Margin	8.63%	4.3%	3.03%			2.92%	2.23%
Free Cash Flow	1,187	447.1	169.8		274	53.6	3.9
Free Cash Flow Margin	6.21%	2.36%	0.682%			0.285%	0.021%
Depreciation and Amortization	15	16.3	786.8		580.2	14.9	578.6
Depreciation and Amortization Margin	0.078%	0.086%	3.16%			0.079%	3.12%
Capital Expenditure	-462.3	-365.9	-584.6		-484.5	-494.4	-409.3
Capital Expenditure Margin	-2.42%	-1.93%	-2.35%			-2.63%	-2.21%

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 (Q2)", "x": "2024-09-07", "y": 27.61}, {"l": "2024 (Q3)", "x": "2024-11-30", "y": 27.94}, {"l": "2024 (Q4)", "x": "2025-02-28", "y": 27.39}, {"l": "2025 (Q1)", "x": "2025-06-14", "y": 27.08}, {"l": "2025 (Q2)", "x": "2025-09-06", "y": 27}, {"l": "2025 (Q3)", "x": "2025-11-29", "y": 27.45}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}, {"label": "Operating Margin", "mappingKey": "user:%operatingMargin", "data": [{"l": "2024 (Q2)", "x": "2024-09-07", "y": 1.57}, {"l": "2024 (Q3)", "x": "2024-11-30", "y": 2.76}, {"l": "2024 (Q4)", "x": "2025-02-28", "y": 1.47}, {"l": "2025 (Q1)", "x": "2025-06-14", "y": 1.81}, {"l": "2025 (Q2)", "x": "2025-09-06", "y": 1.56}, {"l": "2025 (Q3)", "x": "2025-11-29", "y": 2.56}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}, {"label": "Net Margin", "mappingKey": "user:%netMargin", "data": [{"l": "2024 (Q2)", "x": "2024-09-07", "y": 0.784}, {"l": "2024 (Q3)", "x": "2024-11-30", "y": 2.13}, {"l": "2024 (Q4)", "x": "2025-02-28", "y": 0.914}, {"l": "2025 (Q1)", "x": "2025-06-14", "y": 0.95}, {"l": "2025 (Q2)", "x": "2025-09-06", "y": 0.891}, {"l": "2025 (Q3)", "x": "2025-11-29", "y": 1.53}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}, {"label": "Free Cash Flow Margin", "mappingKey": "user:%freeCashFlowMargin", "data": [{"l": "2024 (Q2)", "x": "2024-09-07", "y": 0.021}, {"l": "2024 (Q3)", "x": "2024-11-30", "y": 0.285}, {"l": "2025 (Q1)", "x": "2025-06-14", "y": 0.682}, {"l": "2025 (Q2)", "x": "2025-09-06", "y": 2.36}, {"l": "2025 (Q3)", "x": "2025-11-29", "y": 6.21}], "dataType": "%", "displayAs": "bar", "dataTimeseries": "quarterly", "hidden": false}], "editableDates": {}, "properties": {"display_table": false}, "width": "full"}