Financials

◷ 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
Updated on May 11, 2022

Was this article helpful?

Related Articles