Xcel Energy Inc. (XEL)

Total return at 5 years: 5.0%/year = 1.5% appreciation + 3.5% dividend. The target price ($82) is ex-dividend; the $14 in dividends collected over 5 years are added separately.

By both methods, the value today (DCF $154 · Multiples $78) exceeds the market price ($76).

Today — fairly valued: at $76 trades ~2.4% below its value discounted to today (~$78); the discount is positive but does not reach the margin of safety we require (≥38%).

At 5 years — En valor: the target price ($82) plus dividends yield between the 4% floor and the 10% average return — a reasonable return, though without the margin of a great investment.

The bridge: the return at 5 years exceeds the risk-free rate (4.5%) — but the discount does not reach the required margin of safety (≥38%). To require a 15% annual return, it would need to be bought at ~$50.

Educational / informational. Does not constitute investment advice.

The inverse approach: instead of projecting growth to obtain the value, the market price ($76) is taken as given and it solves for what annual owner-earnings growth would need to hold for 5 years for the present value —at the method's rate (4.5%, no-growth terminal)— to equal that price. It is the disconfirmation test: the expectations the price already pays for, contrasted against the method's projection.

The market discounts less growth (-8.4%/year) than we project (7.0%/year) → if the base case holds, there is margin: perception is more pessimistic than the estimated reality.

That growth implies ~$2.1 bn of owner earnings in year 5 (vs ~$4.5 bn of our base case). It recalculates if the DCF assumptions are edited.

A regulated utility is valued on P/E over adjusted earnings (equity-level): the value sits in the regulated base (rate base), which grows with capex at an allowed ROE. GAAP can be depressed by the mark-to-market of hedges → the adjusted figure is used. It returns capital via dividend (a dividend aristocrat); it may issue some equity to fund capex. Total return adds the dividend collected along the way. In edit mode, the metric, shares, dividend, and exit multiple can be adjusted.

A 100% regulated utility (four subsidiaries — NSP-Minnesota, NSP-Wisconsin, PSCo, SPS — with no unregulated renewables arm) is valued by P/E on attributable net income. XEL also guides a 'recurring' earnings figure that excludes non-recurring items (refunds from the Prairie Island exit and the Marshall wildfire litigation), but the gap is immaterial in this period ($14M on a half-year of $1,142M, under 1% of TTM): GAAP attributable net income, directly verifiable in the XBRL, is used as the metric. The base year is the real TTM ($2,233M as of Jun-2026), and the projection uses 12-month windows. The path starts from current guidance (the July 30, 2026 8-K): the company reaffirmed its 2026 recurring EPS of $4.04-4.16 and its long-term target of +6% to +8%+ annual EPS growth from a base of $3.80 (FY2025). Applied to TTM GAAP EPS ($3.56), that yields EPS growth of ~6.8% compounded annually over 5 years ($4.95 in year 5), within the guided band and without extrapolating the high end. Because the aggregate earnings figure the model carries is what gets divided by future shares, it grows faster than EPS (~9.5% year 1 decelerating to ~7.8%): the difference is dilution of ~2.5%/year from the equity issuance financing capex. XEL finances the 2026-2030 plan ($60,000M) with ~$30,180M of operating cash, $22,820M of new debt, and $7,000M of equity issuance (figures from the company's own financing plan); as of the close of Q2 2026, there were 69.7 million shares outstanding under unsettled forward sale contracts ($5,200M in expected minimum proceeds), consistent with the modeled dilution. The multiple compresses from ~18.7x today (TTM P/E) to 16.5x within a regulated utility's band (15-18x, §4) → a target price of ~$82. Earned ROE holds at ~9.2-9.3% in the base scenario (aggregate earnings grow at a pace similar to equity, which is fed both by retained earnings and by new share issuance); in the adverse scenario it compresses toward ~8.3% (lower allowed returns) and in the favorable scenario it rises toward ~9.5% (rate cases resolved favorably).

Today's multiple compresses on its own going forward as the metric per share grows. The exit multiple at 3 years is higher than the terminal at 5 years —at 3 years there is more growth still ahead—. Total return adds the dividend collected; the required return is applied to the base scenario.

They are valued separately, with their own rationale, and are not incorporated into the base or the verdict (they are excess return). When assigning them value — in Editmode —, the total with optionalities updates live, without moving the base.

The verdict, the base CAGR, and the margin of safety are always calculated on the base; optionalities do not alter them (with optionalities at $0 they do not move).

Each card fixes a required annual return and answers: if the business is worth $82 in 5 years, what is the maximum that can be paid today to obtain that return? Since it now trades at $76, the margin of safety is how much cheaper the market is than that maximum. The three thresholds: 4% covers inflation (the floor), 10% is the long-term average return, and 15% is the level of a great investment.

With a target price of $82 in 5 years plus $14 of dividends collected (the dividend adds to the return, not to the price) and a required return of 4.5% annually, the maximum to pay today is $78. Against the current market price ($76), the margin of safety is 2.4% (trades below the maximum → there is margin) and the total return at that price would be 5.0% annually.

• Multiple vs. the regulated band. ~18.7x TTM earnings, at the top of a 100% regulated utility's band (15-18x) — without the unregulated-growth premium that would justify a higher multiple.
• Growth vs. multiple. The multiple compresses from ~18.7x to ~16.5x as earnings grow; at a fixed price, the P/E paid at 5 years falls to ~14x.
• Margin of safety. Base +2%/year of price (+5% with dividend) in line with or below the average stock return (~10%); the discount to today is small.

Each margin over sales, year by year: historical (solid line) → projection (dotted).

• ✕ ROIC exceeds the cost of capital (~10%)
• ✓ CFROIC backs up the ROIC (100%, cash vs. accruals)
• ✓ Healthy balance sheet (low corporate debt)
• ✓ Durable competitive moat (multiple advantages)

• Regulated return (ROE earned vs. allowed). Earns ~9.3-10.4% (recurring, consolidated) against allowed returns of 9.3-10.5% depending on the subsidiary — execution within band, without wide headroom.
• Value creation (allowed return vs. the 10% bar). The consolidated allowed return (~9.4% blend) sits just below the 10% bar at several subsidiaries (PSCo 9.3%, SPS stipulated 9.5%) — a thinner spread than at utilities with allowed returns above 10.5%.
• Earnings quality. The GAAP-to-recurring gap is small in this period (under 1% of TTM); reported earnings are clean and directly verifiable in the XBRL.

Annual levels from the official filing (10-K); the % over each bar is the year-over-year (YoY) growth vs the prior year.

The engine of a regulated utility is rate base × authorized return. Xcel deploys ~$12,000M/year of capex (2026-2030) that expands the rate base of its four subsidiaries at allowed returns of 9.3-10.5%, at or above the 10% bar in most cases. It is capital-intensive: financed with operating cash, new debt, and equity issuance — which is why reported free cash flow is negative by design, not a sign of stress.

The % are the annual (year-over-year) growth: each year —historical and projected— vs the prior one; the TTM (trailing 12m) vs the TTM of a year ago, to avoid overlapping windows. The historicals are exact figures from the official filings; the projected years come from the year-by-year model (the intermediate years without their own series are interpolated between the anchors). The projected columns (+1y…+5y) are 12-month windows counted from the TTM close (30-jun-2026): the projection starts from the most recently reported data, not the fiscal year. The projected base is realistic and unbiased — the risk discount is applied at the end, via the required return. The rationale for each metric is in the (i).

• Real, not nominal. Growth is real: a physical rate base (plants, transmission, distribution) deployed under an already-budgeted $60,000M capex plan.
• Growth engine. Rate cases that expand the rate base + data-center demand (large-load agreements that pass the cost on to the new customer).
• Sustainability. The +6% to +8%+ guidance is grounded in a capex plan already committed through 2030; the risk is that the share issuance needed to finance it dilutes EPS faster than guided.

• Relevant in 10 years (recurrence). Electricity and natural gas are about as recurring a demand as exists; data-center demand accelerates it. Maximum flow predictability.
• Pricing power. Set by the regulator (authorized return on rate base), not by the market — not pricing power in the traditional sense, but it is a guaranteed return if the regulator approves cost recovery.
• Moat and its direction. A wide moat (regulated monopoly + network scale), stable. There is no evidence it is widening: recent rate cases closed below what was requested.
• Cyclicality / sensitivity. Not very cyclical (stable regulated demand) but highly sensitive to interest rates (high leverage) and to wildfire litigation risk, which is already approaching the insurance-coverage limit.

Not all debt is equal: only the structural needs refinancing; the rest is operational (self-liquidating).

Structural debt is what is exposed to the contraction phase of the cycle; operational debt (leases, matched funding) self-liquidates with the business.

• ✓Regulated return (earned vs allowed ROE)Earns 10.4% vs allowed 9.5%
• !Value creation (allowed ROE − 10% bar)-0.5pp
• !Leverage (net debt / EBITDA)6.4x · Baa1 / BBB / BBB+
• !Capex funding (liquidity + access)Liquidity $4.7 bn
• ✓Predictability (% regulated + rate-base growth)100% regulated · rate base +$12 bn/year

A traffic-light interpreted by the method (not generic): float (negative WC) adds up, capex is judged by incremental ROIC (malinvestment test), and a lender is not subjected to corporate solvency. The (i) shows the derivation of each number.

• Leverage (regulated lens). High by design ($38,458M of debt, 62% of capitalization), but backed by a regulated rate base that earns an authorized return — judged against utility thresholds, not corporate solvency ones.
• Credit quality (investment grade). Baa1/BBB/BBB+ at the parent, with a negative outlook at two of the three agencies — the margin against losing investment grade is tighter than at A-rated utilities.
• Negative cash flow by design. Reported free cash flow is negative (TTM capex of $12,463M far exceeds operating flow of $4,771M) because capex is deploying regulated rate base — it is investment, not cash stress.
• Financing of the capex plan. The $60,000M plan is funded with operating cash (50%), new debt (38%), and equity issuance (12%, already with 69.7M shares committed via forward contracts); it depends on continued access to capital markets.

How cash comes in and how it is deployed. In green, the business's own cash (the owner-FCF it generates and reinvests); in gray, the float and credit — customer and funding money, which is not the shareholder's.

Prioritizes capital deployment into the regulated rate base (~$12,000M/year), financed with operating cash, new debt, and equity issuance — not buybacks. The dividend grows with a targeted payout of 45-55% on recurring earnings, a pace (+4-6%/year) deliberately below earnings growth in order to retain more capital for capex.

Who owns the shares — the alignment and whether there is a controlling shareholder.

• Skin in the game. No founder control; directors and executives hold less than 1% of shares. Alignment comes from compensation design, not ownership.
• Capital allocation. Deploys ~$12,000M/year at regulated returns of 9.3-10.5%, financed with a disclosed mix of cash, debt, and equity. No buybacks — issues shares to fund capex (dilution ~2.5%/year).
• Integrity / candor. The Q2 2026 release discloses in detail the negative impact of equity financing on EPS, rather than hiding it. Transparent disclosure of the wildfire litigation and its insurance coverage.

• Not clearly cheap: it trades near the top of a regulated utility's band (~18.7x TTM earnings against a reference band of 15-18x), without the unregulated-growth premium that would justify a higher multiple for a hybrid utility.
• The modest base return does not stem from an identifiable pricing error, but from the fact that the business is already valued in line with its quality: a well-executed, 100% regulated utility, with a record capex plan already known and guided by the company itself.
• The 10% discount to the 52-week high ($83.91) is small and consistent with the normal rate cycle and with the short-term dilution the company itself discloses from financing capex via equity — there is no evidence of a motivated seller or of missing buyers.

Without an identifiable source of missing buyers or motivated sellers, the method's caution reading applies (§9, Step 9): the stock does not appear cheap, it trades in line with what the business is worth today. The base return (+5% total) is mostly the dividend and modest EPS expansion net of dilution from equity issuance.

The annual return (CAGR at 5 years) in each scenario, with the total period return below — the margin of safety made visual: upside range wide, downside range narrow.

Even in the bear scenario, the return holds at -1%/year (-4% total): the margin of safety protects the downside. The bull (+8%/year, +48% total) exceeds it comfortably — a favorable asymmetry, with a narrow downside range and a wide upside range.

• Wildfire litigation. The Smokehouse Creek fire in Texas has accumulated estimated losses and legal costs of $503M, against annual insurance coverage of which barely ~$80M remains available — the filing's most concrete and quantified risk.
• Regulatory cost-recovery risk. Recent rate cases have been resolved systematically below what was requested; there is no guarantee the pending ones (PSCo, SPS) will improve on that trend.
• Dilution from equity financing. The company's own release discloses equity issuance as a net drag on EPS in the short term, before the new rate base generates the allowed return.
• Nuclear risk. NSP-Minnesota operates two nuclear plants (Prairie Island, Monticello); an incident or a regulatory change in safety requirements would entail substantial unplanned capital expenditures.

Each thinker's analytical framework applied to our data.

• Buffett / Graham Quality + margin of safety

  A wide moat and ROE 10% above the 10% bar, but the margin is limited (+2%) → excellent business at a fair price.

• Peter Lynch Growth at a reasonable price (GARP)

  A stalwart growing 7% at a PEG of 3.0 → expensive for its growth.

• Joel Greenblatt Cheap and high-return (Magic Formula)

  Not applicable — the Magic Formula excludes financials and regulated businesses (EBIT/EV does not capture the operating leverage).

• Howard Marks Perception vs reality + cycle

  The price discounts -8% vs our 7%: perception is more pessimistic than reality, with an identified source of the discount.

• Seth Klarman Capital protection (bear scenario)

  Bear-scenario floor -5%/yr, bull-scenario ceiling +5%/yr over 5y: reasonable asymmetry, without an ample cushion.

• Pat Dorsey Moat strength (Five Rules)

  A wide moat, stable; sources: cost advantage, intangibles, efficient scale, switching costs → passes the Five Rules.

• Aswath Damodaran Expectations implied by the price

  Justifying the price requires discounting -8%, within what we project (7%) — the story squares with the numbers.