# Finance

• 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.