Have a modeling test coming up with CRC IB for an Analyst position, anyone have advice on how to prep?
I've been practicing by building different solar or renewable models, any further advice would be super super helpful
| +234 | Downfall of Qatalyst | 45 | 16h |
| +176 | UBS IB 26Q2 a Disaster! Advisory Revenue Down 23%, Capital MarketsDown 5% | 25 | 3h |
| +117 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 1d |
| +82 | Lincoln International Return Offers | 42 | 2d |
| +62 | London IB BB is a challenge | 37 | 2h |
| +40 | SharePoint makes IB hours HELL | 15 | 7h |
| +39 | momentum of Rx groups | 12 | 15h |
| +37 | Fired during interview | 6 | 1d |
| +35 | VP Lifestyle at Top BB Coverage Groups | 20 | 5h |
| +35 | An Outsider’s View of RX Banking Out of College | 2 | 7h |
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.
Based on the most helpful WSO content, here are some detailed tips to help you prepare for your modeling test with CRC IB:
Focus on Industry-Specific Models:
Master Core Financial Models:
Practice Under Time Constraints:
Review Common Modeling Test Formats:
Brush Up on Excel Skills:
Understand Key Metrics and Ratios:
Review Past WSO Threads:
By focusing on these areas, you'll be well-prepared for your modeling test with CRC IB. Good luck!
Sources: How exactly should I prep for on-cycle?, please help Invited to Lateral On-Site Modeling Test. How To Prep for Op. Model/M&A/DCF?, Best HF Modeling / Case Study Prep, Investment Banking Lateral Analyst Modeling Test, Analyst lateral hiring MS - modeling test
I believe they use Pivotal180 for their training so I’d recommend using their models to review. A decent amount of their lessons are available free on YouTube. Make sure you understand how all assumptions play into a solar/wind model and how tax equity factors in to the whole thing.
Pm me
sent you a pm!
It depends which modeling test you refer to. They have two during their interview. One is to see how creatively you can use the excel to analyze the move of liquid between buckets and make a quick presentation on that with your quick findings. Another is to build solar/wind farm model.
Each test challenge you in different aspect. First one truly require some creativity and not that straight forward as it might seem. Second one, is not very complicated, but the major issue is time. You literally having 45 minutes to build a full model via zoom or in person. It is pretty stressfull and you have to be ready to build that model in a very short period of time and answers all questions in their case. Pivotal180 is helpful, but only to the degree to give you a general knowledge of how to approach. You need a lot of practice to achieve the timeline required. However need to give a disclaimer, I was doing it for Associate position, maybe analyst test is different, but likely same, maybe they just give little more time
Curious if they’d heavily test tax equity and efficient/non efficient tax payer, or simply stop at tax credit treatment. Thanks!
PM me. I can shed some light from my process with them
Hey I sent you a pm, would appreciate any insights
Hi I just PM you. Thank you!
i did this last year, quite non descript random problem they will design for you thats not finance related at all, for example, there are two airports with x number of flights landing, each airport has xyz capacity, flights take 1 hour to stall before departure etc, model the trafifc for the airport
Was this for SA?
How did it go?
Quam qui et quia et sapiente aspernatur qui cumque. Asperiores quo porro voluptate aut assumenda. Occaecati dolorem cumque aut neque possimus. Qui consequatur rem iure 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...