Hello everyone, I've recently run into an extremely frustrating problem. I was hoping you fine gentlemen/women might be able to help me out.I am trying to graph the changing tranche spread relationship of CDOs which depends on Correlation in the various tranches (Equity to Senior tranches) for a paper I am publishing. By all logic and common understanding, going from a 0 correlation to a perfect (1) correlation, the equity tranche (0-3%) should have a negative spread slope, whereas the senior tranche (12-20%) should have a positive slope. Mezzanine should show a somewhat positive/flat trend. I'm sure no one disagrees with me on this point.However, the issue I'm having is when I try to replicate this scenario in my CDO One Factor Gausian Copula model and in other Copula models I have, the slopes are downward sloping for the Equity, Mezzanine and Senior tranches. I have to increase the spreads significantly (0-20% for equity, 20%-40% mezzanine, and 40-60% senior...) to get the desired graph. This is of course cheating, and I would like to develop this graph using real data. I am using standard inputs, i.e. recovery rate 40%, interest rate 5%, hazard rate 10%, maturity 5 years, names 125. The reason why I want to replicate this graph is that I want to show the risk assessments of the various tranches depending on Correlation.You can download a copy of my model at
www.thecopuloslawfirm.com/CDOvaluation.xls to try see what the issue is. I don't think it's a problem with the model, as I have tried other models, but if you think it might be, please let me know. Also, please see
http://www.rotman.utoronto.ca/~hull/Dow ... lModel.pdf, where Mr. John Hull archived what I am trying to do (to prove that I'm not insane ).Hope you are able to help a frustrated man in need. Feel free to message for further details (I tried to make the explanation above as short and simple as possible).ThanksThomas Rasmussen