Post by david42 on Jan 29, 2016 23:11:24 GMT
Please let me know if this information is readily available elsewhere, but I have been struggling to keep track of where I have multiple loans to the same borrower.
I attach my attempt to group the loans that share a significant common borrower risk. I hope this list will help others, and maybe others will be able to improve on this if my assumptions are incorrect. Hopefully the planned website improvments will make this list redundant in the near future (hint Ed?).
Assumptions:
1) I have relied on the borrower information published against each loan.
2) Where the borrower is not described in the loan, I have assumed the borrower does not have another moneything loan. This applies to the loans MT269, MT267, MT266, MT265, MT235, MT215, MT190, MT147, MT103 and the Broadoak property loans.
3) There can be a tricky assessment as to whether we are significantly exposed to the agent or to the end borrower. As I want to focus on the exposure limit that concerns me most, I have made the following choices:
3a) I have treated the C*** S*** loans as a single borrower. Although we have some protection from the individual assets, I think most people consider we would struggle to recover our money if CS failed.
3b) Similarly I have treated the AE loans as a single borrower.
3c) On the other hand I have treated Broadoak Property loans as independent, because I am assuming our prime security comes from the underlying asset.
3d) Similarly I have treated the loans handled directly by Moneything as independent loans.
To avoid risk of identifying borrowers, I have listed only the loan IDs below. The following Excel formula can be used to extract the ID from a loan name in cell C2.
SUBSTITUTE(MID(C2,FIND("(",C2)+1,6),")","")
Loan-ID,Borrower
MT349,scar
MT350,scar
MT345,ccar
MT328,MT277
MT322,car1
MT321,car1
MT320,car1
MT319,car1
MT318,car1
MT317,car1
MT308,scar
MT306,MT277
MT280,scar
MT279,scar
MT277,MT277
MT275,scar
MT269,MT269
MT267,MT267
MT266,MT266
MT265,MT265
MT251,art1
MT250,art1
MT249,art1
MT248,art1
MT247,art1
MT246,art1
MT245,art1
MT244,art1
MT243,art1
MT242,art1
MT241,art1
MT240,art1
MT239,art1
MT235,MT235
MT225,art1
MT224,art1
MT223,art1
MT222,art1
MT221,art1
MT220,art1
MT219,art1
MT218,art1
MT217,ccar
MT216,ccar
MT215,MT215
MT190,MT190
MT147,MT147
MT103,MT103
CSP329,CSP
CSP323,CSP
CSP309,CSP
CSP278,CSP
CSP268,CSP
CSP253,CSP
CSP252,CSP
CSP237,CSP
CSP234,CSP
CSP232,CSP
CSP231,CSP
CSP229,CSP
CSP228,CSP
CSP227,CSP
CSP226,CSP
CSP213,CSP
CSP212,CSP
CSP211,CSP
CSP210,CSP
CSP175,CSP
CSP174,CSP
CSP118,CSP
CSP117,CSP
CSP116,CSP
CSP115,CSP
CSP114,CSP
CSP111,CSP
CSP110,CSP
CSP109,CSP
CSP108,CSP
CSP107,CSP
BPF347,BPF347
BPF311,BPF289
BPF310,BPF310
BPF307,BPF307
BPF289,BPF289
AE326,AE
AE325,AE
AE316,AE
AE315,AE
AE291,AE
AE290,AE
I attach my attempt to group the loans that share a significant common borrower risk. I hope this list will help others, and maybe others will be able to improve on this if my assumptions are incorrect. Hopefully the planned website improvments will make this list redundant in the near future (hint Ed?).
Assumptions:
1) I have relied on the borrower information published against each loan.
2) Where the borrower is not described in the loan, I have assumed the borrower does not have another moneything loan. This applies to the loans MT269, MT267, MT266, MT265, MT235, MT215, MT190, MT147, MT103 and the Broadoak property loans.
3) There can be a tricky assessment as to whether we are significantly exposed to the agent or to the end borrower. As I want to focus on the exposure limit that concerns me most, I have made the following choices:
3a) I have treated the C*** S*** loans as a single borrower. Although we have some protection from the individual assets, I think most people consider we would struggle to recover our money if CS failed.
3b) Similarly I have treated the AE loans as a single borrower.
3c) On the other hand I have treated Broadoak Property loans as independent, because I am assuming our prime security comes from the underlying asset.
3d) Similarly I have treated the loans handled directly by Moneything as independent loans.
To avoid risk of identifying borrowers, I have listed only the loan IDs below. The following Excel formula can be used to extract the ID from a loan name in cell C2.
SUBSTITUTE(MID(C2,FIND("(",C2)+1,6),")","")
Loan-ID,Borrower
MT349,scar
MT350,scar
MT345,ccar
MT328,MT277
MT322,car1
MT321,car1
MT320,car1
MT319,car1
MT318,car1
MT317,car1
MT308,scar
MT306,MT277
MT280,scar
MT279,scar
MT277,MT277
MT275,scar
MT269,MT269
MT267,MT267
MT266,MT266
MT265,MT265
MT251,art1
MT250,art1
MT249,art1
MT248,art1
MT247,art1
MT246,art1
MT245,art1
MT244,art1
MT243,art1
MT242,art1
MT241,art1
MT240,art1
MT239,art1
MT235,MT235
MT225,art1
MT224,art1
MT223,art1
MT222,art1
MT221,art1
MT220,art1
MT219,art1
MT218,art1
MT217,ccar
MT216,ccar
MT215,MT215
MT190,MT190
MT147,MT147
MT103,MT103
CSP329,CSP
CSP323,CSP
CSP309,CSP
CSP278,CSP
CSP268,CSP
CSP253,CSP
CSP252,CSP
CSP237,CSP
CSP234,CSP
CSP232,CSP
CSP231,CSP
CSP229,CSP
CSP228,CSP
CSP227,CSP
CSP226,CSP
CSP213,CSP
CSP212,CSP
CSP211,CSP
CSP210,CSP
CSP175,CSP
CSP174,CSP
CSP118,CSP
CSP117,CSP
CSP116,CSP
CSP115,CSP
CSP114,CSP
CSP111,CSP
CSP110,CSP
CSP109,CSP
CSP108,CSP
CSP107,CSP
BPF347,BPF347
BPF311,BPF289
BPF310,BPF310
BPF307,BPF307
BPF289,BPF289
AE326,AE
AE325,AE
AE316,AE
AE315,AE
AE291,AE
AE290,AE