Author Topic: Prosper calculater return vs XIRR - how could they be this different?  (Read 1064 times)

esanford

• Newbie
• Posts: 1
Prosper calculater return vs XIRR - how could they be this different?
« on: December 20, 2016, 11:00:10 AM »
I'm assuming (hoping) here that this will be a matter of someone pointing out a mistake I made.  I've been into Prosper ~14 mo, with one additional deposit, rolling all payments into new loans.  Prosper says I'm at 16.47% seasoned.  I finally got around to calculating XIRR (the exact method is outlined in the pic), and it's coming in at 5.53%  Something's wrong here.

Any ideas?  (A few numbers might be slightly different in the pics because the dates are off by a couple weeks).

lascott

• Hero Member
• Posts: 1397
Re: Prosper calculater return vs XIRR - how could they be this different?
« Reply #1 on: December 20, 2016, 04:21:22 PM »
Clearly it is way off. Even looking at it from a basic stand point of \$95,000 invested and \$9,500 gained (taking into account 121+day write offs only) you can mentally see it is not 16%. Heck round to \$100K and \$10K for easy math.  Their gains under the performance section ONLY take into account 121+ day write offs as the bubble text over 'Principal charge-offs:' tells you.  Thus I understand you using LCs % for the <30 and > 30 day notes.

If you click on the (+) it tells you about their 'convoluted' formula that is hard to verify with the numbers they give you.

How do we calculate Annualized Returns?
To calculate Annualized Returns, a total gain or loss is calculated by summing all loan payments received net of principal repayment, credit losses, and servicing costs. The gain or loss is then divided by the average daily amount of principal outstanding to get a simple rate of return. To annualize that rate, we divide it by the dollar-weighted average Note age of your portfolio (calculated in days) and then multiply it by 365. Our Annualized Return calculation includes all Notes issued and sold by Prosper Funding LLC and Prosper Marketplace, Inc. since July 15, 2009.
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y