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

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, 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 it a good deal for you?

Show your work. Basic Financial Information: 50 units (#25/2-bedroom/ 1 Bath; #20/1 Bedroom/ 1 bath; #S/ Studio) Average Rent - $1,100/mt for 2 bedroom; $750/mt for 1 bedroom; Studio for $500/mt. Taxes - $35,000/ yr. Insurance - $7,500/yr. General & Admin - $10,000 Amortization - $3,000/ yr. Management - 3% of Effective Gross Vacancy/ Credit Loss - 10% Landscape -$20,000/ yr. Maintenance - $40,000/ yr. Depreciation - $15,000/ yr. Pest Control - $2,500/ yr. Other Income - $3,000/yr. Payroll - $60,000/ yr. Utilities - $35,000/yr. Capital Improvements - $35,000/ yr. Advertising - $8,000/ yr. Equity - $750,000 Loan - $2,250,000 @ 7%, Interest only. 5 year balloon Debt Service - $157,500/year: $13,125/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 Accounting Questions!

#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 to evaluate the purchase of a ten year old 16 unit apartment building located in a prime area. Asking price is $3,000,000. Please complete the Cash Flow Analysis incorporating the following...

The next 5 screenshots were provided my the professor to help us. This is what we have come up with. Evaluate the attached proforma information. You need to do a ten year Spreadsheet similar to...

Ann is looking to buy an office building in 2014. She plans to rent it out for 5 years (2015-2019) and sell it at the end of 2019. (1) Use the first sheet of the spreadsheet (titled "NOI") to compute...

its just a case study i need to write what rec for the gates family and what are financial areas of concern CASE 9 TREVOR AND LINDA GATES CASE Today is January 1, 2017 INTRODUCTORY DATA Trevor and...

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 100 unit apartment...

You are considering a purchase of a 4-plex, which is located in a desirable neighborhood. The cost of the property is $500,000. Effective rents are expected to average $1500 per month. Every resident...

Dexter Company, which produces a single product, has the following standard cost and actual cost information: Standard cost: Direct materials ( 8 pounds @ $2.5/lb) $20 Direct labor (3 direct labor...

Heres another model for the MSRP of off-road motorcycles. a) Would this be a good model to use to predict the price of an off-road motorcycle if you knew its bore, clearance, and engine strokes?...

Program trading is the simultaneous buying and selling of at least 1 5 stocks worth a total of $ 1 million or more. true false

Which of the following is false?If you use systems thinking, you see ISM 3 0 1 1 as a part of the business curriculum, which interacts with other courses of the business curriculum, and thus taking...

=+1. Define each of these terms: vision, mission, strategy, and tactics. What is the relationship among them in relation to a firms strategy planning process?

=+Does it make sense for an oil firm to donate money to the same group because it perceives climate change as a threat to its business model and wants to mitigate that threat by investigating...

=+Does it make sense for a large financial firm to donate money to a group researching the effects of climate change because the CEO believes this is an important issue?