beautypg.com

Chapter 6: financial functions, Listing of financial functions, Chapter 6: financial functions – Apple iWork '09 User Manual

Page 96: 96 listing of financial functions, Financial functions

background image

96

The financial functions help you work with cash flows,

depreciable assets, annuities, and investments by solving

problems such as the amount of annual depreciation of an

asset, the interest earned on an investment, and the current

market price of a bond.

Listing of Financial Functions

iWork provides these financial functions for use with tables.

Function

Description

“ACCRINT” (page 99)

The ACCRINT function calculates the accrued
interest added to the purchase price of a security
and paid to the seller when the security pays
periodic interest.

“ACCRINTM” (page 101)

The ACCRINTM function calculates the total
accrued interest added to the purchase price of a
security and paid to the seller when the security
pays interest only at maturity.

“BONDDURATION” (page 103)

The BONDDURATION function calculates the
weighted average of the present value of the
cash flows for an assumed par value of $100.

“BONDMDURATION” (page 104)

The BONDMDURATION function calculates the
modified weighted average of the present value
of the cash flows for an assumed par value of
$100.

“COUPDAYBS” (page 105)

The COUPDAYBS function returns the number
of days between the beginning of the coupon
period in which settlement occurs and the
settlement date.

“COUPDAYS” (page 107)

The COUPDAYS function returns the number of
days in the coupon period in which settlement
occurs.

6

Financial Functions