-
Microsoft Excel Office 365
Learn How to Use Microsoft Excel FV Function
In this article, you will learn how to use the Microsoft Excel FV function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel FV function return value and syntax with the help of some examples.
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
Comments