Type the purchase, the investee's results, dividends and balance sheets once, and the workbook keeps two equity method investments for three years: a 30 percent corporate stake with its memo purchase price allocation, basis differences amortized through equity in earnings, a dilution and eliminations in both directions, and a 40 percent partnership interest whose losses run past zero into a member loan. Every year the carrying amount is proved as the share of the investee's net assets plus the basis differences. In the worked case the cost of $9,150,000 carries $900,000 of equity method goodwill.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 192 free models.
Equity_Method_Model.xlsx (33 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with The Equity Method Accounting Handbook, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 193 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
11 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Inputs
Prices, share counts, the investees' results, other comprehensive income, dividends and balance sheets, intra-entity sales and fair values, in yellow cells.
MemoPPA
The memo purchase price allocation: share of book net assets, step-ups to fair value and equity method goodwill as the residual.
BasisDiff
Each basis difference rolled forward: inventory released, plant and customer relationships amortized, goodwill not amortized.
Quillmark
Equity in earnings, other comprehensive income and dividends year by year, and the proof: share of net assets plus basis differences equals the carrying amount.
Dilution
An issue of shares to an outside investor treated as a deemed sale: deemed proceeds, carrying amount sold, other comprehensive income reclassified, the gain.
IntraEntity
Downstream and upstream profits still in inventory, eliminated at the investor's percentage and released when sold.
Fennick
A partnership interest on a three-month lag: losses down to zero, then against the member loan, then suspended, and the resumption order.
Impairment
The other-than-temporary charge, the new basis and the negative basis difference accreted afterwards.
StepUp
Obtaining control: the previously held interest at fair value and the gain, plus an illustrative loss of significant influence.
Disclosure
The balance sheet line, the income statement line and summarized financial information.
Checks
Thirteen ties: memo total against the ledger, net assets rolled forward against the balance sheet, both sides of each intra-entity sale, the proofs, floors and dividends.
What the worked case returns
Measure
Value
Initial cost of the 30 percent stake, 1 January 2024
$9,150,000
Aggregate basis difference at acquisition
$3,150,000
of which equity method goodwill, not amortized
$900,000
Carrying amount, 31 December 2024
$9,390,000
Carrying amount, 31 December 2025, after the dilution
$10,175,000
Dilution gain, 1 July 2025, outside equity in earnings
$477,500
Proof at 31 December 2026: share of net assets plus basis differences
$10,217,500
Partnership interest: impairment at 31 December 2025 (US dollars)
700,000
2026 losses charged against the member loan (US dollars)
1,500,000
Losses suspended at the end of 2026
$150,000
Gain on obtaining control, 31 December 2026
$4,232,500
The 2026 loss share of $2,750,000 is absorbed in order: the investment down to zero, then $1,500,000 against the member loan, the next most junior interest, and the last $150,000 is suspended and kept in a memo, to be made up before any later income is recognized. The Quillmark carrying amount is never trusted on the roll-forward alone: each year it is rebuilt as the share of the investee's net assets plus the remaining basis differences, $10,217,500 at the end of 2026.
How to use it on your own case
Enter the price, the share counts and the direct costs of the purchase, and the investee's book net assets and fair values, in the yellow cells of Inputs.
Enter each year's investee net income, other comprehensive income, dividends and balance sheet, and both sides of each intra-entity sale.
Read MemoPPA and BasisDiff: goodwill is the residual of the allocation, and every other difference has a life or a release event.
Read Quillmark and Fennick: the roll-forward and the proof must give the same carrying amount, and losses below zero must follow the order of seniority.
Check that the Checks tab reads ALL PASS before you take any figure into a note or a memo.
Questions people ask about it
Why prove the carrying amount every year?
Because nothing in the general ledger forces an equity method investment to agree with anything else. Rebuilding it as the investor's share of the investee's net assets plus the remaining basis differences shows whether a charge was missed or a draft balance sheet was used. In the case the proof gives $10,217,500 at the end of 2026.
What happens when losses take the investment below zero?
The investor generally stops at zero unless it has guaranteed obligations or committed to fund more. When it holds other investments in the investee, such as a member loan, it keeps recording losses against them, most junior first, at its percentage of each. In the case $1,500,000 goes against the loan and $150,000 is suspended.
Does the model decide whether I have significant influence?
No. It keeps the figures once the equity method applies. The decision rests on the voting interest, the indicators and the memo that weighs them, which the book covers in its own chapter.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.