OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 389)

Syntax Description

ODDLYIELD(settlement;

maturity; last_interest; rate;

price; redemption; frequency;

basis)

Calculates the yield of a security if the last interest

date falls irregularly. Settlement is the date of

purchase of the security. Maturity is the date on

which the security matures (expires). Last_interest

is the last interest date of the security. Rate is the

annual rate of interest. Price is the price of the

security. Redemption is the redemption value per

100 currency units of par value. Frequency is the

number of interest payments per year (1, 2 or 4).

Basis indicates how the year is to be calculated.

PMT(rate; NPER; PV; FV;

type)

Returns the periodic payment for an annuity with

constant interest rates. Rate is the periodic interest

rate. NPER is the number of periods in which

annuity is paid. PV is the present value (cash value)

in a sequence of payments. FV (optional) is the

desired value (future value) to be reached at the end

of the periodic payments. Type (optional) defines

whether the payment is due at the beginning (1) or

the end (0) of a period.

PPMT(rate; period; NPER; PV;

FV; type)

Returns for a given period the payment on the

principal for an investment that is based on periodic

and constant payments and a constant interest rate.

Rate is the periodic interest rate. Period is the

amortization period. NPER is the total number of

periods during which annuity is paid. PV is the

present value in the sequence of payments. FV

(optional) is the desired (future) value. Type

(optional) defines whether the payment is due at the

beginning (1) or the end (0) of a period.

PRICE(settlement; maturity;

rate; yield; redemption;

frequency; basis)

Calculates the market value of a fixed interest

security with a par value of 100 currency units as a

function of the forecast yield. Settlement is the date

of purchase of the security. Maturity is the date on

which the security matures (expires). Rate is the

annual nominal rate of interest (coupon interest

rate). Yield is the annual yield of the security.

Redemption is the redemption value per 100

currency units of par value. Frequency is the

number of interest payments per year (1, 2 or 4).

Basis indicates how the year is to be calculated.

PRICEDISC(settlement;

maturity; discount;

redemption; basis)

Calculates the price per 100 currency units of par

value of a non-interest-bearing security. Settlement

is the date of purchase of the security. Maturity is

the date on which the security matures (expires).

Discount is the discount of a security as a

percentage. Redemption is the redemption value

per 100 currency units of par value. Basis indicates

how the year is to be calculated.

Appendix B Description of Functions 389

1 2 ... 384 385 386 387 388 389 390 391 392 393 394 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 389

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3