RATE (PQL - xl)
This function returns the interest rate per period of an annuity
- Library: PQL \ Spreadsheet \ Financial
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
RATE(nper, pmt, pv, fv, OPTIONAL type, OPTIONAL guess)
Function Arguments
Name | Description | Type | Optional |
nper | Total number of payment periods in an annuity | Number |
|
pmt | Value representing the payment made each period | Number |
|
pv | Present value, worth now | Number |
|
fv | Future value, cash value after the last payment | Number |
|
type | Indicates when payments are due; at the end (0) or beginning (1) of the period; if omitted, the calculation uses the end (0) | Number | Y |
guess | Guess for what the rate will be | Number | Y |
Comments
This function is the same as the Microsoft Excel 'RATE' function - using the same inputs, logic and outputs.