RateLadder.com Launches Standing Order Analyzer | P2P Lending, Peer to Peer Lending, People to People Lending

Introducing the Prosper Standing Order Analyzer, the second in a series of live Crystal Reports.

This is the actual Prosper Standing Order Analyzer that I use when evaluating standing order loan rates. For input it takes the high and low debt to income ratio as well as the high and low loan amount. It looks at all loans in the last 100 days with low DTI to high DTI, and low loan amount to high loan amount. It returns a graph of the average interest rate by credit grade and calculates the number of loans, average amount borrowed, weighted average interest rate by amount borrowed, and the standard deviation of the interest rate.

For example, let’s say you wanted to setup a standing order for loans from $1,000 to $9,999 and DTI from 0% to 40%. What interest rates should you require? Enter the standing order analyzer. It can tell you the weighted average and the standard deviation broken down by credit grade.

For our hypothetical standing order here is the graph produced:

Prosper Standing Order Analyzer

And here is the resulting rates:

Credit Grade# LoansAvg AmtAvg RateStd DeviationAvg Rate + SDAA203$3,636.948.26%1.07%9.33%A126$4,277.619.25%1.35%10.60%B160$4,550.1411.89%2.61%14.50%C228$4,890.1215.29%3.00%18.29%D324$4,190.1218.58%3.42%21.99%E472$3,299.9523.18%4.62%27.80%HR708$2,268.9724.00%5.34%29.34%NC34$2,086.0922.81%6.74%29.56%

This is a very useful information. For example one might say that they need at least the weighted average plus 1 standard deviation. Or there you want to ladder from the weighted average to the weighted average plus 2 standard deviations. The possibilities are limitless, the goal is to beat the average and find a highly positive ROI loan parameters.

One small apology, I still do not have a 1 CPU license for my Crystals. So only 5 people at a time can use the tool. Also, because of a bug in Crystal each time the report is run a user license is used for 20 minutes.

Give it a try.

Blog Traffic ExchangeRelated Posts

  • New Loan Funded — Ethanol Plant — $25,000 at 24% — C Credit — DTI 85%A new loan funded (Ethanol Plant — $25,000 at 24%). I participated via a manual bid, this was an auto funding loan.  The borrow had C credit and 85% DTI. As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10 or less delinquencies in the……
  • New 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……
  • New Loan Funded — Finance for an ESTABLISHED Business — $25,000 at 24% — B Credit — DTI 1392557%A new loan funded (Finance for an ESTABLISHED Business – $25,000 at 24%). I participated via a manual bid the loan was Autofunding. The borrower had B credit and a 1392557% DTI (unverifiable income). As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10 or less delinquencies……
  • Loaning on Lending Club For the 1st TimeSo my money cleared and this morning I started to put it to work at Lending Club. I started with LendingMatch. I reviewed the initial loans discarded half and then searched for more in the credit tranches my portfolio lacked. Starting with the negative (ending with the positive)…  It took a long……
  • My Prosper Internal Rate of Return Update (End of Jan 07) — 18.14%Clearly I am not an expert, but I like to play one on TV. In my previous post:  My Prosper Internal Rate of Return Update (End of Jan 07) — 1.67% I was tracking my IRR using the Excel Function IRR and making a monthly cash flow simplification to have regular intervals. This……

RateLadder.com LoanRelated Websites

  • Leveraged Finance DefinedLeveraged finance relates to funding a business, a company or another investment using more debt than would be considered normal. More than normal debt is going to imply by nature that the funding is a riskier prospect, and therefore more costly than normal borrowing in general. As a result, leveraged……
  • Hack Your Credit Score?When I was at Prosper’s annual conference, CEO Chris Larsen flashed through an interesting slide. It showed a borrow with a grade D credit score having gotten a loan at 1% interest. This is far from the norm. Often someone with a credit score will end with an interest rate……
  • How to Use High Interest Loans and Credit to FIX Bad CreditThe tragedy of bad credit is that in order to get rid of it and build some good financial standing one must dutifully pay off loans and lines of credit. The tragic part being that those with bad credit are typically denied access to such capital. This is why the……
  • Lending Club Loan Selection CriteriaAs you know, I’ve been focusing on Lending Club a lot recently, mostly because I recently moved to California and am now eligible to start lending! Well, I opened a Roth IRA with Lending Club and funded it with $5,000. Each weekday, I go and search for a few loans that……
  • Payday Loan Laws: Every State is DifferentWhen it comes to fixing credit, there is sometimes no other option than the high interest loan. It boils down to a paradoxical situation that affects the lives of millions. Those with bad credit can’t make their situation better unless they take out new lines of credit that are impossible……

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

Categories:

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *