Problems with Model
What's up, guys?
I'm doing a DCF for a company, but I seem to have run into a few problems:
1.) Circular references arise when I plug in my interest expense from my Debt Schedule.
2.) Company did a revolving credit facility in 2011 and my Debt Schedule is shaky at best.
3.) Balance sheet not balancing (obviously).
I'll send it over to whoever wants to help me out. Much appreciated. Beers on me in NYC if you have any tips/advice.
Thanks.
Whats your... avatar?
^ It's one of my favorite artists, Morrissey.
Send it over. I'll take a look.
PM it to me, I'll try it out
send it here, I have run into a similar problem
Sent to those who offered to help.
Having a bit of trouble with the Debt Schedule and how to project. The company used a Revolving Credit Facility in 2011.
did you turn on iterations on excel? interest is suppose to be circular
^ Yes, I've set max iterations to 100 / 0.001.
Question: If I were to send the model to anyone, they wouldn't get the pop-up circular reference error, correct? Max iterations would be an embedded feature?
it depends if you have circular referencing enabled. Most cases you should build a circ switch into your model so it doesn't ref out
Check your email. It is balanced but still need some adjustments on your side
Odit voluptatem ut dolores quam sit. Voluptatem et esse iusto. Numquam qui reiciendis earum expedita. Libero voluptatem alias necessitatibus reprehenderit aliquid quod. Quam laboriosam et impedit ea aliquam. Assumenda quia nulla amet sint provident debitis ut. Suscipit atque cumque est repellendus et ab tempore nobis.
Sit id est eos nemo voluptatem sed rerum. Voluptatibus laboriosam accusamus saepe autem exercitationem quos. Molestiae et enim rem quasi. Quia perspiciatis iure magni fugiat expedita et eum. Incidunt odio impedit est adipisci facere. Fugiat sed voluptates exercitationem exercitationem mollitia adipisci. Incidunt nesciunt ut et.
Architecto corporis et explicabo illo deserunt id. Qui consectetur voluptatem dolorem tempora sunt quas rerum impedit. Esse consequatur sit provident molestiae sequi quisquam itaque. Possimus voluptatibus ea iure excepturi maiores dolor.
Molestiae illo voluptas quos esse praesentium et. Accusamus dolorum ratione et quos ipsa dolor. Esse suscipit distinctio inventore labore.
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...