Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Future value in Excel – Excelchat

The Excel FV function is a financial operation which allows us to calculate the net future value of any investment based on its constant rate of interest.

The net future value in Excel can be determined with constant or periodic payments, or with a single large sum payment.

Figure 1. of Future Value in Excel

Generic Formula

=FV(rate,nper,pmt,[pv],[type])

  • rate = Rate of interest per period.
  • nper = Total amount of scheduled payments.
  • pmt = Every payment made per period. Must have a negative value.
  • pv (optional) = Current value of the future payments. Once omitted, ti is assumed as zero. Must have a negative value.
  • type (optional) = When scheduled payments are due; Default is 0, 1 = beginning of period, and 0 = end of period.

What is Future Value in Excel

Excel FV is essentially the calculation of the Future Value of an investment with a constant Rate of Interest.

If we are required to determine the future value on a single cash flow which earns a fixed interest, that is compounded over a given period, we can use the Excel Future Value Function.

How to use FV Function in Excel

We will now demonstrate how to find future value in Excel with the following simple steps:

  1. Collect and arrange the data information available to us in our spreadsheet

Figure 2. of Future Value Data in Excel

In the example above, our goal is to calculate the future value of a $6,000 investment with a constant interest rate of 10% over a 10 year period by using the Excel FV Function.

  1. The Excel future value formula we will enter into cell B8 above, is as follows:

=FV(B4/B6,B5*B6,0-B3)

Figure 3. of Future Value Function in Excel

The FV calculator in Excel returns a future value of $26,723.52 on the initial $6,000 investment.

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc