Excel Function : FV
Category
Financial
Description
Returns the future value of an investment
Microsoft Excel Reference Page
https://support.office.com/en-us/article/FV-function-2eef9f44-a084-4c61-bdd8-4fe4bb1b71b3
Syntax and Description of the FV Excel Function
The syntax for the FV function in Microsoft Excel is: =FV(rate, nper, pmt, [pv], [type]) rate - The interest rate per period. nper - The total number of payment periods. pmt - The payment made each period. pv - [Optional] The present value of the loan or investment. type - [Optional] When the payment is made.
About FV Excel Function
The FV function returns the future value of an investment. The future value is the value of an asset at a specific time in the future based on an assumed rate of return. The future value is often used when evaluating investments, such as savings accounts, annuities, and bonds. The syntax for the FV function is: FV(rate, nper, pmt, [pv], [type]) rate - The interest rate per period. nper - The total number of periods. pmt - The payment made each period. pv - The present value of the investment. type - The type of payment. The FV function returns the future