Calc Guide

Syntax Description
same unit, and thus both must be calculated
annually or monthly. PV is the current value.
Start_period the first payment period for the
calculation. End_period the last payment
period for the calculation. Type is the due date
of the payment at the beginning (1) or end (0)
of each period.
CUMPRINC(rate; NPER;
PV; S; E; type)
Returns the cumulative interest paid for an
investment period with a constant interest
rate. Rate is the periodic interest rate. NPER
is the payment period with the total number of
periods. NPER can also be a non-integer value.
The rate and NPER must refer to the same
unit, and thus both must be calculated
annually or monthly. PV is the current value in
the sequence of payments. S is the first period.
E is the last period. Type is the due date of the
payment at the beginning (1) or end (0) of
each period.
CUMPRINC_ADD(rate;
NPER; PV; start_period;
end_period; type)
Calculates the cumulative redemption of a
loan in a period. Rate is the interest rate for
each period. NPER is the total number of
payment periods. The rate and NPER must
refer to the same unit, and thus both must be
calculated annually or monthly. PV is the
current value. Start period is the first
payment period for the calculation. End
period is the last payment period for the
calculation. Type is the due date of the
payment at the beginning (1) or end (0) of
each period.
DB(cost; salvage; life;
period; month)
Returns the depreciation of an asset for a
specified period using the double-declining
balance method. Cost is the initial cost of an
asset. Salvage is the value of an asset at the
end of the depreciation. Life defines the period
over which an asset is depreciated. Period is
the length of each period. The life must be
entered in the same date unit as the
depreciation period. Month (optional) denotes
the number of months for the first year of
depreciation.
DDB(cost; salvage; life;
period; factor)
Returns the depreciation of an asset for a
specified period using the arithmetic-declining
Appendix B Description of Functions 439