kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 26, 2017 19:15:49 GMT
I see no reason for your XIRR not to be an average of the return figures shown on the loan details as long as you keep your money invested in loans. As already discussed in different thread even in the case that you are constantly invested to 100%, all loans have the same interest rate and there are no losses your XIRR will be different from the interest rate.
p2pindependentforum.com/thread/7733/applying-xirr-payment-schedule
At least with Twino I can replicate the exact XIRR as quoted by Twino simply using all transfers in/out of the account and the value of the account as of the current day. I apply the Twino method to all of my platforms for a comparision. Always the initial ramp up takes time to climb but then approaches the true return as the initial time makes up a lower and lower proportion of the total time. As with Mintos though, the payouts use the Principal*Interest/Number_of_Days method.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 26, 2017 16:15:43 GMT
Based on your stats I took the plunge and allocated 100€ to each of the classes A, B and C a few weeks ago. I've never seen an A but who knows?
So far, all of the C's have had one payment except for 1 who is late. B's are only just coming up but the first one is paid. According to Twinos predicted returns of 16% on C's, I calculate that we can expect the equivalent of ~1.5 total defaults per 10 loans so I guess these early indicators are on par.
Total Defaults / Return
0 / 140€ 39.58%
1 / 126€ 25.62%
2 / 112€ 11.66%
3 / 98€ -2.29%
4 / 84€ -16.25%
5 / 70€ -30.21%
6 / 56€ -44.17%
7 / 42€ -58.13%
8 / 28€ -72.08%
9 / 14€ -86.04%
10 / 0€ -100.00%
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 26, 2017 15:59:51 GMT
Hmmmf. In typical German fashion, I would have to go to the post office to identify myself .
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 26, 2017 13:48:13 GMT
I don't think it's Germany only though. I my profile, I can choose which country and also "Steuerinländer" vs "Steuerausländer" (native taxpayer vs foreign tax payer).
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 26, 2017 13:41:45 GMT
Woohoo that's me then! I can add another site to my collection.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 26, 2017 13:33:04 GMT
There will always be a cash drag effect of not having anything earned for the first month or so. As time goes on, this month becomes a lower proportion of your total investment time. What I would expect to see the XIRR slowly approach the weighted average interest as more time goes on.
Since Twino give you the interest on the day it's due regardless, the buyback doesn't effect this. You only see a spike when lots of loans pay out around the same time, and a bit of a decline on days that have no payments.
From your XIRR vs average figures, my guess would be that you are only about 2 months in if you deposited a lump at the beginning.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 25, 2017 13:59:40 GMT
A welcome addition apart from the €500 requirement before you can set what interest rate you will accept and other criteria. I cant see why it is not set at €50 which is the minimum for manual investing. It's because us lower class users with a measily amount of investment funds do not deserve to be able to select investments based on our own criteria. In any case, us wretches probably don't understand what we are doing anyway and should just take any loan that shows up.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 24, 2017 11:11:45 GMT
to set filters by credit rating (in fact practically any of the given data) Logically if you give us the data then why not let us use it to filter offerings? Mintos do this well, copy them. Yes this is something really lacking. At the moment, if you want any investments at all you are forced to take 8%. Having to swallow 8% is pretty bad when returns elsewhere are higher, but having to do this with no regard for the risk category is a stretch too far.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 23, 2017 23:33:01 GMT
Great thanks that works.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 23, 2017 22:16:11 GMT
I have replicated the interest payments using Principal*Interest/360*Days. I then use the figures to get an XIRR but then (I think) change the compounding interest rate to a non-compounding one using NOMINAL(). The documentation on NOMINAL() does seem to follow the formula you gave so I think that I should be getting the right answer.
I have tried the same method to more or less replicate the YTM on loans in the secondary market, but I am always a few tenths of a percent off.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 23, 2017 21:03:45 GMT
I raised it and they fixed it. To be fair I've reported a few issues and they have addressed them pretty quickly.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 23, 2017 12:55:55 GMT
To answer my own question, it was a bug apparently and ViaInvest have now fixed it. Buybacks should now always occur at >30 days late (i.e. 31 days late).
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 23, 2017 11:15:58 GMT
If I take loan 476321-01 with a rate of 11% and try to reconstruct the interest rate from the payment schedule using XIRR, I always calculate a little too much interest. Can anyone see what's wrong? 28/12/2016 | -€743.28 |
| 28/01/2017
| €252.32 |
| 28/02/2017
| €252.32 |
| 28/02/2017
| €252.54 |
| XIRR
| 11.74%
| '=XIRR(B1:B4,A1:A4)
| NOMINAL | 11.10% | '=NOMINAL(B5,360) |
I thought that maybe it was a rounding error but when I try different loans I get a similar result. There is something systematic I am not taking into account.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 23, 2017 8:52:22 GMT
Anyone have experiences with a ViaInvest buyback? I have my first one go 30 days on Friday 20th. It's now 23rd and nothing has happened. Does the weekend get in the way?
I am used to Twino where a buyback happens exactly at 12am at the end of the buyback day without fail, so I don't like the lack of predictability.
|
|
kulerucket
Member of DD Central
Posts: 336
Likes: 93
|
Post by kulerucket on Jan 22, 2017 8:23:50 GMT
I use cryptsync to do enycrpt sensitive information to Dropbox/Onedrive etc. Moving 50GB is a couple of days syncing at most so it's not really an issue. I've done that a few times as services such as copy.com ended. In any case though, I mostly just use Google sheets for things I don't need such a level of protection (e.g. P2P tracking) so backups are not an issue.
|
|