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