Excel Functions

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.

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.