Here is the post in it’s entirety because it is that good:
In the early days of Prosper, I estimated that the cost of my idle cash (cash balance waiting to be bid, cash tied up in bids, cash tied up in loan verification, cash tied up waiting for payments to transfer to me) would be the equivalent of about 0.5% loss in interest rate. This came up in one of those old long threads where I advocated that Prosper should pay interest on cash balances.
Well I was wrong. The impact is much larger. Nearly 2%.
I know it sounds amazing.
Some of you have been following the various discussions of using IRR of cash flows into and out of prosper to judge overall portfolio performance. I originally proposed this approach because it includes the costs associated with idle cash and every other bad thing that occurs without the need to explicitly calculate them one by one. I felt that Prosper was giving folk an inappropriate measure of investment success by telling you the average interest rate on your loans, without showing you all the overhead.
When I do the IRR calculation for my portfolio I get about 11.5% . But Prosper says I have an average interest rate of 13.5% in my portfolio. The difference between those two numbers is shockingly high. I started wondering why the heck the difference was so amazingly large.
Today I took the 9 monthly statements I have received so far, and copied the numbers from the summary into a spreadsheet. One column each for:
*Cash balance
active loan value
*in transit
*winning bids
*pending review
total account valueThe ones with the * are the ones where money sits idle, not earning interest.
First thing I did was to average the columns, to produce an average cash balance, average in transit, etc. Then I took ratios of each of these items to total account value. This methodology is not precise, because of this averaging of 9 samples. I would have rather had daily data, but it is very difficult to reconstruct. Here are the results:
Average cash balance= 7.46%
Average in transit = 0.71%
Average winning bids = 3.98%
Average pending review = 1.72%
Sum of these idle cash buckets = 13.87%Wow. On the average, 13.87% of my money has been sitting idle.
Now, my loan portfolio, according to Prosper, has an average interest rate of 13.45%. The idle cash, however, has an interest rate of zero.
So how much have I lost because this cash is idle?
13.87% x 13.45% = 1.87% !!!
To put that another way that may be clearer to some. The amount of my money that has been “active” is 1 – 13.87% = 86.13% . Therefore I’ve been earning that 13.45% average portfolio interest rate on only 86.13% of my money.
86.13% of 13.45% = 11.58% … I’ve been earning 11.58% instead of 13.45% ie losing about 1.87% due to idle cash. (This is all of course before considering the effects of defaults.)
Now this is a disappointing result for a couple of reasons. First, I’ve spent considerable effort trying to control my cash balance. I’ve made frequent deposits. During the heyday when I was ramping up my portfolio rapidly, I was making transfers every 3 days on the average. In September I slowed my bidding dramatically, but on average over the entire time I’ve been involved with Prosper, I’ve averaged one xfer every 6 days. Its not like I transferred a big pile of money in and just let it sit for months while I bid.
I suppose I could manage my cash balance more tightly. The 5 to 7 day delay makes this difficult. (Yea, I know, Prosper calls it a 4 day delay, but its 5 to 7 real days.) I have an Excel model that tells me when I should initiate a transfer. When I’ve tried to run it “tighter” I have had the experience of running out of money from time to time. Loans that meet my bidding criteria seem to come in big bursts.
Beyond managing my cash balance better, there is little I can do. I have a little bit of control over the cash tied up in bids. I could bid later in the listing cycle of course. However, I bid when I do for a reason. In the early days I bid very near the end of listings. I found that many listings terminated early, and my opportunity to bid was lost. As a result of that experience I backed up my bid time. My ongoing experience shows that was the right thing to do. There’s another recent effect that reinforces my thinking on bid timing. There are many large loans that don’t fund these days just because they don’t “catch fire”. This effect seems almost random. However, one can help them along by bidding early. Somebody’s gotta do it. There seem to be a huge number of lenders who wait to see which loans will catch fire, and then bid only after they are greater than some fraction funded.
I can’t do anything about money tied up in loan verification or payments “in transit”.
The practical realities of being a serious lender on Prosper mean that a significant fraction of one’s money is tied up in non-interest-bearing subaccounts. This results in a significant reduction in interest earned.
Here is a link to the topic: http://forums.prosper.com/index.php?showtopic=19842
Related Posts -
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 vs Lending Club -- The First 100 Days Last week Lending Club had a post about their first 100 days -- 100 Days and a Million Dollars in Loans!... This got me thinking, how does that compare with Prosper's first 100 days? Here are the Lending Club loans from that article... Loans issued  172 for $1,046,000 On...... - November Prosper Marketplace Survey Released Prosper released the November marketplace survey and coresponding comentary from Chris Larsen... I particularly like the insight in the last paragraph... Of great interest is the anecdotal evidence of prime and near prime borrowers turning to Prosper for loans that would have historically been steered toward mortgage, auto, and home......
- Another Error in a National Newspaper on P2P Lending Apparently this is fact checking Wednesday. In the USA today is the article: peer-to-peer lending hits its stride In this article a Prosper Lender is quoted... Default rates are lower for peer-to-peer loans than for other consumer loans. Cory Moore became a lender on Prosper.com this year. To hedge against defaults,......
-
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......
Related Websites -
Chase Is Partnering With Retailers To Gouge You I usually don't talk about credit cards on the blog because they're boring and there are plenty of websites and blogs that do cover such things. But when credit cards and bad marketing cross my path, we then have some Weakonomics material. I've made it clear before that I am...... - Cash In On You Web Site's Content Good content could make your website sell like hotcake. Suppose you’ve gained considerable number of regular page visits, wouldn’t it be nice to convert that traffic into something beneficial, like cash? Of course, it would be nice, who doesn’t need money anyway? So now, let’s talk about cashing in on......
-
The Deflation Scam The media has been going on and on about deflation. Long-term bond prices have also been trending up and long term yields have been dropping, which means that the market thinks there will be long-term deflation. Even the Consumer Price Index numbers that came out claim that inflation is under...... -
Viking Classic in Madison Drawing Top Winners Nine previous majors winners along with the last four of the Viking Classic winners have come to be among the players committing to be playing in the upcoming Viking Classic, as the deadline for committing to the tournament passed on October 23, 2009. The defending champion, who is Will MacKenzie,...... - Evan By Numbers May 2010 One of the main reasons that I started this blog was to hold myself accountable, since I truly believe that Accountability Leads to Success when dealing with personal finance and me.. it is even in my FIRST post from August 2008 it is right there in the first sentence of published work......
- Early Flower Bulbs, Roots & Corms Plants, Seeds & Bulbs Gardening & Plants Yard, Garden & Outdoor Living
- Balance New Womens Hit Bg Shoes Running Deals
- Discounted New Balance Shoes Running Deals
- Tokens: Transit Exonumia Coins & Paper Money
- Early Spring Insect & Grub Control Pest & Weed Control Gardening & Plants Yard, Garden & Outdoor Living Nursery
Categories:
Features, Prosper.com
Tags:
1 comment so far ↓
When I started the IRR game, I was using the beginning date of the fund transfer and then I said that to measure the true gains I should use the completed date. Anyway the difference was something like 4% (16% vs. 20%). It seems very significant at first. However, if you think about it in $50 increments, your money may be “uninvested” for 14 days, but then it stays invested for 3 years. Is it going to be that big a difference then?
Leave a Comment