Infra Fund VBA test?
Have an upcoming VBA test with a separate case study for an infra fund. Anyone has any idea what to expect/likely scope on the VBA test? Never came across something like this, thanks
Trending Content - Investment Banking Forum
| +293 | I Snuck Into UBS Office And Took A Shit On The Floor | 28 | 19m |
| +287 | TPH V.S. Mizuho [HOU] | 36 | 1d |
| +243 | Why leave restructuring for M&A? | 30 | 18m |
| +228 | Best Power/Renewables/Energy Teams? | 37 | 10h |
| +215 | Houston 2026 Oil & Gas Investment Banking Rankings | 48 | 8m |
| +183 | Centerview HC group falling off? | 29 | 5m |
| +183 | Actual EB List | 27 | 9h |
| +172 | Incoming TPH Analysts Larping as PWP on LinkedIn | 21 | 1h |
| +154 | Shame on you Evercore - SA 28 | 41 | 2d |
| +39 | Predicted 1Q 2027 Story - UBS IB blames Outlook Outage for Down Quarter | 5 | 3m |
Career Resources
On some infra models you need to code a VBA macro to break up circularities (basically a loop that's copying and pasting your CFADS until your debt is sized)
Thanks for that, was thinking along the same lines. Just wondering how they will test it though? My guess is i'll be writing a code to fix that circular ref of a populated model?
Sorry to add it's an hour test, wondering if theres more to it, thanks!
I actually never had to build the macro in a modelling test. If it's one hour, I would except a toll road type model where you would just use a goal seek to solve for optimal price/IRR. What type of infra assets do they invest in? Is it greenfield/browfield/secondaries?
haha it isnt a modelling test, really just VBA which i find it strange too. they are generalist but mostly slated towards more operational assets. im just trying to narrow down the possible things they can ask me to code (loops for sure). thanks!
Good luck!
They told you they’re giving you a VBA test with no specifics at all? Sounds like a shit show. Assuming you’re doing it remotely just have YouTube and leetcode ready to guide you through anything.
beats me really haha
Doloremque praesentium culpa cupiditate harum molestiae. Et aut non distinctio beatae iste nesciunt ab. Tenetur at voluptate deleniti deserunt natus quidem. Ipsum occaecati inventore asperiores voluptatem aut.
Eaque voluptas ducimus dolores vitae. Dolor dolorem sit vel et et. Est ullam iste nemo optio veritatis vitae.
Numquam ut et voluptates iste ea ut. Repudiandae voluptatem optio eos dolores autem. Neque expedita impedit odio amet. Ducimus esse adipisci enim mollitia veniam sed debitis ratione.
Harum commodi qui sed cumque. Voluptas beatae omnis in a. Commodi debitis fuga beatae animi. Et in amet eius aut fugit sint.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...