Multi-Period Excess Earnings: Step-by-Step Calculation Guide

Overview of the MPEEM

The Multi-Period Excess Earnings Method (MPEEM) is the primary valuation approach for intangible assets that are the central earnings driver of a business — most commonly customer relationships. This guide walks through the complete calculation from start to finish using a practical worked example.

The MPEEM isolates the earnings attributable to a specific intangible asset by deducting the fair economic returns required by all other assets that contribute to generating those earnings. These deductions — contributory asset charges — represent what the business would pay if it had to rent or lease every other asset it uses.

6 core calculation steps

#1 method for customer relationship valuation

Critical accuracy in each step compounds into the final value

★ Key Takeaway

The MPEEM is conceptually straightforward but computationally demanding. Every assumption — from the earnings forecast to each contributory charge rate — affects the final value. This guide provides the structured approach needed to avoid the errors that commonly distort MPEEM results.

The Six Steps

Step 1: Forecast total earnings

Project the total earnings attributable to the existing asset base over the asset's useful life.

Step 2: Apply attrition

Adjust earnings for the expected decline in the primary asset over time (e.g., customer attrition).

Step 3: Calculate contributory asset charges

Deduct fair returns on all other assets that contribute to generating the earnings.

Step 4: Derive excess earnings

Subtract the total contributory charges from the attrition-adjusted earnings.

Step 5: Tax-adjust the excess earnings

Apply the effective tax rate to derive after-tax excess earnings.

Step 6: Discount to present value

Apply the asset-specific discount rate to determine the fair value of the primary intangible asset.

Worked Example: Customer Relationship Valuation

Background

A technology company is acquired for £80M. The PPA team has identified customer relationships as the primary intangible asset and will value them using MPEEM. Key facts:

Revenue from existing customers: £25M (Year 1)
Operating margin on existing customer revenue: 30%
Customer attrition rate: 12% per year (revenue-weighted)
Revenue growth per surviving customer: 3% per year
Tax rate: 25%
Customer relationship discount rate: 14%
Useful life: 10 years

Step 1: Forecast Total Earnings

Project the operating earnings from existing customers over the 10-year useful life. Each year, revenue from surviving customers grows at 3% but the customer base shrinks by 12%:

Year	Surviving Base	Revenue (£M)	Operating Earnings (£M)
1	100%	25.00	7.50
2	88%	22.66	6.80
3	77.4%	19.93	5.98
4	68.1%	17.55	5.27
5	59.9%	15.45	4.63
6	52.7%	13.60	4.08
7	46.4%	11.97	3.59
8	40.8%	10.53	3.16
9	35.9%	9.27	2.78
10	31.6%	8.16	2.45

Step 2: Attrition Adjustment

The attrition is already embedded in the surviving base percentages above. The 12% annual attrition rate means that by Year 10, only 31.6% of the original customer revenue base remains.

Step 3: Contributory Asset Charges

The following assets contribute to generating the customer relationship earnings:

Asset	Fair Value (£M)	Return Rate	Year 1 Charge (£M)
Working capital	5.0	4%	0.20
Fixed assets	3.0	7%	0.21
Assembled workforce	4.0	18%	0.72
Technology platform	15.0	13%	1.95
Trade name	5.0	10%	0.50
Total Year 1 charges			3.58

ℹ Note

The contributory charges decline over time as the contributing assets depreciate and the existing workforce turns over. In a full model, each charge has its own decay schedule. For simplicity, assume total charges decline proportionally with the customer base — from £3.58M in Year 1 to approximately £1.13M in Year 10.

Step 4: Excess Earnings

Year	Operating Earnings (£M)	Total CACs (£M)	Excess Earnings (£M)
1	7.50	3.58	3.92
2	6.80	3.15	3.65
3	5.98	2.77	3.21
4	5.27	2.44	2.83
5	4.63	2.15	2.48
6	4.08	1.89	2.19
7	3.59	1.66	1.93
8	3.16	1.46	1.70
9	2.78	1.29	1.49
10	2.45	1.13	1.32

Step 5: After-Tax Excess Earnings

Apply the 25% tax rate:

Year	Pre-Tax Excess (£M)	Tax (£M)	After-Tax Excess (£M)
1	3.92	0.98	2.94
2	3.65	0.91	2.74
3	3.21	0.80	2.41
4	2.83	0.71	2.12
5	2.48	0.62	1.86

(Pattern continues through Year 10)

Step 6: Present Value

Discount each year's after-tax excess earnings at 14%:

Year	After-Tax Excess (£M)	PV Factor (14%)	Present Value (£M)
1	2.94	0.877	2.58
2	2.74	0.769	2.11
3	2.41	0.675	1.63
4	2.12	0.592	1.26
5	1.86	0.519	0.97
6-10	(declining)	(declining)	2.45
Total Fair Value			£11.0M

✔ Example

The customer relationships are valued at approximately £11.0M, representing about 13.8% of the £80M purchase price. Combined with the technology (£15M), trade name (£5M), and other identified assets, the remaining value would be allocated to goodwill.

Validation Checks

After completing the MPEEM calculation, perform these validation checks:

WARA reconciliation. Ensure the implied return on customer relationships, combined with returns on all other assets, reconciles to the entity-level WACC.

Reasonableness test. Does the customer relationship value, expressed as a multiple of existing customer revenue, fall within a reasonable range for the industry? For technology businesses, customer relationship values of 0.3-0.8x annual customer revenue are typical.

Sensitivity analysis. Test the impact of key assumptions: a 2% change in attrition rate, a 1% change in discount rate, and a 2-year change in useful life. Document the range of outcomes.

⚠ Warning

If the MPEEM produces a negative excess earnings result in any year, revisit the contributory charges. Negative excess earnings imply that the primary asset is destroying value, which is economically implausible for the primary earnings driver of a profitable business. The issue is almost always in the charge calculations, not in the earnings forecast.

The Bottom Line

The MPEEM is a powerful but assumption-intensive method. Follow the six steps methodically, ensure each contributory charge is independently justified, and validate the result through WARA reconciliation and reasonableness testing. The Opagio Calculator automates the entire MPEEM workflow — from earnings projection through contributory charges to present value — with built-in WARA reconciliation. Run your MPEEM calculation.

Tony Hillier is an Advisor at Opagio with 30 years of experience in structured finance, M&A advisory, and asset valuation. He has applied MPEEM to customer relationships across technology, telecommunications, and financial services acquisitions. Meet the team.

Share:

TH

Tony Hillier — Chairman, Co-Founder

MA, Balliol College, University of Oxford | Harvard Business School MBA with Distinction

Connect on LinkedIn →