Unfortunately, the ‘Construction Loan Macro’ seems to break when iterative calc is turned on and a circular reference exists in the Workbook. As reference, the ‘Construction Loan Macro’ iteratively solves for the construction interest reserve in order to avoid a circular reference in that logic. The macro uses the Goal Seek functionality to iterate to the correct interest amount, and that process seems to go into an infinite loop when a separate circular reference is in the model.