FinancePPmt
[this page | pdf]
Function Description
Returns the principal payment for a given period for an
annuity-style cash flow involving periodic fixed payments and a
term-independent interest rate
NAVIGATION LINKS
Contents | Prev | Next
Output type / Parameter details
Output type: Double
Parameter Name | Variable Type | Description |
Rate | Double | Interest rate per period |
Per | Double | Period in question |
NPer | Double | Total number of periods over which (annuity-style) cash flow is paid |
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) |
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