Learn How to Use Microsoft Excel FV Function

Microsoft Excel FV Function

The main purpose of the Microsoft Excel FV function is to get the future value of an investment. That implies, with the help of the FV function you can able to return the future value of an investment. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate. So, with the help of the FV function, you can able to get the future value of an investment.

Return Value of FV Function

The return value will be the future investment value. 

Syntax of FV Function

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

Where the arguments:

• rate: This is the interest rate period.
• nper: This is the total number of payment periods.
• pmt: This is the payment made each period. Must be entered as a negative number.
• pv: This is the present value of future payments. In case omitted, assumed to be zero. Must be entered as a negative number.
• type: This is when payments are due. 0 = end of period, 1 = beginning of period. Default is 0 (optional).

How to Use Microsoft Excel FV Function?

So we know that Microsoft Excel FV function you can able to get the future value of an investment. That implies, with the help of the FV function you can able to return the future value of an investment. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate. So, with the help of the FV function, you can able to get the future value of an investment.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel