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 vs Lending Club -- The First 100 Days Last week Lending Club had a post about their first 100 days -- 100 Days and a Million Dollars in Loans!... This got me thinking, how does that compare with Prosper's first 100 days? Here are the Lending Club loans from that article... Loans issued  172 for $1,046,000 On...... - One Loan Late. Not supposed to happen to AA. What does that mean? Of my 46 loans. 1 is now late (less than 15 days). Here is what Prosper.com says will happen now: What exactly happens if I'm late? Below is the schedule that Prosper follows in the event of a borrower missing a payment due to insufficient funds (NSF). At any point......
- Prosper is Going To Sue Deadbeat Borrowers Prosper the p2p lending company is getting tough on late borrowers. The "New Agency Test" is taking an interesting turn... Prosper is going to sue. I just received the following email from Prosper. The purpose of this email is to inform you of your right to choose what action you would......
- Please Close Major Loophole for Deadbeat Lender/Group Leaders There has been a minor uproar on the forums over deadbeat lenders/group leaders. That is to say, Prosper.com members that are lenders and borrowers with late payments on the loan given to them. The consensus seems to be that Prosper should be impounding the loan payments they are receiving in......
-
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......
Related Websites - The Last 10,000... I am down to my last 10,000 in student loans. The good news is that the "end" is in sight. The bad news is that it is still 10,000. For some reason, this loan, the last loan, has been the hardest to pay extra on. I don't know why that......
- How To Get Your Credit Card Interest Rate Reduced The more money you pay in finance charges on your credit cards, the less you're paying towards principal. And the less you're paying towards principal, the longer it will take you to get out of debt. Fortunately, it's not overly difficult to get your credit card interest rates reduced, and......
-
Great Methods For Avoiding Credit Card Late Fees The amount of profit that credit card companies have made off of credit card late fees has reached record levels in the last few years as more and more individuals find themselves unable to make their payment on time. Credit card fees are destroying family budgets by adding additional charges...... -
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...... -
Saving Money with a Government Loan Option Buying a home is part of the American dream. For more than half of a century, Americans have been set on finding homes to hang their hats. Owning a home is a sign of stability and pride. However, financing a home can be a nightmare that interrupts the American dream.......
- Large Snow Blowers Outdoor Power Equipment Yard, Garden & Outdoor Living
- Case Autoharp & Zither String Acoustic Musical Instruments
- Trumpet Case Flugelhorn Brass Acoustic Musical Instruments
- Color 1990-99 Photos Television Memorabilia Entertainment Memorabilia
- Bam Case Cello String Acoustic Musical Instruments
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