Newcrest Mining Valuation (ASX: NCM)

Newcrest's headline numbers told a growth story: revenue from $4.82B to $6.11B over five years, net profit more than doubled. Our recommendation was SELL.

What I built: five years of financial statements, profitability ratios, a WACC calculation, and a full DCF with sensitivity analysis across discount rates and terminal growth assumptions. The sensitivity table was the most instructive part - it showed how dramatically the valuation output changes based on inputs that feel precise but aren't.

What I discovered: profit margins had peaked in 2021 at 45.56% and were declining. EPS growth was real but diluted by repeated capital raises. And the entire performance was structurally dependent on gold prices - a variable no management team controls. That combination told a different story than the revenue headline.

Then Newmont launched a takeover. Newcrest initially rejected it, accepted a revised bid, and was fully delisted later that same year. The company we had built a SELL case on ceased to exist.

The knowledge gain was stark: a DCF forces you to make your assumptions explicit, but it can't capture corporate events that don't show up in the numbers. The biggest risks in security analysis are often the ones that don't fit into a spreadsheet. Knowing what your model can't see is as important as what it can.