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
  • blog traffic exchangeDTI and Late Payments Yesterday a reader posted the following comment... You rely a lot on DTI - Is DTI a good predictor of default? For the last year, 100 days, or what? Also, what about very high DTI’s (eg >1000%, usually means the person hasn't been able to verify income) — are they......
  • RateLadder.com LoanNew Loan — debt consolodation [sic] — $25,000 at 15.00% — B Credit — DTI 15% A new loan funded this afternoon (debt consolodation [sic] (Loan #6434) — $25,000 at 15.00%).  I participated via my standing order: Low DTI and Mid DTI — NAF.  Which is this loan was funded as a low and medium debt to income ratio and was an non-auto-funding loan.  The borrow had B......
  • 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......
  • 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......
  • RateLadder.com Prosper Days Presentation Slide1RateLadder Presentation At Prosper Days Today I am presenting at Prosper Days 3rd Party Showcase.  Eric from Eric's Credit Community leads off, then RateLadder, then 2 guys from UC Berkley. Here is a sneak peak RateLadder Prosper Days 2007 Powerpoint (unless you are reading this in the future) of my presentation: Here is the video: Here is......
Blog Traffic Exchange Related Websites
  • blog traffic exchangeRemoving the HELOC temptation Lenders are starting to pull the plug on borrowers' home equity lines of credit in light of the falling value of the collateral properties.  They're lowering limits or freezing the accounts, preventing the homeowners from borrowing more against their equity.Banks have certainly not been shy about giving borrowers more rope......
  • flowerMaking Extra Money With P2P Lending Peer to Peer lending is quickly becoming one of the hottest new ways to create multiple streams of income. While there is risk involved, there are various methods that can reduce the risks that individual investors face and provide protection against non-payments. If you're looking for an potential way to......
  • creditcasrdDon't Close These Credit Cards A lot of people tend to close out their credit card accounts if they get too far into debt with their creditors. Apparently they have some kind of notion that this will make the debt go away, when this could not be further from the truth. Not only is this......
  • blog traffic exchangePsst... the Banks *ARE* lending money! I'm willing to bet that if you walked up to the average person on the street and asked them if it's possible to find a loan today, they'd tell you: No way, man! It seems like we've been hearing that the credit system has been frozen for months now.......
  • 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