Section 13: Investment Analysis 193

Example: An investor has the following unconventional investment opportunity. The cash flows are:

Group# of MonthsCash Flow ($)

 

 

 

0

1

–180,000

1

5

100,000

2

5

–100,000

3

9

0

4

1

200,000

 

 

 

Calculate the MIRR using a safe rate of 6% and a reinvestment (risk) rate of 10%.

Keystrokes

Keystrokes

Display

 

(RPN mode)

(ALG mode)

 

 

 

 

 

 

 

f]

f[

 

 

 

 

 

 

fCLEARH

fCLEARH

0.00

 

0gJ

0gJ

0.00

First cash flow.

100000gK

100000gK

100,000.00

 

5ga

5ga

5.00

Second through sixth

 

 

 

cash flows.

 

 

 

 

0gK5ga

0gK5ga

5.00

Next five cash flows.

0gK9ga

0gK9ga

9.00

Next nine cash flows.

200000gK

200000gK

200,000.00

Last cash flow.

10gCfl

10gCfl

657,152.37

NPV of positive cash

 

 

 

flows.

Þ$

Þ$

-657,152.37

 

20nM

20nM

775,797.83

NFV of positive cash

 

 

 

flows.

180000Þg

180000Þg

 

NPV of negative cash

J0gK5g

J0gK5g

 

flows.

a100000Þ

a100000Þ

 

 

gK5ga6gK5ga-660,454.55

 

gCfl6gCfl

 

 

 

 

 

20

20

0.81

Monthly MIRR

12§

§12³

9.70

Annual MIRR.

File name: hp 12c pt_user's guide_English_HDPMF123E27

Page: 193 of 275

Printed Date: 2005/8/1

Dimension: 14.8 cm x 21 cm