Convertible Bond, inflation-linked

Last updated 20 November 2026

Function reference › Bonds › Convertible Bond (Inflation)

5 GIAnalyzer functions for Excel. Optional arguments are shown in [brackets].

GIA_Bonds_ConvertibleInflation_Risk

Returns the risk measures (DV01, Modified Duration, Convexity, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond, given a nominal interest rate and a real interest rate for discounting future cash flows.

GIA_Bonds_ConvertibleInflation_Risk(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, RateN, RateI, Sp, LCPI, VDate, Comp, Days, Steps, RM, [RMForm], [ShiftedRates])

Returns: Risk measures (DV01, Modified Duration, Convexity, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond

ArgumentUseDescription
FaceValueRequiredThe bond's face value.
ConversionRatioRequiredThe number of shares received on conversion.
ConversionRatioTypeRequiredWhat the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value)
StartDateRequiredThe start date of the bond's first accrual period.
MDateRequiredThe bond's maturity date.
CRateRequiredThe bond's fixed coupon rate.
CFrRequiredThe frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
FPPDRequiredThe first principal payment date. Blank or the maturity date: the whole principal is paid at maturity.
FrPPRequiredThe frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly)
BCPIRequiredThe CPI level at the inception of the deal.
SRequiredThe spot price of the underlying asset.
VolRequiredThe volatility of the underlying asset.
DividendYieldRequiredThe continuous annual dividend yield.
RateNRequiredThe nominal interest rate, which drives and discounts the equity component.
RateIRequiredThe inflation (real) interest rate used for discounting the bond's cash flows.
SpRequiredThe credit spread (in basis points) that is added to the inflation interest rate.
LCPIRequiredThe CPI level at the value date.
VDateRequiredThe value date.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
StepsRequiredThe number of steps in the binomial tree: at least one per coupon or principal period.
RMRequiredThe risk measure type (DV01, ModifiedDuration, Convexity, Delta, Gamma, Vega, Theta)
RMFormOptionalThe form of DV01, Delta, Gamma, Vega and Theta (Amount: for the whole face value; Percent: per 100 of face value). Blank: Amount.
ShiftedRatesOptionalThe interest rates the DV01, ModifiedDuration and Convexity move (Nominal, Inflation, Both). Blank: Both.

See also: GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_ValueFromCurve, GIA_Bonds_ConvertibleInflation_Zspread

GIA_Bonds_ConvertibleInflation_RiskFromCurve

Returns the risk measures (DV01, Modified Duration, Convexity, KR01, Bucket DV01, Key Rate Duration, Bucket Duration, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond, given a nominal and a real (inflation) interest rate curve for discounting future cash flows.

GIA_Bonds_ConvertibleInflation_RiskFromCurve(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, NCurveDates, NCurveRates, ICurveDates, ICurveRates, Sp, LCPI, VDate, Comp, Days, Interp, Steps, RM, [RMForm], [ShiftedCurves], [StartTerm], [EndTerm])

Returns: Risk measures (DV01, Modified Duration, Convexity, KR01, Bucket DV01, Key Rate Duration, Bucket Duration, Delta, Gamma, Vega, Theta) of an inflation-linked convertible bond

ArgumentUseDescription
FaceValueRequiredThe bond's face value.
ConversionRatioRequiredThe number of shares received on conversion.
ConversionRatioTypeRequiredWhat the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value)
StartDateRequiredThe start date of the bond's first accrual period.
MDateRequiredThe bond's maturity date.
CRateRequiredThe bond's fixed coupon rate.
CFrRequiredThe frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
FPPDRequiredThe first principal payment date. Blank or the maturity date: the whole principal is paid at maturity.
FrPPRequiredThe frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly)
BCPIRequiredThe CPI level at the inception of the deal.
SRequiredThe spot price of the underlying asset.
VolRequiredThe volatility of the underlying asset.
DividendYieldRequiredThe continuous annual dividend yield.
NCurveDatesRequiredThe array of dates in the nominal interest rate curve, which drives and discounts the equity component.
NCurveRatesRequiredThe array of rates in the nominal interest rate curve, which drives and discounts the equity component.
ICurveDatesRequiredThe array of dates in the inflation (real) interest rate curve used for discounting the bond's cash flows.
ICurveRatesRequiredThe array of rates in the inflation (real) interest rate curve used for discounting the bond's cash flows.
SpRequiredThe credit spread (in basis points) that is added to the inflation curve.
LCPIRequiredThe CPI level at the value date.
VDateRequiredThe value date.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
InterpRequiredThe interpolation method (Linear, LogLinear, CubicSpline, Exponential)
StepsRequiredThe number of steps in the binomial tree: at least one per coupon or principal period.
RMRequiredThe risk measure type (DV01, ModifiedDuration, Convexity, KR01, BucketDV01, KRDuration, BucketDuration, Delta, Gamma, Vega, Theta)
RMFormOptionalThe form of DV01, KR01, BucketDV01, Delta, Gamma, Vega and Theta (Amount: for the whole face value; Percent: per 100 of face value). Blank: Amount.
ShiftedCurvesOptionalThe interest rate curves the interest rate measures move (Nominal, Inflation, Both). Blank: Both.
StartTermOptionalThe starting term for Bucket and Key Rate measures.
EndTermOptionalThe ending term for Bucket and Key Rate measures.

See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_ValueFromCurve, GIA_Bonds_ConvertibleInflation_Zspread

GIA_Bonds_ConvertibleInflation_Value

Returns the value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments, given a nominal interest rate and a real interest rate for discounting future cash flows.

GIA_Bonds_ConvertibleInflation_Value(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, RateN, RateI, Sp, LCPI, VDate, Comp, Days, Steps)

Returns: Value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments

ArgumentUseDescription
FaceValueRequiredThe bond's face value.
ConversionRatioRequiredThe number of shares received on conversion.
ConversionRatioTypeRequiredWhat the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value)
StartDateRequiredThe start date of the bond's first accrual period.
MDateRequiredThe bond's maturity date.
CRateRequiredThe bond's fixed coupon rate.
CFrRequiredThe frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
FPPDRequiredThe first principal payment date. Blank or the maturity date: the whole principal is paid at maturity.
FrPPRequiredThe frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly)
BCPIRequiredThe CPI level at the inception of the deal.
SRequiredThe spot price of the underlying asset.
VolRequiredThe volatility of the underlying asset.
DividendYieldRequiredThe continuous annual dividend yield.
RateNRequiredThe nominal interest rate, which drives and discounts the equity component.
RateIRequiredThe inflation (real) interest rate used for discounting the bond's cash flows.
SpRequiredThe credit spread (in basis points) that is added to the inflation interest rate.
LCPIRequiredThe CPI level at the value date.
VDateRequiredThe value date.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
StepsRequiredThe number of steps in the binomial tree: at least one per coupon or principal period.

See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_ValueFromCurve, GIA_Bonds_ConvertibleInflation_Zspread

GIA_Bonds_ConvertibleInflation_ValueFromCurve

Returns the value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments, given a nominal and a real (inflation) interest rate curve for discounting future cash flows.

GIA_Bonds_ConvertibleInflation_ValueFromCurve(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, NCurveDates, NCurveRates, ICurveDates, ICurveRates, Sp, LCPI, VDate, Comp, Days, Interp, Steps)

Returns: Value of an inflation-linked convertible bond paying fixed coupons and its principal at maturity or in periodic instalments

ArgumentUseDescription
FaceValueRequiredThe bond's face value.
ConversionRatioRequiredThe number of shares received on conversion.
ConversionRatioTypeRequiredWhat the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value)
StartDateRequiredThe start date of the bond's first accrual period.
MDateRequiredThe bond's maturity date.
CRateRequiredThe bond's fixed coupon rate.
CFrRequiredThe frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
FPPDRequiredThe first principal payment date. Blank or the maturity date: the whole principal is paid at maturity.
FrPPRequiredThe frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly)
BCPIRequiredThe CPI level at the inception of the deal.
SRequiredThe spot price of the underlying asset.
VolRequiredThe volatility of the underlying asset.
DividendYieldRequiredThe continuous annual dividend yield.
NCurveDatesRequiredThe array of dates in the nominal interest rate curve, which drives and discounts the equity component.
NCurveRatesRequiredThe array of rates in the nominal interest rate curve, which drives and discounts the equity component.
ICurveDatesRequiredThe array of dates in the inflation (real) interest rate curve used for discounting the bond's cash flows.
ICurveRatesRequiredThe array of rates in the inflation (real) interest rate curve used for discounting the bond's cash flows.
SpRequiredThe credit spread (in basis points) that is added to the inflation curve.
LCPIRequiredThe CPI level at the value date.
VDateRequiredThe value date.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
InterpRequiredThe interpolation method (Linear, LogLinear, CubicSpline, Exponential)
StepsRequiredThe number of steps in the binomial tree: at least one per coupon or principal period.

See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_Zspread

GIA_Bonds_ConvertibleInflation_Zspread

Returns the Z-spread of an inflation-linked convertible bond: the credit spread over the inflation (real) interest rate curve at which the bond is worth its given value.

GIA_Bonds_ConvertibleInflation_Zspread(FaceValue, ConversionRatio, ConversionRatioType, StartDate, MDate, CRate, CFr, FPPD, FrPP, BCPI, S, Vol, DividendYield, Value, NCurveDates, NCurveRates, ICurveDates, ICurveRates, LCPI, VDate, Comp, Days, Interp, Steps)

Returns: Z-spread of an inflation-linked convertible bond: the credit spread over the inflation (real) interest rate curve at which the bond is worth its given value

ArgumentUseDescription
FaceValueRequiredThe bond's face value.
ConversionRatioRequiredThe number of shares received on conversion.
ConversionRatioTypeRequiredWhat the conversion ratio counts shares for (PerBond: one bond of the face value; PerUnit: one unit of face value)
StartDateRequiredThe start date of the bond's first accrual period.
MDateRequiredThe bond's maturity date.
CRateRequiredThe bond's fixed coupon rate.
CFrRequiredThe frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
FPPDRequiredThe first principal payment date. Blank or the maturity date: the whole principal is paid at maturity.
FrPPRequiredThe frequency of principal payments (Annual, SemiAnnual, Quarterly, Monthly)
BCPIRequiredThe CPI level at the inception of the deal.
SRequiredThe spot price of the underlying asset.
VolRequiredThe volatility of the underlying asset.
DividendYieldRequiredThe continuous annual dividend yield.
ValueRequiredThe bond's value, for the whole face value.
NCurveDatesRequiredThe array of dates in the nominal interest rate curve, which drives and discounts the equity component.
NCurveRatesRequiredThe array of rates in the nominal interest rate curve, which drives and discounts the equity component.
ICurveDatesRequiredThe array of dates in the inflation (real) interest rate curve used for discounting the bond's cash flows.
ICurveRatesRequiredThe array of rates in the inflation (real) interest rate curve used for discounting the bond's cash flows.
LCPIRequiredThe CPI level at the value date.
VDateRequiredThe value date.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
InterpRequiredThe interpolation method (Linear, LogLinear, CubicSpline, Exponential)
StepsRequiredThe number of steps in the binomial tree: at least one per coupon or principal period.

See also: GIA_Bonds_ConvertibleInflation_Risk, GIA_Bonds_ConvertibleInflation_RiskFromCurve, GIA_Bonds_ConvertibleInflation_Value, GIA_Bonds_ConvertibleInflation_ValueFromCurve