benaj
Member of DD Central
Posts: 4,855
Likes: 1,591
|
Post by benaj on Aug 1, 2019 7:35:46 GMT
May be someone could explain more about this total portfolio value better.
On unbolted, Total portfolio value = cash available + investment balance.
Total portfolio value is also the sum of {Net fund transferred} + {Total Interest Paid and Accrued}
A few months ago, I thought the total portfolio value must somehow includes the investment balance and investment balance displayed of each loan must have included the accrued interest. After downloading the my_investment.csv, it does seem to suggest the total investment value include accrued interest.
However, cross examining the transaction history on the loans I recently bought, I am not so sure any more. It seems the current investment in this loan is not the same calculation of past investment in this loan when fully repaid, i.e. current investment in this loan is not the same as invested amount.
|
|
ganymede
Member of DD Central
Posts: 299
Likes: 207
|
Post by ganymede on Aug 1, 2019 9:22:06 GMT
I have this is a spreadsheet. The Loan Portfolio is copy and pasted into spreadsheet with row headings
Loan Reference, Start Date, Due Date, Last Repayment Date, Loan Status, Invested Amount, Repaid Amount, Outstanding Amount (including accrued interest)
Net Funds transferred In
Invested = - (invested(Active)+Invested(Overdue)+Invested(Default)-Repaid(Last repayment Date=None)) Repaid = Repaid(Active) + Repaid(Overdue) Default Recovered Interest = Default(Repaid) - Default(Invested) Repaid interest = Repaid(Repaid) - Repaid(Invested) Quarterly Interest (Go to tax state sum of other income column in monthly split, or search through transaction statements for Bank Interest)
Cash Balance = sum of the above
Investment Balance = sum of outstanding
Portfolio Balance = Investment Balance + Cash Balance
Total Interest and Accrued = Portfolio Balance - Cash Deposits
The my_investment.csv amount is just the outstanding amount for loans with accrued interest that it doesn't include loans that have been fully repaid. It's only ever going to give you a current investment balance
The spreadsheet is a lot more complex as I split down into loan types using matching on these,
*Standard Loan (Gold Trust* *Standard Loan (Provision Trust* *Sale Advance Loan (Provision Trust* *Working Capital Loan (Provision Trust* *Business loan* *Working Capital Loan (not protected* *Standard loan (not protected* *Sale Advance Loan (not protected*
|
|