Question: 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

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 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 (#15/2-bedroom/ 1 Bath; #10/1 Bedroom/ 1 bath) Average Rent - $1,100/mt for 2 bedroom; $750/mt for 1 bedroom. Taxes - $15,000/ yr. Insurance - $5,000/ yr. General & Admin - $4,000 Amortization - $2,000/y. Management -3% of Effective Gross Vacancy/ Credit Loss -15% Landscape -$6,000/ yr. Maintenance -- $18,000/ yr. Depreciation - $11,500/y. Pest Control - $1,500/yr. I Other Income - $1,500/yr. Payroll - $30,000/ yr. Utilities - $16,000/yr. Capital Improvements - $15,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,...

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

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

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

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

Identify which control activity is violated in each of the following situations. 1. Once a month, the sales department sends unnumbered sales invoices to the accounting department to be recorded....

Suppose a random sample of 14 people 3039 years of age produced the household incomes shown here. Use these data to determine a point estimate for the population variance of household incomes for...

You have just won a $ 2 5 million lottery prize, which pays you $ 1 million ( tax - free ) every year for the next 2 5 years. Have you really won $ 2 5 million ? What have you won if the rate of...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...