Google Sheets financial functions
Financial functions in Google Sheets, explained with live examples.
50 financial functions in Google Sheets — 50 documented in depth so far, the rest indexed below and landing every week.
Documented financial functions
Syntax, examples, and the equivalent — ready now.
- ACCRINTCalculates the accrued interest of a security that has periodic payments.FinancialExcel
- ACCRINTMCalculates the accrued interest of a security that pays interest at maturity.FinancialExcel
- AMORLINCReturns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.FinancialExcel
- COUPDAYBSCalculates the number of days from the first coupon, or interest payment, until settlement.FinancialExcel
- COUPDAYSCalculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.FinancialExcel
- COUPDAYSNCCalculates the number of days from the settlement date until the next coupon, or interest payment.FinancialExcel
- COUPNCDCalculates next coupon, or interest payment, date after the settlement date.FinancialExcel
- COUPNUMCalculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.FinancialExcel
- COUPPCDCalculates last coupon, or interest payment, date before the settlement date.FinancialExcel
- CUMIPMTCalculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- CUMPRINCCalculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- DBCalculates the depreciation of an asset for a specified period using the arithmetic declining balance method.FinancialExcel
- DDBCalculates the depreciation of an asset for a specified period using the double-declining balance method.FinancialExcel
- DISCCalculates the discount rate of a security based on price.FinancialExcel
- DOLLARDEConverts a price quotation given as a decimal fraction into a decimal value.FinancialExcel
- DOLLARFRConverts a price quotation given as a decimal value into a decimal fraction.FinancialExcel
- DURATIONCalculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value.FinancialExcel
- EFFECTCalculates the annual effective interest rate given the nominal rate and number of compounding periods per year.FinancialExcel
- FVCalculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- FVSCHEDULECalculates the future value of some principal based on a specified series of potentially varying interest rates.FinancialExcel
- INTRATECalculates 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.FinancialExcel
- IPMTCalculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- IRRCalculates the internal rate of return on an investment based on a series of periodic cash flows.FinancialExcel
- ISPMTThe ISPMT function calculates the interest paid during a particular period of an investment.FinancialExcel
- MDURATIONCalculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.FinancialExcel
- MIRRCalculates 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.FinancialExcel
- NOMINALCalculates the annual nominal interest rate given the effective rate and number of compounding periods per year.FinancialExcel
- NPERCalculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- NPVCalculates the net present value of an investment based on a series of periodic cash flows and a discount rate.FinancialExcel
- PDURATIONReturns the number of periods for an investment to reach a specific value at a given rate.FinancialExcel
- PMTCalculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- PPMTCalculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- PRICECalculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.FinancialExcel
- PRICEDISCCalculates the price of a discount (non-interest-bearing) security, based on expected yield.FinancialExcel
- PRICEMATCalculates the price of a security paying interest at maturity, based on expected yield.FinancialExcel
- PVCalculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.FinancialExcel
- RATECalculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.FinancialExcel
- RECEIVEDCalculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.FinancialExcel
- RRIReturns the interest rate needed for an investment to reach a specific value within a given number of periods.FinancialExcel
- SLNCalculates the depreciation of an asset for one period using the straight-line method.FinancialExcel
- SYDCalculates the depreciation of an asset for a specified period using the sum of years digits method.FinancialExcel
- TBILLEQCalculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.FinancialExcel
- TBILLPRICECalculates the price of a US Treasury Bill based on discount rate.FinancialExcel
- TBILLYIELDCalculates the yield of a US Treasury Bill based on price.FinancialExcel
- VDBReturns the depreciation of an asset for a particular period (or partial period).FinancialExcel
- XIRRCalculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.FinancialExcel
- XNPVCalculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.FinancialExcel
- YIELDCalculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.FinancialExcel
- YIELDDISCCalculates the annual yield of a discount (non-interest-bearing) security, based on price.FinancialExcel
- YIELDMATCalculates the annual yield of a security paying interest at maturity, based on price.FinancialExcel
More Google Sheets function categories