hotkey.gg / drill library / full builds
◆ Full Builds · drill · Financial Modeling Keyboard Mastery track

Tie the three statements

three statements, three wires — everything else is arithmetic.
The associate who built this pack left the three statements sitting side by side and never wired them together — net income never reaches the cash flow statement, cash never reaches the balance sheet, and retained earnings never absorbs the year. The VP reads it at eight. Build the three links, then build the check row under the balance sheet and bold it. Three zeros mean every wire is in.
train this drill → par 45s · optimal 42 keys · keyboard only · free
The shortcuts in this drill
Alt walks: tap Alt, release, then the letters in sequence — each key steps one ribbon menu. On a Mac, tap and use the same letters (KeyTips, Excel 2024+).
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.
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.
Ctrl+B⌘B on macBold
Bold marks structure: titles, total rows, anything the reviewer’s eye should land on first.
Alt h b p⌥ h b p on macTop border
Top border above a total row — the accounting ruling that says “this line sums the ones above.”
Ctrl+S⌘S on macSave
The optimal line
the par-setting sequence, straight through:
link C8=C6 · C14=C12 · D18=C18+D6 · each line shift+→ then ctrl+r (or ctrl+↵) · C20=C16-C19 ctrl+r · ctrl+b + alt h b p · ctrl+s
More Full Builds drills
Build the income statement
Five forecast years off one driver panel — revenue grown year on year, the cost lines as a
Balance the balance sheet
Three years: roll retained earnings, total both sides, land the check at zero
Link the cash flow statement
Point the statement at its schedules, close the cash roll year to year, read cash conversi
Roll working capital
Roll receivables, inventory and payables off three day-count drivers
← NWC Schedule Op model → all 74 drills
Excel is a registered trademark of Microsoft Corporation. hotkey.gg is independent and not affiliated with or endorsed by Microsoft. More: the shortcut compendium · all drills · about hotkey.gg.