With the release of the new private data I thought I would write most of my posts this week on nuggets on information that can be pulled out of the data…

This first post is on the debt sale amount as a percentage of principal balance at the time of the debt sale…  I know you can find previous debt sale figures here, but sometimes you like to check for yourself. (leporello you know who you are.

To create the follow chart I wrote some sql (see sql at the end of the post) and did a simple pivot in excel.

 

Here is the sql to generate the data… The only remotely tricky part was getting the principal balance on the same line as the net default and filtering out data that I didn’t want. I also linked to the loan object to get the creditgrade… One could take this further and filter the results on any loan or listing column.


select
nd.loankey,
l.creditgrade,
nd.cyclenumber,
nd.status,
nd.netdefaults,
cast(datepart(mm,nd.observationdate) as varchar(2))+'/'+cast(datepart(yyyy,nd.observationdate) as char(4)) as obervatiomonth,
min(fp.principalbalance) as PrincipalAtDefault,
(min(fp.principalbalance)-nd.netdefaults)/min(fp.principalbalance) as defaultPercentage
from
loanperformance nd
inner join
loanperformance fp
on nd.loankey=fp.loankey
inner join
loan l
on l.[key]=nd.loankey
where
nd.netdefaults>0
and nd.netdefaults!=0
and fp.netdefaults=0
and fp.principalbalance!=0
and NOT(nd.status like '%bankruptcy%')
and nd.status!='Repurchased'
group by
nd.loankey,l.creditgrade,nd.cyclenumber,nd.status,nd.dpd,nd.netdefaults,nd.observationdate
having
(min(fp.principalbalance)-nd.netdefaults)/min(fp.principalbalance)>0


Related Posts

• Prosper Debt Sale In Progress As I mentioned several days ago a debt sale is about to be completed. I have had 3 loans sold so far (I will update this page if more are sold)... B Credit @15.16% interest rate, non-homeowner, sold for 9.54% of principal (borrower had not made a single payment). C......
• Debt Sale Accounting via Quicken In the recent default debt sale I had a loan sold.  This is my first opportunity to account for such an event.  I use Quicken for my personal finances including my Prosper account (read about it here). Here are the details of my defaulted loan: CreditGrade: AA Homeowner: Yes Verified......
• Another Default Debt Sale Prosper completed another debt sale...  The details are not yet on the Default Sale History page; however, Prosper Shira did make an announcement on the forums... We completed a debt sale this week which will be evident in participating lender accounts over the next few business days. When a loan......
• L5 (6th Largest Prosper Lender) Post Debt Sale Portfolio Analysis L5 is the 6th largest lender (pick your favorite stats site to verify) and he was on the large lender panel at Prosper Days. I asked him for insights in the aftermath of the latest debt sale that his portfolio might have uncovered. As a smaller lender I don't necessarily......
• Debt Sale Announcement on the Official Forum I was just reading the official forum for the 1st time in a while...  There was an interesting note about the debt sale... Apparently, it was just concluded...  A few of our members have been asking about debt sales.  The timing is driven by the accumulation of a large enough......

Related Websites

• How To Avoid Bankruptcy With A Consumer Proposal If you have a job but are unable to make all your minimum payments, let alone actually pay down your debts on things like payday loans, you may have wondered if bankruptcy is the only way to get out from under all your debt. There is another option you should......
• Deals may soon be harder to find at Wal-Mart This article on MSN regarding Wal-Mart's plans to measure customer traffic is market analysis on steroids.  From what I gather the system will track shoppers' movements using IR and associate those movements with sales data.  Presumably this will allow the stores to tweak the product placement, display, and prominence of......
• 4 Tips to Getting Bad Debt Under Control If you are swimming in a sea of bad debt, keeping your head above water can be incredibly difficult. Thanks to our consumer culture, the availability of credit cards and a general lack of concern for what debt means, many people find that their bad debt is out of control.......
• 3 Ways to Consolidate Credit Card Debt Today's post is a guest blog by Nicole James of Debt Consolidation Care. If you are overburdened with multiple credit card bills and want a solution, then credit card debt consolidation could be the answer that you are looking for. This process combines all your multiple credit card bills into......
• Smart ways to reduce credit card debt (This guest post is presented courtesy of Debt Consolidation Care.) Often, you take many credit cards in order to maintain a certain standard of living. But the problem arises when you can't repay of the loans. The creditors start calling you time and again. Your credit score gets reduced. Therefore,......

Online Stores

• Inflatable Floats & Tubes Swimming Sale
• New Balance Via Watches & Pedometers Running Deals
• Vintage Air Jordan For Sale Womens Shoes
• Cast Iron Metalware Collectibles
• Post-1950 Tables, Stands Furniture Antiques

If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Uncategorized

Tags:

azerbaijan, mozambique