◆ Models II · drill · Financial Modeling Keyboard Mastery track
Sweep the revolver
A revolver has two regimes and one formula each — MAX draws the shortfall, MIN sweeps only what is owed.
Credit committee is Thursday and the revolver page is still blank under the opening balance. One facility, four years: it funds any shortfall to the minimum cash balance, and in a good year it sweeps the cash above that minimum — never more than is outstanding. Build the draw and the sweep, close each year, open the next one on that close, and show where cash lands once the facility has moved.
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+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+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.
Shift+↓⇧↓ on macExtend selection one cell
functions you'll type: MAX() · MIN() · SUM()
The optimal line
the par-setting sequence, straight through:
C13 =MAX(0,$C$9-C6) · C14 =-MIN(C12,MAX(0,C6-$C$9)) · C15 =SUM(C12:C14) · ctrl+b + alt h b p · D12 =C15 fill → · ctrl+r the 13–15 block · C17 =C6+C13+C14 · ctrl+s
More Models II drills