◄Contents► ◄Index► ◄Back► ────────────────────────────────────────────────────────────────────────────── Financial Functions available in Professional Edition only ────────────────────────────────────────────────────────────────────────────── Financial Function Summary ■ The following functions are used in Visual Basic to return values used in financial operations: ◄DDB#► Returns depreciation using double-declining-balance method ◄FV#► Returns future value of annuity ◄IPmt#► Returns interest payment for given period of an annuity ◄IRR#► Returns the internal rate of return ◄MIRR#► Returns modified internal reate of return ◄NPer#► Returns number of periods for investment ◄NPV#► Returns net present value of investment ◄Pmt#► Returns payment for investment ◄PPmt#► Returns principal payment for given period of annuity ◄PV#► Returns present value of series of payments ◄Rate#► Returns interest rate per period for annuity ◄SLN#► Returns depreciation using straight-line method ◄SYD#► Returns depreciation using sum-of-years' digits method See: ◄Keywords By Task► ◄Mathematical Operations►