Warning: base64_decode() expects parameter 1 to be string, array given in /home/teamgillett/rateladder.com/wp-content/plugins/askapache-google-404/askapache-google-404.php on line 156
Analyze a Loan Using Crystal Report and Data Export | P2P Lending, Peer to Peer Lending, People to People Lending | P2P Lending News, Information, Borrowing and Lending Strategy

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

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


Categories:

Prosper.com, Strategy, Tools



Tags:

,


0 comments ↓

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

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