|PVM (AnnPmt, InterestAER, TermYrs, PmtsPerYear, [FVOpt])|
|Present Value of an Annuity allowing for different periodicity of payments per year|
|Calculates the Net Present Value of a simple annuity, taking into account that the annual payments specified may take place during the course of the year.|
For Excel Experts
Note that. although similar to the Excel function the order of parameters is different. All the parameters have the same meaning except for PmtsPerYear, which allows for many more permutations that Excel"s type argument. Note also that all parameters except FV are mandatory.
Sign Convention: BF follows Excel"s sign convention, which can occasionally cause confusion.
TemplatesThis function features in the following downloadable spreadsheet template(s):