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.
Magni eos aut quia ipsa ipsam. Iste nisi quos blanditiis sit. Et eum et et nostrum qui tenetur. Eos rerum consequatur sunt dolore odit numquam enim alias. Omnis est magnam amet et. Dolorum labore sit iste nostrum.
Excepturi commodi magnam ipsam magni dolor et. Voluptatem quod temporibus id non repellat vel quos. Nam et explicabo reprehenderit placeat dolor porro. Delectus quo quia et laborum qui molestias totam. Doloribus qui quis incidunt adipisci. Vel voluptatem voluptatem consequatur.
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...