Calculation guide
Assume settlement immediately after a coupon. All exercise and redemption dates are whole coupon periods from settlement. Yields are nominal annual rates compounded at the payment frequency. Assume proportional paydown for this holding, with interest on each opening balance and all face value repaid by the final row. A lottery sinking fund can produce different individual proceeds.
Coupon = opening principal × annual coupon / frequency. Discount coupons plus scheduled principal to the full price.
Inputs
Face value
Example entry 1000 (in the selected currency).
Full price paid
Example entry 1000 (in the selected currency).
Annual coupon rate
Example entry 5 %. Allowed range 0 to 100.
Coupon payments per year
Example entry 2. Use whole numbers.
Scheduled principal repayment
Example entry 200 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Face value | 1,000 |
| Full price paid | 1,000 |
| Annual coupon rate | 5% |
| Coupon payments per year | 2 |
Sinking-fund principal by period
| Scheduled principal repayment |
|---|
| 200 |
| 300 |
| 500 |
| Result | Value |
|---|---|
| Annual yield to sinker | 5% |
| Total coupon interest | 57.5 |
| Principal-weighted life in years | 1.15 |
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 |
|---|---|---|---|---|---|
| Full price paid | 1,000 | 1,100 | Annual yield to sinker | 5% | -3.430773% |
| Annual coupon rate | 5% | 6% | Annual yield to sinker | 5% | 6% |
| Coupon payments per year | 2 | 3 | Total coupon interest | 57.5 | 38.333333 |
