As you have probably seen we’ve been actively updating our cash flow page. It has been our engineering team’s priority over February and March to execute the feature improvements that you have been requested. We hope that the cash flow page serves as a great analytical tool for you and becomes the go-to place to get an overview of payments coming in and out of your portfolio – either historical, actual or future.
This time we’ve decided to present the latest cash flow updates on video. Come on a tour with us and leave your feedback in the comments if this kind of video communication is something we should start doing more often.
New features on the cash flow page
- 1. Historic and future cash flow is combined into one table
- 2. Historic payments are split between current loans and loans in default as per the status active at the date of the payment
- 3. Day-level data that shows cash flow categorized per each investment
- 4. Forecast settings can be defined also for historic schedules so you can use cash flow based adjustments for predicting future payments
- 5. You can adjust your net return calculation based on the forecast settings defined in the cash flow report
- 6. Cash flow report will show the opening cash balance and closing cash balance for each period
- 7. Ability to define which data series to show on the chart and in the cash flow table
- 8. Historic planned schedules are split between current loans and loans in default
- 9. Cash flow table results can be exported to Excel
- 10. Account statement for the last 24 hours from Expert Center is incorporated into the cash flow report
- 11. Ability to filter to a specific loan in the Investments list straight through the cash flow report so you can quickly take loans off Secondary Market or put them there based on the information visible in the cash flow report
And on the dashboard
- 1. Custom bid size
With this feature you can set the custom bid size on your own to any amount as long as it is divisible by 5. - 2. Spare cash balance
With this feature you can specify the amount of money your portfolio will keep on your account as available funds.
Great work, I really like it!! Thanks !!
Just a quick question: if I take all the monthly cash flows sice origin of one of the loans in which I’m invested , and then try to calculate the rate with XIRR in Excel, I find for some cases a significantly different value from the rate specified for the loan. How is that possible (in one of the examples I took, it went from 28.26% (rate specified on Bondora) to 32.15% (rate calculated with XIRR)? Happy to give the loan id or my calc file if it helps answering
Thanks! The difference comes from day-count conventions. Loan nominal interest is applied using convention 360/30 whilst XIRR uses actual convention Actual/Actual.
More information in Wikipedia https://en.wikipedia.org/wiki/Day_count_convention
Pärtel,
one step into the right direction after many so many disappointments,
ideas for the cashflow checking page
– for the graph only: make a checkbox “cummulate data” for each category in order to see how each incremental per period adds up to the total.
– make a Checkbox “check/uncheck all” per column
– add a pulldownmenu to select the tax on the income and include it in the life time return calculation (as this is the most neglected aspects of a “true” net return rate)
– add : total Debt at Default (=EAD1) (not just the Debt according to the repayment Schedule)
add: total outstanding debt (not just the Debt according to the repayment schedule)
YaCop
Many thanks Arne. Added all of these to our backlog!
Thanks, Pärtel, that’s right, when I redo the calc with XIRR using hypothetical dates for the cash-flows by adding increments of 30 days to the date of origin of the loan, I indeed find back the rate of 28.26%.
Do I understand correctly that the return shown in the dashboard is also calculated with XIRR, thus with the actual dates and not the 30/360 convention? Then, if I had only the loan to which I referred in my portfolio, and if all payments come on date foreseen, the dashboard will show a return of 32.15% instead of 28.26%? Right?
Also, on the cash-flow page, what I would like to see is the opening balance projected taking into account the future cash-flows.
Nominal interest rate understates the actual cost of capital especially in case of shorter periods. Therefore for borrowers we show (and law requires to show) APR which is calculated with XIRR logic. If everything happens as scheduled then the XIRR of a loan or portfolio is always going to be higher than the nominal rate. This however does not affect the actual cash flows as projected cash is projected cash and the way interest/xirr is calculated does not affect it anymore after the schedule is already set.