unmadem
Member of DD Central
Posts: 377
Likes: 181
|
Post by unmadem on Jun 8, 2014 17:24:42 GMT
I understand that when you sell a loan part you are still due the accrued interest up to the point it is bought.
Is there anywhere on the site which shows you what you are due for accrued interest on sold parts, and ideally, given the different payment patterns e.g. payment free periods, interest only periods, different amortisation periods etc, when you will receive these payments.
Apologies if it is really obvious but I couldn't see it.
|
|
mikeb
Posts: 1,072
Likes: 472
|
Post by mikeb on Jun 8, 2014 18:41:45 GMT
No, there isn't. It's in the feature-request/todo list, somewhere ...
You need to note the accrued amount just before you list it for sale. Otherwise, if it sells straight away, you'll never know.
You need to visit the repayments page for the loan to see when then next payment is due (or, in some cases, when the final payment is due: for some loans), and note the date there. Then hit sell.
If you are selling via Auto-Invest, you stand no chance of noting these things before the AI kicks in and sells things!
|
|
unmadem
Member of DD Central
Posts: 377
Likes: 181
|
Post by unmadem on Jun 9, 2014 11:02:36 GMT
I was afraid of that.
chris is this on your To Do List ?
At the moment the site effectively under reports lenders returns, which doesn't seems great marketing . Given the large volume of sales you report on the AM it must add up to quite a bit overall.
|
|
|
Post by chris on Jun 9, 2014 11:04:02 GMT
I was afraid of that.
chris is this on your To Do List ?
At the moment the site effectively under reports lenders returns, which doesn't seems great marketing . Given the large volume of sales you report on the AM it must add up to quite a bit overall. I'm aware of it and want to address it but it's not in active development for the next handful of weeks. Likely to be prioritised after that, maybe sooner but don't want to promise.
|
|
|
Post by Jack Barlow on Jun 10, 2014 12:24:26 GMT
Is there anywhere on the site which shows you what you are due for accrued interest on sold parts?
Aggregated accrued interest on owned and sold loan parts can be calculated reasonably easily from the loan parts and statement data that's downloadable from the website. In the "Loan Units" XLS download, enter the following formulas: Cell H1: =SUMIF(E2:E10000,"<>"&"deleted",D2:D10000) [this value is referred to as “A” below] Cell H2: =SUMIF(E2:E10000,"live",D2:D10000) [this value is referred to as “B” below] In the "Statement" XLS download, enter the following formulas: Cell G1: =SUMIF(G2:G10000,"setDef",E2:E10000) [this value is referred to as “C” below] Cell G2: =LEFT(C2,3)&LEFT(D2,3) Copy the Cell G2 formula into cells G3:G10000 (or at least down to the last row of entries in the sheet) Before downloading the "Statement" XLS file remember to set the start date to one that's on or before the date you made your first deposit to your AC account. The values A, B and C represent: “A” – All accrued deferred interest (both paid and unpaid) on all sold loan parts, plus unpaid accrued interest on all currently-owned loan parts “B” – Unpaid accrued interest on all currently-owned loan parts (this figure should tally with the sum of the accrued interest values shown on the "My Accounts" page of the website) “C” – Accrued deferred interest already paid on all sold loan parts Unpaid accrued deferred interest on sold loan parts = A - B - C, which is I believe what unmadem was asking about. The above calculation doesn’t correct for the error in the under-calculation of some deferred interest payments that has been discussed in the "Interest allocation on loans" thread.
|
|
|
Post by Ton ⓉⓞⓃ on Jun 10, 2014 13:17:05 GMT
I'm a little bit backward but any idea which of the exels' this will work with if that isn't a silly question.
Thanks for putting this together!
|
|
|
Post by Jack Barlow on Jun 10, 2014 13:55:23 GMT
I'm a little bit backward but any idea which of the exels' this will work with if that isn't a silly question. Should work in all versions of MS Excel plus latest versions of OpenOffice and LibreOffice.
|
|