Small Loans Less Risk, Large Loans More Risk

I have heard conjecture that large loans are riskier since they have a larger payment… While this seems intuitive I thought I would try to show it visually. 

To start with I ran a quick pivot with 2 different loan buckets.  Loans with payments from $0-$499 and loans with payments $500+.

This graph proves the hypothesis… Is the difference priceable?  Can you make up the difference with higher rates?  Absolutely, but the lower the credit grade the higher the risk adjustment that needs to be made.

(Notice the holiday color scheme?)

Loan Status Percentage By Payment Amount

Here is the sql I used to get the data:

select [key],creditgrade,
case
 when (status like '%late%') then 'Late'
 when (status like '%defaulted%') then 'Default'
 Else 'Current' end as status,
(AmountBorrowed*BorrowerRate/12)/(1-power(1+(BorrowerRate/12),-36)) as payment,
round((AmountBorrowed*BorrowerRate/12)/(1-power(1+(BorrowerRate/12),-36)),-3) as paymentBucket
from loan
where borrowerrate!=0
order by payment desc


 

Blog Traffic Exchange Related Posts
  • blog traffic exchangeProsper Announces Collections "Early Delinquency" Letter Series I love hearing about collections improvements... Give me more!!! Sounds like an interesting idea. I am glad it works. (This must have been the test:Prosper In House Collections Letter) From Doug Fuller on Collections #1: One of the many activities aimed at improving collections undertaken in the last couple of......
  • blog traffic exchangeForbes (P2P Lending) and CNBC (LendingClub) This week has been a great week for p2p lending news. Forbes did an article (Banking 2.0: New Capital Connections For Entrepreneurs) and Lending Club CEO Renaud Laplanche was on Power Lunch at CNBC. I found this of interest from the Forbes article (small business loans from your local bank......
  • blog traffic exchangeProsper People-to-People Lending Market Survey San Francisco – October 9, 2007 – Prosper (www.prosper.com), America’s largest people-to-people lending marketplace, today released its September People-to-People Lending Market Survey.  Prosper’s People-to-People Lending Market Survey provides key statistics and a market commentary by Chris Larsen, Chief Executive Officer and Co-Founder of Prosper.   Prosper’s People-to-People Lending Market Survey......
  • Loan Size GuidanceProsper Steering Borrowers Away From 25K Loans With my recent loan on Prosper I tried to keep an eye out for interesting stories along the way. In this case I found something I didn't like as a lender... Prosper explicitly told me not to put up a 25K listing. As a lender and data junkie I have......
  • Update: RateLadder Prosper Listing Request Reaches 100% Funded Sometime late afternoon on Wednesday (1/30/08) my loan reached 100% funding.  This is a critical first step in getting a Prosper loan. Without reaching 100% funded you cannot get a Prosper loan.  Reaching 100% funded should be the 1st goal of an Prosper borrower and the tools for reaching 100% should......
Blog Traffic Exchange Related Websites
  • blog traffic exchangeMy Financial Week in Review #5 Quick hits on my financial week: I finally invested my 2006 Roth IRA. I decided that I would go with a foreign markets ETF (ticker symbol EFA). While I was in the account, I realized that I had some old holdings like Palm, Checkpoint software, and AMD. I had them......
  • scoreWhat Determines a Credit Score pt 1 Here is some basic information on what you need to know about credit scores and what goes into determining your credit score. What is responsible for determining my credit score? Your credit score has become a very important focal point for a variety of things. Your score is now the......
  • breakRuin Your Credit Fast, pt1 Granted, there are a wide variety of different ways that you can ruin your credit over time, but do you want to know what the quickest and most dangerous ways are? Here are five ways that you can quickly and effectively destroy your credit. 1 - Break your budget. Sure......
  • blog traffic exchangeProsper Investing Tips and Testimonial I've been lending on Prosper for a bit over 7 months now. I've seen quite a few loans move in and out of late status. I suppose some borrowers prefer to "optimize their cash flow" by allowing their loan payments to lapse a few days. This is just fine with......
  • blog traffic exchangeWhy same-as-cash offers are bad I confess that we are currently taking advantage of a 12 months-same-as-cash type offer. We did so because we thought we'd rather earn a little interest on the money that's sitting in our bank account, instead of paying it out up front. I felt comfortable with the idea at the......
Online Stores If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Uncategorized



Tags:

,


7 comments ↓
#1 onthefence on 12.14.07 at 6:48 am

Good work.

#2 Chrisfs on 12.14.07 at 9:55 am

Interesting because payment amount is a function of two items. Loan amount and interest rate. I wonder how much of the increased risk is contributed to by each item.

#3 Little Troll on 12.14.07 at 10:36 am

Where might one find default rate by interest rate for each credit grade?

#4 Kevin on 12.14.07 at 11:13 am

@Little Troll
The trick with such an analysis would be to not slice the data into too many buckets. As the amount of data in each bucket decreases teh less reliable the results.

Are you thinking something similar to this analysis only using interest rate buckets? What buckets would you use?

#5 Little Troll on 12.14.07 at 12:08 pm

Here is what I have so far

Rate-> 6 7 8 9 10 11
A 0.0% 0.0% 0.0% 1.5% 3.4% 3.1%
AA 0.0% 0.0% 0.2% 1.2% 1.7% 2.2%
B 0.0% 0.0% 0.0% 0.0% 4.6% 4.5%
C 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
D 0.0% 0.0% 0.0% 15.4% 14.3%
E 33.3% 50.0% 0.0% 0.0% 0.0% 0.0%
HR 25.0% 23.1% 14.3% 20.0% 23.8% 30.3%
NC 0.0% 0.0% 50.0% 0.0%
Grand 6.7% 2.3% 0.4% 1.4% 3.7% 4.6%

#6 Kevin on 12.14.07 at 12:23 pm

This sql on ProProsper will give you the raw data you seek…
select
creditgrade,
round(borrowerrate,2),
sum(case when ((status like '%late%') or (status like '%default%')) then 1.0 else 0.0 end)/count([key]) as LateOrWorsePercentage
from loan
group by creditgrade, round(borrowerrate,2)
order by creditgrade, round(borrowerrate,2)

I will write up some reuslts for apost next week.

#7 Isaac on 12.14.07 at 5:30 pm

Interesting. I watched your video on the Prosper website, nice stuff.

Cheers

http://p2plendingwithprosper.blogspot.com/

Leave a Comment

aa algorithm axis azerbaijan banks benefit blog borrowers ceo Collections credit grade credit history credit information credit score curves doug fuller email friends and family good luck google income borrowers interest rate interest rates investments launch lenders lending institutions liquidity loans marketplace money mozambique peer to peer lending portfolio plan private data promissory notes quiet period registration statement risk securities and exchange securities and exchange commission spreadsheets sql student loans Zopa