Earnings Power Value: Complete EPV Calculation Guide and Excel Spreadsheet with MarketXLS

Earnings Power Value (EPV) is a company's value if its current sustainable earnings continue forever with no growth: EPV = adjusted after-tax operating earnings ÷ WACC. To get per-share EPV, subtract debt, add excess cash, and divide by shares outstanding; if the stock trades below that figure, you are paying nothing for growth. The method was popularized by Columbia professor Bruce Greenwald. This guide walks through the ten calculation steps, a worked Microsoft example, and an Excel spreadsheet where MarketXLS functions such as =HF_EBIT("MSFT", 2024), =TotalDebt("MSFT"), and =Last("MSFT") fill in the inputs.

---

What Is Earnings Power Value?

Earnings Power Value is a valuation approach that answers one question: "What is this business worth if it never grows, but maintains its current level of earnings indefinitely?"

The Core Formula

EPV = Adjusted Earnings / WACC

Where:

• Adjusted Earnings = Normalized after-tax operating earnings, adjusted for depreciation, maintenance capex, and non-recurring items
• WACC = Weighted Average Cost of Capital (the required return on invested capital)

Why EPV Matters for Value Investors

Most valuation methods, DCF models in particular, rely heavily on growth assumptions. A small change in the assumed growth rate can swing the valuation by 50% or more. EPV eliminates this uncertainty by assuming zero growth, making it:

1. More conservative: if the stock is cheap even with no growth assumed, the margin of safety does not depend on a forecast
2. Less dependent on forecasting: no need to predict 5–10 years of revenue growth
3. Focused on current earnings: values what the business earns today, not what it might earn tomorrow
4. Complementary to other methods: use alongside DCF and asset-based valuation

EPV vs. Other Valuation Methods

Greenwald recommends using EPV alongside reproduction value. If EPV exceeds reproduction value, the company earns more than its cost of capital, which indicates a competitive advantage (economic moat). If EPV is lower, the business is destroying value.

---

The Complete EPV Calculation: Step by Step

Step 1: Start with Operating Earnings (EBIT)

Begin with the company's Earnings Before Interest and Taxes (EBIT). Use multiple years to normalize:

=HF_EBIT("MSFT", 2021)
=HF_EBIT("MSFT", 2022)
=HF_EBIT("MSFT", 2023)
=HF_EBIT("MSFT", 2024)
=HF_EBIT("MSFT", 2025)

Formula documentation: HF_EBIT

Take the average over 5–7 years to smooth out business cycle effects:

Normalized EBIT = AVERAGE(EBIT_2021, EBIT_2022, EBIT_2023, EBIT_2024, EBIT_2025)

Why normalize? A single year's EBIT can be abnormally high (boom year) or low (recession). Averaging captures the company's sustainable earning power across economic conditions.

Step 2: Adjust for Non-Recurring Charges

Companies frequently report "one-time" charges that are actually recurring. Review 5–7 years of financial statements and calculate the average of items classified as non-recurring:

• Restructuring charges
• Litigation settlements
• Asset write-downs
• Acquisition-related costs

Subtract the annual average of these charges from normalized EBIT.

Adjusted EBIT = Normalized EBIT - Average Non-Recurring Charges

Step 3: Apply the Tax Rate

Apply an appropriate tax rate. You can use either:

• The company's average effective tax rate over the normalization period
• The statutory corporate tax rate (21% in the US)

After-Tax Earnings = Adjusted EBIT × (1 - Tax Rate)

Retrieve the income tax expense to calculate the effective rate:

=HF_INCOME_TAX_EXPENSE("MSFT", 2024)

Formula documentation: HF_INCOME_TAX_EXPENSE

And the pre-tax income:

=HF_EBIT("MSFT", 2024)

Formula documentation: HF_EBIT

Effective tax rate = Income Tax Expense / EBIT (approximately).

Step 4: Add Back Depreciation

Depreciation is a non-cash charge that reduces reported earnings but does not represent an actual cash outflow. Add back the most recent year's after-tax depreciation:

=HF_DEPRECIATION("MSFT", 2024)

Formula documentation: HF_DEPRECIATION

After-Tax Depreciation = Depreciation × (1 - Tax Rate)

Some analysts add back full depreciation; others add back only a portion (e.g., 80%) depending on how well they believe reported depreciation reflects true economic wear. Greenwald recommends adding it back entirely and then subtracting an estimate of true economic depreciation (maintenance capex) in the next step.

Step 5: Subtract Maintenance Capital Expenditure

Maintenance capex is the spending required to maintain the company's current productive capacity, as opposed to growth capex, which expands capacity.

Estimating Maintenance Capex:

1. Calculate the long-term average ratio of Gross PPE to Sales:

Gross PPE/Sales Ratio = Average(Gross PPE / Revenue) over 5-7 years

2. Calculate growth capex:

Growth Capex = PPE/Sales Ratio × Current Year Increase in Sales

3. Calculate maintenance capex:

Maintenance Capex = Total Capex - Growth Capex

Retrieve revenue data for multiple years:

=hf_revenue("MSFT", 2021)
=hf_revenue("MSFT", 2022)
=hf_revenue("MSFT", 2023)
=hf_revenue("MSFT", 2024)
=hf_revenue("MSFT", 2025)

Formula documentation: hf_revenue

Also use the summary function:

=Revenue("MSFT")

Formula documentation: Revenue

Step 6: Calculate Adjusted After-Tax Earnings

Combine all adjustments:

Adjusted After-Tax Earnings = After-Tax Earnings + After-Tax Depreciation - After-Tax Maintenance Capex

This is the sustainable, cash-generating earning power of the business.

Step 7: Determine the Cost of Capital (WACC)

WACC represents the minimum return investors require. For EPV purposes, a simplified WACC works:

WACC = (E/V × Re) + (D/V × Rd × (1 - T))

Where:

• E/V = Equity proportion of total capital
• D/V = Debt proportion of total capital
• Re = Cost of equity (often estimated using CAPM: Rf + Beta × Market Risk Premium)
• Rd = Cost of debt (interest expense / total debt)
• T = Tax rate

MarketXLS helps with several inputs:

=MarketCapitalization("MSFT")   → Market value of equity
=TotalDebt("MSFT")              → Total debt
=Beta("MSFT")                   → Beta for CAPM
=Last("MSFT")                   → Current stock price

Formula documentation: MarketCapitalization, TotalDebt, Beta, Last

Typical WACC range: For large-cap US companies, WACC generally falls between 7% and 12%. For the purposes of a conservative EPV, using a higher WACC (e.g., 10%) provides additional margin of safety.

Step 8: Calculate Enterprise EPV

Enterprise EPV = Adjusted After-Tax Earnings / WACC

For example, if adjusted earnings are $85 billion and WACC is 9%:

Enterprise EPV = $85B / 0.09 = $944 billion

Step 9: Convert to Equity EPV Per Share

To get the per-share value for comparison with the stock price:

Equity EPV = Enterprise EPV - Total Debt + Excess Cash

EPV Per Share = Equity EPV / Shares Outstanding

Retrieve these values:

=TotalDebt("MSFT")
=HF_CASH_AND_EQUIVALENTS("MSFT", 2024)
=Shares_Outstanding("MSFT")
=Last("MSFT")   → For comparison with EPV per share

Formula documentation: TotalDebt, HF_CASH_AND_EQUIVALENTS, Shares_Outstanding, Last

Step 10: Assess Margin of Safety

Compare EPV Per Share with the current market price:

Margin of Safety = (EPV Per Share - Market Price) / EPV Per Share

Many value investors look for a 30–50% margin of safety before considering a stock. The bands below are a common way to read the result, not buy or sell signals:

---

Building the EPV Spreadsheet in Excel

Worksheet Layout

Create a workbook with the following structure:

Section A: Input Data (MarketXLS Functions)

Section B: EPV Calculation

Color Coding

• Green cells = MarketXLS formulas (auto-populated)
• Yellow cells = Manual inputs (non-recurring charges, WACC, maintenance capex estimates)
• Blue cells = Calculated results

This structure allows you to change the ticker in cell B1 and have the entire model recalculate for any company.

---

Worked Example: Microsoft (MSFT)

Let us walk through a complete EPV calculation for Microsoft.

Data Collection (via MarketXLS)

Note: These are illustrative figures. Use actual MarketXLS output for real analysis.

Calculation

In this illustrative example, Microsoft trades far above its EPV, indicating the market is pricing in substantial future growth. This is expected for a high-growth tech company. EPV is most useful for identifying companies where the market price is below the no-growth value.

---

Understanding WACC in the EPV Context

The WACC is the most impactful input in the EPV calculation. A small change in WACC dramatically affects the result.

Sensitivity Analysis

For $67.2B in adjusted earnings:

A 1% change in WACC swings EPV per share by approximately 15%. Always run a sensitivity table and use a WACC range rather than a single point estimate.

CAPM-Based Cost of Equity

Re = Rf + Beta × (Rm - Rf)

Where:

• Rf = Risk-free rate (10-year Treasury yield, ~4.5%)
• Rm - Rf = Equity risk premium (~5.5%)
• Beta = =Beta("MSFT")

Re = 4.5% + 0.9 × 5.5% = 9.45%

Conservative Approach

Many value investors use a flat 10% or even 12% as their WACC for EPV calculations, regardless of the company-specific CAPM estimate. This adds conservatism and avoids the false precision of beta estimates.

---

EPV and Reproduction Value: Greenwald's Framework

Greenwald's complete framework compares three values:

1. Asset Value (Reproduction Value): what it would cost to reproduce the company's assets
2. Earnings Power Value: what the business earns sustainably with no growth
3. Growth Value: the additional value from profitable growth (DCF or growth models)

Interpreting the Comparison

The Margin of Safety Cascade

For the most conservative value investors:

1. First, check if stock price < Asset Value. If yes, the margin of safety is very strong (buying assets below replacement cost)
2. Then, check if stock price < EPV. If yes, the margin of safety is good (buying earning power below its capitalized value)
3. Finally, check if stock price < EPV + reasonable Growth Value. If yes, the margin of safety is moderate

EPV sits in the middle of this hierarchy, providing more value attribution than pure asset-based analysis but less speculation than growth-dependent DCF.

---

Industries Where EPV Works Best

EPV is most reliable for:

EPV is less reliable for:

---

Common Mistakes in EPV Analysis

---

How MarketXLS Streamlines EPV Analysis

With MarketXLS, each input is a formula instead of a lookup in SEC filings, so changing the ticker repopulates the model. On Mac or Excel for the web (the Microsoft 365 add-in), prefix the functions with mxls..

For pricing details and subscription options, visit the MarketXLS pricing page.

---

Frequently Asked Questions

What is Earnings Power Value in simple terms?

Earnings Power Value (EPV) estimates what a company is worth if its current level of earnings continues forever, with no growth. It divides normalized after-tax operating earnings by the cost of capital. If the stock price is below EPV per share, the company may be undervalued even without any future growth.

Who developed the Earnings Power Value method?

Professor Bruce Greenwald of Columbia Business School developed and popularized the EPV framework. It is detailed in his book "Value Investing: From Graham to Buffett and Beyond." The method builds on Benjamin Graham's principles of conservative valuation and margin of safety.

How is EPV different from a DCF valuation?

A DCF model projects future cash flows over 5–10+ years and discounts them to present value, so it depends heavily on growth assumptions. EPV assumes zero growth and capitalizes current sustainable earnings. EPV is more conservative and less sensitive to forecasting errors. Many analysts use EPV as a "floor" valuation and DCF as an "optimistic" scenario.

What WACC should I use for EPV?

For conservative analysis, many value investors use a flat 8–12% regardless of the company. For a more precise estimate, calculate WACC using the Capital Asset Pricing Model (CAPM) for the cost of equity and the company's cost of debt. Always run a sensitivity table showing EPV at multiple WACC assumptions (e.g., 7%, 9%, 11%) to understand the impact.

Can I calculate EPV for any company?

EPV works best for mature companies with stable, predictable earnings. It is less useful for high-growth companies (where most value comes from future growth), early-stage companies with minimal earnings, or companies undergoing significant restructuring. Use it as one tool in your valuation toolkit alongside DCF, relative valuation, and asset-based analysis.

How does MarketXLS help with EPV calculations?

MarketXLS provides Excel functions that pull financial data directly into your spreadsheet: =HF_EBIT() for operating earnings, =hf_revenue() for revenue, =HF_DEPRECIATION() for depreciation, =TotalDebt() for debt, =MarketCapitalization() for market cap, =Beta() for CAPM inputs, and =Last() for the current stock price. This automates the data collection process and allows you to build a reusable EPV template that works for any ticker symbol.

---

Conclusion

Earnings Power Value removes growth assumptions and values what a business earns now, which shows whether a stock's price is supported by current earnings or depends on expected growth.

The calculation requires careful normalization of earnings, thoughtful estimation of maintenance capex, and a reasonable cost of capital. MarketXLS handles the data steps: pull multi-year EBIT with =HF_EBIT(), revenue with =hf_revenue(), depreciation with =HF_DEPRECIATION(), and current prices with =Last(). A reusable template lets you run the same EPV model on any ticker.

Remember: EPV is a conservative baseline, not the complete picture. Use it alongside reproduction value analysis (to assess competitive advantage), DCF (to value growth), and the current market price (to identify margin of safety). When the market price is below EPV per share, the valuation does not depend on growth forecasts. This article is educational and not investment advice.

Ready to build your EPV spreadsheet? Get started with MarketXLS and bring fundamental data directly into your Excel valuation models.