Tutorial
Column
6
shows the cumulative interest, the interest paid-to-date
for each period.
1.
Move the entry marker to Cell
8,6,
press
0;
then select
ROWS
8-19.
2.
Press
0,
and type
CMT(#RSC4)
(ENTER).
This formula gives
the accumulated totals for all
12
periods plus the final total of
all the values in Column
4,
starting with Row
8,
and displays
these values in Column
6.
For example, the interest paid-to-date
for Period
4
is
displayed in Cell
11,6
and equals the values of
Cells
8,4, 9,4, 10,4,
and
11,4. CMT
stands for
column summa-
tion,
and
#RSC4
tells the computer to always start the
cumulative summing from Cell
8,4
(the interest paid in Period
1).
The last column is for the cumulative principal, the principal paid-
to-date for each period. (After all
12
periods have been calculated,
the last figure in this column, the cumulative principal for Period
12,
will equal the original amount of the loan.)
1.
Move the entry marker to Cell
8,7,
press
0,
and select
2.
Press
0,
and type
CMT(#R8C5)
(ENTER).
The increasing
values in this column show how the loan is gradually being paid
off and retired.
ROWS
8-19.
Calculating and Reformatting a Worksheet
The spreadsheet is now completely set up, and you are ready to per-
form calculations.
1.
Press
ICTRL)
0;
then
(CTRLI
Q
to move the entry marker to
Cell
1,l.
This example involves an
18%
1-year loan for
$1000.00.
2.
Press
0
for Calculate. You are prompted to enter the
LOAN
AMT.
3.
Type
1000
(ENTER).
4.
Type
0.015
(ENTER)
for the
I
N
T
R
A
T
E.
(Remember, you need
to divide the annual interest rate by
12
to get the monthly
interest rate.)
60
Tandy
1000
To Next Page
Loading...
Need help?
General
