Excel Requirements for CLO Structuring-Analyst
Hi folks, I am going to have an interview 4 days later. I am wondering if someone can share some insights regarding to the excel skills required by CLO Structuring-Analyst role?
Many thanks 😊.
Hi folks, I am going to have an interview 4 days later. I am wondering if someone can share some insights regarding to the excel skills required by CLO Structuring-Analyst role?
Many thanks 😊.
Career Resources
I’m not in CLO structuring, but have done work in the CLO space in the past from what I’ve seen the modelling seems to involve looking at cash flows on each payment date over the life of the deal. It looked somewhat simple with maybe an XIRR function used to calculate equity distriubutions each payment date. Sometimes I saw people play around with things like goal seek to tweaking to see how changes in purchase price and WACD( weighted average cost of debt for CLO liabilities) affect final equity IRR and deciding whether deals make sense to print or not. I wish I could give more info, but I’ve forgotten a lot of the stuff since moving roles.
Beatae et provident voluptatem eos enim. Cupiditate dolores omnis amet deleniti sit.
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...