Auditing unit conversions in an investment banking model
Catch the thousand-fold errors that can survive visual checks in a linked model or pitch book.
Wall Street Playbook ·
Explain the failure
A company reports earnings of $8 million and has 4,000 thousand diluted shares. Converting both to millions gives 8 ÷ 4, or $2.00 EPS. Dividing “8” by “4,000” directly gives $0.002 and silently mixes units.
Add a reconciliation
Label unit scales in the source sheets and keep share counts and monetary amounts explicit. Compare the ratio to a secondary source or a known reasonableness check. If you change a display unit in a deck, verify the underlying Excel formula separately. Abbreviated formatting can hide a scaling error that still affects downstream calculations.
Finance Technical Interview Guide
Get the complete guide when you’re ready for more practice.
Sale price $67.15 Original price $79