OpenOffice.org OpenOffice - 3.2 Guide de base télécharger pdf (Page 441)

Syntax Description

(settlement; maturity;

coupon; yield; frequency;

basis)

security in years. Settlement is the date of

purchase of the security. Maturity is the date

on which the security matures (expires).

Coupon is the annual coupon interest rate

(nominal rate of interest). Yield is the annual

yield 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.

EFFECT_ADD(nominal

_rate; Npery)

Calculates the effective annual rate of interest

on the basis of the nominal interest rate and

the number of interest payments per annum.

Nominal interest refers to the amount of

interest due at the end of a calculation period.

Nominal_rate is the annual nominal rate of

interest. Npery is the number of interest

payments per year.

EFFECTIVE(NOM; P) Calculates the effective annual rate of interest

on the basis of the nominal interest rate and

the number of interest payments per annum.

Nominal interest refers to the amount of

interest due at the end of a calculation period.

NOM is the nominal interest. P is the number

of interest payment periods per year.

FV(rate; NPER; PMT; PV;

type)

Returns the future value of an investment

based on periodic, constant payments and a

constant interest rate. Rate is the periodic

interest rate. NPER is the total number of

periods. PMT is the annuity paid regularly per

period. PV (optional) is the present cash value

of an investment. Type (optional) defines

whether the payment is due at the beginning

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

FVSCHEDULE(principal;

schedule)

Calculates the accumulated value of the

starting capital for a series of periodically

varying interest rates. Principal is the

starting capital. Schedule is a series of

interest rates. Schedule has to be entered

with cell references.

INTRATE(settlement;

maturity; investment;

redemption; basis)

Calculates the annual interest rate that results

when a security (or other item) is purchased at

an investment value and sold at a redemption

value with no interest being paid. Settlement

is the date of purchase of the security.

Appendix B Description of Functions 441

1 2 ... 436 437 438 439 440 441 442 443 444 445 446 ... 496 497

Commentaires sur ces manuels

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 441

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel OpenOffice.org OpenOffice - 3.2