Question

In: Finance

You are considering the purchase of an apartment complex. The following assumptions are made: • The...

You are considering the purchase of an apartment complex. The following assumptions are made: • The purchase price is $1,150,000. • Potential gross income (PGI) for the first year of operations is projected to be $195,000. • PGI is expected to increase at 4 percent per year. • 3% vacancies are expected. • Operating expenses are estimated at 30 percent of effective gross income. Capital expenditures are estimated at 10 percent of effective gross income. • The market value of the investment is expected to increase 4.25 percent per year. • Selling expenses will be 3 percent. • The holding period is 4 years. • The appropriate unlevered rate of return to discount projected NOIs and the projected NSP is 14.5 percent. • The required levered rate of return is 15.5 percent. • 75 percent of the acquisition price can be borrowed with a 30-year, monthly payment mortgage. • The annual interest rate on the mortgage will be 7 percent. • Financing costs will equal 4.5 percent of the loan amount. • There are no prepayment penalties. a. Calculate net operating income (NOI) for each of the four years. Show all work. (2 pts) b. Calculate the net sale proceeds from the sale of the property. Show all work. (2 pts) c. Calculate the net present value of this investment, assuming no mortgage debt. Should you purchase? Why? Show all work. (4 pts) d. Calculate the internal rate of return of this investment, assuming no debt. Should you purchase? Why? Show all work. (1.5 pts) e. Calculate the monthly mortgage payment. What is the total per year? Show all work. (2 pts) f. Calculate the loan balance at the end of year 4. Show all work. (2 pts) g. Calculate the levered required initial equity investment. Show all work. (2 pts) h. Calculate the before-tax cash flow (BTCF) for each of the four years. Show all work. (2 pts) i. Calculate the before-tax equity reversion (BTER) from the sale of the property. Show all work. (2 pts) j. Calculate the levered net present value of this investment. Should you purchase? Why? Show all work. (4 pts) k. Calculate the levered internal rate of return of this investment (assuming no debt and no taxes). Should you purchase? Why? Show all work.

Solutions

Expert Solution

a. Calculate net operating income (NOI) for each of the four years.
1 2 3 4
Potential gross income (PGI) 4% increase each year after Ist Year. $195,000.00 $202,800.00 $210,912.00 $219,348.48
Less: Annual vacancy rate = 3% x PGI $5,850.00 $6,084.00 $6,327.36 $6,580.45
Effective gross income (EGI) $189,150.00 $196,716.00 $204,584.64 $212,768.03
Less: Annual operating expense = 30% x EGI $56,745.00 $59,014.80 $61,375.39 $63,830.41
Less: Capital expenditures (CAPX) = 10% x EGI $18,915.00 $19,671.60 $20,458.46 $21,276.80
Net operating Income (NOI) $113,490.00 $118,029.60 $122,750.78 $127,660.82
b. Calculate the net sale proceeds from the sale of the property.
Selling price = $1,150,000 x (1+ 4.25%)^4 $1,358,320.00
Less: Selling expenses (at 3% of SP) $40,749.60
Net sale proceeds $1,317,570.40
Net sale proceed will be added to year 4 NOI for calculating NPV.
c. Calculate the net present value of this investment, assuming no mortgage debt. Should you purchase? Why?
Year Cash Flow PV @ 14.5% Present Value
0 -$1,150,000.00 1 -$1,150,000.00
1 $113,490.00 0.873362445 $99,117.90
2 $118,029.60 0.762761961 $90,028.49
3 $122,750.78 0.666167652 $81,772.60
4 $1,445,231.21 0.581805809 $840,843.92
NPV -$38,237.09
No, The property should not be purchased because NPV is negative..
d. Calculate the internal rate of return of this investment, assuming no debt. Should you purchase? Why?
Year Cash Flow
0 -$1,150,000.00
1 $113,490.00
2 $118,029.60
3 $122,750.78
4 $1,445,231.21
IRR 13.40%
No, The property should not be purchased because IRR is less than unlevered required rate of return is 14.50 percent

Related Solutions

You are considering the purchase of an apartment complex. The following assumptions are made: •           The...
You are considering the purchase of an apartment complex. The following assumptions are made: •           The purchase price is $1,250,000. •           Potential gross income (PGI) for the first year of operations is projected to be $191,000. •           PGI is expected to increase at 4.5 percent per year. •           5% vacancies are expected. •           Operating expenses are estimated at 35 percent of effective gross income. Capital expenditures are estimated at 15 percent of effective gross income. •           The market value of...
As manager of Precision Properties, you are considering the purchase of an apartment complex. The following...
As manager of Precision Properties, you are considering the purchase of an apartment complex. The following assumptions are made: • The purchase price is $2,000,000. • Potential gross income (PGI) for the first year of operations is projected to be $320,000. • PGI is expected to increase at 4 percent per year. • No vacancies are expected. • Operating expenses are estimated at 38 percent of effective gross income. Ignore capital expenditures. • The market value of the investment is...
Assume you are buying an existing apartment complex and have made the following assumptions: Data Acquisition...
Assume you are buying an existing apartment complex and have made the following assumptions: Data Acquisition Cost $5,000,000 Project Length 5 Year 1 Rental Income $560,000 Rental Income Annual Growth 3% Year 1 Expenses $200,000 Expenses Annual Growth 2% Ordinary Tax Rate 28% Capital Gains Tax Rate 15% Annual Appreciation Rate of Property Market Value 3% 30-year Fixed Fully Amortizing Loan (monthly payments) Term in Years 30 Interest Rate (Annualized) 6% LTV 75% The proceeds of the loan are received...
You are considering a creative financing arrangement for the purchase of a small apartment complex. The...
You are considering a creative financing arrangement for the purchase of a small apartment complex. The property is selling for $2,600,000. Both lenders have agreed to allow the arrangement to proceed, if you decide to pursue it. The first mortgage will be for 65% LTV over 25 years with monthly payments at 9%. The first mortgage charges a 0.5% origination fee and no points. The second mortgage will be for 20% LTV over 10 years with monthly payments at 15%....
You are considering the purchase of an apartment complex. Purchase price: $775,000 BTCF: Year NOI 1...
You are considering the purchase of an apartment complex. Purchase price: $775,000 BTCF: Year NOI 1 $103,085 2 $108,361 3 $113,875 4 $119,636 5 $125,651 Holding period is four years Cap rate is expected to be 7% in year 4 Selling expenses will be 5% of the sale price The 4-year Treasury bill rate is 3% and your risk premium for this project is 8% a) Calculate the NPV of this project assuming that you do not take any mortgages...
You are considering the purchase of a 35,000-square-foot apartment complex located in the Inland Empire. The...
You are considering the purchase of a 35,000-square-foot apartment complex located in the Inland Empire. The building is about 50 years old. It has obviously depreciated, but it has been well-maintained with the owner spending approximately 7% of NOI each year in capital improvements. The building has 48 apartments. The owner has presented you with the following rental information: 10 studio apartments @ $1,200 each 30 1-bedroom apartments @ $1,450 each 8 2-bedroom apartments @ $1,650 each Your research shows...
Part 1 You are considering the purchase of a 120-unit apartment complex. The 50 one-bedroom units...
Part 1 You are considering the purchase of a 120-unit apartment complex. The 50 one-bedroom units rent for $650 per month and the remaining 70 two-bedroom units rent for $800 per month. Vacancy and credit losses are 10% in this market. There is miscellaneous income of $20,000 per year. Operating expenses for this property are 35% of gross operating income. Market cap rates for this type of investment are 7.75%. You can get a loan equal to 75% of the...
You are considering buying an apartment complex with 50 units. The units rent for $1000 per...
You are considering buying an apartment complex with 50 units. The units rent for $1000 per month each. Usually, there is a 10% vacancy. You want a 7.5% percent total annual after-tax return on the funds you invest. You do not expect any appreciation of the property value. You also expect the property to not have any economic or real depreciation in value, since the maintenance expenses will keep the property in equal condition year after year. When fully occupied,...
Suppose that you are considering the purchase of an apartment building for $2 million.A bank is...
Suppose that you are considering the purchase of an apartment building for $2 million.A bank is willing to loan you 85% of the purchase price with a 25 year loan with monthly payments and monthly compounding. If the bank charges you an annual interest rate of 10%. What will be your monthly payment for this loan. Show work a.10119 b.10373 c.13626 d. 14539 e.15444 Suppose that you are considering the purchase of a house for 300,000. A bank is willing...
Evaluate the purchase of an existing 500 unit apartment complex for $20000000, the building is assumed...
Evaluate the purchase of an existing 500 unit apartment complex for $20000000, the building is assumed to have a 20 year functional life. Treat the rents as being collected at the end of each year, along with associated variable and fixed costs. Assume rent controls will prohibit the rent from being raised over the life of the building. Assume that the underlying property reverts to the original owners at the end of twenty years, and that you will also be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT