Loading ...
Loading ...
Loading ...
ΣInt()
Catalog >
Amortization function that calculates the
sum of the interest during a specified range
of payments.
NPmt1 and NPmt2 define the start and end
boundaries of the payment range.
N, I, PV, Pmt, FV, PpY, CpY, and PmtAt
are described in the table of TVM
arguments, page 161.
• If you omit Pmt, it defaults to
Pmt=tvmPmt
(N,I,PV,FV,PpY,CpY,PmtAt).
• If you omit FV, it defaults to FV=0.
• The defaults for PpY, CpY, and PmtAt
are the same as for the TVM functions.
roundValue specifies the number of
decimal places for rounding. Default=2.
ΣInt(NPmt1,NPmt2,amortTable) calculates
the sum of the interest based on
amortization table amortTable. The
amortTable argument must be a matrix in
the form described under amortTbl(), page
7.
Note: See also ΣPrn(), below, and Bal(),
page 15.
ΣPrn()
Catalog >
ΣPrn(NPmt1, NPmt2, N, I, PV, [Pmt],
[FV], [PpY], [CpY], [PmtAt],
[roundValue]) ⇒ value
ΣPrn(NPmt1, NPmt2, amortTable) ⇒
value
Amortization function that calculates the
sum of the principal during a specified
range of payments.
NPmt1 and NPmt2 define the start and end
boundaries of the payment range.
N, I, PV, Pmt, FV, PpY, CpY, and PmtAt
are described in the table of TVM
arguments, page 161.
Symbols 187
Loading ...
Loading ...
Loading ...