Apple Numbers '08 - Manual (Page 242)

242 Chapter 12 Dictionary of Functions
ISPMT
The ISPMT function calculates the interest due for a particular payment period of an
investment.
ISPMT(rate, period, num-periods, present-value)
 rate: The interest rate for each period.
 period: The period for which you want to find the interest.
 num-periods: The number of periods in the life of the investment.
 present-value: The present value of the loan or investment.
Notes
This function, which duplicates the capabilities of the IPMT function, helps you to use
spreadsheets from older spreadsheet applications.
Be sure that the interest rate is expressed as the rate per period. For example, if the
interest rate is 10% per year and the payment period is monthly, the rate used in the
function should be 0.1/12 (approximately 0.00833 per month).
LARGE
The LARGE function retrieves the nth-largest value within a range. The largest value is
ranked number 1.
LARGE(range, n)
 range: The array of cells containing the values.
 n: A number representing the size ranking of the value you want to retrieve (1 is
largest, 2 is second-largest, and so on).
Notes
If n is omitted, is less than or equal to 0, or is greater than the number of values in the
range, an error is returned.
Examples
ISODD(3) returns TRUE.
ISODD(3.75) returns TRUE.
ISODD(2) returns FALSE.
Examples
To find the interest portion of the first payment on a $1000 loan at 12% annual interest with payments
due at the end of each month:
IPMT(0.12/12, 1, 12, 1000) returns -$10.