HP 12C#ABA hp 12c_solutions handbook_English_E.pdf - Page 14

Example 1, Assuming a 125% declining balance depreciation, what are the After-Tax - functions

Page 14 highlights

5. Key in depreciable value and press 4. 6. Key in depreciable life and press 5. 7. Key in factor (for declining balance only) and press 6. 8. Key in the Marginal Tax Rate (as a percentage) and press 7. 9. Key in the growth rate in Potential Gross Income ( 0 for no growth) and press 8. 10. Key in the growth rate in operational cost (0 if no growth) and press 9. 11. Key in the vacancy rate (0 for no vacancy rate) and press 0. 12. Key in the desired depreciation function at line 32 in the program. 13. Press to compute ATCF. The display will pause showing the year and then will stop with the ATCF for that year. The Y-register contains the year. 14. Continue pressing to compute successive After-Tax Cash Flows. Example 1: A triplex was recently purchased for $100,000 with a 30-year loan at 12.25% and a 20% down payment. Not including a 5% annual vacancy rate, the potential gross income is $9,900 with an annual growth rate of 6%. Operating expenses are $3,291.75 with a 2.5% growth rate. The depreciable value is $75,000 with a projected useful life of $20 years. Assuming a 125% declining balance depreciation, what are the After-Tax Cash Flows for the first 10 years if the investors Marginal Tax Rate is 35%? Keystrokes Display CLEAR 100000 20 12.25 30 9900 2 3291.75 3 75000 4 20 5 80,000.00 Mortgage amount. 1.02 360 -838.32 9,900.00 3,291.75 75,000.00 20.00 Monthly interest rate. Mortgage term. Monthly payment. Potential Gross Income. 1st year operating cost. Depreciable value. Useful life. 13

  • 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

13
5.
Key in depreciable value and press
4.
6.
Key in depreciable life and press
5.
7.
Key in factor (for declining balance only) and press
6.
8.
Key in the Marginal Tax Rate (as a percentage) and press
7.
9.
Key in the growth rate in Potential Gross Income ( 0 for no growth) and
press
8.
10.
Key in the growth rate in operational cost (0 if no growth) and press
9.
11.
Key in the vacancy rate (0 for no vacancy rate) and press
0.
12.
Key in the desired depreciation function at line 32 in the program.
13. Press
to compute
ATCF
. The display will pause showing the year
and then will stop with the
ATCF
for that year. The Y-register contains the
year.
14.
Continue pressing
to compute successive After-Tax Cash Flows.
Example 1:
A triplex was recently purchased for $100,000 with a 30-year
loan at 12.25% and a 20% down payment. Not including a 5% annual
vacancy rate, the potential gross income is $9,900 with an annual growth
rate of 6%. Operating expenses are $3,291.75 with a 2.5% growth rate. The
depreciable value is $75,000 with a projected useful life of $20 years.
Assuming a 125% declining balance depreciation, what are the After-Tax
Cash Flows for the first 10 years if the investors Marginal Tax Rate is 35%?
Keystrokes
Display
CLEAR
100000
20
80,000.00
Mortgage amount.
12.25
1.02
Monthly interest rate.
30
360
Mortgage term.
-838.32
Monthly payment.
9900
2
9,900.00
Potential Gross Income.
3291.75
3
3,291.75
1st year operating cost.
75000
4
75,000.00
Depreciable value.
20
5
20.00
Useful life.