VB & VBA in a Nutshell: The Language

A.10. Financial Functions

DDB Function

Returns double-declining balance depreciation of an asset for a specific period

FV Function

Returns the future value of an annuity

IPmt Function

Returns the interest payment for a given period of an annuity

IRR Function

Returns the internal rate of return for a series of periodic cash flows

MIRR Function

Returns the modified internal rate of return for a series of periodic cash flows

NPer Function

Returns the number of periods for an annuity

NPV Function

Returns the net present value of an investment

Pmt Function

Returns the payment for an annuity

PPmt Function

Returns the principal payment for a given period of an annuity

PV Function

Returns the present value of an annuity

Rate Function

Returns the interest rate per period for an annuity

SLN Function

Returns the straight-line depreciation of an asset for a single period

SYD Function

Returns the sum-of-years' digits depreciation on an asset