VBA Financial Function

VBA Financial Functions

VBA Financial Functions:

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

List of VBA Functions:

Please click on below link to go back to see all List of VBA Functions.

List of VBA Functions

Leave a Comment

Your email address will not be published. Required fields are marked *