Question

In: Finance

Underwriting information: 200 unit apartment building 1,000 per month average rent 8% vacancy 38% total operating...

Underwriting information:

200 unit apartment building

1,000 per month average rent

8% vacancy

38% total operating expense ratio

Replacement Reserves of $250 per unit per year

3% growth rate

Purchase price is $20 million

Exit cap rate is 7.5%

Sales costs are 2%

Unlevered discount rate is 8%

Assume 5 year holding period

Part 1 - Prepare 5 year pro forma operating statement

What is cap rate on the purchase price?

Determine the sales price at the end of year 5

Based on your analysis, what do you think the initial value of the asset is?

If you buy the asset for $20 million, what is your NPV? IRR?

Solutions

Expert Solution

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Underwriting information: 200 unit apartment building 1,000 per month average rent 8% vacancy 40% total operating...
Underwriting information: 200 unit apartment building 1,000 per month average rent 8% vacancy 40% total operating expense ratio 3% growth rate Purchase price is $20 million Exit cap rate is 7.5% Unlevered discount rate is 8% Assume 5 year holding period 2. Assume the above but now with the following loan information: Loan principal of $10 million 5% interest rate 30 year term with amortization 2% loan fees Calculate levered cash flows Calculate net sales proceeds after debt repayment What...
A 100 unit apartment building is for sale. It rents for 500/unit per month. Operating expenses...
A 100 unit apartment building is for sale. It rents for 500/unit per month. Operating expenses for the building are 200,000 per year and property taxes are 10,000 a year. Lisa wants to buy it and thus needs to arrange a mortgage loan of 3,000,000 at j4 = 10% amortized over 25 years with monthly payments. The banker assessed the lending value of the property to be 4,000,000. The banker requires a minimum DCR of 1.15, (a) Does Lisa qualify...
I wish to show that the average apartment rent in Atlanta is over $1200 per month....
I wish to show that the average apartment rent in Atlanta is over $1200 per month. I took a simple random sample of 81 and found the sample mean was $1250 with a standard deviation of $36. Let alpha=.01 Critical value = _____ 1) 1.28 2) 12.5 3) 1.65 4) 2.33
You are buying a mismanaged 64-unit apartment building for $3,000,000.  Rents are $800 per unit per month...
You are buying a mismanaged 64-unit apartment building for $3,000,000.  Rents are $800 per unit per month and expenses are $500 per unit per month, but the property is 10% vacant. You think you can turn the property around in three years by increasing rents $75 per year at each unit, keeping operating expenses constant.  Vacancy will decrease to 7.5% in year 2 and 5% in year 3.    The bank requires you put 25% down. Terms include a 25-year amortization at 4.0%.   You...
Part1) Bob's Apartment Building has 100 units that rent for $1,110 per month each. What is...
Part1) Bob's Apartment Building has 100 units that rent for $1,110 per month each. What is the Gross Potential Income for Bob's Apartment Building? Part2) Bob's Apartment Building has gross potential income of $1,000,000. The expected vacancy rate is 13%. Collection losses are 5% (after allowing for vacancies). Incidental income is $50,000 per year. What is the Effective Gross Income for Bob's Apartment Building? Part3) Bob's Apartment Building has effective gross income of $500,000. Operating expenses are 38% of revenue....
The business manager of a 90 unit apartment building is trying to determine the rent to...
The business manager of a 90 unit apartment building is trying to determine the rent to be charged. From past experience with similar buildings, when rent is set at $400, all the units are full. For every $20 increase in rent, one additional unit remains vacant. What rent should be charged for maximum total revenue? What is that maximum total revenue? To help solve the above scenario, perform an internet search for Profit Parabola or Applications of Quadratic Functions. List...
Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent...
Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent study of 180 randomly selected apartments found that the average rent was $915, with a standard deviation of $227.50. Do the data enable us to conclude that rents have increased? At the 98% degree of confidence, can it be concluded that the average rent has increased?
Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent...
Five years ago, the average apartment rent in southwest Virginia was $895 per month. A recent study of 180 randomly selected apartments found that the average rent was $915, with a standard deviation of $227.50. Do the data enable us to conclude that rents have increased? The computed test statistic
A real estate office handles a 60-unit apartment complex. When the rent is $530 per month,...
A real estate office handles a 60-unit apartment complex. When the rent is $530 per month, all units are occupied. For each $25 increase in rent, however, an average of one unit becomes vacant. Each occupied unit requires an average of $30 per month for service and repairs. What rent should be charged to obtain a maximum profit?
The business manager of a 90 unit apartment building is trying to determine the rent to be charged.
The business manager of a 90 unit apartment building is trying to determine the rent to be charged. From past experience with similar buildings, when rent is set at $400, all the units are full. For every $20 increase in rent, one additional unit remains vacant. What rent should be charged for maximum total revenue? What is that maximum total revenue? To help solve the above scenario, perform an internet search for Profit Parabola or Applications of Quadratic Functions. List...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT