Type in Google’s function list
Financial functions
Functions for interest, payments, securities and depreciation. Google prints 50 Financial function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| ACCRINT | ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention]) | Calculates the accrued interest of a security that has periodic payments. |
| ACCRINTM | ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention]) | Calculates the accrued interest of a security that pays interest at maturity. |
| AMORLINC | AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis]) | Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. |
| COUPDAYBS | COUPDAYBS(settlement, maturity, frequency, [day_count_convention]) | Calculates the number of days from the first coupon, or interest payment, until settlement. |
| COUPDAYS | COUPDAYS(settlement, maturity, frequency, [day_count_convention]) | Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. |
| COUPDAYSNC | COUPDAYSNC(settlement, maturity, frequency, [day_count_convention]) | Calculates the number of days from the settlement date until the next coupon, or interest payment. |
| COUPNCD | COUPNCD(settlement, maturity, frequency, [day_count_convention]) | Calculates next coupon, or interest payment, date after the settlement date. |
| COUPNUM | COUPNUM(settlement, maturity, frequency, [day_count_convention]) | Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. |
| COUPPCD | COUPPCD(settlement, maturity, frequency, [day_count_convention]) | Calculates last coupon, or interest payment, date before the settlement date. |
| CUMIPMT | CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) | Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. |
| CUMPRINC | CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) | Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. |
| DB | DB(cost, salvage, life, period, [month]) | Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. |
| DDB | DDB(cost, salvage, life, period, [factor]) | Calculates the depreciation of an asset for a specified period using the double-declining balance method. |
| DISC | DISC(settlement, maturity, price, redemption, [day_count_convention]) | Calculates the discount rate of a security based on price. |
| DOLLARDE | DOLLARDE(fractional_price, unit) | Converts a price quotation given as a decimal fraction into a decimal value. |
| DOLLARFR | DOLLARFR(decimal_price, unit) | Converts a price quotation given as a decimal value into a decimal fraction. |
| DURATION | DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) . | Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. |
| EFFECT | EFFECT(nominal_rate, periods_per_year) | Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. |
| FV | FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning]) | Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. |
| FVSCHEDULE | FVSCHEDULE(principal, rate_schedule) | Calculates the future value of some principal based on a specified series of potentially varying interest rates. |
| INTRATE | INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention]) | Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself. |
| IPMT | IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. |
| IRR | IRR(cashflow_amounts, [rate_guess]) | Calculates the internal rate of return on an investment based on a series of periodic cash flows. |
| ISPMT | ISPMT(rate, period, number_of_periods, present_value) | The ISPMT function calculates the interest paid during a particular period of an investment. |
| MDURATION | MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) | Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. |
| MIRR | MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate) | Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. |
| NOMINAL | NOMINAL(effective_rate, periods_per_year) | Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. |
| NPER | NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning]) | Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. |
| NPV | NPV(discount, cashflow1, [cashflow2, ...]) | Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. |
| PDURATION | PDURATION(rate, present_value, future_value) | Returns the number of periods for an investment to reach a specific value at a given rate. |
| PMT | PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. |
| PPMT | PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. |
| PRICE | PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention]) | Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. |
| PRICEDISC | PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention]) | Calculates the price of a discount (non-interest-bearing) security, based on expected yield. |
| PRICEMAT | PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention]) | Calculates the price of a security paying interest at maturity, based on expected yield. |
| PV | PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning]) | Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. |
| RATE | RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess]) | Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. |
| RECEIVED | RECEIVED(settlement, maturity, investment, discount, [day_count_convention]) | Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. |
| RRI | RRI(number_of_periods, present_value, future_value) | Returns the interest rate needed for an investment to reach a specific value within a given number of periods. |
| SLN | SLN(cost, salvage, life) | Calculates the depreciation of an asset for one period using the straight-line method. |
| SYD | SYD(cost, salvage, life, period) | Calculates the depreciation of an asset for a specified period using the sum of years digits method. |
| TBILLEQ | TBILLEQ(settlement, maturity, discount) | Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. |
| TBILLPRICE | TBILLPRICE(settlement, maturity, discount) | Calculates the price of a US Treasury Bill based on discount rate. |
| TBILLYIELD | TBILLYIELD(settlement, maturity, price) | Calculates the yield of a US Treasury Bill based on price. |
| VDB | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]) | Returns the depreciation of an asset for a particular period (or partial period). |
| XIRR | XIRR(cashflow_amounts, cashflow_dates, [rate_guess]) | Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. |
| XNPV | XNPV(discount, cashflow_amounts, cashflow_dates) | Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. |
| YIELD | YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention]) | Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. |
| YIELDDISC | YIELDDISC(settlement, maturity, price, redemption, [day_count_convention]) | Calculates the annual yield of a discount (non-interest-bearing) security, based on price. |
| YIELDMAT | YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]) | Calculates the annual yield of a security paying interest at maturity, based on price. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.