You are considering the purchase of a 120-unit apartment complex. The 50 one-bedroom units rent for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are considering the purchase of a 120-unit apartment complex. The 50 one-bedroom units rent for $650 per month and the remaining 70 two-bedroom units rent for $800 per month. Vacancy and credit losses are 10% in this market. There is miscellaneous income of $20,000 per year (also subject to vacancy). Operating expenses for this property are 35% of gross operating income. Market cap rates for this type of investment are 7.75%. You can get a loan equal to 75% of the purchase price at 7.00% interest with a 30-year amortization term. The minimum debt coverage ratio is 1.25. 1. What is the NOI? 2. What is the Purchase Price (do not round)? 3. How much is the loan amount? 4. How much is the annual cebt service? 5. What is the cash on cash? 6. Calculate the debt coverage ratio? Now assume a different scenario: this is a value-add opportunity and you plan to hold the property for 3 years. You are considering using an interest only loan at 6.825% fixed for 5 years with an 75% loan to value. You can become more efficent with the operations and bring those down immediately in the first year by 2.5% by getting your management team in there. In addition, you expect that you can reduce the vacancy and credit loss to 7.5% in the second year and 5% in the third year. You also assume that rents increase at a modest 2.0% annually, beginning immediately, and that the miscellaneous income remains flat. When you sell the property at the end of Year 3, you expect cap rates to be a little higher at 8.0%. Commissions and closing costs are 4.5% and 0.5%, respectively. 1. How much equity is required? 2. What is the DCR in each year? 3. What is the Cash On Cash in each year? 4. What is the total investment IRR? 5. What is the total profit from the investment? You are considering the purchase of a 120-unit apartment complex. The 50 one-bedroom units rent for $650 per month and the remaining 70 two-bedroom units rent for $800 per month. Vacancy and credit losses are 10% in this market. There is miscellaneous income of $20,000 per year (also subject to vacancy). Operating expenses for this property are 35% of gross operating income. Market cap rates for this type of investment are 7.75%. You can get a loan equal to 75% of the purchase price at 7.00% interest with a 30-year amortization term. The minimum debt coverage ratio is 1.25. 1. What is the NOI? 2. What is the Purchase Price (do not round)? 3. How much is the loan amount? 4. How much is the annual cebt service? 5. What is the cash on cash? 6. Calculate the debt coverage ratio? Now assume a different scenario: this is a value-add opportunity and you plan to hold the property for 3 years. You are considering using an interest only loan at 6.825% fixed for 5 years with an 75% loan to value. You can become more efficent with the operations and bring those down immediately in the first year by 2.5% by getting your management team in there. In addition, you expect that you can reduce the vacancy and credit loss to 7.5% in the second year and 5% in the third year. You also assume that rents increase at a modest 2.0% annually, beginning immediately, and that the miscellaneous income remains flat. When you sell the property at the end of Year 3, you expect cap rates to be a little higher at 8.0%. Commissions and closing costs are 4.5% and 0.5%, respectively. 1. How much equity is required? 2. What is the DCR in each year? 3. What is the Cash On Cash in each year? 4. What is the total investment IRR? 5. What is the total profit from the investment?
Expert Answer:
Related Book For
Real Estate Finance and Investments
ISBN: 978-0073377339
14th edition
Authors: William Brueggeman, Jeffrey Fisher
Posted Date:
Students also viewed these finance questions
-
You are considering the purchase of a small office building in Brooklyn. The property contains 20,000 square feet of rentable space and is currently occupied by multiple tenants each with differing...
-
Air flows through the fine mesh gauze shown in the figure below with an average velocity of 1.50 m/s in the pipe. Determine the loss coefficient for the gauze. KL= i 8.1mm V = 1.5 m/s Water Gauze...
-
Empty Fields Company pays its salaried employees monthly on the last day of each month. The annual salary payroll for 20-- follows. Compute the following for the payroll of December 31: OASDI Taxable...
-
As mentioned, spreadsheets can do the work for us of computing beta. Use Excels slope function to estimate the beta of Microsoft using the data in Table LE12.1. Use the intercept function to estimate...
-
For approximately 20 months, Robert E. McDonald perpetrated a scheme to solicit millions of dollars purportedly for a \($100\) million purchase by the RAI Entities and certain other related corporate...
-
The comparative balance sheet of Canace Products Inc. for December 31, 2014 and 2013, is as follows: Additional data obtained from an examination of the accounts in the ledger for 2014 are as...
-
A Rolls-Royce Phantom weighing 2.49 x 104 N is traveling in the +x direction with an initial speed of 40.2 m/s when the driver hits the brakes. The car slows to a stop in 5.60 s. If the acceleration...
-
Firstly need to design an HR Department for a fictitious company which will be a construction company who builds and renovated. The company is brand new, and it is private sector and non-union with...
-
Which specific parameters are utilized by third-party payers in reimbursing healthcare providers, and how do these parameters influence the reimbursement process?
-
A company is projected to have a free cash flow of $243 million next year, growing at a 5.6% rate until the end of year 3. After that, cash flows are expected to grow at a stable rate of 2.1%. The...
-
Consider a particle of mass m moving on a smooth vertical parabolic wire placed in a uniform gravitational field: r = xE+yE, y = cx, V = mgy, where c is a positive constant. (a) Using x as a...
-
You are unsure whether you want to invest in ABC Corp or XYZ Inc, which is a much larger company. What tool would you use to appropriately compare the two companies? Explain
-
Although carrying receivables means a company is not getting cash quickly, why would a company extend credit to customers?
-
Devise a gear train with a train value of -900:1. Specify the number of the teeth in each gear. From interference criteria, no gear should have fewer than 17 teeth. Due to size restrictions, no gear...
-
A container holds 2.0 mol of gas. The total average kinetic energy of the gas molecules in the container is equal to the kinetic energy of an 8.0 10-3-kg bullet with a speed of 770 m/s. What is the...
-
What is meant by the term overage for retail space ?
-
Use the same information as in problem 3. Now assume a loan for $1.5 million is obtained at a 10 percent interest rate and a 15-year term. a. Calculate the expected IRR on equity and the standard...
-
What is a standby commitment? When and why is it used?
-
True or False: Engineers seldom have an opportunity to influence the recovery period for expenditures.
-
A lumber company purchases and installs a wood chipper for \(\$ 200,000\). The chipper is classified as MACRS 7-year property. Its useful life is 10 years. The estimated salvage value at the end of...
-
True or False: Straight-line depreciation is the most popular depreciation method used in financial reporting.
Study smarter with the SolutionInn App