89
Computing with date and time representations
You can use date and time representations in arithmetic
expressions. For example:
date_representation
+
days
Returns a new date plus a given
number of days (
days
).
date_representation
-
days
Returns a new date minus a given
number of days (
days
).
date_representation_date
-
representation
Returns the number of days difference
between the two dates.
Financial functions
In the following table, the optional parameters are
shown in italic.
DDB(cost, salvage, life, period,
factor
)
Calculates double-declining (or specified) balance
depreciation for an asset, acquired at cost, with
the specified life and estimated final salvage, for
the specified period. It assumes the rate at which
the balance declines to be 2 (double-declining) if
factor is omitted. Accelerates the depreciation
rate, to give larger depreciation in earlier periods.
Example: DDB(5500,900,4,1) returns 2750.
DDB(2400,300,10,2,1.5) returns 306.
FV(rate, nper, pmt,
pv
,
type
)
Calculates the future value for fixed payments pmt
made for the number of periods nper, at a
constant interest rate.
pv
is the lump-sum amount
that a series of future payments is worth right now.
It is assumed to be 0 if
pv
is omitted. The function
assumes that payments are made at the end of
each period if
type
is 0 or omitted, at the begin-
ning of the month, if
type
is equal to 1.
Example: FV(0.083,25,-1500) returns 114583.
FV(0.5%,10,-200,-500,1) returns 2581.40.
Comments to this Manuals