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.
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.
Chapter10: Capital Budgeting: Decision Criteria And Real Option
Section: Chapter Questions
Problem 14P
Related questions
Question
solve the following in excel
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning