You are considering a luxury apartment building project that requires an investment of $12,500,000. The building has 50 units. You expect the maintenance cost for the apartment building to be $250,000 the first year and $300,000 the second year, after which it will continue to increase by $50,000 in subsequent years. The cost to hire a manager for the building is estimated to be $80,000 per year. After five years of operation, the apartment building can be sold for $14,000,000. What is the annual rent per apartment unit that will provide a return on investment of 15% after tax? Assume that the building will remain fully occupied during the five years. Assume also that your regular tax rate is 35% and the capital gains tax rate is 17.5%. The building has a CCA rate of 4% and will be sold at the end of the fifth year of ownership.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 10PA: The Ham and Egg Restaurant is considering an investment in a new oven that has a cost of $60,000,...
icon
Related questions
Question

solve the following in excel

You are considering a luxury apartment building project that requires an investment
of $12,500,000. The building has 50 units. You expect the maintenance cost for
the apartment building to be $250,000 the first year and $300,000 the second year,
after which it will continue to increase by $50,000 in subsequent years. The cost
to hire a manager for the building is estimated to be $80,000 per year. After five
years of operation, the apartment building can be sold for $14,000,000. What is
the annual rent per apartment unit that will provide a return on investment of 15%
after tax? Assume that the building will remain fully occupied during the five
years. Assume also that your regular tax rate is 35% and the capital gains tax rate
is 17.5%. The building has a CCA rate of 4% and will be sold at the end of the
fifth year of ownership.
Transcribed Image Text:You are considering a luxury apartment building project that requires an investment of $12,500,000. The building has 50 units. You expect the maintenance cost for the apartment building to be $250,000 the first year and $300,000 the second year, after which it will continue to increase by $50,000 in subsequent years. The cost to hire a manager for the building is estimated to be $80,000 per year. After five years of operation, the apartment building can be sold for $14,000,000. What is the annual rent per apartment unit that will provide a return on investment of 15% after tax? Assume that the building will remain fully occupied during the five years. Assume also that your regular tax rate is 35% and the capital gains tax rate is 17.5%. The building has a CCA rate of 4% and will be sold at the end of the fifth year of ownership.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Break-even Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College