**FINANCE.ACCRINT**— Calculate the accrued interest of a security that has periodic payments.**FINANCE.CUMIPMT**— Calculate the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.**FINANCE.CUMPRINC**— Calculate the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.**FINANCE.DB**— Calculate the depreciation of an asset for a specified period using the arithmetic declining balance method.**FINANCE.DDB**— Calculate the depreciation of an asset using the double-declining balance method.**FINANCE.DOLLARDE**— Converts a price quotation given as a decimal fraction into a decimal value.**FINANCE.DOLLARFR**— Converts a price quotation given as a decimal value into a decimal fraction.**FINANCE.EFFECT**— Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.**FINANCE.FV**— Calculates the future value of an investment with period constant payments and a constant interest rate.**FINANCE.FVSCHEDULE**— Calculates the future value of an initial principal, after applying a series of compound interest rates.**FINANCE.IPMT**— Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.**FINANCE.IRR**— Calculates the internal rate of return for a series of cash flows.**FINANCE.IRR_WITH_ESTIMATE**— Calculates the internal rate of return for a series of cash flows, compatible with popular spreadsheet`IRR`

methods.**FINANCE.ISPMT**— Calculates the interest payment for an investment based on an interest rate and constant payment schedule.**FINANCE.MIRR**— Calculates the internal rate of return for a series of period cash flows, considering the cost of the investment and the interest on the reinvestment of cash.**FINANCE.NOMINAL**— Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.**FINANCE.NPER**— Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.**FINANCE.NPV**— Calculates the number of periods required by an investment to reach a specified value.**FINANCE.PDURATION**— Calculates the number of periods required by an investment to reach a specified value.**FINANCE.PMT**— Calculates the period payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.**FINANCE.PPMT**— Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.**FINANCE.PV**— Calculates the present value of an investment, based on constant-amount periodic payments and a constant interest rate.**FINANCE.RATE**— Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the association of a constant interest rate.**FINANCE.RRI**— Calculates an euqivalent interest rate for the growth of an investment.**FINANCE.SLN**— Calculates the depreciation of an asset for one period using the straight-line method.**FINANCE.SYD**— Calculates the depreciation of an asset for a specified period using the sum of years digits method.**FINANCE.TBILLEQ**— Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.**FINANCE.TBILLPRICE**— Calculates the price of a US Treasury Bill based on discount rate.**FINANCE.TBILLYIELD**— Calculates the return of a US Treasury Bill based on price.**FINANCE.XIRR**— Calculates the internal rate of return for a schedule of cash flows.**FINANCE.XPNV**— Calculates the net present value for a schedule of cash flows.