◆ Full Builds · drill · Financial Modeling Keyboard Mastery track
Build the DCF page
a DCF is one anchored factor row — the PV line, the terminal value and the check all read off it.
The valuation committee meets at eight and the DCF is the last exhibit still open. Diligence signed off on the unlevered cash flows overnight and treasury confirmed net debt and the diluted count — the discounting, the terminal value and the walk down to a share price are yours. The MD reads the check line first: one NPV over the raw flows has to land on the same total your PV row does, or the page does not go in the book.
The shortcuts in this drill
Shift+→⇧→ on macExtend selection one cell
Nudge a selection one cell at a time when the block you need doesn’t end at a data edge.
Shift+↓⇧↓ on macExtend selection one cell
Ctrl+R⌘R on macFill right from the cell to the left
Same as fill down, but across — one quarter’s formula becomes the whole year in two keystrokes.
functions you'll type: SUM() · NPV()
The optimal line
the par-setting sequence, straight through:
discount factor =1/(1+$C$4)^C7 · PV =C8*C9 · ctrl+r across both rows in one pass · terminal value =G8*(1+$C$5)/($C$4-$C$5) · its PV =C12*G9 · EV =SUM(C10:G10)+C13 · equity =C14-C15 · per share =C16/C17 · check =NPV($C$4,C8:G8) · ctrl+s
More Full Builds drills