Enterprise value vs equity value: build the valuation bridge
Work out what each measure values, classify debt, cash and other claims, and bridge between enterprise value and a per-share equity value with checked answers.
THE FINX JOURNAL LEARN BY DOING
Financial modeling
Understand how a model fits together, follow its connections and practice finding the mistakes behind the numbers.
In this topic
PAGE 5
Retained earnings formula: reconcile profit, dividends and the balance sheet
Build a two-year retained earnings roll-forward with a profit year and a loss year, catch a dividend sign error and reconcile the result to balance-sheet equity.
Working capital schedule: forecast receivables, inventory and payables
Build a three-year operating working capital schedule from DSO, DIO and DPO drivers, check the cash-flow sign of each change and catch a payables forecast on the wrong base.
Comparable company analysis: build a peer set and valuation range
Build a trading-comps example in Excel: select peers, calculate EV/EBITDA, handle a loss-making company and bridge enterprise value to equity value with checked answers.
DCF model example: build cash flow, terminal value and equity value
Build a five-year DCF model in Excel with checked formulas, a terminal-value timing fix and a sensitivity table. Follow the bridge from enterprise to equity value.
Balance sheet not balancing? Follow the cash before changing a number
Find a missing cash-flow entry in a worked financial model. Reconcile cash, debt and equity, then test whether your correction fixes the cause.