FinanceRate
[this page | pdf]
Function Description
Returns the interest rate (per period) for an annuity cash
flow
NAVIGATION LINKS
Contents | Prev | Next
Output type / Parameter details
Output type: Double
Parameter Name | Variable Type | Description |
NPer | Double | Total number of periods over which (annuity-style) cash flow is paid |
Pmt | Double | (Fixed) payment paid each period |
PV | Double | Present value of (annuity-style) cash flows |
FV | Double | Future value remaining after (annuity-style) cash flows paid |
CashFlowAtEnd | Boolean | Flag indicating if payment at end (otherwise assumed to be at start) |
Guess | Double | Initial guess at rate (e.g. .1 for 10%) |
Links to:
-
Interactively run function
-
Interactive instructions
-
Example calculation
-
Output type / Parameter details
-
Illustrative spreadsheet
-
Other Finance functions
-
Computation units used
Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement