Model Help - Any tips?

Hi guys,

I'm having some problems with building forecast models. I can't get the model to work when i try having 2 plugs at the same time (#DIV/0!)

Here's the situation: 1)Company raises additional capital through debt only 2) Additional cash is invested in short-term securities 3) Cash has to be above $45m at all times

Here's the excel formula I'm using: In Cash& Short term Securities --> =MAX($45M, IF(TL&E-TA>0, TL&E-TA, 0)) In Debt --> =IF(TA-TL&E>0, TA-TL&E, Previous_Year_Debt)

Interest on Cash and Debt are = Constant%*AVERAGE(Previous_Year, Current_Year) Any tips? I've been trying to find solutions online and through books, no luck.

Thanks in advance!