
An example for measuring profitability for a commercial bank portfolio of credit assets.
Instructions on downloading a free version of @RISK.
Calculate a stochastic variable for loss given default, the amount that is not covered by any collateral once a loan has defaulted.
Calculate the probability of default for a loan depending on its score and type.
After the simulation is run we proceed to interpret the chart results.
How to calculate profitability using RAROC for each one of the components of this portfolio.
How to create Excel graphs that are automatically updated every time a simulation is executed.
This banking example shows how to measure profitability for a commercial bank portfolio of credit assets. In the credit business, losses of interest and principal occur all the time - there are always some borrowers that default on their obligations. The losses that are actually experienced in a particular year vary from year to year, depending on the number and severity of default events.
Using a Basel II-based approach we propose a Loss-Given-Default type of model inserting Monte Carlo simulation in order to incorporate probabilities that allow calculation of unexpected losses.