arbster
Member of DD Central
Posts: 810 
Likes: 426
|
Post by arbster on Sept 25, 2016 10:35:01 GMT
Having been in P2P fairly actively for about 18 months, I was interested to do a comparison of the interest earned from the various sites I'm invested with, excluding promotional bonuses, but including cashbacks on individual loans, which I consider as part of the overall returns on a particular deal. I've also included known defaults and likely defaults on unsecured loans (ie Lending Crowd and Funding Circle). ABLrate
| 5.20% | Including containers as a loss | Assetz
| 3.44% | Only recently joined and 50/50 30D/GBBA | Funding Circle
| 7.80% (8.3% inc bonuses) | My first P2P site, and largest averaged over the period | | Funding Secure | 7.76% (9.5% inc bonuses) | No defaults so rate doesn't account for accrued interest, but does reflect uninvested periods | Landbay
| 3.83% (10.4% inc bonuses) | Low maintenance | Lending Crowd
| 1.35% (32.3% inc bonuses) | 2 defaults | Moneything
| 11.55% | The star performer | Ratesetter
| 4.22% (5.7% inc bonuses)
| A mix of rates, but too much Rolling and uninvested periods | | Savingstream | 8.89% | Rate includes garden centre as a loss; 11.98% if it recovers fully. |
Anyone else care to share? |
|
adrianc
Member of DD Central
Posts: 10,035
Likes: 5,154
Member is Online
|
Post by adrianc on Sept 25, 2016 14:00:11 GMT
RS - 6.2%
FC - 9.2%
LC - 8.2% (inc bonus), 9.4% (exc bonus, but including interest earned by the bonus... Regarding A****o as a default would take the figure to about 0%, though.)
SS - 11.9% (Sept interest about to be paid)
AC - 8.5% (High percentage has been sat in QAA waiting to get into GBBA, now 20% QAA, 80% in MLIA at 10.5%)
PM - 4.4% (Sept rent about to be paid)
THC - 1.7%
I nearly didn't include PM and THC figures, because they're not really long-term representative, as none of the SPVs have had much more than first payments, with set-up voids and costs. Some of the THC SPVs haven't even had a first payment yet - exclude those, and 2.2%. But they're about long-term capital growth anyway... <crosses fingers>
|
|
ablender
Member of DD Central
Posts: 2,204
Likes: 555
|
Post by ablender on Sept 25, 2016 14:09:10 GMT
How are you calculating these figures?
|
|
adrianc
Member of DD Central
Posts: 10,035
Likes: 5,154
Member is Online
|
Post by adrianc on Sept 25, 2016 14:12:34 GMT
How are you calculating these figures? I have a spreadsheet with a page for each platform, then a summary page for at-a-glance. Current balance, every payment in, every payment out, all with dates. Then use the XIRR function to calculate the interest rate you've actually achieved to date.
|
|
ablender
Member of DD Central
Posts: 2,204
Likes: 555
|
Post by ablender on Sept 25, 2016 14:15:32 GMT
Thanks adrianc , What columns are needed apart from date, amount in, amount out? Amount in/out, do you mean deposits and withdrawals or investments in loans? |
|
SteveT
Member of DD Central
Posts: 6,875
Likes: 7,924
|
Post by SteveT on Sept 25, 2016 14:30:07 GMT
In approximate order of financial significance:
Saving Stream 12.2% (no defaults to date)
MoneyThing 13.9% (no defaults to date, boosted by cashback, etc.)
Funding Secure 8.3% (no write-offs to date; excludes as-yet unpaid accrued interest but includes a long list of overdue loans, so who knows where it will pan out)
Assetz Capital 10.0% (no write-offs to date; excludes as-yet unpaid accrued interest but includes several suspended loans, so again somewhat uncertain)
Ablrate 13.0% (no defaults to date)
Funding Circle 13.6% (mostly historic, from the good old days of early closers and stripping property cashback)
ReBuilding Society 8.0% (fully exited the platform, other than about 8 defaulted loans that I’ve valued at zero)
Lending Crowd 40.1% (but only ever lent £1000 so almost entirely driven by incentive and referral bonuses)
|
|
adrianc
Member of DD Central
Posts: 10,035
Likes: 5,154
Member is Online
|
Post by adrianc on Sept 25, 2016 14:38:02 GMT
Thanks adrianc , What columns are needed apart from date, amount in, amount out? That's all you need to calculate the XIRR - how much you've put to and from each platform, when, and the current balance. Beyond that depends on what else you want to keep an eye on. I sum up the various deposits/withdrawals, and I calculate the %age of total in each platform, %age of return from each platform, "return ratio" (%return/%invested, so I can see that one platform's doing 2x average return) - that sort of thing. The platform, not to and from each individual loan. Let the platform keep track of that sort of detail...!
|
|
ablender
Member of DD Central
Posts: 2,204
Likes: 555
|
Post by ablender on Sept 25, 2016 14:41:30 GMT
Thanks,
In open office the formula for XIRR asks me for a guess, if I say 10 it gives me a set of results around 10 if I give the guess of 12 I will get a set of numbers around 12.
How do I go about setting this?
|
|
SteveT
Member of DD Central
Posts: 6,875
Likes: 7,924
|
Post by SteveT on Sept 25, 2016 14:53:59 GMT
Thanks, In open office the formula for XIRR asks me for a guess, if I say 10 it gives me a set of results around 10 if I give the guess of 12 I will get a set of numbers around 12. How do I go about setting this? No idea. No guess is needed to use XIRR in Excel. Try this set of dummy figures, which should give you an XIRR of 12.15%: 01/01/2014 -2000 01/01/2015 -1000 01/01/2016 -500 25/09/2016 4500
|
|
ablender
Member of DD Central
Posts: 2,204
Likes: 555
|
Post by ablender on Sept 25, 2016 15:00:47 GMT
This seems to work. When I download some data from SS accounts, It is giving me errors.
Edit: I keep the interest on the platform and reinvest it. Do I need to make this a negative (as a deposit) or positive?
|
|
SteveT
Member of DD Central
Posts: 6,875
Likes: 7,924
|
Post by SteveT on Sept 25, 2016 15:03:12 GMT
Make sure all your cash deposits (to the platform) are negative figures, any withdrawals you've made are positive figures, your current total account value (which will include any interest you've kept on the platform) is positive and all your dates are formatted as dates (not text)
|
|
ablender
Member of DD Central
Posts: 2,204
Likes: 555
|
Post by ablender on Sept 25, 2016 15:07:53 GMT
I think I arrived at the fact that I need to include the balance still left on the platform while you were typing your reply. Thanks for the help. I have a small project to work on.
|
|
SteveT
Member of DD Central
Posts: 6,875
Likes: 7,924
|
Post by SteveT on Sept 25, 2016 15:09:44 GMT
I think I arrived at the fact that I need to include the balance still left on the platform while you were typing your reply. Thanks for the help. I have a small project to work on. Yes, the final entry in the column should be today's date and today's total account value (as if you'd magically sold the lot and withdrawn it today)
|
|
bigfoot12
Member of DD Central
Posts: 1,817
Likes: 816
|
Post by bigfoot12 on Sept 25, 2016 15:34:48 GMT
This seems to work. When I download some data from SS accounts, It is giving me errors. Edit: I keep the interest on the platform and reinvest it. Do I need to make this a negative (as a deposit) or positive? Yes the sign on payments has to be opposite that of receipts. The guess shouldn't be that important, it makes the calculation a bit quicker, but you would use 0.1 for a guess of 10%. I use openoffice a lot.
|
|
ablender
Member of DD Central
Posts: 2,204
Likes: 555
|
Post by ablender on Sept 25, 2016 15:42:43 GMT
Thanks guys. I had a go at the information from SS. It is so frustrating. I either get an error or 0% which I am sure is not the correct answer.
I eliminated all the loan buys and sells and capital repayments. I added all interests on a given date and made a single entry. I kept a total for the end one and still does not seem to work well. I'll rest and have another go at it.
Edit and I reversed signs.
|
|
