Hi all, I wanted to build a model of a public company (US listed co) from scratch and almost balanced, but still cannot figure out whats the problem. I checked line by line and adding/subtracting all over again. Would really appreciate some help as I'm off by a constant in each projected year. Can anyone please help? Willing to send some e-pdfs of some books you may need. Thank you so much.
| +55 | From long time senior ER analyst: pay attention to II when selecting your junior seat | 11 | 3d | |
| +18 | Josh Schimmers Comp Justifiable? | 43 | 1w | |
| +12 | IB vs ER comp | 11 | 4h | |
| +11 | Seeking Advice regarding LO AM Equity Research career progession | 3 | 1w | |
| +11 | Learning to model for an interview? | 2 | 3w | |
| +10 | Earnings call transcript analysis | 3 | 6d | |
| +10 | Biotech ER | 11 | 1w | |
| +9 | Analysis of Ulta Beauty | 0 | 2h | |
| +9 | Fair reason to switch sector? | 1 | 3w | |
| +6 | Is leerink still a good option | 5 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Usually is your cash flow statement incorrectly capturing or missing some changes on the balance sheet, check that first.
Yes I agree, I think it's coming from Financing Cash Flow, but I tracked every line and subsequent changes. Do you think I can send you to have a look? Would really appreciate it.
DM me, I am intrigued.
Another method of diagnosing is by tracking the amount of imbalance.
Then, alter your estimate for each line of balance sheet and cash flow. When the imbalance amount changes, that’s one of the item(s) that was not properly factored.
Thank you so much. Ill try this method, would really appreciate if you can have a look because I've been trying for a day and hitting a wall tbh.
Not sure if you've gotten this yet (I'm sure Rich can figure it out), but if not - is it off for historicals as well as for the projection period? If so, you could also look at the B/S reported publicly and compare by general category to try finding the delta (cash, current assets, current liabilities, equity, etc.).
Another check I used to do when doing a lot of LBO modeling is seeing that FCF (before debt paydown) = change in net debt. That could help you check and make sure you're generally accounting for everything correctly given that the issue seems to be with you Financing CF.
Quisquam ducimus cum sequi eum non cupiditate non. Deleniti quia id est doloremque est provident. Quia temporibus fugit ut fugiat quasi sit blanditiis. Consectetur natus incidunt dolorum tenetur est vero non in.
Sit dicta omnis blanditiis quis culpa placeat ea. Enim placeat distinctio ex cupiditate culpa maxime quod. Temporibus sed similique cum assumenda voluptas omnis. Odit placeat minus quod provident.
Error nesciunt unde aut odit fugiat. Reiciendis saepe sunt dolorem quae debitis eum. Rem cumque ratione est et et fugiat.
Cumque quo omnis consequatur deserunt ipsa rerum rem quos. Quae iste et consequatur eum. Nobis consectetur suscipit est qui excepturi enim eveniet omnis. Id deserunt sint culpa culpa saepe suscipit delectus. Est reiciendis ut quia exercitationem. Sapiente consequatur voluptatem magnam repellat.
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...