Excel Functions


Interest Rates

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.
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.


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