Juniper Systems Allegro DOS Manual - Manual (Page 138)

Page 4-72 Windows CE
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 specified 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(1999, 1, 1)) equals 1999.
DateValue(dateText) Converts a date in the form of text to a serial
number.
Example: DateValue(“1/1/99”) equals 36161.
Day(date) Returns the day of a date.
Example: Day(1/1/99) equals 1.
Hour(time) Returns the hour of a time.
Example: Hour(2:45) equals 2.
Minute(time) Returns the minutes of a time.
Example: Minute(2:45) equals 45.
Month(date) Returns the month of a date.
Example: Month(1/1/99) equals 1.
Now() Returns the current date and time.
Second(time) Returns the seconds of a time.
Example: Second(Time(1, 45, 20)) equals 20.
Time(hour, min, sec) Returns a particular time. Time(1,45,0) equals 1:45.
TimeValue(timeText) Converts a time in the form of text to a serial
number. TimeValue(“1:45”) equals 0.072917.