Net Present Value
Syntax:
netpresentvalue(Discount Rate, Future Cashflows Column)
Calculates the net present value of an investment based on a list or column of periodic cash flows and a discount rate. npv()
is the compact format for readability.