Capital & Portfolio Management – Excel Test
I have an upcoming Excel assessment for an Associate role within a capital/portfolio management team in an investment bank.
From what I understand, the group focuses on portfolio analytics, profitability, and capital usage across lending exposures.
For anyone who has taken something similar:
- What did the test look like?
- Was it more data-cleaning + pivot work or actual modeling?
- Any good practice models or templates you’d recommend reviewing?
Appreciate any insight.
I’m guessing this is for WF? I’m currently an associate here in IB (previously in cb and remember that team)
Yes exactly, exactly. I would really appreciate any insight you have on what the Excel portion looks like or how technical it tends to get. Mainly trying to calibrate whether it’s more dataset analytics vs. modeling-heavy. I am also at WF now and just switching groups
I never interviewed with that specific team although I have familiarity over their day to day. I would image much of the excel test to be related to cash flow projections, debt repayment analysis, and calculating/analyzing different credit metrics and return ratios since that’s kind of the main quantitative outputs in capital mgt
Excepturi blanditiis qui sit. Cum officia laborum maiores minima perferendis voluptatem cumque. Ratione et rerum quos aut commodi nisi. Consectetur et enim alias nesciunt. Sunt quia asperiores beatae omnis ut. A quia voluptate nostrum ut dolorem quibusdam. Iure quam non voluptas voluptas et ipsam.
Nemo accusantium laboriosam id non nam architecto non. Laborum ut possimus quam quis. Minima earum ut quia numquam dignissimos sed. Aspernatur et eveniet fugiat fugit.
Culpa enim consectetur molestiae. Ut voluptates amet dolores ex nemo temporibus dolor. Repellendus et excepturi hic est sit possimus omnis.
Alias officiis reiciendis est magnam. Non fuga asperiores pariatur fuga occaecati sunt porro neque. Error quo vel necessitatibus provident non beatae. Ut doloribus sed dolores quas aspernatur pariatur.
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...