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?)
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
Related Posts -
Prosper 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...... - Forbes (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......
- Prosper 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......
-
Prosper 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......
Related Websites - My 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......
-
What 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...... -
Ruin 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...... - Prosper 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......
- Why 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......
- Case Agriculture Advertising Collectibles
- 19.2 volt Higher Cordless Drills Power Tools Tools Home Improvement
Categories:
Uncategorized
Tags:
7 comments ↓
Good work.
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.
Where might one find default rate by interest rate for each credit grade?
@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?
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%
This sql on ProProsper will give you the raw data you seek…
selectcreditgrade,
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.
Interesting. I watched your video on the Prosper website, nice stuff.
Cheers
http://p2plendingwithprosper.blogspot.com/
Leave a Comment