Financial function overview

Sigma supports the following financial functions:

CAGR
Returns the compound annual growth rate of an investment.
Effect
Returns the effective annual interest rate.
FV
Returns the future value of an investment.
IPmt
Returns the interest portion of a periodic payment for a loan based on the amount, number of periods, and constant interest rate. The portion of the payment allocated to interest decreases over time.
Nominal
Rreturns the nominal annual interest rate.
NPer
Returns the number of periods for a loan or investment based on known amount, interest rate, and periodic payment amount.
Pmt
Returns the periodic payment for a loan based on the amount, number of periods, and constant interest rate.
PPmt
Returns the principal portion of a periodic payment for a loan based on the amount, number of periods, and constant interest rate. The portion of the payment allocated to principal increases over time.
PV
Returns theΒ present value of a loan or an investment, when using constant and regular periodic payments.
XNPV
Returns the net present value of an investment for payments or incomes at irregular intervals.