Syntax: FV ( payment; interestRate; periods )
paymentThe nominal amount of the payment.
interestRateThe per-period interest rate.
periodsThe number of periods in the duration of the investment.
Data type returned: Number
Returns the future value of a periodic investment based on the payments and interest rate for the number of periods specified.
The FV() function doesn't account for the present value of your investment, and it assumes that payments are made at the end of each period.
FV ( 50; .10; 2 )
Returns 105, indicating the amount of money you would have after making two periodic deposits of $50 into an investment that paid 10% per period.
If the investment compounds monthly, divide the annual interestRate by 12 to express the periods as a number of months.
To figure out the future value of monthly investments of $250, earning 8% interest, for 10 years, you would use the formula
FV ( 250; .08/12; 10 * 12)
which returns 45736.51.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information