Forward Rate from an Interest Rate Curve
Last updated 9 November 2026
Function reference › Interest Rates › Forward Rate
1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].
GIA_IR_ForwardRatefromIRCurve
Returns the forward interest rate, given an interest rate curve.
GIA_IR_ForwardRatefromIRCurve(CurveDates, CurveRates, T0, T1, T2, CompInput, CompOutput, DaysInput, DaysOutput, Interp)Returns: Forward interest rate
| Argument | Use | Description |
|---|---|---|
CurveDates | Required | The array of dates in the interest rate curve. |
CurveRates | Required | The array of rates in the interest rate curve. |
T0 | Required | The spot date. |
T1 | Required | The start date of the forward period. |
T2 | Required | The end date of the forward period. |
CompInput | Required | The compounding basis of the input interest rates (Annual, SemiAnnual, Quarterly, Simple, Continuous) |
CompOutput | Required | The compounding basis of the forward interest rate (Annual, SemiAnnual, Quarterly, Simple, Continuous) |
DaysInput | Required | The time basis of the input interest rates (act/360, act/365, act/act, 30E/360, 30I/360) |
DaysOutput | Required | The time basis of the forward interest rate (act/360, act/365, act/act, 30E/360, 30I/360) |
Interp | Required | The interpolation method (Linear, LogLinear, CubicSpline, Exponential) |