Question: Please show all work on paper not excel!!! A 30 year old 100 unit apartment complex in a transitional neighborhood is for sale for 10,000,000

Please show all work on paper not excel!!!

A 30 year old 100 unit apartment complex in a transitional neighborhood is for sale for 10,000,000 Using the numbers below what us the gross possible income, effective gross, NOI, and cashflow. What is the asking cap rate, return on equity and Price Per Unit? If you want at least 5% return on your investment how much would you pay for thr complex? is this a good deal?

Basic financial information

100 units(#75 2-bed/ 1 bath and #25-1 bed/bath)

Acerage rent 1,100/mt for 2 beds, 850/mt for one bed

Vacancy/ credit loss-10%

Expenses 5000 unit/year

Other Income 4,000

Equity (30%) 3,000,000

Loan (70%) 7,000,000 @ 5% intrest only with 5 year balloon

Debt service 350,000/ YR

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 General Management Questions!

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

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

Calvin and his wife Susie live in Watterson, California which is a moderate sized town between Sacramento and Chico. They have been pretty successful in their financial lives over the years and own a...

I have an assignment for Finance Management: Payback Periods, Net Present Value, Internal rate of return , NPV, Equivalent Annual Annuity, Estimation CF, Capital Rationing. Please see excel...

please show your work on excel 1) What did Plimsol pay for the Note? Your can use QUARTERLY data (not necessary to use XIRR since all cash flows will Become Conventional) On March 10, 2006, HDP...

Please help with these Capsim Production numbers. I believe 6-15 is good how it currently is. 1-5 I am not sure how to get the production schedule numbers, please show your work. Eat=Traditonal,...

Please show your work. A B C D E F G H J K L M N o F 1 Q1: 2 An important task in performing business valuations is normalizing the historical financial statements. (a). Using the information...

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

Please show ALL work This is all I was given There are no tables The following transactions occurred in a merchandising business that was incorporated in the month of October The numbers beside the...

Bloomsbury Ltd provides you with the following information for one of its contracts, contract X: Contract price 4,000 Cost of work recognised / certified 1,400 Costs carried forward 100 Value of...

A metal ion with a net +3 charge has five electrons in the 3d sub shell. Identify the metal.

The AICPA's Code of Professional Conduct sets forth rules for CPAs

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...