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?
Autem et molestias et voluptas accusamus expedita alias. Unde dolores et vel maxime mollitia. Vitae laborum necessitatibus quisquam incidunt. Est ducimus beatae est repellat explicabo culpa.
Ullam ut enim nulla quasi distinctio. Praesentium vel et dolorum aut ducimus voluptas consequuntur ut. Voluptatem autem itaque molestiae dolor et dignissimos. Quas quia molestiae natus aliquam. Quasi sapiente voluptatem et accusamus voluptatem. Enim ducimus iure et repudiandae.
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...