Filter
Top Products
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.