Juniper-systems Allegro CX Manual Manual de usuario descargar pdf (Pagina 159)

Allegro CX Owner’s Manual 159

PPmt(rate, per, nper, pv, fv, type)

Returns the payment on the principal for a given period of an

investment. For more information see Pmt.

Example: Ppmt(0.01, 1, 36, 1000) equals -23.21.

Pv(rate, nper, pmt, fv, type)

Returns the present value of an investment. For more information

see Pmt.

Example: Pv(0.01, 5*12, 1000, 0) equals -44955.04.

Rate(nper, pmt, pv, fv, type, guess)

Returns the interest rate per period of an annuity. For more

information see Pmt. Guess is your guess for what the rate will be.

Example: Rate(36, -300, 10000, 0) equals 0.42%.

Sln(cost, salvage, life)

Returns the straight-line depreciation of an asset for one period. Cost

is the initial cost of the asset. Salvage is the value at the end of the

depreciation. Life is the number of periods.

Example: Sln(40000, 5000, 8) equals 4375.

Syd(cost, salvage, life, period)

Returns the sum-of-years’ digits depreciation of an asset for a

speciﬁ ed period. Cost is the initial cost of the asset. Salvage is the

value at the end of the depreciation. Life is the number of periods.

Period is the period.

Example: Syd(40000, 5000, 8, 8) equals 972.22.

Date & Time Functions

Date(year, month, day)

Returns a particular date.

Example: Year(Date(2003, 1, 1)) equals 2003.

DateValue(dateText)

Converts a date in the form of text to a serial number.

Example: DateValue(“1/1/03”) equals 36161.

Day(date)

Returns the day of a date.

Example: Day(1/1/03) equals 1.

1 2 ... 154 155 156 157 158 159 160 161 162 163 164 ... 303 304

Sin comentarios

Juniper-systems Allegro CX Manual Manual de usuario Pagina 159