Tranquil Manor is a 33,000 square foot apartment complex located at 1000 Raucous Causeway, South Haven,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tranquil Manor is a 33,000 square foot apartment complex located at 1000 Raucous Causeway, South Haven, CT 06999. The location is fully built-up and well established with multi-family housing. The prevailing capitalization rate in this area for properties such as this is 11%. You are contemplating the purchase of this property on December 31, 2005. The building is brick, about 50 years old and has been well-maintained. There is no evidence of deferred maintenance or of the need to replace the roof or mechanicals at any time in the near future (no CapEx needed). 75% of the value of the property lies in the building and 25% in the land. Use straight line depreciation (1/27.5 per year) for life of building which is 27.5 years for a residential income-producing property. The building has 48 apartments. Every apartment is occupied and all leases expire within a year or less. The owner has presented us with the following rent roll information: - 10 studio apartments @ $700 each • 30 1-bedroom apartments @ $950 each 82-bedroom apartments @ $1,150 each (A note on data entry: Don't enter 48 individual apartments into the rent roll; it's an unnecessary exercise. Make only three entries, one for each type of apartment, and aggregate the rent for each. For example, as the first "tenant" enter a name such as "10 studio apartments @ $700" and the first year's rent as 7000.) Your research shows that these rents are realistic in this market and also that rents have been increasing at about 2% per year. Although there are no vacancies now, you will estimate a 2% vacancy loss. You combine the owner's representations with your knowledge of similar buildings and come up the following estimate of first-year operating expenses: Accounting 2,500 Insurance (fire and liab.) 29,300 Lawn/Snow 7,400 Legal 6,200 Miscellaneous 3,200 Property Management 38,400 Repairs and Maintenance 29,300 Supplies 7,400 Real Estate Taxes 42,600 Trash Removal 18,600 Electricity 12,200 Sewer and Water 29,500 Telephone 800 You believe that each of these expenses will increase at 3% per year except insurance (5%) and real estate taxes (4%). The seller's asking price is $3 million. You believe you can obtain financing for 80% of the purchase price. The terms are a 7% interest rate, 240-month term and 2 points. You plan to sell at the end of 2010. Selling price is based on 3% expected annual appreciation. You also expect to pay 7% of the selling price as your cost of sale when you eventually dispose of the property. You have a 30% income tax and 20% capital gains tax. The depreciation recapture tax rate is 25%. 1) What is the IRR on the property? 2) What is the BTIRR on equity? 3) What is the ATIRR on equity? 4) Note that your NOI is going up each year, but at a decelerating rate. Why? 5) What is the effective tax rate? 6) What is the year-1 break-even occupancy level? 7) Before-tax, what is the cash-on-cash multiple for this investment? Tranquil Manor is a 33,000 square foot apartment complex located at 1000 Raucous Causeway, South Haven, CT 06999. The location is fully built-up and well established with multi-family housing. The prevailing capitalization rate in this area for properties such as this is 11%. You are contemplating the purchase of this property on December 31, 2005. The building is brick, about 50 years old and has been well-maintained. There is no evidence of deferred maintenance or of the need to replace the roof or mechanicals at any time in the near future (no CapEx needed). 75% of the value of the property lies in the building and 25% in the land. Use straight line depreciation (1/27.5 per year) for life of building which is 27.5 years for a residential income-producing property. The building has 48 apartments. Every apartment is occupied and all leases expire within a year or less. The owner has presented us with the following rent roll information: - 10 studio apartments @ $700 each • 30 1-bedroom apartments @ $950 each 82-bedroom apartments @ $1,150 each (A note on data entry: Don't enter 48 individual apartments into the rent roll; it's an unnecessary exercise. Make only three entries, one for each type of apartment, and aggregate the rent for each. For example, as the first "tenant" enter a name such as "10 studio apartments @ $700" and the first year's rent as 7000.) Your research shows that these rents are realistic in this market and also that rents have been increasing at about 2% per year. Although there are no vacancies now, you will estimate a 2% vacancy loss. You combine the owner's representations with your knowledge of similar buildings and come up the following estimate of first-year operating expenses: Accounting 2,500 Insurance (fire and liab.) 29,300 Lawn/Snow 7,400 Legal 6,200 Miscellaneous 3,200 Property Management 38,400 Repairs and Maintenance 29,300 Supplies 7,400 Real Estate Taxes 42,600 Trash Removal 18,600 Electricity 12,200 Sewer and Water 29,500 Telephone 800 You believe that each of these expenses will increase at 3% per year except insurance (5%) and real estate taxes (4%). The seller's asking price is $3 million. You believe you can obtain financing for 80% of the purchase price. The terms are a 7% interest rate, 240-month term and 2 points. You plan to sell at the end of 2010. Selling price is based on 3% expected annual appreciation. You also expect to pay 7% of the selling price as your cost of sale when you eventually dispose of the property. You have a 30% income tax and 20% capital gains tax. The depreciation recapture tax rate is 25%. 1) What is the IRR on the property? 2) What is the BTIRR on equity? 3) What is the ATIRR on equity? 4) Note that your NOI is going up each year, but at a decelerating rate. Why? 5) What is the effective tax rate? 6) What is the year-1 break-even occupancy level? 7) Before-tax, what is the cash-on-cash multiple for this investment?
Expert Answer:
Answer rating: 100% (QA)
1 To calculate the Internal Rate of Return IRR on the property determine the cash flows over the hol... View the full answer
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these finance questions
-
( support your answer with one academic reference and non-academic or industry reference ). Every year, as a CEO of a company, you are required to make an annual formal report. In your opinion, what...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Gombas Company decided to analyze certain costs for October of the current year. There was no beginning inventory. Units started into production equaled 14000, units transferred out equal 12000, and...
-
Change to LIFO Retail; Dollar-Value LIFO Retail Davenport Department Store converted from the conventional retail method to the LIFO retail method on January 1, 2010, and is now considering...
-
Consider the data set of paint thicknesses given in DS 6.1.8. Construct a point estimate of the average paint thickness. What is the standard error of your point estimate?
-
A \(5-\mathrm{kg}\) object is subject to an interaction that has a potential energy \(U(x)=\frac{1}{2} k x^{2}-b x\), where \(k=2.0 \mathrm{~J} / \mathrm{m}^{2}\) and \(b=1.5 \mathrm{~J} /...
-
1. How many minutes, on average, does it take for a first edition patron to get the requested book from time of entry into the library? (State all assumptions and show the calculations.) 2. How many...
-
Write the SOP Boolean expressions for the 7 outputs. [ 3 . 5 marks ]
-
Isorait Co is a company which installs kitchens and bathrooms to customer specifications. It is planning to invest KShs. 4,000,000 in a new facility to convert vans and trucks into motorhomes. Each...
-
a) On April 1, 2023, Kaur Company issued $1,000,000 face value, 16.3% , ten-year bonds. The market rate of interest was 16%. Interest is paid semi-annually on April 1st and October 1st. Kaur Company...
-
Which statement regarding net passive losses is accurate? a. Net passive losses do not reduce a partners basis and at-risk amounts, because the partner is not allowed to deduct them. b. No current...
-
Partner L of the LMN Partnership agrees to actively manage the partnership in return for a $6,000 distribution from the partnership each month. How should the $6,000 monthly payment be treated by L?...
-
In Rev. Rul. 81-301, which of the following is not a factor considered by the IRS in determining whether a partner receives payments in her capacity as a partner, or is instead acting as a third...
-
R and Q form equal partnership RQ on February 15. Partner R has a tax year ending on July 31, whereas partner Qs tax year ends on October 31. What taxable year must the partnership use? a. February...
-
Which of the following are valid lambda expressions? (Choose three.) A. () -> {} B. (Double adder) -> {int y; System.out.print(adder); return adder;} C. (Long w) -> {Long w=5; return 5;} D. (int...
-
Which of the following molecules can form hydrogen bonds? Check all that apply. ammonia, NH3 U H hydrogen bromide, HBr H -Br: water, HO H H H butane, C4H10 H H H hydrogen, H H H H H H H H
-
Is that Yelp review real or fake? The article A Framework for Fake Review Detection in Online Consumer Electronics Retailers (Information Processing and Management 2019: 12341244) tested five...
-
Consider again, as in exercise 27.11, the political incentives for legislators that represent districts. In exercise 27.11, we considered pork barrel projects as publicly funded private goods that...
-
Suppose you own a business that does well during economic expansions but not so well during recessions which happen with probability . Let xE denote your consumption level during expansions and let...
-
Did 9/11 Change Tastes?: In another textbook, the argument is made that consumer tastes over airline miles traveled and other goods changed as a result of the tragic events of September 11, 2001. A:...
-
Identify something you own, perhaps even something you still use regularly. a. Give a list of at least six reasons why you might consider replacing the identified item. b. Identify at least two...
-
A company owns a 6-year-old gear hobber that has a book value of \($60,000.\) The present market value of the hobber is \($80,000.Anew\) gear hobber can be purchased for \($450,000.\) Using an...
-
Ten reasons why companies use equipment long after replacements would be justified economically. In many cases, these reasons do not apply just to companies; rather, they apply to us as individuals....
Study smarter with the SolutionInn App