Modeling Test - Big 4 Infra?

Hi all,

 

I am late stages in an interview process with a big 4 Infrastructure Advisory team and the interviewer mentioned the next stage will be a 2 hour modelling test then an interview to discuss the analysis/recommendations.

 

I am from Australia and the interviews so far have not been in person due to the COVID environment would anyone have ideas on what to expect here? They do a lot of renewable energy deals (solar, hydro) so I have been looking at some examples but I am curious given the 2 hour time frame what would be expected?

 

I am imagining modelling a 20-30 year contract based on the $mw/h with debt sizing, debt metrics, and a sensitivity analysis  - perhaps a cash waterfall?

 

Any ideas? Thanks!

Comments (13)

 
Nov 1, 2020 - 6:54pm

Bump, very interested to know as well

Quant (ˈkwänt) n: An expert, someone who knows more and more about less and less until they know everything about nothing.

 
Nov 2, 2020 - 12:12am

Yes, your guess is correct. I wouldn't necessarily say macro/VBA or sensitivity is included in a 2-hour modeling test though. Could be just a normal DCF, unless you previously have infra/renewable experience. 

If the infrastructure advisory group is with EY, take it if you get it. Deloitte and KPMG's infra advisory groups are...okay. PwC no.  

 
Nov 2, 2020 - 3:38am

Thanks for replying. Interesting comment about the ranking of the big 4. 

I've read differently about the groups, maybe that's cause it's based in Australia?

Either way I'm pretty pumped, i've been going through Edward Bomer's courses and they seem pretty in-depth but would you have any recommendations or materials to help prepare?

 
Nov 2, 2020 - 4:29am

It is for a Senior Consultant/Manager role and I have some background in Infrastructure but haven't had exposure to renewables. 

 

Thanks for that website it looks great! I will go through that course this week. 

Start Discussion

Popular Content See all

Life Hacks during WFH | How do you avoid burnout?
+52IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A
Leaked EY Email
+49IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
I’ll never take WSO for granted again
+41OFFby Principal in Venture Capital">Principal in VC
What's so good about Evercore?
+29IBby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
Have any 1st year analysts actually quit?
+27IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A

Total Avg Compensation

January 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (30) $350
  • Associates (139) $232
  • 3rd+ Year Analyst (18) $155
  • 2nd Year Analyst (84) $153
  • Intern/Summer Associate (89) $144
  • 1st Year Analyst (344) $134
  • Intern/Summer Analyst (297) $83

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Secyh62's picture
Secyh62
98.3
3
Jamoldo's picture
Jamoldo
98.3
4
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.7
6
frgna's picture
frgna
97.6
7
Addinator's picture
Addinator
97.5
8
Edifice's picture
Edifice
97.5
9
bolo up's picture
bolo up
97.5
10
NuckFuts's picture
NuckFuts
97.5