Apple iWork '09 - Manual (Page 146)

RECEIVED
The RECEIVED function returns the maturity value for a security that pays interest only
at maturity.
RECEIVED(settle, maturity, invest-amount, annual-rate, days-basis)
 settle: The trade settlement date. settle is a date/time value. The trade settlement
date is usually one or more days after the trade date.
 maturity: The date when the security matures. maturity is a date/time value. It must
be after settle.
 invest-amount: The amount invested in the security. invest-amount is a number
value and must be greater than or equal to 0.
 annual-rate: The annual coupon rate or stated annual interest rate of the security.
annual-rate is a number value and is either entered as a decimal (for example, 0.08)
or with a percent sign (for example, 8%).
 days-basis: An optional argument specifying the number of days per month and
days per year used in the calculations.
30/360 (0 or omitted): 30 days in a month, 360 days in a year, using the NASD
method for dates falling on the 31st of a month.
actual/actual (1): Actual days in each month, actual days in each year.
actual/360 (2): Actual days in each month, 360 days in a year.
actual/365 (3): Actual days in each month, 365 days in a year.
30E/360 (4): 30 days in a month, 360 days in a year, using the European method for
dates falling on the 31st of a month (European 30/360).
Example
In this example, the RECEIVED function is used to determine the amount received at the maturity of
the hypothetical security described by the values listed. The security pays interest only at maturity.
The function evaluates to $1,651.83, the amount to be received at maturity including both principal
and interest.
settle maturity invest-amount annual-rate days-basis
=RECEIVED (B2, C2,
D2, E2, F2) 05/01/2009 06/30/2015 990.02 0.065 0
Related Topics
For related functions and additional information, see:
“INTRATE” on page 122
“Common Arguments Used in Financial Functions” on page 341
“Listing of Financial Functions” on page 96
146 Chapter 6 Financial Functions