| Keyword | Description | Symbol / Usage |
| effect | Effective annual interest rate | Effect(nominal_rate[pct], nperi) |
| fv | Future value of a series of periodic constant payments | Fv(rate[pct], nper[int], pmt[USD], pv[USD], type[0|1]) |
| irr1 | Interest rate | Irr1(nper, pval[USD], fval[USD]) |
| irrn | Internal rate of return | Irrn(val1[USD], val2[USD], val3[USD]…,guess[pct]) |
| nfv | Net future value of periodic variable payments | Nfv( rate[pct] , pay1[USD] [ , pay2[USD]… ] ) |
| nfv1 | Net future value of a one time investment | Nfv1( rate[pct] , nper , pval[USD] ) |
| npv | Net present value of periodic variable payments | Npv( rate[pct] , pay1[USD] [ , pay2[USD]… ] ) |
| npv1 | Net present value of a future earning | Npv1( rate[pct] , nper , fval[USD] ) |
| pv | Present value of a series of periodic constant payments | Pv(rate[pct], nper[int], pmt[USD], fv[USD], type[0|1]) |