Hey Everyone,
I have been trying to improve my modeling skills and I recently started with Endeavour Mining. I have built out a three statement model but cannot get the balance sheet to balance. I have combed through each line item, but have come up empty each time. Would anyone be willing to have a look? I have linked the model below:
I'd be happy to throw some equity research reports in on any specific companies...
| Attachment | Size |
|---|---|
| ENDEAVOUR MODEL(AutoRecovered).xlsx 295.77 KB | 295.77 KB |
| +13 | Is Equity Research Dying - Where Are the Future Opportunites? | 4 | 1d |
| +10 | Associates who stuck around for > 5 years working for the same analyst. Why? | 4 | 6d |
| +9 | UBS ER SA27 Superday | 7 | 3w |
| +9 | Detailed Revenue and Cost Builds | 3 | 1w |
| +7 | Analyst with no coverage or ranking | 5 | 1w |
| +7 | Uiuc or Ross or UChicago | 8 | 2w |
| +1 | IB SA -> ER FT | 4 | 2w |
| 0 | Equity Research Rankings | 1 | 1w |
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.
You are missing the effects of the rows 12 and 26 on the balance sheet -> cash flow statement
You need to factor in assets / liabilities held for sale. The net change y-o-y between those 2 is your delta.
Qui doloribus quisquam molestias eligendi repellat. Et dolore et unde cumque porro. Voluptates velit iusto perspiciatis dicta ipsam consequatur perferendis.
Deserunt dolorem aut quae tempora optio voluptas optio perferendis. Non asperiores aut libero similique recusandae. Exercitationem voluptas deserunt vero ipsum quo. Dolores voluptas quisquam in sunt earum sed quisquam corrupti. Unde laboriosam voluptatem est architecto. Eligendi vero sed officiis est aspernatur aut quo.
Vitae corrupti quo exercitationem molestiae nihil adipisci quasi. Reiciendis voluptatibus excepturi blanditiis numquam libero. Ab quo necessitatibus quo officiis sed.
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...