Valuation - need help - balance sheet won't balance
Need some help here - building a valuation model from scratch (dcf, comps, etc.) and I'm having some trouble getting my projections to balance out. I'm not sure as to why things are not balancing but I'm in need of some assistance. All assumptions are my own - first time doing everything myself, so any advice would be greatly appreciated. Thanks.
| Attachment | Size |
|---|---|
| GoPro Valuation 110.5 KB | 110.5 KB |
Why is your username your email address. Poor move - get rid of it
Definitely a mistake - did not even notice that. Much obliged.
I'm not doing this for you, so I doubt these alone will make it balance (correct and resend and I'll take another look). -I don't see your marketable securities change in your CF statement. The adjustment should be roughly $95k. -You also need to switch current liabilities around in your CF statement (e.g., for FY2016 current assets, you take column F and subtract column G. For current liabilities it needs to be G minus F). -Where are your deferred income taxes on the CF statement? You had a change on the BS.. -Where is the other long-term liabilities on the CF statement?
Other than the sign change on working capital adjustments, what would really help is if you make a check list. Go through the balance sheet first and see if the line item changes from one year to the next - then go through your CFs and see if those changes are captured somewhere.
Cumque explicabo voluptas aut voluptatem error animi aliquid sed. Quis consectetur tempore voluptatem nobis quia ut soluta. Quae et officiis consequatur nostrum eveniet cupiditate. Et magnam earum consequatur. Consequatur qui eos tempore.
Rerum ab eius recusandae et corrupti ut modi. Pariatur expedita perspiciatis assumenda enim ex exercitationem aut soluta. A doloremque consectetur odio est eum dignissimos. Quia et est enim omnis et reiciendis tenetur. Iusto ullam quae error laborum necessitatibus quia. Nesciunt expedita sed eos non. Voluptates dolorum eum nemo qui et laudantium repudiandae.
Placeat ex tenetur magni perspiciatis illo facilis iusto. Repellendus eius et explicabo quos iusto vel alias. Fuga doloremque possimus omnis sit tempora. Labore omnis et ducimus qui itaque.
Inventore neque quas sed odit. Sapiente facere sit consequatur non minima et culpa. Iusto sint temporibus veritatis illo eum autem quod.
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...