4 hour modelling test - what should i expect?

Hi

I have a 4 hour financial modelling test for a company that does infrastructure deals and projects. 
 

What should I expect? It’s nerve wrecking. DCF? LBO

I cannot imagine either being 4 hours… My experience also doesn’t require me to do anything beyond simple DCF. Any help is strongly appreciated. 

5 Comments
 

For a 4-hour financial modeling test focused on infrastructure deals and projects, you can anticipate a comprehensive examination of your ability to construct and analyze financial models that are pertinent to the infrastructure sector. Based on the WSO Dataset, here's a breakdown of what you might expect:

  1. Traditional LBO Modeling: Even though the focus is on infrastructure, some firms might still assess your skills through a traditional LBO model. This could involve building a 3-statement LBO model and possibly preparing a PowerPoint deck to present your findings. Given the time frame, this test would likely assess not only your technical skills but also your time management and prioritization abilities.

  2. Infrastructure-Specific Modeling: More relevant to the sector, you might be tasked with creating a model that reflects the unique aspects of infrastructure investments. This could include:

    • Construction Stage Infrastructure Model: A short-form model focusing on the construction phase of an infrastructure project. This might involve forecasting costs, funding sources, and the timeline of the construction phase.
    • Project Finance / Infrastructure Modeling: Given the sector, there's a high likelihood of a test involving project finance or infrastructure-specific modeling. This could encompass analyzing cash flows, debt structures, and the economic viability of infrastructure projects. Ed Bodmer's resources on project finance and infrastructure modeling could be invaluable for preparation.
  3. DCF Modeling: While you mentioned your experience with simple DCF models, the test might require a more complex DCF analysis tailored to infrastructure projects. This could involve detailed projections of cash flows, considering the long-term nature and regulatory environment of infrastructure projects.

Preparation Tips: - Review Basic Concepts: Ensure you're comfortable with the basics of DCF and LBO modeling. Understanding the core principles will help you adapt to more complex or sector-specific models. - Practice with Sector-Specific Models: If possible, practice building or analyzing models that are specific to the infrastructure sector. Pay special attention to how these models handle long-term projects, government regulations, and funding structures. - Time Management: Given the 4-hour limit, practice managing your time effectively. Break down the test into manageable sections and allocate time accordingly. - Utilize Resources: Explore resources like Ed Bodmer's project finance exercises to familiarize yourself with infrastructure modeling. Additionally, reviewing guides and threads on WSO related to LBO and infrastructure modeling can provide insights and tips.

Remember, the goal of such a test is not only to assess your current modeling skills but also to gauge your ability to learn, adapt, and apply financial concepts to real-world scenarios in the infrastructure sector.

Sources: Interviewing For Infrastructure Investment Roles, Preparation for 2 hour LBO modelling test, Interviewing For Infrastructure Investment Roles, 2-hour Modeling Test for HF (Fundemental Equities) - What to expect?, How would you approach a 4 hour case study?

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Most Helpful

Assuming this is for an M&A role at bank - infra tests even at senior analyst level are extremely detailed and will require you to model most if not all of the following concepts:

  • Contracted/uncontracted revenue (need to understand how PPAs work and pricing/volume mechanism)
  • Variable/fixed costs 
  • CFADS
  • Debt sculpting and debt sizing 
  • Different tranches of debt, each with different characteristics (hedged, floating etc..) 
  • Equity value and returns analysis 

Basically, if this is a for an M&A role, infra models are never just a simple 3-statement model with LBO/DCF

 

Error officia corrupti sequi. Voluptate incidunt voluptate aut iusto eligendi culpa ipsum. Illum consequuntur tempora fugit similique vel distinctio ex.

Odit in exercitationem doloribus sapiente voluptate molestias aut. Modi vero in libero magnam et aliquam et.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • 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.8%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 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 (78) $151
  • Intern/Summer Analyst (72) $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

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
CompBanker's picture
CompBanker
98.9
10
numi's picture
numi
98.8
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...”