◷ Reading Time: 2 minutes
FlexRule.Extensions.Financials
finNPV
Calculates the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate.
finNPV (fixedRate, cashFlowValues)
- fixedRate (Required): Value specifying discount rate over the length of the period, expressed as a decimal.
- cashFlowValues (Required): Array of values specifying cash flow. The array must contain at least one negative value (a payment) and one positive value (a receipt).
finPmt
Calculates the payment for an annuity based on periodic, fixed payments and a fixed interest rate.
finPmt (interestRate, numberOfPayment, presetValue, futureValue, periodBegin)
- interestRate: The fixed interest rate
- numberOfPayment: The number of payment
- presetValue: Present value
- futureValue: Future value
- periodBegin: A boolean value stating whether to start the payment period
finIPmt
Calculates the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
finIPmt (interestRate, paymentPeriod, numberOfPayment, presetValue, futureValue, periodBegin)
- interestRate: The fixed interest rate
- paymentPeriod: The payment period
- numberOfPayment: The number of payment
- presetValue: Present value
- futureValue: Future value
- periodBegin: A boolean value stating whether to start the payment period
finPPmt
Calculates the principal payment for a given period of an annuity based on periodic fixed payments and a fixed interest rate.
finPPmt (interestRate, paymentPeriod, numberOfPayment, presetValue, futureValue, periodBegin)
- interestRate: The fixed interest rate
- paymentPeriod: The payment period
- numberOfPayment: The number of payment
- presetValue: Present value
- futureValue: Future value
- periodBegin: A boolean value stating whether to start the payment period