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

#4) A 40-year-old 50 unit apartment complex in a transitional neighborhood is for sale in Atlanta for $3,000,000. Using the financials below what

#4) A 40-year-old 50 unit apartment complex in a transitional neighborhood is for sale in Atlanta for $3,000,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 10% 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 (#25/2-bedroom, 1 Bath; #15/1 Bedroom, 1 bath and #10/ Studios). Average Rent: $1,100/mt for 2 bedroom; $800/ mt for 1 bedroom and $600 for the studios. Taxes - $50,000/ yr. Insurance - $9,000/ yr. General & Admin - $7,000 Amortization - $2,000/ yr. Management -3% of Effective Gross Vacancy/ Credit Loss 15% Landscape -$8,000/ yr. Maintenance - $35,000/ yr. Depreciation - $11,500/ yr. Pest Control - $3,000/ yr. Other Income - $1,500/yr. Payroll - $30,000/ yr. Utilities - $25,000/ yr. Capital Improvements - $30,000/ yr. Advertising - $10,000/ yr. Equity (30%) - $750,000 Loan (70%) - $2,100,000 @ 8%, Interest Only with 5-year balloon Debt Service - $168,000 / year; $14,000 / 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!

#4) A 40-year-old 50 unit apartment complex in a transitional neighborhood is for sale in Atlanta for $3,000,000. Using the financials below what is the NOI, Cash Flow, Asking Cap Rate, Return on...

can someone show me the work for this and answer the question as if it would apply to them? #4) A 50-year-old 25 unit apartment complex in a transitional neighborhood is for sale in Atlanta for...

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,...

14) 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...

#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...

#4) A 30-year-old 100 unit apartment complex in a transitional neighborhood is for sale in Atlanta for $10,000,000. Using the numbers below what is the Gross Possible Income, Effective Gross, NOI,...

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,...

Two thousand randomly selected adults were asked if they think they are financially better off than their parents. The following table gives the two-way classification of the responses based on the...

Consider the following reaction, equilibrium concentrations, and equilibrium constant at a particular temperature. Determine the equilibrium concentration of H2O(g): [C2H4]eq = 0.015 M, [C2H5OH]eq =...

Short - term investing requires more diligent monitoring than long - term investing. True False

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".