Cash Flow Worksheet Variables
К оглавлению1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1617 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
51 52 53 54
Use the Cash Flow worksheet to solve problems with
unequal cash flows.
To solve problems with equal cash flows, use the TVM
worksheet.
• To access the Cash Flow worksheet and initial cash
flow value (CFo), press '.
• To access the cash flow amount and frequency
variables (Cnn/Fnn), press # or ".
• To access the discount rate variable (I), press (.
• To compute net present value (NPV), press # or " and
% for each variable.
• To compute net present value (NPV), net future value
(NFV), payback (PB), and discounted payback (DPB),
press # or " and % for each variable.
• To compute the internal rate of return (IRR), press ).
• To compute the modified internal rate of return
(MOD), press # to access the reinvestment rate (RI)
variable, key in a value, and press #.
Variable Key Display Variable
Type**
Initial cash flow ' CFo Enter-only
Amount of nth cash flow # Cnn* Enter-only
Frequency of nth cash flow # Fnn* Enter-only
Discount rate ( I Enter-only
Net present value # % NPV Compute-only
* nn represents the cash flow (C01–C32) or frequency (F01–F32)
number.
** This guidebook categorizes variables by the method of entry. (See
“Types of Worksheet Variables” on page 17.)
Resetting Variables
• To reset CFo, Cnn, and Fnn to default values, press ' and then
&z.
• To reset NPV, NFV, PB, and DPB to default values to the default
value, press ( and then &z.
• To reset IRR, RI, and MOD to default values to the default value,
press ) and then &z.
• To reset all calculator variables and formats to default values,
including all Cash Flow worksheet variables, press &} !.
Entering Cash Flows
• You must enter an initial cash flow (CFo). The calculator accepts up
to 32 additional cash flows (C01–C32). Each cash flow can have a
unique value.
• Enter positive values for cash inflows (cash received) and negative
values for cash outflows (cash paid out). To enter a negative value,
key in a number and press S.
Inserting and Deleting Cash Flows
The calculator displays INS or DEL to confirm that you can press &X
or & W to insert or delete cash flows.
Net future value # % NFV Compute-only
Payback # % PB Compute-only
Discounted payback # % DPB Compute-only
Internal rate of return )% IRR Compute-only
Reinvestment rate # RI Enter-only
Modified Internal rate of return # MOD Auto
Compute
Variable Key Display Variable
Type**
Cash Flow Worksheet 43
Uneven and Grouped Cash Flows
Uneven Cash Flows
The Cash Flow worksheet analyzes unequal cash flows over equal time
periods. Cash-flow values can include both inflows (cash received) and
outflows (cash paid out).
All cash-flow problems start with an initial cash flow labeled CFo. CFo is
always a known, entered value.
Grouped Cash Flows
Cash-flow problems can contain cash flows with unique values as well as
consecutive cash flows of equal value.
Although you must enter unequal cash flows separately, you can enter
groups of consecutive, equal cash flows simultaneously using the Fnn
variable.
Entering Cash Flows
Cash flows consist of an initial cash flow (CFo) and up to 32 additional
cash flows (C01-C32), each of which can have a unique value. You must
enter the number of occurrences (up to 9,999), or frequency (F), for each
additional cash flow (C01-C32).
• The calculator displays positive values for inflows (cash received) and
negative values for outflows (cash paid out).
• To clear the Cash Flow worksheet, press & z.
To enter cash flows:
1. Press '. The initial cash-flow value (CFo) appears.
2. Key in a value for CFo and press !.
3. To select an additional cash-flow variable, press #. The C01 value
appears.
4. To change C01, key in a value and press !.
5. To select the cash-flow frequency variable (F01), press #. The F01
value appears.
6. To change F01, key in a value and press !.
7. To select an additional cash-flow variable, press #. The C02 value
appears.
8. Repeat steps 4 through 7 for all remaining cash flows and
frequencies.
9. To review entries, press # or ".
Deleting Cash Flows
When you delete a cash flow, the calculator decreases the number of
subsequent cash flows automatically.
The DEL indicator confirms that you can delete a cash flow.
1. Press # or " until the cash flow you want to delete appears.
2. Press & W. The cash flow you specified and its frequency is
deleted.
Inserting Cash Flows
When you insert a cash flow, the calculator increases the number of the
following cash flows, up to the maximum of 32.
Note: The INS indicator confirms that you can insert a cash flow.
1. Press # or " to select the cash flow where you want to insert the
new one. For example, to insert a new second cash flow, select C02.
2. Press & X.
3. Key in the new cash flow and press !. The new cash flow is
entered at C02.
Use the Cash Flow worksheet to solve problems with
unequal cash flows.
To solve problems with equal cash flows, use the TVM
worksheet.
• To access the Cash Flow worksheet and initial cash
flow value (CFo), press '.
• To access the cash flow amount and frequency
variables (Cnn/Fnn), press # or ".
• To access the discount rate variable (I), press (.
• To compute net present value (NPV), press # or " and
% for each variable.
• To compute net present value (NPV), net future value
(NFV), payback (PB), and discounted payback (DPB),
press # or " and % for each variable.
• To compute the internal rate of return (IRR), press ).
• To compute the modified internal rate of return
(MOD), press # to access the reinvestment rate (RI)
variable, key in a value, and press #.
Variable Key Display Variable
Type**
Initial cash flow ' CFo Enter-only
Amount of nth cash flow # Cnn* Enter-only
Frequency of nth cash flow # Fnn* Enter-only
Discount rate ( I Enter-only
Net present value # % NPV Compute-only
* nn represents the cash flow (C01–C32) or frequency (F01–F32)
number.
** This guidebook categorizes variables by the method of entry. (See
“Types of Worksheet Variables” on page 17.)
Resetting Variables
• To reset CFo, Cnn, and Fnn to default values, press ' and then
&z.
• To reset NPV, NFV, PB, and DPB to default values to the default
value, press ( and then &z.
• To reset IRR, RI, and MOD to default values to the default value,
press ) and then &z.
• To reset all calculator variables and formats to default values,
including all Cash Flow worksheet variables, press &} !.
Entering Cash Flows
• You must enter an initial cash flow (CFo). The calculator accepts up
to 32 additional cash flows (C01–C32). Each cash flow can have a
unique value.
• Enter positive values for cash inflows (cash received) and negative
values for cash outflows (cash paid out). To enter a negative value,
key in a number and press S.
Inserting and Deleting Cash Flows
The calculator displays INS or DEL to confirm that you can press &X
or & W to insert or delete cash flows.
Net future value # % NFV Compute-only
Payback # % PB Compute-only
Discounted payback # % DPB Compute-only
Internal rate of return )% IRR Compute-only
Reinvestment rate # RI Enter-only
Modified Internal rate of return # MOD Auto
Compute
Variable Key Display Variable
Type**
Cash Flow Worksheet 43
Uneven and Grouped Cash Flows
Uneven Cash Flows
The Cash Flow worksheet analyzes unequal cash flows over equal time
periods. Cash-flow values can include both inflows (cash received) and
outflows (cash paid out).
All cash-flow problems start with an initial cash flow labeled CFo. CFo is
always a known, entered value.
Grouped Cash Flows
Cash-flow problems can contain cash flows with unique values as well as
consecutive cash flows of equal value.
Although you must enter unequal cash flows separately, you can enter
groups of consecutive, equal cash flows simultaneously using the Fnn
variable.
Entering Cash Flows
Cash flows consist of an initial cash flow (CFo) and up to 32 additional
cash flows (C01-C32), each of which can have a unique value. You must
enter the number of occurrences (up to 9,999), or frequency (F), for each
additional cash flow (C01-C32).
• The calculator displays positive values for inflows (cash received) and
negative values for outflows (cash paid out).
• To clear the Cash Flow worksheet, press & z.
To enter cash flows:
1. Press '. The initial cash-flow value (CFo) appears.
2. Key in a value for CFo and press !.
3. To select an additional cash-flow variable, press #. The C01 value
appears.
4. To change C01, key in a value and press !.
5. To select the cash-flow frequency variable (F01), press #. The F01
value appears.
6. To change F01, key in a value and press !.
7. To select an additional cash-flow variable, press #. The C02 value
appears.
8. Repeat steps 4 through 7 for all remaining cash flows and
frequencies.
9. To review entries, press # or ".
Deleting Cash Flows
When you delete a cash flow, the calculator decreases the number of
subsequent cash flows automatically.
The DEL indicator confirms that you can delete a cash flow.
1. Press # or " until the cash flow you want to delete appears.
2. Press & W. The cash flow you specified and its frequency is
deleted.
Inserting Cash Flows
When you insert a cash flow, the calculator increases the number of the
following cash flows, up to the maximum of 32.
Note: The INS indicator confirms that you can insert a cash flow.
1. Press # or " to select the cash flow where you want to insert the
new one. For example, to insert a new second cash flow, select C02.
2. Press & X.
3. Key in the new cash flow and press !. The new cash flow is
entered at C02.