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:

 

And here is the resulting rates:

Credit Grade	# Loans	Avg Amt	Avg Rate	Std Deviation	Avg Rate + SD
AA	203	$3,636.94	8.26%	1.07%	9.33%
A	126	$4,277.61	9.25%	1.35%	10.60%
B	160	$4,550.14	11.89%	2.61%	14.50%
C	228	$4,890.12	15.29%	3.00%	18.29%
D	324	$4,190.12	18.58%	3.42%	21.99%
E	472	$3,299.95	23.18%	4.62%	27.80%
HR	708	$2,268.97	24.00%	5.34%	29.34%
NC	34	$2,086.09	22.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.

 

Related Posts

• Default Rate: It's Not Just If a Loan Defaults, But When I had a very interesting email exchange with RGF.  (I emailed him after using his forum posts in articles last week). Here is a portion of that email exchange on default rates over time and their affect on yield. RGF: Default rate:  It's not just if a loan defaults, but......
• 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......
• Prosper in May Set a New Monthly Loan Origination Volume High Water Mark (sql to produce statistics at the end of post)  In May, Prosper originated more loan volume than in any previous month roughly 9.6M loans the vast majority were credit grades AA-C.  This is great news for Prosper on 2 fronts: total volume and loan quality. Here is the breakdown... May......
• New Loan Funded — Secure Borrower needs funds to complete rental houses — $25,000 at 12.00% — AA Credit — DTI 25% A new loan funded (Secure Borrower needs funds to complete rental houses — $25,000 at 12.00%).  I participated via my standing order: Mid DTI — AF.  Which is this loan was funded as a medium debt to income ratio and was an auto-funding loan.  The borrow had AA credit and......
• Vintage Curves 04 2008 -- Amount Late By Credit Grade from Origination It is time for my monthly update of the amount late vintage curves... The y axis is the percent of $$ 30 more more days late... the x axis is days from origination.  The curves stop when there are less than 250 loans in the bucket. There are ways to......

Related Websites

• New Features make Lending on Prosper Better than Ever Prosper.com released a few new features recently. These features might be interesting to all lenders or potential lenders. Here's a run down on some of the new features and how they could affect Prosper's peer-to-peer lending market. Portfolio Plans - Prosper now provides an automated method to bid on set......
• Home Improvement Loan – Renovate Home At Low Price Finance You bought or build a home while back and now it frequently requires enhancements like repairing some damages. Home improvement isn't limited to repairing works however instead adding a story to the home, enlarging area, building additional rooms; modernizing kitchen etc works are included. So the expenses towards creating home......
• Present Value and Future Value - Understanding the Difference In macroeconomics, two important financial structures are the present value and future value. Below is a discussion describing the two structures, and how they differ from one another. Present versus future value is analogous to the concept that today's dollar will be worth more in the future. This concept is......
• Prosper.com Review: A Review of the Prosper Marketplace Prosper.com, also called Prosper Marketplace, is a service that is part of the emerging peer-to-peer lending industry which facilitates the lending and borrowing of money between its users. How it Works: Prosper, Lending Club, Zopa and other firms around the world are sidestepping the banking industry by creating an......
• Are Companies that Make Payday Loans Bad? There's a lot of negative talk in the personal space about pay day loans. In general this talk is justified as many people get trapped in loans with high interest rates. The rates are so high that sometimes people can only pay the interest on the loans. They can't pay......

Online Stores

• Standing Liberty 1916-30 Quarters Coins US Coins Paper Money
• Credit, Charge Cards Trading Cards Collectibles
• Chevron Standard Oil Gas Oil Companies Gas Oil Advertising Collectibles

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


Categories:

Prosper.com, Statistics, Strategy, Tools

Tags:

azerbaijan, mozambique