FV Function – Future Value

The FV Function [Future Value calculation] is built into Excel. It is a financial function used to calculate the Future Value of an investment.  This function assumes constant payments with a constant interest rate.

 =FV(rate, nper, pmt, [pv], [type])  
rateThe interest rate per period
nperThe number of periods for the life of the investment
[pmt]Optional, specifies the payment per period
[pv]Optional, specifies the present value of the investment
  • Please note, [pmt] or [pv] must be provided.
0 – (minus) Payment is made at the end of the period
1 – (minus) Payment is made at the start of the period

FV Function Monthly Calculation Example

Let’s look at the following example with payment due at the end of each month. This noted in the formula as -B2, or -1500.

FV Function

FV Function Result:

FV Function

To change the formula to have payment at the beginning of the month, you would change the formula to below.

FV Function


FV Function

Leave a Reply

YEAR Function

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to

Read More »

SUMIFS Function

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to

Read More »

EXACT Function

The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case

Read More »
Scroll to Top