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

Table 35: Basis calculation types

Basis Calculation

0 or missing US method (NASD), 12 months of 30 days each.

1 Exact number of days in months, exact number of days in year.

2 Exact number of days in month, year has 360 days.

3 Exact number of days in month, year has 365 days.

4 European method, 12 months of 30 days each.

Table 36: Financial analysis functions

Syntax Description

ACCRINT(issue; first_interest;

settlement; rate; par;

frequency; basis)

Calculates the accrued interest of a security in the

case of periodic payments. Issue is the issue date of

the security. First_interest is the first interest date

of the security. Settlement is the maturity date.

Rate is the annual nominal rate of interest (coupon

interest rate). Par is the par value of the security.

Frequency is the number of interest payments per

year (1, 2 or 4). Basis indicates how the year is to be

calculated.

ACCRINTM(issue; settlement;

rate; par; basis)

Calculates the accrued interest of a security in the

case of one-off payment at the settlement date. Issue

is the issue date of the security. Settlement is the

maturity date. Rate is the annual nominal rate of

interest (coupon interest rate). Par is the par value

of the security. Basis indicates how the year is to be

calculated.

AMORDEGRC(cost;

date_purchased; first_period;

salvage; period; rate; basis)

Calculates the amount of depreciation for a

settlement period as degressive amortization. Unlike

AMORLINC, a depreciation coefficient that is

independent of the depreciable life is used here.

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.

382 OpenOffice.org 3.3 Calc Guide

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

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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