Advanced P2P Portfolio Calculator

Analyze your P2P bond portfolio: YTM, Weighted Duration, Monthly Cash Flow, and Default Impact.

Portfolio Bonds

Bond 1
Nominal value of the bond/loan
Price paid to acquire the bond
Annual interest rate
Investment start date (or today)
Bond maturity date
Frequency of interest payments per year
Day of month when coupon is paid (leave empty for default)
YTM: 0.00%
Accrued Interest: โ‚ฌ0.00 ยท Clean Price: โ‚ฌ0.00 ยท Dirty Price (Tel Quel): โ‚ฌ0.00
Portfolio YTM?
0.00%
Weighted Avg Duration?
0.00
years
Monthly Cash Flow?
โ‚ฌ0.00
Default Impact?
โ‚ฌ0.00
0% 50% 100%

Portfolio Summary

Total Invested ?
โ‚ฌ0.00
Total Face Value ?
โ‚ฌ0.00
Expected Loss ?
โ‚ฌ0.00
Portfolio Value ?
โ‚ฌ0.00
Value of Capital ?
โ‚ฌ0.00

What is Yield to Maturity (YTM)?

YTM is the total return anticipated on a bond if held until maturity. It is calculated from the purchase price, face value, coupon payments, and time to maturity using the Newton-Raphson method.

Price = ฮฃ[C / (1 + YTM/n)^t] + FV / (1 + YTM/n)^N

What is Weighted Average Duration?

The weighted average duration measures the portfolio's overall sensitivity to interest rate changes, computed as each bond's Macaulay Duration weighted by its share of total investment.

Weighted Duration = ฮฃ(w_i ร— D_i) where w_i = Investment_i / Total Investment

What is Total Monthly Cash Flow?

Total Monthly Cash Flow is the sum of all monthly coupon payments across all bonds in the portfolio, providing an estimate of recurring income.

Monthly Cash Flow = ฮฃ(FaceValue_i ร— CouponRate_i / 12)

What is Default Impact?

Default Impact estimates the potential loss on the portfolio if a certain percentage of bonds default. Adjust the slider to simulate different default scenarios.

Default Impact = Portfolio Value ร— Default Rate (%)

What is Clean Price vs. Dirty Price?

The Clean Price is the bond price excluding accrued interest. The Dirty Price (or Tel Quel) is the actual amount a buyer pays, which includes the Clean Price plus any interest accrued since the last coupon payment. In secondary P2P lending markets, this distinction is important: the seller is entitled to interest earned up to the sale date.

Dirty Price = Clean Price + Accrued Interest

What is Accrued Interest?

Accrued Interest is the interest that has accumulated on a bond since the last coupon payment date but has not yet been paid. When buying a bond on the secondary market, the buyer typically pays the seller the accrued interest on top of the clean price.

Accrued Interest = (Coupon Rate ร— Face Value / Payments per Year) ร— (Days since last coupon / Days in period)