| IRR | Returns the internal rate of return on an investment based on a series of periodic cash flows | IRR(cashflow_amounts, [rate_guess]) |
| COUPPCD | Returns the last coupon payment date | COUPPCD(settlement, maturity, frequency, [calculation_method]) |
| PMT | Returns the periodic payment amount for a loan or investment based on a constant interest rate per period and unchanging payment amounts | PMT(rate, number_of_payments, present_value, [future_value], [end_or_beginning]) |
| PV | Returns the present value of a loan or investment based on a constant interest rate per period and unchanging payment amounts | PV(rate, number_of_payments, payment_amount, [future_value], [end_or_beginning]) |
| DOLLARDE | Returns the fractional price as a decimal number | DOLLARDE(fractional_price, unit) |
| DOLLARFR | Returns a decimal number as a fractional price | DOLLARFR(decimal_price, unit) |
| XNPV | Calculates the net present value of an investment for irregular cash flows | XNPV(discount, cashflow_amounts, dates) |
| NPV | Returns the net present value of an investment for regular cash flows | NPV(discount, cashflow1, [cashflow2, ...]) |