Apple Numbers '08 User Manual

Page 197

Chapter 12

Dictionary of Functions

197

Calculates the net present value of an investment based on a series
of future cash flows and a fixed interest rate.

Calculates fixed, periodic payments given a fixed interest rate, a
number of periods, the present value, the future value, and the
type of payments.

Calculates the principal portion of a payment for a loan or
investment based on periodic fixed payments and a fixed interest
rate.

Calculates the price for a security that pays periodic interest per
$100 par value.

Calculates the price of a discounted security per $100 par value.

Calculates the price of a security that pays interest at maturity per
$100 par value.

Calculates the present value of an investment, given a series of
fixed, periodic payments and a fixed interest rate.

Calculates the interest rate of an annuity (a fixed sum paid
periodically over a specified period of time).

Calculates the straight-line depreciation of an asset during a
period.

Calculates the sum-of-years’-digits depreciation of an asset during
a particular period.

Calculates the depreciation of an asset over a chosen time interval.

Function

Description