Six months into a corporate development role, most analysts from investment banking make the same discovery: the models they built in the bank are the wrong tool for the job they now have. That is not a skill problem. It is a context problem. And it costs credibility fast — …
General
The first time most analysts value a private company, they apply the same methodology they would to a public one. The DCF runs, the comps table gets built, the output looks defensible. Then the questions start — and the model doesn’t hold up. Private company valuation isn’t a variation of …
Revenue is the first line of every financial model and the assumption that drives everything below it — margins, working capital, debt capacity, and ultimately valuation. Most models treat it as a single growth rate. That is not a revenue model. This guide shows how practitioners build revenue assumptions that …
Working capital is not a plug. It is not a percentage of revenue. It is a set of operational drivers — Days Sales Outstanding, Days Inventory Outstanding, Days Payable Outstanding — that translate a company’s commercial reality into cash timing. Get the drivers wrong and your cash flow statement is …
Every valuation model has a number that carries more weight than any other. Not the revenue forecast. Not the margin assumption. The discount rate — and specifically, the Weighted Average Cost of Capital that sits behind it. Get the WACC wrong and the entire DCF moves. A 1% error in …
Most analysts can build a P&L. A reasonable number can build a cash flow statement. But a model where all three statements move together — automatically, consistently, without manual patches — that is where the real skill gap shows up. And it shows up at exactly the wrong moment: under …
Relative valuation benchmarks a company against market prices of comparable peers; intrinsic valuation — primarily DCF — calculates standalone value from projected cash flows. Neither method is universally superior. Which one you use depends on the transaction context, the reliability of comparable data, and what the output needs to survive …
The assumptions tab is the single most consequential sheet in any financial model — and the most commonly built wrong. A well-structured assumptions tab separates every driver from every calculation, makes audits survivable, and lets any analyst pick up the model without a guided tour. Here is exactly how to …
Minority interest is one of the most consistently mishandled line items in consolidated financial models. Analysts either ignore it, hardcode it, or place it correctly on the balance sheet but forget it exists by the time they build the EV-to-equity bridge. This guide covers the full treatment: income statement, balance …
Most analysts can recite the Hamada equation. Far fewer can explain why the beta they just plugged into their WACC is wrong — and exactly where the error entered. This guide walks through the full construction of a levered beta: peer selection, unlevering, re-levering, and the judgment calls that determine …