Analyze a Loan Using Crystal Report and Data Export

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 Loans Average Amount Borrowed Average Lender Rate
79 $6,853.52 18.46%

RateLadder.com Loan Analysis 


Oh No! Another late loan… Review of late loan#2.: $16,000 @ 14.7% — AA credit – DTI 25%:       

Number of Loans Average Amount Borrowed Average Lender Rate
64 $8,445.70 10.95%

Late Loan #2 -- Loan Review


Ok last one… for now   

New Loan Funded #6141 — $2,950 in 47 loans – $23,000 @ 27% — C Credit — 16% DTI

Number of Loans Average Amount Borrowed Average Lender Rate
359 $5,872.22 15.85%

RateLadder.com Loan Listing Review

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


Categories:

Prosper.com, Strategy, Tools



Related Articles Related Stores
0 comments ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment

Email Updates