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.
Comments
0 comments
Article is closed for comments.