Visual Basic Financial Functions

And to think, I was about to reinvent the wheel on this one...

Visual basic (and VBA) has a large set of financial functions that you can use.  In the VBA help search for \"Financial Keyword Summary\" and you will get this list of financial functions:

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


Related Scribbles:
  • Visual Basic Notes
  • Finance, Stocks, and Other Such Nonsense
  • MS Access Notes

  • ID: 253
    Date Updated:
    2003-12-23 00:22:55
    Date Created:
    2003-08-07 11:34:28


     >> Leonard Chan's Homepage  >> Scribble Web  >> Visual Basic Financial Functions is hosted by Perceptus Solutions Inc.