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.
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 |