Tutorial
5.
Press
0
to calculate.
The formula tells the program to take the value in the preceding
row and the same column, add
1;
then display that value in the
next row. For example, move the entry marker to Cell 19,l. The
value in the last row selected, Row 19, will be the value in Row
18
(ll),
plus
1,
or 12, the last period in the loan. Thus, the original
formula entered,
R8
+
1,
changes
for
each row
so
that when
the value for Period 12 in Row 19 is calculated, the formula is
R18
+
1.
Next, you are going to format Column
1
so
that the period numbers
don’t run into the calculations that will be displayed in Column 2.
1.
Move the entry marker to Cell
8,1,
press
0;
then select
2. Press
0
for Format, and type
LI
IENTER).
L
stands for left-
justified, which means that the contents
of
all the selected cells
will be flush left within the cell instead of the default right-
justified format for numbers and calculated values.
You
also
specified an integer
(I)
format, since the period numbers did not
need to be shown in dollar, 2-decimal format.
Column 2 shows the balance, the unpaid principal portion of the
original loan amount.
1.
Move the entry marker to Cell 8,2. The balance for Period
1
is
the entire amount of the loan that you will enter later as a cons-
tant value in Cell 1,2.
2. Press
0,
and type
RlC2
(ENTER).
3.
Move the entry marker to Cell 9,2, press
0
for Select; then
use the arrow keys to highlight Rows 9-19.
4.
Press
(F31,
and type
R8C2
-
R8C5
(ENTER).
This formula takes
the value in the preceding row and the same column (the balance
of the previous period), subtracts the value in the preceding row
in Column
5
(the principal payment of the previous period) and
displays the result in the next row. Therefore, the value in the
last row selected (the balance
of
Period 12), Row 19, equals the
Period
11
balance in Row
18
less the principal payment paid in
Period
11,
shown in cell 18,5. When the value in Cell 19,2 is
calculated, the original formula is changed to
R18C2
-
R18C5.
(You
can move the entry marker to Cell 19,2 to see that this is
true.)
ROWS 8-19.
58
Tandy
1000
To Next Page
Loading...
Need help?
General
