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. What is the mortgage balance by the end of year 8 if John does renovate the property? (Choose the nearest value)

A. $954,230

B. $1,152,233

C. $965,662

D. $1,003,848

1b. If John can renovate the property by obtaining a new loan that is equal to 75% of the sum of the existing value of the property ($1,050,000) plus the renovation costs. What is the additional equity John needs to invest if he does the renovation?

A. $85,423

B. $55,245

C. $37,824

D. $45,641

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

A. $81,955

B. $43,077

C. $60,308

D. $45,949

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