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

Earnings Power Value (EPV) is a conservative valuation method that estimates a company's intrinsic value based on its current, sustainable earnings — without assuming any future growth. Developed by Columbia University Professor Bruce Greenwald, EPV is a cornerstone of value investing that forces analysts to separate what a business earns today from speculative growth assumptions. In this comprehensive guide, you will learn the complete EPV formula, how to normalize earnings, calculate the weighted average cost of capital (WACC), determine margin of safety, and build an Earnings Power Value spreadsheet in Excel using MarketXLS functions like =hf_revenue(), =HF_EBIT(), =PERatio(), =MarketCapitalization(), =Revenue(), and =Last().

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 is real
2. Less dependent on forecasting — No need to predict 5–10 years of revenue growth
3. Focused on current reality — Values what the business earns today, not what it might earn tomorrow
4. Complementary to other methods — Use alongside DCF and asset-based valuation for a complete picture

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 — indicating 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)

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)

And the pre-tax income:

=HF_EBIT("MSFT", 2024)

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)

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)

Also use the summary function:

=Revenue("MSFT")

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

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

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

Greenwald and other value investors typically require a 30–50% margin of safety before considering a stock for purchase.

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 — a much stronger margin of safety.

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, very strong margin of safety (buying assets below replacement cost)
2. Then, check if stock price < EPV — If yes, good margin of safety (buying earning power below its capitalized value)
3. Finally, only if stock price < EPV + reasonable Growth Value — If yes, moderate margin of safety

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, the data collection that would take 30–60 minutes of searching SEC filings takes seconds. Change the ticker symbol and the entire model repopulates automatically.

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 — a strong margin of safety for value investors.

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 — 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 is one of the most intellectually honest valuation methods available to investors. By stripping away growth assumptions and focusing on what a business earns right now, EPV reveals whether a stock's price is supported by actual economic performance or merely by expectations of future growth.

The calculation requires careful normalization of earnings, thoughtful estimation of maintenance capex, and a reasonable cost of capital. MarketXLS makes the data-intensive steps effortless — pull multi-year EBIT with =HF_EBIT(), revenue with =hf_revenue(), depreciation with =HF_DEPRECIATION(), and current prices with =Last(). Build a reusable spreadsheet template, and you can evaluate any company's Earnings Power Value in minutes.

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 falls below EPV per share, you have a compelling value opportunity that does not depend on optimistic growth forecasts.

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