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

leonard

2003-12-23 00:22:55

2003-08-07 11:34:28

Comments?

>> Leonard Chan's Homepage
>> Scribble Web
>> Visual Basic Financial Functions

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.