Npv
The Npv function returns the net present value based on a series of periodic cash flows and a discount rate.
Usage:
= Npv(<rate>,<value_or_range>[,<value_or_range>...])
Rate is the rate of discount over the length of one period.
Value_or_range are a series of ordered payments and income.
Example:
/* returns 1188.44 */
= Fixed(Npv(10%, -10000, 3000, 4200, 6800), 2)