Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

NPV

Use this function to calculate the net present value of future cash flows. For each period, net inflow equals inflow minus outflow (outflow is expected to be a positive value). NPV must be used with BY dimension. The symbols in the BY dimension hold the series of values. The result of NPV is stored in the first symbol in the range of symbols in the BY dimension as specified in the calculation block.

Note: To specify the range of symbols in the BY dimension, enter the first and last symbols in the range, separated by a colon. For example, A0601:A0612.

Copy

Syntax

NPV (InflowSymName,Rate[, OutflowSymName])                        

where:

  • InflowSymName is a symbol that contains the cash flows (+ and -).
  • Rate is the interest rate to discount the cash flows at.
  • OutflowSymName is an optional symbol that contains expenditures.
Copy

Syntax example

CalculationBlock(Accounts;TimePeriods A0101:A0112)
BY TimePeriods
  
target = NPV (Chi1,0.12,Chi2)
  
End CalculationBlock                                            
Published:

NPV

Use this function to calculate the net present value of future cash flows. For each period, net inflow equals inflow minus outflow (outflow is expected to be a positive value). NPV must be used with BY dimension. The symbols in the BY dimension hold the series of values. The result of NPV is stored in the first symbol in the range of symbols in the BY dimension as specified in the calculation block.

Note: To specify the range of symbols in the BY dimension, enter the first and last symbols in the range, separated by a colon. For example, A0601:A0612.

Copy

Syntax

NPV (InflowSymName,Rate[, OutflowSymName])                        

where:

  • InflowSymName is a symbol that contains the cash flows (+ and -).
  • Rate is the interest rate to discount the cash flows at.
  • OutflowSymName is an optional symbol that contains expenditures.
Copy

Syntax example

CalculationBlock(Accounts;TimePeriods A0101:A0112)
BY TimePeriods
  
target = NPV (Chi1,0.12,Chi2)
  
End CalculationBlock                                            
For an optimal Community experience, Please view on Desktop