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!
Stupid question: have you got your iterations on?
Hi HF,
Yes, i've my iterations turned on. I've input a circuit breaker and it works now. But, the balance sheet still can't balance..damnit.
Any one free to take a look?
Pariatur ducimus ut corrupti minima autem. Fugiat nam molestiae velit. Et deleniti molestiae autem aut.
Maiores aut quos nesciunt excepturi est quo corporis. Impedit modi vel modi quod facilis iure.
Minus veniam vitae voluptate quo deleniti. Ea rerum nisi quibusdam debitis quasi deserunt voluptas. Enim mollitia ab consequatur sed commodi placeat sint. At pariatur quia qui et. Dolorem quae eos voluptatem saepe nobis commodi.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...