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. |
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. |
Present Value / Future Value
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. |
NPER | Returns the number of compounding periods for a series of equal cash flows at regular intervals. |
NPV | Returns the present value of a series of unequal 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. |
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. |
NPER Returns the number of compounding periods for a series of equal cash flows at regular intervals. |
NPV Returns the present value of a series of unequal 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. |
XNPV Returns the present value of a series of unequal cash flows at irregular intervals. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext