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

Blog Traffic Exchange Related Posts
  • RateLadder.com LoanNew Loan Funded — paying bills — $5,000 at 26.00% — D Credit — DTI 12% A new loan funded (paying bills — $5,000 at 26.00%).  I participated via my new standing order: Low Amt, Low DTI — AF.  Which is this loan was funded as a low amount requested, low debt to income ratio and was an auto-funding loan.  The borrow had D credit and......
  • blog traffic exchangeEmail From Lending Club I received an email from Merry Richter (Director of Content and Marketing at Lending Club).  The email is basically announcing that lending club is now a marketplace off of Facebook in addition to on Facebook.  I must have signed up for marketing email. --- Greetings from Lending Club! After 100......
  • New Loan ListingNew Loan Funded #5989 -- $2850 in 45 loans A new loan funded this afternoon (#5989 -- PAYING OFF CREDIT CARDS AND HOME IMPROVEMENT -- $22,000 14.55%).  I participated via my standing order: High DTI -- NAF.  Which is this loan was funded as high debt to income ratio and was a non auto-funding loan.  Here is the credit of the......
  • blog traffic exchangeUnderAppreciated Listings RSS Feed Update -- Greater than $3MM in Fundable by Rate, Amount, and DTI Listings Expired I started my RSS feeds on March 18th...  I thought I would check in on my favorite (Underappreciated Listings)...  There have been 827 listings profiled, requesting to borrower $9,057,314 or $10,952.01 per loan on average. Here is the listing status break down... Status Total Amount Number Per Loan Cancelled $455,274......
  • Join my group on Prosper, Climb Down the RateLadderRateLadder Lauches Prosper Group Focussed on Borrower Success As a dedicated and fanatical lender I have been trying to climb up the RateLadder. Put my experience to work for you, allowing you to climb down the RateLadder and obtain the best possible loan rate for your listing. Membership and Listing Requirements How dedicated? How fanatical?   I have been......
Blog Traffic Exchange Related Websites
  • blog traffic exchangeLending Club Opens For Business Again Lending Club has opened for business again. They come back with a partnership from FOLIOfn. This partnership, as I understand it (and I could be wrong here), seems to have sped up their process with the SEC. It also allows them to have a secondary market - a place where......
  • creditcardsGet Rid Of Your Credit Card Debts Credit card debt consolidation is a quite effective option of eliminating your credit card debts. Getting into credit card debt is really harmful for your credit score. It is even worse if you let it accumulate. At present, an average American household carries credit card debts of over $8,000 which......
  • blog traffic exchangeRepost of my First Post - Almost Two Year Anniversary at My Journey to Millions August 5th, 2010 will be 2 years for My Journey to Millions!  To put that in perspective: High School was 4 years College was 4 Years Law School was 3 years I have been Married 2 years and 2 months For the next couple days I am going to re-post......
  • blog traffic exchangeThree Credit Building Tips The credit score is a consumer's lifeblood. Consumers with good credit can easily obtain loans with fantastic interest rates. A bad score can cost thousands of dollars over the life of a loan. While weak credit cannot be fixed overnight, concerted effort over time can increase a poor score. Here......
  • credit consequencesHow Credit Rating Consequences Can Affect Your Life Too often, people overlook the importance of their credit rating and how it affects many different things in their life.  Your credit rating can affect the interest rate for loans that are made available to you as well as your employment and housing opportunities. Sometimes, blemishes on your credit history......
Online Stores 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