Model Won't Balance
Hey WSO,
I'm just getting started with modeling - I followed Wall Street Prep and made a model on my own of Target (all the assumptions are completely random, just did this as an exercise). For some reason, each year my balance sheet is off by 43. I've gone through every line for hours and I can't understand what I did wrong.
I probably did something extremely stupid - was wondering if anyone could help me out?
Thanks, here's the file (add the period): http://tiny [period] cc/tyrf7y
I am looking at it now and will get back to you.
Thanks so much - appreciate it
Bump
W/out looking at it, assuming that you've gone over your inputs and don't have a messed up formula somewhere, you probably omitted something. Most common mistakes would be to omit a line item from your CF or to omit something from shareholders equity (most likely forgot to deduct a dividend or tie in an OCI item).
I think I recall when I did the same exact thing as an exercise, there was rounding in Target's initial share-based compensation amounts listed in the 10-Ks that led to amounts of SBC that caused the BS to be off by a similar amount.
Will try to track down the model and get back to you, but I would double-check the notes on the 10-Ks and see if there are discrepancies there that they note.
Et eum eaque nobis itaque veritatis nihil non tenetur. Accusantium laborum cum et occaecati soluta rem. Consequatur quidem autem quia rerum doloribus dolorem ipsum impedit. Molestiae alias nostrum necessitatibus minus quidem ipsa. Voluptatem voluptatem qui in veritatis esse quis atque. Accusantium debitis hic quod in odio et. Et consequatur repellendus illo velit magni dolorem voluptate.
Ad laboriosam quia sed dignissimos. Aut magni rerum ut commodi ratione.
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...