State Default Rates — A Publishable Application of the RateLadder ListingKey | P2P Lending, Peer to Peer Lending, People to People Lending

In the past I have talked about my technique for adding a ListingKey to the Loan table of the Prosper.com data export. While I had successfully added the key several weeks ago I hadn’t found an application of the key that I could publish until recently. A fellow Princetonian and prosper lender suggested that I determine and publish the state default rates. (This is a hot topic on the forums as many people claim people from Georgia are more likely to default.) What a brilliant idea.

In order to accomplish you must link from loan to listing to member. Without adding a listingkey to your loan table this is not possible.

So without further ado here is the best and worst current state default rates for all loans in the data export order by highest percentage of defaults. This is using data from 2/19/2007 and includes all loans.

Using Only States with at least 70 loans.

Here is the Best 3 by # of Loans:

StateCurrent, Paid, or PurchasedLate or DefaultedName# of LoansAvg Rate# of Loans% of State Total# of Loans% of State TotalWA 12518%12297.60%32.40%NY12213%11795.90%54.10%IL16819%15894.05%105.95%

Here is the Worst 3 by # of Loans:

StateCurrent, Paid, or PurchasedLate or DefaultedName# of LoansAvg Rate# of Loans% of State Total# of Loans% of State TotalGA 25020%21887.20%3212.80%CO7015%6390%710%OR8621%7890.70%89.30%

Here is the Entire List by # of Loans (I removed bad data and loans for which I could not tell the state):

StateCurrent, Paid, or PurchasedLate or DefaultedName# of LoansAvg Rate# of Loans% of State Total# of Loans% of State TotalAK 29%2100%00%AL5120%4996.08%23.92%AR109%10100%00%AZ10217%9492.16%87.84%CA55020%50591.82%458.18%CO7015%6390%710%CT810%8100%00%DE39%3100%00%FL18215%16992.86%137.14%GA25020%21887.20%3212.80%HI810%8100%00%IA2014%20100%00%ID2016%1890%210%IL16819%15894.05%105.95%IN4115%3892.68%37.32%KS3416%3191.18%38.82%KY14%1100%00%LA2315%2295.65%14.35%MA5416%4990.74%59.26%MD3818%3694.74%25.26%ME417%4100%00%MI12419%11592.74%97.26%MN87%8100%00%MO9720%9092.78%77.22%MS39%3100%00%MT919%9100%00%NC5113%5098.04%11.96%ND521%360%240%NE1113%11100%00%NH1420%1178.57%321.43%NJ4513%4497.78%12.22%NM1523%1386.67%213.33%NY12213%11795.90%54.10%OH47%4100%00%OK2014%1995%15%OR8621%7890.70%89.30%PA53%480%120%SC1011%10100%00%TN2010%1995%15%TX47519%43591.58%408.42%UT4417%4295.45%24.55%VA4211%42100%00%VT215%2100%00%WA12518%12297.60%32.40%WI3714%3594.59%25.41%WV816%8100%00%WY115%1100%00%Related posts:
If you liked this article, vote for it on del.icio.us and stumbleupon.

Categories:

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *