VBA Financial Functions are help us to perform standard financial and accounting calculations. We use DDB, FV, IPmt, IRR, MIRR, NPer, NPV, Pmt, PPmt, PV, Rate, SLN and SYD financial functions to calculate interest rates, loan payments, annuity etc. These functions are Built-In functions. We use these VBA Financial functions in either procedure or function. These functions we use in the VBA editor window in Excel. These Financial functions you can use any number of times in VBA macro codes or procedures.
List of Financial Functions in Excel VBA:
Here are the list of Financial functions. And also find its description, syntax and return type. We can use these multiple Financial functions in one statement.
Function | Description | Syntax | Returns |
---|---|---|---|
VBA DDB | VBA DDB calculates the future value of an asset over a specified period of time. | DDB(Cost, Salvage, Life, Period, [Factor]) | Double |
VBA FV | VBA FV function calculates the future value of an annuity. | FV(Rate,NPer,Pmt, [PV], [Due]) | Double |
VBA IPmt | VBA IPmt function calculates the interest part of a payment in a specific period of regular interval time. | IPmt(Rate, Per, NPer, PV, [FV], [Due]) | Double |
VBA IRR | VBA IRR function calculates the interest rate of return for a series of unequal cash flows at regular intervals. | IRR(ValueArray(), [Guess]) | Double |
VBA MIRR | VBA MIRR function calculates the modified interest rate of return for a series of unequal cash flows at regular intervals. | MIRR(ValueArray(), FinanceRate, ReinvestRate) | Double |
VBA NPer | VBA NPer function calculates the number of periods for an annuity. | NPer(Rate, Pmt, PV, [FV], [Due]) | Double |
VBA NPV | VBA NPV function calculates the net present value of an annuity. | NPV(Rate, ValueArray()) | Double |
VBA Pmt | VBA Pmt function calculates the number of periodic payments of an annuity. | Pmt(Rate, NPer, PV, [FV], [Due]) | Double |
VBA PPmt | VBA PPmt function calculates the principal amount paid in a specific period for an annuity. | PPmt(Rate, Per, NPer, PV, [FV], [Due]) | Double |
VBA PV | VBA PV function calculates the present value of an annuity. | PV(Rate, NPer, Pmt, [FV], [Due]) | Double |
VBA Rate | VBA Rate function calculates the interest rate per payment period of an annuity. | Rate(NPer, Pmt, PV, [FV], [Due], [Guess]) | Double |
VBA SLN | VBA SLN function calculates the straight line depreciation of an asset for a single period of time. | SLN(Cost, Salvage, Life) | Double |
VBA SYD | VBA SYD function calculates the sum of years’ digits depreciation of an asset for a specific period of time. | SYD(Cost, Salvage, Life, Period) | Double |
Other Useful Resources:
Click on the following links of the useful resources. These helps to learn and gain more knowledge.
VBA Tutorial VBA Functions List VBA Arrays in Excel Blog
VBA Editor Keyboard Shortcut Keys List VBA Interview Questions & Answers