Section 13:
Section 13:
Section 13:
Section 13: Investment Analysis
Investment Analysis
Investment Analysis
Investment Analysis
149
File name: HP 12c+_user's guide_English_E_HDP0F12AE03_062608 - Modified.doc
Page: 149 of 213
Printed Date: 2021/6/16
Dimension: 14.8 cm x 21 cm
This Modified Internal Rate of Return procedure (
MIRR
) is one of several
IRR
alternatives which avoids the drawbacks of the traditional
IRR
technique. The
procedure eliminates the sign change problem and the reinvestment (or
discounting) assumption by utilizing user stipulated reinvestment and borrowing
rates.
Negative cash flows are discounted at a safe rate that reflects the return on an
investment in a liquid account. The figure generally used is a short-term security
(T-Bill) or bank passbook rate.
Positive cash flows are reinvested at a reinvestment rate which reflects the return on
an investment of comparable risk. An average return rate on recent market
investments might be used.
The steps in the procedure are:
1. Calculate the future value of the positive cash flows (
NFV
) at the reinvestment
rate.
2. Calculate the present value of the negative cash flows (
NPV
) at the safe rate.
3. Knowing
n
,
PV
, and
FV
, solve for
i
.
Example:
Example:
Example:
Example: An investor has the following unconventional investment opportunity. The
cash flows are:
Group
Group
Group
Group
# of Months
# of Months
# of Months
# of Months
Cash Flow ($)
Cash Flow ($)
Cash Flow ($)
Cash 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
Keystrokes
Keystrokes
Display
Display
Display
Display
f
CLEAR
H
0.00
0
gJ
0.00
First cash flow.
100000
gK
5
ga
5.00
Second through sixth cash flows.
0
gK
5
ga
5.00
Next five cash flows.
0
gK
9
ga
9.00
Next nine cash flows.
200000
gK
200,000.00
Last cash flow.
Содержание 0012C-90001
Страница 1: ...hp 12c financial calculator user s guide H Edition 5 HP Part Number 0012C 90001 ...
Страница 14: ......
Страница 15: ...Part I Part I Part I Part I Problem Solving Problem Solving Problem Solving Problem Solving ...
Страница 86: ......
Страница 87: ...Part II Part II Part II Part II Programming Programming Programming Programming ...
Страница 123: ...Part III Part III Part III Part III Solutions Solutions Solutions Solutions ...
Страница 169: ...Appendi Appendi Appendi Appendixes xes xes xes ...