Note: In order to use the spreadsheet examples, you need to download Business Functions | ||||||||
NPVM (NPVDate, DisAER, AnnualCashFlows, StartAnnDate, PmtsPerYear) | ||||||||
Present Value of annual cash flows that are annually specified that are assumed to take place at intervals over the year | ||||||||
Calculates the Net Present Value of a series of annual cashflows, taking into account that cash flows are dispersed throughout the year according to PmtsPerYear. | ||||||||
General | ||||||||
This function should have been named PVM< for consistency with the other DCF functions, but it clashed with the existing annuity function PVM | ||||||||
Whats good or unique about it | ||||||||
With PmtsPerYear of 1 and an NPVDate equal to the StartAnnDate this gives the same results as Excels NPV function. This function however extends this, principally by allowing the specification of cash flows as occurring throughout the year (either months, quarters etc) and in in advance or arrears. | ||||||||
Key Points | ||||||||
StartAnnDate | ||||||||
ExampleNPVM.xls | ||||||||
TemplatesThis function features in the following downloadable spreadsheet template(s):reallysimpleleaseanalysis.xls |