Financial

Element

Description

DDB function

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

FV function

Calculates the future value of an annuity

IPmt function

Computes the interest payment for a given period of an annuity

IRR function

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

MIRR function

Calculates the modified internal rate of return

NPer function

Determines the number of payment periods for an annuity, based on fixed periodic payments and a fixed interest rate

NPV function

Calculates the net present value of an investment

Pmt function

Calculates the payment for an annuity

PPmt function

Computes the payment of principal for a given period of an annuity

PV function

Calculates the present value of an annuity

Rate function

Returns the interest rate per period for an annuity

SLN method

Computes the straight-line depreciation of an asset

SYD function

Computes the sum-of-years’ digits depreciation of an asset for a specified period

Get VB .NET Language in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.