Description
The Excel FV function calculates the Future Value of an investment with periodic constant payments and a constant interest rate.
The syntax of the function is :
FV( rate, nper, [pmt], [pv], [type] )
Where the arguments are as follows:
Excel Fv Function Examples
The spreadsheets below show examples of the Excel Fv function. In each case, the format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.
Example 1
The following spreadsheet shows the Excel Fv function used to calculate the future value of an investment of $1,000 per month for a period of 5 years. The present value is 0, the interest rate is 5% per year and the payments are made at the end of each month.
Example 2
The example below shows the Excel Fv function used to calculate the future value of an investment of $2,000 per quarter for a period of 4 years. The interest is 10% per year and each payment is made at the start of the quarter.
Fv Function Errors
If you get an error from the Excel Fv Function, this is most likely to be the #VALUE error:
Common Errors
No comments:
Post a Comment