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...... - RateLadder.com Launches Rate Loan Analyzer I have decided to take RateLadder.com to the next level. Instead of having just static content, I will be launching a series of live crystal reports that run off the nightly prosper data. The first report is the actual Prosper Loan Rate Analyzer that I use when evaluating and reviewing......
-
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...... -
New Loan Funded — debt relief for kids — $6,000 at 18% — B Credit — DTI 64% A new loan funded (debt relief for kids â $19,500 at 14.34%). I participated via my standing order RL Overlooked. The borrower had B credit, a 64% DTI, and is a homeowner. This was a non autofunding loan. As a reminder my standing orders (and manual bids) only find loans with 0 current...... -
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......
Related Websites - Improving Cash Flow vs. Accumulating Wealth When it comes to personal finance, most people are very familiar with the concept of cash flow. They know that their monthly pay represents cash flow in and checks written and automatic draft payments each month are cash flow out. As long as cash flow remains positive (the more positive......
-
Credit Union Pros and Cons A credit union is a financial institution formed by members of a group which allows those members to pool their financial resources for the use of all members. Unlike a bank with is not owned by the customers who use that institution, a credit union gives its members the opportunity...... - 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......
- Is your time worth $2/hour or is it priceless? There are a number of different ways to value your time in order to determine whether to go the extra mile for a discount, do something yourself or hire out, or take on an extra job. I gave my take on how to calculate the hourly value of my time,......
- Four smart tips to take out a mortgage after foreclosure (This post is given courtesy of MortgageFit.com.) If you are a victim of foreclosure, you do not need to consider it as an endless suffering. Foreclosure does bring upon you financial disaster but it does not end your life. You can regain your financial condition, even after you have encountered......
- Leather With High Arm Protection Gloves & Protective Gear Garden Tools & Equipment Gardening & Plants Yard, Garden & Outdoor Living
- Free Standing Punching Bags Boxing Exercise & Fitness
- Computers, High Tech Advertising Collectibles
- Vintage High Heels Womens Shoes
- Standard Process Canine Supplements & Diet Exercise & Fitness
Categories:
Prosper.com, Statistics, Strategy, Tools
Tags:
0 comments ↓
There are no comments yet...Kick things off by filling out the form below.
Leave a Comment