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

Syntax Description

AMORLINC(cost;

date_purchased; first_period;

salvage; period; rate; basis)

Calculates the amount of depreciation for a

settlement period as linear amortization. If the

capital asset is purchased during the settlement

period, the proportional amount of depreciation is

considered. Cost is the acquisition cost.

Date_purchased is the date of acquisition.

First_period is the end date of the first settlement

period. Salvage is the salvage value of the capital

asset at the end of the depreciable life. Period is the

settlement period to be considered. Rate is the rate

of depreciation. Basis indicates how the year is to be

calculated.

COUPDAYBS(settlement;

maturity; frequency; basis)

Returns the number of days from the first day of

interest payment on a security until the settlement

date. Settlement is the date of purchase of the

security. Maturity is the date on which the security

matures (expires). Frequency is the number of

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

indicates how the year is to be calculated.

COUPDAYS(settlement;

maturity; frequency; basis)

Returns the number of days in the current interest

period in which the settlement date falls.

Settlement is the date of purchase of the security.

Maturity is the date on which the security matures

(expires). Frequency is the number of interest

payments per year (1, 2 or 4). Basis indicates how

the year is to be calculated.

COUPDAYSNC(settlement;

maturity; frequency; basis)

Returns the number of days from the settlement date

until the next interest date. Settlement is the date

of purchase of the security. Maturity is the date on

which the security matures (expires). Frequency is

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

Basis indicates how the year is to be calculated.

COUPNCD(settlement;

maturity; frequency; basis)

Returns the date of the first interest date after the

settlement date, and formats the result as a date.

Settlement is the date of purchase of the security.

Maturity is the date on which the security matures

(expires). Frequency is the number of interest

payments per year (1, 2 or 4). Basis indicates how

the year is to be calculated.

COUPNUM(settlement;

maturity; frequency; basis)

Returns the number of coupons (interest payments)

between the settlement date and the maturity date.

Settlement is the date of purchase of the security.

Maturity is the date on which the security matures

(expires). Frequency is the number of interest

payments per year (1, 2 or 4). Basis indicates how

the year is to be calculated.

Appendix B Description of Functions 383

1 2 ... 378 379 380 381 382 383 384 385 386 387 388 ... 433 434

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

Žádné komentáře

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

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

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