M&A and private equityAdvanced · ~50 minWorking draft · 11 sheets · 301 formulas

Union Pacific and Norfolk Southern merger model

The 2025 railroad merger: shares and cash, synergies, EPS, leverage. Read a real stock-and-cash merger from its joint proxy statement: separate what a fixed exchange ratio fixes from what moves with the acquirer’s price, rebuild the pro forma, and say what the synergies have to deliver for earnings per share and what the new debt does to leverage.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: union pacific and norfolk southern merger model.Updated 20 November 2026

Who builds it, and for whatThe model a sell-side analyst, an acquirer’s adviser or a holder of either stock builds when a stock-and-cash merger is announced: the consideration at a fixed exchange ratio, the cash half funded with debt, both companies’ projected earnings, the synergies the boards were shown, pro forma earnings per share against the acquirer’s own projection, and the leverage the new debt leaves while a regulator decides. Built from the transaction’s own published documents, with every input they do not give labelled as an assumption.

Every sheet below, in your browser, with its outputs and checks

Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHI
1Assumptions
2$m unless stated. Disclosed figures carry their source on the Sources sheet; the rest are illustrative inputs.
4DriverUnitFY2027EFY2028EFY2029EFY2030EFY2031ENotes
5Scenario
6Scenario#11 = base, 2 = downside, 3 = upside. Sets the run-rate synergies.
8The terms (merger agreement, 28 July 2025)
9Union Pacific shares for each Norfolk Southern shareshares1.00Disclosed: one share, a fixed exchange ratio (Form 8-K, 29 July 2025).
10Cash for each Norfolk Southern share$ per share88.82Disclosed: $88.82 in cash, without interest.
11Union Pacific share price$ per share231.18Disclosed: the close on 16 July 2025, the last day before press speculation (joint proxy p.23). Change it: it moves the value of the stock half, never the share count.
12Norfolk Southern unaffected share price$ per share260.32Disclosed: the close on 16 July 2025 (joint proxy p.23).
13Norfolk Southern shares outstandingm shares224.61Disclosed: at 30 June 2025, the joint proxy’s basis for the consideration (p.46).
14Norfolk Southern awards settled in cash$m20.0Disclosed: the joint proxy’s estimate (p.46).
15Union Pacific shares outstandingm shares593.12Disclosed: at 26 September 2025 (joint proxy p.20). Held flat: Union Pacific paused its repurchases for the merger (Form 10-Q, Q3 2026).
17Union Pacific management’s projections for Union Pacific (joint proxy p.106)
18Union Pacific adjusted EBITDA$m13,700.014,200.014,800.015,400.016,000.0Disclosed, in $bn to one decimal.
19Union Pacific diluted EPS$ per share13.5214.4615.5016.6517.84Disclosed.
20Union Pacific unlevered free cash flow$m7,800.08,100.08,400.08,700.09,100.0Disclosed, as Morgan Stanley and Wells Fargo calculated it from the projections (p.107).
22Union Pacific management’s projections for Norfolk Southern (joint proxy p.107)
23Norfolk Southern adjusted EBITDA$m6,700.07,100.07,500.07,800.08,000.0Disclosed. Norfolk Southern’s own plan (p.109) reads the same to FY2028E and higher after.
24Norfolk Southern diluted EPS$ per share15.7217.3319.1120.8622.47Disclosed. Norfolk Southern’s own plan has $16.04 in FY2027E rising to $22.36 in FY2030E (p.109).
25Norfolk Southern unlevered free cash flow$m3,500.03,800.04,100.04,400.04,400.0Disclosed: Morgan Stanley’s figures, which count the Eastern Ohio disbursements as cash out (p.107).
26Norfolk Southern adjusted EBITDA, FY2025E$m5,800.0Disclosed (p.107). The base of the entry multiple.
27Union Pacific diluted EPS, FY2026E$ per share12.57Disclosed (p.106).
28Norfolk Southern diluted EPS, FY2026E$ per share14.05Disclosed (p.107).
30Synergies (joint proxy p.109)
31Management assumed synergies, gross run-rate EBITDA$m2,750.0Disclosed: $1.75bn from revenue and $1.0bn from operating costs, by the third year after completion (p.94).
32Union Pacific management net synergies$m2,000.0Disclosed: the gross figure net of illustrative assumed concessions, which Morgan Stanley and Wells Fargo were directed to use.
33Run-rate synergies, downside$m1,000.0Illustrative: half the net figure.
34Run-rate synergies, selected scenario$m2,000.0Pre-tax EBITDA once fully phased in. Base: the net $2.0bn. Downside: half of it. Upside: the gross $2.75bn.
35Synergies phased in, % of run-rate%35.0%70.0%100.0%100.0%Illustrative. The documents say "by the third year"; the shape follows the synergy cash flows Wells Fargo derived (p.131).
36Operating cost to achieve the synergies$m170.0---Disclosed: $170m, in the first year of the phase-in.
37Capital spending to achieve the synergies$m1,000.01,000.0--Disclosed: $2.0bn, half in each of the first two years.
39Financing and accounting (joint proxy pp.49 to 50)
40Cash Union Pacific applies to the cash consideration$m-Illustrative. The joint proxy funds it all with debt and shows $5bn of cash cutting interest by $250m a year.
41Interest rate on the new debt%5.0%Disclosed assumption: "a reasonable interest rate of 5%". Each 0.125% is about $25m a year.
42Interest forgone on cash applied%4.0%Illustrative.
43Issuance and liability management costs$m190.0Disclosed: paid in cash and amortised over 15 years.
44Amortisation period of those costsyears15Disclosed.
45Union Pacific merger costs$m190.0Disclosed estimate; expensed, so outside adjusted earnings.
46Tax rate on the adjustments%24.2%Disclosed: federal and state statutory rates as Union Pacific discloses them.
47Write-up of Norfolk Southern’s property$m-Illustrative. The joint proxy keeps book value and says a material part of the $53.1bn of goodwill could be attributed to property.
48Composite depreciation rate on a write-up%2.8%Disclosed: $10bn more property adds $275m of depreciation a year (p.50).
50Balance sheet and dividends
51Union Pacific debt at 30 June 2025$m32,813.0Disclosed: $2,522m due within a year and $30,291m after (joint proxy p.43). Held to completion.
52Norfolk Southern debt at 30 June 2025, book$m17,367.0Disclosed: $903m and $16,464m (p.43).
53Fair value adjustment to Norfolk Southern’s debt$m(1,348.0)Disclosed: the pro forma records the debt at fair value (p.47).
54Norfolk Southern cash at 30 June 2025$m1,303.0Disclosed (p.43).
55Union Pacific interest expense, 2024$m1,269.0Disclosed (p.42).
56Norfolk Southern interest expense, 2024$m807.0Disclosed (p.42).
57Rate on the existing debt%4.1%Derived: 2024 interest over the June 2025 debt. Illustrative as a forward rate.
58Union Pacific quarterly dividend$ per share1.42Disclosed: raised from $1.38 in the third quarter of 2026 (Form 10-Q). Held flat on the combined share count: illustrative.

Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.

Download

Union Pacific and Norfolk Southern merger model: the workbook

An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
  3. L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
  4. L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
The worked model
11 sheets and 301 live formulas, all 9 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
The starter
The same inputs and layout with the pro forma EPS: accretion and dilution left blank for you to build, each blank cell marked. The worked model is its answer.

What the base case says

Value per Norfolk Southern share
320.00
Former Norfolk Southern holders’ ownership
27.5%
New debt
$19,970.3m
Accretion / (dilution), FY2029E
8.7%
Breakeven run-rate synergies, FY2029E
$-83.6m
Debt / EBITDA at completion
3.4x

Read from the workbook as served, every input at its default. Periods: FY2027E, FY2028E, FY2029E, FY2030E, FY2031E. Built from the transaction’s published documents, cited on the Sources sheet by page: the terms, the share counts, both companies’ projections as Union Pacific management prepared them, the synergies and the joint proxy’s pro forma conventions are as disclosed, and what those documents do not give (the phase-in of the synergies, any property write-up, cash applied before completion, dividends after it) is an illustrative input, labelled, and moves with whatever you type in.

What changes the answer

Every figure below is the workbook recalculated by its own formulas: the cases it carries, each key assumption moved a tenth either way, and the sensitivity grids from its own sheets. Nothing is estimated outside the model.

The cases, side by side

The scenario switch on the Assumptions sheet, set to each option in turn. Every check in the workbook reads zero in every case.

OutputBaseas shippedDownsideUpside
Value per Norfolk Southern share320.00320.00320.00
Former Norfolk Southern holders’ ownership27.5%27.5%27.5%
New debt$19,970.3m$19,970.3m$19,970.3m
Accretion / (dilution), FY2029E8.7%4.5%-4.2 pts11.9%+3.1 pts
Breakeven run-rate synergies, FY2029E$-83.6m$-83.6m$-83.6m
Debt / EBITDA at completion3.4x3.4x3.4x
What each case assumes
Run-rate synergies, selected scenario2,000.01,000.02,750.0

The first period of each assumption row the switch sets directly, in the order of the columns above.

What moves accretion or dilution most

Accretion / (dilution), FY2029E is 8.7% in the base case. Each bar moves one assumption 10% below and 10% above its own value, with everything else held, and shows where the output lands.

  • Union Pacific diluted EPS (union pacific management’s projections for union pacific)

    10% lower: 12.7%10% higher: 5.4%

  • Norfolk Southern diluted EPS (union pacific management’s projections for norfolk southern)

    10% lower: 5.3%10% higher: 12.1%

  • Union Pacific shares for each Norfolk Southern share

    10% lower: 11.8%10% higher: 5.8%

  • Union Pacific management net synergies

    10% lower: 7.9%10% higher: 9.6%

  • Synergies phased in

    10% lower: 7.9%10% higher: 9.6%

  • Union Pacific shares outstanding

    10% lower: 9.4%10% higher: 8.1%

Assumption 10% lowerAssumption 10% higherBase case, 8.7%

The sensitivity grid, as heatmaps

FY2029E accretion / (dilution): property write-up by run-rate synergies

Accretion / (dilution) (%), by property write-up ($m) down and run-rate synergies, pre-tax ($m) across. From the Sensitivity sheet.
Property write-up ($m) ↓ / Run-rate synergies, pre-tax ($m) →1,000.01,500.02,000.02,500.03,000.0
-4.5%6.6%8.7%10.8%12.9%
5,000.03.7%5.8%7.9%10.0%12.1%
10,000.02.9%5.0%7.1%9.2%11.3%
15,000.02.1%4.2%6.3%8.3%10.4%
20,000.01.2%3.3%5.4%7.5%9.6%
Lower than the base caseHigher than the base caseThe base case, as the workbook ships

Presenting these figures? In Deck Studio a slide can carry any output above, with the case and the cell printed as its source.Open Deck Studio

What this model is

A merger model of Union Pacific’s agreed acquisition of Norfolk Southern, announced on 29 July 2025: one Union Pacific share and $88.82 in cash for each Norfolk Southern share, approved by both companies’ shareholders on 14 November 2025 and awaiting the Surface Transportation Board.

It prices the consideration, funds the cash half with new debt as the joint proxy does, adds both companies’ projected earnings, the synergies, the interest and any write-up, and compares pro forma earnings per share with Union Pacific’s own projection for FY2028E to FY2031E. It then follows the debt from completion as the combined free cash flow repays it.

Uses: seeing what a fixed exchange ratio does and does not move; finding the synergies the combination needs to add to earnings per share; and testing the leverage while the regulator decides.

Seats: Investment banking, Equity research and hedge funds, Private equity.

Careers that do this work: investment banking, private equity, growth equity, corp dev / m&a, venture capital.

How the schedules connect

Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.

What you should be able to explain

  • Why the value of the offer moves with Union Pacific’s share price while the new shares, the cash and the earnings per share do not.
  • How a joint proxy’s pro forma is built: the whole cash consideration on new debt at an assumed rate, the issuance costs amortised, the adjustments taxed at the acquirer’s rate, the target’s property at book value.
  • Why a target whose projected earnings grow faster than the acquirer’s can make a deal accretive before any synergy, and what a write-up of its property does to that.
  • How breakeven synergies are found, and why a run-rate figure has to be read through its phase-in and the cost of achieving it.
  • How debt to EBITDA at completion falls as free cash flow repays debt and synergies lift EBITDA, and what dividends and repurchases do to the path.

What a reviewer looks for

  • Treating the $320 as fixed. It was the value at Union Pacific’s 16 July 2025 close; the exchange ratio is fixed and the value is not.
  • Counting the $85bn enterprise value as the funding requirement. Only the cash half and the costs need funding; the shares are issued and Norfolk Southern’s debt is assumed.
  • Reading the $2.75bn as what the advisers valued. They were directed to use $2.0bn, net of illustrative concessions, and the phase-in is not disclosed.
  • Stating an actual accretion or return. Every result here is conditional on projections the companies made in 2025 and on inputs the page labels.
  • Forgetting that the pro forma keeps Norfolk Southern’s property at book value. A write-up adds depreciation, and $10bn of it costs about $275m a year before tax.

Conventions this workbook uses

Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.

  • Disclosed figures are inputs with their source on the Sources sheet. The projections are Union Pacific management’s for both companies, the set Union Pacific’s board and advisers used. Illustrative inputs (the phase-in, a property write-up, cash applied, the downside synergies, the forward rate on existing debt, dividends after completion) are labelled.
  • The terms are fixed per share: the new shares are the exchange ratio times Norfolk Southern’s shares, and the cash is $88.82 times the same count. Union Pacific’s share price changes the value of the share consideration and the premium, never the share count or the earnings per share.
  • Completion is treated as the end of FY2027E. FY2028E is the first full year after it and FY2029E the second, the year the announcement says the merger turns accretive.
  • Pro forma net income is projected EPS times shares for each company, plus the after-tax adjustments: synergies at the phase-in, less their cost, interest on the new debt held at its amount at completion, interest forgone on any cash applied, amortisation of the issuance costs and depreciation of any property write-up, taxed at 24.2%, as the joint proxy’s pro forma does. Share counts are held flat.
  • Accretion / (dilution) = pro forma EPS / Union Pacific standalone EPS - 1. The breakeven is the run-rate at which pro forma EPS equals standalone EPS in that year at that year’s phase-in.
  • Debt at completion is the joint proxy’s pro forma at 30 June 2025: Union Pacific’s debt, Norfolk Southern’s at fair value, and the new debt net of its costs. Each later year repays debt with both companies’ unlevered free cash flow, the after-tax synergies less their capital spending, less after-tax interest at the blended rate and the dividend on the combined shares. Leverage is debt over combined EBITDA with the synergies.
  • The merger costs are paid in cash and expensed, so they are in the sources and uses and outside adjusted earnings.

Build it yourself

The starter workbook

The earnings rows have been cleared: both companies’ net income from the projections, pro forma net income, shares and EPS, the accretion, the EPS bridge and the breakeven synergies on the Pro Forma EPS sheet. Rebuild them from the Assumptions and the adjustments, so that the bridge check reads zero and the Sensitivity grid’s centre ties to your FY2029E accretion.

Blanks: Pro forma EPS: accretion and dilution. Download it beside the worked model.

Finished? Audit a model you built for errors, hardcodes and checks that do not tie, in your browser.

The path around this model

Understand it, drill it, read the build, then apply it to a real company.

Vocabulary: Merger Model, Accretion / Dilution, Synergies, Goodwill, Equity Value, Leverage Ratio (Debt/EBITDA), Purchase Price Allocation (PPA).

Questions about this model

How much of this model is disclosed and how much is assumed?

Disclosed: the terms (one Union Pacific share and $88.82 for each Norfolk Southern share), the share counts, the prices the joint proxy quotes, Union Pacific management’s projections for both companies, the advisers’ unlevered free cash flow, the management assumed synergies ($2.75bn gross, $2.0bn net, $170m of operating cost and $2.0bn of capital spending to achieve them), and the pro forma conventions (5% on the new debt, $190m of issuance costs over 15 years, a 24.2% tax rate, the June 2025 balance sheet). Assumed and labelled: how the synergies phase in each year, any write-up of Norfolk Southern’s property, cash applied before completion, the downside synergies, the forward rate on existing debt and dividends after completion.

Why does changing Union Pacific’s share price not change the accretion?

Because the terms fix the number of shares and the amount of cash per Norfolk Southern share. The price changes what the share consideration is worth, and so the premium and the enterprise value, but the new shares, the new debt and every line of pro forma earnings stay where they were.

The company said the deal would be accretive in the second full year. Why does the base case show accretion in the first?

The base case uses the joint proxy’s own pro forma conventions, which keep Norfolk Southern’s property at book value and leave out integration costs beyond the $170m, on Union Pacific management’s projections. The documents do not give the arithmetic behind the company’s statement. A write-up of Norfolk Southern’s property is the input that moves the model most: at $20bn it turns the first full year to dilution.

Where does the leverage figure come from?

Debt at completion is the joint proxy’s pro forma balance sheet at 30 June 2025, $68.6bn, over the two companies’ projected adjusted EBITDA for 2027, about 3.4x against the announcement’s approximately 3.3x. Each later year repays debt with both companies’ unlevered free cash flow and the synergies after interest and dividends; no repurchases are assumed.

Related models

What assumption would you challenge?

Every model rests on a few judgements. Ask how one works, or say which input you would set differently and why.

Ask about this model

No questions yet. Ask the first.

All discussions · Community rules

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.