Union Pacific Corp. (UNP)

[Dividend Watcher]

Union Pacific Corp.
(NYSE: UNP)

GICS Sector: Industrials
Sub-Industry: Railroads

In this installment, I am looking at Union Pacific as part of the railroad industry in general. If you wish to see the why's about these spreadsheets, see the thread on NSC located here.

About Union Pacific Corp.

From their latest annual report for 2024:

Quote:UPRR is a Class I railroad operating in the U.S. We have 32,880 route miles, connecting Pacific Coast and Gulf Coast ports with the Midwest and Eastern U.S. gateways and providing several corridors to key Mexican and Canadian gateways. We serve the western two-thirds of the country and maintain coordinated schedules with other rail carriers to move freight to and from the Atlantic Coast, the Pacific Coast, the Southeast, the Southwest, Canada, and Mexico. Export and import traffic moves through Gulf Coast, Pacific Coast, and East Coast ports and across the Mexican and Canadian borders.

My Spreadsheet

Attached to this thread is the latest copy of my analysis spreadsheet on UNP. The spreadsheet has data back to 2007. I wanted to show what affects the Great Recession (2008-2009) had on their financials.

I've added a few features from previous editions.

• I've added railroad specific statistics for any railroad analysis sheets. CN/CNI reports on these consistently for the last 10 years and have quite a variety of statistics they discuss. The other railroads seem to pick only what they want to show. See the notes on the spreadsheet.
  
  
• Revenue is broken down into the different categories of products transported. Usually this does not total 100% of GAAP reported revenues as there are miscellaneous other sources also. I just wanted to get a feel for which sectors of the economy make up their sales.
  
  
• Lastly, I've added a graph to the share price history tab. This is a rough version of the FastGraphs graph with data points based on the previous years' results. If you don't like it, you can just delete it. It just helps me look at valuation.
  
  

I'd appreciate any feedback or thoughts on improving these spreadsheets.

Disclosure:

I own shares of UNP in my IRAs.