Nomad
Member of DD Central
Posts: 708 
Likes: 475
|
Post by Nomad on Mar 17, 2020 16:31:44 GMT
Terms of the offer are yet to be added to their website.
|
|
benaj
Member of DD Central
Posts: 4,130
Likes: 1,347
|
Post by benaj on Mar 25, 2020 16:18:44 GMT
My observation after 6 months:
- XIRR 12.16% (Range: 7.8%-12.16%), expect higher return from the latest 14% loans.
- 35 loans invested, 35 loans repaid
- 13 loans repaid with delayed interest (buyback)
- 22 loans repaid on time.
- Withdrawal time: within 1 working day
- Plenty of PL & ES loans available on the platform, no cash drag.
- No change of Deposit Fund account yet.
- My active investment: 0
|
|
|
|
Post by geldregiertdiewelt on Mar 30, 2020 14:26:23 GMT
> 60% of loans in my Lendermarket portfolio are now overdue; looks like "stash the cash" is also their game these days
|
|
benaj
Member of DD Central
Posts: 4,130
Likes: 1,347
|
Post by benaj on Mar 30, 2020 15:30:57 GMT
> 60% of loans in my Lendermarket portfolio are now overdue; looks like "stash the cash" is also their game these days During my testing with the platform, the delayed loans / arrears can be high. Maximum number of loans I held at any time was 10. XIRR ranges from 7.8% to 12.16%, it is below 10% for almost 4 month until the very end of my testing. Loan performance somehow is similar to Lime, where it seems LO is making bulk payment for a batch of loans.
|
|
Nomad
Member of DD Central
Posts: 708
Likes: 475
|
Post by Nomad on Apr 16, 2020 18:50:41 GMT
|
|
|
|
Post by veganline on Feb 1, 2022 19:16:08 GMT
My observation after 6 months: - XIRR 12.16% (Range: 7.8%-12.16%), expect higher return from the latest 14% loans. Does anyone know what to google in order to find guides to calculating returns on spreadsheets? I can download the Lendermarket report as a spreadsheet. I have invested in bits, rather than just once. I'm used to Google Sheets and a bit of Libre Office Calc when feeling adventurous. Reason for asking is that Lendermarket returns are puzzling. I've invested in just the riskiest investments. www.lendermarket.com/summary has "15.1%" in big bold letters, but that's the amount asked-for, so far as I can tell. Underneath it says that half the investments are delayed; paying late, but not late enough for buy-back. www.lendermarket.com/summary shows delayed payments at a tenth of on-time payments, so not much. Suppose that half the accounts are late at any one time, contributing only a tenth, the return should be 7.505% + 0.75% = 8.25% ish The trouble is that I've invested bits over time, and newer loans default less than older loans, so these rules of thumb are probably wrong. Also, spreadsheets came-out after I left school and I teach myself rather slowly how to use them. So: back to the beginning: what should I google to learn how to use a spreadsheet like Libre Office of Google Sheets to calculate returns, as downloaded from www.lendermarket.com/statement "download report" ? Maybe I could ask Lendermarket this question but I am not sure how! Any help appreciated
|
|
Ace
Member of DD Central
Posts: 4,068
Likes: 4,346
|
Post by Ace on Feb 1, 2022 20:01:32 GMT
My observation after 6 months: - XIRR 12.16% (Range: 7.8%-12.16%), expect higher return from the latest 14% loans. Does anyone know what to google in order to find guides to calculating returns on spreadsheets? I can download the Lendermarket report as a spreadsheet. I have invested in bits, rather than just once. I'm used to Google Sheets and a bit of Libre Office Calc when feeling adventurous. Reason for asking is that Lendermarket returns are puzzling. I've invested in just the riskiest investments. www.lendermarket.com/summary has "15.1%" in big bold letters, but that's the amount asked-for, so far as I can tell. Underneath it says that half the investments are delayed; paying late, but not late enough for buy-back. www.lendermarket.com/summary shows delayed payments at a tenth of on-time payments, so not much. Suppose that half the accounts are late at any one time, contributing only a tenth, the return should be 7.505% + 0.75% = 8.25% ish The trouble is that I've invested bits over time, and newer loans default less than older loans, so these rules of thumb are probably wrong. Also, spreadsheets came-out after I left school and I teach myself rather slowly how to use them. So: back to the beginning: what should I google to learn how to use a spreadsheet like Libre Office of Google Sheets to calculate returns, as downloaded from www.lendermarket.com/statement "download report" ? Maybe I could ask Lendermarket this question but I am not sure how! Any help appreciated To calculate the annualised return from a set of irregular payments in Google Sheets you use the XIRR formula. If you google Sheets and XIRR you will find some examples. I don't use Lendermarket, so I don't know what their "download report" looks like, but all you need is a set of dated payments into and out of the account and a present value.
|
|
|
|
Post by wiseclerk on Feb 1, 2022 20:16:49 GMT
this should help on how to do it in Excel
|
|
benaj
Member of DD Central
Posts: 4,130
Likes: 1,347
|
Post by benaj on Feb 22, 2023 12:56:00 GMT
The trouble is that I've invested bits over time, and newer loans default less than older loans, so these rules of thumb are probably wrong. Also, spreadsheets came-out after I left school and I teach myself rather slowly how to use them. So: back to the beginning: what should I google to learn how to use a spreadsheet like Libre Office of Google Sheets to calculate returns, as downloaded from www.lendermarket.com/statement "download report" ? Maybe I could ask Lendermarket this question but I am not sure how! Any help appreciated Lendermarket report is a SINGLE column CSV file, so you need to Insert "DATA" from "Text / CSV" if you are using Excel. www.ablebits.com/office-addins-blog/converting-csv-excel-issues/Calculating XIRR needs two columns, date and transaction amount (negative for withdrawal and positive for deposit)
|
|
|
|
Post by barneywol on Mar 11, 2023 12:01:02 GMT
LenderMarket CSV files actually use a semicolon as a column separator becuase the European standard is to use a comma for the decimal point. Excel *can* be configured to deal with that, but it is hard work, and a pain if you use other "English standard" CSV files. The easiest method, I find, is to drop their CSV files into a text editor and add the line: sep=; at the top. Excel will then use the semicolon (or anything else you specify) as the column separator.
|
|
