Module VI· Excel Setup & Best PracticesIntermediate
Question

How do you prevent hardcodes in formulas?

Answer

Put assumptions in dedicated input cells and reference them. Use color coding, named or clearly labeled assumption rows, and checks for constants inside formulas. Avoid formulas like revenue x 1.05; instead reference the growth assumption. Hardcodes inside formulas make models hard to audit and easy to break.