Question

In: Finance

Atlas Realty Partners, a real estate investment company, is under contract to buy a 30-unit mixed-use...

Atlas Realty Partners, a real estate investment company, is under contract to buy a 30-unit mixed-use apartment building in Brooklyn, NY for $11,000,000. The property consists of 28 apartments, each 850 square feet, renting for $2,400 a month per unit, and 2 stores - the first is a 2,000 square foot space with a yoga studio as the tenant in place, paying a $8,500 rent per month and the second is a 3,000 square foot space with a sport equipment store as the tenant, paying $11,500 rent per month. Vacancy rates in the area are 5% for ground floor commercial spaces and 3% for the apartments on the upper floors. The borrower owns several similar properties in the neighborhood and knows that expenses are about 30% of the effective gross income.

1. What is the annual gross potential income?

2. What is the annual NOI (Net Operating Income)?

3. What is the capitalization rate?

4. What loan amount the borrower could get based on a 65% loan-to-value?

5. What is the loan constant based on a 30-year amortization schedule and a 3.50% interest rate?

6. What is the annual debt service? (also use answers to questions 4 and 5)

7. What is the actual debt service coverage ratio? (also use answers to questions 2, 4, 5 and 6)

8. How much equity will the borrower need to invest if closing costs are $150,000? (also use answer to question 4)

9. How much is the free cash flow after debt service? (Also use answers to questions 2, 4, 5 and 6)

10.What is the borrower's cash on cash return? (Also use answers to questions 2, 4, 5, 6 and 8)

Solutions

Expert Solution

You have asked multiple sub parts in the same question. I will address the first four. Please post the balance sub parts as separate question.

1. The property consists of 28 apartments, each 850 square feet, renting for $2,400 a month per unit, and 2 stores - the first is a 2,000 square foot space with a yoga studio as the tenant in place, paying a $8,500 rent per month and the second is a 3,000 square foot space with a sport equipment store as the tenant, paying $11,500 rent per month.

Annual gross potential income = (28 x 2,400 + 8,500 + 11,500) x 12 = $ 1,046,400

2. Annual Net Operating income = Annual gross potential income - Vaccancy losses - Operating expenses

Vacancy rates in the area are 5% for ground floor commercial spaces and 3% for the apartments on the upper floors.

Hence, Vaccancy losses = [28 x 2,400 x 3% + (8,500 + 11,500) x 5%] x 12 = $ 36,192

Operating expenses = 30% of effective gross income = 30% x (Annual gross potential income + other income - Vaccancy losses) = 30% x ($ 1,046,400 + 0 - 36,192) =  303,062

Hence, annual NOI = 1,046,400 - 36,192 - 303,062 = $  707,146

3. Capital Value = Annual NOI / Capitalization rate

Hence, Capitalization rate = Annual NOI / Capital value = 707,146 / 11,000,000 = 6.43%

4. Loan amount the borrower could get based on a 65% loan-to-value = 65% x 11,000,000 = $  7,150,000

Please post the balance sub parts as a separate question.


Related Solutions

Atlas Realty Partners, a real estate investment company, is under contract to buy a 30-unit mixed-use...
Atlas Realty Partners, a real estate investment company, is under contract to buy a 30-unit mixed-use apartment building in Brooklyn, NY for $11,000,000. The property consists of 28 apartments, each 850 square feet, renting for $2,400 a month per unit, and 2 stores - the first is a 2,000 square foot space with a yoga studio as the tenant in place, paying a $8,500 rent per month and the second is a 3,000 square foot space with a sport equipment...
If, under a real estate contract, the seller is to provide financing to the purchaser, what...
If, under a real estate contract, the seller is to provide financing to the purchaser, what issues should be discussed concerning seller financing?
CenTer Realty is a recently founded commercial and residential real estate company. CenTer grossed $3,000,000 in...
CenTer Realty is a recently founded commercial and residential real estate company. CenTer grossed $3,000,000 in revenues last year, while incurring $1,000,000 in operating expenses and $300,000 in income taxes. CenTer Realty owned and occupied an office building in downtown Kansas City. The building could have been leased to other businesses for $500,000 in lease income last year. The owner of CenTer Realty invested $4,000,000 of his own money that could have earned a 10 percent rate of return on...
Five years ago, Farley Walton purchased a 30% interest in Oak Motte Partners, a real estate...
Five years ago, Farley Walton purchased a 30% interest in Oak Motte Partners, a real estate development partnership. He paid $50,000 for a 30% interest in capital, profits and losses. This year, at the end of the year, Farley sold his interest in the partnership for $250,000 cash to an unrelated buyer. The following table summarizes Farley’s distributive share of partnership profits and losses, as well as distributions received and additional capital contributions made by Farley over the five year...
Dr. Godwin decides to open a real estate company which he names, Comfort Realty, Inc. The...
Dr. Godwin decides to open a real estate company which he names, Comfort Realty, Inc. The following transactions were made over the period: On September 1, 2018, Dr. Godwin invested $15,000 cash in the business On September 3, 2018, Comfort Realty purchases computer equipment for $7,000 cash. On September 4, 2018, Comfort realty purchases for $1,600 from ACME supply company computer paper and other supplies exacted to last several months. ACME agrees to allow Comfort Realty to pay this bill...
Dr. Williams decides to open a real estate company which he names, Comfort Realty, Inc. The...
Dr. Williams decides to open a real estate company which he names, Comfort Realty, Inc. The following transactions were made over the period: On September 1, 2018, Dr. Godwin invested $17,000 cash in the business On September 3, 2018, Comfort Realty purchases computer equipment for $8,000 cash. On September 4, 2018, Comfort realty purchases for $1,600 from ACME supply company computer paper and other supplies exacted to last several months. ACME agrees to allow Comfort Realty to pay this bill...
Real estate investment As an example, suppose that the subject property is a 20-unit apartment complex....
Real estate investment As an example, suppose that the subject property is a 20-unit apartment complex. Three recent sales of comparable properties have been discovered and the data has been verified with sellers and buyers. The three areas are as follows: Comparable Sales Price Units Potential Gross Income #1 $600,000 25 $100,000 #2 $750,000 30 $128,000 #3 $450,000 18 $74,000 PGI of Subject (Potential Gross Income)=$82,000 Comparable #1 offers amerities and location nearest to the subject property but has superior...
Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy...
Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy the property today and sell it 12 years from today. The initial cost of the property is $7 million and the expected sale price is $19 million. What is the IRR of the investment? Enter your answer as a percentage and rounded to 2 DECIMAL PLACES. Do not include the percentage sign in your answer. ​ Enter your response below. ​%
Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy...
Seabreeze Properties is evaluating a real estate investment of Green Hills Estates. Management plans to buy the property today and sell it 12 years from today. The initial cost of the property is $7 million and the expected sale price is $19 million. What is the IRR of the investment? Enter your answer as a percentage and rounded to 2 DECIMAL PLACES. Do not include the percentage sign in your answer. ​ Enter your response below. ​%
Identify the vision and mission statement of the investment company in the real-estate development in which...
Identify the vision and mission statement of the investment company in the real-estate development in which you are working. Rewrite the vision and mission statement of the company according to your opinion focusing on continuous improvement, and justify the changes that you would like to bring in the new vision and mission statement of the company.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT