HP HP12C hp 12c_user's guide_English_E_HDPMBF12E44.pdf - Page 148

Excess Depreciation, Modified Internal Rate of Return

Page 148 highlights

148 Section 13: Investment Analysis Excess Depreciation When accelerated depreciation is used, the difference between total depreciation charged over a given period of time and the total amount that would have been charged under straight-line depreciation is called excess depreciation. To obtain excess depreciation: 1. Calculate the total depreciation then press \. 2. Key in the depreciable amount (cost less salvage) then press \. Key in the useful life of the asset in years then press z. Key in the number of years in the income projection period then press § to get the total straight-line depreciation charge. 3. Press - to get the excess depreciation. Example: What is the excess depreciation in the previous example over 7 calendar years? (Because of the partial first year, there are 61/2 years depreciation in the first 7 calendar years.) Keystrokes 9429.56\ 10500\ 8z 6.5§ - Display 9,429.56 10,500.00 1,312.50 8,531.25 898.31 Total depreciation through seventh year. Depreciable amount. Yearly straight-line depreciation. Total straight-line depreciation. Excess depreciation Modified Internal Rate of Return The traditional Internal Rate of Return (IRR) technique has several drawbacks which hamper its usefulness in some investment applications. The technique implicitly assumes that all cash flows are either reinvested or discounted at the computed yield rate. This assumption is financially reasonable as long as the rate is within a realistic borrowing and lending range (for example, 10% to 20%). When the IRR becomes significantly greater or smaller, the assumption becomes less valid and the resulting value less sound as an investment measure. IRR also is limited by the number of times the sign of the cash flow changes (positive to negative or vice versa). For every change of sign, the IRR solution has the potential for an additional answer. The cash flow sequence in the example that follows has three sign changes and hence up to three potential internal rates of return. This particular example has three positive real answers: 1.86, 14.35, and 29. Although mathematically sound, multiple answers probably are meaningless as an investment measure. File name: hp 12c_user's guide_English_HDPMBF12E44 Printered Date: 2005/7/29 Page: 148 of 209 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

148 Section 13: Investment Analysis
File name: hp 12c_user's guide_English_HDPMBF12E44
Page: 148 of 209
Printered Date: 2005/7/29
Dimension: 14.8 cm x 21 cm
Excess Depreciation
When accelerated depreciation is used, the difference between total depreciation
charged over a given period of time and the total amount that would have been
charged under straight-line depreciation is called excess depreciation. To obtain
excess depreciation:
1. Calculate the total depreciation then press
\
.
2. Key in the depreciable amount (cost less salvage) then press
\
. Key in the
useful life of the asset in years then press
z
. Key in the number of years in
the income projection period then press
§
to get the total straight-line
depreciation charge.
3. Press
-
to get the excess depreciation.
Example:
What is the excess depreciation in the previous example over 7
calendar years
?
(Because of the partial first year, there are 6
1
/
2
years
depreciation in the first 7 calendar years.)
Keystrokes
Display
9429.56
\
9,429.56
Total depreciation through seventh
year.
10500
\
10,500.00
Depreciable amount.
8
z
1,312.50
Yearly straight-line depreciation.
6.5
§
8,531.25
Total straight-line depreciation.
-
898.31
Excess depreciation
Modified Internal Rate of Return
The traditional Internal Rate of Return (
IRR
) technique has several drawbacks which
hamper its usefulness in some investment applications. The technique implicitly
assumes that all cash flows are either reinvested or discounted at the computed
yield rate. This assumption is financially reasonable as long as the rate is within a
realistic borrowing and lending range (for example, 10% to 20%). When the
IRR
becomes significantly greater or smaller, the assumption becomes less valid and
the resulting value less sound as an investment measure.
IRR
also is limited by the number of times the sign of the cash flow changes
(positive to negative or vice versa). For every change of sign, the
IRR
solution has
the potential for an additional answer. The cash flow sequence in the example that
follows has three sign changes and hence up to three potential internal rates of
return. This particular example has three positive real answers: 1.86, 14.35, and
29. Although mathematically sound, multiple answers probably are meaningless
as an investment measure.