FV Function

  • Updated

Returns the end-of-period future value for a series of payments given the interest rate, number of periods, payment amount, and initial principal

Syntax

 

Returns the end-of-period future value for a series of payments given the interest rate, number of periods, payment amount, and initial principal

 

FV(rate, numberOfPeriods, paymentAmount, presentValue)

 

 

Arguments:

 

 

 

rate

Numeric - the interest rate

 

 

numberOfPeriods

Numeric - the number of periods

 

 

paymentAmount

Numeric - the payment made each period

 

 

presentValue

Numeric - the initial principal amount

Remarks

  • Example: FV(0.05, 36, -100, 0) returns 9583.632.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.