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 Offer Roughly 0.93%-4.83% On Friday, Doug Fuller gave an update on the debt sale. Synopsis:  Prosper put the bid file on an auction site, 8 bids received, all the bids were very disappointing, Prosper has not accepted a bid yet, and is exploring options for getting a better deal. When asked how disappointing......
• Daily Late 0 DQ Vintage Curves You may have seen my Prosper vintage curves... While they were hard to make since the data had to be pulled off the Prosper Loan Performance page. These are now much easier with the private lender data (see the sql at the end of the post for those that are......
• LendingStats Site Update LendingStats has just announced an update...  And I think it has 2 cool features and a very nice upgrade to the LendingStats ROI calculation. The ROI upgrade:  Updated the collection rates used to calculate estimated ROI corresponding to how Prosper split out the Penncro Collection rates by credit grade. This caused......
• 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......
• RateLadder Quicken ROI Update November 1, 2007 I have decided to continue to track my Quicken ROI even though Prosper has removed the Prosper ROI link from the lending tab. I have also decided to keep the Prosper ROI on the graph for reference. This Quicken ROI is calculated using the method described here. My Quicken Prosper......

Related Websites

• Paying down the mortgage One of my goals is to pay off our mortgage by the year 2011, becoming COMPLETELY debt free. That means that to make my share of the payments, I need to pay down $54,000 over the next four years, while also aggressively funding a variety of savings, investments, and pet......
• Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all three!) this list of more than 80 top products is just what you need. Everyone's got saving money on their minds these days. Some of us are always looking to......
• 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.......
• 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......
• Debt Consolidation Tips If you're swimming in a sea of debt and trying to figure out how to keep your head above the water, one of the easiest ways is to consolidate. However, the actual process of consolidation can be confusing and it is all too easy to make mistakes that will end......

Online Stores

• New Balance Womens Shoes

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


Categories:

Uncategorized

Tags:

azerbaijan, mozambique