Yes I've searched the forums. Yes I've applied all the rules and advice to my model. Yes I've printed out my B/S, went line by line, and scrubbed the ENTIRE model for inaccuracies. Yes, I'm retarded.
The details: I've gone line by line and made a couple of adjustments to silly common errors until my model went from being unbalanced by -209m to a mere -29m. Still, I wasn't understanding where this discrepancy came from.
Then I noticed that my LT debt difference was supposed to be +14 (based on my B/S) but I was showing a decrease of approx -163 based on guidance. So in my roll forward my EOP LT Debt balance was driven by this pay down taken from the company's 10k. Anyways, I adjusted it to the hypothetical $14 difference, and my whole model balanced.
What gives? Should I use this "increase" in LT debt as a plug to get the model to balance or am I missing something?
Here's a drop box link with the model in question, I'm hoping someone is kind enough to take a look. I've been wacking my brain over this for 2 days now and I'm questioning my sanity and intelligence at this point.
https:// tinyurl . com /yb7mv3zv (just delete the spaces)
Iusto quod aperiam quia autem quaerat. Debitis aliquid et laudantium est voluptate enim nihil consequuntur. In porro impedit officiis rerum et inventore saepe.
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...