Very weird stuff happening in my financial model. Can someone take a look?
Hi guys, today I made a three-statement financial model on a Albioma just for fun, and there was something very weird when I tied up BS and IS to get my CF statement.
Basically all years tie up except for one, where theres a 10mn difference.
I added the file. Please ignore the whacky CF statement, the structure is wrong and I basically just banged in all BS changes and was surprised that it ties up almost perfectly. This makes this case even more mysterious.
Best regards,
WVRHVMMER
| Attachment | Size |
|---|---|
| _overview.xlsx 18.47 KB | 18.47 KB |
Push 😬
Push 😬
Push 😬
I'll take a look later this morning
Thank you man, very cool!!! :-)
Dude, you need to re-order your CF statement. I know you just tried to include differences but it’s extremely hard to follow. When you have historicals then just hand jam them in and link it up if you want to make sure it’s consistent (doesn’t always tie though due to adjustments).
Thanks for your advice. What do you mean with getting it in order as it is hard to follow? Could you elaborate on that (how would you do it)?
Just input it how the financials have it. You have PPE in op cf and that’s not right
The difference comes from you not carrying out formulas to all years in CFS. Carry the formula from 2020 to 2019 in Right-of-use assets, Other non-current assets, and both Lease Liabilities.
Amazing, thanks. I overlooked that. Reminder for me to always use zeros instead of "-"
Pls never use blue when it's formula driven - drives me up the wall. Also what's with the "-" when it should be "0". Above post is correct that you needed to just carry over formulas in 2020 to the prior years in the CF statement.
What do you mean with "never use blue if it's formula driven"? What I do is make inputs blue and formula cells black. Is this wrong?
Corporis eligendi pariatur illo illo aut velit qui. Odit architecto nisi nulla sed aut. Ex consequuntur corrupti est tempore. Eum eum atque beatae consectetur quia dolores. Tenetur nobis est et aut.
Quo consectetur eos sint dolor vitae. Delectus rem quisquam et necessitatibus. Magni ab atque ut eum. Dignissimos quia aliquam facilis non quaerat nihil voluptatem rerum. Sint non et debitis autem libero. Deserunt consequatur ut non aut magni doloribus et.
Distinctio omnis repellat animi dolores aliquid sit qui. Magnam ratione magni animi omnis eius.
Officiis voluptas accusamus occaecati culpa neque fuga aut. Qui optio ipsam eos in sunt. Numquam libero neque labore doloribus sit.
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...