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

After-Tax Cash Flows, Net Operating Income using the Potential Gross Income, operational cost

Page 10 highlights

transaction costs are expected to be 7% of the resale price. The mortgage is the same as that indicated in the preceding example. • What will the Mortgage Balance be in 10 years? • What are the Cash Proceeds of Resale and Net Cash Proceeds of Resale? Keystrokes Display CLEAR 240.00 Mortgage term. 20 11.5 700000 0.96 -7,465.01 Mortgage rate. Property value. Monthly payment. 10 120.00 Projection period. -530,956.57 Mortgage balance in 10 years. 800000 7 56,000.00 744,000.00 Estimated resale. Transaction costs. Cash Proceeds of Resale. 213,043.43 Net Cash Proceeds of Resale. After-Tax Cash Flows The After-Tax Cash Flow (ATCF) is found for the each year by deducting the Income Tax Liability for that year from the Cash Throw Off. where: Taxable Income = Net Operating Income - interest - depreciation. Tax Liability = Taxable Income x Marginal Tax Rate. After Tax Cash Flow = Cash Throw Off - Tax Liability. The After-Tax Cash Flow for the initial and successive years may be calculated by the following HP-12C program. This program calculates the Net Operating Income using the Potential Gross Income, operational cost and vacancy rate. The Net Operating Income is readjusted each year from the growth rates in Potential Gross Income and operational costs. The user is able to change the method of finding the depreciation from declining balance to straight line. To make the change, key in at line 32 of the program in place of . 9

  • 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

9
transaction costs are expected to be 7% of the resale price. The mortgage
is the same as that indicated in the preceding example.
What will the Mortgage Balance be in 10 years?
What are the Cash Proceeds of Resale and Net Cash Proceeds of
Resale?
After-Tax Cash Flows
The After-Tax Cash Flow (
ATCF
) is found for the each year by deducting
the Income Tax Liability for that year from the Cash Throw Off.
where:
Taxable Income =
Net Operating Income - interest - depreciation.
Tax Liability =
Taxable Income x Marginal Tax Rate.
After Tax Cash Flow =
Cash Throw Off - Tax Liability.
The After-Tax Cash Flow for the initial and successive years may be
calculated by the following HP-12C program. This program calculates the
Net Operating Income using the Potential Gross Income, operational cost
and vacancy rate. The Net Operating Income is readjusted each year from
the growth rates in Potential Gross Income and operational costs.
The user is able to change the method of finding the depreciation from
declining balance to straight line. To make the change, key in
at
line 32 of the program in place of
.
Keystrokes
Display
CLEAR
20
240.00
Mortgage term.
11.5
0.96
Mortgage rate.
700000
Property value.
-7,465.01
Monthly payment.
10
120.00
Projection period.
-530,956.57
Mortgage balance in 10 years.
800000
Estimated resale.
7
56,000.00
Transaction costs.
744,000.00
Cash Proceeds of Resale.
213,043.43
Net Cash Proceeds of Resale.