Löffler Gunter, Posch Peter N. Credit Risk Modeling using Excel and VBA

Wiley, 2007. — 277 p. — ISBN: 0470031573, 9780470031575.In today's increasingly competitive financial world, successful risk management, portfolio management, and financial structuring demand more than up-to-date financial know-how. They also call for quantitative expertise, including the ability to effectively apply mathematical modeling tools and techniques, in this case credit.
Credit Risk Modeling using Excel and VBA with DVD provides practitioners with a hands on introduction to credit risk modeling. Instead of just presenting analytical methods it shows how to implement them using Excel and VBA, in addition to a detailed description in the text a DVD guides readers step by step through the implementation. The authors begin by showing how to use option theoretic and statistical models to estimate a borrowers default risk. The second half of the book is devoted to credit portfolio risk. The authors guide readers through the implementation of a credit risk model, show how portfolio models can be validated or used to access structured credit products like CDO’s. The final chapters address modeling issues associated with the new Basel Accord.Attached xls-files with examples of models.Estimating Credit Scores with Logit.
The Structural Approach to Default Prediction and Valuation.
Transition Matrices.
Prediction of Default and Transition Rates.
Modeling and Estimating Default Correlations with the Asset Value Approach.
Measuring Credit Portfolio Risk with the Asset Value Approach.
alidation of Rating Systems.
alidation of Credit Portfolio Models.
Risk-Neutral Default Probabilities and Credit Default Swaps.
Risk Analysis of Structured Credit: CDOs and First-to-Default Swaps.
Basel II and Internal Ratings.
Appendix A1 Visual Basics for Applications (VBA).
Appendix A2 Solver.
Appendix A3 Maximum Likelihood Estimation and Newton’s Method.
Appendix A4 Testing and Goodness of Fit.
Appendix A5 User-Defined Functions.