Hi everyone,
I have a model that includes a construction loan that requires an interest reserve be included in the overall loan budget. The model calculates the total projected interest based on this budget (cell A2).
Then, and using this value (A2) as reference, I manually add the interest reserve amount to the budget (via cell A1), which then changes the value of cell (A2). I then play (manually) with the Value of (A1) until it is equal to the value in (A2). I'd like to create a macro that will automatically optimize the interest reserve in (A1) so that it equals that in (A2(. The traditional Goal Seek function won't work in this instance because if requires that you have a fixed target to solve to. I suspect that a DO UNTIL loop that sets the value of A1 to $1, checks to see if A1=A2, and if not, adds $1 to A1 and checks again, etc. is whats required but i have been unable to find the code.
Any help would be appreciated.
Bookmarks