Calculation guide
Each instrument matures one coupon period after the previous instrument, beginning at period one. All issue prices are full settlement quotes per 100 face, with aligned coupon dates and par redemption. Positive discount factors can exceed one.
DFₙ = [Pₙ − couponₙ Σ(previous DF)] / (100 + couponₙ).
Inputs
Coupon periods per year
Example entry 1. Use whole numbers.
Full price per 100 face
Example entry 100 (in the selected currency). Minimum 1e-06.
Annual coupon percentage
Example entry 4 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Coupon periods per year | 1 |
Bonds in increasing consecutive maturity
| Full price per 100 face | Annual coupon percentage |
|---|---|
| 100 | 4% |
| 100 | 4% |
| 100 | 4% |
| Result | Value |
|---|---|
| Spot rate at final maturity | 4% |
| Final discount factor | 0.888996 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Coupon periods per year | 1 | 2 | Final discount factor | 0.888996 | 0.942322 |
| Full price per 100 face (row 1) | 100 | 110 | Spot rate at final maturity | 4% | 4.139038% |
| Annual coupon percentage (row 1) | 4% | 5% | Spot rate at final maturity | 4% | 3.986797% |
