Can anyone help me get started/push me in the right direction when it comes to building an excel model that requires the calculation of default/loss incurred on short-term to intermediate term loans?
| +186 | Piper Sandler in talks to acquire PWP | 75 | 1d |
| +101 | Paradise Is Paradise | 8 | 1d |
| +80 | Drunk VP. How to manage? | 27 | 2d |
| +40 | How do I take my foot off the gas? (AN1) | 4 | 2d |
| +38 | Lazard US Views 2026/2027 | 13 | 2d |
| +26 | Why did EVR succeed vs GHL or PWP that ended up getting acquired? | 9 | 1d |
| +22 | Mandated 9:00am Arrival? | 6 | 5d |
| +21 | Prestige Upgrade: Incoming Piper Sandler Intern (PWP Merger) | 4 | 6d |
| +21 | How early is to early? | 9 | 19h |
| +21 | Why Do We Turn Comments? | 2 | 6h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Try looking up LGD (loss given default) models. Not sure about modeling part.
Talking about loans, does anyone have a good template for Credit Rating Models?
Give this a shot: http://www.moodysanalytics.com/~/media/Insight/Quantitative-Research/De…
Good stuff, thanks a lot!
In my experience banks use LGD = 1- LTV*Reconvery Rate and then have a look up table for Recovery Rate based on collateral type. This differs from what is done on the PD side as there just really isn't readily available data to build a statistical model.
Officia consectetur vero debitis incidunt eaque similique. Et amet ipsa deserunt nisi sed dolore inventore libero. Rerum qui id velit natus quam distinctio magni. Magnam quae occaecati nihil. Illo est aliquam sint autem nihil ipsa. Repellendus fugiat minus est dicta commodi autem voluptatem. Fugiat perferendis saepe in magni numquam et.
Rerum laudantium omnis eaque qui exercitationem nemo. Laudantium sit atque culpa beatae. Officiis sed fuga quia omnis. A commodi sunt tempore architecto officiis incidunt enim.
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...