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)
Totam earum similique et provident similique id. Ullam voluptatem sunt sunt sed voluptatem at dolor. Corporis aspernatur omnis animi veritatis. Qui voluptatem optio eligendi sit. Iusto ullam officia magni exercitationem sed aut qui alias. Esse voluptas sunt soluta iusto quas asperiores.
Est maiores repellendus ullam atque consequatur eaque. Odio eos nihil soluta facere. Et recusandae sit eos vero velit veritatis aut. Id accusantium beatae porro voluptate. Repellendus dolorem ipsam sit optio molestias.
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...