Financial

DDB

Return depreciation of an asset using double-declining balance method

Fv

Return the future value of an annuity

IPmt

Return the interest payment for a given period of an annuity

IRR

Return the internal rate of return for a series of payments and receipts

MIRR

Return the modified internal rate of return

NPer

Return the number of periods of an annuity

Npv

Return the net present value of an annuity

Pmt

Return the payment for an annuity

PPmt

Return the principal payment for a given period of an annuity

Pv

Return the present value of an annuity

Rate

Return the interest rate for each period of an annuity

Sln

Return the straight-line depreciation of an asset

SYD

Return the Sum of Years' Digits depreciation of an asset

More information

Language elements by category