Glossary
Circular reference
A formula loop that a spreadsheet cannot resolve in one pass. In a debt schedule, interest depends on average debt, average debt depends on cash flow, and cash flow depends on interest. Fixes are iterative calculation with a circuit breaker, or an interest calculation on beginning balances that avoids the loop.
