Latest ROI Results

To my utmost surprise, my only “Late” loan made a payment (wahoo!), so at the moment I have no “Lates”. Of course there are plenty of loans one month late or worse, but without any “Late” loan statuses, I know that at least for 15 or so days there won’t be any more loans falling off the cliff into Collection Agency territory.

I went through and recalculated my Prosper ROI using Excel’s XIRR function today. Here are the results:

ROI: 7.90%

Average Loan Age: 409 days

Total Account value: $27,311

Total Loan value of late Loans: $1,121

When I use the XIRR function, I count all loans one month late or worse, and subtract that from my total account value (giving them $0 value). There are several bankruptcies in there (BK) so it’s fair. Plus, I haven’t had much luck getting any of these baddies to cure. Booo Collection Agency!

I also use the “Loan Value” figure from the Loan Detail page instead of the remaining Principal because there is a bunch of accrued interest in there. Since I’m not counting on these deadbeats to pay me back, I shouldn’t expect to see the accrued interest either.

Here is the Loan Value and credit grade of each of my late loans:

$80 – AA (BK)
$49 – D (BK)
$74 – C (BK)
$89 – A (BK)
$50 – HR
$50 – B
$118 – AA
$129 – C (BK)
$140 – D
$32 – B (BK)
$34 – AA
$60 – D
$62 – D
$32 – C
$56 – C
$64 – B

Even AA grade borrowers can be deadbeats and not pay back their Prosper loan. Booo deadbeats!