Interest Rate from a Discount Factor
Last updated 9 November 2026
Function reference › Interest Rates › Interest Rates
1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].
GIA_IR_IRfromDF
Returns the interest rate, given a discount factor
GIA_IR_IRfromDF(discountFactor, T0, T, Comp, Days)Returns: Interest rate
| Argument | Use | Description |
|---|---|---|
discountFactor | Required | The discount factor. |
T0 | Required | The start date of the interest rate period. |
T | Required | The end date of the interest rate period. |
Comp | Required | The compounding basis of the interest rate (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous) |
Days | Required | The time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360) |