Juniper Systems Allegro CX Manual - Manual (Page 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
specifi 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.