Apple numbers User Manual

    Dictionary of Functions 

 

  

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.

  

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.
  

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.

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.

ODD(1) returns 1.

ODD(2) returns 3.

ODD(2.5) returns 3.

ODD(-2.5) returns -3.

ODD(0) returns 1.