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

Syntax Description

COUPPCD(settlement;

maturity; frequency; basis)

Returns the date of the interest date prior to 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.

CUMIPMT(rate; NPER; PV; S;

E; type)

Calculates the cumulative interest payments (the

total interest) for an investment based on a constant

interest rate. Rate is the periodic interest rate.

NPER is the payment period with the total number

of periods. NPER can also be a non-integer value.

The rate and NPER must refer to the same unit, and

thus both must be calculated annually or monthly.

PV is the current value in the sequence of payments.

S is the first period. E is the last period. Type is the

due date of the payment at the beginning (1) or end

(0) of each period.

CUMIPMT_ADD(rate; NPER;

PV; start_period; end_period;

type)

Calculates the accumulated interest for a period.

Rate is the interest rate for each period. NPER is

the total number of payment periods. The rate and

NPER must refer to the same unit, and thus both

must be calculated annually or monthly. PV is the

current value. Start_period the first payment period

for the calculation. End_period the last payment

period for the calculation. Type is the due date of the

payment at the beginning (1) or end (0) of each

period.

CUMPRINC(rate; NPER; PV;

S; E; type)

Returns the cumulative interest paid for an

investment period with a constant interest rate. Rate

is the periodic interest rate. NPER is the payment

period with the total number of periods. NPER can

also be a non-integer value. The rate and NPER

must refer to the same unit, and thus both must be

calculated annually or monthly. PV is the current

value in the sequence of payments. S is the first

period. E is the last period. Type is the due date of

the payment at the beginning (1) or end (0) of each

period.

CUMPRINC_ADD(rate; NPER;

PV; start_period; end_period;

type)

Calculates the cumulative redemption of a loan in a

period. Rate is the interest rate for each period.

NPER is the total number of payment periods. The

rate and NPER must refer to the same unit, and

thus both must be calculated annually or monthly.

PV is the current value. Start period is the first

payment period for the calculation. End period is

the last payment period for the calculation. Type is

the due date of the payment at the beginning (1) or

end (0) of each period.

384 OpenOffice.org 3.3 Calc Guide

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

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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