Module VI· Circular References & IterationAdvanced
Question
When do you use copy-paste-values as loop resolution instead of iteration?
Answer
Use copy-paste-values when a circular calculation is needed only once or when model stability matters more than dynamic updating. Examples include locking a refinancing case, final bid output, or a circular tax / interest loop in a static deliverable. Document it clearly because pasted values will not update when assumptions change.