This is not the document you are looking for? Use the search form below to find more!

0.00 (0 votes)

Cash flow analysis is an extension of the basic TVM concepts applied to compound interest problems when payments
occur in regular periods and do not have the same value. Any financial investment can be represented as an initial
investment of money and a series of cash flows that occur in regular periods of time. Each flow of money can be positive
(received) or negative (paid out) and considered as a cash flow. Common cash flow problems usual y involve the
calculation of the Internal Rate of Return (IRR) or the Net Present Value (NPV).
The NPV expresses the amount of money resulting from the summation of the initial investment (CF0) and the present
value of each anticipated cash flow (CFj) calculated to the time of the initial investment. The IRR is the discounted rate
applied to all future cash flows that cause NPV = 0.

- Added:
**October, 07th 2010** - Reads:
**235** - Downloads:
**0** - File size:
**187.36kb** - Pages:
**6** - content preview

- Name:
**yesse**

Related Documents

Cash flow analysis is an extension of the basic TVM concepts applied to compound interest problems when payments occur in regular periods and do not have the same value. Any financial ...

This hp 12c platinum user's guide is intended to help you get the most out of your investment in your hp 12c platinum Programmable Financial Calculator. Although the excitement of acquiring this ...

You have in your hands a compact symbolic and numerical computer that will facilitate calculation and mathematical analysis of problems in a variety of disciplines, from elementary mathematics to ...

1 Getting to know the printer Understanding the printer's features and benefits 12 Print with excellent quality 12 Save Time 12 Save money. 12 Create professional ...

1 Getting to know the printer Printer features and benefits 2 Print with excellent quality 2 Save money 2 Create professional documents 2 Printer components 3 ...

You have in your hands a compact symbolic and numerical computer that will facilitate calculation and mathematical analysis of problems in a variety of disciplines, from elementary mathematics to ...

1 Printer basics Quick access to more information 2 WWW links for drivers, software, and support 2 User guide links 2 Where to look for more information 2 Printer ...

* Exceptional image quality--with leading edge technologies like fusion imaging, harmonic fusion, adaptive color and adaptive doppler--shows what you need to see for more confident diagnosis * ...

HP Sonos 2000 * Quick Touch Interface * Dynamic Elevation Beamforming * Continuous Loop Review * Color Flow and steerable Pulsed Wave * Dedicated presets for Cardiac ...

Content Preview

Cash flow and NPV calculations

Cash flow diagrams

The HP12C cash flow approach

Practice solving NPV problems

How to modify cash flow entries

Cash flow analysis is an extension of the basic TVM concepts applied to compound interest problems when payments

occur in regular periods and do not have the same value. Any financial investment can be represented as an initial

investment of money and a series of cash flows that occur in regular periods of time. Each flow of money can be positive

(received) or negative (paid out) and considered as a cash flow. Common cash flow problems usual y involve the

calculation of the Internal Rate of Return (

The NPV expresses the amount of money resulting from the summation of the initial investment (CF0) and the present

value of each anticipated cash flow (CFj) calculated to the time of the initial investment. The IRR is the discounted rate

applied to all future cash flows that cause NPV = 0.

The expression that calculates the Net Present Value is:

1

2

j

0

+

+

+

L

Figure 1

1+

(1+

The cash flow diagram in Figure 1 illustrates one of the many possible situations that can be handled by the HP12C.

Composition Period

gK Last Cash Flow

gK Intermediate Cash Flow

gJ Initial Cash Flow

ga Number of consecutive occurrences of CFj

Figure 2

In the HP12C each cash flow amount is stored in its corresponding register in memory. For each cash flow amount there

is a related register to store the number of consecutive occurrences of this amount. This approach is shown below:

Registers

Cash flow

Nj

R0

CF0

N0

R1

CF1

N1

...

...

...

R6

CF6

N6

R7

CF7

N7

...

...

...

R.8

CF18

N18

R.9

CF19

N19

Figure 3

FV

CF20

N20

hp calculators

- 2 -

The HP12C memory organization al ows up to 20 different cash flow amounts plus the initial investment to be stored and

handled according to the diagram in Figure 2. If any cash flow amount repeats consecutively, then it can be stored as a

grouped cash flow CFj and its corresponding Nj holds the number of occurrences, up to 99. TVM register

index to control CF operations.

The keys to enter cash flow data are:

gJ - stores the number in the display in R0 and sets

gK - adds 1 unit to current

ga - stores the number in the display(∗) in Nj;

(∗) The number in the display must be a positive integer from 1 to 99, otherwise ga returns

to the display and

no operation is performed.

If the last available register has already been used, gK adds 1 unit to current

the display in TVM register FV. Any attempt to add a cash flow amount with gK after FV has already been used

or when

to be shown in the display and no

operation is performed.

Example 1: The cash flow diagram below represents a possible investment and you were chosen to determine if it is

feasible. The success of this investment dictates your future in the company, so the analysis must be

precise and error free. What is the correct keystroke sequence to fill the HP12C registers with this data?

$ 178,500.00

$ 20,000.00

CF6

CF3

$ 7,000.00

$ 12,000.00

CF

CF4

1

3 consecutive occurrences

N3

$-10,000.00

$-8,000.00

$-130,000.00

CF

CF

CF

2

5

0

Figure 4

Solution:

It is not necessary to clear all registers to start cash flow analysis because only the registers updated with

cash flow data are used.

130000 Þ gJ

7000 gK

10000 Þ gK

Figure 5

hp calculators

- 3 -

The next cash flow amount occurs three times in a sequence, so it can be entered as a grouped cash flow.

20000 gK

3 ga

Figure 6

The remaining data is entered with the following keystroke sequence:

12000 gK

8000 Þ gK

178500 gK

Figure 7

Answer:

The keystrokes presented above indicate the correct entries.

Example 2: The cash flow diagram has all of its information used to compose the cash flow data in the HP12C memory.

How can the entries be checked to ensure they are correct?

Solution:

Now that all data is entered, checking for its correctness is possible in two ways. The alternative way is the

random check through the use of the : key. The procedure for this checking is as follows:

:w

Figure 8

This is the number of the last register used to store the cash flow data.

:6

Figure 9

This is the amount of CF6. Now check CF3 and verify N3 as wel .

:3

Figure 10

This is CF3 contents. To randomly check for Nj contents,

Nj will be recalled.

hp calculators

- 4 -

3n :ga

Figure 11

Now check CF2 and CF0.

:2

Figure 12

:0

Figure 13

Recal

:w

Figure 14

Answer:

The entries are correct.

Example 3: The investment is considered attractive if the calculated net present value is positive for a given interest

rate. Now that all data is stored and checked, calculate the NPV for a given interest rate of 8%.

Solution:

If

6 w fl

Figure 15

Answer:

Yes, the investment is attractive based on a net present value of $11,429.11 for an interest rate of 8%.

If it happens that a cash flow entry was wrongly entered, modifying its amount is not difficult. There are two ways to

correct entries.

Example 4: Update the amount of CF2 to $-9,500.00 and compute the new NPV after this change.

Solution 1: Type in the correct amount and store it in R2:

9500 Þ ?2 fl

hp calculators

- 5 -

Figure 16

Solution 2: Set

1n 9500 Þ gK 6n fl

Figure 17

To modify a wrongly entered Nj, it is necessary to change the value stored in register

Example 5: Now change both N3 and N4 to 2 and calculate NPV again. The cash flow diagram now looks like this:

$ 178,500.00

$ 20,000.00

CF6

CF

$ 12,000.00

3

$ 7,000.00

CF4

CF1

2 consecutive occurrences

2 consecutive occurrences

N3

N4

$-9,500.00

$-8,000.00

CF2

CF

$-130,000.00

5

CF0

Figure 18

Solution:

For each correction, set

its original value and press fl.

3n 2 ga 4n 2 ga 6 n fl

Figure 19

Answer:

The newly computed NPV is $ 6,413.11.

hp calculators

- 6 -

## Add New Comment