Skip to main content



Rate Function

Returns the end-of-period interest rate which must be applied to the present value in order to arrive at the future value when compounded over the given number of periods

Syntax​

Rate(numberOfPeriods, futureValue, presentValue)

Returns the end-of-period interest rate which must be applied to the present value in order to arrive at the future value when compounded over the given number of periods

Arguments​

numberOfPeriods Numeric - the number of compounding periods

futureValue Numeric - the expected future value

presentValue Numeric - the present value or principal

Remarks​

Example:

Rate(36,30000,5000); // returns 0.051