Credit Risk Modeling using Excel and VBA

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.

In today's increasingly competitive financial world, successfulrisk management, portfolio management, and financial structuringdemand more than up-to-date financial know-how. They also call forquantitative expertise, including the ability to effectively applymathematical modeling tools and techniques, in this case credit.Credit Risk Modeling using Excel and VBA with DVDprovides practitioners with a hands on introduction to credit riskmodeling. Instead of just presenting analytical methods itshows how to implement them using Excel and VBA, in addition to adetailed description in the text a DVD guides readers step by stepthrough the implementation. The authors begin by showing howto use option theoretic and statistical models to estimate aborrowers default risk. The second half of the book isdevoted to credit portfolio risk. The authors guide readersthrough the implementation of a credit risk model, show howportfolio models can be validated or used to access structuredcredit products like CDO's. The final chapters addressmodeling issues associated with the new Basel Accord.