PO.ECON.NPV.Monthly


Description

Net present value of a column of monthly cash flows at an annual discount rate. Each flow is taken at the end of its month, so the k-th flow is divided by (1 + i)^(k/12), where i is the annual rate. The monthly rate (1 + i)^(1/12) − 1 is the one that compounds to i over twelve months, so a flow twelve months out is discounted by exactly one year. Any currency works; the result is in the same currency.

Formula

=LAMBDA(cash,annual_rate,NPV((1+annual_rate)^(1/12)-1,cash))

Parameters

Parameter Unit Description
cash currency Monthly cash flows, first month first (a column or a row)
annual_rate fraction Annual discount rate, effective (0.1 for 10 %)

Examples

Invocation Expected
=PO.ECON.NPV.Monthly({0;0;0;0;0;0;0;0;0;0;0;1100}, 0.1) 1000
=PO.ECON.NPV.Monthly({100;100;100;100;100;100;100;100;100;100;100;100}, 0.1) 1140.048783

Need a custom LAMBDA? Suggest a New Lambda