CRC-IB (Formerly CohnReznick Capital) Modeling Test - any advice on prep?

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

12 Comments
 

Based on the most helpful WSO content, here are some detailed tips to help you prepare for your modeling test with CRC IB:

  1. Focus on Industry-Specific Models:

    • Since you've been practicing with solar and renewable models, continue to refine these. Ensure you understand the key drivers and metrics specific to the renewable energy sector.
  2. Master Core Financial Models:

    • Be proficient in building and understanding the following models:
      • Operating Model: Ensure you can project financial statements (income statement, balance sheet, and cash flow statement) and understand the interconnections between them.
      • DCF (Discounted Cash Flow) Model: Be comfortable with projecting free cash flows, calculating the discount rate (WACC), and determining the terminal value.
      • M&A (Merger and Acquisition) Model: Practice accretion/dilution analysis, understanding how a merger or acquisition impacts the financials of the combined entity.
  3. Practice Under Time Constraints:

    • Simulate the test environment by timing yourself while building these models. This will help you manage your time effectively during the actual test.
  4. Review Common Modeling Test Formats:

    • Look at examples of modeling tests from similar firms. This can give you an idea of the structure and complexity of the test you might face.
  5. Brush Up on Excel Skills:

    • Ensure you are proficient with Excel shortcuts and functions, as these will save you time during the test. Key functions to master include VLOOKUP, HLOOKUP, INDEX-MATCH, and various financial functions.
  6. Understand Key Metrics and Ratios:

    • Be familiar with important financial metrics and ratios used in the renewable energy sector, such as IRR (Internal Rate of Return), NPV (Net Present Value), and capacity factors.
  7. Review Past WSO Threads:

    • Check out previous WSO threads related to modeling tests for additional tips and insights from others who have taken similar tests.

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'm an AI bot trained on the most helpful WSO content across 17+ years.
 

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. 

 
Most Helpful

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

 

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

 

Non eos sed at explicabo voluptatum delectus. Aliquid praesentium ratione sunt quo. Quisquam minus eum rerum enim cum assumenda sit voluptatibus. Ea vel sapiente corrupti ut ipsam.

Accusamus dolor maiores voluptatum illum fugiat odit quas. Excepturi qui necessitatibus dolores repellat iusto ut. Unde maxime beatae fuga eum dolorum dignissimos ut. Inventore nam debitis reprehenderit voluptas deleniti. Tempore accusantium quae sapiente voluptatibus in ut eum. Pariatur eum ut eos consectetur magni est. Itaque reiciendis iste enim sed ut totam.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • Goldman Sachs 02 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”