-
14-10-2018, 04:05 PM
#3871
Member
Originally Posted by myles
Attempted explanation a few posts back - calculated by grouping loans with same estimated default values (i.e risk grade) - it is not time based. Different Scorecard risk grades had different estimated default values so make up different circles.
In case it's not clear, each loan has the Estimated Default Rate recorded with it - so calculation is similar to all other bar charts, but annualised as per Harmoney's estimated rate.
Gotcha, and on the other side - the actual default would be the total # of defaults / cumulative # of days of all the loans.
How do you add up paid off / charge offs? Is it taken to current date, or date of repayment/default?
-
14-10-2018, 04:36 PM
#3872
yeah, nah
Have a read of the Harmoney and Lending Club definitions - I linked to them above.
No cumulative # of days, just number of days / 365.25.
Defaults are all 'Charge Off' + 'Debt Sold' vs everything except 'Cancelled' loans.
The final date was the query I was asking about before - Harmoney don't appear to do the same as Lending Club. Lending Club takes it back an arbitrary 120 days, Harmoney take from first to last (that's my interpretation of what their wording). So first loan start date to last loan payment date is what I'm using (I actually had max(start date) - min(start date), but have 'fixed' that to max(last payment date) - min(start date) and it has shifted the scatter pretty much under the line in lower risk grades - high risk grades are off the line (i.e. lower default rate on high risk grades then estimated).
It seems a pretty rudimentary way of calculating it, but it appears to be the way it is done...
-
14-10-2018, 08:02 PM
#3873
yeah, nah
-
15-10-2018, 09:50 AM
#3874
Member
As its currently proposed harmoney could end end up caught up in this too
https://www.interest.co.nz/personal-...erson-test-and
I cannot find a definition of who they define as "high-cost lenders"
However if we just look at interest and fees alone in the combined data set there 11 Unique loans where interest paid to date is greater then amount invested - Key point to rember is is only what has been paid todate - the real number will be alot higher once loans reach full term. Also as proposed the 100% cap includes all fees as well as default charges
"Interest and fees on high-cost loans will be limited to 100% of the amount borrowed (the loan principal). Thus if an individual borrows $500, they will never have to pay the lender back more than $1000, including all fees and interest, the Government says. This will only apply to "high-cost lenders" with the aim being to prevent unmanageable debt and financial hardship from accumulating large debts from a small loan.The idea is that even if the borrower defaults, they would repay no more than twice the original loan principal, including interest, default interest, and all fees. "
-
15-10-2018, 10:02 AM
#3875
Member
heard on the radio (but havnt seen in writing) that high cost was defined as interest rates greater than 50% per annum.
Highest at harmoney was 39%, dont know if that is the case now..
Last edited by IntheRearWithTheGear; 15-10-2018 at 10:05 AM.
-
15-10-2018, 10:06 AM
#3876
Member
Originally Posted by myles
Putting this up a bit early. It includes the two updated csv files that were put up today. The data set summary on page 4 should be correct for the unique.csv file which is what all of the charts are based on.
I've dropped off the last chart as it seemed to be causing some confusion, will revisit it at a later time.
Please note the warning in the summary about comparing values to annualised values.
I can claim the largest loan There is a story behind it - it wasn't meant to be - moral of the story - don't get distracted when purchasing loans. I've given up sweating over it, if it defaults it will hurt a bit, but not too much now
summary.pdf
unique.csv
raw.csv
Enjoy!
Fantastic effort Myles. Lots of top notch analysis which will help shed valuable insights, to help optimise our loan selections, even should the economy does head towards more turbulent times.
Am comparatively an excel hack compared to your DB charting skills, but heres a lone graph that some may find useful.
It tracks lifecycle stats by month of initiation. Stats are all as a % of initial capital invested. eg int% = total interest earned to date for mmmyy loan/ total investment made in mmmyy
Also the "arrears" figure I've taken is my own calculation of "principal at risk" (being the entire principal outstanding of loans more then half a payment in arrears). In addition I don't rely on HM judgement on arrears. Happy to share how I calculate if requested.
Second graph shows remaining principal in $ value. Use this as a measure of future potential (eg potential for further interest / further defaults). Months with less then 10% principal outstanding should have minimal change to Int/Charge off.
Thirdly is a measure of clear interest %. Being Interest earned less principal in arrears less defaults (no HM fee). Note it is not annualised, but over the period of the investment (which given the high early repayment would probably work out as annual anyway!).
Attachment 10071
-
15-10-2018, 10:33 AM
#3877
Member
Once again, many thanks Myles for your time and effort and producing a fantastic top-notch and very professional report.
-
15-10-2018, 10:37 AM
#3878
Member
Originally Posted by leesal
Fantastic effort Myles. Lots of top notch analysis which will help shed valuable insights, to help optimise our loan selections, even should the economy does head towards more turbulent times.
Am comparatively an excel hack compared to your DB charting skills, but heres a lone graph that some may find useful.
It tracks lifecycle stats by month of initiation. Stats are all as a % of initial capital invested. eg int% = total interest earned to date for mmmyy loan/ total investment made in mmmyy
Also the "arrears" figure I've taken is my own calculation of "principal at risk" (being the entire principal outstanding of loans more then half a payment in arrears). In addition I don't rely on HM judgement on arrears. Happy to share how I calculate if requested.
Second graph shows remaining principal in $ value. Use this as a measure of future potential (eg potential for further interest / further defaults). Months with less then 10% principal outstanding should have minimal change to Int/Charge off.
Thirdly is a measure of clear interest %. Being Interest earned less principal in arrears less defaults (no HM fee). Note it is not annualised, but over the period of the investment (which given the high early repayment would probably work out as annual anyway!).
Attachment 10071
Thanks for sharing Leesal. Interesting charts
-
15-10-2018, 11:49 AM
#3879
Thanks Again Myles
Originally Posted by myles
If you find the secret to selecting the perfect loans, please share.
If you see a loan for a Caravan, you might be onto a good thing
Enjoy!
Watch out for owners doing home improvements
-
15-10-2018, 12:28 PM
#3880
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Bookmarks