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

Syntax Description

NOMINAL_ADD(effective_rate

; Npery)

Calculates the yearly nominal rate of interest, given

the effective rate and the number of compounding

periods per year. Effective_rate is the effective

annual rate of interest. Npery is the number of

interest payments per year.

NPER(rate; PMT; PV; FV;

type)

Returns the number of periods for an investment

based on periodic, constant payments and a constant

interest rate. Rate is the periodic interest rate. PMT

is the constant annuity paid in each period. PV is the

present value (cash value) in a sequence of

payments. FV (optional) is the future value, which is

reached at the end of the last period. Type (optional)

defines whether the payment is due at the beginning

(1) or the end (0) of a period.

NPV(Rate; value_1;

value_2; ... value_30)

Returns the net present value of an investment

based on a series of periodic cash flows and a

discount rate. Rate is the discount rate for a period.

Value_1; value_2;... value_30 are values

representing deposits or withdrawals.

ODDFPRICE(settlement;

maturity; issue; first_coupon;

rate; yield; redemption;

frequency; basis)

Calculates the price per 100 currency units par value

of a security, if the first interest date falls irregularly.

Settlement is the date of purchase of the security.

Maturity is the date on which the security matures

(expires). Issue is the date of issue of the security.

First_coupon is the first interest date of the

security. Rate is the annual rate of interest. Yield is

the annual yield of the security. Redemption is the

redemption value per 100 currency units of par

value. Frequency is the number of interest

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

the year is to be calculated.

ODDFYIELD(settlement;

maturity; issue; first_coupon;

rate; price; redemption;

frequency; basis)

DDB(cost; salvage; life; period; factor)

ODDLPRICE(settlement;

maturity; last_interest; rate;

yield; redemption; frequency;

basis)

Calculates the price per 100 currency units par value

of a security, if the last interest date falls irregularly.

Settlement is the date of purchase of the security.

Maturity is the date on which the security matures

(expires). Last_interest is the last interest date of

the security. Rate is the annual rate of interest.

Yield is the annual yield of the security.

Redemption is the redemption value per 100

currency units of par value. Frequency is the

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

Basis indicates how the year is to be calculated.

388 OpenOffice.org 3.3 Calc Guide

1 2 ... 383 384 385 386 387 388 389 390 391 392 393 ... 433 434

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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