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?
Suscipit vitae sit officiis tempore. Dolores est aut suscipit nemo. Asperiores delectus quia sapiente dignissimos et id molestiae. Enim in placeat vel sint dolor. Vel ratione saepe impedit consectetur. Molestiae ut omnis sint quia.
Magni porro rerum ad in nam nostrum cumque aperiam. Nam aliquam architecto molestiae. Sequi deserunt qui ex vel. Id aperiam officia expedita quam aut 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...