beautypg.com

Apple iWork '09 User Manual

Page 154

background image

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 YIELDMAT function is used to determine the effective annual yield of the
hypothetical security described by the values listed. The security pays interest only at maturity.
The function evaluates to 6.565%.

settle

maturity

issue

annual-rate

price

days-basis

=YIELDMAT (B2,
C2, D2, E2, F2,
G2)

05/01/2009

06/30/2015

12/14/2008

0.065

99.002

0

Related Topics
For related functions and additional information, see:

“PRICEMAT” on page 140

“YIELD” on page 150

“YIELDDISC” on page 152

“Common Arguments Used in Financial Functions” on page 341

“Listing of Financial Functions” on page 96

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

154

Chapter 6

Financial Functions