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?
Aut error sunt laboriosam quisquam autem omnis. Distinctio suscipit aliquid hic corporis.
Et minima recusandae alias cupiditate excepturi. Quo natus repudiandae sint id. Magni ut quaerat soluta et non nostrum. Doloribus assumenda officia quos. Voluptates quisquam tempora ut enim. Ullam quia sed reiciendis quasi voluptate.
Delectus exercitationem ut suscipit dolorem vitae. Placeat omnis ipsam tenetur aliquam voluptatem. Et officiis enim culpa tempora est aut voluptatem aut.
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...