OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 391)

Syntax Description

SYD(cost; salvage; life;

period)

Returns the arithmetic-declining depreciation rate.

Use this function to calculate the depreciation

amount for one period of the total depreciation span

of an object. Arithmetic declining depreciation

reduces the depreciation amount from period to

period by a fixed sum. Cost is the initial cost of an

asset. Salvage is the value of an asset after

depreciation. Life is the period fixing the time span

over which an asset is depreciated. Period defines

the period for which the depreciation is to be

calculated.

TBILLEQ(settlement;

maturity; discount)

Calculates the annual return on a treasury bill.

Settlement is the date of purchase of the security.

Maturity is the date on which the security matures

(expires). (The settlement and maturity date must be

in the same year.) Discount is the percentage

discount on acquisition of the security.

TBILLPRICE(settlement;

maturity; discount)

Calculates the price of a treasury bill per 100

currency units. Settlement is the date of purchase

of the security. Maturity is the date on which the

security matures (expires). Discount is the

percentage discount upon acquisition of the security.

TBILLYIELD(settlement;

maturity; price)

Calculates the yield of a treasury bill. Settlement is

the date of purchase of the security. Maturity is the

date on which the security matures (expires). Price

is the price (purchase price) of the treasury bill per

100 currency units of par value.

VDB(cost; salvage; life; start;

end; factor; type)

Returns the depreciation of an asset for a specified

or partial period using a variable declining balance

method. Cost is the initial value of an asset. Salvage

is the value of an asset at the end of the

depreciation. Life is the depreciation duration of the

asset. Start is the start of the depreciation entered

in the same date unit as the life. End is the end of

the depreciation. Factor (optional) is the

depreciation factor. FA=2 is double rate

depreciation. Type (optional) defines whether the

payment is due at the beginning (1) or the end (0) of

a period.

XIRR(values; dates; guess) Calculates the internal rate of return for a list of

payments which take place on different dates. The

calculation is based on a 365 days per year basis,

ignoring leap years. If the payments take place at

regular intervals, use the IRR function. Values and

dates are a series of payments and the series of

associated date values entered as cell references.

Guess (optional) is a guess for the internal rate of

return. The default is 10%.

Appendix B Description of Functions 391

1 2 ... 386 387 388 389 390 391 392 393 394 395 396 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 391

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3