Excel Functions

EFFECT	Returns the effective (or annual) interest rate given a nominal interest rate.
FV	Returns the future value of all the payments of an annuity.
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.
NPV	Returns the present value of a series of unequal cash flows at regular intervals.
PV	Returns the present value of an annuity with fixed cash flows.
RATE	Returns the interest rate for a series of equal cash flows at regular intervals.
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.

EFFECT Returns the effective (or annual) interest rate given a nominal interest rate.
FV Returns the future value of all the payments of an annuity.
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.
NPV Returns the present value of a series of unequal cash flows at regular intervals.
PV Returns the present value of an annuity with fixed cash flows.
RATE Returns the interest rate for a series of equal cash flows at regular intervals.
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.

FV	Returns the future value of a series of equal cash flows at regular intervals.
IPMT	Returns the amount of interest paid in a given period in a series of equal cash flows at regular intervals.
IRR	Returns the interest rate for a series of unequal cash flows at regular intervals.
MIRR	Returns the interest rate for a series of unequal cash flows at regular intervals (with reinvestment).
NPER	Returns the number of compounding periods for a series of equal cash flows at regular intervals.
PMT	Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals.
PPMT	Returns the amount of principal paid in a given period in a series of equal 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 at irregular intervals.
XNPV	Returns the present value of a series of unequal cash flows at irregular intervals.

FV Returns the future value of a series of equal cash flows at regular intervals.
IPMT Returns the amount of interest paid in a given period in a series of equal cash flows at regular intervals.
IRR Returns the interest rate for a series of unequal cash flows at regular intervals.
MIRR Returns the interest rate for a series of unequal cash flows at regular intervals (with reinvestment).
NPER Returns the number of compounding periods for a series of equal cash flows at regular intervals.
PMT Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals.
PPMT Returns the amount of principal paid in a given period in a series of equal 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 at irregular intervals.
XNPV Returns the present value of a series of unequal cash flows at irregular intervals.