◆ Formulas I · drill · Spreadsheet Formulas & Data track
Margins across the page
point the divide, fill it down, dress it — the same three moves price a margin, a growth rate and a multiple.
The coverage page came back from the junior with the raw metrics pulled and the three ratio columns left empty — revenue for both years, EBITDA and enterprise value (EV) are all sitting there. Price the peer set: the margin, the growth rate and the EV/EBITDA multiple, each shown the way its number gets quoted. The ratio columns land in a different order every run, so read the headers, not the positions.
The shortcuts in this drill
Ctrl+D⌘D on macFill down from the cell above
Build the logic once in the top cell, select down, and stamp it — the standard way to fill a schedule.
Ctrl+1⌘1 on macOpen the Format Cells dialog
The master formatting dialog — number formats, alignment, borders in one place when a ribbon walk would take longer.
Ctrl+B⌘B on macBold
Bold marks structure: titles, total rows, anything the reviewer’s eye should land on first.
The optimal line
the par-setting sequence, straight through:
G3 point =EBITDA/revenue · F3 point =FY25/FY24-1 · H3 point =EV/EBITDA · select F3:H8 ctrl+d · G3:G8 + F3:F8 ctrl+1 p · H3:H8 ctrl+1 x · F2:H2 ctrl+b · ctrl+s
More Formulas I drills