Tuesday, November 20, 2012

Executive Summary

I am looking at a multifamily residential property to invest in. This investment offers potential to generate positive cash flows. The property is located in College Station, TX in an area known as the Northgate District. Closely located near Texas A&M University, the property offers a good opportunity to experience a quality lifestyle with various attractions around the area, the main one being Northgate. The property has strong showings of rental capacity, in a range of 95%, and is estimated to continue its strong capacity in part due to the planned renovations of the property and the ever growing population related to Texas A&M. In a thriving college town with tradition, friendliness, and great lifestyle amenities, this property is sure to please its tenants in an effort to maximize their time spent here in College Station.

Company Profile


My name is Max Freeman and my company, Freeman Real Estate (FRE), seeks to invest in residential properties in the College Station area. I am a finance major at Texas A&M and was born in Houston, Texas. Currently, my company is looking at a multifamily residential area that has an opportunity to provide positive cash flows.


Market Analysis


Demographics
The multifamily apartment being looked at is located close to the popular Northgate District in College Station, TX. College Station is a college town and the majority of the population living in College Station are ages 19-24.


It is also nearby the campus of Texas A&M University. This location has a primary target market of current college students attending either Texas A&M or Blinn College. Texas A&M has a total student population of around 49,000 and has seen a growth in population for the past few years.


Economics
The area of College Station contains multiple industries, but with the target market on this property, we tend to focus on the service industry. With the amount present in the city, our market should have plenty of opportunities to seek employment.

The property we are looking at currently has an occupancy rate of 100%, but I expect vacancy rates to range around 5%, or an occupancy rate of 95%. The main basis for that is the fact that college students’ lease periods are typically more short term than other tenants. Looking at comparable properties around the area, monthly rent for 2 bed/1 bath properties range from $350-$675 per bedroom, or $700-$1350 per unit. Based on these numbers, we plan on having a monthly unit rental rate of $750, or $375 per bedroom.

Pyschographic
The biggest lifestyle characteristic in this area is Northgate. Northgate is a nightlife area located just north of the campus of Texas A&M University. It is home to many clubs, bars, and restaurants that attract many people every day. Popular places include the Dixie Chicken and The Corner Bar and Grill. One other attraction is the planned development for Northgate Park, which is located about a block to the east of the property I am interested in investing in. This park will include trails, picnic benches, a jogging trail, and other fun options to choose from.


The link above shows the planned area that the park will be at. The property I plan on investing in is right across the street on the west side from the planned park. 



Property Description

The property consists of multiple buildings with a total of 24 units. The property was built in 1968, so it is a little dated, hence the need to put money in the property to renovate it. There is a total lot size of 35,407 square feet with 19,800 square feet of that being leasable.






Looking at the above views, you can see that it is in a favorable location in comparison to Texas A&M University and Northgate.






The above pictures are the actual buildings that make up the full property. The buildings have concrete slab foundations, the exterior is brick with outlays of wooden panels to give the buildings some diversity. Walkways are well placed around the facility and are made of concrete. There are plenty of parking spots by the buildings that are close and convenient. There are multiple entrances to the property from various streets around the neighborhood. The property also is centered close to major roads such as Wellborn Road and University Drive.




 Here is the floor plan that is in place in the units of the property. The plan starts with a spacious living room that leads into the kitchen equipped with a stove top, sink, dishwasher, and refrigerator. One renovation is to replace the current counter tops with all new granite counter tops that will give the units some added flare that will appeal to our target market. The bedrooms are cozy, have carpet, and contain a closet. The bathroom is connected to the bedrooms and has tile floors. My plan is to match the bathroom sink top granite with the kitchen top granite to give the units consistency. Overall this a nice layout that fits the needs of my target market for this property.

Financial Analysis


I plan to use debt financing to purchase this property. The property costs $1,350,000 and, as mentioned above, the occupancy rate will be estimated to be around 95% and the monthly rental rate will be $750 per unit.

Here are the terms on the loan:
Amortization Period: 25 years
Interest Rate: 4.15%
Loan-to-Value ratio: 70%
Loan Amount: $945,000
Holding Period: 10 years
Cap Rate: 5.22%

Assumptions:
Vacancy Loss: 5%
Rental Growth Rate: 1.25%
Operating Expense Growth Rate: 2%

The operating expense ratio is 45% of the first year's effective gross income and has a growth rate of 2%. The reason is that I plan on renovating the property to increase the value of the property by the end of the holding period.


The sales price of the property is $2,302,203. This is calculated by taking the 11th year's NOI ($120,175) divided by the cap rate (5.22%). However, since I plan on financing the property when purchasing it, I will have to take out the balloon payment from the sales price to get the sales revenue of $1,624,142. These two numbers will be explained more below.



The required rate of return on this property is 13%. Since I plan on financing this purchase using debt, the leveraged IRR is 23%, which is 10% higher than the return I require on this property. Notice that there is a NPV of $370,653.40 for the 10 year holding period, which confirms that this investment is a good one. Trying to purchase this investment with equity only turns out to be a bad investment that produces an IRR of 12% and a NPV of -$44,682.13. Both numbers don’t meet my expectations of a 13% return and a positive NPV value.