Financial Keyword Summary

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Action

Keywords

Calculate depreciation.

DDB, SLN, SYD

Calculate future value.

FV

Calculate interest rate.

Rate

Calculate internal rate of return.

IRR, MIRR

Calculate number of periods.

NPer

Calculate payments.

IPmt, Pmt, PPmt

Calculate present value.

NPV, PV