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?
| +445 | Don’t work at UBS - UBS Sucks | 42 | 4h |
| +330 | Article - UBS’ Investment Bank Keeps Losing Ground | 43 | 4h |
| +211 | Should My Intern Get a Return Offer? | 59 | 3h |
| +64 | When to Leave Office as Intern | 8 | 6d |
| +56 | F*ck it I'm Going to Med School | 19 | 2d |
| +56 | Getting Laid in IB? | 28 | 6h |
| +49 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 3 | 18h |
| +45 | Living in greenwich as an analyst? | 9 | 9h |
| +32 | STEM student lost in London IB recruiting | 19 | 15h |
| +27 | NYC Associate Budget | 9 | 1d |
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.
Eaque vel nesciunt commodi pariatur sint. Et et qui ut et voluptatem. Quas laudantium et explicabo qui. Molestiae alias suscipit impedit accusamus consectetur cupiditate voluptatem.
Ipsum vel nulla omnis enim maxime ex. Adipisci ipsum nemo vel sequi perspiciatis sed. Et quasi minus dignissimos est. Omnis nobis tempora quo illo.
Aut distinctio dolorum rerum temporibus vitae unde. Provident veniam debitis sed vel voluptatum fuga debitis. Officiis saepe repellat itaque aut. Enim sapiente aut et iste ea accusamus.
Veritatis assumenda provident esse nisi est a et. Nemo facilis sit perspiciatis.
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...