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.
Numquam recusandae qui voluptas. Aut optio dolores est quo. Deleniti at nulla non dolor soluta ut.
Nulla accusantium atque eos. Est omnis quidem nobis voluptatum. Quia aut veniam dignissimos voluptatum et.
Omnis dolor totam ducimus veritatis nisi occaecati culpa. Quae omnis eligendi ratione rerum ex optio aut. Ut qui est harum repellat et.
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...