• Subscribe
  • Contact Us
  • About LendIt Fintech News
  • Home
  • Menu Item
  • Menu Item
  • Menu Item
  • Menu Item

Lend Academy

LendIt Fintech News: Daily Coverage of Fintech & Online Lending


  • Editorial
  • Daily News
  • Podcast
  • Investor Forum
  • Events

What is Your Actual Return with P2P Lending?

January 7, 2011 By Peter Renton 21 Comments

Views: 3,388

Every time you login to Lending Club you are greeted with your Net Annualized Return number on the home screen. But is this the actual return you are getting on your money? Let me share my results with you to give you an idea.

I began investing in Lending Club July 2009 with just $500, split between two notes (one of which defaulted after 9 months). As I mentioned in a previous post this lack of diversification was a big mistake. I invested another $10,000 in August 2009 (more diversified this time) and since then I have invested no new money in this account. Last year I did rollover my wife’s IRA into a Lending Club IRA but that account is only six months old so it is too young to really give us a good indication of actual vs stated return. My account on Prosper has been open less than six months as well so I won’t be including either account in this analysis.

My main Lending Club account has 304 notes, primarily grades A, B, and C with a median loan age of 15 months. On December 31st, 2010, Lending Club maintained that my Net Annualized Return (NAR) was 7.64%. So, I calculated what my real world return was. It was a very simple process because I had not added or withdrawn money from my account in 2010. My starting balance on January 1, 2010 was $10,792 and my ending balance on December 31, 2010 was $11,547. This equates to a return of exactly 7.0%, or 0.64% less than Lending Club states.

The Difference Between Real and Stated NAR

Why is there a difference between my actual return and the return that Lending Club states? The main reason can be summed up in one word: cash. The Lending Club formula assumes that all your money is 100% invested in notes all the time. But in reality that can’t happen. Once you decide to invest in a note it will take several days for the funds to be released to the borrower. Meanwhile that money is just sitting there earning 0% interest. Then once you have some loans in place, if you have more than a handful of loans you are receiving interest and principal payments on a daily basis. This money stays in your account earning o% as well until you reinvest it.

Lending Club does take into account loan defaults in calculating your NAR, so whenever you have one you will notice a dip in your NAR. Your NAR will change regularly because it is calculated every day for you. If you go for several days or weeks without a default you will likely see it creep up. As you invest in new notes, particularly higher interest notes, you will also see it creep up.

Prosper Takes a Different Approach

With Prosper you are not greeted with a big NAR number staring at you when you login like you are at Lending Club. Prosper sends out monthly emails with your “Prosper ROI” but they don’t display it on their web site for you. From the monthly email they share how your NAR is calculated:

Returns include all payments received net of principal repayment, credit losses, and servicing costs for Notes not bought or sold on Folio. Returns are divided by the average daily amount of principal outstanding to get a simple rate of return. This rate is annualized by dividing by the dollar weighted average Note age of your portfolio in days and multiplying by 365.

It is a slightly different formula to Lending Club, but I am not an expert mathematician so I can’t provide much feedback as to which one is more accurate. They both take into account defaults and service fees. Anyway, you shouldn’t rely on either company’s metrics, you really should do you own calculation to determine your actual NAR.

How to Calculate Your NAR for Lending Club or Prosper

The good news is that it is relatively easy to calculate your own real world NAR in an Excel spreadsheet. You can use the XIRR function within Excel to do the hard work for you. All you need is a list of all the deposits and withdrawals you made on your account and their respective dates as well as the starting and ending balance. You put the deposits in as negative numbers and the withdrawals as a positive number, then the final balance should be a positive number. Lets’s take a look at this simple example here. On January 1, 2010 $10,000 was invested; three further deposits were made on 2/1/10, 5/5/10 and 6/30/10. A $300 withdrawal was made on 11/15/10 and the closing balance of $11,489 results in a 11.48% annual return. There are examples and further explanations of XIRR() in Excel’s help as well as here.

Past Performance is No Guarantee of Future Returns

You see this disclaimer throughout the financial services industry and it certainly applies here as well. The thing about NAR is that it is always going to be best when most loans in your portfolio are young. As of right now the median age of loans on Lending Club is slightly less than nine months. This means that the majority of loans are still very young and haven’t even had much of a chance to default. So, even though the Lending Club claim of 9.68% average returns and Prosper’s claim of 10.4% is technically correct, it is somewhat misleading. In the real world your returns will be less than that as I demonstrated in my example above. Also, the average return for all p2p investors will likely be lower than claimed  once all loans have been held to maturity and all defaults have been taken into account.

If you really want an accurate picture of your returns on your p2p investments it is important to calculate it yourself. It appears that Lending Club overstates the return by between 0.5% and 1%, and my guess is that Prosper does this as well. It is also a good idea to temper your expectations, because your returns may well go down as your loans age and some defaults become a reality. Even with these lower expectations and overstated returns, I still believe that with p2p lending you can a great return on your money.

Filed Under: Investing/Lending Tagged With: interest rate, NAR, return, XIRR

Views: 3,388

Comments

  1. Dan B says

    January 8, 2011 at 12:37 am

    Excellent job ! That’s a very balanced assessment of p2p returns. It should be “required reading” for all new p2p investors.

    Reply
  2. Peter Renton says

    January 8, 2011 at 7:20 am

    Thanks Dan. That’s high praise coming from you.

    Reply
  3. Rob G @ Lending Club says

    January 8, 2011 at 8:14 am

    Peter:

    As a matter of clarification, it is not correct to state that Lending Club’s formula “assumes that all your money is 100% invested in notes all the time.” In fact, the formula is independent of whether you have money in cash or invested. What the formula does is calculate your return based on outstanding principal ONLY. In other words, it calculates your return based on capital that is invested. As you get payments, some of your capital is returned to you as cash, which does not earn a return, which explains the difference between the real returns on invested capital, and your more nominal calculation of return.

    Hope this helps clarify.
    Rob

    Reply
  4. Peter Renton says

    January 8, 2011 at 2:52 pm

    Thanks for the clarification, Rob. It is probably more accurate to say it your way. I just wanted to get the point across that the Lending CLub stated return is different from the real world return. If an investor doesn’t bother reinvesting the cash earned from payments and let’s the money sit there earning o%, eventually the LC return and the real world return will be a long way apart.

    The lesson here for everybody: reinvest your cash. Don’t let it sit idle in your account.

    Reply
  5. Mike says

    January 8, 2011 at 3:14 pm

    Excellent advice. Even getting 1-1.5% in an online bank beats getting 0% at Lending Club. I don’t hesitate to move money out of Lending Club if I can’t find any loans that satisfy all of my criteria. At year end, I review all of my investments, and for 2010, my stock performance trounced my Lending Club performance, which averaged 10% between my two accounts. I am no longer adding any more $$ to my non-retirement Lending Club account, and am just reinvesting the $$ in my SIMPLE IRA at Lending Club. I have had a couple of borrowers default due to bankruptcies shortly after obtaining their loans. I am concerned that word may get out that if you are considering bankruptcy, try to obtain a loan just before, and you’re golden for that 20 or 25k. Has this happened to anybody else?

    Reply
  6. Peter Renton says

    January 10, 2011 at 10:26 am

    Mike, There are certainly people who try and game the system like this and I have had a couple of bankruptcies very early on in the process. But I believe Lending Club are capturing most of these people before they get approved for a loan. If they didn’t their platform would no longer function. It is hard to get all the scammers but my experience is that there are a very small percentage of people who have no intention of paying back the loan.

    Reply
  7. Mike says

    January 12, 2011 at 10:34 am

    I hope you are right, Peter. Another one of my loans went late after just one payment…By the way, do you think Lending Club’s format for it’s loan performance data is realistic?

    Reply
  8. Peter Renton says

    January 12, 2011 at 5:14 pm

    Mike, I am not sure exactly what you mean by “format for its loan performance”. I think the performance page in the Statistics section is very useful, particularly when you plug in dates for older loans. However, I think the stated 9.68% return is not a realistic expectation for most p2p lenders. My guess is that return on loans held to maturity will average 7-8%. Which I believe is still quite a good return on your money.

    Reply
  9. Matthew Paulson says

    August 13, 2011 at 11:06 am

    Peter – Could you upload your spreadsheet so that we can have a template to work from?

    Reply
  10. Paul says

    January 30, 2014 at 1:03 am

    Having awful returns on Lending Club – down to 0.5% NAR (ie, after chargeoffs). I stayed with C+ loans, but at this rate I might not get my principle back when all is said and done.

    Reply
    • Peter Renton says

      January 30, 2014 at 1:03 pm

      Hi Paul, Sorry to hear about your poor returns. I am curious to know how many loans you have invested in. And how much you invested per loan. Do you mind sharing this?

      Reply
      • Robin says

        December 15, 2018 at 12:31 pm

        I had pretty good returns with 50 or more loans and now at over 130 loans the rate of interest — real life, between 4% and 6%. I don;t think that is bad… better than a savings account , and most CDs of deposit! I also do I bonds, but not certain what interest those give… less than LC but lower risk too.
        When the acct in LC reaches $10K I am going to travel more…
        It’s definitely a fun acct and not my bet the farm account… too risky, not insured…
        With I bonds, you are risking nothing. So far LC out does the rate in my 401K account through work with Fidelity. , but I’m not trusting that kind of $$ to LC P2P !
        They say you need at least 100 loans at various risk levels, in order to offset the risk over the loans! I think that is true. Finally… it feels good to be lending through LC, rather than borrowing from LC… which is how I got started. I borrowed a few times when money was lean, and now I auto invest monthly and the loans to others pile in monthly a few at a time. Very little money “just sits” that way…

        Reply
  11. mark says

    March 1, 2015 at 10:48 pm

    Thanks for the article. I am hoping that you can confirm that I used the formula correctly. I started 2014 with a balance of $4,236 and ended with a balance of $21,925. During the year I made 9 deposits for a total of $16,500. I came up with an interest rate of 3.82%, which is considerably lower than the NAR shown on my account page. Did I use the formula incorrectly? If not, why the huge difference?

    Thanks,
    Mark

    Reply
    • Peter Renton says

      March 2, 2015 at 7:54 am

      Hi Mark,

      The problem here I suspect is cash drag. When you invest your money it takes 45-60 days to start earning interest on this money. This is because it can take some time to find the loans to invest in then it is two weeks before the loan is issued and then payments don’t start coming in for 30 days after the loan is issued.

      I assume that you put the dates in the XIRR formula for the day the money was transferred in and given your large additions throughout the year this 45-60 day lag would be a real drag on your returns. But once fully invested as long as you reinvest quickly cash drag is kept to a minimum.

      Reply
      • mark says

        March 3, 2015 at 9:31 pm

        Perfect, makes sense. Should have thought of that. Thanks for the quick reply.

        Reply

Trackbacks

  1. Five Ways to Improve your P2P Investment says:
    March 20, 2011 at 9:11 pm

    […] the ROI numbers that Lending Club or Prosper provide. Do your own analysis to determine your real p2p lending ROI. Both companies tend to overstate your actual return a little and so it is best to find the real […]

    Reply
  2. My Top 10 Wish List for Lending Club and Prosper says:
    April 6, 2011 at 4:16 pm

    […] that prominently displays your NAR (Net Annualized Return). But what neither company provides is a real world return. They tell you what your return is on the notes you have invested in, but they don’t share your […]

    Reply
  3. Lending Club PRIME Update – April 2011 says:
    April 13, 2011 at 11:55 am

    […] way the that formula is calculated. This is why I always recommend that investors calculate their actual return instead of relying on the Lending Club NAR number. I am still very happy with a 9% return, […]

    Reply
  4. The “Discrepancy” in Lending Club’s Monthly Statements says:
    May 5, 2011 at 2:50 pm

    […] final point. If you want to work out your actual real world ROI, then you will want to ignore accrued interest. The easiest way to do this is to just use the […]

    Reply
  5. Lending Club PRIME Review and the Difference Between NAR and Actual Returns says:
    August 19, 2011 at 12:39 pm

    […] Lending Club provide on their account details screen can be misleading. I have written about the difference between actual return and Lending Club NAR before and I am going to stress this again today. You may look at the screen shot above and believe […]

    Reply
  6. Five Ways to Measure Your P2P Lending ROI says:
    October 24, 2011 at 2:31 pm

    […] have talked about the XIRR() method before and it is my preferred way to determine ROI. By using the balances on your monthly statements and […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Investor Intelligence

Peter Renton's Returns

Investor Forum

Lending Club Review

Prosper Review

Investor Resources

Most Popular Editorials

The Pure Marketplace Lending Model is Dead, the Hybrid Takes its Place

The 2018 Lending Club and Prosper Tax Guide

My Returns at Lending Club and Prosper

Map of Available States for Lending Club and Prosper Investors

Banks and Marketplace Lending Platforms: Ideal Partners?

Subscribe to the Podcast

Subscribe to the Lend Academy Podcast on iTunes
Subscribe to the Lend Academy Podcast
List of Podcast Episodes

Archives

Follow @LendAcademy Follow @LendIt

ABOUT LENDIT FINTECH NEWS

LendIt Fintech News, Powered by Lend Academy, has been bringing you all the news and information about fintech and online lending since 2010 when it was founded by Peter Renton. We not only have the industry’s most active news site, but also the largest investor forum and the first and most popular podcast.

We are a team of fintech enthusiasts who have been covering the industry for many years. With a deep knowledge of online lending, digital banking, blockchain, artificial intelligence and more our team covers the daily news and writes in-depth editorials.

Recent Editorials

  • Marcus Co-Founder Leaving for New Walmart Fintech Initiative
  • Top 10 Fintech News Stories for the Week Ending February 27, 2021
  • Podcast 287: Brad Paterson of Splitit
  • ODX and Fundation Join Forces to Form Linear Financial Technologies
  • LendIt Fintech’s Lending Innovation Summit Europe is Next Week

Copyright © 2021 · Metro Pro Theme on Genesis Framework · WordPress · Log in