# Excel Functions

### Interest Rates

DISC | Returns the interest rate (or discount rate) for a security held to maturity. |

EFFECT | Returns the effective (or annual) interest rate given a nominal interest rate. |

NOMINAL | Returns the nominal interest rate for a period given an effective interest rate. |

IRR | Returns the interest rate for a series of unequal cash flows at regular intervals. |

INTRATE | Returns the interest rate for a fully invested security. |

MIRR | Returns the modified interest rate for a series of unequal cash flows at regular intervals. |

RATE | Returns the interest rate for a series of equal cash flows at regular intervals. |

RRI | Returns an equivalent interest rate for the growth of an investment. |

XIRR | Returns the interest rate for a series of unequal cash flows not at regular intervals. |

YIELD | Returns the interest rate for a series of equal cash flows at regular intervals. |

YIELDDISC | Returns the interest rate (annual) for a discounted security (no interest payments). |

YIELDMAT | Returns the interest rate (annual) for a security that pays interest at maturity. |

DISCReturns the interest rate (or discount rate) for a security held to maturity. |

EFFECTReturns the effective (or annual) interest rate given a nominal interest rate. |

NOMINALReturns the nominal interest rate for a period given an effective interest rate. |

IRRReturns the interest rate for a series of unequal cash flows at regular intervals. |

INTRATEReturns the interest rate for a fully invested security. |

MIRRReturns the modified interest rate for a series of unequal cash flows at regular intervals. |

RATEReturns the interest rate for a series of equal cash flows at regular intervals. |

RRIReturns an equivalent interest rate for the growth of an investment. |

XIRRReturns the interest rate for a series of unequal cash flows not at regular intervals. |

YIELDReturns the interest rate for a series of equal cash flows at regular intervals. |

YIELDDISCReturns the interest rate (annual) for a discounted security (no interest payments). |

YIELDMATReturns the interest rate (annual) for a security that pays interest at maturity. |

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext