Calculation guide
Use positive future cash flows, full price and continuously compounded annual spot rates for their exact dates. The spread is constant across maturities. Cash flows are deterministic.
Solve P = Σ CFₜ exp[−(spotₜ + z)t].
Inputs
Full price for all cash flows
Example entry 110 (in the selected currency).
Years to payment
Example entry 1. Allowed range 0.0001 to 200.
Promised cash flow
Example entry 5 (in the selected currency). Minimum 1e-06.
Continuously compounded annual spot rate (%)
Example entry 0. Allowed range -100 to 10000.
Worked example
| Input | Value |
|---|---|
| Full price for all cash flows | 110 |
Cash flows with spot rates
| Years to payment | Promised cash flow | Continuously compounded annual spot rate (%) |
|---|---|---|
| 1 | 5 | 0 |
| 2 | 105 | 0 |
| Result | Value |
|---|---|
| Constant Z-spread (bp) | 0 |
| Present value on unadjusted curve | 110 |
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 for all cash flows | 110 | 121 | Constant Z-spread (bp) | 0 | -487.373687 |
| Promised cash flow (row 1) | 5 | 6 | Constant Z-spread (bp) | 0 | 46.508945 |
| Continuously compounded annual spot rate (%) (row 1) | 0 | 1 | Constant Z-spread (bp) | 0 | -2.313998 |
