Financials

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)

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)

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)