Love it :t_up:
Printable View
I don't look at Harmoney NAR, as it is very limiting as Alistair says. It may help compare poster portfolio performances withing Harmoney, but it is meaningless for comparisons across P2P platforms (more so, after Payment Protect).
XiRR is a superior measure for cross platform comparisons, but in a growing portfolio the difference between XiRR and other methods like yours, can be remarkable (back of envelope calculations, although I haven't checked your method fully yet).
You are also right in pointing out leesal, that XiRR does not account for accrued income, but then it is a tool made to measure performance based on actual historical cash movements. So, not an exact tool for what you are trying to achieve.
Inclusion of payment protect inflates not just Harmoney NAR but also XiRR heaps, in growing portfolios. Beware
lmao, you are not as smart as you seem to think you are.
Like I said in my earlier post, the only issue is how to handle the outstanding principle. That's the only difference.
You have some weird way of valuing this, based on the average interest it will get, expected defaults / arrears etc.
I have just treated is an outgoing payment on the last date. I even said that.
I would question your knowledge on IRR / XIRR when you can't see the difference is simply down to how the outstanding principle is handled, instead you think its something do to with the calculation itself.
Also you are only 4 months in (iirc), your loan portfolio is like a new born baby, you will have a low default rate and hence a high RAR / Xirr, wait til its 16 months in like some of ours and those defaults start hitting lol.
Hes essentially doing a basic Xirr calc like anyone could, but trying to forecast out the "true" value of his outstanding principle, which I have found from experience messing around trying to forecast what that might be based on harmoneys reported default stats / interest rates, just doesn't work out, cause suddenly your portfolio gets a year old and defaults blow up lol.
Cheers Beacon, well put.
If you isolate payment protect loans only. XIRR will show 40-50%... Massively inflating your return if using the method Alistar_Mid is using.
Never said I was clever. However unless you have largely avoided payment protect loans - your XIRR will be overinflated.
The rest of my tool is technicality (although correct). It enables some cross checkign against RAR. Once I've gone through a cycle of loans, I'd be happy with 7%.... Who knows whats to come
How can I put this, you are not anywhere close to as smart as you think you are.
Once again, the only difference is how we value the outstanding principle. The rest is sourced from Harmoneys record of deposits / withdrawls.
Because you can't seem to see this, and think its something to do with the Xirr calc itself, I can only conclude you don't know how Xirr works.
Please guys: mind the personal stuff. It detracts from the discussion.
Just for info: First loan 8/2/15
Total cash in $90,169 progressively increased from initial $2,000 - total portfolio value $108,619
RAR 13.85% on 31/12 and that's the highest it's got to
Last financial year actual return on all money excl accruals 14.50% - this year dropped to date as suffered first write offs ($668)
current running yield on today's balances 17.04% before any costs
Nice edit of your earlier post....
Post tax bumps up your return. Harmoney automatically deducts their fees and then pays tax on your behalf. But their fees are tax deductible so they have effectively made you pay more tax than you should have. You then have to claim this back + claiming defaults as bad debts if you feel inclined (jury is out on that), so your post tax return is certainly more than your pre tax.
Your'e already confused because of the difference of how we handle outstanding principle - you seem to think its do to with the Xirr calc itself, now you seem to have the tax round the wrong way.
https://media1.tenor.com/images/f50d...6712/tenor.gif
Every time you take a payment protect loan HARMONEY credits your account a small amount.
HARMONEY then adds this balance to your outstanding principal. So you take out a loan for say $1000 with pp, and you will see your outstanding principal increase by say 40. Unfortunately for us this isn't really money.
So if you are comparing your return against say lending crowd, using XIRR, you've got to at the very least strip off the payment protect part.
Since your not prepared to explain your methods I've not looked very hard at them...
Nothing you're saying is new. The topic of the influence of Payment Protect has been covered before. Simply removing it from calculations will result in undervaluing as it has a positive return due to interest gained. I think everyone is very aware that the Harmoney RAR value is very different from XIRR (no matter how you calculate it).
Accrued income has very little impact on a portfolio with even a little maturity and in my view is completely pointless to consider in the big picture of the investment.
Have been trying to....
The method I am using to value Payment protect, is earning out the "unearned principal" over the life of the loan
accrued income is more of a technicality - but extremely important for anyone with a portfolio less then half a year old
Removing Withholding tax enables a comparison against RAR.. And just better form in general, as everyone has different withholding tax rates.
**** Be aware though - In the spreadsheet I've included formula for withdrawals, and defaults ... I've never had either, so don't know how harmoney output this data on the extract
Agreed. It is quite important in growing portfolios of over a year maturity too, regardless of the platform ...
However, myles is right that in mature portfolios (ie, maybe reinvesting returns, but not investing substantial new capital) accrued capital diminishes in importance with portfolio age.