JavaScript Editor JavaScript Editor     JavaScript Debugger

Previous Section Next Section

Main Page

Handling Financial Data

You finally landed that big programming job at MegaMegaBank—congratulations! But now there's some trouble—just what is an "internal rate of return" anyway? Visual Basic to the rescue—there are 13 Visual Basic functions devoted entirely to financial work, and they appear in Table 2.12.

Table 2.12: The Visual Basic financial functions.

To do this

Use this

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

Previous Section Next Section




JavaScript Editor Free JavaScript Editor     JavaScript Editor