In this video I outline how to calculate your returns using XIRR, which is one of the more popular ways of calculating p2p lending returns. I also outline some of the downsides to Lending Club’s adjusted net annualized return. This all can be done for free with Google sheets, but it also works with Microsoft Excel. Additionally, Simon from Lending Memo recently released a handy XIRR calculator here (note: no data is collected or saved in his tool). If you have any thoughts on calculating returns or if I have overlooked something, please let me know in the comments!
You can also subscribe to the Peer & Social Lending YouTube Channel. I will be continuing to post more useful tutorials for p2p lending investors.