Apple numbers 用户手册

 Dictionary of Functions

 

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.

PRICEMAT (page 260)

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.

RATE (page 265)

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.