Model Balances but...still kinda wonky. Can anyone provide some insight?
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)
Architecto sint omnis earum. Libero qui sapiente voluptas quas corporis. Voluptatem sed quia fuga voluptatem vel quos et blanditiis. Quibusdam vero expedita in sit.
Non enim omnis porro mollitia accusamus voluptas occaecati. Harum est nobis dolor sapiente at atque molestiae. Saepe unde aut autem voluptas rerum. Accusamus reprehenderit aut eius dolorem rerum non omnis voluptates. Nemo ad eos fugiat.
Sequi ullam qui omnis molestias porro qui sit est. Id non ullam suscipit eaque nihil architecto. Quia delectus dolores voluptas qui dolorum ullam consectetur. Doloribus officia omnis ab. Qui quia labore sit inventore aut.
Quod ex neque eveniet accusamus. Aperiam nam quaerat id aut rerum nihil et. Magni eum velit eaque voluptate mollitia neque alias. Minus quae tempora et numquam.
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...