|
Post by natasha1 on Feb 29, 2020 16:42:00 GMT
Thanks Ace, I have PM you back. Thanks Criston, blender, richv for your super clear explanations.
The figures correct as of today 29/02/20 are:
Date requested: 07/07/2019 Amount requested (on 07/07/19): £98,963.00 Amount received to date: £20,894.20
Interest received to date (before any deduction): £8,138.10 Loan part sales minus purchases: -£114.59 Fees: -£778.17 Defaults: -£2,508.59 Recoveries: £46.08 Net interest so far earned: £4,782.83
Annualised return: 6.5%
Currently still lent out: £65,007.42
My initial investment was £100,500 not £105,500 as initially quoted, that was 100% a typo on my behalf, apologies.
I am no maths expert so I can't understand how I am making a 6.5% return from these figures.
|
|
criston
Member of DD Central
Posts: 1,204
Likes: 628
|
Post by criston on Feb 29, 2020 16:57:27 GMT
Thanks Ace, I have PM you back. Thanks Criston, blender, richv for your super clear explanations. The figures correct as of today 29/02/20 are: Date requested: 07/07/2019 Amount requested (on 07/07/19): £98,963.00 Amount received to date: £20,894.20 Interest received to date (before any deduction): £8,138.10 Loan part sales minus purchases: -£114.59 Fees: -£778.17 Defaults: -£2,508.59 Recoveries: £46.08 Net interest so far earned: £4,782.83 Annualised return: 6.5% Currently still lent out: £65,007.42 My initial investment was £100,500 not £105,500 as initially quoted, that was 100% a typo on my behalf, apologies. I am no maths expert so I can't understand how I am making a 6.5% return from these figures. You sure the amount received to date is correct. If you scroll down your summary page, hit transaction statements, go through all the months looking for 'FC Len Withdrawal' & add them up. Edit. May be quicker to search your bank account.
|
|
|
Post by Badly Drawn Stickman on Feb 29, 2020 17:01:09 GMT
Thanks Ace, I have PM you back. Thanks Criston, blender, richv for your super clear explanations. The figures correct as of today 29/02/20 are: Date requested: 07/07/2019 Amount requested (on 07/07/19): £98,963.00 Amount received to date: £20,894.20 Interest received to date (before any deduction): £8,138.10 Loan part sales minus purchases: -£114.59 Fees: -£778.17 Defaults: -£2,508.59 Recoveries: £46.08 Net interest so far earned: £4,782.83 Annualised return: 6.5% Currently still lent out: £65,007.42 My initial investment was £100,500 not £105,500 as initially quoted, that was 100% a typo on my behalf, apologies. I am no maths expert so I can't understand how I am making a 6.5% return from these figures. I have not been paying very close attention as you seemed to be getting plenty of help....... but assuming you have not made any withdrawals then your portfolio total would be useful information. Then again if you have made withdrawals.....
|
|
|
Post by Ace on Feb 29, 2020 17:19:47 GMT
Thanks Ace, I have PM you back. Thanks Criston, blender, richv for your super clear explanations. The figures correct as of today 29/02/20 are: Date requested: 07/07/2019 Amount requested (on 07/07/19): £98,963.00 Amount received to date: £20,894.20 Interest received to date (before any deduction): £8,138.10 Loan part sales minus purchases: -£114.59 Fees: -£778.17 Defaults: -£2,508.59 Recoveries: £46.08 Net interest so far earned: £4,782.83 Annualised return: 6.5% Currently still lent out: £65,007.42 My initial investment was £100,500 not £105,500 as initially quoted, that was 100% a typo on my behalf, apologies. I am no maths expert so I can't understand how I am making a 6.5% return from these figures. Hi Natasha, From FC's point of view, you invested £100,500 in Feb 2019 and are showing an overall profit today of £4,782.83. A simple XIRR calculation of these figures gives an annual return of 4.75% (assuming all £100,500 was invested on 28th Feb 2019). I think I'm correct in saying that FC's calculated return ignores cash drag, which you are bound to have suffered while trying to get your funds invested. Therefore, FC's return figure will overstate your true return. Also, if you deposited your £100,500 in chunks over a period of time, your return would be higher than the 4.75% calculated. Having said that, your figures don't seem to add up. Do you have some funds sitting in cash that are not included above?
|
|
|
Post by natasha1 on Feb 29, 2020 19:16:41 GMT
I withdraw all money paid back to me as I am investing it elsewhere.
What does XIRR mean?
I am not sure why these figures don't add up. I am giving you all the figures on my FC screen available to me.
|
|
|
Post by Badly Drawn Stickman on Feb 29, 2020 19:39:13 GMT
I withdraw all money paid back to me as I am investing it elsewhere. What does XIRR mean? I am not sure why these figures don't add up. I am giving you all the figures on my FC screen available to me. The money you have withdrawn would be the missing amount then? If you have £8138.10 of interest and £2508.59 of defaulted loans you are in profit. You may also have loans that are late so not sell able, and obviously you are paying a fee to sell the loans. You are not yet (and unlikely to get into) negative territory.
|
|
|
Post by Ace on Feb 29, 2020 20:14:40 GMT
I withdraw all money paid back to me as I am investing it elsewhere. What does XIRR mean? I am not sure why these figures don't add up. I am giving you all the figures on my FC screen available to me. XIRR stands for eXtended Internal Rate of Return. Most spreadsheets have a function for calculating it. It's an accurate way to measure your annualised return when you have investments and withdrawals at irregular time intervals. The figures don't seem to add up because your Portfolio Total (£65,007.42) should equal your Investments (£100,500) plus your Net Earnings (£4,782.83) minus you Withdrawals (£20,894.20). This certainly works for all of my accounts. As others have said, are you sure that you've calculated your withdrawal total correctly? Since the other figures can be taken directly from your dashboard.
|
|
|
Post by natasha1 on Feb 29, 2020 20:32:05 GMT
Are you saying that all my withdrawals added together would the number that would replace the ? in the following equation.
£100,500-(£65,107.35+£20,764.22+?) = £98,963.00
Q.3. does the £20,764.22 include the £4,782.83 of interest received so far?
Q.4. I thought the amount received of £20,764.22 included my withdrawals, is that not the case?
|
|
|
Post by Ace on Feb 29, 2020 20:53:08 GMT
Are you saying that all my withdrawals added together would the number that would replace the ? in the following equation. £100,500-(£65,107.35+£20,764.22+ ?) = £98,963.00 Q.3. does the £20,764.22 include the £4,782.83 of interest received so far?
Q.4. I thought the amount received of £20,764.22 included my withdrawals, is that not the case?
From the figures you gave most recently, the amount you have withdrawn should be £100,500 + £4,782.83 -£65,007.42 = £40,275.41. I thought you were telling us that you had actually only withdrawn £20,894.20, which is why I said that your figures did not add up. Have I misunderstood your £20,894.20 figure?
|
|
|
Post by natasha1 on Feb 29, 2020 20:57:03 GMT
Hi Ace,
Yes, I'm sorry I think you misunderstood me (my figures were poorly communicated). So, this means I must have withdrawn a total of £40,275.41-£20,764.22 = £19,511.19 over many months...
|
|
richv
Posts: 42
Likes: 11
|
Post by richv on Feb 29, 2020 21:02:31 GMT
Are you saying that all my withdrawals added together would the number that would replace the ? in the following equation. £100,500-(£65,107.35+£20,764.22+ ?) = £98,963.00 Q.3. does the £20,764.22 include the £4,782.83 of interest received so far?
Q.4. I thought the amount received of £20,764.22 included my withdrawals, is that then not the case?
Hi Natasha1, I looked at you post a few hour ago and have been thinking this though. I might be wrong but I think I may have worked it out. Where are you getting the £20,764.22 from? it that is the number from 'access Funds' page then its not the full amount. How FC displays information and sells lones change on the 12 December, and that number 20,764.22 will relate to the amount that you have received form 'interest, repayments and recovery' since the 12 December. but (I don't think) it includes money from 'interest, repayments and recovery' before that. By my maths their is £19,410.75 unaccounted for, which will be the amount of 'interest, repayments, and recovery', paid between you putting the lones up for sale on July 2019 and the 12 Dec 2019. while that sounds quite a lot, given you £100,500 investment it would be correct if you had a lot of short 12 and 24 month loans in you portfolio. I don't think that there is an easy way of adding up all of the times that you have withdrawn money. Is it possible that its about £40,000. I hope this does not sound like a silly even flippant, but if you have taken it out in lots of small amounts as it became available and transferred to other accounts???
|
|
|
Post by Ace on Feb 29, 2020 21:02:45 GMT
Hi Ace, Yes, I'm sorry I think you misunderstood me (my figures were poorly communicated). So, this means I must have withdrawn a total of £40,275.41-£20,764.22 = £19,511.19 over many months... Sorry Natasha, but no, if the other numbers are correct you have withdrawn a total of £40,275.41. (Unless I'm still not understanding you 😩)
|
|
|
Post by natasha1 on Feb 29, 2020 21:09:35 GMT
Hi Ace, Yes, I'm sorry I think you misunderstood me (my figures were poorly communicated). So, this means I must have withdrawn a total of £40,275.41-£20,764.22 = £19,511.19 over many months... Sorry Natasha, but no, if the other numbers are correct you have withdrawn a total of £40,275.41. (Unless I'm still not understanding you 😩) richv you are a genius, I think you are absolutely spot on! Thank you. Ace thank you, I must have withdrawn £40,275.41 over many many small withdrawals.
|
|
richv
Posts: 42
Likes: 11
|
Post by richv on Feb 29, 2020 21:12:15 GMT
Hi Ace, Yes, I'm sorry I think you misunderstood me (my figures were poorly communicated). So, this means I must have withdrawn a total of £40,275.41-£20,764.22 = £19,511.19 over many months... It looks like you worked out the same thing I did just as I was typing my last reply. This if correct may also enplane why you 'interest rate' of 6.5% looks bigger than we thought it should, if there was about £20,000 less in the account then we thought then 6.5% looks about right for a £4,782.83.
|
|
|
Post by Ace on Feb 29, 2020 21:14:12 GMT
Sorry Natasha, but no, if the other numbers are correct you have withdrawn a total of £40,275.41. (Unless I'm still not understanding you 😩) richv you are a genius, I think you are absolutely spot on! Thank you. Ace thank you, I must have withdraw £40,275.41 over many small withdrawals. Phew, glad we got to the bottom of it. You could confirm it by adding up all the withdrawals in your bank statements, or by adding up all the withdrawals in your FC transaction statements. They should both add up to the £40,275.41. 😊
|
|