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:
XIRR Calculation
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.
Risk distribution
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.
Cashflow
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.
Security
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.
DOWNLOAD THE PEER TO PEER EXCEL SPREADSHEET HERE
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..
DOWNLOAD THE P2P CROWDLENDING SPREADSHEET NOW
Sign up to the newsletter to receive updates on the Crowdlending Excel spreadsheet and other crowdlending related news.
24 Comments
Søren N
June 16, 2019 - 7:45 pmThanks for a great tool for keeping track of my platforms.
Took me a while to get the XIRR calculation to work, but after reading the instructions I figured it out.
DMO
July 8, 2019 - 11:20 amThanks a lot for your great blog and excel file
Very Usefull
Jim N
September 4, 2019 - 6:08 pmThanks for a great blog and this great tool.
Would like to track my portfolio over more than one year – can the spreadsheet be expanded for that purpose?
CompareCrowdlending.com
September 4, 2019 - 10:57 pmDear Jim,
Thanks for your feedback.
The Excel sheet is fully customizable. Its possible to edit the file yourself to include more than one year. Its however not recommended, since you will end up with some very big graphs and you might lose overview. But if you have a big computer screen and you prefer it that way then its possible. Would recommend you to check back in the nearest future when a new even easier to use version will released.
søren
September 8, 2019 - 8:16 pmso far I have tried to use the sheet . I just need to put in : start month account value & added/withdraw-ed funds during the month & and end month account value and ould like to get the roi ( xirr) for that month calculated . pls advice thx
CompareCrowdlending.com
September 8, 2019 - 9:24 pmDear Søren,
Thank you for your comment. Please start by reading the details instructions in the first tab in the Excel file. Its called Instruction (start here). The guide will walk you through all steps. If you still have challenges then, please drop me a message via the contact form here: https://comparecrowdlending.com/contact/ and I will help you to get it up and running at once.
Andre Butter
October 1, 2019 - 8:13 pmIs it possible that in addition to “total invested sum” you also calculate the XIRR of the “total invested sum?
CompareCrowdlending.com
October 1, 2019 - 11:32 pmDear Andre,
Yes it’s possible, but not included in the current version. I will release the next version soon with a lot of improvements including the possibility to calculate the weighted average of XIRR on all investments. Consider signing up for the newsletter not to miss out on the new version. If you need this function added to your current Excel file then write me a message via the contact form.
Radoslav
January 20, 2020 - 12:15 pmHi,
Is there a new version for 2020.
CompareCrowdlending.com
January 20, 2020 - 10:17 pmDear Radoslav,
You can use the same file for 2020. Just change the year.
I would however recommend you to wait a few days until I release the newest version. It supports more platforms, has a better design, gives you a better overview and the best part is that data entry is even faster.
If you are interested in testing it before I release it then drop me an e-mail.
P
February 23, 2020 - 4:26 amCould you make the same thing but as a Google spreadsheet?
That way it’s accessible from multiple devices and safely stored in the cloud, no risk of losing the file if something happens to my computer!
CompareCrowdlending.com
February 23, 2020 - 12:03 pmThanks for the feedback. I will write it on the todo list. I recommend using programs like Dropbox, so you always have a backup and can go back a few versions if something happens + you always have access to an offline version. But I will definitely look into it.
P
February 23, 2020 - 1:40 pmThanks for replying to my comment!
I also forgot to mention that i’m on macOS, I tried opening the file with Numbers (the excel equivalent) but it looks like it’s all broken (i haven’t tried to input any values though). Google spreadsheet would make it available to all investors 🙂
What would you recommend using in the meantime? portfolio performance or something similar?
CompareCrowdlending.com
February 29, 2020 - 12:55 pmThanks again for your comment. I will be looking into google sheets.
I don’t have much knowledge about “Numbers” on Mac, but I think it should be possible for you to build something simple there using the XIRR formula and some graphs. If you sign up for the newsletter you will be the first one to hear when there is news regarding a potential Google spreadsheet version.
lars
February 3, 2020 - 5:24 pmI don’t mind testing the new version
CompareCrowdlending.com
February 3, 2020 - 10:02 pmI will send you a copy by mail. All bugs are almost removed.
Miguel Ferreira Pinto
February 5, 2020 - 1:54 pmHow can I find out the monthly amount received as interest and principal on Twino, for example?
I’m having trouble finding these amounts.
Thanks for the fantastic instrument.
CompareCrowdlending.com
February 6, 2020 - 9:00 amDear Miguel,
Please use the contact form to send your question and I will assist you. I hope to keep the comment section clean for support questions.
The next version (that are in the final testing phase) will include a Youtube video.
CompareCrowdlending.com
February 22, 2020 - 7:47 pmVersion 3.0 of the Crowdlending Excel spreadsheet is now ready to download.
CompareCrowdlending.com
March 4, 2020 - 10:07 pmIf you need support with the Crowdlending Excel spreadsheet, please use the contact form on the homepage : https://comparecrowdlending.com/contact/
and not the comments box here.
Simon
July 7, 2020 - 11:17 pmThis is a great tool! I also use it to visualize my (group) housing investments and stocks (ETF’s).
The interest is easy to visualize if the account value changes – but when only receiving dividends, I add the value as a “referral bonus” to the spreadsheet. If would be cool if it showed as an interest rate as well. How do you guys do it?
CompareCrowdlending.com
July 9, 2020 - 11:32 pmThanks for your comment Simon. Glad for also found use for it to stocks.
I will get back to you via e-mail not to fill the comment section with support questions.
Wizard1966
September 30, 2021 - 3:05 pmThanks for this super easy excel sheet. just the thing i was looking for.
Almost all my invests are in € but some are in RUB any plans to add other currencies ?
Will there be any update version in the future still ?
I’m using this excelsheet on a daily basis thanks very mutch.
CompareCrowdlending.com
October 4, 2021 - 10:31 pmGlad you enjoy the spreadsheet. I am working on a new version and trying to collect all the feedback I am receiving from the users. If you write me directly via the contactform I can guide you how to use multicurrencys in the Excelfile.