Skip to content

Google Sheets financial functions

Financial functions in Google Sheets, explained with live examples.

50 financial functions in Google Sheets — 3 documented in depth so far, the rest indexed below and landing every week.

Documented financial functions

Syntax, examples, and the equivalent — ready now.

All Google Sheets financial functions

The full set — deep dives on the way.

ACCRINT
Calculates the accrued interest of a security that has periodic payments.
ACCRINTM
Calculates the accrued interest of a security that pays interest at maturity.
AMORLINC
Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.
COUPDAYBS
Calculates the number of days from the first coupon, or interest payment, until settlement.
COUPDAYS
Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.
COUPDAYSNC
Calculates the number of days from the settlement date until the next coupon, or interest payment.
COUPNCD
Calculates next coupon, or interest payment, date after the settlement date.
COUPNUM
Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.
COUPPCD
Calculates last coupon, or interest payment, date before the settlement date.
CUMIPMT
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
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
Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
DDB
Calculates the depreciation of an asset for a specified period using the double-declining balance method.
DISC
Calculates the discount rate of a security based on price.
DOLLARDE
Converts a price quotation given as a decimal fraction into a decimal value.
DOLLARFR
Converts a price quotation given as a decimal value into a decimal fraction.
DURATION
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
Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
FV
Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
FVSCHEDULE
Calculates the future value of some principal based on a specified series of potentially varying interest rates.
INTRATE
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.
IRR
Calculates the internal rate of return on an investment based on a series of periodic cash flows.
ISPMT
The ISPMT function calculates the interest paid during a particular period of an investment. .
MDURATION
Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.
MIRR
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
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
NPER
Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
NPV
Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
PDURATION
Returns the number of periods for an investment to reach a specific value at a given rate. .
PPMT
Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.
PRICE
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.
PRICEDISC
Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
PRICEMAT
Calculates the price of a security paying interest at maturity, based on expected yield.
RATE
Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.
RECEIVED
Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.
RRI
Returns the interest rate needed for an investment to reach a specific value within a given number of periods. .
SLN
Calculates the depreciation of an asset for one period using the straight-line method.
SYD
Calculates the depreciation of an asset for a specified period using the sum of years digits method.
TBILLEQ
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
TBILLPRICE
Calculates the price of a US Treasury Bill based on discount rate.
TBILLYIELD
Calculates the yield of a US Treasury Bill based on price.
VDB
Returns the depreciation of an asset for a particular period (or partial period). .
XIRR
Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.
XNPV
Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.
YIELD
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.
YIELDDISC
Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
YIELDMAT
Calculates the annual yield of a security paying interest at maturity, based on price.

More Google Sheets function categories