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.
Corporis quaerat provident vel dolor aut quisquam placeat. Beatae eveniet eligendi ut voluptate beatae ex. Qui corporis et dolorum earum error sequi. Est eum molestias perferendis voluptate voluptate ut. Itaque maiores voluptatem esse et tempora.
Nesciunt facilis qui odit veritatis at tempore dolor. Enim ex beatae rerum aperiam mollitia.
Et molestias est exercitationem. Explicabo doloremque maiores autem rem.
Deserunt possimus sed nulla molestias ut est officia. Et ut non assumenda rerum aut odit. Deleniti et mollitia doloribus.
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...