Functions Data, TimeSeries Business Context

Net Present Value/NPV

NPV stands for Net Present Value, and it is a financial metric used in capital budgeting and investment analysis. The Net Present Value represents the difference between the present value of cash inflows and the present value of cash outflows over a specific period of time. It’s a method used to evaluate the profitability of an investment or project.

Datatype: TimeSeries

=TimeSeries(“Portfolio A”, “NPV”, “1 Oct 2023”, “3 Oct 2023”, “p”, “none:none”, “Dataview(Entity, Factor, DeclarationDate, ValueDate, Unit, Value”):Both”, “ZAR”, “D”, IAAD, DataSource, Attributes)

EntityFactorDeclarationDateValueDateUnitValue
Portfolio ANPV1 Oct 20231 Oct 2023ZAR150.5
Portfolio ANPV2 Oct 20232 Oct 2023ZAR110.5
Portfolio ANPV3 Oct 20233 Oct 2023ZAR96.5