Author Topic: Calculating return for lending club notes bought on FolioFN (secondary market)  (Read 1721 times)


  • 5 O'Clock Shadow
  • *
  • Posts: 1
I just started using lending club and it sounds like the annualized return won't be accurate for notes bought through FolioFN.
Is this correct; if so, does someone have a spreadsheet or something to easily calculate this value?



  • 5 O'Clock Shadow
  • *
  • Posts: 10
Hi David, I'm a p2p lending blogger and currently use XIRR to calculate my overall returns (both newly listed and from the secondary market) - although I do not sell notes on FOLIOfn which may make things a little more tricky.  I believe you can use IRR as well, but I'm not as familiar with it.  I outline how I use XIRR here: