Prosper IRR is a tricky calculation.  The concept is very simple.  The problem lies in how to treat delinquent and late loans prior to the debt sale.   Before loans are late and after the debt sale treating one’s account balance is whole.  While a loan is late the loan’s value must be subtracted from the account value in some way.  The two edge cases are to not subtract anything and to subtract the entire value of the loan.  The problem is the right answer is somewhere in between.  After one month late if it loan payments are subject to some collections fee.  When the debt is sold it yield something even if it is pennies on the dollar.  Over time the current loans in limbo matter less as the roll rate, collection rate, and default sale percentage will “come out in the wash.”

As pensioner said this game

is all about defaults!!!!

The ultimate goal being knowledge, entertainment, and ROI.  I developed a spreadsheet to determine IRR. Pensioner and I have refined the spreadsheet.  Now the IRR calculated by the spreadsheet returns the best case and worst case numbers for the loans more than month late.  The “Game”’s tracking page is at Prosper.com IRR Lender “Game” Tracking Page

So far, I have my numbers and I have pensioner’s numbers and permission to post.  I have invited several other lenders to join my “game” and am awaiting responses.  The “game” is to track the IRR at monthly intervals and see the results.  Hopefully we will gain a better understanding of the marketplace and our own portfolios.

I will post the responses as I get the posts ready.  If you want to participate  send an email with results with explicit permission to post with a short writeup about yourself to kevin [at] rateladder (dot) com.   The writeup doesn’t need to be extensive, but it must be compelling.  For example, pensioner’s writeup would be compelling for the sole reason that he is the largest lender on Prosper.  The fact that he was on the large lender panel at Prosper Days only helps.

Here is the a sample Prosper IRR Spreadsheet.

The reporting and analysis will developed over the course of the “game” as a starting point I will post a the current spreadsheet and bio for each lender as the posts are ready.  Expect at least RateLadder_com and pensioner by the end of the weekend.

Related Posts

• Prosper Employee Andrew Seeks Loan A Prosper employee (Prosper Andrew on the forums) is seeking a loan...  Credit Grade AA Homeowner Account Verified 3% Debt To Income Ratio Loan Description: Purpose of loan: I own an apartment in San Francisco that has a tile patio which started leaking last winter (rainy season here in SF).......
• Email 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......
• Prosper Site Update 12/2007 Verbatim from amf of Prosper... All, Tonight we did a bunch of back-end work and made a couple of changes that you might notice...   Lender overview changes We've received a lot of feedback from lenders that the "Active loan summary" box on the "Your Account > Lending" page is......
• Prosper IRR Lender “Game” September 07 Update It is time for the end of September 2007 update of the IRR Lender “Game.” This month was just a regular month. A Collections guru was hired and I did have a collections paymnet at the last second that saved me from a negative model IRR. Hopefully, a sign of......
• Prosper IRR Lender “Game” July 07 Update It is time for the July 2007 update of the IRR Lender “Game.” This is going to be more about accomplishments during the last month rather than pure calculations.  The actual numbers are at Prosper.com IRR Lender “Game” Tracking Page So without further ado: Highest IRR Model: leporello 2.61% Largest IRR......

Related Websites

• Revealing the Keys to Prosper Success Earlier this week, I defended the Prosper's business viability. I spent two posts rebutting the idea that it might not be a good investment. Just yesterday, I discussed the Prosper mistakes I've made. Today, I will share with you what I've learned. Hopefully 5 minutes from now you'll be......
• Do You Need to Do a Short Sale? It is very important to know if a short sale is the best answer for your situation.  A short sale becomes a viable option when you cannot get what you are owed on the property because of changes in the market.  You may be thinking why would the lender allow......
• The Popularity of the Deer Hunting Game Online A deer hunting game can be a fun way to pass some time for avid hunters and outdoor enthusiasts. While nothing can take the place of getting out into the woods and really hunting, the online community has come up with some suitable diversions for hunters who are looking for......
• Rogers HTC Magic running the ROM for the new Andriod phone the HTC Hero... 1) Install the Andriod SDK developer.android.com 2) Install the USB Drivers that are in the Andriod SDK C:\android-sdk-windows-1.5_r2\usb_driver 4) Hero ROM - read this post... forum.xda-developers.com Get this ROM tinyurl.com put it on the SD Card that's in the phone and rename it to "update.zip". 3) Recovery Environment -......
• Maximize Your Prosper Lending with RateLadder.com I had mentioned RateLadder.com in the past, but Kevin has been busy adding some great tools for lenders. I should have been bringing you up to date before now, but he's been bringing them out faster than I write about them. Today we are going to catch up and cover......

Online Stores

• Baseball-MLB Game Used Memorabilia Sports Collectibles
• Wholesale Trade & Distribution Businesses for Sale Opportunities
• Businesses for Sale Opportunities
• Big Game Tree Stands Accessories Hunting
• Sticks Hockey-NHL Game Used Memorabilia Sports Collectibles

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


Categories:

Prosper Lender IRR "Game", Prosper.com, Statistics, Tools

Tags:

azerbaijan, mozambique