The P2P crowdlending Excel spreadsheet can calculate your income, cash flow, risk distribution, XIRR and more. To achieve the highest possible return its necessary for you to actively manage your crowdlending investments, according to your investment strategy. Some of the factors that can reduce your returns are low interest rates, cash drag, increased risks due to unbalanced portfolio, late payments and incorrect calculations from the loan providers. CompareCrowdlending.com has created a free P2P crowdlending Excel spreadsheet that can help you to manage your peer to peer crowdlending investments. You can DOWNLOAD it now or continue reading about the functionalities below(recommended) or watch the youtube video:
One of the main features of the peer to peer crowdlending Excel spreadsheet is the XIRR calculation. The XIRR calculation will show you the yearly internal actual return taking into account the date of your deposits and withdrawals. The XIRR calculation will also take into account the cash drag (time your money was not invested due to the lack of loans on a platform), as well as how delayed loans paid back with or without accrued interest influenced your investment. Consider the following example: You are investing in platform A that offers you 14% pr. year on loans and platform B that offers you 11%. You notice that often on platform A with 14% interest your full sum of money is not invested and you decide to do the XIRR calculation in the Excel calculator. The calculation shows that the real yearly return on platform A is only 9%, making platform B the better choice interest wise.
The old saying goes: Don’t put all your eggs in one basket. The same goes for crowdlending that has risks. By investing all your funds in a few platforms you risk losing a big part of your investments if something goes wrong. The excel calculator will show your distribution between different platforms as well as automatically marking unbalanced investments with different colours to indicate the distribution among them.
Did you ever wonder how much money you would be able to withdraw any given month, without selling your investments on the secondary market, if you simply paused all your investments? The peer to peer excel spreadsheet has all the answers and it will include the cash flow from interest, principal and referral bonuses.
The Excel calculator is completely safe to use. All information will only be stored at your local computer and not on 3rd part servers online. Furthermore, the Excel spreadsheet has been constructed in a way that no unknown VBA code will be running in the background, so you have full control of your own data.
Support to the crowdlending P2P Excel spreadsheet
Instructions are included in the Excel spreadsheet, a Youtube guide is made and there is free e-mail support.
Version 3.00 2020
Features of the crowdlending P2P Excel spreadsheet:
- Prepared for 40+ Crowdlending platforms.
- Easy time-efficient entry of data with colour guidance. (The fastest way to track your platforms)
- Simple, easily customizable design.
- Highly automated calculations.
- Data will only be stored on your own computer and no VBA programming will run any unknown code in the background.
- Includes instructions and support by e-mail.
- Free to download and yours to keep forever.
The dashboard includes the following information:
- Monthly interest income and referral income.
- Graphs for individual crowdlending platforms as well as total values.
- Distribution across P2P Crowdlending platforms including colour warnings.
- XIRR calculations on all individual peer to peer platforms.
- Monthly Cashflow.
- Total sum of money invested.
- And much more..
Sign up to the newsletter to receive updates on the Crowdlending Excel spreadsheet and other crowdlending related news.