Threshold formula creates circular error

The columns are
-Date
-Daily ROI
-Balance
-Draw Amount


I have a formula that returns the date a threshold in the Balance is reached. Another formula uses that date as a flag to begin computation of another formula to calculate the Draw Amount. The balance amount is then the previous Balance Amount+Daily ROI-DrawAmount. This last action creates a circular reference. I'm probably overlooking somethig obvious, but need this to work.

Formulas

=OFFSET(A1,MATCH(P14,G:G,1),0,1,1) 'where A1 is the beginning of the Date column; P14 is the Threshold Amount and G:G is the Balance column - returns date
=IF(G2>=$P$14,(1-$O$14)*E2,"") 'IF Balance Amount(G2) reaches Threshold(P14), multiply draw rate(1-$O$14) by the ROI
=G2+E3-I2 'Old Balance + New ROI - Draw Amount....this creates circular reference

How do I calculate the new balance?

Sheet "Alt"

I want column G to be equal to column G(row-1)+ column E - column F - column K

The problem is the formula in column K uses the value in column G.

I don't want column K to have a value until column G reaches a threshold. Once that threshold is reached the value in K is subtracted from G. I've been racking my brain to make this happen, but I keep getting a circular reference. I could probably do more with VBA, but I'd rather not.

THanks