Since starting this blog I have reviewed several loans. Since then I have developed a basic crystal report to analyze a loan (DTI, Amount, Credit, and Lender Rate) in the context of all loans on Prosper.com.
The report takes as import the credit grade and the debt to income ratio. It then filters the loans to that credit grade and within +/-5% of the DTI producing both a list of loans with amount borrowed, lender rate, debt to income, credit grade, origination date, averages, and a graph. Anybody have any better ideas for a crystal report analysis? Send me a comment.
I will spare you the details and just show the averages and graph for each of the previous loans I have reviewed…
The data used for this post is from a download from Prosper.com from the morning of 1/10/2007.
Debt Consolidation – Pay off cards to raise credit score: $24,000 @ 19.10% – C Credit — 37% DTI:
Number of LoansAverage Amount BorrowedAverage Lender Rate79$6,853.5218.46%
Oh No! Another late loan… Review of late loan#2.: $16,000 @ 14.7% — AA credit – DTI 25%:Number of LoansAverage Amount BorrowedAverage Lender Rate64$8,445.7010.95%
Ok last one… for now
New Loan Funded #6141 — $2,950 in 47 loans – $23,000 @ 27% — C Credit — 16% DTI
Number of LoansAverage Amount BorrowedAverage Lender Rate359$5,872.2215.85%
If you liked this article, vote for it on del.icio.us and stumbleupon.