PLEASE SHOW YOUR WORK ON EXCEL

A retail property was acquired on April 12 of year one with $1,674,160 of cash and $3,894,650 of debt. The mortgage was a 20-year term, 6.25% fixed rate, fully amortizing. No loan fees because the owner accepted a higher interest rate. The owner did not make any capital improvements to the property during the hold period. Year one NOI of $456,580. (Note: You DO NOT have any information to go beyond year 1 NOI, so there is zero reason to try to attempt to, any attempt to do so WILL be a significant reduction in points).

The property was sold on the April 11 of year eight for $6,541,380 with closing costs of 4.25%.

The owners Tax rates are 39% ordinary Income, 25% depreciation recapture, 20% capital gains

(For Debt retirement calculations assume full years, ignoring the month specified above. These are more to make you think for the depreciation schedule than to cause confusion with debt retirement.)

Tax Assessment for this property is as follows:

Value
$ (24%)	Land
$ (76%)	Improvements
$ (100%)	Total

1. What is the monthly mortgage payment?
2. What is the mortgage balance at disposition?
3. What is the first year BTCF and ATCF?
4. What are the Sale Proceeds Before Tax?
5. What is the Ordinary income Tax due at Sale?
6. What is the basis of this property at acquisition?
7. What is the Annual Depreciation (full year)?
8. What is the first-year depreciation?
9. What is the depreciation recapture deduction for the year of disposition (how much depreciation has the owner taken over the hold period (in dollars))?
10. What is the depreciation recapture tax due?
11. What is the gain on Sale?
12. What is the Capital Gain amount (dollars)?
13. At a 22% Capital Gain rate, what was the capital gain tax to the owner?
14. What is the SPAT?

Reminder: The Calculation for SPBT and SPAT is below as a refresher

Sale Price

• Cost of Sale
• Mortgage Balance

= Sales Proceeds Before Tax

• Tax (Savings) Ordinary income (Investors Ordinary Income Tax Rate) (see note number 1 below)
• Tax on Depreciation (see note number 2 below)
• Tax on Capital Gains (see note number 3 below)

= Sale Proceeds After Tax

Note 1: Remember what is taxed as ordinary income at time of sale (this is NOT the sale proceeds and is not the same as annual ordinary income tax and is possibly zero).

Note 2: This is a tax on the accumulated depreciation over the hold period.

Note 3: This is a tax on the Taxable Gain (Sale price less closing costs less Adjusted Basis less Depreciation taken)