1: Overview of Calculator Operations
21
Using Worksheets: Tools for Financial Solutions
What Is a Worksheet?
Each worksheet is designed as a framework for a set of
variables. The formulas that define the relationships between
the variables, though not visible, are built into each worksheet.
•
Each worksheet is designed to solve specific types of
problems such as time-value-of money, cash-flow, bond, or
depreciation problems.
•
You access the Time-Value-of-Money (TVM) worksheet
variables with the five TVM keys on the third row of the
keyboard (
,
,
-
,
.
,
/
,
0
).
•
All other worksheets are prompted. For example, the
&
\
key sequence lets you access the variables in the
prompted worksheet to amortization calculations.
•
You select settings for some variables, assign known values
to other variables, and compute values for the unknown
variables.
•
Variable labels are displayed one at a time, along with any
value previously assigned to the variable.
•
By changing the values of the variables, you can quickly
perform “what if” calculations.
•
Generally, each worksheet is independent of the others;
operations you perform in one worksheet do not affect
variables in other worksheets.
•
All current worksheet data is retained when you stop using a
worksheet, even if you turn off the calculator.
