So, I just had a second round interview for a research associate role and then was given a modeling test. I was told to fix three errors in the forecasting period of the IS. At first glance I see four errors in the forecasting periods for Gross Profit as it does not incorporate all 4Qs in FY 2016. Seems too easy that I must be missing something.
| Attachment | Size |
|---|---|
| copy_of_val_w_3_errors.xls 1.14 MB | 1.14 MB |
| +81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 5d | |
| +32 | How the heck do you learn all of this stuff? | 10 | 4h | |
| +28 | Getting Frustrated | 10 | 4w | |
| +28 | My experience on the sell side | 20 | 2w | |
| +24 | Clues in Financial Reporting Analysis | 7 | 1d | |
| +17 | Am i fairly compensated? | 9 | 2d | |
| +14 | Data Science to PM | 8 | 1w | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
| +12 | ER - Remote Jobs? | 8 | 5d | |
| Equity Research at Bank vs IG, High Yield & Leveraged Loans Research at Asset Manager | 4 | 21h |
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.
What bank was this for?
MM Bank
i will pm you the model with comments ... then you can upload that if you want.. I did not bother to go through the schedules but it is just not the way I would have made the model, i hope this is not the way they actually make the models
Could you also PM me please? thanks
What are some of the changes you would make to the model to have it fit more in line with what you would make? Or would you just make it in a completely different way?
completely different
I identified two errors and was able to make the #VALUE! error dissapear, the model seems to be working OK. However, could you also pm me just for me to check my solving and find out the third error?
Hi, Qureshi,
Could you please Dm me the model ?
Thanks
Hi, Qureshi,
Could you please Dm me the model as well. I'd love to see if my output matches yours
Thanks!
Qureshi Could you also PM me? Thank you!
Looks like this RBC, Next time don't publish your model TEST on internet
just update your post with the edited model and the comments in a word doc it will be easier for others
Also interested. Could you pm me aswell? Thankkyou
Qureshi - mind PM'ing me as well? Thank you.
Interested as well, Can you pm updated model. thanks
Could you please me the updated model as well? Thank you!
anyone who wants me to PM the model corrections ask IronCondorGorilla it his/her to give, first try to solve it on your own and if you have something you need some help with, I will give you a few hints, solving it on your own will give you practice
Hi guys. Can someone help me with this? I fixed the few things in the IS but more importantly how do I fix the circularity?
Thx in advance!!!!
Can someone pm me the solution? Just want to double check. Thanks
Repudiandae a aut odio modi officia. Fugit quam repellendus enim accusantium. Quae atque error non veniam. Autem ipsa in magnam non deleniti. Quo nulla necessitatibus ipsum quod assumenda ex dolor numquam. Cumque temporibus officia omnis ut.
Ut autem nesciunt aperiam unde repellat eveniet. Cupiditate veniam excepturi dolor. Sunt et quisquam dolorem aut ut exercitationem autem.
Ab aut vitae aut iste natus. Labore nihil at sint fugit odio.
Cum reiciendis placeat ducimus sit est expedita. Quasi laboriosam omnis molestiae quos quas qui. Amet et non et veritatis inventore assumenda rem. Ipsum laborum dolore qui voluptatem.
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...
Sunt ipsa quaerat earum enim et. Numquam quia eius voluptatem id repellendus quas. Magnam repellendus perspiciatis voluptatem voluptatem aut deleniti.
Libero consequatur esse nam vel excepturi et ullam et. Recusandae perspiciatis veritatis quia perspiciatis impedit facilis nihil. Minima est esse dolores molestias exercitationem explicabo nemo. Consequatur voluptas velit quod voluptas dolor quas soluta.