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.