Atmos Energy Financial Model

• Total assets: Approximately $25-30 billion.
• Key asset categories: Property, Plant, and Equipment makes up over 85% of total assets and represents the regulatory rate base.
• Goodwill & intangibles: Minimal, representing less than 2% of total assets.
• Working capital profile:
• Days Sales Outstanding (DSO): 30-45 days.
• Days Inventory Outstanding (DIO): 15-25 days (gas in storage).
• Days Payable Outstanding (DPO): 30-45 days.
• Net working capital as % of revenue: Often negative or near zero.
• Is working capital positive or negative?: The company frequently operates with negative working capital, as gas cost payables and deferred tax liabilities offset receivables.
• PP&E: Consists of natural gas distribution mains, transmission pipelines, storage facilities, and service lines. Depreciated over 30-50 years.
• Right-of-use assets / operating leases: Immaterial to the overall asset base.

• Capex as % of revenue: 60-80% (highly capital intensive).
• Maintenance capex vs. growth capex: Approximately 85% is dedicated to safety and reliability. In a regulated utility, this acts as growth capex because it is added to the rate base and earns a return.
• Major capex programmes underway or planned: A massive $26 billion capital plan from fiscal 2026 to 2030, focusing on replacing aging pipe and system fortification.
• Capitalised software / development costs if material: Immaterial compared to hard infrastructure spend.
• M&A pattern: Organic grower. The company has not made a transformational acquisition in over a decade.
• Typical acquisition multiple paid: Not applicable.

• Total debt: Approximately $8.5 to $9.5 billion in long-term debt.
• Debt/EBITDA ratio: Typically runs between 3.5x and 4.0x.
• Credit rating: A- / A2 (strong investment grade).
• Key debt instruments: Unsecured senior notes and a commercial paper programme for short-term liquidity.
• Maturity profile: Well-laddered long-term bonds stretching out 10 to 30 years.
• Interest rate profile: Predominantly fixed-rate long-term debt, insulating the company from short-term rate shocks.
• Covenants: Standard debt-to-capitalisation limits.
• Share repurchase programme: Inactive. The company issues equity rather than repurchasing it to fund its massive capex programme.
• Dividend policy: 41 consecutive years of increases. The target payout ratio is approximately 50% of net income, yielding around 2.0-2.5%.

• Operating cash flow conversion: 1.2x to 1.5x of Net Income, aided by massive depreciation add-backs.
• Free cash flow margin: Consistently negative. The company outspends its operating cash flow on capex to grow the rate base.
• Major non-cash items: Depreciation and deferred income taxes.
• Working capital cash flow impact: Can swing significantly year-over-year based on winter weather and natural gas prices causing under-recovered or over-recovered gas costs.
• Capex intensity: Extremely high, requiring constant access to capital markets.
• Cash tax rate vs. GAAP effective tax rate: Cash taxes are significantly lower than the GAAP rate due to accelerated depreciation on infrastructure investments.

1. Assumptions: Hardcoded macro drivers, regulatory allowed returns, rate base growth targets, capex plans, and financing mix.
2. Rate Base & Capex: Roll-forward of gross PP&E, accumulated depreciation, accumulated deferred income taxes, and calculation of average rate base by segment.
3. Revenue Build: Distribution segment (customers, volumes, base rates, gas costs) and Pipeline and Storage segment (capacity, reservation rates).
4. O&M & Depreciation: Operating expenses, headcount drivers, and depreciation schedules based on composite asset lives.
5. Income Statement: Consolidated profitability, interest expense, and income taxes.
6. Balance Sheet: PP&E, working capital, debt, equity, and deferred taxes.
7. Cash Flow Statement: Operating cash flow, investing cash flow (capex), and financing cash flow (debt issuance, equity issuance, dividends).
8. Debt & Equity Schedule: Debt tranches, interest calculation, equity issuance required to maintain the 60% equity ratio, and share count roll-forward.
9. Valuation: Dividend Discount Model, P/E multiple valuation, and a standard DCF.

1. "Distribution Gross Margin = Distribution Revenue - Purchased Gas Costs"
2. "Pipeline and Storage Revenue = (Reserved Capacity x Reservation Rate) + (Throughput x Volumetric Rate)"
3. "Ending Rate Base = Beginning Rate Base + Capital Expenditures - Depreciation - Deferred Taxes"
4. "Allowed Operating Income = Average Rate Base x Weighted Average Cost of Capital (Regulatory)"
5. "Depreciation Expense = Gross PP&E x Composite Depreciation Rate"
6. "Interest Expense = Average Debt Balance x Weighted Average Interest Rate"
7. "Funding Gap = Total Capex + Dividends - Operating Cash Flow"
8. "Equity Issuance Requirement = Funding Gap x Target Equity Percentage"
9. "Shares Outstanding = Beginning Shares + (Equity Issuance / Average Share Price)"
10. "Dividend Per Share = Prior Year DPS x Target Growth Rate"
11. "Earnings Per Share = Net Income / Shares Outstanding"

The Rate Base & Capex sheet is the engine of the model; it feeds O&M & Depreciation (calculating depreciation expense) and Revenue Build (allowed return drives rate case revenue). The Revenue Build and O&M & Depreciation sheets feed the Income Statement. The Income Statement feeds the Cash Flow Statement and Balance Sheet. The Cash Flow Statement identifies the funding gap, which feeds the Debt & Equity Schedule to calculate required debt and equity issuance. The Debt & Equity Schedule feeds back into the Income Statement (Interest Expense) and Balance Sheet (Debt and Equity balances). This creates a circularity where interest expense depends on debt, which depends on the funding gap, which depends on net income.

• Revenue, income, and asset balances are positive.
• Expenses and costs are calculated as positive numbers in their specific build schedules but subtracted in the Income Statement.
• Liability and equity balances are positive.
• Cash Flow: Inflows are positive, outflows (such as Capex and Dividends) are negative.

1. "Failing to pass through purchased gas costs correctly; revenue and COGS must move in tandem with gas prices, leaving gross margin unaffected."
2. "Ignoring the equity issuance requirement; Atmos funds its capex with a strict 60% equity to 40% debt mix, meaning share dilution must be modelled."
3. "Misunderstanding regulatory lag; capex does not instantly generate revenue, though mechanisms like the Gas Reliability Infrastructure Program reduce this delay to roughly six months."
4. "Applying a standard DCF blindly; utilities are often better valued on P/E multiples or a Dividend Discount Model due to perpetual negative Free Cash Flow."
5. "Overestimating summer revenue; the Distribution segment is highly seasonal, with the vast majority of earnings in the December and March quarters."
6. "Forgetting deferred taxes; accelerated tax depreciation creates large deferred tax liabilities which are deducted from the regulatory rate base."
7. "Circularity in the financing loop; interest expense depends on debt, which depends on the funding gap. The model must include a circuit breaker toggle."
8. "Miscalculating the rate base; it is not simply Net PP&E, it must be adjusted for accumulated deferred income taxes and working capital."

1. "Equity Capitalisation Ratio should remain between 58% and 62% in all forecast years to match management targets."
2. "Dividend Payout Ratio should be approximately 48-52% of Net Income."
3. "EPS Growth should fall within management's target range of 6.0% to 8.0% annually."
4. "Rate Base Growth should track at 13-15% annually based on the $26 billion capex plan."
5. "Operating Cash Flow to Net Income should consistently be greater than 1.2x."
6. "Free Cash Flow must be negative in all years due to the heavy capex programme."
7. "Balance Sheet must balance: Total Assets = Total Liabilities + Equity in every period."
8. "Effective Tax Rate should be approximately 20-23%."

• Filings: SEC EDGAR for Atmos Energy (ATO) 10-K and 10-Q filings.
• Presentations: Atmos Energy Investor Relations page for quarterly earnings presentations and the annual Statistical Summary.
• Peers: CenterPoint Energy (CNP), ONE Gas (OGS), Southwest Gas (SWX), Spire (SR), NiSource (NI).
• Industry Data: American Gas Association for customer growth and regulatory trends; Railroad Commission of Texas for state-specific rate case outcomes.
• Consensus: Bloomberg or FactSet for consensus EPS and capex estimates.

• Atmos Energy Corporation Form 10-K for the fiscal year ended September 30, 2025.
• Atmos Energy Q4 2025 Investor Presentation (November 2025).
• Atmos Energy 2024 Statistical Summary.
• State of Minnesota Department of Revenue Capitalization Rate Study 2026.