The FV function calculates the future value of an investment based on periodic, constant payments and a constant interest rate. It is commonly used in financial planning and analysis to determine the future worth of investments or savings over time.


=FV(Rate, Nper, Pmt, [PV], [Type])

Rate The interest rate per period for the investment.
Nper The total number of payment periods for the investment.
Pmt The payment made each period; it remains constant throughout.
PV (Optional) The present value or initial principal amount of the investment. Defaults to 0 if omitted.
Type (Optional) Indicates when payments are due: 0 for end of period 1 for beginning of period. Defaults to 0 if omitted.

About FV

In the realm of financial forecasting and investment planning, the FV function emerges as a trusty ally within Excel's toolkit. It stands ready to assist in projecting the future value of investments or savings, honing in on the potential financial growth derived from regular contributions and interest accrual over time. By harnessing FV, you can envision the worth of your investments down the road, aiding in informed decision-making and goal setting.


Imagine you are tucking away $500 at the end of each month into a retirement account that yields an annual interest rate of 6%. You plan to retire in 20 years and want to estimate the total future value of your account. The FV formula would be: =FV(0.06/12, 20*12, -500, 0, 0). This will provide you with the projected future value of your retirement savings after 20 years.

Suppose you decide to invest in a savings account that offers a 4% annual interest rate. You deposit $200 at the beginning of each quarter for 5 years. To calculate the future value of your savings, the FV formula would be: =FV(0.04, 5*4, 200, 0, 1). This calculation will give you the anticipated value of your savings at the end of the 5-year period.


What does the Type argument signify in the FV function?

The optional Type argument in the FV function determines when payments are due: 0 represents payments at the end of the period, while 1 signifies payments at the beginning of the period. By specifying the appropriate Type value, you align the calculations with the timing of payments within your investment scenario.

Can the FV function handle varying payment amounts each period?

No, the FV function is designed for scenarios involving constant payments in each period. If the payment amounts fluctuate, alternative Excel functions like FVSCHEDULE or XNPV may be better suited for the computation of future values.

Is the FV function useful for evaluating investments with irregular payment schedules?

The FV function is tailored for investments with consistent, periodic payments. In cases where payment schedules vary or are irregular, utilizing Excel functions like NPV may offer a more appropriate means of assessing future investment values.

Related functions