Calc Guide

Syntax Description
SLN(cost; salvage; life) Returns the straight-line depreciation of an
asset for one period. The amount of the
depreciation is constant during the
depreciation period. Cost is the initial cost of
an asset. Salvage is the value of an asset at
the end of the depreciation. Life is the
depreciation period determining the number
of periods in the depreciation of the asset.
SYD(cost; salvage; life;
period)
Returns the arithmetic-declining depreciation
rate. Use this function to calculate the
depreciation amount for one period of the total
depreciation span of an object. Arithmetic
declining depreciation reduces the
depreciation amount from period to period by
a fixed sum. Cost is the initial cost of an asset.
Salvage is the value of an asset after
depreciation. Life is the period fixing the time
span over which an asset is depreciated.
Period defines the period for which the
depreciation is to be calculated.
TBILLEQ(settlement;
maturity; discount)
Calculates the annual return on a treasury bill.
Settlement is the date of purchase of the
security. Maturity is the date on which the
security matures (expires). (The settlement
and maturity date must be in the same year.)
Discount is the percentage discount on
acquisition of the security.
TBILLPRICE(settlement;
maturity; discount)
Calculates the price of a treasury bill per 100
currency units. Settlement is the date of
purchase of the security. Maturity is the date
on which the security matures (expires).
Discount is the percentage discount upon
acquisition of the security.
TBILLYIELD(settlement;
maturity; price)
Calculates the yield of a treasury bill.
Settlement is the date of purchase of the
security. Maturity is the date on which the
security matures (expires). Price is the price
(purchase price) of the treasury bill per 100
currency units of par value.
VDB(cost; salvage; life;
start; end; factor; type)
Returns the depreciation of an asset for a
specified or partial period using a variable
declining balance method. Cost is the initial
value of an asset. Salvage is the value of an
Appendix B Description of Functions 447