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

• 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......
• New Loan Funded #6141 -- $2,950 in 47 loans A new loan funded this afternoon (Engagement Ring (Loan #6141) — $23,000 at 27%).  I participated via my standing order: Any DTI -- AF.  Which is this loan was funded as any debt to income ratio and was an auto-funding loan.  The borrow had C credit and 16% DTI. As a reminder......
• Prime Borrowing on Prosper Hits Record Levels -- Febuary Marketplace Survey SAN FRANCISCO--(BUSINESS WIRE)--March 11, 2008--Spurred by the credit crunch, attractive rates, and lender demand for conservative assets, Prosper (www.prosper.com), America's largest people-to-people lending marketplace with over 600,000 members and $120 million in funded loans, reported that the number of prime borrowers (720+ credit scores) creating listings and obtaining loans continues......
• New 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......
• 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......

Related Websites

• Got a Refund? 10 Ideas to Spend Your Tax Refund I've always been an advocate against getting a refund each year and changing your withholding throughout the year to get extra money now instead of waiting. Yes, getting a refund is better than paying in to the government, but I always like to tweak my withholding just enough to where......
• How to Fuel Your Body For Exercise When you are trying to lose weight, it is very common to go on a strict diet and add in exercise on top of that. There is a problem with this however and you can end up feeling too exhausted to keep going. This usually leads to quitting your......
• Intended Payday Loans Payday loans are intended to tie borrowers over until the next paycheck arrives. The downside is payday loans have steep fees and APR (Annual Percentage Rates) and can lead to bankruptcy and debt. The loans are issued upon an agreement with stipulations that the borrower will repay the fees on......
• Making 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......
• 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......

Online Stores

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

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


Categories:

Prosper.com, Statistics, Strategy, Tools

Tags:

azerbaijan, mozambique