Gutenberg Research
  • Home
  • Models
  • Education
    • Cooperative Education Program >
      • Enroll Today >
        • Program Enrollment (Virtual)
        • Program Enrollment (Bootcamp - Boston)
        • Program Enrollment (Bootcamp - New York)
      • Training Hub (Winter'22-'23) >
        • Meetings >
          • Kick-off Call/Orientation (Winter'22-'23)
          • Meeting 1: Building the Model (Winter'22-'23)
          • Meeting 2: Entering Your Forecast Into The Model (Winter'22-'23)
          • Meeting 3: Target Valuation (Winter'22-'23)
          • Meeting 4: Live Starbucks Release (Winter'22-'23)
          • Meeting 5: Live FOMC Policy Release & ERP Update (Winter'22-'23)
        • Classes >
          • Class 1 - Introduction to Financial Modeling (Winter'22-'23)
          • Class 2 - Building the Income Statement (Winter'22-'23)
          • Class 3 - Balance Sheet and Cash Flow Modeling (Winter'22-'23)
          • Class 4 - Model Calibration & Forecasting (Winter'22-'23)
          • Class 5 - The DCF Inputs: Beta, ERP, CAPM, & WACC (Winter'22-'23)
          • Class 6 - Discounted Cash Flow Valuation (Winter'22-'23)
          • Class 7 - Market Multiple-Based Valuation (Winter'22-'23)
          • Class 8 - How to Use Your Earnings Model (Winter'22-'23)
    • Books >
      • Procrastinator's Guide - SBUX >
        • Templates - SBUX
      • Book Registration - Third Edition >
        • Templates - Third Edition
      • Book Registration - Second Edition >
        • Templates - Second Edition
  • About
    • Contact
    • Email Distribution Sign-up
    • Terms of Use
    • Privacy Policy

Contributor 130's Contributor Page


Company: Union Pacific Corp (NYSE:UNP)

Union Pacific Corp (UNP).xlsx
File Size: 212 kb
File Type: xlsx
Download File

Last Updated: March 30, 2019
View: Neutral
Model Approach: This model uses estimates of rail carloads and average revenue per car to forecast UNPs revenue, and ratio analysis to complete the financial statements.
​ 
Model Developer Summary: 
Overall, Union Pacific Corporation seems stable, and based on the enclosed valuation, the market does not appear to grossly undervalue or overvalue the firm.

UNP is not heavily dependent on leverage, which is positive in a time when interest rates are increasing. The firm also appears to be focused on implementing operating efficiencies into 2020. This highlights that near term operating expenses should be in-line with historical operating expenses. But, it could also signal the that the firm is anticipating and/or preparing for a decline in revenue within the next several years. The company's outlook for 2019 and 2020 seems stable, however, with margins expected to improve and revenue growth expected to outpace inflation (which the fed is currently forecasting long-term at 2%). Capital expenditures are in line with historical spending.

One concern is how UNP's revenue will perform beyond 2020. The company's largest segment is currently "premium", which contains domestic autos and international goods. Both of these areas could be greatly impacted due to economic uncertainty and/or trade dynamics between the US and other countries, which could occur in the later years of this analysis. To account for this risk, the "premium" segment's revenue performance is projected to lag the other three segments in the model in 2021. Other concerns include rising prices for diesel fuel (UNP's second largest operating expense; represented 18% of total 2018 operating expenses) and the market return investors expect in the next several years. Both are taken into account within the model to an extent, and support the statement that the market is not grossly overvaluing or undervaluing UNP.

Disclosure of conflicts of interest:
The model developer has no financial investment or other conflict of interest related to the subject company or other companies discussed. Any views made or implied in the content represent the author’s opinions.
Gutenberg Research is a media and education company. The information presented on our website and within Gutenberg Research models, files, or other content does not represent investment advice. Data and information presented on this website, or on third party websites posted by us, within our models, files, and other content is for demonstration only, and is presented “as is”. Neither Gutenberg Research nor any Gutenberg Research agents or associates are liable for any errors, delays, incompleteness of data presented, or for actions taken based on reliance on any information contained on this website or within Gutenberg Research models or other content. Investors should consult a professional investment adviser prior to making investment decisions. By accessing this site and/or receiving our models or other content you are deemed to have read and agreed to our Terms of Use posted on this website. This website uses Cookies, refer to our Privacy Policy for details. The Gutenberg Research logo is among the registered and unregistered trademarks of Gutenberg Research LLC. © Gutenberg Research LLC 2023. All Rights Reserved.