ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 25, 2017 15:15:31 GMT
£6000 allocated asked for £10000.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Lendy (L) in Administration
Mini bond
Jan 24, 2017 12:52:55 GMT
Post by ganymede on Jan 24, 2017 12:52:55 GMT
kadhim , I think when SS said the Bond allows investors to indirectly participate in the peer-to-peer marketplace without any active management I think that they meant management by the customer.
The proposed bond will definitely not be a passively managed fund in the normal sense: it will be actively managed by SS and thus carries the associated cost and, presumably, a lower risk. Thus it naturally has a lower return.
The proposed bond is an actively managed fund, relieving the investor of the trouble, and is thus more expensive than the traditional SS P2P investment where the customer manages the investment and carries the extra risk associated with being a non professional investor. I'm not sure the risk in the bond is lower. After all it's just a loan to the company. Here's how it seems to me. Anyone funding loans directly is exposed to: a) the risk a loan will go bad; b) the risk that the platform will go bust. In an ideal world, the risk of b) would be zero/minimal because the platform would have a backup servicer in place. Anyone lending to the platform so that it can invest in loans would seem to have the following things to consider: a) loans might go bad; b) you don't know what loans you're exposed to; c) the platform might go bust. In this case, the 'going bust' risk is not zero/minimal because you have no security over the company and no direct recourse to the underlying loans. Just think of the advantages, the mini bond has over the investors. No Recaptcha restrictions. 24/7 internal robots picking from SM market for the bond. Manipulation of SM Market, removal of better loans from the market. Better access to information. Fuller take up of loan allocations. If £100 allocation might see some select £10 some selecting well over £100. Now if all those in the bond get the full £100, then it proportioned amongst the bond holders larger holders of the bond effectively get many times the normal allocation of £100. I probably haven't thought of all the ways. I wouldn't be concerned about looking at the merits of the mini bond, I would be very concerned what the mini bond means to existing investors.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 23, 2017 18:55:43 GMT
Being tied to a single Provider is not the type of IF ISA I want. Could have multiple IF ISA's, and shift funds around, but it's not going to be simple, expect a lot of paper work to do so.
I want a single point of call for S&S ISA and IF ISA to allow P2P loans from multiple providers.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Lendy (L) in Administration
Mini bond
Jan 23, 2017 18:40:02 GMT
Post by ganymede on Jan 23, 2017 18:40:02 GMT
Seems like our money isn't good enough for them! Perhaps they didn't want the forensic digging ( cooling_dude ), the less than enthusiastic mutterings ( oldgrumpy ) or the inevitable difficult questions (from too many to mention) that an open invitation might bring. Little did they realise....... On the other hand, it might just be that they recoginse that a mere 6% won't sufficiently excite hardened 12%ers! I sold off some of my corporate bonds - what I call proper bonds that appear on ORB. Was getting 5-6% returns on those but could sell on ORB for a capital gain. This was to provide extra funds for P2P only makes sense to realize the capital gain and give up the 5-6% for the higher rates of return. Mini bonds if they are fixed term, and have high exit charges, or no SM. exit route I would avoid. I wouldn't be selling off Corporate Bonds to replace with mini-bonds. Bonds on ORB can also be held in existing S&S ISA and SIPP's. No waiting for an IF ISA, no being tried to a single providers bond offering. What we wanted wasn't an IF ISA but an extended S&S ISA that also allowed P2P loans or bonds from any provider providing they meet some standards. These mini bonds only really compete with Bank and Build Society fixed rate savings bonds on providing a better deal without the same guarantees. They could also compete with Cash ISA's fixed term offerings if provided through a IF ISA. Especially as marketed as if they are Bank and Build Society fixed rate savings bonds.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 14, 2017 11:45:29 GMT
The calculation for payments per month for £100 @ 12% over 24 months is
=12% * 100 / (12 * ( 1 - ( 1 + 12% / 12) ^ (-24)))
which gives £4.70734722... round to 2dp is £4.71
or you can use the excel function
=-pmt(12%/12,24,£100)
rate = 12%pa / 12 = 1% per month nperiods = 24 months pv = present value
Overall interest is
=24*£4.71 - £100
£12.976333... rounded to £12.98
If 12 months into payments then balance was £52.95 using £4.71
=12% * £52.95 / (12 * ( 1 - ( 1 + 12% / 12) ^ (-12)))
which is £4.70435678
if you know payment is £4.71 then balance is
£4.71 = balance *12% /(12 * ( 1 - ( 1 + 12% / 12) ^ (-12)))
balance = £4.71 * (12 * ( 1 - ( 1 + 12% / 12) ^ (-12))) / 12%
Using £4.71 gives £53 using £4.70434722 gives £52.98155768
so can also do
12% * £52.95 / (12 * ( 1 - ( 1 + 12% / 12) ^ (-12))) = 12% * 100 / (12 * ( 1 - ( 1 + 12% / 12) ^ (-24)))
£52.95 = £100 * (1 - 1.01^(-12))/(1-1.01^(-24))
That gives £52.98155768... the 0.03... difference is because of rounding £4.70734722.... to 2dp in calculating £52.95.
For LTV. Initial LTV = Value / Loan (Principle) x100 %
LTV at N months = Value / FV x100%
FV = -fv(12%/12, N, pmt(12%/12, 24, Principle), Principle, 0)
N =datedif(Start date, now(), "m")
balance today would be something like this in a single cell
FV = -fv(12%/12, datedif(Start date, now(), "m"), pmt(12%/12, 24, Principle), Principle, 0)
LVT for a single cell it would be something like this
LVT = Value / -fv(12%/12, datedif(Start date, now(), "m"), pmt(12%/12, 24, Principle), Principle, 0)
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 14, 2017 0:41:21 GMT
ablrate how is the amount of the capital repayment calculated? Do these types of loans pay back all of the capital during the loan term and is simply the capital divided equally by the number of payments? or are the capital payments a set percentage of the balance but not designed to have repaid all the capital by the term of the loan? Is it possible to determine the capital outstanding at a particular time point in a loan? Eg half way through life of a loan there is only 50% capital to repay? Would I be correct in thinking the LTV would decrease during the life of a loan? Yes capital is all paid back, no it's not capital / payments. If starts at £100 12% over 24 months, then £100 x 12%/12 = £1 of interest. The monthly repayment is £4.71, so £3.71 of capital is repaid leaving £96.29 of capital, next month interest is £0.9629 payment is still £4.71 so £3.75 of capital is repaid. The 24th month all capital has been repaid. Yes it is possible to determine the capital outstanding at any point through the life of the loan. The Excel fv function can be used. =-fv(12%/12, 12, -£4.71, £100, 0) £52.95 capital outstanding after 12 months Yes LTV does decrease. If value is constant, but value can change also over the period of the loan.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 13, 2017 10:34:52 GMT
I got £8500 allocation, under the total allocation asked for.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 12, 2017 16:53:33 GMT
My allocations. 157 £5000 158 £850 ganymede : Did you pre-fund for more than £5k of PBL157? Yes £6k on both.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 12, 2017 16:40:36 GMT
My allocations. 157 £5000 158 £850
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 3, 2017 14:16:54 GMT
My account history, click on show filters, select interest repayments, set a from date, then to date. Click on search. Now download into spread sheet, and sum the interest payment column. Just in case your manual notes fail. Results might be 1p out due to rounding. Took me longer to type the post to the forum than to find Decembers interest paid. Thank you for your very quick post. It is, as you said, extremely easy to find total paid interest for the month. How do you calculate how much December interest was what you 'earned' above the accrued interest you already purchased across many individual loan parts on the SM? Edit - to clarify, my first investment is recorded as 49.97 for 50.00 whereas I need to know that it was discounted and included 0.40 interest bought in that month's interest. (I'm a non-tax payer and am only interested in my return on total purchase costs.) Whilst I have to waste time on FS I can at least glean this across My Current Investments, Investment History and Account Movements; for ABL I can't even see this information is available. The accrued interest is a different problem, has been asked for already - some thread on the tax calculations. I don't know if it's available. However I do keep records, and the e-mails from ALB, with subject "Ablrate - you have been matched to offers" contained the accrued interest. So yes in this case I keep a record in my own spreadsheet. There is a filter for accrued interest just no data. This comes down to if ABL recorded the accrued interest amount and it can't be seen, if it's there in another database table then it should be possible to join two tables together to get the accrued interest and interest. There is a basic principal either the accrued interest is recorded or there is a mean to recalculate, you never throw information away from financial transactions. If email sent are kept then, ABL could scan e-mails (record keeping / backups). For Trade Date, Loan ID, Accrued Interest plus e-mail address for the user id. To create/recreate the database table. Same way I could select and export e-mails then scan my e-mails for the fields. Could, I don't have enough to warrant that effort myself. Here a simple start. $ awk -F ": " '/(Trade Date|Loan ID|Accrued Interest)/ {print $2}' Ablrate\ -\ you\ have\ been\ matched\ to\ offers.eml 20/12/2016 21:24 1000017 £0.05 Just exported one SM trade email...
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 3, 2017 12:26:04 GMT
The clear, easy ability to see how much interest I have earnt for the month above any amounts bought. I thought FS was a pain having to reconcile different sets of data, for ABL I had to use historical, manual notes! My account history, click on show filters, select interest repayments, set a from date, then to date. Click on search. Now download into spread sheet, and sum the interest payment column. Just in case your manual notes fail. Results might be 1p out due to rounding. Took me longer to type the post to the forum than to find Decembers interest paid.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 3, 2017 11:45:53 GMT
Mine are n**r I bid on AE504 for £5, followed by BPF600 for £238 the rest of the funds I had available, was £2000 of BPF600 available. Think I bid on something else before these, but had all gone my the time I entered the bid. I am using a single browser window for MT, all manual no bot's used.
Moving on, seen two renewals in the MT pipeline, my renew boxes ticked, doubt will be much left to bid on. Need to transfer over more funds to MT. SS interest credited so asked to withdraw funds, as nothing worth while available. SS funds appeared this morning in current account.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 2, 2017 9:59:12 GMT
I managed to pick up a some yesterday, just happened to login and about 4 loans on SM. Ignored the football stadium. Used up the funds from a repaid loan, and interest. Most the time there has been nothing on the SM. I didn't need a bot. Well done to u , l can't seem to find anything. Do you mind if l ask what time u got it around? From loan BPF600 recent investments tab... z***4 £1,160.00 01/01/2017 20:02:38 f***a £102.00 01/01/2017 20:02:29 n***r £238.00 01/01/2017 20:02:27 z***4 £500.00 01/01/2017 20:02:15 z***4 £8.00 01/01/2017 13:51:26 n***r £12.00 01/01/2017 06:36:49 Will be looking again as just credited with some more interest.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Jan 2, 2017 9:06:58 GMT
I managed to pick up a some yesterday, just happened to login and about 4 loans on SM. Ignored the football stadium. Used up the funds from a repaid loan, and interest. Most the time there has been nothing on the SM. I didn't need a bot.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Lendy (L) in Administration
Payment
Dec 24, 2016 9:00:31 GMT
Post by ganymede on Dec 24, 2016 9:00:31 GMT
My payment to resolve negative from yesterday deposit confirmed e-mail arrived 24/12/2016 07:51, dated 24/12/2016.
|
|