Understanding Your True P2P Returns
XIRR Explained
Your platform says you're earning 12%. But are you really? Learn why XIRR is the gold standard for measuring your actual P2P investment performance.
The Problem with Platform Returns
You shouldn't rely on the return percentages you see when logging into your P2P platform. Here's why they often differ significantly from reality.
Platform Reported
12.0%
→
Actual XIRR
10.0%
Difference: 2.0% lower than reported
Why Platform Returns Are Misleading
They ignore uninvested cash
A €10,000 account with only €5,000 invested at 14% earns roughly 7% overall — but platforms report 14%.
Cash drag kills returns silently
Typical investors lose 1-2% annually to cash drag — money waiting between loan repayments and reinvestment.
They use projected, not actual, losses
Platforms estimate defaults optimistically. Your real defaults may be higher than their projections.
Secondary market distorts numbers
Buying loans at discounts or selling at premiums isn't properly reflected in their NAR calculations.
What is XIRR?
XIRR (Extended Internal Rate of Return) is your money-weighted return — it calculates the annualized return rate that makes the present value of all your cash flows equal to zero, accounting for exact dates.
Think of XIRR like a GPS that calculates your average speed for a road trip — it doesn't just divide total distance by total time, it accounts for when you were actually driving versus stopped at rest areas.
Dates Matter, Not Just Amounts
€1,000 invested on January 1st contributes more to your return than €1,000 invested on December 1st.
Annualized & Comparable
Whether you've invested for 3 months or 3 years, XIRR gives you a yearly rate you can compare to any other investment.
Your Personal Reality
Unlike platform rates, XIRR reflects YOUR actual experience — including cash sitting uninvested.
XIRR vs ROI vs IRR vs TWR
Each metric answers a different question. Understanding when to use each helps you evaluate investments correctly.
| Metric | Time Value | Cash Flow Timing | Output | Best For |
|---|---|---|---|---|
| ROI | N/A | Total return % | Quick, simple comparisons | |
| IRR | Regular intervals | Annual rate | Monthly rent, fixed payments | |
| TWR | Between cash flows | Annual rate | Comparing fund managers | |
| XIRR Recommended | Specific dates | Annual rate | P2P, SIPs, real portfolios |
ROI
IRR
TWR
XIRR
RecommendedXIRR (money-weighted) measures your actual returns. TWR (time-weighted) measures how the investment performed regardless of your cash flows. For P2P investors who control their deposits and withdrawals, XIRR is the right choice.
How XIRR Works
The math is complex, but the concept is straightforward:
List Every Cash Movement
Record each deposit (as negative) and withdrawal (as positive) with the exact date it happened.
Add Your Current Value
Include today's portfolio value as a final positive entry — this represents what you'd get if you withdrew everything today.
Find the Rate
XIRR iteratively finds the annual rate where these cash flows, discounted to present value, sum to zero.
Calculate It Yourself
You can calculate XIRR in Excel or Google Sheets with a simple formula:
Formula Syntax
=XIRR(cashflow_amounts, cashflow_dates, [rate_guess]) Example:
=XIRR(B2:B5, A2:A5, 0.1) Getting It Right
- ✓ Deposits = negative (money leaving your bank)
- ✓ Current value + withdrawals = positive (money coming back)
- ✓ Getting #NUM! error? Add a guess like 0.15 or 0.25 as the third parameter
- ✓ Result is a decimal — multiply by 100 for percentage (or format as %)
- ✓ Works in Google Sheets, Excel, LibreOffice, and most financial software
Practical Example
You invest in a P2P platform throughout the year, adding money as you have it available:
Cash Flows
Initial investment
Added more funds
Portfolio value
Calculated Returns
Simple ROI
8.5%
XIRR
11.3%
Why is XIRR higher? Because earning €850 on money that averaged only 7.5 months invested is more impressive than it looks. XIRR recognizes your capital worked harder during the time it was actually deployed.
When XIRR Has Limitations
XIRR is powerful, but understanding its edge cases helps you interpret results correctly:
Requires both deposits and value
You need at least one negative cash flow (deposit) and one positive (current value or withdrawal) for XIRR to calculate.
Short periods = extreme rates
A 5% gain in one month becomes 80% annualized. This is mathematically correct but can look misleading for new portfolios.
May need a rate guess
The default 10% starting guess doesn't always work. If you get an error in Excel, try adding a guess parameter like 0.15.
Sign changes complicate things
Portfolios with many withdrawals then deposits can have multiple valid XIRR solutions, though this is rare in practice.
The Good News
For typical P2P portfolios held for 6+ months with regular deposits, XIRR works flawlessly and gives you the most honest picture of your returns.
Understanding the Full Picture
XIRR is just one metric for understanding your returns. Learn how it connects to other important P2P concepts.
Calculate Your Real Returns
P2P Dash calculates XIRR automatically across all your platforms. No spreadsheets needed — just upload your exports and see your true performance.