Function: RRI

Function: RRI

The Excel RRI function is a Financial function that calculates and returns the equivalent interest rate for the growth of an investment. When given a present value, a future value, and the number of periods for an investment, you can calculate the rate of return for...
Function: RATE

Function: RATE

The Excel RATE function is a Financial formula that calculates and returns the interest rate for a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel RATE function and also go over some tips and error...
Function: NPER

Function: NPER

The NPER function is a Financial formula that calculates and returns the number of repayment periods of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel NPER function and also go over some tips and error...
Function: PMT

Function: PMT

The PMT is a Financial function that calculates and returns the repayment amount of a loan based on constant payments and a constant interest rate. This formula is commonly used in amortization schedule Excel models. In this guide, we’re going to show you how to use...
Function: MIRR

Function: MIRR

The MIRR Excel function is a finance function that calculates the modified internal rate of return (MIRR) for a series of periodic cash flows. This function works by using both the cost of the investment and the interest received by reinvesting the cash. In this...
Function: XIRR

Function: XIRR

The XIRR function is a finance function that calculates the internal rate of return (IRR) of a series of non-periodic cash flows. This function works like the IRR function, but doesn’t require entering regular intervals. In this guide, we’re going to show you...
Function: IRR

Function: IRR

The IRR Excel function is a finance function which can calculatee the internal rate of return (IRR) of a series of periodic cash flows. The function assumes that the cash flows occurs at regular intervals. In this guide, we’re going to show you how to use the IRR...
Function: XNPV

Function: XNPV

The XNPV function is a finance function which can calculate the net present value (NPV) of a series of non-periodic cash flows, based on a specified discount rate. In this guide, we’re going to show you how to use the XNPV function and also go over ome tips and error...
Function: NPV

Function: NPV

The Excel NPV function is a finance function that calculates the net present value (NPV) of a series of cash flows based on a specified discount rate. In this guide, we’re going to show you how to use the Excel NPV function and also go over some tips and error...