HP 113394 User Guide - Page 193

Group, of Months, Cash Flow

Page 193 highlights

Section 13: Investment Analysis 193 Example: An investor has the following unconventional investment opportunity. The cash flows are: Group # of Months 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 (RPN mode) Keystrokes (ALG mode) Display f] f[ fCLEARH 0gJ 100000gK 5ga 0gK5ga 0gK9ga 200000gK fCLEARH 0gJ 100000gK 5ga 0gK5ga 0gK9ga 200000gK 0.00 0.00 100,000.00 5.00 5.00 9.00 200,000.00 First cash flow. Second through sixth cash flows. Next five cash flows. Next nine cash flows. 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Þ gK5ga6 gK5ga gCfl 6gCfl -660,454.55 20n¼ 12§ 20n¼ §12³ 0.81 9.70 Monthly MIRR 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

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 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
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278

Section 13: Investment Analysis
193
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
Example:
An investor has the following unconventional investment opportunity.
The cash flows are:
Group
# of Months
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
(RPN mode)
Keystrokes
(ALG mode)
Display
f]
f[
f
CLEAR
H
f
CLEAR
H
0.00
0
gJ
0
gJ
0.00
First cash flow.
100000
gK
100000
gK
100,000.00
5
ga
5
ga
5.00
Second through sixth
cash flows.
0
gK
5
ga
0
gK
5
ga
5.00
Next five cash flows.
0
gK
9
ga
0
gK
9
ga
9.00
Next nine cash flows.
200000
gK
200000
gK
200,000.00
Last cash flow.
10
gCfl
10
gCfl
657,152.37
NPV of positive cash
flows.
Þ$
Þ$
-657,152.37
20
nM
20
nM
775,797.83
NFV of positive cash
flows.
180000
Þg
J
0
gK
5
g
a
100000
Þ
gK
5
ga
6
gCfl
180000
Þg
J
0
gK
5
g
a
100000
Þ
gK
5
ga
6
gCfl
-660,454.55
NPV of negative cash
flows.
20
20
0.81
Monthly
MIRR
12
§
§
12
³
9.70
Annual
MIRR.