Research and Markets: Credit Risk Modeling using Excel and VBA: 2nd Edition Includes New Coverage of the Important Issue of How Parameter Uncertainty Can Be Dealt With
This book provides practitioners and students with a hands-on introduction to modern credit risk modeling. The authors begin each chapter with an accessible presentation of a given methodology, before providing a step-by-step guide to implementation methods in Excel and Visual Basic for Applications (VBA). The book covers default probability estimation (scoring, structural models, and transition matrices), correlation and portfolio analysis, validation, as well as credit default swaps and structured finance. Several appendices and videos increase ease of access.
The second edition includes new coverage of the important issue of how parameter uncertainty can be dealt with in the estimation of portfolio risk, as well as comprehensive new sections on the pricing of CFSs and CDOs, and a chapter on predicting borrower-specific loss given default with regression models. In all, the authors present a host of applications - many of which go beyond standard Excel or VBA usages, for example, how to estimate logit models with maximum likelihood, or how to quickly conduct large-scale
Clearly written with a multitude of practical examples, the new edition of Credit Risk Modeling using Excel and VBA will prove an indispensable resource for anyone working in, studying or researching this important field.
Praise for the first edition
In one place, Lffler and Posch provide all that is needed to install a state-of-the-art risk management system, including a broad understanding of different risk management frameworks, detailed estimation techniques for dertiving PD, LGD, and correlation parameters, and programming tools for putting these methods into practice. -
Key Topics Covered:
- Preface to the 2nd edition.
- Preface to the 1st edition.
- Some Hints for Troubleshooting.
- 1 Estimating Credit Scores with Logit.
- 2 The Structural Approach to Default Prediction and Valuation.
- 3 Transition Matrices.
- 4 Prediction of Default and Transition Rates.
- 5 Prediction of Loss Given Default.
- 6 Modeling and Estimating Default Correlations with the Asset Value Approach.
- 7 Measuring Credit Portfolio Risk with the Asset Value Approach.
- 8 Validation of Rating Systems.
- 9 Validation of Credit Portfolio Models.
- 10 Credit Default Swaps and Risk-Neutral Default Probabilities.
- 11 Risk Analysis and Pricing of Structured Credit: CDOs and First-to-Default Swaps.
- 12 Basel II and Internal Ratings.
Author:
Gunter Lffler is Professor of Finance at the
For more information visit http://www.researchandmarkets.com/research/c1df0f/credit_risk_modeli
[email protected]
U.S. Fax: 646-607-1907
Fax (outside U.S.): +353-1-481-1716
Source:



Advisor News
- SEC in ‘active and detailed’ settlement talks with accused scammer Tai Lopez
- Sketching out the golden years: new book tries to make retirement planning fun
- Most women say they are their household’s CFO, Allianz Life survey finds
- MassMutual reports strong 2025 results
- The silent retirement savings killer: Bridging the Medicare gap
More Advisor NewsAnnuity News
- Advising clients wanting to retire early: how annuities can bridge the gap
- F&G joins Voya’s annuity platform
- Regulators ponder how to tamp down annuity illustrations as high as 27%
- Annual annuity reviews: leverage them to keep clients engaged
- Symetra Enhances Fixed Indexed Annuities, Introduces New Franklin Large Cap Value 15% ER Index
More Annuity NewsHealth/Employee Benefits News
- Pan-American Life Insurance Group Reports Record 2025 Results; Premiums Reached $1.86 Billion and Net Income Totaled $110 Million as Company Enters Its 115th Year
- LightSpun and Smile America Partners Announce Partnership to Accelerate Dental Provider Enrollment to Expand Treatment for 500K Underserved Kids
- Lawmakers try again to change ‘reflection in the mirror’ for cancer patients
- IF FINALIZED, PROPOSED CHANGES TO MEDICARE ADVANTAGE AND MEDICARE PART D WOULD IMPACT SENIORS' COVERAGE AND CARE IN 2027
- ASSEMBLYMEMBER WILSON INTRODUCES LEGISLATION TO PROTECT CALIFORNIANS FROM GENETIC AND BIOMARKER DISCRIMINATION IN INSURANCE
More Health/Employee Benefits NewsLife Insurance News
- National Life Group Ranked Second by The Wall Street Journal in Best Whole Life Insurance Companies of 2026
- Majority of Women Now Are the Chief Financial Officer of Their Household, Allianz Life Study Finds
- Most women say they are their household’s CFO, Allianz Life survey finds
- MassMutual Delivers Excellent 2025 Financial Results
- ACORE CAPITAL Named Alternative Lender of the Year ($15 Billion + AUM) by PERE Credit
More Life Insurance News