FV()

Category: Financial

Syntax: FV ( payment; interestRate; periods )

Parameters:

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

Description:

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.

Examples:

Function

Results

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

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

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



FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net