Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Show all work in excel if possible) A retail property was acquired on April 12 of year one with $750,000 of cash and $3,500,000 of

(Show all work in excel if possible)

A retail property was acquired on April 12 of year one with $750,000 of cash and $3,500,000 of debt. The mortgage was a 20 year term, 5.75% 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.

The property was sold on the April 11 of year eight for $ $5,800,000 with closing costs of 4.75%.

The owners Tax rates are 39% ordinary Income, 27% depreciation recapture, 15% capital gains

Tax Assessment for this property is as follows:

Value

$(25%)

Land

$(75%)

Improvements

$4,250,000 (100%)

Total

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

Reminder: Calculations for SPBT and SPAT is below

Sale Price

  • Cost of Sale
  • Mortgage Balance

=Sales Proceeds Before Tax

  • Tax (Savings) Ordinary income (Investors Ordinary Income Tax Rate)
  • Tax on Straight Line Depreciation
  • Tax on Capital Gains

= Sale Proceeds After Tax

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan

12th edition

1259918947, 1260091908, 978-1259918940

More Books

Students also viewed these Accounting questions

Question

discuss what an intervention is in relation to work psychology;

Answered: 1 week ago

Question

Data table " " Th Done More info

Answered: 1 week ago

Question

2. In what way can we say that method affects the result we get?

Answered: 1 week ago