Apple Numbers '08 - Manual (Page 254)

254 Chapter 12 Dictionary of Functions
NPV
The NPV function calculates the net present value of an investment based on a series of
future cash flows, assuming a fixed interest rate.
NPV(rate, cash-flow, [cash-flow, . . .])
 rate: The fixed interest rate.
 cash-flow: One or more cash flows, such as payments (negative values) or income
(positive values). Specify the values in chronological order. Ranges can be used for
values.
ODD
The ODD function rounds a number away from zero to the next odd number.
ODD(number)
 number: The number you want to round. It can be a number, numeric expression, or
a reference to a cell containing a numeric expression.
Notes
To round to an even number, use the EVEN function.
Examples
NPER(0.1/12,-100,1000) returns 10.5 months, which you would round to 11, the time it takes to pay off a
$1,000 loan at an annual interest rate of 10% if you make monthly payments of $100.
Examples
NPV(10%,-5000,0,10000,10000,10000) returns $16007.04 (when using the currency number format). The
return value indicates that the net present value of a $5,000 investment at 10% interest, followed by
an income flow of $0, $10,000, $10,000, and $10,000, is $16,007.04 after four years.
Examples
ODD(1) returns 1.
ODD(2) returns 3.
ODD(2.5) returns 3.
ODD(-2.5) returns -3.
ODD(0) returns 1.