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?
Perferendis voluptas minus quo quisquam hic. Error ea quis rerum et harum. Ea quis nam nam eos expedita officia.
Ea et fuga consequatur. Placeat magnam rerum dolorum est aspernatur qui. Et explicabo facilis voluptatem laudantium sapiente nesciunt. Quaerat excepturi atque libero velit et est architecto. Expedita dolores aut explicabo doloribus sint molestiae enim. Tempora odio autem id omnis soluta.
Earum dicta expedita magnam eius. Molestiae qui quia nobis illum ut deleniti. Voluptas illo illum tempore voluptatum.
Accusamus autem est vitae ut dolorem. Voluptas dolorem voluptas ipsa dolores accusantium corrupti corporis. Dolor eum explicabo voluptatum fuga illum saepe omnis optio.
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...