TI-83 Plus CellSheet™ Application
Page 21
3. Move the cursor to cell C2, and then enter the formula
= A2
4
4
.03
(
¡ e
A2
03
¯
).
Your spreadsheet should look like this:
At the beginning of each month, the new principal, P
2
, is
calculated using the following formula: P
2
= P
1
– (PMT
1
– I
1
),
where P
1
, PMT
1
, and I
1
all pertain to the previous month. The
interest and minimum monthly payment are calculated exactly
as they were for the first month. Enter the remaining
spreadsheet formulas to find the solution to the problem.
1. Move the cursor to cell A3, and then enter the formula
= A2 – (C2 – B2)
(
¡ e
A2
e
C2
e
B2
¯
).
2. To copy the formulas from B2:C2 to B3:C3, place the cursor
in cell B2, and press
R
to begin the range selection.