John presently owns an office building, which is 30 years old, and is considering renovating it. Assume that if John does the renovation, he will be able to obtain a new loan that is equal to the balance of the existing loan plus 75% of the renovation costs. Assume a five-year holding period. Below is the information about the property and Johns estimation if he does the renovation.

1a. The NOI for year 4 is $90,000. What is the after-tax cash flow from operations for year 4 if John does not renovate the property?

1b. What is the annual loan payment if John does renovate the property?

1c. What is the capital gain tax from the property sale by the end of year 8 if John does renovate the property?

400,000 20.00% 3.00% 1,523,000 3.00% of sale price 11.00% CURRENT Purchase Price Building Value Land Value Loan-to-value ratio Interest Term Payments per year Years since Purchased Current NOI (year 4) Projected Increase in NOI Resale Value Today Depreciable Life Ordinary income tax rate Price appreciation tax rate Depreciation recapture tax rate IF RENOVATED 1,000,000 Renovation Cost 800,000 Initial Increase in NOI (year 4) 200,000 Annual Increase in NOI 75.00% Resale Value after holding 5 years 9.00% Selling Expenses 30 years New Loan: 12 Interest Rate 3 Term 90,000 Payments per year 2.00% per year 1,050,000 39 years 28.00% 28.00% 28.00% 30 years 12 400,000 20.00% 3.00% 1,523,000 3.00% of sale price 11.00% CURRENT Purchase Price Building Value Land Value Loan-to-value ratio Interest Term Payments per year Years since Purchased Current NOI (year 4) Projected Increase in NOI Resale Value Today Depreciable Life Ordinary income tax rate Price appreciation tax rate Depreciation recapture tax rate IF RENOVATED 1,000,000 Renovation Cost 800,000 Initial Increase in NOI (year 4) 200,000 Annual Increase in NOI 75.00% Resale Value after holding 5 years 9.00% Selling Expenses 30 years New Loan: 12 Interest Rate 3 Term 90,000 Payments per year 2.00% per year 1,050,000 39 years 28.00% 28.00% 28.00% 30 years 12