Continuing the theme of tracking the late or worse vintage curves.  Each curve lasts only as long as there are 250 loans in the bucket.  The curves progress in time from the loan origination date.  The measurement is the percentage of money late or worse.  After a debt is defaulted the net default amount is used as the late or worse amount.

General Population 1 Month Late or Worse:

Zero Current Delinquencies 1 Month Late or Worse:

0 Current DQ, 0-1 Inq in last 6 months Criteria 1 Month Late or Worse:

Here is the SQL to produce the data for the general population curves (this take a while to run so you cannot run it on ProProsper as it will timeout):

DECLARE @DTD int
SET @DTD=30
SELECT
cast(aday-originationdate as int) as 'PIT',
l.creditgrade,
sum(PrincipalBalance+NetDefaults) as 'Amount',
count(l.[key]) as 'Count',
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN PrincipalBalance+NetDefaults ELSE 0 END) as 'AmountLate',
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN PrincipalBalance+NetDefaults ELSE 0 END)/sum(PrincipalBalance+NetDefaults) as AmountLatePercentage,
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN 1 ELSE 0 END) as 'CountLate',
sum(case WHEN (mld.DPD!=0 and (mld.DPD+(aday-observationdate))>@DTD) THEN 1.0 ELSE 0.0 END)/count(l.[key]) as 'CountLatePercentage'
FROM
loan l
inner join creditprofile cp on cp.listingkey=l.listingkey
inner join LoanPerformance mld on l.[key]=mld.loankey cross join alldays
where
mld.observationdate = ( select top 1 observationdate from LoanPerformance sub where sub.observationdate < aday and sub.loankey=mld.loankey order by sub.observationdate DESC )
and aday < getDate()
and aday >= '02/01/2006'
and l.creditgrade!='NC'
group by
cast(aday-originationdate as int),
l.creditgrade
having
count(l.[key])>250 and
sum(PrincipalBalance+NetDefaults)>0
order by
'PIT'

Related Posts

• Prosper Vintage Curves 12/1/2007 Today we are updating the vintage curves for 12/1/2007.  (Here is the original explanation.) The number of loans required for display is 250. There are 3 different populations shown across both count late % and amount late %. General population. All loans in credit grade. Loan Count Late % Dollar......
• RateLadder IRR/ROI 5/08 Update -- (1.35%) to 15.3% Well another month down... Nothing major happened that would effect my IRR/ROI (like a debt sale.)  It was a fairly uneventful month for my Prosper p2p lending account, but it was a good month...  My ROI/IRR is higher on 4/5 of my tracking indices (it will be 5/6 when the......
• Prosper Vintage Curves From Private Data 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. With the new private lender data these vintage curves can be pulled with sql and excel greatly expediting the process. Check out the......
• Prosper 1 Month Late or Worse Curves The methodolgy or the sql for obtaining the data these curves from the private data export have already been explained in detail, but briefly... The Y axis is the percentage of all loans orginated of a given age that are currently 1 month late or worse... The X axis is......
• 1 Month Late or Worse Curves by Credit Grade (August 1, 07 Update) This is an update to my original 1 month late or worse curves. I believe we are starting to see the continued flattening of the curves.  Time will tell. I have pulled the public data on the performance tab by hand in order to produce a spreadsheet of loan performance.......

Online Stores

• Case French Horn Brass Acoustic Musical Instruments
• Trumpet Case Flugelhorn Brass Acoustic Musical Instruments
• Hard Case Euphonium Brass Acoustic Musical Instruments
• Double Case For Violin And Viola String Acoustic Musical Instruments
• Double Case Ukulele String Acoustic Musical Instruments

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


Categories:

Uncategorized

Tags:

azerbaijan, mozambique

Useful Info:
One can spend a stress-free vacation with holiday insurance plans. Pay off insurance like dental insurance premiums through your credit cards. People who are enjoying the secured loans facility can get their securities back by paying off the principal amount or their debts. For everything else, a personal loan is available. Shop as much as you can by swiping your bad credit credit cards and earn your rewards visa has offered. Now you can apply online for a mastercard and get another supplementary card free of cost.