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

Syntax Description

DB(cost; salvage; life; period;

month)

Returns the depreciation of an asset for a specified

period using the double-declining balance method.

Cost is the initial cost of an asset. Salvage is the

value of an asset at the end of the depreciation. Life

defines the period over which an asset is

depreciated. Period is the length of each period. The

life must be entered in the same date unit as the

depreciation period. Month (optional) denotes the

number of months for the first year of depreciation.

DDB(cost; salvage; life;

period; factor)

Returns the depreciation of an asset for a specified

period using the arithmetic-declining method. Note

that the book value will never reach zero under this

calculation type. Cost fixes the initial cost of an

asset. Salvage fixes the value of an asset at the end

of its life. Life is the number of periods defining how

long the asset is to be used. Period defines the

length of the period. The period must be entered in

the same time unit as the life. Factor (optional) is

the factor by which depreciation decreases.

DISC(settlement; maturity;

price; redemption; basis)

Calculates the allowance (discount) of a security as a

percentage. Settlement is the date of purchase of

the security. Maturity is the date on which the

security matures (expires). Price is the price of the

security per 100 currency units of par value.

Redemption is the redemption value of the security

per 100 currency units of par value. Basis indicates

how the year is to be calculated.

DOLLARDE(fractional _dollar;

fraction)

Converts a quotation that has been given as a

decimal fraction into a decimal number.

Fractional_dollar is a number given as a decimal

fraction. (In this number, the decimal value is the

numerator of the fraction.) Fraction is a whole

number that is used as the denominator of the

decimal fraction.

DOLLARFR(decimal _dollar;

fraction)

Converts a quotation that has been given as a

decimal number into a mixed decimal fraction. The

decimal of the result is the numerator of the fraction

that would have Fraction as the denominator.

Decimal_dollar is a decimal number. Fraction is a

whole number that is used as the denominator of the

decimal fraction.

DURATION(rate; PV; FV) Calculates the number of periods required by an

investment to attain the desired value. Rate (a

constant) is the interest rate to be calculated for the

entire duration. Entering the interest rate divided by

the periods per year, can calculate the interest after

each period. PV is the present value. FV is the

desired future value of the investment.

Appendix B Description of Functions 385

1 2 ... 380 381 382 383 384 385 386 387 388 389 390 ... 433 434

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

Žádné komentáře

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

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

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