Question: #5) A 50-year-old 25 unit apartment complex in a transitional neighborhood is for sale in Atlanta for $1,200,000. Using the financials below what is the

#5) A 50-year-old 25 unit apartment complex in a transitional neighborhood is for sale in Atlanta for $1,200,000. Using the financials below what is the NOI, Cash Flow, Asking Cap Rate, Return on Equity, Debt Coverage Ratio, Loan to Value and Debt Coverage Ratio? If you want at least a 8% return on your investment how much would you pay for the complex? Is this a good deal for you? Show your work. Basic Financial Information: 25 units (#15/2bedroom/ 1 Bath; #10/1 Bedroom] 1 bath) Average Rent - $1 ,100/mt for 2 bedroom; $750/ mt for1 bedroom. Taxes - $15,000/ yr. Insurance - $5,000/ yr. General & Admin - $4,000 Amortization $2,000! yr. Management 3% of AGI Vacancy/ Credit Loss 15% Landscape $6,000/ yr. Maintenance $18,000! yr. Depreciation - $11 ,500/ yr. Pest Control - $1 ,500/ yr. Other Income - $1 ,500/yr. Payroll $30,000/ yr. Utilities - $16,000/ yr. Capital Improvements $12,000/ yr. Advertising - $3,500/ yr. Equity (30%) $360,000 Loan (70%) - $840,000 @ 6%, Interest Only with 5-year balloon Debt Service - $50,400 / year; $4,200 / month

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A 50-year-old 25 unit apartment complex in a transitional neighborhood is for sale in Atlanta for $1,200,000. Using the financials below what is the NOI, Cash Flow, Asking Cap Rate, Return on Equity,...

how do you find the NOI, Cash Flow, asking Cap Rate, Return Equity, Debit Coverage Ratio, Loan to Value, Debt Coverage Ratio A 50 -year-old 25 unit apartment complex in a transitional neighborhood is...

A 50-year-old 25-unit apartment complex in a transitional neighborhood is for sale in Atlanta for $1,200,000. Using the financials below what is the NOI, Cash Flow, Asking Cap Rate, Return on Equity,...

4.) A 30 year old 50 unit apartment complex is for sale in Kennesaw, Ga for $3,000,000. Using the financials below what is the NOI, Cash Flow, Asking Cap Rate, Return on Equity, Debt Coverage Ratio,...

#4) A 30-year-old 200 unit apartment complex is for sale in Canton, GA for $12,000,000. Using the financials below what is the NOI, Cash Flow, Asking Cap Rate, Return on Equity, Debt Coverage Ratio,...

A 30-year-old 200 unit apartment complex is for sale in Canton, GA for $12,000,000. Using the financials below what is the NOI, Cash Flow, Asking Cap Rate, Return on Equity, Debt Coverage Ratio, Loan...

You are a real estate investor that has an interest in purchasing a multifamily property in Atlanta Georgia. You received the offering brochure and you discovered that this is a 25 unit apartment...

Refer to question 22 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver.

What are the factors that may lead the best price for a product to differ between market segments?

Common - sixe financial statements: Mutiple Chisice Do not emphenize tive reledive importence of each ilem Is also known as horizortal malyis. Show the dolter amount of change for firanciel statement...

Solve for t t 8 36 6 t Type Type an integer or a simplified fra