Monday, July 16, 2012

One Year of Lending Club: The (Getting) Ins and (Getting) Outs of Lending Club

Well now, I was hoping to be further along before this post than I am. I intentionally (this time it really was) did not post last most. I considered it my quiet period as I was liquidating.

My one year experiment with Lending Club has led me to the following for those who do not live in a "funding state":
  1. It is easy and quick to get going in Lending Club, although I would recommend buying in slowly to get the best performance
  2. It is easy and very slow to get out of Lending Club (sold 150 Notes over two months)
  3. Learn how to find Pre-Grace Period status of Notes
  4. Don't hold on to Grace Period Notes and hold no hope for Late Notes (it's just better that way)
  5. There are three very different markets: A/B, C/D, E/F/G. I focused on E/F/G most of the time. My conclusions may not hold as well for the other two markets.
  6. Both High Yield To Maturity and Low Markup buying techniques work well
  7. Lending Club's Net Annualized Return is only valuable to compare against other investors and to track historical changes, the number itself is pretty much meaningless
So yes, I am really liquidating my Lending Club account (just about finished now). This was an experiment with my play money and it is now time for me to pull all my cash together to buy my mother-in-law a house. I will invest in Lending Club again when all this house thing settles out.

I also wanted to be able to report on what it is like to get your money out of Lending Club (a concern for many). You can do it. It will take time. I am selling them off at about 2 to 3 Notes a day on average.  I offer my Notes for sale at either 16% Cash-on-Cash-Return or a specific Markup, which ever leads to a lower price. I started with a 3.9% markup, and dropped it to 3.4%, 2.9%, 2.4%, 1.9%, 1.4% and now 0.9% markup. When I noticed that I was not selling 2 to 3 Notes a day, I would lower my Markup by 0.5%. I am not selling any of my Notes at a loss (except any Grace Period Notes, but those are becoming rare as my portfolio shrinks). 

It is weird not going in and buying Notes anymore.

This has been a terrific experience. I have really enjoyed working with the P2P lending community, especially Peter Renton of Social Lending Network. There is so much great information out there to learn.

If you run across this post and are considering Lending Club as an investment, might I make a few suggestions:
  1. Read all you can. My blog, Social Lending Network (BTW Peter has a course you can buy that should give you plenty of information), etc.
  2. Start investing right away. Don't wait until you have all the details.
  3. Start small. As you gain experience (and make mistakes) your educational process will accelerate. You will not learn enough from reading alone, and you want your mistakes to be with a small portfolio.
  4. Make mistakes, but try not to make my mistakes (or Peter Renton's, etc. learn from us). Don't be afraid to make mistakes.
  5. Share what you learn. Start a blog (free at blogger.com) and share what you are learning. Link to great sources of information you've found.
  6. Get involved. The P2P lending community has several great leaders in it. Follow their twitter accounts. Read their blogs. Circle them on Google+. Comment. Share. Be part of the discussion.
This is not goodbye, but until next time. I've had a great time. I look forward to coming back and investing in Lending Club.

Signing off for now.

- Marc

Tuesday, May 15, 2012

Ten Months on Lending Club, Brutal Reality Hits

I missed a month on reporting how my Lending Club experience was going. I could say I was extremely busy (I was) but it was probably more coming to grips with brutal reality. Right after I posted on my Eight Month Results, my NAR dropped to 6.0%. I think that was the result of my Defaults finally all going to Charge Off status.

I'm slowly climbing my way out of those Charge Offs. I've learned how to avoid them by avoiding any Note that even smells of a Late payment. I check the Loan Performance page for every Note that is Processing payment (sort my Notes by Payment Due Date and open each in a new Tab in Chrome). I don't buy Notes that are more than 20 days since last payment (saves me having to look at the Loan Performance page).

My portfolio has also changed quite a bit, not so much from trying to avoid Defaults, but due to a shift in strategy caused by using Lending Club Chrome Extension. Until I can bake into the Sale Price my risk factors (feature yet to be added), I don't buy as risky of Notes. Instead I look for discounted Notes. It turns out that the most discounted Notes tend to be Grades D, E and F (although F not quite as much).

When I buy Notes, I look for Notes that meet the following criteria:

  • have a Yield to Maturity of 16+%
  • no more than $25 Outstanding Principal
  • no more than 20 Days Since Payment
  • I don't already own a Note of that Loan

I then get the most steeply discounted (or least marked up) Notes that meet that criteria. The Chrome Extension makes this really easy to filter for (even if there is a lot of clicking "Next").

Once I have my Notes, I immediately offer them up for a price that gives me (after taxes and fees) 18% annualized gain, unless the Note is in pre-Grace Period or Grace Period, in which case I discount it to sell. I was offering my Notes at 16%, but they were selling too quickly. At 18% I tend to offer my Notes at 1.5% to 3% markup (depending on what kind of Discount/Markup I had).

I divide my Notes into two main Portfolios (four actually, but most Notes are in two). My newly acquired Notes that have not made more than one payment (I call them Buttercup) grew tremendously when I offered my Notes to get 16% annualized return. Since raising my expected annualized return to 18%, the two portfolios have balanced out and are now about half each.

My Buttercup portfolio is mainly split between D and E Notes. It looks like before the D Notes hit their second payment, they have a 50/50 chance of selling at those discounts.

The other half of my portfolio (Wesley) contains Notes that have made at least two payments. These are mainly F Notes, followed by D and E Notes. I'm happy to see that the higher yield Notes are sticking around longer (they don't sell). To recover from those Charge Offs, I need an accelerated return, like the 19.41% Wesley brings in.


So in two months I raised my NAR from 6.0% to 9.36%. I've heard rumblings that NAR is pretty much meaningless. I think it is an easy way to measure the direction you are going in, but I agree it has no real world value. I wanted to find a better overall metric for myself. I settled on Annualized Cash on Cash Return. The way I calculate it is treat my account as a closed box bank account. If I put my deposits in a bank (and taking into account withdrawals) what APR would that account have to have the balance I have now.

The cash equivalent balance I have right now is an interesting thing to figure out. You can start with your Account Total (on your main Account page), but that doesn't take into account Notes you've purchased today (I tend to have a half dozen to two dozen purchases pending). The cash for those was transferred from Lending Club to FolioFN to purchase the Notes, but FolioFN hasn't reported the Notes back to Lending Club yet. So I add in the purchase price of pending purchase Notes.

This CCR calculation really opened my eyes as to how bad the NAR calculation is. My annualized CCR after ten months is -2.45%. If I were to sell my Notes for their Outstanding Principal + Accrued Interest and cashed out my account, I would have less money than I put in. Now 8 Charge Offs and dumping a bunch In Grace Period Notes to clean out your portfolio can have a devastating affect, but I was not expecting that. Now that I have a way to track my CCR, I'll be watching that. It does get better daily, so I like the direction it's heading in. What scares me is what it would have looked like two months ago.

So bottom line is I am digging myself out from the Late Notes that went to Default and clearing out a bunch of In Grace Period Notes at steep discounts. Things are getting better (noted by the NAR rising and the daily improvement in my CCR). I've got two months until my one year anniversary. We'll see what kind of CCR I can come up with in the meantime.



Friday, April 6, 2012

Lending Club Chrome Extension: Buying FolioFN Notes

(See Other Posts about Lending Club Extension)

Version 0.3 of the Lending Club Extension has been released (see what changed). I am getting feedback that we need more detailed information about how to use it.

(click on this link in Google Chrome)

The first step is to click on the link above and go through the installation process (you may need to click a button at the bottom of this page saying you trust me, you do trust me don't you?). After you have installed the extension, you will see a Lending Club icon in your browser window. Clicking on this will bring up a settings window. If it feels a bit cramped, you can get a bigger page with the settings by clicking on the wrench (spanner) in the upper right corner (shown in the image here) and selecting Tools -> Extensions. 

In the extensions list you'll see Lending Club FolioFN Note Filter (I need to change that name). The image below shows what it looks like (except it will be version 0.3 and it won't say (Unpacked)).

If you click the Options link you'll get the same options you would get by clicking the Lending Club icon at the top of the window, but you'll have more space to look at things like Help.



There are two main features that this extension helps you with,  Buying Notes and Selling Notes. 

Buying Notes (or Note Filters)












When buying Notes on the FolioFN platform, you'll see a table that looks something like the above. When the Lending Club extension is working, the table will have green rows (if not, there will be blue rows). There are some limited, though helpful, filters already available on FolioFN, seen in the box before the table. I usually choose the Never Late checkbox and uncheck the rest and leave everything else as is. Once you search with the FolioFN filters, then it's time to pull in the extension filters.

Clicking on the Lending Club icon at the top of the window will reveal a window with the extensions filters. They mostly match the column headers (and in the same order) as seen in the Browser Notes list above.

Some values have a Min/Max, for instance Days Since Payment. Let's say that you want Notes that are about to make a payment, but not so close that it is processing just yet. You would enter a Min of 18 and a Max of 24 (I've seen some Notes start processing 25 days after the last payment).

Any Notes that have Days Since Payment at 18 through 24 will be left untouched. If the Days Since Payment falls outside that range, the extension will look at the Out Of Range Color box to decide what to do.


Clicking on the popup menu next to the Out Of Range Color box for Days Since Payment will reveal options for actions to take. By default (empty box) the filter is disabled, meaning it will do nothing if it is outside the range. You can Hide Notes that are outside the range (you won't even see them). This will fill in the Out Of Range Color with six 0's (000000).

The rest of the options for Out Of Range Color are actually colors. These set the background to the selected color. The value that is filled in the Out Of Range Color box is of the format RRGGBB for the Red, Green and Blue value in web format (two digit hexadecimal values). Don't worry, you don't have to know what any of that means, you can just select from the menu the background color you want. The numbers and letters in the boxes are for those who want absolute control over the colors. Feel free to play around with them (6 characters either 0-9 or A-F).


There are four items that do not have a Min/Max, Duplicate Loan, Loan Owned, Note Owned and Imperfect Status.

Duplicate Loan

The second time (or more) a Loan Number is seen on a page, the Out Of Range Color will be applied. This helps prevent purchasing multiple Notes from the same Loan.

Loan Owned

If you own a Note from this Loan (either this Note or another Note) the Out Of Range Color will be applied. The is another help to prevent buying Notes from Loans you already own.

Note Owned

These are the Notes you actually own. Lending Club replaces the checkbox with a little blue circle so you can't select them anyway. If you select Hide Note (000000) for the Out Of Range Color then this noise will be removed from the table (you can't buy it anyway).

Imperfect Status

There are two statuses that are considered perfect, Current and Issued, anything else is considered Imperfect. This allows you to highlight or remove Notes that are In Grace Period or Late.

The selections above are what I use when I am hunting for Notes to buy. I remove all chances (well, nearly all) that I will buy two Notes from the same Loan (Duplicate Loan, Loan Owned, Note Owned). I don't care if Term is 36 or 60 months, so I leave that alone. I only want Perfect Status, so I hide all Imperfect Statuses. I don't want to buy Notes that are processing a payment, so I highlight in Light Red any Notes 25 days or more since the Last Payment (this helps filter out people selling Notes in Pre-Grace Period). I always want a Yield To Maturity of at least 16%.

What settings do you use? Are you having any problems or something is not quite clear? Have a suggestion to improve the extension? Leave a post below and I'll see what I can do.


Lending Club Chrome Extension Version 0.3

(See Other Posts about Lending Club Extension)

It's taken longer than I expected (partly because I got sucked into Empire Avenue, ticker MARCPAGE). Then Peter Renton (of Social Lending Network fame) pointed out that the extension doesn't work well when selling Notes that have been Funded as opposed to Purchased on FolioFN. As I am in a state that I cannot fund Notes, I wasn't sure exactly how to handle this. With Peter's help we've come up with a pretty nice solution.


Install Note Browser Filter 
(click on this link in Google Chrome)



First, a little background. When selling or repricing Notes, the extension will add two extra columns, one for Annualized Return and one for Markup. The Annualized Return is the return you would get if that Note was sold between now and the Order Expiration Date for the given price, taking into account how long the Note has been held. In other words, if you put the money into a bank account with an APR of the Annualized Return, and left it in there for the same period of time as you held the Note, you would get your Asking Price when you withdrew the money.

In order to do this calculation, the extension needs to know when you acquired the Note. If you purchased the Note this month via FolioFN, it will get this information from the My Account page (just visiting this page will get these dates). If you purchased the Note in a previous month, you can find the purchase date in the Trading Statements at the bottom of the FolioFN My Account page (change Showing Notes to All). again simply loading these pages once the extension will store off the purchase dates for the calculation.

However, if you did not purchase a Note from FolioFN, I now get the acquired date from the Loan Performance page (just about every Note on any page has a link to this page, see the Current links in the images below). Loading the Loan Performance page will store off the Issue Date for use in the calculation.

In version 0.2 there was a bug where if we could not find the purchase date, the two extra columns would be added, but they would be left blank. Now we will fill in the Markup right away (we can calculate that from the data on the page). While loading the acquisition date we now let you know what we are doing.  Once we have finished our search for the acquisition date, we simple state "Purchase Date?" to let you know that the extension has not seen any page that lists the Issue Date nor the Purchase Date. At the point you can go to the My Account page and then the appropriate (or all) Trading Statement(s).

If an Issue Date is found but not a Purchase Date then the Annualized Return will be blue to let you know that it hasn't seen evidence that you purchased it, so it is assuming you funded the Note (plus an extra row will be added to the top of the table letting you know what blue means).


Saturday, March 17, 2012

Lending Club Chrome Extension Version 0.2

(See Other Posts about Lending Club Extension)

After using it myself for almost a week, I'm proud to announce version 0.2 is available for install (see Alright, I'm Ready To Share for original announcement).

Install Note Browser Filter 
(click on this link in Google Chrome)


So let's start in with some of the changes. Next to the Out of Range Color boxes there is now a popup that allows you to choose from preselected colors, hide the matching Note or disable that filter altogether.


I've found this handy when I want to temporarily disable a filter and then reenable it, specifically when I have change left over in my account, I don't expect to get 16% Yield to Maturity on $12 Notes.



You'll notice there are a few more links. These each open a section on this page. Opening the Preferences section allows you to set your Short Term Tax Rate (with a link off to a site where you can look it up), your Minimum Preferred Gain and the discount you want to give on Grace Period and Late Notes (in my experience all Late Notes are the same, hard to sell). Why would the extension need to know this information? Glad you asked.

Now when you Sell or Reprice Notes, two new columns are added giving you the Annualized Return and the Markup. As you modify the values, those columns also update with the new values. The Annualized Return is based on the date you bought the Note (more about that later, see Caveat below) the Order Expiration Date (at the top of the table) the Asking Price, the Payments To Date, the Maintenance Fees, the Sell Fee and estimated Taxes (see Can Someone Check My Math? for details on the calculation).


As an example of what happens when you change the values, the snapshot of the table below is identical to the table above except I pressed the Principal + Interest button at the top of the table. Notice all the Markups went to zero and the returns were adjusted accordingly.



Another cool feature is that if any of the Asking Price fields are every empty (deleted) they will be filled in with the value that will give you your Minimum Preferred Gain from the Preferences. For the Sell Notes page, this will automatically fill in every Asking Price (since they start out blank) with a value that will give you your Minimum Preferred Gain (or Discount based on Grace Period or Late of the Note). When Repricing Notes, just delete the value in the Asking Price box and it will fill it back in with the appropriate value. This feature alone saves so much time. When you have 80 Notes you want to put up for sale, determining what you want the sales price to be and then entering it in can be mind numbing.

Caveat

In order for the Annualized Return (or the Asking Price) to be calculated, the extension has to "see" the purchase date on one of FolioFN's web pages. If you visit FolioFN's My Account and the Note shows up there as purchased (this month) then it will have seen the purchase date. However, if you purchased the Note in a previous month, you'll need to go to the bottom of the My Account page and look at the Trading Statement for the month that you purchased the Note and then change the Showing Notes to All.

All you have to do is view these pages after installing the extension. It will remember the purchase dates of all the Notes it sees. What I did to get things kicked off is open each Trading Statement in a new tab and then went to each tab and changed Showing Notes to All. Then I closed all the tabs. Do that once and the extension will remember all the purchase dates.

Feedback and Donate

I've added to other links, Feedback and Donate. The Donate link just gives an Amazon.com affiliate link you can use to show your support for the extension (or alternately PayPal information). I've spent all the time I really need to for my needs on this. I'll be using the donations as a gauge of how much time I'll spend adding requested features and improving the extension.

The Feedback link will send you back to this blog. For suggestions, problems, questions, etc. just leave comments on this blog.

I hope this helps make FolioFN a more usable part of the Lending Club experience (especially for those of us that FolioFN is the main part of Lending Club we can use). Let me know what you think.



Thursday, March 15, 2012

Eight Months on Lending Club

(See other Monthly Status Updates)

Already another month. My NAR keeps dropping like a rock as Lending Club is coming to terms with those Late Notes that will never pay as they move them to Default and Charge Off. I had almost a dozen Notes that went Late. One completely paid the Note off. One came back into payments (and then I was able to sell the Note). I think I sold another couple.

Even though the graph looks depressing, I am optimistic. I have realized what I have done wrong, and how to prevent future Late Notes (which nearly inevitably lead to Defaults and Charge Offs). Since the first wave I have only had one more Note go Late.

As I peruse the other P2P Lending Blogs (see several excellent ones to the right) it seems that 12% NAR is considered pretty good. It's definitely better than than the Stock Market (see Why You Should Invest in the Stock Market) but my target is 16% or higher, mainly to offset the effects of real inflation (see Not All Inflations Are Created Equal). I'm confident I can get back to 16%.

Once I learned the ropes of Lending Club, I wanted to make sure that the time I was spending on investing was not offsetting my gains (unless your time is worthless, you need to consider this). Now that I have the Chrome Browser extension (see Alright, I'm Ready To Share), I feel like I have finally been able to bring down my time spent to a reasonable amount. Before I used this extension, I was only looking at Lending Club 3 days a week to cut down on the time I spent investing. Selling Notes used to be my biggest time consumption, and that was manually entering dozens (even more when I went to 3 days a week from 6) of sell prices from my spreadsheet. Now my extension enters them all for me (coming in version 0.2).

I'm back to 5 to 6 days a week, but it is a 5 minute checkup as opposed to 10 to 15 minutes. And the time spent will not grow dramatically as I scale up my portfolio. I was having a hard time seeing 400 let alone 800 Note portfolio before. Now I can easily see it.

I've now sold 3 times the number of Notes I currently hold (churn). My Notes held average $24.88 and I've held them on average for 2 1/2 months. The Notes I've sold I've held for just over 3 weeks. My median return on sold Notes is 28.8% annualized, or 38.2% days weighted annualized (the longer the Notes been held, the more weight it is given in the average).


The average rate for my Notes held is over 21%. This is a snapshot. I tend to sell off higher Interest Rate Notes, so my held Notes is a little lower, but we'll get to that later.




Almost all my Notes are 60 month Notes. I prefer it this way. I try to buy Notes with a lot of Principal left, which means that the payments are mainly Interest. 60 month Notes have even more Interest since the Principal is spread out over a longer period.



This is a natural side effect of how I choose Notes. I look for Notes with good Yields, and 60 beats out 36 just about every time.





Overall Composition

I always get concerned when I look at this chart. I really don't like holding G Grade Notes, but I have more G Grade than E Grade (I'd rather the reverse). I do like to see that the majority of my Notes are F Grade (in my opinion best Risk/Return balance).

The D and B Grade Notes are the stragglers when I have less than $25 left to invest, then I go find a good Yield Note with less Principal and these can often be lower Grade Notes.

The nice thing about having portfolios is that you can analyze your Note in different segments (see How I Use Lending Club Portfolios). You'll recall I had separated out my fairly newly purchased Notes from those that I had received at least 2 payments from (my Buttercups and Wesleys, respectively). This helps me see how my buy and sell strategy plays out. I buy irrespective of the Note's information just on it's raw Yield or Discount. It could be a Note that has a plunging credit score, lives in Florida, leveraged to the hilt, only on the job for a month, high debt-to-income G Grade Note, and I'd still buy it because it has a good Yield to Maturity.

However, when I sell is when I look at the details of the Notes. That G Grade Note will get sold for near 16% annualized return markup. While the Notes I would rather keep, the F Grade 10+ year employed, home owner, from Oklahoma, get a higher, closer to 32% annualized return markup. So let's see how that affects my portfolios.


Buttercup

The Buttercup portfolio are the Notes I've recently purchased (and haven't gone bad in any way). As you can see, it skews highly towards the G Grade Notes. This is a symptom of buying Notes based solely on Yield To Maturity.

If you compare this graph to the overall composition graph, you'll notice that I sell many of the G Grade Notes before they reach a second payment.










Wesley

My Wesley portfolio are the Notes that I've held for at least two payments and have not started missing payments. This is what I like to see in my portfolio. Overwhelmingly F Grade Notes, followed by E Grade and a few G Grade Notes (and a smackling of smaller Grade Notes).

Notice I still have an over 20% Weighted Average Rate, but I am more heavily invested in F Grade Notes, which have a lower Default Rate than G Grade, and have a higher average Yield (see Low Risk, High Return Lending Club Strategy).



Strategy Change

I have three buying strategies I use. The first is Newly Issued High Yield to Maturity 60 Month Notes (see the bottom of Seven Months In And Things Are Slowing Down). The second is High Yield to Maturity only. The third is Highly Discounted over 16% Yield to Maturity.

I used the second strategy the most heavily for the longest and have been using all three lately. However, until I get my extension to add risk factors to selling prices, I'm probably going to have to focus on the third strategy (Highly Discounted). Many of the seasoned veterans use this method (although not necessarily limiting it to above 16% Yield to Maturity) and have called into question the High Yield to Maturity model. Without my risk based selling prices, I think I'm going to have to agree with them. Plus Now I have a tool that allows my to visually see Discount vs. Yield to Maturity (see Discounted Notes on Lending Club's FolioFN).

Conclusion

So the effects of the Late Notes from the end of last year are finally starting to show in my Net Annualized Return. We'll see when I actually hit bottom on that. As long as I can prevent future Late Notes (which eventually lead to Defaults and Charge Offs), which so far has been pretty successful and will only get better with the Chrome Browser extension, I think I can climb back up to 16%.

I'm excited about the time savings I am getting from using the Chrome Browser extension. It makes the process so much more fun (less tedious) and cuts my time spent "investing" dramatically. It cuts the time down so much, I feel like I still need to do something when I'm done, 5 minutes is not very long.













Tuesday, March 13, 2012

Discounted Notes on Lending Club's FolioFN

On Peter Renton's blog post Changes Today to the Lending Club Trading Platform on SocialLending.net, user @stilltrackin noted that discounted Notes seemed to be harder to find as of February 2012. After I started using my Chrome browser extension I added discounted Notes to my buying strategy. I hadn't been buying discounted Notes for around 6 months and noticed that they seemed to be a bit thin.

When I view Notes, I filter out Notes with principal less than $15 or more than $25, Notes from the same Loan and Notes with less than 16% Yield to Maturity. With those filters, in 1,300 of the most discounted Notes (22 pages at 60 each), I only found 42 that met that criteria and were marked up less than 3%. There seemed to be a pattern so I threw the values into a spreadsheet and came up with this graph, which shows Yield to Maturity on the Y-axis and the discount on the X-axis.
Remember that this is a selection of what I consider premium Notes (see the criteria I mentioned above). It is interesting that there are a handful of Notes right around par and then nothing until around 2%. It is possible that someone is rapidly snatching up everything under 2% markup. 

Now let's look at the Notes from 14% to 16% Yield to Maturity. There are 59 Notes in the same 1,300 or so Notes that have this Yield to Maturity. In this range there is nothing below 1% available. The distribution looks very different than the 16%+ distribution. I stopped at 14% because the number of Notes starts getting larger the smaller Yield to Maturity you get.
If you stack the two graphs you can start to see a boundary of Discount for each Yield to Maturity. I think this is the balance between two Lending Club investment philosophies, Yield to Maturity vs Discount. 19% Y2M Notes seem to sell well at a markup of 2% or less because both types of investors are looking for them (has a low Discount and a high Yield to Maturity). It seems 15% is the low end for markups as high as 2%. I would need more data to be sure (note the three near-zero markup 18.5% Y2M Notes).

This will be one of the things I will start tracking and posting about. When I have more time, I'll delve more into the lower Yield to Maturity Notes.

What are your thoughts?

Update 03/13/2012 @ 12:17pm Central

So I pulled data from the top 1,200 discounted Notes with Yield to Maturity of 6%+. The data is in the graph above. There are a little over 600 Notes from unique Loans that have never been Late, over 6% Yield to Maturity and under 3% markup. The blank spots to the left of the graph probably indicate good markups for quick sales, as there is little competition in that area.

What conclusions do you draw from the chart above?