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
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | ||||||||
| 2 | $m unless stated. Disclosed figures carry their source on the Sources sheet; the rest are illustrative inputs. | ||||||||
| 4 | Driver | Unit | FY2027E | FY2028E | FY2029E | FY2030E | FY2031E | Notes | |
| 5 | Scenario | ||||||||
| 6 | Scenario | # | 1 | 1 = base, 2 = downside, 3 = upside. Sets the run-rate synergies. | |||||
| 8 | The terms (merger agreement, 28 July 2025) | ||||||||
| 9 | Union Pacific shares for each Norfolk Southern share | shares | 1.00 | Disclosed: one share, a fixed exchange ratio (Form 8-K, 29 July 2025). | |||||
| 10 | Cash for each Norfolk Southern share | $ per share | 88.82 | Disclosed: $88.82 in cash, without interest. | |||||
| 11 | Union Pacific share price | $ per share | 231.18 | Disclosed: 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. | |||||
| 12 | Norfolk Southern unaffected share price | $ per share | 260.32 | Disclosed: the close on 16 July 2025 (joint proxy p.23). | |||||
| 13 | Norfolk Southern shares outstanding | m shares | 224.61 | Disclosed: at 30 June 2025, the joint proxy’s basis for the consideration (p.46). | |||||
| 14 | Norfolk Southern awards settled in cash | $m | 20.0 | Disclosed: the joint proxy’s estimate (p.46). | |||||
| 15 | Union Pacific shares outstanding | m shares | 593.12 | Disclosed: at 26 September 2025 (joint proxy p.20). Held flat: Union Pacific paused its repurchases for the merger (Form 10-Q, Q3 2026). | |||||
| 17 | Union Pacific management’s projections for Union Pacific (joint proxy p.106) | ||||||||
| 18 | Union Pacific adjusted EBITDA | $m | 13,700.0 | 14,200.0 | 14,800.0 | 15,400.0 | 16,000.0 | Disclosed, in $bn to one decimal. | |
| 19 | Union Pacific diluted EPS | $ per share | 13.52 | 14.46 | 15.50 | 16.65 | 17.84 | Disclosed. | |
| 20 | Union Pacific unlevered free cash flow | $m | 7,800.0 | 8,100.0 | 8,400.0 | 8,700.0 | 9,100.0 | Disclosed, as Morgan Stanley and Wells Fargo calculated it from the projections (p.107). | |
| 22 | Union Pacific management’s projections for Norfolk Southern (joint proxy p.107) | ||||||||
| 23 | Norfolk Southern adjusted EBITDA | $m | 6,700.0 | 7,100.0 | 7,500.0 | 7,800.0 | 8,000.0 | Disclosed. Norfolk Southern’s own plan (p.109) reads the same to FY2028E and higher after. | |
| 24 | Norfolk Southern diluted EPS | $ per share | 15.72 | 17.33 | 19.11 | 20.86 | 22.47 | Disclosed. Norfolk Southern’s own plan has $16.04 in FY2027E rising to $22.36 in FY2030E (p.109). | |
| 25 | Norfolk Southern unlevered free cash flow | $m | 3,500.0 | 3,800.0 | 4,100.0 | 4,400.0 | 4,400.0 | Disclosed: Morgan Stanley’s figures, which count the Eastern Ohio disbursements as cash out (p.107). | |
| 26 | Norfolk Southern adjusted EBITDA, FY2025E | $m | 5,800.0 | Disclosed (p.107). The base of the entry multiple. | |||||
| 27 | Union Pacific diluted EPS, FY2026E | $ per share | 12.57 | Disclosed (p.106). | |||||
| 28 | Norfolk Southern diluted EPS, FY2026E | $ per share | 14.05 | Disclosed (p.107). | |||||
| 30 | Synergies (joint proxy p.109) | ||||||||
| 31 | Management assumed synergies, gross run-rate EBITDA | $m | 2,750.0 | Disclosed: $1.75bn from revenue and $1.0bn from operating costs, by the third year after completion (p.94). | |||||
| 32 | Union Pacific management net synergies | $m | 2,000.0 | Disclosed: the gross figure net of illustrative assumed concessions, which Morgan Stanley and Wells Fargo were directed to use. | |||||
| 33 | Run-rate synergies, downside | $m | 1,000.0 | Illustrative: half the net figure. | |||||
| 34 | Run-rate synergies, selected scenario | $m | 2,000.0 | Pre-tax EBITDA once fully phased in. Base: the net $2.0bn. Downside: half of it. Upside: the gross $2.75bn. | |||||
| 35 | Synergies 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). | ||
| 36 | Operating cost to achieve the synergies | $m | 170.0 | - | - | - | Disclosed: $170m, in the first year of the phase-in. | ||
| 37 | Capital spending to achieve the synergies | $m | 1,000.0 | 1,000.0 | - | - | Disclosed: $2.0bn, half in each of the first two years. | ||
| 39 | Financing and accounting (joint proxy pp.49 to 50) | ||||||||
| 40 | Cash 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. | |||||
| 41 | Interest rate on the new debt | % | 5.0% | Disclosed assumption: "a reasonable interest rate of 5%". Each 0.125% is about $25m a year. | |||||
| 42 | Interest forgone on cash applied | % | 4.0% | Illustrative. | |||||
| 43 | Issuance and liability management costs | $m | 190.0 | Disclosed: paid in cash and amortised over 15 years. | |||||
| 44 | Amortisation period of those costs | years | 15 | Disclosed. | |||||
| 45 | Union Pacific merger costs | $m | 190.0 | Disclosed estimate; expensed, so outside adjusted earnings. | |||||
| 46 | Tax rate on the adjustments | % | 24.2% | Disclosed: federal and state statutory rates as Union Pacific discloses them. | |||||
| 47 | Write-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. | |||||
| 48 | Composite depreciation rate on a write-up | % | 2.8% | Disclosed: $10bn more property adds $275m of depreciation a year (p.50). | |||||
| 50 | Balance sheet and dividends | ||||||||
| 51 | Union Pacific debt at 30 June 2025 | $m | 32,813.0 | Disclosed: $2,522m due within a year and $30,291m after (joint proxy p.43). Held to completion. | |||||
| 52 | Norfolk Southern debt at 30 June 2025, book | $m | 17,367.0 | Disclosed: $903m and $16,464m (p.43). | |||||
| 53 | Fair value adjustment to Norfolk Southern’s debt | $m | (1,348.0) | Disclosed: the pro forma records the debt at fair value (p.47). | |||||
| 54 | Norfolk Southern cash at 30 June 2025 | $m | 1,303.0 | Disclosed (p.43). | |||||
| 55 | Union Pacific interest expense, 2024 | $m | 1,269.0 | Disclosed (p.42). | |||||
| 56 | Norfolk Southern interest expense, 2024 | $m | 807.0 | Disclosed (p.42). | |||||
| 57 | Rate on the existing debt | % | 4.1% | Derived: 2024 interest over the June 2025 debt. Illustrative as a forward rate. | |||||
| 58 | Union Pacific quarterly dividend | $ per share | 1.42 | Disclosed: 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.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- 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.
- 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.
- 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.
| Output | Baseas shipped | Downside | Upside |
|---|---|---|---|
| Value per Norfolk Southern share | 320.00 | 320.00 | 320.00 |
| Former Norfolk Southern holders’ ownership | 27.5% | 27.5% | 27.5% |
| New debt | $19,970.3m | $19,970.3m | $19,970.3m |
| Accretion / (dilution), FY2029E | 8.7% | 4.5%-4.2 pts | 11.9%+3.1 pts |
| Breakeven run-rate synergies, FY2029E | $-83.6m | $-83.6m | $-83.6m |
| Debt / EBITDA at completion | 3.4x | 3.4x | 3.4x |
What each case assumes
| Run-rate synergies, selected scenario | 2,000.0 | 1,000.0 | 2,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%
The sensitivity grid, as heatmaps
FY2029E accretion / (dilution): property write-up by run-rate synergies
| Property write-up ($m) ↓ / Run-rate synergies, pre-tax ($m) → | 1,000.0 | 1,500.0 | 2,000.0 | 2,500.0 | 3,000.0 |
|---|---|---|---|---|---|
| - | 4.5% | 6.6% | 8.7% | 10.8% | 12.9% |
| 5,000.0 | 3.7% | 5.8% | 7.9% | 10.0% | 12.1% |
| 10,000.0 | 2.9% | 5.0% | 7.1% | 9.2% | 11.3% |
| 15,000.0 | 2.1% | 4.2% | 6.3% | 8.3% | 10.4% |
| 20,000.0 | 1.2% | 3.3% | 5.4% | 7.5% | 9.6% |
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.
Purchase price and consideration
Offer, premium, mix, new shares, exchange ratio
Assumptions, rows 9–15 · Purchase Price, rows 5–9 · Purchase Price, rows 12–19 · Purchase Price, rows 22–26 · Shareholder View, rows 5–11 · Shareholder View, rows 14–20
Sources and uses
What the deal costs and who funds it
Sources & Uses, rows 5–10 · Sources & Uses, rows 13–17 · Sources & Uses, rows 20–21
Debt schedule
Tranches, interest, amortisation and the sweep
Assumptions, rows 40–45 · Assumptions, rows 51–58 · Pro Forma EPS, rows 13–15 · Leverage, rows 6–10 · Leverage, rows 18–25 · Leverage, rows 28–30
Synergies
Run-rate, phase-in, after tax
Assumptions, rows 31–37 · Pro Forma EPS, rows 11–12 · Pro Forma EPS, rows 17–19 · Leverage, rows 13–15
Purchase accounting
The write-up that amortises
Assumptions, rows 47–48 · Pro Forma EPS, row 16
Tax
Tax on profit, and tax on operating profit
Assumptions, row 46 · Pro Forma EPS, row 18
Pro forma EPS: accretion and dilution
Standalone to pro forma, per share
Assumptions, rows 18–20 · Assumptions, rows 23–28 · Pro Forma EPS, rows 6–8 · Pro Forma EPS, rows 22–28 · Pro Forma EPS, rows 31–38 · Pro Forma EPS, rows 41–44
Contribution analysis
What each side brings against what it owns
Contribution, rows 6–9
Sensitivity tables
Two assumptions at once, without a data table
Sensitivity, rows 5–6 · Sensitivity, rows 9–16
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.
Build · Lab · ~8 min
Accretion / Dilution Animator
Call a deal accretive or dilutive from P/E, premium and financing mix before you open a model.
Build · Lab · ~15 min
Optimal Capital Structure
Explain why more debt stops helping: watch coverage, rating and spread move as leverage rises until WACC turns.
Read · Guide · 14 min
How to Build a Merger Model: Purchase Accounting, Financing and Accretion
Read · Guide · 8 min
M&A Interview Questions: Accretion/Dilution and Beyond
Read · Guide · 7 min
Enterprise Value vs. Equity Value, Once and For All
Apply · Skill
Accretion and Dilution
Show what the deal does to the acquirer’s earnings per share.
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
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.
No questions yet. Ask the first.