Financials

Contents

◷ Reading Time: 1 minute

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).

Calculates the payment for an annuity based on periodic, fixed payments and a fixed interest rate.

 finPmt (interestRate, numberOfPayment, presetValue, futureValue, periodBegin)

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)

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)

Updated on June 29, 2020