...

UNP Exhibits Industry Strength Union Pacific Corporation (UNP) April 19, 2016

by user

on
Category: Documents
19

views

Report

Comments

Transcript

UNP Exhibits Industry Strength Union Pacific Corporation (UNP) April 19, 2016
Krause Fund
Spring 2016
Union Pacific Corporation (UNP)
April 19, 2016
Stock Rating:
Industrials – Railroads
Analysts
Current Price $82.84
Target Price Range $86 – 96
Nicole Gierman
[email protected]
Sam Stecker
[email protected]
UNP Exhibits Industry Strength
Troy Radtke
[email protected]
Carson Goodale
[email protected]
• Location of Rails & Int’l Transportation – UNP
has access to every state west of Chicago as well as all gateways
to Canada and Mexico. Their intermodal distribution also allows
for transportation of commodities between the U.S. and abroad
Company Overview
Union Pacific Corporation (UNP) is one of the dominant
transportation companies in North America. It provides
customers in 23 states with transportation via railroads
through its principal operating company of Union Pacific
Railroad Company – this is comparable to its main
competitor, Burlington Northern Santa Fe, which operates in
28 states. Union Pacific is a Class I railroad that connects the
Western two-thirds of the United States with Canada and
Mexico with its rail networks consisting of over 32,000 miles.
UNP’s advantage over its competitor’s includes providing
services using over 8,500 locomotives to move its diversified
business mix which consists of Agricultural Products,
Automotive, Chemicals, Coal, Industrial Products and
Intermodals.
Stock Performance Highlights
52 week High
52 week Low
Beta Value
Average Daily Volume
HOLD
$111.38
$67.06
1.111
5.9 m
• Diverse Product Mix – diversification of commodities
in UNP’s product mix has allowed for stable revenues over the
past seven years and reduces risk exposure
• Low Oil Makes Intermodal Attractive – surpluses
of oil inventory have resulted in decreased oil prices, making
transportation via intermodal more attractive for consumers and
more profitable for Union Pacific
• Decrease in Coal Causes Concern – shift toward
cleaner energy has caused a decline in freight revenues in one of
Union Pacific’s largest commodity groups
• Increase in Capital Expenditures – Union Pacific is
spending more on capital expenditures to make rail freight
transportation safer and more efficient
One Year Stock Performance
Share Highlights
Market Capitalization
Shares Outstanding
Book Value per share
EPS (TTM)
P/E Ratio
Dividend Yield
$68.46 b
843 m
$24.38
$5.49
14.79
2.67%
Company Performance Highlights
ROA
ROE
Sales
9.41%
22.78%
$21.81 b
Financial Ratios
Current Ratio
Debt to Equity
1.29
68.6%
i
1|Page
Executive Summary
We recommend Union Pacific Corporation as a HOLD.
Union Pacific’s exposure to risk is much lower than its
competitors due to its diversified business mix of six
commodities. We are concerned about the possibility
of rising interest rates which would increase UNP’s
expenses for financing debt, as well as the decrease in
demand for coal shipments. However, we believe that
oil shipments combined with a more efficient
intermodal service will help offset the future losses.
Economic Outlook
Gross Domestic Product
Real GDP was reported as an annualized +1.4% for the
third and final estimate for 2015. This increase in the
revision of the estimate came from the boost in
personal consumption expenditures which came in at a
+2.4% annualized rate.ii This increase in personal
consumption and real GDP positively impacts the
demand on railroad transportation. During prosperous
economic conditions, the industrials sector
outperforms other sectors due to increases in
consumer discretionary spending. Consumers and
businesses in a healthy economy tend to spend more
on goods. This drives demand for the transportation
industry, specifically for larger goods, to be transported
across the country via railroad. In 2002,
transportation-related goods and services accounted
for 10% - over $1 trillion – of U.S. GDP.iii This shows
the strong correlation between the rail freight
transportation and the status of the overall economy.
The 2016 outlook we have for Real GDP is slightly
lower than the 2015 annualized Real GDP. We predict
Real GDP to come in around 2.2% due to a combination
of factors. First, our team believes that personal
income will increase, just as it has every month of this
year. Since the beginning of 2016, personal income has
increased, on average, about 0.33% month over month.
This increase will drive growth in the economy as
consumer spending accounts for two-thirds of the U.S.
GDP.iv We believe this growth will be hindered by the
strengthening of the U.S. Dollar. A stronger U.S. Dollar
indicates a decrease in exports of U.S. goods, and
increasing imports of foreign goods. This impact will
have a negative effect on Real GDP; however, we
believe it will have a positive impact on the railroad
industry, as there will be a demand for transporting
products that are shipped across seas.
Price of Oil
The price of crude oil continues to remain low at
roughly $40 per barrel. There was an important
meeting held Sunday, April 17th in Doha by OPEC to
discuss the possibility of freezing production of crude
oil in order to raise the price of crude oil per barrel.v
After not reaching a production freeze, we believe that
the price of crude oil will remain stagnant around
current prices. These low prices will be a result of
inventory levels as they are at a record breaking 536.5
million barrels.vi
vii
ii
The figure above shows the crude oil inventories for
the United States for the past five years, and shows that
current inventories are 78 million barrels higher year
over year.
2|Page
The decrease in the price of oil has a positive impact on
domestic logistics companies, as fuel expenses are a
major component of their operating expenses. One
concern railroad companies may face is the threat of
competition from trucking companies when oil prices
are lower. Rail transportation is more fuel efficient and
cost effective when fuel prices are high. We believe
fuel prices will return to higher levels if an agreement
with OPEC is reached regarding a production freeze.
Manufacturing Index
The ISM Manufacturing Index level for March rose
2.3% to a plus-50 reading for the first time since
September, 2015.viii This plus-50 reading indicates a
slight growth in the manufacturing industry, and is a
positive signal for the performance in the railroad
industry and economy. Increases in production of new
orders and other manufacturing products will increase
demand for shipment via railroad. With increases in
shipping demands, rail companies will be utilizing
higher capacity of its rail network and rail cars.
Interest Rates
Currently, the effective Fed Funds Rate sits at 0.37%
after an increase of 25 basis points in December. This
minor increase is significant as the Federal Reserve
works toward its goal of 2% inflation; it also decreases
the amount of loanable money. In the short-term, we
believe the Fed will maintain their interest rate range
of 0.25-0.50%. However, due to the high amount of
money in circulation, we predict a large increase in
interest rates in the next 3-5 years. This will impact
companies in all sectors by making debt financing more
expensive due to an increase in the cost of debt. The
railroad and trucking industries are very capital
intensive meaning this increase in interest rates will
have a large impact on the industry and will slow
growth in the long run.
Capital Markets Outlook
Data from 2015 has shown a strong correlation
between the S&P Industrials Index and the S&P 500
with a value of 0.94.x This positive correlation is also
reflected in the returns over the past 5 years. The S&P
500 Index has had returns of approximately 57.67%;
while the S&P Industrials Index has seen returns of
50.96%.xi
This information is reflective of the seasonality of the
industrials sector and its dependence on market
performance. During prosperous economic times, the
industrials sector tends to perform in line with the
market; at the same time, when markets are in
recession, the industrials sector follows suit and
underperforms the S&P 500 index.
ix
The graph above shows the manufacturing index data
over the past 58 years with the highlighted areas
showing the 11 economic recessions that have
occurred during this time. The Manufacturing Index
data reported before four of the eleven recessions
shows values above the favored 50% mark; this shows
that this index is not a completely viable way of
forecasting for the economy. However, in the shortterm outlook, this boost in manufacturing will have a
positive impact on the railroad industry.
From this information, we believe the best time to
invest in the industrials sector would be during a
recession. Industrials are very cyclical and tend to
outperform other sectors early on as the economy
recovers from the recession.
Industry Analysis
Industry Overview
The industrials sector is comprised into three main
sectors. The three sectors according to the Global
Industry Classification System are capital goods,
commercial services, and transportation. The three
main industrials sectors are split up into thirteen
3|Page
different sub-sectors. First, the capital goods sector is
comprised of aerospace and defense, building products,
construction and engineering, electrical equipment,
industrial conglomerates, and machinery. The
commercial services sector includes commercial
services and supplies. Finally, the transportation sector
consists of air freight and logistics, airlines, marine,
road and rail, and transportation infrastructure.
Throughout the remainder of this report, we will be
focusing on the road and rail industry of the
transportation sector.
railroad companies’ total miles of track and revenues.
When comparing the seven companies, we can see that
Union Pacific’s greatest competition comes from BNSF.
2015 Class 1 Rail
Revenues (Billions)
$21.81
$21.97
$10.51
$2.42 $11.25
$12.03
BNSF
Canadian National
Canadian Pacific
Kansas City Southern
Norfolk Southern
Union Pacific
The chart above breaks down the 2015 revenues for
the seven Class I railroads. Union Pacific finished 2015
with revenues of $21.81 billion, falling only short to
Burlington North Santa Fe which reported revenues of
$21.97 billion. Union Pacific and BNSF both have
32,000 miles of track spanning across the United
States. The figures below show the seven Class I
Miles of
Track
BNSF
$21.97
32,000
Canadian Pacific
$11.25
15,000
Canadian National
Sub-Industry Railroads
The United States freight rail network is widely
considered one of the most dynamic freight systems in
the world. The $60 billion industry is comprised of
seven Class I rails (railroads with operating revenues of
$433.2 million or more), 21 regional railroad, and 510
local railroads. All together, these railroads span over
140,000 miles of rail track. The seven Class I freight
railroads consist of BNSF Railway, Canadian National,
Canadian Pacific, CSX Transportation, Kansas City
Southern Railway, Norfolk Southern Combined
Railroad Subsidiaries, and Union Pacific Corporation.
These seven Class I freight railroads make up over 70%
of all the rail track within the United States.xii
Revenues
(billions)
Company
CSX Transportation
Kansas City
Southern
Norfolk Southern
xiii
Union Pacific
$12.03
$11.81
$2.42
$10.51
$21.81
21,421
21,000
6,000
20,000
32,000
Products
Below is a chart showing the different segments of
revenue for the railroad industry. The segments of
revenue consist of food and consumer goods market,
consumers, agricultural market, miscellaneous mixed
shipments, chemical market, coal market, industrial
goods market, and other revenues. The three main
segments are chemical market at 13.6%, coal market at
18.7%, and industrial goods market which is 24.1%.
Recent Developments and Trends
Government Regulation
The Railroad industry plays a critical role in the U.S.
economy, and reaches almost every state. Due to this
xiv
4|Page
nature, the government heavily regulates this industry
to ensure a safe environment for transportation of
goods for industry workers and consumers.
One recent requirement for railroad companies was the
development and implementation of Positive Train
Control (PTC) which was a part of the Rail Safety
Improvement Act passed by Congress in 2008. This act
was a response to several fatal accidents that occurred
between 2002 and 2008.xv Initially, railroad companies
were required to develop and install highly advanced
technologies designed to make freight rail
transportation even safer by automatically stopping a
train before certain types of accidents occur by 2015.xvi
This deadline was proved “unworkable” by railroad
companies; they were given a 3-year extension to
complete the installation of PTC by December, 2018.
One major issue that companies face is the costs
associated with the financing of PTC and maintenance
of current infrastructure as companies must privately
fund and develop all aspects of PTC and future projects.
To date, railroad companies have spent approximately
$6 billion on PTC development and deployment.xvi
Based on our analyses and predictions for future, longterm interest rates, we believe these expenses will
gradually increase over the remainder of the three
years as the cost of debt for rail companies will
increase. While the benefits of PTC includes a safer
environment for railroad workers and the general
public, in the end, the expenses associated with this
project will hurt future earnings and cash flow across
all rail companies.
Shift Towards Cleaner Energy Sources
Recent advances in technology have launched a shift
towards using cleaner energy sources such as natural
gas and renewable energy like wind. This is
detrimental to the railroad industry as, historically,
coal has been the single most important single
commodity carried by U.S. railroads.xvii Use of cleaner
energy has decreased the demand on coal, thus
decreasing the revenues generated from shipping coal.
For example, the year-over-year data from March 2015
to March 2016 of coal shipments show a decrease of
35.9%, or 188,250 carloads.xviii This decrease will have
lasting impacts across the industry – in order to combat
this, rail companies will have to diversify their business
mix in order to salvage their bottom line.
Porter’s Five Forces
Threat of New Entrants
The railroad industry is highly capital intensive
especially for companies that are considered Class I
Railroads. For example, from 2002-2011, the
Association of American Railroads stated that the
average U.S. manufacturer had a CapEx to Revenue
ratio of 3.0%, while rail freights had a CapEx to
Revenue ratio of 17.0%.xix This large amount of capital
expenditure for developing and maintaining
infrastructure makes its nearly impossible for new
entrants to enter the market. In the end, we believe
there is little threat of new entrants in this industry.
Competitive Rivalry
Although Class I Railroads include seven companies,
the industry is dominated by four – Burlington
Northern Santa Fe Corporation (BNSF), Union Pacific
Corporation (UNP), CSX Corporation (CSX), and Norfolk
Southern Corporation (NSC). These companies account
for 87.4% of the market share in this industry.
Within the industry, companies compete on the basis of
travel time, fuel consumption, safety, regulations, and
destinations.xix All companies are required to comply
with regulations set forth by the government; many of
these regulations surround the safety of rail workers
and the transportation of commodities.
As for rail destinations, the map below shows the
different locations in which the seven largest railroads
compete. The map shows that the firms compete in
different locations rather than concentrating on one or
two sections of the U.S. UNP and BNSF have operations
in the Midwest and Western United States, while CSX
and NSC have a large presence on the Eastern part of
the U.S. This creates large competition among the firms
in their respective locations.
5|Page
xx
In addition to destinations, these same firms also
compete on the basis of travel time and fuel
consumption. Companies improve on these factors by
improving infrastructure, including trains and tracks,
in order to improve transportation time and fuel
efficiency. The chart below compares the dwell time
and train speeds of the four key players in the industry.
The combination of low dwell time and faster speed
increases reliability and efficiency of railroad
infrastructure.
Dwell Time
(Hours)
Train
Speed
(MPH)
xxi
UNP
BNSF
27.1
28.7
26.8
24.1
CSX
25.3
21.0
NSC
23.3
Bargaining Power of Suppliers
Capital expenditures in the rail industry create high
barriers of entry for potential competition – this same
factor also creates strong bargaining power for
suppliers. Companies are dependent on a select
number of suppliers to provide reliable equipment and
infrastructure. The low number of suppliers of
locomotives and rails proves that there are high
barriers of entry for railroad suppliers. A decrease in
manufacturing of locomotive engines and rails from
suppliers would create significant expenses for all
companies in the industry. In order to keep these
expenses reasonable, companies must keep suitable
relationships with their suppliers.
Threat of Substitutes
Freight can be moved in ways other than by railroad,
thus creating threats of substitutes for the railroad
industry. Substitutes include other modes of
transportation such as trucks, airplanes, barges, and
pipeline. The chart below shows a breakdown of the
amount of freight in percent ton-miles moved by each
mode of transportation. From this, we are able to see
that rail’s greatest threat comes from transportation
via trucks. Railroads see an advantage over trucking
for shipping larger loads of freight over longer
distances. Rail also benefits when fuel prices are
higher as they tend to be nearly four times more fuel
efficient than trucks.xxii
23.8
When comparing these companies, it is also critical to
consider the diversification of their business mix. As
stated earlier in the report, we believe the shipment
volumes of coal and its revenues will continue to
decrease, thus making it crucial for companies to
diversify their product mix in order to manage their
losses. Although UNP has lower train speed and
greater dwell time, they have a more diversified
business mix consisting of six commodities compared
to BNSF’s business mix of four. This allows Union
Pacific to continue to compete with BNSF despite UNP
trailing in other factors such as dwell time and train
speed.
xxiii
In response to this competition, railroad companies
have implemented intermodal transportation. This
solution combines transportation of freight by
combining railroads with trucks or barges. Intermodal
has become the fastest growing segment in North
6|Page
American freight transportation with nearly 25 million
containers moving across the continent each year.xxii
Bargaining Power of Buyers
Due to competition with substitute, we believe the
bargaining power of buyers to be medium. We came
up with this based on the diversification of
commodities transported by railroads across the
industry as well as the threat of substitutes railroads
face. In order to mitigate any risk associated with their
business mix, rail companies choose to ship
commodities with low correlation among each other.
This results in wide exposure – if a few commodities
perform poorly, it is typically offset by the remaining
commodities in the diversified mix. At the same time,
consumers have the ability to have their products
shipped in a more time-efficient manner via trucks. For
these reasons, we believe the bargaining power of
buyers is moderate.
Industry Leaders and Followers
There are seven companies in the railroad industry, but
there are four major companies that make up over 87%
of the market share for the railroad industry. The
impact on how large these four major companies are on
the railroad market can be seen in the table below.
Company
UNP
BNSF
CSX
NSC
CP
CNI
KSU
xxiv
Market
Cap
$61.18B
N/A
$24.92B
$24.15B
$22.30B
$49.83B
$9.89B
P/E
14.73
N/A
13.04
16.00
22.25
18.55
20.79
Market
Share
29.6%
N/A
14.4%
13.3%
6.6%
4.3%
1.7%
Profit
Margin
21.88%
N/A
16.66%
14.80%
20.14%
28.06%
19.99%
(BNSF was acquired by Berkshire Hathaway in 2009, so its numbers are
disregarded in the above table)
Market capitalization is an important instrument in
comparing the seven Class I railroad companies with
each other. It measures the market value of shares
outstanding of a company. As seen above, UNP has the
greatest market cap of all the railroad companies at
$61.18 billion.
Price-to-earnings ratio is able to suggest the dollar
amount investors can expect to invest in order to
receive $1 of a company’s earnings. It is a tool that can
also be used to help determine a company’s future
earnings growth. A higher P/E ratio suggests that a
company is going to have a higher earnings growth
than that to a company that has a lower P/E ratio.
Union Pacific has the fifth highest P/E ratio amongst
the seven Class I railroad companies.
Market share is able to show how large a company is
compared to its competitors. Market share is
calculated by taking a company’s sales and dividing
them by the total sales of the industry. Union Pacific
has the greatest market share at 29.6%, excluding
BNSF due to it being acquired by Berkshire Hathaway.
Profit margin measures how much out of every dollar
generated by sales a company actually keeps in
earnings. Profit margin gives us an idea of how much
revenue is being made after all expenses are paid. CNI
has the greatest profit margin of the seven Class I
railroad companies, with UNP coming in second with a
profit margin of 21.88%.
Catalysts for Growth/Change
Oil Prices
With oil prices continuing to decrease, the input prices
for companies such as Union Pacific also decrease
which allows for Union Pacific to increase its profit
margin. Oil inventory levels are the highest they have
ever been, increasing the amount of transportation
needed for oil. However, the lowering of oil prices also
has drawbacks for the company. Transportation by
railroad is much cheaper than other forms of
transportation when fuel prices are high. With fuel
prices so low, it makes it easier to ship with trucking or
other forms of transportation due to the lower cost.
Consumer Spending
The Consumer Confidence Index increased to 96.2 in
March, up 2.2 points from February.xxv Consumer
spending will also increase due to a rise in consumer
confidence. The railroad and transportation industries
are directly affected by an increase in consumer
spending. With an increase in consumer spending,
comes an increase in transportation of these products
that are now being purchased. UNP has a great
opportunity to capitalize on being able to transport the
abundance of products being transported due to higher
consumer spending.
7|Page
Company Analysis
Overview and Business Description
Union Pacific Corporation (UNP) is one of the largest
transportation companies in North America, mainly
operating in the western two-thirds of the United
States. UNP provides customers in 23 states with
transportation via railroad networks consisting of
32,084 rail miles. Only Burlington North Santa Fe is
larger, operating in 28 states with 32,500 rail miles.
UNP is a Class I railroad with over 8,500 locomotives
currently in operation. UNP is the only rail
transportation with access to all the major gateways in
the United States, Mexico, and Canada. The freight
traffic of UNP is broken down into three main
categories: bulk, manifest, and premium business. Bulk
traffic relates to transportation of a single commodity
from one source to one destination. Manifest traffic
pertains to individual carloads or less than train-load
business transporting commodities. Lastly, the
transportation of auto parts or intermodal containers
takes up what is called the premium business. UNP has
a diversified product mix consisting of six main
commodity groups. These six main commodity groups
are agricultural products, automotive, chemicals, coal,
industrial products, and intermodals.
flow from financing activities has also been negative
and is driven heavily by their repurchases of common
and preferred stock. This proves that Union Pacific is
in the maturity stage because they are able to purchase
assets that are critical to business activities using
capital. The negative values of financing cash flow
shows that the company is not dependent on outside
investors to raise capital – they have generated enough
cash that they are able to afford stock repurchases
while paying dividends.
Products
In 2015, UNP was able to generate $20.4 billion in
freight revenues from the six major commodity groups.
Below is a chart showing the revenue breakdown of the
six major commodities for 2015.
Life Cycle
In order to determine that Union Pacific is in the
Maturity Stage of the life cycle, we started by looking at
the Income Statement and analyzing revenues, net
income, and profit margin. Over the past seven years
(2009 to 2015), Union Pacific has reported strong sales
revenue growth year-over-year; this is also
accompanied by stable, positive numbers reported as
net income. The most important metric that proves
that Union Pacific is in the Maturity Stage is their
strong profit margin that was recorded as 21.88% for
FY15. This proves the efficiency of the company as well
as its ability to distribute dividends to investors and
cover any debt.
Next, we analyzed the statement of cash flows in order
to further prove our assumption. Cash flow from
operating activities has been stable and positive since
recovering from the recession in 2008. This is followed
by steady, negative cash flows from investing activities;
this is led by capital expenditures. And finally, cash
xxvi
Intermodal Products
Intermodal business is broken down into two
segments: international and domestic. Together,
international and domestic intermodal products make
up the largest portion of Union Pacific’s 2015 freight
revenue at 20%. International intermodal products
mainly consist of the importation and exportation of
container traffic through the ports along the West
Coast. International intermodal declined 8% from 2014
to 2015 and accounted for the overall 6% decline in
carloadings. This decline was attributed to supply chain
distributions stemming from the West Coast port work
disruptions.xxvi We believe this decrease is also
impacted by the appreciation of the US Dollar as
consumers abroad must pay a premium for USproduced goods, thus decreasing international
shipments by Union Pacific. Domestic intermodal
8|Page
business includes the container and trailer pick-up and
delivery within North America.
Industrial Products
Industrial products generated the second most revenue
in 2015 for Union Pacific at 19%. Industrial products
include construction products, minerals, consumer
goods, metals, lumbar, paper, and other miscellaneous
products. Industrial products declined 13% from 2014
to 2015. We believe that this relates to large
inventories of oil and not having the need to drill for
oil. Oil drilling increases the demand for raw steel,
finished pipe, frac sand, and stone and drilling fluid
commodities.
Coal
Shipments of coal accounted for 16% of Union Pacific’s
2015 freight revenue. Volume shipments of coal have
been on the decline, especially for fiscal year 2015
where coal revenues dropped 22%. An overabundance
of supply and low natural gas prices have left Union
Pacific with the challenge of taking on extra expenses
associated with the shipment of coal. As utility
companies shift towards using other fuel sources such
as natural gas, we believe Union Pacific will continue to
see negative impacts from shipping coal. There is also a
trend for consumers and businesses to use cleaner,
more environmentally friendly means of energy and
coal doesn’t meet that standard. Coal consumption and
production have declined recently, and coal production
is expected to decrease by 16% in 2016, the largest
annual decline in coal production since 1958.xxvii We
believe that coal shipments are going to continue to
decline going forward. Union Pacific needs to assess its
future shipping demands in coal in order to minimize
losses.
Chemicals
The transportation of chemicals generated 17% of
freight revenues for Union Pacific in 2015, down 3%
from the previous year. Union Pacific’s chemical
shipments include four categories: industrial
chemicals, plastics, fertilizer, and petroleum and liquid
petroleum gases. The majority of the chemical
shipments for Union Pacific are from Gulf Coast areas,
where 60% of the chemical companies for Union Pacific
originate.
Automotive
Union Pacific is the largest automotive carrier west of
the Mississippi river and has access to over 40 vehicle
distribution centers. Freight revenues generated by the
transportation of automotive products was 11% of
total freight revenues, up 2% from the previous year.
Although automotive revenues made up the smallest
portion of total freight revenues for 2015, we believe
that automotive shipments are going to continue to
rise, thus experiencing a positive impact on automotive
freight revenue going forward.
Agricultural Products
Agricultural products made up for 17% of total freight
revenues for 2015, a 5% decline year over year.
Agricultural products include the shipment of grains,
foods, grain processors, animal feeders, and ethanol
producers.
Competition
Union Pacific has a large presence to the West of
Chicago and Memphis, expanding to gateways in
Canada and Mexico. Based on their geographic location
and routes, UNP’s main competition within the railroad
industry comes from Burlington Northern Santa Fe
(BNSF) as it operates parallel routes in many of Union
Pacific’s corridors.xxviii An advantage that Union Pacific
holds over BNSF is its accessibility to a larger number
of international corridors into Mexico and Canada.
Union Pacific also has greater diversification of its
business mix with six commodities, while BNSF only
has a business mix of four commodities. This increased
access to the corridors as well as its diversified
business mix gives Union Pacific a competitive
advantage over BNSF. Union Pacific has the ability to
reach a larger amount of consumers internationally,
while also being able to offset any losses generated by
falling shipments in commodities.
In addition to other rail companies, Union Pacific faces
competition from trucking, airplane, and barge
companies. One large advantage these firms have over
Union Pacific is the public funding for infrastructure
and roads. Union Pacific is responsible for maintenance
associated with its rails and locomotives; this increased
expense is then passed on to the consumer. The use of
roads also allows for greater accessibility to reach
customers and geographic areas that don’t fall within
Union Pacific’s reach. To compete with these
9|Page
companies, Union Pacific uses its intermodal
distribution to reach greater amounts of end
consumers. Union Pacific must also compete heavily
with these other modes of transportation when fuel
prices are low. Low fuel prices allow for trucking,
airplane, and barge companies to keep prices and costs
low; however, when fuel prices are high, railroads
benefit as they are more fuel efficient.
Investment Positives
•
•
•
Diversified product mix decreases exposure to
risk associated with lower shipment volumes
Increased inventory of oil is driving growth in
oil shipment via rail
UNP has a low debt-to-equity ratio compared to
its competitors
Investment Negatives
•
•
•
Demand for coal will decrease, causing lower
shipment volumes over forecasted 5-6 year
period
Low fuel prices push consumers to substitute
rail shipping for other modes of transportation
Rising interest rates will increase the cost of
debt and financing for Union Pacific
Valuation Analysis
For this report, we used four types of valuation models
to conclude that Union Pacific is undervalued. We used
a Discounted Cash Flow analysis, Economic Profit
analysis, Dividend Discount Model, and relative
valuation to come up with our assumption. From our
analyses, we have determined Union Pacific to be a
HOLD with an intrinsic stock price above the current
trading price of $82.84.
Our DCF and EP models gave us an intrinsic value of
$91.47. This is a premium of 10.4% relative to its
current trading price on April 19, 2016. As for our
DDM model, we produced a price of $80.10 – a discount
of 3.42% from its current price. We then used Relative
Price-to-Earnings (P/E) and PEG ratios for our relative
valuation models. The Relative P/E ratio gave us the
intrinsic values of $101.25 and $86.07 for 2016 and
2017 respectively – both are premiums of 22.22% and
3.90%. For our PEG ratio, we found the values to be
premiums for both 2016, at $109.57, and 2017, at
$102.11. Both of these numbers came in at premiums
of about 32.27% and 23.62% respectively.
General Assumptions
Revenue Decomposition
In order to determine future revenue streams for
Union Pacific, we looked at previous data starting after
the 2008 recession. This was a critical time period to
choose as we believe the recovery of Union Pacific and
the economy as a whole is in a much different state
than it was prior to, and during, the recession. We
generated revenue growth assumptions for each of the
six commodities that are a part of UNP’s business mix;
after, we estimated the growth in the number of
carloads for each commodity as well.
Forecasting the revenues of each commodity were
chosen by looking for the average growth in revenue
over the previous 5-7 years. Upon finding the change
in growth, we modified our numbers based on any
expectations we had made, or were implied from our
economic and industry outlooks. For example, analysts
believe automotive sales will set a new record in 2016,
driven heavily by low fuel prices.xxix We also
considered other trends for commodities such as coal.
The recent shift towards cleaner energy use has
lowered the demand of coal – we had to be certain that
our revenue decline for that commodity was reflective
of the information reported in our economic and
industry outlooks.
Next, we determined carload growth using the average
growth of carloads from the past 3-5 years. Most of our
decisions were made similar to how we forecasted
revenue growth – we looked at trends set forth from
our economic and industry outlooks to estimate future
growth or decline in commodity carloads.
One factor we thought was important to point out was
that we had decided to be a more conservative in our
estimation of revenue and carload growth. We chose to
10 | P a g e
use these slightly reduced values due to the uncertainty
in economic outlooks. We believe outside factors such
as slow economic growth abroad and the strong U.S.
Dollar may produce lower growth rates than if we had
used a straight-line average.
Income Statement
Compensation and Benefits make up roughly 37.5% of
operating expenses for Union Pacific. They are the
largest driver of these expenses followed by Purchased
Services and Materials which accounts for 17.6% of
operating expenses.
Compensation and Benefits has been increasing over
the past 7 years. We believe this is due to extra
expenditure related to development and
implementation costs of PTC. This project has resulted
in increased hiring and training expenses related to a
larger workforce in the first half of the year.xxviii We
believe these expenses will continue through the
completion of PTC and beyond as Union Pacific will be
responsible for the maintenance of its infrastructure.
These expenses will also be maintained due to our
forecasted increase in interest rates, thus resulting in
inflation of wages and in the economy as a whole.
We also believe PTC has influenced expenses relating
to Purchased Services and Materials. This expense
includes services purchased from outside contractors
and other services providers, as well as materials used
to maintain UNP’s lines, structure, and equipment.
There was a decrease in these expenses from this line
item due to lower locomotive and freight car repair
costs. xxviii We believe these costs will continue for
reasons similar to Compensation and Benefits.
Based on these observations, we chose to grow Cost of
Goods Sold as a percentage of Sales because these costs
make up roughly half of Union Pacific’s operating
expenses.
Balance Sheet
The railroad industry is very capital intensive by
nature, making it important for us to focus on Property,
Plant and Equipment (PP&E) when forecasting our
balance sheet. We estimated growth in PP&E based on
the average CapEx rates for Gross PP&E over the past 7
years. In addition to this, we had to include PTC related
expenses for 2016-2018. PTC expenses were found
based on management discussion as they forecasted
another $825 million will be used over the course of
the next three years to complete the project.
Therefore, we forecasted the largest, most important
component of the balance sheet, PP&E, to reflect
historical CapEx rates adjusted for expenses related to
the PTC project.
Weighted Average Cost of Capital (WACC)
Cost of Equity
To find the cost of equity, we used the Capital Asset
Pricing Model. We obtained our beta using the
Bloomberg terminal to find weekly raw betas for 1, 5,
and 10 years. The raw beta we found, and used for our
project, was 1.111. Next, we found the risk-free rate
from the yield of a 30-year Treasury bond that matures
on February 15, 2046. Our Market Risk Premium was
found using the difference between the expected
market return (7.37%) and the risk-free rate (2.57%)
to come up with the MRP of 4.80%. We used this data
to arrive at our Cost of Equity of 7.90%.
Cost of Debt
We used the yield on Union Pacific’s longest
outstanding bond to find the pre-tax cost of debt. We
then adjusted this by the marginal tax rate to find the
after-tax cost of debt of 2.41%.
Capital Structure and WACC
For our valuation models, we held the assumption that
the capital structure will remain stable through our CV
of 2021. Using the Market Values of Equity and Debt,
we were able to come up with a WACC of 6.82%.
DCF and EP Analyses
Our Discounted Cash Flow and Economic Profit models
gave us an intrinsic stock price of $91.47 which is a
premium based on the current stock price. Our
assumptions for both models came from our Value
Drivers of ROIC, NOPLAT, WACC, EP, Invested Capital,
and FCF.
We started with the DCF Model using Free Cash Flow.
We predict FCF to decrease from 2016 to 2018 because
of the extra CapEx for the PTC project. We expect them
to recover as we predict revenues to grow while
Capital Expenditures decrease. We then used our CV
Growth rate assumption of 1.95% and WACC of 6.82%
to find the Continuing Value of $104,642 million. The
11 | P a g e
WACC was used again to discount the FCFs to find the
present value; the present values were then added
together to find the value of operating assets of
$93,720 million. After adjusting for operating and nonoperating assets, we found the value of equity to equal
$76,493 million. This number, divided by the number
of shares outstanding gave us the intrinsic value of
UNP’s equity; this was then adjusted for the fractional
period of the year as of April 19, 2016 for an adjusted
stock price of $91.47.
Our Economic Profit Model followed similar steps used
in the DCF Model. The main differences we had was the
use of Economic Profit instead of FCF and adding back
beginning invested capital to find the value of
operating assets. We used the same adjustments to
find the value of equity and to find the intrinsic stock
price of $90.08 which was adjusted by the fractional
period of the year. The final adjusted stock price for
the EP Model was equal to the price found using our
DCF Model ($91.47).
When determining our target price range, we relied
heavily on the DCF and EP models and their target
stock price. We believe the stock price found is a better
reflection of our economic, industry, and company
outlooks.
Dividend Discount Model (DDM)
Our Dividend Discount Model was another valuation
method used to find the intrinsic value of our stock.
We used our projected dividends per share and
discounted them back to the present value to find the
intrinsic stock price.
We started by using a payout ratio of 41% - this was
chosen based on the significant increase of almost 7%
in the payout ratio from 2014 to 2015. We used a CV
EPS growth rate of 2.25%; we arrived at this number
because we believe UNP will increase its earnings per
share due to the high number of repurchases it plans
on making. We used the CV EPS Growth rate, Cost of
Equity, and CV ROE to find the P/E Multiple; this was
multiplied by the projected 2021CV EPS to find the
future stock price. This was then discounted, along
with the projected dividends per share for 2016 to
2020, by the cost of equity to find the discounted cash
flows. The sum of these numbers was our intrinsic
value of $78.88 – this was adjusted for the fractional
period of the year to find the adjusted stock price of
$80.10.
We moderately took our DDM stock price of $80.10
into consideration when determining our target stock
price range. We believe UNP has a strong history of
paying dividends, but at this point in time, stronger
outside factors that affect the economy and industry
will play a larger role in determining the value of Union
Pacific.
Relative Valuation
When starting our Relative Valuation, we turned to
BNSF because they are Union Pacific’s largest
competition. We were unable to find the necessary
data for BNSF as they are a fully-owned subsidiary of
Berkshire Hathaway. Had we used the data for
Berkshire Hathaway Class A shares, our data would
have been heavily skewed and obsolete.
In order to find the valuation based on similar
companies, we had to choose the data for the next five
largest rail companies that compete with Union Pacific
– CSX Corporation (CSX), Canadian Pacific Railway
(CP), Canadian National Railway (CNI), Kansas City
Southern (KSU), and Norfolk Southern Corporation
(NSC). We chose to use P/E ratios for 2016 and 2017
when using relative valuation. We found the Relative
P/E prices to be $101.25 for 2016 and $86.07 for 2017.
We believed the price for 2016 was relatively high
given the analyses we completed on the economy,
industry, and company. We believed the 2017 price
was a relatively low, but reasonable starting price for
our target price range.
Sensitivity Analysis
Due to the many assumptions made throughout all of
our valuation models, our prices are sensitive to
certain metrics used from our inputs. We used data
tables to analyze the sensitivity levels of various
structural and operating assumptions and their effects
on stock price.
Beta
The beta we used, as stated earlier in the report, is an
average of the raw betas over different periods of time.
Any change in the beta will be reflected in the stock
12 | P a g e
price moderately. An increase of two tenths (1.311)
will result in a decrease of the stock price by roughly
$15. We are confident in our decision of having a beta
of 1.111 to come up with our intrinsic stock price
because of the cyclical nature and correlation that the
industrials sector, and Union Pacific in particular, has
with the market.
Market Risk Premium
Market risk premium is found by finding the difference
between the expected return of the market and the
risk-free rate. Due to the nature of this assumption,
this value could change based on the risk tolerance and
investing styles of the investor – a riskier investor
would expect a higher return from the market,
resulting in a higher market risk premium. If we
increased our market risk premium we end up getting
a lower intrinsic stock price.
COGS as a percentage of Sales
COGS as a percentage of Sales is similar to SG&A as a
percentage of sales because it is an operating
assumption. Our rate of 48% was chosen based on a
straight-line average over the period of 5 years. We
believe this is a good value because it is reflective of
recent economic and company trends.
Risk Free Rate
Yields on Treasury bonds have recently gone up due to
the Feds raising interest rates to 25-50 basis points.
As a result of this increase, we are able to see that
Union Pacific’s stock price will decrease as it will be
more expensive to finance debt.
CV Growth of NOPLAT
The assumption for CV Growth of NOPLAT is
dependent on the economic outlook and is subject to
preferences by the particular analyst. We have a
moderate growth rate of 1.95% because of our
conservative stance throughout our models given the
nature of the railroad industry. Increasing the CV
Growth of NOPLAT to a more optimistic number such
as 2.45% would cause an increase in our stock price of
about $5.
WACC and Cost of Equity
The WACC is critical to our valuation models as it is
used to discount FCF and EP to find the present value;
the Cost of Equity is important for the discounting of
dividends. The Cost of Equity does not have as
significant a role as WACC; this is seen when we
increase the Cost of Equity 50 basis points – the stock
price does not move as much as when we change the
WACC.
SG&A as a percentage of Sales
SG&A is an operating assumption so management is
able to manipulate the numbers. By controlling the
numbers, management is able to achieve a certain stock
price. If management decides to decrease SG&A as a
percentage of sales, stock price will increase but not by
much.
13 | P a g e
References
Union Pacific Corporation. Google. (n.d.). Retrieved
April 17, 2016, from
https://www.google.com/webhp?sourceid=chrom
e-instant&ion=1&espv=2&ie=UTF8#q=UNP+Stock+1year
ii. GDP. (n.d.). Retrieved March 25, 2016, from
http://www.bloomberg.com/markets/economiccalendar
iii. Bureau of Transportation Statistics. Economic
Impact on Transportation. (n.d.). Retrieved March
15, 2016, from
http://www.rita.dot.gov/bts/programs/freight_tra
nsportation/html/transportation.html
iv. Payne, D. (2016, April 1). GDP Growth Slowed by
Strong Dollar's Drag. Retrieved April 17, 2016,
from http://www.kiplinger.com/article/business/
T019-C000-S010-gdp-growth-rate-andforecast.html
v. Oyedele, A. (2016, April 17). Crude Oil Plunges after
Producers' Meeting in Doha Flops. Retrieved April
17, 2016, from
http://www.businessinsider.com/crude-oil-priceapril-17-2016-4
vi. EIA Petroleum Status Report. (2016, April 13).
Retrieved April 17, 2016,
from http://www.bloomberg.com/markets/econo
mic-calendar
vii. Berman, A. (2016, April 15). Are We On The Right
Track To An Oil Price Recovery? Retrieved April 17,
2016, from http://oilprice.com/Energy/CrudeOil/Are-We-On-The-Right-Track-To-An-Oil-PriceRecovery.html
viii. ISM Manufacturing Index. (n.d.). Retrieved April 17,
2016, from
http://www.bloomberg.com/markets/economiccalendar
ix. Mislinski, Jill. (2016, April 1). ISM Manufacturing
Index: Expansion in March, First in Seven Months.
Advisor Perspectives. Retrieved April 17, 2016,
from
http://www.advisorperspectives.com/dshort/upd
ates/ISM-Manufacturing
x. Bausys, M. (2016, January 12). U.S. Stock Market
Sectors: Correlations. Retrieved April 18, 2016,
from http://seekingalpha.com/article/3805416-us-stock-market-sectors-correlations
i.
xi. Sector Tracker: S&P 500 Index. (n.d.). Retrieved
April 18, 2016,
from http://www.sectorspdr.com/sectorspdr/tool
s/sector-tracker
xii. Freight Rail Today. (n.d.). Retrieved April 18, 2016,
from https://www.fra.dot.gov/Page/P0362
xiii. 140,000-Mile Private Rail Network Delivers for
America's Economy. (n.d.). Retrieved April 18, 2016,
from http://archive.freightrailworks.org/network/
union-pacific/
xiv. IBISWorld. (2016). IBISWorld. Retrieved from
Industry at a Glance
http://clients1.ibisworld.com/reports/us/industry
/productsandmarkets.aspx?entid=1133#PS
xv. Rail Safety Improvement Act of 2008 (RSIA). (n.d.).
Retrieved April 19, 2016, from
https://www.fra.dot.gov/Page/P0395https://ww
w.fra.dot.gov/Page/P0395
xvi. Association of American Railroads. (n.d.). Positive
Train Control. Retrieved April 18, 2016, from
https://www.aar.org/policy/positive-train-control
xvii.
Association of American Railroads. (n.d.). What
We Haul. Retrieved April 18, 2016, from
https://www.aar.org/todays-railroads/what-wehaul
xviii. Association of American Railroads. (2016, April
6). AAR Reports Week Rail Traffic for March and
Week Ending April 2, 2016. Retrieved April 19,
2016, from
https://www.aar.org/newsandevents/PressReleases/Pages/2016-04-06-railtraffic.aspx
xix. IBISWorld. (2016). IBISWorld. Retrieved from
Competitive Landscape
http://clients1.ibisworld.com.proxy.lib.uiowa.edu/
reports/us/industry/competitivelandscape.aspx?e
ntid=1133#BOC
xx. Aberdeen Carolina & Western. (n.d.). Freight Rail
Map of Class I Carriers in North America. Retrieved
April 19, 2016,
from http://www.acwr.com/economicdevelopment/rail-maps/class-i-freight-carriers
xxi. Railroad Performance Measures. (n.d.). Retrieved
April 19, 2016, from http://www.railroadpm.org/
xxii.
The Motley Fool. (n.d.). How Does Union Pacific
Stack Up Against the Rest of the Railroad Industry?
Retrieved April 18, 2016, from
http://www.fool.com/investing/general/2015/04
/07/how-does-union-pacific-stack-up-against-therest-o.aspx
14 | P a g e
xxiii. Federal Railroad Administration. (n.d.) Freight
Rail Today. Retrieved April 19, 2016, from
http://www.fra.dot.gov/Page/P0362
xxiv. IBISWorld. (2016). IBISWorld. Retreived from
Rail Transportation.
http://clients1.ibisworld.com/reports/us/industry
/majorcompanies.aspx?entid=1133#MP347838
xxv.
Consumer Confidence Index. (2016, March 29).
Consumer Confidence Board Consumer Confidence
Index Improved in March. Retrieved April 19, 2016,
from https://www.conferenceboard.org/data/consumerconfidence.cfm
xxvi. Union Pacific Corporation. (2015). Form 10-K
2015. Retrieved from
http://www.up.com/cs/groups/public/@uprr/@i
nvestor/documents/investordocuments/pdf_upc_1
0k_02062015.pdf
xxvii. U.S. Energy Information Administration. (2016,
April 12). Short-term Energy and Summer Fuels
Outlook - Coal. Retrieved April 19, 2016,
from https://www.eia.gov/forecasts/steo/report/
coal.cfm
xxviii. Union Pacific Corporation. (2016). Form 10-K
2016. Retrieved from
http://www.up.com/cs/groups/public/@uprr/@i
nvestor/documents/investordocuments/pdf_up_1
0k_02062016.pdf
xxix. Prince, S. (2016, January 18). Union Pacific's
Automotive Freight Revenues in 2016 Could Shine.
Retrieved April 19, 2016, from
http://marketrealist.com/2016/01/union-pacificsautomotive-freight-revenues-2016-will-likelyshine/
15 | P a g e
Important Disclaimer
This report was created by students enrolled in the
Security Analysis (FIN:4250) class at the University
of Iowa. The report was originally created to offer
an internal investment recommendation for the
University of Iowa Krause Fund and its advisory
board. The report also provides potential
employers and other interested parties an example
of the students’ skills, knowledge and abilities.
Members of the Krause Fund are not registered
investment advisors, brokers or officially licensed
financial professionals. The investment advice
contained in this report does not represent an offer
or solicitation to buy or sell any of the securities
mentioned. Unless otherwise noted, facts and
figures included in this report are from publicly
available sources. This report is not a complete
compilation of data, and its accuracy is not
guaranteed. From time to time, the University of
Iowa, its faculty, staff, students, or the Krause Fund
may hold a financial interest in the companies
mentioned in this report.
16 | P a g e
Union Pacific Corporation
Revenue Decomposition
Fiscal Years Ending Dec. 31
Freight Revenue
% of Total Revenue
% Change in Freight Revenue
Agricultural (in Millions)
% of Freight Revenue
$
$
% Change in Agriculture Revenue
$
$
$
2,336
11.7%
% Change in Automotive Revenue
3,822
18.5%
$
Construction Products
Paper
Minerals & Consumer
Metals
Lumber
Other
3,093
5.0%
$
3,915 $
3,986
18.1%
18.1%
941
10.4%
957
10.5%
976
10.6%
996
10.8%
1,016
10.9%
1,036
11.0%
1,057
11.1%
3,805
1.7%
-2.0%
$
3,809
0.1%
2.0%
$
3,802
-0.2%
1.8%
1.8%
2.0%
$
3,794
-0.2%
1.8%
2.0%
$
3,787
-0.2%
91.4%
1.6%
1.8%
2.0%
$
3,779
-0.2%
2.0%
$
3,772
-0.2%
2,154 $
10.6%
2,498
-4.0%
2,251 $
10.9%
4.5%
900
9.9%
2,502
0.2%
2,449 $
11.6%
2,554 $
12.0%
2,664 $
12.3%
2,778
12.6%
936
10.2%
973
10.5%
1012
10.8%
1052
11.1%
1095
11.5%
4.3%
$
2,509
0.3%
4.3%
4.0%
4.0%
4.3%
$
2,348 $
11.3%
$
2,516
0.3%
4.3%
4.0%
$
2,524
0.3%
4.3%
4.0%
$
2,531
0.3%
4.3%
4.0%
$
2,538
0.3%
3,543 $
17.4%
3,621 $
3,701 $
3,782 $
3,865 $
3,950 $
4,037
17.6%
17.8%
18.0%
18.1%
18.2%
18.3%
1,098
12.1%
1,118
12.3%
1,138
12.4%
1,158
12.5%
1,179
12.6%
1,200
12.7%
1,222
12.8%
3,227
-1.7%
2.2%
2.2%
1.8%
$
3,239
0.4%
2.2%
1.8%
$
3,252
0.4%
2.2%
1.8%
1.8%
$
3,265
0.4%
2.2%
$
3,278
0.4%
2.2%
1.8%
$
3,291
0.4%
1.8%
$
3,304
0.4%
11%
23%
17%
26%
23%
2,716 $
13.1%
2,488 $
11.8%
2,087 $
-21.6%
2,965 $
14.4%
2,279 $
3.7%
3,237 $
15.9%
10.7%
-8.4%
9.6%
-8.4%
-8.4%
1,768
18.4%
1,459
16.1%
1,350
14.8%
1,269
13.8%
1,192
12.9%
1,121
12.0%
1,054
11.2%
990
10.4%
4,127
18.3%
$
2,334
-0.1%
-17.5%
$
4,400
19.5%
2,218
-5.0%
-8.4%
-7.5%
$
2,197
-0.9%
-8.4%
-6.0%
$
2,141
-2.6%
-8.4%
-6.0%
$
2,086
-2.6%
-6.0%
$
2,033
-2.6%
8.7%
-6.0%
$
1,981
-2.6%
1,912
-6.0%
$
1,931
-2.6%
74%
11%
15%
$
15.1%
3,808 $
18.7%
-13.5%
3,949 $
19.2%
4,095 $
19.7%
4,247 $
20.2%
4,404 $
20.6%
4,567 $
21.1%
4,736
21.5%
1,368
14.2%
1,213
13.4%
1,228
13.5%
1,242
13.5%
1,257
13.6%
1,272
13.6%
1,288
13.6%
1,303
13.6%
3,217
4.0%
-11.3%
$
31%
8%
23%
17%
9%
12%
-2.4%
1.2%
$
3,217
2.5%
3.7%
1.2%
$
3,296
2.5%
3.7%
1.2%
1.2%
$
3,378
2.5%
3.7%
$
3,461
2.5%
3.7%
1.2%
$
3,547
2.5%
3.7%
1.2%
$
3,634
2.5%
35%
9%
21%
15%
10%
10%
4,074 $
4,155 $
4,239 $
4,323 $
4,410 $
4,498 $
4,588
19.9%
20.0%
20.2%
20.4%
20.5%
20.6%
20.7%
20.8%
Carloads (in Thousands)
% of Total Carloads
3,325
36.9%
3,591
37.3%
3,488
38.5%
3,551
39.0%
3,615
39.4%
3,680
39.8%
3,746
40.1%
3,813
40.4%
3,882
40.7%
1.9%
% Change in Total Carloads
% Change in Revenue
International
Domestic
Premium
1,212
1.5%
$
11.4%
0.4%
$
4,489
3,139
3.7%
19.5%
Average Revenue per Carload (in Dollars)
$
3,846 $
18.0%
1.8%
91.8%
1.5%
% of Freight Revenue
% Change in Automotive Revenue
4,030
3,778 $
17.9%
-1.6%
$
10.7%
$
30%
9%
20%
19%
10%
12%
$
3.3%
3,711 $
17.8%
-3.3%
73%
14%
13%
4.3%
$
$
3.8%
$
1,236
13.7%
% Change in Total Carloads
3,282
3,645 $
17.7%
1.8%
92.1%
1.4%
43%
57%
9%
22%
13%
24%
32%
9.4%
Carloads (in Thousands)
% of Total Carloads
3,664
16.2%
3,581 $
17.6%
6.7%
$
1.2%
$
73%
14%
13%
$
-2.1%
92.5%
1.2%
863
9.5%
1,116
11.6%
-9.0%
$
SPRB
CO/UT
Other
Intermodal (in Millions)
3,978
19.2%
2,602
92.8%
1.1%
2.4%
4.7%
1,703
18.9%
% Change in Total Carloads
% Change in Revenue
$
1.7%
Carloads (in Thousands)
% of Total Carloads
Average Revenue per Carload (in Dollars)
2.2%
$
43%
57%
9%
22%
12%
23%
34%
% Change in Automotive Revenue
Industrial Products (in Millions)
% of Freight Revenue
3,176
2,103
9.3%
93.2%
0.9%
25%
41%
34%
3.6%
$
5.9%
$
Soda Ash
Plastics
Fertilizer
Liquid & Dry Chemicals
Petroleum & Others
% Change in Revenue
3,501
16.9%
3.6%
93.5%
-9.6%
-3.3%
$
809
8.4%
1,103
12.2%
% Change in Total Carloads
Average Revenue per Carload (in Dollars)
8.6%
3,881
2015
2016E
2017E
2018E
2019E
2020E
CV2021
20,397 $ 20,587 $ 20,809 $ 21,066 $ 21,357 $ 21,681 $ 22,037
-5.2%
1.3%
8.1%
Carloads (in Thousands)
% of Total Carloads
Coal (in Millions)
% of Freight Revenue
$
43%
57%
% Change in Automotive Revenue
% Change in Revenue
2,659
$
24%
43%
33%
5.8%
$
Auto Parts
Finished Vehicles
Average Revenue per Carload (in Dollars)
2,077
10.0%
3,777
16.7%
$
11.3%
$
781
8.7%
% Change in Total Carloads
Chemicals (in Millions)
% of Freight Revenue
2.8%
94.0%
9.1%
973
10.1%
14.9%
Carloads (in Thousands)
% of Total Carloads
% Change in Revenue
3,746
2014
22,560
15.3%
26%
39%
35%
% Change in Automotive Revenue
Average Revenue per Carload (in Dollars)
$
-2.9%
$
Food/Refrigerated
Whole Grains
Grain Products
Automotive (in Millions)
% of Freight Revenue
3,276
15.8%
$
874
9.7%
% Change in Total Carloads
% Change in Avg. Revenue per Carload
94.2%
5.1%
-0.1%
Carloads (in Thousands)
% of Total Carloads
Average Revenue per Carload (in Dollars)
2013
20,684
-9.2%
8.0%
$
53%
47%
0%
1,250
3.1%
2.0%
-2.9%
$
51%
49%
0%
1,168
-6.6%
2.0%
1.8%
$
1,170
0.2%
2.0%
1.8%
$
1,173
0.2%
2.0%
1.8%
$
1,175
0.2%
2.0%
1.8%
$
1,177
0.2%
2.0%
1.8%
$
1,180
1.8%
$
1,182
1,940 $
2,066
0.2%
0.2%
49%
51%
0%
Other Revenues (i.e. Revenues from
subsidiaries, commuter rail operations, and
accessorial revenues)
$
5.8%
3%
6.0%
12%
6.5%
-1%
6.8%
7%
7.2%
7%
7.5%
7%
7.9%
7%
8.2%
6%
8.6%
6%
Total Revenue
$ 21,963
$ 23,988
$ 21,813
$ 22,095
$ 22,415
$ 22,777
$ 23,179
$ 23,621
$ 24,103
5.0%
9.2%
-9.1%
1.3%
1.4%
1.6%
1.8%
1.9%
2.0%
9,022
9,625
9,062
9,102
9,175
9,257
9,346
9,443
9,549
-0.3%
6.7%
-5.8%
0.4%
0.8%
0.9%
1.0%
1.0%
1.1%
% of Total Revenue
% Change in Other Revenue
% Change in Total Revenue
Total Carloads (in Thousands)
% Change in Total Carloads
1,279
$
1,428
$
1,416 $
1,508 $
1,606 $
1,710 $
1,822 $
Union Pacific Corporation
Income Statement
(In Millions)
Fiscal Year Ending December 31st
Sales
Cost of Goods Sold (COGS) incl. D&A
COGS excluding D&A
Depreciation & Amortization Expense
Gross Income
SG&A Expense
EBIT (Operating Income)
Nonoperating Income - Net
Interest Expense
Unusual Expense - Net
Legal Claim Expense
Unrealized Investment Loss (Gain)
Other Unusual Expense
Pretax Income
Income Taxes
Consolidated Net Income
Net Income
Net Income available to Common
EPS (recurring)
Total Shares Outstanding
Dividends per Share
2013
21,963
13,668
11,891
1,777
8,295
849
7,446
146
517
27
17
0
10
7,048
2,660
4,388
4,388
4,388
2014
23,988
14,311
12,407
1,904
9,677
924
8,753
151
561
0
0
0
0
8,343
3,163
5,180
5,180
5,180
2015
21,813
12,837
10,825
2,012
8,976
924
8,052
226
622
0
0
0
0
7,656
2,884
4,772
4,772
4,772
2016E
22,095
12,653
10,606
2,047
9,442
956
8,486
146
653
0
0
0
0
7,979
3,040
4,939
4,939
4,939
2017E
22,415
12,923
10,759
2,164
9,492
990
8,502
154
686
0
0
0
0
7,971
3,037
4,934
4,934
4,934
2018E
22,777
13,213
10,933
2,281
9,563
1,024
8,539
180
720
0
0
0
0
7,999
3,048
4,951
4,951
4,951
2019E
23,179
13,515
11,126
2,389
9,664
1,060
8,604
161
756
0
0
0
0
8,008
3,051
4,957
4,957
4,957
2020E
23,621
13,836
11,338
2,498
9,785
1,097
8,688
164
794
0
0
0
0
8,057
3,070
4,988
4,988
4,988
CV2021
24,103
14,176
11,569
2,607
9,927
1,136
8,791
165
834
0
0
0
0
8,122
3,094
5,028
5,028
5,028
4.73
912
1.48
5.75
883.37
1.91
5.49
849.21
2.20
5.63
823.81
2.25
5.77
794.91
2.36
5.91
772.56
2.48
6.06
745.15
2.61
6.21
716.41
2.73
6.37
692.83
2.87
Union Pacific Corporation
Balance Sheet
(In Millions)
Fiscal Year Ending December 31st
Assets
Cash & Short-Term Investments
Short-Term Receivables
Inventories
Other Current Assets
Total Current Assets
2013
2014
2015
2016E
2017E
2018E
2019E
2020E
CV2021
1,432.00
1,414.00
653.00
491.00
3,990.00
1,586.00
1,611.00
712.00
770.00
4,679.00
1,391.00
1,356.00
736.00
647.00
4,130.00
1,469.41
1,436.16
684.94
607.61
4,198.12
1,716.15
1,456.98
694.87
616.41
4,484.42
1,531.49
1,480.49
706.08
626.36
4,344.42
1,559.34
1,506.64
718.55
637.42
4,421.96
1,568.41
1,535.38
732.26
649.58
4,485.63
1,486.99
1,566.69
747.19
662.83
4,463.70
Net Property, Plant & Equipment
Property, Plant & Equipment - Gross
Accumulated Depreciation
Total Investments and Advances
Other Assets
Total Assets
43,749.00
59,812.00
16,063.00
1,321.00
671.00
49,731.00
46,272.00
63,214.00
16,942.00
1,390.00
375.00
52,716.00
48,866.00
66,564.00
17,698.00
1,410.00
194.00
54,600.00
50,843.92
70,589.00
19,745.08
1,525.32
106.68
56,674.04
52,705.11
74,614.00
21,908.89
1,581.15
108.39
58,879.07
54,449.58
78,639.00
24,189.42
1,633.49
110.12
60,537.61
55,810.30
82,389.00
26,578.70
1,674.31
111.88
62,018.45
57,062.27
86,139.00
29,076.73
1,711.87
113.67
63,373.44
58,205.49
89,889.00
31,683.51
1,746.16
115.49
64,530.84
Liabilities & Shareholders' Equity
ST Debt & Curr. Portion LT Debt
Accounts Payable
Income Tax Payable
Other Current Liabilities
Total Current Liabilities
705.00
803.00
491.00
1,792.00
3,791.00
462.00
877.00
412.00
2,014.00
3,765.00
Long-Term Debt
Provision for Risks & Charges
Deferred Tax Liabilities
Other Liabilities
Total Liabilities
8,872.00
0.00
14,163.00
1,680.00
28,506.00
11,018.00
0.00
14,680.00
2,064.00
31,527.00
594.00
743.00
434.00
1,435.00
3,206.00
0.25
13,607.00
0.00
15,241.00
1,844.00
33,898.00
1.09%
594.00
828.56
457.17
1,867.90
3,747.63
0.25
13,302.25
0.00
15,924.99
1,822.82
34,797.69
1.86%
1,052.00
840.57
480.03
1,904.06
4,276.65
0.25
13,801.16
0.00
16,608.28
1,849.24
36,535.33
0.96%
566.00
854.13
504.03
1,943.43
3,867.58
0.25
14,290.73
0.00
17,294.00
1,879.08
37,331.40
1.05%
637.00
869.22
529.23
1,985.97
4,021.42
0.25
14,751.53
0.00
17,980.51
1,912.27
38,665.74
1.67%
1,034.00
885.80
555.69
2,031.68
4,507.17
0.25
15,114.78
0.00
18,671.24
1,948.75
40,241.94
1.32%
839.69
903.86
583.48
2,080.52
4,407.55
0.25
15,451.26
0.00
19,367.50
1,988.49
41,214.79
Common Equity
Common Stock/Additional Paid-In Capital
Retained Earnings
Cumulative Translation Adjustment/Unrealized For. Exch. Gain
Other Appropriated Reserves
Treasury Stock
Total Shareholders' Equity
Total Liabilities & Shareholders' Equity
21,225.00 21,189.00 20,702.00 21,876.35 22,343.74 23,206.21 23,352.71 23,131.50 23,316.05
5,597.00
7,096.00
7,193.00
7,261.80
7,330.60
7,399.41
7,468.21
7,537.01
7,564.53
25,288.00 27,367.00 30,233.00 33,317.60 36,371.65 39,404.76 42,420.20 45,449.82 48,492.38
-37.00
-49.00
-92.00
0.00
0.00
0.00
0.00
0.00
0.00
-713.00 -1,161.00 -1,103.00 -1,000.00 -1,000.00 -1,000.00 -1,000.00 -1,000.00 -1,000.00
-8,910.00 -12,064.00 -15,529.00 -17,703.06 -20,358.52 -22,597.96 -25,535.69 -28,855.33 -31,740.86
21,225.00 21,189.00 20,702.00 21,876.35 22,343.74 23,206.21 23,352.71 23,131.50 23,316.05
49,731.00 52,716.00 54,600.00 56,674.04 58,879.07 60,537.61 62,018.45 63,373.44 64,530.84
Union Pacific Corporation
Cash Flow Statement
(In Millions)
Fiscal Year Ending December 31st
Operating Activities
Net Income / Starting Line
Depreciation, Depletion & Amortization
Deferred Taxes & Investment Tax Credit
Other Funds
Funds from Operations
Changes in Working Capital
Receivables
Inventories
Accounts Payable
Income Taxes Payable
Other Assets/Liabilities
Net Operating Cash Flow
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
1,606.00
1,237.00
235.00
-212.00
2,866.00
14.00
68.00
-64.00
-102.00
0.00
112.00
2,880.00
1,855.00
1,321.00
332.00
-259.00
3,249.00
28.00
47.00
-58.00
30.00
0.00
9.00
3,277.00
2,338.00
1,387.00
547.00
48.00
4,320.00
-250.00
38.00
3.00
-342.00
0.00
51.00
4,070.00
1,898.00
1,444.00
723.00
-538.00
3,527.00
-293.00
-72.00
-25.00
-90.00
0.00
-106.00
3,234.00
3,292.00
1,617.00
986.00
-298.00
5,597.00
276.00
-217.00
-80.00
395.00
0.00
178.00
5,873.00
3,292.00
1,617.00
986.00
-298.00
5,597.00
276.00
-217.00
-80.00
395.00
0.00
178.00
5,873.00
3,943.00
1,760.00
887.00
-160.00
6,430.00
-269.00
70.00
-46.00
-185.00
0.00
-108.00
6,161.00
4,388.00
1,777.00
723.00
-226.00
6,662.00
161.00
-83.00
7.00
163.00
0.00
74.00
6,823.00
5,180.00
1,904.00
895.00
-285.00
7,694.00
-309.00
-197.00
-59.00
217.00
0.00
-270.00
7,385.00
4,772.00
2,012.00
765.00
-28.00
7,521.00
-177.00
255.00
-24.00
-276.00
-85.00
-47.00
7,344.00
Investing Activities
Capital Expenditures
Sale of Fixed Assets & Businesses
Purchase/Sale of Investments
Purchase of Investments
Other Funds
Other Uses
Other Sources
Net Investing Cash Flow
-536.00
669.00
-2,242.00
2,242.00
67.00
0.00
67.00
-2,042.00
-3,117.00
743.00
0.00
0.00
-52.00
-52.00
0.00
-2,426.00
-3,168.00
481.00
0.00
0.00
-77.00
-77.00
0.00
-2,764.00
-2,484.00
287.00
0.00
0.00
22.00
0.00
22.00
-2,175.00
-2,482.00
67.00
0.00
0.00
-73.00
-73.00
0.00
-2,488.00
-3,261.00
193.00
0.00
0.00
-51.00
-51.00
0.00
-3,119.00
-4,012.00
354.00
0.00
0.00
25.00
0.00
25.00
-3,633.00
-3,496.00
98.00
0.00
0.00
-7.00
-7.00
0.00
-3,405.00
-4,346.00
0.00
0.00
0.00
97.00
-41.00
138.00
-4,249.00
-4,650.00
0.00
0.00
0.00
174.00
-77.00
251.00
-4,476.00
-322.00
160.00
0.00
160.00
-657.00
-657.00
0.00
-657.00
35.00
0.00
35.00
-784.00
-364.00
-1,375.00
-1,375.00
0.00
789.00
789.00
1,581.00
-792.00
150.00
0.00
150.00
-800.00
-481.00
-1,609.00
-1,609.00
0.00
1,049.00
1,049.00
2,257.00
-1,208.00
106.00
-31.00
137.00
-935.00
-544.00
0.00
0.00
0.00
-28.00
-28.00
843.00
-871.00
114.00
0.00
114.00
-458.00
-602.00
-1,249.00
-1,249.00
0.00
-518.00
-518.00
894.00
-1,412.00
-12.00
-12.00
0.00
-2,381.00
-837.00
-1,418.00
-1,418.00
0.00
-476.00
-476.00
486.00
-962.00
108.00
0.00
108.00
-2,623.00
-1,146.00
-1,474.00
-1,474.00
0.00
-63.00
-63.00
695.00
-758.00
1.00
0.00
1.00
-2,682.00
-1,333.00
-2,218.00
-2,218.00
0.00
803.00
803.00
1,443.00
-640.00
-301.00
-301.00
0.00
-3,049.00
-1,632.00
-3,225.00
-3,225.00
0.00
1,878.00
1,878.00
2,588.00
-710.00
-3.00
-3.00
0.00
-2,982.00
-2,344.00
-3,465.00
-3,465.00
0.00
2,772.00
2,772.00
3,328.00
-556.00
-26.00
-26.00
0.00
-3,063.00
54.00
51.00
371.00
601.00
-764.00
131.00
-154.00
369.00
154.00
-195.00
Financing Activities
Cash Dividends Paid
Change in Capital Stock
Repurchase of Common & Preferred Stk.
Sale of Common & Preferred Stock
Issuance/Reduction of Debt, Net
Change in Long-Term Debt
Issuance of Long-Term Debt
Reduction in Long-Term Debt
Other Funds
Other Uses
Other Sources
Net Financing Cash Flow
Net Change in Cash
Union Pacific Corporation
Cash Flow Statement
(In Millions)
Fiscal Year Ending December 31st
Operating Activities
Net Income / Starting Line
Depreciation, Depletion & Amortization
Deferred Taxes & Investment Tax Credit
Changes in Working Capital
Receivables
Inventories
Accounts Payable
Income Taxes Payable
Other Assets
Other Liabilities
Net Operating Cash Flow
2016E
2017E
2018E
2019E
2020E
CV2021
4,938.91
2,047.08
683.99
551.92
-80.16
51.06
85.56
23.17
39.39
432.90
8,221.89
4,933.90
2,163.81
683.29
31.47
-20.82
-9.93
12.01
22.86
-8.81
36.15
7,812.47
4,951.44
2,280.53
685.72
32.26
-23.51
-11.21
13.56
24.00
-9.95
39.37
7,949.96
4,957.13
2,389.28
686.51
33.15
-26.15
-12.47
15.09
25.20
-11.06
42.55
8,066.07
4,987.58
2,498.03
690.73
34.14
-28.74
-13.71
16.58
26.46
-12.16
45.70
8,210.48
5,027.53
2,606.78
696.26
35.21
-31.30
-14.93
18.06
27.78
-13.24
48.85
8,365.78
Investing Activities
Capital Expenditures
Long-Term Investments
Other Assets
Net Investing Cash Flow
-4,025.00 -4,025.00 -4,025.00 -3,750.00 -3,750.00 -3,750.00
-115.32
-55.84
-52.33
-40.82
-37.56
-34.30
87.32
-1.71
-1.73
-1.76
-1.79
-1.82
-4,053.00 -4,082.54 -4,079.07 -3,792.58 -3,789.35 -3,786.12
Financing Activities
Cash Dividends Paid
Change in Capital Stock
Repurchase of Common & Preferred Stk.
Common Stock/Additional Paid-In Capital
Other Liabilities
Other Income
Change in Long-Term Debt
Current Portion of Short and Long Term Debt
Net Financing Cash Flow
-1,854.31
-2,105.26
-2,174.06
68.80
-21.18
195.00
-304.75
0.00
-4,090.49
-1,879.85
-2,586.66
-2,655.46
68.80
26.42
0.00
498.91
458.00
-3,483.18
-1,918.33
-2,170.64
-2,239.44
68.80
29.84
0.00
489.57
-486.00
-4,055.55
-1,941.70
-2,868.93
-2,937.73
68.80
33.19
0.00
460.80
71.00
-4,245.64
-1,957.96
-3,250.84
-3,319.64
68.80
36.48
0.00
363.25
397.00
-4,412.07
-1,984.97
-2,858.01
-2,885.53
27.52
39.73
0.00
336.48
-194.31
-4,661.08
78.41
246.75
-184.66
27.85
9.06
-81.41
1,391.00
1,469.41
1,469.41
1,716.15
1,716.15
1,531.49
1,531.49
1,559.34
1,559.34
1,568.41
1,568.41
1,486.99
Net Change in Cash
Beginning Cash
Ending Cash
Union Pacific Corporation
Common Size Income Statement
(% of Sales)
Fiscal Year Ending December 31st
Sales
Cost of Goods Sold (COGS)
Depreciation & Amortization
Gross Income
SG&A Expense
Other Operating Expense
EBIT (Operating Income)
Nonoperating Income - Net
Interest Expense
Unusual Expense - Net
Pretax Income
Income Taxes
Consolidated Net Income
Net Income
2013
100%
54.14%
8.09%
37.77%
3.87%
0.00%
33.90%
0.66%
2.35%
0.12%
32.09%
12.11%
19.98%
19.98%
2014
100%
51.72%
7.94%
40.34%
3.85%
0.00%
36.49%
0.63%
2.34%
0.00%
34.78%
13.19%
21.59%
21.59%
2015
100%
49.63%
9.22%
41.15%
4.24%
0.00%
36.91%
1.04%
2.85%
0.00%
35.10%
13.22%
21.88%
21.88%
2016E
100%
48.00%
9.26%
42.74%
4.33%
0.00%
38.41%
0.66%
2.96%
0.00%
36.11%
13.76%
22.35%
22.35%
2017E
100%
48.00%
9.65%
42.35%
4.42%
0.00%
37.93%
0.69%
3.06%
0.00%
35.56%
13.55%
22.01%
22.01%
2018E
100%
48.00%
10.01%
41.99%
4.50%
0.00%
37.49%
0.79%
3.16%
0.00%
35.12%
13.38%
21.74%
21.74%
2019E
100%
48.00%
10.31%
41.69%
4.57%
0.00%
37.12%
0.69%
3.26%
0.00%
34.55%
13.16%
21.39%
21.39%
CV2021
2020E
100%
100%
48.00%
48.00%
10.58%
10.82%
41.42% 41.18%
4.65%
4.71%
0.00%
0.00%
36.78% 36.47%
0.69%
0.68%
3.36%
3.46%
0.00%
0.00%
34.11% 33.70%
13.00%
12.84%
21.11%
20.86%
21.11% 20.86%
Union Pacific Corporation
Common Size Balance Sheet
(% of Sales)
Fiscal Year Ending December 31st
Assets
Cash & Short-Term Investments
Short-Term Receivables
Inventories
Other Current Assets
Total Current Assets
2013
6.52%
6.44%
2.97%
2.24%
18.17%
6.61%
6.72%
2.97%
3.21%
19.51%
Net Property, Plant & Equipment
Total Investments and Advances
Other Assets
Total Assets
199.19%
6.01%
3.06%
226.43%
192.90%
5.79%
1.56%
219.76%
Liabilities & Shareholders' Equity
ST Debt & Curr. Portion LT Debt
Accounts Payable
Income Tax Payable
Other Current Liabilities
Total Current Liabilities
3.21%
3.66%
2.24%
8.16%
17.26%
1.93%
3.66%
1.72%
8.40%
15.70%
Long-Term Debt
Provision for Risks & Charges
Deferred Tax Liabilities
Other Liabilities
Total Liabilities
40.40%
0.00%
64.49%
7.65%
129.79%
45.93%
0.00%
61.20%
8.60%
131.43%
62.38%
60.21%
61.57%
62.74%
63.64%
63.99%
64.11%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
69.87%
72.08%
74.09%
75.93%
77.57%
79.04%
80.35%
8.45%
8.25%
8.25%
8.25%
8.25%
8.25%
8.25%
155.40% 157.49% 162.99% 163.90% 166.81% 170.36% 171.00%
Common Equity
Total Shareholders' Equity
Total Liabilities & Shareholders' Equity
96.64%
96.64%
226.43%
88.33%
88.33%
219.76%
97.93%
96.74%
94.91%
99.01%
99.68% 101.89% 100.75%
94.91% 99.01% 99.68% 101.89% 100.75% 97.93% 96.74%
250.31% 256.50% 262.68% 265.79% 267.56% 268.29% 267.73%
2014
2015
6.38%
6.22%
3.37%
2.97%
18.93%
2016E
6.65%
6.50%
3.10%
2.75%
19.00%
2017E
7.66%
6.50%
3.10%
2.75%
20.01%
2018E
6.72%
6.50%
3.10%
2.75%
19.07%
2019E
6.73%
6.50%
3.10%
2.75%
19.08%
2020E
6.64%
6.50%
3.10%
2.75%
18.99%
CV2021
6.17%
6.50%
3.10%
2.75%
18.52%
224.02% 230.12% 235.13% 239.06% 240.78% 241.57% 241.49%
6.46%
6.90%
7.05%
7.17%
7.22%
7.25%
7.24%
0.89%
0.48%
0.48%
0.48%
0.48%
0.48%
0.48%
250.31% 256.50% 262.68% 265.79% 267.56% 268.29% 267.73%
2.72%
3.41%
1.99%
6.58%
14.70%
2.69%
3.75%
2.07%
8.45%
16.96%
4.69%
3.75%
2.14%
8.49%
19.08%
2.48%
3.75%
2.21%
8.53%
16.98%
2.75%
3.75%
2.28%
8.57%
17.35%
4.38%
3.75%
2.35%
8.60%
19.08%
3.48%
3.75%
2.42%
8.63%
18.29%
Union Pacific Corporation (UNP)
Weighted Average Cost of Capital (WACC) Estimation
Beta:
Risk Free Rate:
Market Risk Premium:
Cost of Equity =
1.111
2.57%
4.80%
7.90%
Cost of Debt:
Marginal Tax Rate:
After-Tax Cost of Debt
3.90%
38.10%
2.41%
Cost of Equity:
Weight of Equity:
Cost of Debt:
Weight of Debt:
7.90%
80.39%
2.41%
19.61%
WACC =
6.82%
Stock Price:
Shares Outstanding:
MV of Equity:
$82.24
849,210,000
$ 69,839,030,400
Weight of Equity
80.39%
ST Debt & Current Portion of LTD:
Long-Term Debt:
PV of Operating Leases
MV of Debt:
$594,000,000
$13,607,000,000
$2,840,553,260
$ 17,041,553,260
Weight of Debt
19.61%
MV of Equity:
MV of Debt:
MV of Firm
$ 69,839,030,400
$ 17,041,553,260
$ 86,880,583,660
100.00%
Union Pacific Corporation
Value Driver Estimation
(in Millions)
Fiscal Years Ending Dec. 31
NOPLAT COMPUTATION
Net Sales
Less: Cost of Sales
Less: Depreciation Less: SG & A Expense
Plus: Implied Interest on the PV of Operating Leases
EBITA
2013
2014
2015
2016E
2017E
2018E
2019E
2020E
CV2021
21,963.00
11,891.00
1,777.00
849.00
129.86
7,575.86
23,988.00
12,407.00
1,904.00
924.00
120.50
8,873.50
21,813.00
10,825.00
2,012.00
924.00
110.78
8,162.78
22,094.84
10,605.52
2,047.08
956.34
115.27
8,601.16
22,415.08
10,759.24
2,163.81
989.81
119.49
8,621.71
22,776.78
10,932.86
2,280.53
1024.46
123.44
8,662.38
23,179.07
11,125.95
2,389.28
1060.31
126.52
8,730.05
23,621.26
11,338.21
2,498.03
1097.42
129.36
8,816.97
24,102.86
11,569.37
2,606.78
1135.83
131.95
8,922.83
2,660.00
196.98
55.63
10.23
10.29
2,821.87
3,163.00
213.74
57.53
0.00
0.00
3,319.21
2,884.00
236.98
86.11
0.00
0.00
3,034.88
3,039.94
248.83
55.65
0.00
0.00
3,233.13
3,036.86
261.27
58.78
0.00
0.00
3,239.35
3,047.66
274.34
68.65
0.00
0.00
3,253.34
3,051.16
288.05
61.27
0.00
0.00
3,277.94
3,069.90
302.46
62.38
0.00
0.00
3,309.98
3,094.49
317.58
62.74
0.00
0.00
3,349.32
14,163.00
268.00
0.00
13,895.00
14,680.00
277.00
0.00
14,403.00
15,241.00
0.00
0.00
15,241.00
15,924.99
0.00
0.00
15,924.99
16,608.28
0.00
0.00
16,608.28
17,294.00
0.00
0.00
17,294.00
17,980.51
0.00
0.00
17,980.51
18,671.24
0.00
0.00
18,671.24
19,367.50
0.00
0.00
19,367.50
Net Change in Deferred Tax Liabilities
1,050.00
508.00
838.00
683.99
683.29
685.72
686.51
690.73
696.26
NOPLAT
5,803.98
6,062.29
5,965.91
6,052.02
6,065.66
6,094.77
6,138.62
6,197.72
6,269.77
INVESTED CAPITAL
Operating Current Assets
"Normal" Cash
Accounts Receivable, Net
Inventories
Other Operating Current Assets
Operating Current Assets
71.60
1,414.00
653.00
223.00
2,361.60
79.30
1,611.00
712.00
493.00
2,895.30
69.55
1,356.00
736.00
647.00
2,808.55
73.47
1,436.16
684.94
607.61
2,802.18
85.81
1,456.98
694.87
616.41
2,854.07
76.57
1,480.49
706.08
626.36
2,889.51
77.97
1,506.64
718.55
637.42
2,940.58
78.42
1,535.38
732.26
649.58
2,995.65
74.35
1,566.69
747.19
662.83
3,051.05
Operating Current Liabilities
Accounts Payable
Taxes Payable
Other Current Liabilities
Operating Current Liabilites
803.00
491.00
1,792.00
3,086.00
877.00
412.00
2,014.00
3,303.00
743.00
434.00
1,435.00
2,612.00
828.56
457.17
1,867.90
3,153.63
840.57
480.03
1,904.06
3,224.65
854.13
504.03
1,943.43
3,301.58
869.22
529.23
1,985.97
3,384.42
885.80
555.69
2,031.68
3,473.17
903.86
583.48
2,080.52
3,567.86
Income Tax Provision
Plus: Tax Shield on Interest Expense
Less: Tax Non-Operating Income
Plus: Tax on Unusual Expenses
Plus: Tax Shield on Non-Operating Losses
Total Adjusted Taxes
Deferred Tax Liabilities
Deferred Tax Current Assets
Deferred Tax Long-Term Assets
Net Deferred Tax Liability
Net Operating Working Capital
Plus: Net PPE
Plus: PV of Operating Leases
Plus: Tangible Other Assets
-724.4
-407.7
196.55
-351.45
-370.58
-412.08
-443.84
-477.52
-516.81
43,749.00
3,329.64
671.00
46,272.00
3,089.62
375.00
48,866.00
2,840.55
105.00
50,843.92
2,955.53
106.68
52,705.11
3,063.72
108.39
54,449.58
3,165.12
110.12
55,810.30
3,244.22
111.88
57,062.27
3,317.00
113.67
58,205.49
3,383.45
115.49
47,025.24
49,328.92
52,008.10
53,554.68
55,506.64
57,312.75
58,722.57
60,015.42
61,187.63
VALUE DRIVERS
NOPLAT
BEG. INVESTED CAPITAL
ROIC
5,803.98
45,132.83
12.86%
6,062.29
47,025.24
12.89%
5,965.91
49,328.92
12.09%
6,052.02
52,008.10
11.64%
6,065.66
53,554.68
11.33%
6,094.77
55,506.64
10.98%
6,138.62
57,312.75
10.71%
6,197.72
58,722.57
10.55%
6,269.77
60,015.42
10.45%
BEG. INVESTED CAPITAL
ROIC
WACC
EP
45,132.83
12.86%
6.82%
2723.85
47,025.24
12.89%
6.82%
2853.01
49,328.92
12.09%
6.82%
2599.41
52,008.10
11.64%
6.82%
2502.68
53,554.68
11.33%
6.82%
2410.77
55,506.64
10.98%
6.82%
2306.67
57,312.75
10.71%
6.82%
2227.26
58,722.57
10.55%
6.82%
2190.14
60,015.42
10.45%
6.82%
2173.96
NOPLAT
BEG. INVESTED CAPITAL
ENDING INVESTED CAPITAL
FCF
5,803.98
45,132.83
47,025.24
3,911.58
6,062.29
47,025.24
49,328.92
3,758.61
5,965.91
49,328.92
52,008.10
3,286.72
6,052.02
52,008.10
53,554.68
4,505.44
6,065.66
53,554.68
55,506.64
4,113.70
6,094.77
55,506.64
57,312.75
4,288.66
6,138.62
57,312.75
58,722.57
4,728.80
6,197.72
58,722.57
60,015.42
4,904.87
6,269.77
60,015.42
61,187.63
5,097.56
Invested Capital
Union Pacific Corporation (UNP)
Discounted Cash Flow (DCF) and Economic Profit (EP) Valuation Models
Key Inputs:
CV Growth
CV ROIC
WACC
Cost of Equity
1.95%
10.45%
6.82%
7.90%
Fiscal Years Ending Dec. 31
5% of Sales
1090.65
2015
2016E
2017E
2018E
2019E
2020E
6.82%
3,286.72
4,505.44
4,113.70
4,288.66
4,728.80
4,904.87
1
4,217.61
2
3,604.87
3
3,518.10
4
3,631.33
104,642.35
6,269.77
5
5
3,525.91
75,223.12
2,502.68
1
2,410.77
2
2,306.67
3
2,227.26
4
2,190.14
5
44,626.93
5
2,342.80
2,112.58
1,892.22
1,710.35
1,574.40
32,080.48
CV2021
DCF Model
WACC
FCF to Discount
NOPLAT
Period to Discount
PV of FCF
Value of Operating Assets
Plus: Excess Cash
Value of the Firm
Less: Short Term Debt
Less: Long-Term Debt
Less: PV of Operating Leases
Less: PV of ESOP
Less: Underfunded Pension
Value of Equity
Number of Shares Outstanding:
Intrinsic Value
93,720.94
300.35
94,021.29
594.00
13,607.00
2,840.55
72.19
414.00
76,493.54
849.21
$
90.08
Fractional Period of Year
Adjusted Stock Price
$
0.301
91.47
EP Model
WACC
EP to Discount
Period to Discount
Beginning Invested Capital
PV of Cash Flows
6.82%
2,599.41
52,008.10
Value of Operating Assets
Plus: Excess Cash
Value of Firm
Less: Short Term Debt
Less: Long-Term Debt
Less: PV of Operating Leases
Less: PV of ESOP
Less: Underfunded Pension
Value of Equity
Number of Shares Outstanding
Intrinsic Value
Fractional Period of Year
Adjusted Stock Price
93,720.94
300.35
94,021.29
594.00
13,607.00
2,840.55
72.19
414.00
76,493.54
849.21
90.08
$
0.301
91.47
Union Pacific Corporation (UNP)
Dividend Discount Model (DDM) or Fundamental P/E Valuation Model
Fiscal Years Ending Dec. 31
2016E
EPS
5.63
Key Assumptions
CV EPS growth
CV ROE
Cost of Equity
2017E
5.77
2018E
5.91
2019E
6.06
2020E
6.21
CV2021
6.37
2.25%
21.56%
7.90%
Future Cash Flows
P/E Multiple (CV Year)
EPS (CV Year)
Future Stock Price
Dividends Per Share
Periods
Discounted Cash Flows
15.85
6.37
100.91
2.25
1
2.09
Intrinsic Value
$
78.88
Fractional Period of Year
Adjusted Stock Price
$
0.301
80.10
2.36
2
2.03
2.48
3
1.98
2.61
4
1.92
2.73
5
1.87
5
69.00
Union Pacific Corporation
Relative Valuation Models
Ticker
CSX
CP
CNI
KSU
NSC
Company
CSX Corporation
Canadian Pacific Railway
Canadian National Railway
Kansas City Southern
Norfolk Southern Corporation
UNP
Union Pacific Corporation
Implied Value:
Relative P/E (EPS16)
Relative P/E (EPS17)
PEG Ratio (EPS16)
PEG Ratio (EPS17)
Price
$25.98
$146.98
$63.56
$91.55
$81.78
EPS
2016
$2.00
$6.34
$3.31
$4.40
$5.10
EPS
2017E
$1.84
$11.03
$4.66
$4.56
$5.34
Average
$82.24
$5.49
$5.63
$ 101.25
$ 86.07
$ 109.57
$ 102.11
P/E 16
13.0
23.2
19.2
20.8
16.0
18.4
P/E 17
14.1
13.3
13.6
20.1
15.3
15.3
15.0
14.6
Est. 5yr
EPS gr.
3.0
13.5
9.4
8.4
10.1
8.21
PEG 16
4.33
1.71
2.05
2.48
1.59
2.4
1.8
PEG 17
4.71
0.98
1.46
2.39
1.51
2.2
1.8
Union Pacific Corporation
Key Management Ratios
Fiscal Years Ending Dec. 31
2013
2014
2015
2016E
2017E
2018E
2019E
2020E
CV2021
1.05
0.75
199.00
1.24
0.85
914.00
1.29
0.86
924.00
1.12
0.78
450.49
1.05
0.74
207.77
1.12
0.78
476.84
1.10
0.76
400.54
1.00
0.69
-21.54
1.01
0.69
56.15
Liquidity Ratios
Current Ratio
Quick Ratio
Net Working Capital
(Current Assets/Current Liabilites)
(Cash + A/R)/Current Liabilities
(Current Assets - Current Liab.)
Activity or Asset-Management Ratios
Receivables Turnover
Total Asset Turnover
Fixed Asset Turnover
Net Income/(Average A/R)
Total Revenues/(Average Total Assets)
Total Revenues/(Average Net PP&E)
3.20
0.45
0.51
3.42
0.47
0.53
3.22
0.41
0.46
3.54
0.40
0.44
3.41
0.39
0.43
3.37
0.38
0.43
3.32
0.38
0.42
3.28
0.38
0.42
3.24
0.38
0.42
Financial Leverage Ratios
Debt-to-Equity Ratio
Equity Ratio
Debt Ratio
Capitalization Ratio
(ST Debt + LT Debt)/Total Equity
Total Equity/Total Assets
Total Liabilities/Total Assets
LT Debt/(LT Debt + SH Equity)
0.45
0.43
0.57
0.29
0.54
0.40
0.60
0.34
0.69
0.38
0.62
0.40
0.64
0.39
0.61
0.38
0.66
0.38
0.62
0.38
0.64
0.38
0.62
0.38
0.66
0.38
0.62
0.39
0.70
0.37
0.63
0.40
0.70
0.36
0.64
0.40
Profitability Ratios
Net Profit Margin
ROA
ROE
Operating Margin
Net Income/Revenue
Net Income/Average Total Assets
Net Income/SH Equity
Operating Income/Net Sales
19.98%
9.06%
20.67%
33.90%
21.59%
10.11%
24.45%
36.49%
21.88%
8.89%
23.05%
36.91%
22.35%
8.88%
22.58%
38.41%
22.01%
8.54%
22.08%
37.93%
21.74%
8.29%
21.34%
37.49%
21.39%
8.09%
21.23%
37.12%
21.11%
7.96%
21.56%
36.78%
20.86%
7.86%
21.56%
36.47%
Payout Policy Ratios
Dividend Payout Ratio
Total Payout Ratio
Dividends per Share/Earnings per Share
(Dividends + Repurchases)/Net Income
31.29%
80.93%
33.22%
93.76%
40.07%
121.73%
37.54%
80.17%
38.10%
90.53%
38.74%
82.58%
39.17%
97.04%
39.26%
104.44%
39.48%
96.33%
$
Market
Risk
Premium
$
WACC
Beta
1.111
102.76
96.84
91.47
86.56
82.07
91.47
4.30%
4.55%
4.80%
5.05%
5.30%
0.911
125.56
118.74
112.52
106.84
101.62
1.011
113.19
106.85
101.09
95.82
91.00
1.211
93.83
88.29
83.25
78.67
74.47
1.311
86.11
80.89
76.16
71.85
67.91
91.47
5.99%
6.49%
6.99%
7.49%
7.99%
1.45%
108.39
95.29
84.57
75.63
68.06
CV Growth of NOPLAT
1.70%
1.95%
2.20%
105.64
105.64
108.39
93.35
93.35
95.29
83.19
83.19
84.57
74.65
74.65
75.63
67.38
67.38
68.06
2.45%
114.92
99.83
87.74
77.84
69.58
SG&A as
% of
Sales
Risk Free
Rate
$ 91.47
3.00%
3.25%
3.50%
3.75%
4.00%
7.12%
91.35
91.30
91.26
91.22
91.17
$ 91.47
2.07%
2.32%
2.57%
2.82%
3.07%
47.00%
101.74
96.49
91.67
87.24
83.14
Cost of Equity
7.62%
8.12%
91.48
91.61
91.44
91.57
91.39
91.52
91.35
91.48
91.31
91.44
8.62%
91.74
91.70
91.65
91.61
91.57
9.12%
91.87
91.83
91.78
91.74
91.70
COGS as % of Sales
47.50%
48.00%
48.50%
101.63
101.53
101.42
96.38
96.28
96.17
91.57
91.47
91.36
87.13
87.03
86.93
83.04
82.94
82.84
49.00%
101.31
96.07
91.26
86.83
82.74
Present Value of Operating Lease Obligations (2015)
Present Value of Operating Lease Obligations (2014)
Operating
Leases
491
446
371
339
282
1501
3430
589
2841
Fiscal Years Ending 2015
2016
2017
2018
2019
2020
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Capitalization of Operating Leases
3.90%
5.3
Lease
Commitment
491
446
371
339
282
282
PV Lease
Payment
472.6
413.1
330.8
290.9
232.9
1100.3
2840.6
Present Value of Operating Lease Obligations (2012)
Capitalization of Operating Leases
3.90%
6.3
Lease
Commitment
525
466
410
375
339
339
PV Lease
Payment
505.3
431.7
365.5
321.8
280.0
1531.4
3435.7
Present Value of Operating Lease Obligations (2009)
Capitalization of Operating Leases
3.90%
15.1
Lease
Commitment
576
570
488
425
352
352
PV Lease
Payment
554.4
528.0
435.1
364.7
290.7
3269.6
5442.4
Present Value of Operating Lease Obligations (2006)
Capitalization of Operating Leases
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Lease
Commitment
624
546
498
456
419
419
3.90%
6.9
Lease
Commitment
525
489
415
372
347
347
PV Lease
Payment
505.3
453.0
370.0
319.2
286.6
1696.0
3630.1
3.90%
8.2
Lease
Commitment
657
614
580
465
389
389
PV Lease
Payment
632.3
568.8
517.1
399.0
321.3
2226.6
4665.1
Operating
Leases
615
517
450
405
359
2588
4934
985
3949
Fiscal Years Ending 2005
2006
2007
2008
2009
2010
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Capitalization of Operating Leases
3.90%
7.0
PV Lease
Payment
600.6
505.8
444.0
391.3
346.0
2072.9
4360.6
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Lease
Commitment
615
517
450
405
359
359
PV Lease
Payment
492.8
441.9
390.5
343.2
274.2
1387.1
3329.6
Operating
Leases
613
526
461
382
340
2599
4921
998
3923
Fiscal Years Ending 2010
2011
2012
2013
2014
2015
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
3.90%
7.6
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Lease
Commitment
613
526
461
382
340
340
PV Lease
Payment
590.0
487.3
411.0
327.8
280.8
1825.7
3922.6
Operating
Leases
639
600
554
522
417
3289
6021
1264
4757
Fiscal Years Ending 2007
2008
2009
2010
2011
2012
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Capitalization of Operating Leases
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Lease
Commitment
512
477
438
400
332
332
Present Value of Operating Lease Obligations (2007)
Operating
Leases
657
614
580
465
389
3204
5909
1244
4665
Fiscal Years Ending 2008
2009
2010
2011
2012
2013
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
3.90%
5.7
Capitalization of Operating Leases
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Present Value of Operating Lease Obligations (2010)
Operating
Leases
525
489
415
372
347
2380
4528
898
3630
Fiscal Years Ending 2011
2012
2013
2014
2015
2016
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Present Value of Operating Lease Obligations (2005)
Operating
Leases
624
546
498
456
419
2914
5457
1096
4361
Fiscal Years Ending 2006
2007
2008
2009
2010
2011
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
PV Lease
Payment
488.9
448.3
382.5
305.5
266.8
1197.6
3089.6
Capitalization of Operating Leases
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Lease
Commitment
508
484
429
356
323
323
Present Value of Operating Lease Obligations (2008)
Operating
Leases
576
570
488
425
352
5312
7723
2281
5442
Fiscal Years Ending 2009
2010
2011
2012
2013
2014
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
3.90%
5.0
Capitalization of Operating Leases
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Operating
Leases
512
477
438
400
332
1907
4066
736
3330
Fiscal Years Ending 2013
2014
2015
2016
2017
2018
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Capitalization of Operating Leases
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Present Value of Operating Lease Obligations (2011)
Operating
Leases
525
466
410
375
339
2126
4241
805
3436
Fiscal Years Ending 2012
2013
2014
2015
2016
2017
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Fiscal Years Ending 2014
2015
2016
2017
2018
2019
Thereafter
Total Minimum Payments
Less: Interest
PV of Minimum Payments
Capitalization of Operating Leases
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Present Value of Operating Lease Obligations (2013)
Operating
Leases
508
484
429
356
323
1625
3725
635
3090
3.90%
7.2
PV Lease
Payment
591.9
478.9
401.2
347.5
296.5
1832.5
3948.5
Pre-Tax Cost of Debt
Number Years Implied by Year 6 Payment
Year
1
2
3
4
5
6 & beyond
PV of Minimum Payments
Lease
Commitment
639
600
554
522
417
417
3.90%
7.9
PV Lease
Payment
615.0
555.8
493.9
447.9
344.4
2300.2
4757.3
FORECASTED PV OF OPERATING LEASES
2016
2955.53
2017
3063.72
2018
3165.12
2019
3244.22
2020
3317.00
2021
3383.45
Effects of ESOP Exercise and Share Repurchases on Common Stock Balance Sheet Account and Number of Shares Outstanding
Number of Options Outstanding (shares):
Average Time to Maturity (years):
Expected Annual Number of Options Exercised:
Current Average Strike Price:
Cost of Equity:
Current Stock Price:
5,571,000
5.40
1,031,667
$
66.69
7.90%
$82.24
Increase in Shares Outstanding:
Average Strike Price:
Increase in Common Stock Account:
2016E
2017E
2018E
2019E
2020E
CV2021
1,031,667
1,031,667
1,031,667
1,031,667
1,031,667
412,667
$
66.69 $
66.69 $
66.69 $
66.69 $
66.69 $
66.69
68,801,850
68,801,850
68,801,850
68,801,850
68,801,850
27,520,740
Change in Treasury Stock
Expected Price of Repurchased Shares:
Number of Shares Repurchased:
2,174,060,000 2,655,459,000 2,239,437,090 2,937,734,292 3,319,639,750 2,885,533,013
$
82.24 $
88.74 $
95.75 $
103.31 $
111.48 $
120.28
26,435,554
29,924,840
23,388,719
28,435,143
29,778,937
23,989,413
Shares Outstanding (beginning of the year)
Plus: Shares Issued Through ESOP
Less: Shares Repurchased in Treasury
Shares Outstanding (end of the year)
849,210,000
1,031,667
26,435,554
823,806,112
823,806,112
1,031,667
29,924,840
794,912,939
794,912,939
1,031,667
23,388,719
772,555,887
772,555,887
1,031,667
28,435,143
745,152,410
745,152,410
1,031,667
29,778,937
716,405,140
716,405,140
412,667
23,989,413
692,828,393
VALUATION OF OPTIONS GRANTED IN ESOP
Ticker Symbol
Current Stock Price
Risk Free Rate
Current Dividend Yield
Annualized St. Dev. of Stock Returns
Range of
Outstanding Options
Range 1
Number
of Shares
5,571,000
Total
5,571,000 $
UNP
$82.24
2.15%
2.68%
8.26%
Average
Exercise
Price
66.69
66.69
Average
Remaining
Life (yrs)
5.40 $
B-S
Option
Price
12.96 $
Value
of Options
Granted
72,193,204
5.40 $
22.37 $
72,193,204
Fly UP