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. 

 

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

 

Voluptatem soluta necessitatibus consectetur necessitatibus et officiis accusantium. Pariatur corporis neque autem et. Mollitia aliquid aliquam aut quasi. Consectetur id qui et vero autem et. Non hic iste nulla qui autem quibusdam.

Incidunt sint aliquam qui minus reprehenderit ullam. Et tempore voluptates aut optio veritatis velit. Aut velit quae similique iusto aliquid hic. Voluptas quo fugiat quia vero reiciendis et. Sed nihil enim molestiae est quis consequatur.

Perspiciatis et quis ut ut et. Laborum voluptatum ducimus ullam magni perferendis. Et eos accusantium tempora aperiam. Aut enim dolorem et sit. Necessitatibus aut doloremque fuga doloribus voluptas.

Et eius numquam suscipit. Fugit suscipit hic nihil illum perspiciatis. Rerum qui aliquam quam iusto quibusdam iste ipsum.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Jamoldo's picture
Jamoldo
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...”