GURUFOCUS.COM » STOCK LIST » USA » NYSE » Magellan Midstream Partners LP (NYSE:MMP) » Definitions » Earnings Power Value (EPV)
Switch to:

Magellan Midstream Partners LP Earnings Power Value (EPV)

: $3.88 (As of Jun22)
View and export this data going back to 2001. Start your Free Trial

As of Jun22, Magellan Midstream Partners LP's earnings power value is $3.88. *

* GuruFocus does not store EPV value into our database if Average Maintenance CAPEX is 0.

Margin of Safety is -1227.56

The basic concept of EPV is that one should value a stock based on the current free cash flow of a company and not on future projections which may, or may not, come true. It is arguably a better way to analyze stocks than Discounted Cash Flow analysis that relies on highly speculative growth assumptions many years into the future. Assumption: Current profitability is sustainable.


Magellan Midstream Partners LP Earnings Power Value (EPV) Historical Data

The historical data trend for Magellan Midstream Partners LP's Earnings Power Value (EPV) can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Magellan Midstream Partners LP Annual Data
Trend Dec12 Dec13 Dec14 Dec15 Dec16 Dec17 Dec18 Dec19 Dec20 Dec21
Earnings Power Value (EPV)
Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 2.50 5.96 -1.07 -0.91 2.68

Magellan Midstream Partners LP Quarterly Data
Sep17 Dec17 Mar18 Jun18 Sep18 Dec18 Mar19 Jun19 Sep19 Dec19 Mar20 Jun20 Sep20 Dec20 Mar21 Jun21 Sep21 Dec21 Mar22 Jun22
Earnings Power Value (EPV) Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 3.00 2.60 2.68 1.40 3.88

Competitive Comparison

For the Oil & Gas Midstream subindustry, Magellan Midstream Partners LP's Earnings Power Value (EPV), along with its competitors' market caps and Earnings Power Value (EPV) data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.

   

Magellan Midstream Partners LP Earnings Power Value (EPV) Distribution

For the Oil & Gas industry and Energy sector, Magellan Midstream Partners LP's Earnings Power Value (EPV) distribution charts can be found below:

* The bar in red indicates where Magellan Midstream Partners LP's Earnings Power Value (EPV) falls into.



Magellan Midstream Partners LP Earnings Power Value (EPV) Calculation

Earnings Power Value also known as just Earnings Power is a valuation technique popularised by Bruce Greenwald, an authority on value investing at Columbia University. It is arguably a better way to analyze stocks than Discounted Cash Flow analysis that relies on highly speculative growth assumptions many years into the future.

The basic concept of EPV is that one should value a stock based on the current free cash flow of a company and not on future projections which may, or may not, come true. This valuation tool excludes the potential growth that a company may have so that needs to be looked at separately. Since future growth is excluded from the analysis, only the maintenance capital expenditures are subtracted from after-tax EBIT (earnings before interest and taxes) and growth capex is ignored.

Magellan Midstream Partners LP's "Earning Power" Calculation:

Average of Last 20 Quarters Last Quarter
Revenue 2,645
DDA 237
Operating Margin % 35.53
SGA * 25% 48
Tax Rate % 0.24
Maintenance Capex 448
Cash and Cash Equivalents 5
Short-Term Debt 31
Long-Term Debt 5,135
Shares Outstanding (Diluted) 212

1. Start with "Earnings" not including accounting adjustments (one-time charges not excluded unless policy has changed). "Earnings" are "Operating Income.

2. Look at average margins over a business/Industry cycle: Average Operating Margin = 35.53%

To normalize margins and eliminate the effects on profitability of valuing the firm at different points in the business cycle, it is usually best to take a long-term average of operating margins. Ideally this would be as long as 10 years and include at least one economic downturn. However, since most of companies do not have as long as 10-year history, here GuruFocus uses the latest 5 years data to do the calculation. To smooth out unusual years but reflect recent developments, we take an average of the 5 year margin.

3. Multiply average margins by sustainable revenues and then adjust for maintenance SGA. This yields "normalized" EBIT:

To be conservative, GuruFocus uses an average of the 5 year revenues as the sustainable revenue.
EPV analysis recognises that part of SG&A expenditure is made to maintain and replace the existing assets, while part is made to grow sales. Since EPV is only interested in what it costs a going concern to maintain its existing asset base, it adds back a percentage of SG&A (between 15% and 50% - this is a matter of judgment and industry knowledge) to make up for the fact that some of this expenditure went to fund growth and shouldn't be accounted for. To start off, we assume 25% for the sake of prudence.
Sustainable Revenue = $2,645 Mil, Average Operating Margin = 35.53%, Average Adjusted SGA = 48,
therefore "Normalized" EBIT = Sustainable Revenue * Average Operating Margin + Average Adjusted SGA = 2,645 * 35.53% +48 = $988.31741114 Mil.

4. Multiply by one minus Average Tax Rate (NOPAT):

Same as average operating margin calculation, GuruFocus takes an average of the 5 years tax rates.
Average Tax Rate = 0.24%, and "Normalized" EBIT = $988.31741114 Mil,
therefore After-tax "Normalized" EBIT = "Normalized" EBIT * ( 1 - Average Tax Rate ) = 988.31741114 * ( 1 - 0.24% ) = $985.93556617915 Mil.

5. Add back Excess Depreciation (after tax at 1/2 average tax rate). This yields "normalized" Earnings:

Excess Depreciation = Average DDA * % of Excess Depreciation (after tax at 1/2 average tax rate) = 237 * 0.5 * 0.24% = $0.285274833 Mil.
"Normalized" Earnings = After-tax "Normalized" EBIT + Excess Depreciation = 985.93556617915 + 0.285274833 = $986.22084101215 Mil.

6. Adjusted for Maintenance Capital Expenditure:

First, calculate the revenue change regarding to the previous year. If the revenue decreased from the previous year, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
Second, if the revenue increased from the previous year, then calculate the percentage of Net PPE as of corresponding Revenue.
Third, calculate Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was negative, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was positive, then the Maintenance Capital Expenditure = Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
Fourth, GuruFocus uses an average of the 5 year maintenance capital expenditures as maintenance CAPEX.
Magellan Midstream Partners LP's Average Maintenance CAPEX = $448 Mil *.
* GuruFocus does not store EPV value into our database if Average Maintenance CAPEX is 0.

7. Investors require a return of "WACC" for the risk they are taking: WACC = 9%

8. Magellan Midstream Partners LP's current cash and cash equivalent = $5 Mil.
Magellan Midstream Partners LP's current interest bearing debt = Long-Term Debt & Capital Lease Obligation + Short-Term Debt & Capital Lease Obligation = 5,135 + 31 = $5166 Mil.
Magellan Midstream Partners LP's current Shares Outstanding (Diluted Average) = 212 Mil.

Magellan Midstream Partners LP's Earnings Power Value (EPV) for Jun22 is calculated as:

EPV = ( ( Norm. Earnings-Maint. CAPEX *) / WACC + CashandEquiv - Int. Bearing Debt ) / Shares Outstanding (Diluted Average)
= ( ( 986.22084101215 - 448)/ 9%+5-5166 )/212
=3.88

Margin of Safety (EPV)=( Earnings Power Value (EPV)-Current Price )/Earnings Power Value (EPV)
=( 3.8815431172074-51.53 )/3.8815431172074
= -1227.56%

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* GuruFocus does not store EPV value into our database if Average Maintenance CAPEX is 0.


Magellan Midstream Partners LP  (NYSE:MMP) Earnings Power Value (EPV) Explanation

Assumption: Current profitability is sustainable.

Earnings power value (EPV) uses a very basic equation which assumes no growth, although it does rely on an assumption about the cost of capital as well as the fact that current earnings are sustainable. It also involves several adjustments to clean up the underlying Earnings figures.


Be Aware

Though using today's earnings in calculating Earnings Power Value, GuruFocus is normalizing these earnings to the business cycle. This eliminates the effects on profitability of valuing the firm at different points in the business cycle. This means that we are considering the average earnings over 5 years.


Magellan Midstream Partners LP Earnings Power Value (EPV) Related Terms

Thank you for viewing the detailed overview of Magellan Midstream Partners LP's Earnings Power Value (EPV) provided by GuruFocus.com. Please click on the following links to see related term pages.


Magellan Midstream Partners LP Business Description

Magellan Midstream Partners LP logo
Traded in Other Exchanges
N/A
Address
One Williams Center, P.O. Box 22186, Tulsa, OK, USA, 74121-2186
Magellan Midstream Partners is a master limited partnership that operates pipelines and storage terminals in the Central and Eastern United States. Its assets transport, store, and distribute refined petroleum products and crude and earn a fee-based stream of cash flows. Assets include the country's longest petroleum pipeline network and several crude oil pipelines. Refined products make about 70% of operating margin, with the remainder mainly crude-oil pipelines.
Executives
Somasundaram Sivasankaran director C/O APERGY CORPORATION 2445 TECHNOLOGY FOREST BLVD, BLD 4, FL 9 THE WOODLANDS TX 77381
Roles Mark B officer: Senior Vice President ONE WILLIAMS CENTER SUITE 2800 TULSA OK 74172
Pearson Michael C officer: Senior Vice President ONE WILLIAMS CENTER SUITE 2800 TULSA OK 74172
Joung Chansoo director C/O WARBURG PINCUS LLC 450 LEXINGTON AVENUE NEW YORK NY 10017
Holman Jeffrey L officer: Senior Vice President & CFO ONE WILLIAMS CENTER TULSA OK 74172
Little Melanie A officer: Senior Vice President ONE WILLIAMS CENTER, SUITE 2800 TULSA OK 74172
Guay Edward J director ONE WILLIAMS CENTER, SUITE 2800 TULSA OK 74172
Gobillot Lori director 5103 CITY WEST BLVD. 4TH FLOOR HOUSTON TX 77042
Aaronson Michael officer: Senior Vice President 16666 NORTHCHASE DRIVE HOUSTON TX 77060
Milford Aaron L officer: Senior Vice President & CFO ONE WILLIAMS CENTER TULSA OK 74172
Methvin Stacy P. director 777 HIDDEN RIDGE IRVING TX 75038
Barnes Robert L officer: Senior Vice President ONE WILLIAMS CENTER SUITE 2800 TULSA OK 74172
Osborne Michael P officer: Senior VP & CFO ONE WILLIAMS CENTER SUITE 2800 TULSA OK 74172
May Douglas J officer: Senior Vice President ONE WILLIAMS CENTER, SUITE 4100 TULSA OK 74172
Davied Larry J officer: Senior Vice President ONE WILLIAMS CENTER SUITE 2800 TULSA OK 74172

Magellan Midstream Partners LP Headlines

Other Sources

Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)