Excel Functions


Interest Rates

EFFECTReturns the effective (or annual) interest rate given a nominal interest rate.
FVReturns the future value of all the payments of an annuity.
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.
NPVReturns the present value of a series of unequal cash flows at regular intervals.
PVReturns the present value of an annuity with fixed cash flows.
RATEReturns the interest rate for a series of equal cash flows at regular intervals.
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.
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.

Cash Flows

FVReturns the future value of a series of equal cash flows at regular intervals.
IPMTReturns the amount of interest paid in a given period in a series of equal cash flows at regular intervals.
IRRReturns the interest rate for a series of unequal cash flows at regular intervals.
MIRRReturns the interest rate for a series of unequal cash flows at regular intervals (with reinvestment).
NPERReturns the number of compounding periods for a series of equal cash flows at regular intervals.
PMTReturns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals.
PPMTReturns the amount of principal paid in a given period in a series of equal 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 at irregular intervals.
XNPVReturns 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.

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