Asset-Backed Finance Collateral Modeling
Does anyone know where I can find collateral models for consumer assets like personal loans, credit cards, etc.? Trying to understand how to model some of this collateral so any direction here would be helpful.
I did a few last summer as an intern
Pretty much from what I remember for mortgage backed securities, you get the loan book and manually calculate the figures in excel
You would first screen the data with summaries and check if there are any gaps or unexplainable figures that the client needs to resolve
Then you calculate the WA metrics for each portfolio
Summarise the data and graph them accordingly
If it's a single asset or a portfolio, I think you were able to model their individual / combined cash flows to a point (don't think it was the same for MBS)
Based on the most helpful WSO content, while there isn't a direct mention of specific collateral models for consumer assets like personal loans or credit cards, you might find value in exploring the WSO Free Modeling Series. This series includes lessons taught by experienced private equity professionals and investment bankers, covering financial statement modeling, DCF, M&A, LBO, and Comps. Additionally, it offers 27 financial modeling templates in a swipe file, which could potentially include relevant frameworks or be adapted for your needs.
If you're looking for more specialized resources, consider checking out materials like S&P's Leveraged Loan Primer or other primers on credit agreements, as these can provide insights into credit modeling and collateral evaluation. For a deeper dive into credit-focused modeling, Moyer's Distressed Debt Analysis is also a recommended resource, offering a perspective on credit through a structured lens.
You can access the WSO Free Modeling Series and templates by signing up through their platform.
Sources: Private Credit Resources and Prep, Question For the Credit Guys: When Is A Borrower Over levered?, Resources for learning about distressed debt investing, Credit research at an insurance firm, Non Recourse Loan - Guarantor Net Worth and Liquidity Requirements?
Tempore et consequuntur dolorem maxime dolores autem. Sequi eum corporis rerum praesentium rerum iure nemo. Inventore quas facilis quis voluptatem. Omnis iusto sit sunt nostrum dolor sit et perspiciatis.
Earum sed molestiae quidem aliquam. Molestiae modi deserunt nulla id qui. Voluptatem est in quae recusandae minima dolore at. Qui temporibus assumenda eaque vel. Voluptatibus officia voluptatem totam enim vel voluptatem qui. Occaecati praesentium et magni natus nisi.
Repellat id et eius error qui voluptatum. Quos quia repellat quia fugit. Pariatur iure temporibus aut ex voluptatem non assumenda. Qui repellendus quam quia et nulla reiciendis.
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...