Question 1: Disposition and Renovation Decisions I. An investor has owned a property for five years. A property could be sold today for $2 million. It has a loan balance of $ 1 million and, if sold, the investor would incur a total of $250,000 in taxes (capital gains tax + depreciation recapture tax). The investor has determined that if it were sold today, she would have earned an IRR of 15% on equity for the past five years. If not sold, the property is expected to produce after tax cash flow of $50,000 over the next two years. At the end of the two years, the property value is expected to increase to $2.1 million, the loan balance will decrease to $900,000. If sold after two years, the investor would incur a total of $255,000 in taxes. A. What is the incremental internal rate of return for keeping the property two additional years? B. The investor has an outside investment opportunity that is expected to earn him a rate of return of 15%. What advice would you give the investor? II. (Continuation of Question 1) The owner determines that if the property were renovated instead of sold, after tax cash flow over the next two years would increase to $60,000 and the property could be sold after two years for $2.4 million. Renovation would cost $250,000. The investor would not borrow any additional funds to renovate the property. Assume that taxes due on sale after two years would be $255,000. C. What is the rate of return the investor would earn on the additional funds invested in renovating the property (compared to not renovating the property and continuing to operate it as is)? D. The investor has an outside investment opportunity that is expected to earn him a rate of return of 15%. Would you recommend the property be renovated?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Please answer in excel and show steps, thank you.

Question 1: Disposition and Renovation Decisions
An investor has owned a property for five years. A property could be sold today for $2 million. It has a
loan balance of $ 1 million and, if sold, the investor would incur a total of $250,000 in taxes (capital
gains tax + depreciation recapture tax). The investor has determined that if it were sold today, she would
have earned an IRR of 15% on equity for the past five years. If not sold, the property is expected to
produce after tax cash flow of $50,000 over the next two years. At the end of the two years, the property
value is expected to increase to $2.1 million, the loan balance will decrease to $900,000. If sold after
I.
two
years,
the investor would incur a total of $255,000 in taxes.
A. What is the incremental internal rate of return for keeping the property two additional years?
B. The investor has an outside investment opportunity that is expected to earn him a rate of return of
15%. What advice would you give the investor?
(Continuation of Question 1) The owner determines that if the property were renovated instead of sold,
after tax cash flow over the next two years would increase to $60,000 and the property could be sold
after two years for $2.4 million. Renovation would cost $250,000. The investor would not borrow any
additional funds to renovate the property. Assume that taxes due on sale after two years would be
$255,000.
II.
C. What is the rate of return the investor would earn on the additional funds invested in renovating the
property (compared to not renovating the property and continuing to operate it as is)?
D. The investor has an outside investment opportunity that is expected to earn him a rate of return of
15%. Would
you recommend the property be renovated?
Transcribed Image Text:Question 1: Disposition and Renovation Decisions An investor has owned a property for five years. A property could be sold today for $2 million. It has a loan balance of $ 1 million and, if sold, the investor would incur a total of $250,000 in taxes (capital gains tax + depreciation recapture tax). The investor has determined that if it were sold today, she would have earned an IRR of 15% on equity for the past five years. If not sold, the property is expected to produce after tax cash flow of $50,000 over the next two years. At the end of the two years, the property value is expected to increase to $2.1 million, the loan balance will decrease to $900,000. If sold after I. two years, the investor would incur a total of $255,000 in taxes. A. What is the incremental internal rate of return for keeping the property two additional years? B. The investor has an outside investment opportunity that is expected to earn him a rate of return of 15%. What advice would you give the investor? (Continuation of Question 1) The owner determines that if the property were renovated instead of sold, after tax cash flow over the next two years would increase to $60,000 and the property could be sold after two years for $2.4 million. Renovation would cost $250,000. The investor would not borrow any additional funds to renovate the property. Assume that taxes due on sale after two years would be $255,000. II. C. What is the rate of return the investor would earn on the additional funds invested in renovating the property (compared to not renovating the property and continuing to operate it as is)? D. The investor has an outside investment opportunity that is expected to earn him a rate of return of 15%. Would you recommend the property be renovated?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education