Enter Bond and Benchmark Details
Use values per bond. Keep bond and benchmark amounts in the same currency. Clean prices exclude accrued interest.
Example Data
| Input | Example value | Purpose |
|---|---|---|
| Bond starting price | USD 980.00 | Initial market value per bond. |
| Bond ending price | USD 1,002.00 | Ending market value per bond. |
| Face value | USD 1,000.00 | Basis for coupon income. |
| Annual coupon rate | 5.50% | Stated annual coupon percentage. |
| Coupon frequency | Semiannual | Two scheduled payments yearly. |
| Coupon payments received | 1 | Cash coupons collected during holding. |
| Holding period | 180 days | Period used for annualization. |
| Benchmark values | 100.00 to 102.00 | Reference investment performance. |
Formula Used
Coupon Income = Face Value × (Coupon Rate ÷ 100) × (Coupon Payments Received ÷ Coupon Frequency)Bond Total Return = (Ending Price − Starting Price + Coupon Income + Other Income − Transaction Costs) ÷ Starting PriceBenchmark Return = (Benchmark Ending Value − Benchmark Starting Value + Benchmark Income) ÷ Benchmark Starting ValueExcess Return = Bond Total Return − Benchmark ReturnThe annualized result uses each total return and converts it to a 365-day equivalent. It is unavailable when a return is below negative one hundred percent.
How to Use This Calculator
- Enter the bond clean price when the holding period began.
- Enter the clean price on the sale or valuation date.
- Provide face value, coupon rate, frequency, and payments received.
- Add other eligible income and total transaction costs.
- Enter matching start, end, and income values for your benchmark.
- Select Calculate Excess Return to view results above the form.
- Download the results as CSV or PDF when needed.
Bond Excess Returns Explained
Understanding the Comparison
Bond excess return measures how a bond performed compared with a selected benchmark over the same holding period. A positive figure means the bond outperformed. A negative figure means the benchmark delivered more return. The comparison can use a bond index, a treasury portfolio, a duration matched fund, or another reference investment. Matching the benchmark to the bond's risk and maturity gives the result greater meaning.
Why Return Needs More Than Price
Price movement alone does not describe a bond investment. Coupon payments add income. Accrued interest or other cash adjustments may also matter. Transaction costs reduce the investor's realised gain. A bond can fall in price yet produce a positive holding period return when coupon income offsets part of the decline. Conversely, a rising price can still trail a stronger benchmark.
Inputs That Change the Result
The calculator begins with the bond's starting and ending clean prices. It then estimates coupon income from face value, coupon rate, payment frequency, and payments received. You can enter other income separately. This helps when settlement adjustments, call premiums, or recorded cash flows need inclusion. Transaction costs are subtracted because they reduce the return actually kept by an investor.
Choosing a Suitable Benchmark
The benchmark should cover the same days as the bond holding period. Enter its starting value, ending value, and any distributions. A short treasury benchmark may suit a low-risk comparison. A duration matched bond index may better reflect market exposure. Use one benchmark consistently when comparing several bonds. Changing benchmarks can make otherwise similar results look different.
Reading the Equation
Bond total return equals net profit divided by the starting bond price. Net profit combines price change, coupon income, other income, and transaction costs. Benchmark return follows the same holding period approach. Excess return is simply the bond total return less benchmark total return. The annualized figures convert each holding period return into a one-year equivalent. They are most useful when the holding period is shorter or longer than one year.
Using Consistent Records
Use prices and cash amounts in the same currency. Enter each amount per bond, not for a mixed portfolio. Select the coupon frequency that matches the bond terms. Enter zero coupon payments when none were received. Review the result card after calculation. Positive excess return signals outperformance, while negative excess return signals underperformance. This tool estimates historical performance. It cannot predict future bond returns, interest-rate changes, defaults, or liquidity conditions.
Putting the Result in Context
Excess return is not a complete measure of investment quality. A bond may outperform because it accepted more credit risk, longer duration, lower liquidity, or greater call exposure. Compare the result with the bond's rating, duration, sector, and tax treatment. Check whether the benchmark uses a similar currency and interest-rate sensitivity. One holding period can be unusual. Review several periods before drawing a broad conclusion. Keep records of purchase dates, sale dates, and cash flows. Those details make later comparisons more reliable and make calculation errors easier to identify. This discipline supports clearer reviews and better reporting.
Frequently Asked Questions
What is bond excess return?
Bond excess return is the bond's total return minus the return of a selected benchmark during the same period. It shows whether the bond outperformed or underperformed that reference investment.
Which benchmark should I use?
Choose a benchmark with similar currency, duration, credit quality, and market exposure. A treasury series can suit a low-risk comparison. A duration matched bond index may suit broader market comparisons.
Why are clean prices used?
Clean prices separate the market price from accrued interest. This keeps coupon and accrued-income amounts visible in the calculation. Use consistent price conventions at both the start and end dates.
Do coupon payments affect excess return?
Yes. Coupon payments are cash income and form part of total return. Ignoring them can make a bond appear weaker than it actually was over the holding period.
Can excess return be negative?
Yes. Negative excess return means the selected benchmark earned a higher total return than the bond during the measured period. The bond itself may still have earned a positive return.
What are transaction costs in this calculation?
Transaction costs include commissions, spreads, fees, and other recorded costs related to buying or selling the bond. They are subtracted from the bond's profit because they reduce realised performance.
How is the annualized return calculated?
The calculator compounds each holding-period total return to a 365-day equivalent. Annualized figures make periods of different lengths easier to compare, but they do not predict a future annual result.
Can I use this for a zero-coupon bond?
Yes. Enter a coupon rate of zero and coupon payments received as zero. The bond return will then come from price movement, other recorded income, and transaction costs.
Should benchmark income be included?
Yes, when the benchmark distributed income during the same period. Including distributions creates a total-return comparison rather than a price-only comparison.
Does the calculator include taxes?
No tax model is applied automatically. Enter tax-related cash effects within other income or transaction costs when they are relevant to your analysis.
Is this result investment advice?
No. The tool provides a historical calculation from the values entered. It does not assess credit risk, liquidity, tax rules, suitability, or future interest-rate movements.