Module VI· Interest Calculation MechanicsIntermediate
Question

How do you model interest on average balance without a circular reference?

Answer

Use beginning balance as a proxy, use prior-period ending balance, or calculate interest before optional sweep and base the sweep on cash after interest. Another method is a circularity switch: use average balance when iteration is on and beginning balance when off. The cleanest non-circular approach sacrifices some precision for stability.