Hi, Please i need help, i would like to calculate the Z-spread(zero volatilité spread) of coupon bond. Input(known variable) : Price of the Bond = 102.3 Coupon = 3% Frequency : Annuel Date of maturity = 15/12/2024. Yield Curve: Year 1 =0.1, Year 2 =0.2, Year 3 =0.4, Year 4 = 0.5. The formula is : 102.3= 3/(1+0.1+SP)^1+3/(1+0.2+SP)^2+3/(1+0.4+SP)^3+3/(1+0.5+SP)^4+100/(1+0.5+SP)^4. With the function Solve, i would like to find SP(Z-spread). Thank you for your help. Samy
... View more