Research and Markets: Credit Risk Modeling using Excel and VBA, 2nd Edition
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 thesr methods into practice."
Richard Cantor , Chief Credit Officer, Moody's Investor Service
Key Topics Covered:
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.
For more information visit http://www.researchandmarkets.com/research/58b446/credit_risk_modeli
[email protected]
U.S. Fax: 646-607-1907
Fax (outside U.S.): +353-1-481-1716
Source:



Discover Bank Receives Bankrate.com™ Highest Rating for Financial Strength and Stability
Advisor News
- What’s behind private equity investment in insurance brokerages
- Advisors get a win as NJ Senate passes independent contractor bill
- Why federal retirement benefits are more complex than advisors realize
- Why timing the market is still a retirement mistake and what to do instead
- Business owners may be overlooking a key part of their financial picture
More Advisor NewsAnnuity News
- Best’s Special Report: U.S. Life/Annuity Industry Sees Bottom-Line Growth Despite 18% Decline in Total Income in First-Quarter 2026
- Globe Life Inc. (NYSE: GL) Records 52-Week High Thursday Morning
- Fortitude Re Completes $500 Million FABN Issuance
- Reframing retirement income for greater certainty
- Jackson Introduces Dow Jones Industrial Average Index Option, Flexible Premiums, Six-Year Rate Guarantee in Latest Registered Index-Linked Annuity Launch
More Annuity NewsHealth/Employee Benefits News
- California is getting ready to increase a health insurance tax. Will it affect your premium?
- Report: Rural Virginia hospitals at risk of closure
- JasonRhodesnamed to Shelbyville CityCouncil
- Getting disability benefits got harder after the Social Security Administration changes
- Capitol Beat: Scott's veto signatures piling up
More Health/Employee Benefits NewsLife Insurance News
- OVER $107 MILLION IN LIFE INSURANCE BENEFITS LOCATED FOR TENNESSEANS IN 2025 THROUGH NAIC'S LIFE INSURANCE POLICY LOCATOR SERVICE
- Maryland Heights man pleads guilty in murder-for-hire death of his mom
- AM Best Affirms Credit Ratings of Everlake Life Group Members
- Industry experts warn NAIC: Fix flawed IUL illustrations now
- InsuranceAUM.com Celebrates a Historic 5th Annual Insurance Investment Executives’ Meeting in Chicago, Honoring Outstanding Industry Leaders and Spotlighting Next Event in Austin
More Life Insurance News