CFM Model Design, Structure & Best Practices

Question 1

Under common modeling color conventions, what does blue font usually mean?

Accepted Answer

Hard-coded inputs or assumptions

Answer

Industry convention uses blue for hard-coded inputs, black for formulas and green for links to other sheets. This lets a reviewer see right away which cells are meant to be changed.

Question 2

Why do best-practice models keep inputs, calculations and outputs in separate sections?

Accepted Answer

To improve transparency, make the model easier to audit and lower the risk of overwriting formulas

Answer

Separating assumptions, logic and results makes the model's flow easy to follow. Users can change inputs in one place without touching formulas, which also makes reviews easier.

Question 3

Which formula breaks modeling best practice?

Accepted Answer

=C10*1.05

Answer

=C10*1.05 hides a hard-coded 5% assumption inside the formula. The assumption can't be seen in the inputs section and is easy to miss when assumptions change.

Question 4

What does the 'one formula per row' principle mean in a time-series model?

Accepted Answer

The same formula should be used consistently across every period in the row

Answer

When the formula is the same across all columns of a row, the model is easier to review and to extend. It also avoids hidden one-off changes in individual periods.

Question 5

What is the main purpose of timing flags (1/0 indicators) in a financial model?

Accepted Answer

To switch calculations on or off for specific periods such as construction or operations

Answer

Timing flags are multiplied into calculations so that items such as revenue or debt repayment only appear in the right periods. They also respond automatically when dates change.

CFM - Certified Financial Modeler Practice Test

CFM - Certified Financial Modeler Practice Test

CFM Model Design, Structure & Best Practices