Using Worksheets: Tools for Financial Solutions

Each worksheet is independent of the others: operations in a worksheet

do not affect variables in other worksheets. When you exit a worksheet

or turn off the calculator, the calculator retains all worksheet data.

Key in a new calculation 2 ; 2.00

Recall the last answer & x 4.00

Complete the calculation N 16.00

The calculator contains worksheets with embedded

formulas to solve specific problems. You apply settings or

assign known values to worksheet variables and then

compute the unknown value. Changing the values lets you

ask what if questions and compare results.

Except for TVM variables, accessed in the standardcalculator

mode, all variables are prompted.

For example, to assign values to amortization variables, you

must first press & \ to access the Amortization

worksheet.

To select Function Press

TVM worksheet

(Chapter 2) Analyzes equal cash flows, for

example, annuities, loans,

mortgages, leases, and savings

,, -, .,

/, 0, or

& [

Amortization worksheet

(Chapter 2)

Performs amortization

calculations and generates an

amortization schedule

& \

Cash Flow worksheet

(Chapter 3)

Analyzes unequal cash flows by

calculating net present value

and internal rate of return

& '

Bond worksheet

(Chapter 4)

Computes bond price and yield

to maturity or call

& l

Depreciation worksheet

(Chapter 5)

Generates a depreciation

schedule using one of six

depreciation methods

& p

To Press Display

Accessing the TVM Worksheet Variables

Statistics worksheet

(Chapter 6)

Analyzes statistics on one- or

two-variable data using four

regression analysis options

& k

Percent

Change/Compound

Interest worksheet

(Chapter 7)

Computes percent change,

compound interest, and costsell

markup

& q

Interest Conversion

worksheet

(Chapter 7)

Converts interest rates

between nominal rate (or

annual percentage rate) and

annual effective rate

& v

Date worksheet

(Chapter 7)

Computes number of days

between two dates, or

date/day of the week a

specified number of days is

from a given date

& u

Profit Margin worksheet

(Chapter 7)

Computes cost, selling price,

and profit margin

& w

Breakeven worksheet

(Chapter 7)

Analyzes relationship between

fixed cost, variable cost, price,

profit, and quantity

& r

Memory worksheet

(Chapter 7)

Accesses storage area for up to

10 values

& {

• To assign values to the TVM worksheet variables, use

the five TVM keys (,, -, ., /, 0).

• To access other TVM worksheet functions, press the &

key, and then press a TVM function key (xP/Y, P/Y,

BGN). (See “TVM and Amortization Worksheet

Variables” on page 22.)

Note: You can assign values to TVM variables while in a

prompted worksheet, but you must return to the

standard-calculator mode to calculate TVM values or

clear the TVM worksheet.

To select Function Press

Accessing Prompted-Worksheet Variables

After you access a worksheet, press # or " to select variables. For

example, press & \ to access the Amortization worksheet, and

then press # or " to select the amortization variables (P1, P2, BAL, PRN,

INT).(See “TVM and Amortization Worksheet Variables” on page 22.)

Indicators prompt you to select settings, enter values, or compute results.

For example, the i# $ indicators remind you to press # or " to select

other variables. (See “Reading the Display” on page 2.)

To return to the standard-calculator mode, press & U.

Types of Worksheet Variables

• Enter-only

• Compute-only

• Automatic-compute

• Enter-or-compute

• Settings

Note: The = sign displayed between the variable label and value

indicates that the variable is assigned the value.

Enter-Only Variables

Values for enter-only variables must be entered, cannot be computed,

and are often limited to a specified range, for example, P/Y and C/Y. The

value for an enter-only variable can be:

• Entered directly from the keyboard.

• The result of a math calculation.

• Recalled from memory.

• Obtained from another worksheet using the last answer feature.

When you access an enter-only variable, the calculator displays the

variable label and ENTER indicator. The ENTER indicator reminds you to

press ! after keying in a value to assign the value to the variable.

After you press !, the  indicator confirms that the value is assigned.

Compute-Only Variables

You cannot enter values manually for compute-only variables, for

example, net present value (NPV). To compute a value, display a

compute-only variable and press %. The calculator computes and

displays the value based on the values of other variables.

When you display a compute-only variable, the COMPUTE indicator

reminds you to press % to compute its value. After you press %, the 

indicator confirms that the displayed value has been computed.

Automatic-Compute Variables

When you press # or " to display an automatic-compute variable (for

example, the Amortization worksheet INT variable), the calculator

computes and displays the value automatically without you having to

press %.

Enter-or-Compute Variables in the TVM Worksheet

You can either enter or compute values for the TVM worksheet variables

(N, I/Y, PV, PMT, and FV).

Note: Although you do not have to be in the standard-calculator mode

to assign values to these variables, you must be in the standard-calculator

mode to compute their values.

• To assign the value of a TVM variable, key in a number and press a

variable key.

• To compute the value of a TVM variable, press %, and then press the

variable key. The calculator computes and displays the value based

on the values of other variables.

Enter-or-Compute Variables in Prompted Worksheets

You can either enter or compute values for some prompted worksheet

variables (for example, the Bond worksheet YLD and PRI variables).

When you select an enter-or-compute variable, the calculator displays

the variable label with the ENTER and COMPUTE indicators.

• The ENTER indicator prompts you to press ! to assign the keyedin

value to the displayed variable.

• The COMPUTE indicator prompts you to press % to compute a

value for the variable.

Selecting Worksheet Settings

Many prompted worksheets contain variables consisting of two or more

options, or settings (for example, the Date worksheet ACT/360 variable).

When you select variables with settings, the calculator displays the SET

indicator and the current setting.

To scroll through the settings of a variable, press & V once for each

setting.

Display Indicators

• The  indicator confirms that the calculator entered the displayed

value in the worksheet.

• The  indicator confirms that the calculator computed the displayed

value.

• When a change to the worksheet invalidates either entered or

computed values, the  and  indicators disappear.

Time-Value-of-Money and Amortization Worksheets 21

Each worksheet is independent of the others: operations in a worksheet

do not affect variables in other worksheets. When you exit a worksheet

or turn off the calculator, the calculator retains all worksheet data.

Key in a new calculation 2 ; 2.00

Recall the last answer & x 4.00

Complete the calculation N 16.00

The calculator contains worksheets with embedded

formulas to solve specific problems. You apply settings or

assign known values to worksheet variables and then

compute the unknown value. Changing the values lets you

ask what if questions and compare results.

Except for TVM variables, accessed in the standardcalculator

mode, all variables are prompted.

For example, to assign values to amortization variables, you

must first press & \ to access the Amortization

worksheet.

To select Function Press

TVM worksheet

(Chapter 2) Analyzes equal cash flows, for

example, annuities, loans,

mortgages, leases, and savings

,, -, .,

/, 0, or

& [

Amortization worksheet

(Chapter 2)

Performs amortization

calculations and generates an

amortization schedule

& \

Cash Flow worksheet

(Chapter 3)

Analyzes unequal cash flows by

calculating net present value

and internal rate of return

& '

Bond worksheet

(Chapter 4)

Computes bond price and yield

to maturity or call

& l

Depreciation worksheet

(Chapter 5)

Generates a depreciation

schedule using one of six

depreciation methods

& p

To Press Display

Accessing the TVM Worksheet Variables

Statistics worksheet

(Chapter 6)

Analyzes statistics on one- or

two-variable data using four

regression analysis options

& k

Percent

Change/Compound

Interest worksheet

(Chapter 7)

Computes percent change,

compound interest, and costsell

markup

& q

Interest Conversion

worksheet

(Chapter 7)

Converts interest rates

between nominal rate (or

annual percentage rate) and

annual effective rate

& v

Date worksheet

(Chapter 7)

Computes number of days

between two dates, or

date/day of the week a

specified number of days is

from a given date

& u

Profit Margin worksheet

(Chapter 7)

Computes cost, selling price,

and profit margin

& w

Breakeven worksheet

(Chapter 7)

Analyzes relationship between

fixed cost, variable cost, price,

profit, and quantity

& r

Memory worksheet

(Chapter 7)

Accesses storage area for up to

10 values

& {

• To assign values to the TVM worksheet variables, use

the five TVM keys (,, -, ., /, 0).

• To access other TVM worksheet functions, press the &

key, and then press a TVM function key (xP/Y, P/Y,

BGN). (See “TVM and Amortization Worksheet

Variables” on page 22.)

Note: You can assign values to TVM variables while in a

prompted worksheet, but you must return to the

standard-calculator mode to calculate TVM values or

clear the TVM worksheet.

To select Function Press

Accessing Prompted-Worksheet Variables

After you access a worksheet, press # or " to select variables. For

example, press & \ to access the Amortization worksheet, and

then press # or " to select the amortization variables (P1, P2, BAL, PRN,

INT).(See “TVM and Amortization Worksheet Variables” on page 22.)

Indicators prompt you to select settings, enter values, or compute results.

For example, the i# $ indicators remind you to press # or " to select

other variables. (See “Reading the Display” on page 2.)

To return to the standard-calculator mode, press & U.

Types of Worksheet Variables

• Enter-only

• Compute-only

• Automatic-compute

• Enter-or-compute

• Settings

Note: The = sign displayed between the variable label and value

indicates that the variable is assigned the value.

Enter-Only Variables

Values for enter-only variables must be entered, cannot be computed,

and are often limited to a specified range, for example, P/Y and C/Y. The

value for an enter-only variable can be:

• Entered directly from the keyboard.

• The result of a math calculation.

• Recalled from memory.

• Obtained from another worksheet using the last answer feature.

When you access an enter-only variable, the calculator displays the

variable label and ENTER indicator. The ENTER indicator reminds you to

press ! after keying in a value to assign the value to the variable.

After you press !, the  indicator confirms that the value is assigned.

Compute-Only Variables

You cannot enter values manually for compute-only variables, for

example, net present value (NPV). To compute a value, display a

compute-only variable and press %. The calculator computes and

displays the value based on the values of other variables.

When you display a compute-only variable, the COMPUTE indicator

reminds you to press % to compute its value. After you press %, the 

indicator confirms that the displayed value has been computed.

Automatic-Compute Variables

When you press # or " to display an automatic-compute variable (for

example, the Amortization worksheet INT variable), the calculator

computes and displays the value automatically without you having to

press %.

Enter-or-Compute Variables in the TVM Worksheet

You can either enter or compute values for the TVM worksheet variables

(N, I/Y, PV, PMT, and FV).

Note: Although you do not have to be in the standard-calculator mode

to assign values to these variables, you must be in the standard-calculator

mode to compute their values.

• To assign the value of a TVM variable, key in a number and press a

variable key.

• To compute the value of a TVM variable, press %, and then press the

variable key. The calculator computes and displays the value based

on the values of other variables.

Enter-or-Compute Variables in Prompted Worksheets

You can either enter or compute values for some prompted worksheet

variables (for example, the Bond worksheet YLD and PRI variables).

When you select an enter-or-compute variable, the calculator displays

the variable label with the ENTER and COMPUTE indicators.

• The ENTER indicator prompts you to press ! to assign the keyedin

value to the displayed variable.

• The COMPUTE indicator prompts you to press % to compute a

value for the variable.

Selecting Worksheet Settings

Many prompted worksheets contain variables consisting of two or more

options, or settings (for example, the Date worksheet ACT/360 variable).

When you select variables with settings, the calculator displays the SET

indicator and the current setting.

To scroll through the settings of a variable, press & V once for each

setting.

Display Indicators

• The  indicator confirms that the calculator entered the displayed

value in the worksheet.

• The  indicator confirms that the calculator computed the displayed

value.

• When a change to the worksheet invalidates either entered or

computed values, the  and  indicators disappear.

Time-Value-of-Money and Amortization Worksheets 21