Module VI· Circular References & IterationBasic
Question

What is a circular reference in an Excel model?

Answer

A circular reference occurs when a formula depends on its own result, directly or indirectly. Common modeling circulars include interest based on average debt when debt repayment depends on cash after interest, taxes based on interest when debt depends on taxes, or revolver draws based on ending cash. Circulars can be intentional but must be controlled.