Spreadsheet Applications

MARTINGALE PROBABILITIES OF DEFAULT

Model Description:

A spreadsheet that demonstrates risk-neutral default probabilities when pricing bonds with embedded options. We illustrate the Martingale pricing process under certain assumptions.

The user inputs the bond parameters and an assumed recovery rate for each bond.

The spreadsheet computes the default probability.

The accompanying spreadsheet illustrates in simple terms how the risk-neutral probabilities
are obtained.