Every roll-forward is beginning balance + adds − subs = ending balance — one formula, filled across.
The capex plan came back from ops overnight and the fixed-asset page is still empty under the inputs. Two statements read off this schedule before the four o’clock model review — the balance sheet takes the closing net book value, the cash flow takes the depreciation. Build the first year, open every later year at the prior year’s close, and run the accumulated-depreciation memo underneath.
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.
Shift+↓⇧↓ on macExtend selection one cell
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.”
functions you'll type: SUM()
the par-setting sequence, straight through:
C8 =-C5*$C$15 · C9 =SUM(C5:C8) · D5 =C9 ctrl+r · C8:G9 ctrl+r · ctrl+b + alt h b p on the ending line · C12 =$C$16+C8 · D12 =C12+D8 ctrl+r · ctrl+s