I’m a VP in credit risk. I’m now in an interview process on the buyside, principal investment, solar renewables. It’ll be an internal sideways move for me, so i know their people, and they know my people.
Cleared the first round which was a 45 min chat with the VP. He seems pretty good.
Now they want me to do an excel modeling test for 1hr. My excel is a bit rusty.
I asked him what the test would be on and he said it’s not a 15 tab model, only a short form, which is suspect will mean 3-4 tabs. He’s deleted some of the formula on interest calc, IRR, inflation adjustments which need to be completed. It’s probably going to harder than he lets on.
Anyway, any tips for preparing? I would much rather be way over prepared than slightly under. And i’m will to put in a good 3-5 days worth of effort into this.
Also, i should add, my corp finance is rusty as f u ck, and i’m not used to analyzing corporate, or projects. I’m a FIG banker.