Calc Guide

Syntax Description
period; rate; basis) that is independent of the depreciable life is
used here. Cost is the acquisition cost.
Date_purchased is the date of acquisition.
First_period is the end date of the first
settlement period. Salvage is the salvage
value of the capital asset at the end of the
depreciable life. Period is the settlement
period to be considered. Rate is the rate of
depreciation. Basis indicates how the year is
to be calculated.
AMORLINC(cost;
date_purchased;
first_period; salvage;
period; rate; basis)
Calculates the amount of depreciation for a
settlement period as linear amortization. If the
capital asset is purchased during the
settlement period, the proportional amount of
depreciation is considered. Cost is the
acquisition cost. Date_purchased is the date
of acquisition. First_period is the end date of
the first settlement period. Salvage is the
salvage value of the capital asset at the end of
the depreciable life. Period is the settlement
period to be considered. Rate is the rate of
depreciation. Basis indicates how the year is
to be calculated.
COUPDAYBS(settlement;
maturity; frequency; basis)
Returns the number of days from the first day
of interest payment on a security until the
settlement date. Settlement is the date of
purchase of the security. Maturity is the date
on which the security matures (expires).
Frequency is the number of interest
payments per year (1, 2 or 4). Basis indicates
how the year is to be calculated.
COUPDAYS(settlement;
maturity; frequency; basis)
Returns the number of days in the current
interest period in which the settlement date
falls. Settlement is the date of purchase of
the security. Maturity is the date on which the
security matures (expires). Frequency is the
number of interest payments per year (1, 2 or
4). Basis indicates how the year is to be
calculated.
COUPDAYSNC(settlement;
maturity; frequency; basis)
Returns the number of days from the
settlement date until the next interest date.
Settlement is the date of purchase of the
security. Maturity is the date on which the
security matures (expires). Frequency is the
Appendix B Description of Functions 437