Returns the endofperiod 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

Returns the endofperiod 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 

Rate(numberOfPeriods, futureValue, presentValue) 

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