# Excel Functions

### Interest Rates

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

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

### Cash Flows

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

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

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