CAS 6


fv
- Financial

Summary

Returns the future value of periodic payments and a constant interest rate

Examples

fv 9.5 180 840.86 100000
fv 9.5 180 840.86 100000 1

Syntax

(Freq) fv Rate Term Pmt OrigBal (Type)

Left Arguments

Name Data Type Input Type Description Optional Default
Freq Numeric Field, Constant Frequency Yes 12

Right Arguments

Name Data Type Input Type Description Optional Default
Rate Numeric Field, Constant Interest rate No
Term Numeric Field, Constant Remaining term in months No
Pmt Numeric Field, Constant Monthly payment No
OrigBal Numeric Field, Constant Original or Current Balance No
Type Boolean Field, Constant Advance=1, Arrears=0; Boolean Field or Constant Default = 0 Yes 0

Result

Type: Numeric

Remaining Balance



Build 6.0.624