Monday, April 23, 2012

Financial Analysis and Conclusion(5, end)


General financial information
-Selling Price $125 per sqft
-Leasable area : 220,000sq.ft
-Construction cost : $25,000,000(estimation from RSMEANS QUICK COST ESTIMATOR)
estimated construction cost of 1100 Trinity Mills
*The developer does construct buildings by itself. Thus, he could save construction cost as much as he can. 

-Land Price : around $3,000,000

-Units Price 
 
Unit
Sqft.
Price
1Bed, 1 Bath
700
$87,500
1Bed, 1 Bath, Den
1,000
$125,000
2Bed, 2 Bath
1,100
$137,500
2Bed, 2 Bath, Den
1,295
$161,875
2Bed, 2 Bath, Den        
1,300      
$165,000



Development Costs

+ Construction Costs (PSF)  $114.00  $100.00
x Total Square Feet  220,000  220,000
= Total Construction Cost  $25,080,000.00  $22,000,000.00
+ Land Acquisition Costs  $3,000,000.00  $300,000.00
= Total Development Costs  $28,080,000.00  $22,300,000.00
- Governmental Rebates for Energy/Sustainability  $-    $-  
= Revised Development Costs  $28,080,000.00  $22,300,000.00

* The total amount money that the developer can earn from this development is $125x220,000=$27,500,000. Thus, if the maximum cost per sf of the construction is $100,  and the vacant rate is under 19%,  this project is worth to do.


Conclusion

When I heard about this project at first time, I was easily sure that this project's feasibility is very high. It is because the location of this condo is fantastic. There is the Super H-mart right next to 1100 Trinity Mills. 4 years ago, before H-mart did not open yet, around the shopping mall, that has H-mart now, was half empty. But, now the shopping center is full of tenants. And, apartments around this shopping center is very popular for Asians. Thus, average occupancy rate is over 95%. That is why I could determine the condo's location is really good. 
According to my financial analysis, the project has a feasibility if the condos could be sold over 81%. Within 6 weeks after the development company(DIRA) started pre-sale, 88 units(61.54%) out of total 143 units have been sold. to sell condos. The developer have a plan to raise selling price. This project is about to start construction. It is supposed to start the end of April 2012. 
Does this development project have feasibility? My answer is absolutely "Yes". 






Market Analysis(4)


zip code 75007 area where 1100 Trinity Mills is included




This area has high population density. 4,238 per square mile live in Zip 75007. Salary($53,694) is over than state average.  And, also, household income in 2010 is $71,753. This is 45% more than average household income in Texas. And, vacancy rate is very low. The housing vacant rate in Carrollton was 3.45% in September 2010. In same period, the vacant rate in the US was 10.37%.  









The data from citydata.com




Summary
-zip 75007
-average home sale price is around $160,000
 :1100 Trinity Mills($135,375) has price competitiveness)
-% of renters is 29%(state 36%)
-4,238 people per square mile
-Estimated median house/condo value in 2010 is $213,984(Texas $127,400)
 : 1100 Trinity Mills provides good investment opportunity
-Median resident age is 34.6 years old
-Average household size is 2.4 people(Texas 2.8)
-Average Adjusted Gross Income(AGI) in 2004 is $56,481(Texas $47,881)
 : The condos targe is young professionals. The people who are living around this area are affordable to buy 1100 Trinity Mills
-Salary/wage is $53,694(State $41,947)
-Estimated median household income in 2010 is $71,753(Texas $49,585)
-Public primary/middle school in zip code 75007
 :Davis Elementary, Kent Elementary, Furneaux Elementary, Thompson Elementary, Rainwater Elementary, Rosemeade Elementary, Huie special Education Center. 
-Housing Vacant rate is 3.45%(US 10.37) in September 2011

Regulatory Analysis(3)


The site that the condo will be built is LR-2 zone. It means that the area is Local Retail Districts, non residential district. But, the city allows the condo could be built in this zone. And, they are doing process to change the zoning. Carrollton city emphasizes that this site will be high density TOD zone.  
site zone(LR-2)
The most attractive regulation for this condo is the Community Reinvestment Act(CRA). This area was appointed as CRA zone. CRA is a federal act that is designed to boost reinvestment on underdeveloped community. Under CRA, homebuyers can get a home mortgage loan with only 3% down payment. The interest rates is from 4.25% to 4.5%. Minimum credit score for this loan is 620. And, the Deb to income ratio is at least 48%. Government officer such as police, fireman, teacher can get home loan with 0% down payment. The Compass bank provides this loan under CRA. 


*CRA definition(from Wikipedia)
The Community Reinvestment Act (CRA, Pub.L. 95-128, title VIII of the Housing and Community Development Act of 1977, 91 Stat. 1147, 12 U.S.C. § 2901) is a United States federal law designed to encourage commercial banks and savings associations to help meet the needs of borrowers in all segments of their communities, including low- and moderate-income neighborhoods. Congress passed the Act in 1977 to reduce discriminatory credit practices against low-income neighborhoods, a practice known as redlining.
The Act instructs the appropriate federal financial supervisory agencies to encourage regulated financial institutions to help meet the credit needs of the local communities in which they are chartered, consistent with safe and sound operation (Section 802.) To enforce the statute, federal regulatory agencies examine banking institutions for CRA compliance, and take this information into consideration when approving applications for new bank branches or for mergers or acquisitions (Section 804.)

Summary
-LR-2 zone(Local Retail District), but the city allows to build condos
-CRA district. Home loan with 3% down payment with 4.25%~4.5% interest rates

Site Analysis(2)


The gross land area is a 4 acre. And, the condo is a 4 story building with 220,000sf, net leasable area. The number of total units is 143. There will be 291 total parking spaces(over 2 cars per unit). There are 6 types of units such as one bedroom(700sf), one bedroom(745sf), one bedroom(1,000sf), two bedroom(1,100sf), two bedroom(1,295sf), two bedroom(1,300sf). This condo will have a court yard, business center, lounge, fitness center, swimming pool.
property maps

The City of Carrollton was ranked 12 by the Forbes among the America's 25 best place to move in 2009. In the most vibrate area in the center of Carrollton city, the 1100 trinity mils is about to be built. 
This condo has big locational benefit. 
Location

Super H-mart next to 1100 Trinity Mills
The condo is right next to the H-mart that is the biggest asian mart in Texas. According to the former manager of this H-mart in Carrollton, the weekly revenue is over 1million. On weekend, the parking lot is full of cars. The capacity of this parking lot is over 1,000 cars. Around this H-mart, big asian town was formed which has restaurants, hospitals, dentals, CPA and lawyer offices, bar and Karaoke, book store. It means that this condo is the best place to live for asians. That is why the condo's developer is targeting the segment of asian residents. 
And, this condo is right next to 191 toll road. And, it is very convenient to access to 35E. Also, DART station, Trinity station, is within 2 miles. 
Raiford Project
 One more thing to consider for site analysis is the Raiford project. Carrolton city has plan to change the area around the condo to mixed use development site. This is the Raiford project. This area already have Wal-mart, Lowe's, Spa Castle(luxury spa and hotel, the biggest building in Carrolton). Hotel, residence, office, street shopping mall will be built according to this Raiford project. Carrolton city support this condo project on many aspects. 
Spa Castle(the biggest spa in Texas)
Summary
- 4 acre land, 4 story, 220,000sf(net leasable area), 143units, 291 parking space, 6types units.
-Carrolton city is 12 ranked best place to live
-Right next to the biggest asian mart in Texas and big asian town.
-near 191 toll road, 35E, DART station
-The Center of Raiford project

Saturday, April 21, 2012

SFFA Back Door Procedure


  ORDINARY BUILDING HIGHLY ENERGY EFFICIENT BUILDING
Total Square Feet 100,000 100,000
xExpected Gross Rental Rate PSF  $38.55  $33.23
=Potential Gross Income(PGI)  $3,855,000.00  $3,323,000.00
   Vacancy and Collectin Loos % of PGI 15% 10%
-Vacancy and Collection Loss% of PGI  $578,250.00  $332,300.00
=Effective Gross Income(EGI)  $3,276,750.00  $2,990,700.00
  Total Operating Expenses as % of EGI 35% 25%
-Total Operating Expenses  $1,146,862.50  $747,675.00
=Expeced Net Operating Income  $2,129,887.50  $2,243,025.00
/ Debt Service Coverage Ratio 1.4 1.25
=Annual Debt Service  $1,521,348.21  $1,794,420.00
  Before Tax Cash Flow(BTCF)  $608,539.29  $448,605.00
/ Annualized Mortgage Constant 0.107859393 0.101262819
=Debt(Loan Amount)  $14,104,921.04  $17,720,423.07
Maximum LTV Ratio 70% 80%
= Maximum Supportable Total Project Costs  $20,149,887.19  $22,150,528.83
+Governmental Rebates for Energy/Sustainability 0  $500,000.00
-Land Acquisition Costs  $150,000.00  $150,000.00
=Expected Construction Cost  $19,999,887.19  $22,500,528.83
Maximum Construction Cost(PSF)  $200.00  $225.01

Monday, April 16, 2012

Project for REAE 5314_(1)

The project name

1100 Trinity Mills










Types of development
- Condos (143units)


Location
















Summery




This is the condo project in Carrolton. This is the first condo project that is on undergoing in Korea town in Carrolton. The developer is also Korean. It is about to start construction on end of this month.
Carrolton city has very big development plan which is called as the Raiford Project around Korean Town. And, this condo project is one of these plan. I want to know this condo project really has feasibility because already many asians are interested in this condo project. If it is being proceeded successfully, Korean Town and Carrolton city could get many economic benefits.

Sunday, April 15, 2012

Adaptive Reuse Case Study Project



Background

Addresses
Buildings 2-3: 1001-1059 Foch Street.
Building 1: 821-945 Foch Street.

Building 1, 2, 3
Red: case study site, Blue: Montgomery Plaza, Yellow: Target and other big retail stores.

Area measurements
Building 1: approx 68,000 SF. (was 80,000 prior to redevelopment in 2003).
Approx 12 tenants including 1 Tex Mex restaurant, yoga studio, art supply
store, vintage clothing boutique, etc. 
Has approx 112 parking stalls on site.
Building 2: 80,000 SF (as of Jan 1 2011) Site shared between Buildings 2 and
3 had approx 42 striped stalls on it plus more unpaved parking area on the
building's east side (see site plan).
Building 3: 14,300 SF. 1 restaurant/bar tenant, 7 office tenants.

History
Building 1 purchased in 2001.
Buildings 2 + 3 purchased (same lot) in 2004.
Building 1 redeveloped from 2002-3
Building 3 redeveloped from 2004-5.
Building 2 was 100% leased to a metal fabricator through 12/31/2010.
Metal fabricator paid approx $2.50/SF gross for their 80,000 SF space.

Situation(Jan, 2011)
Building 1: approx 60% leased (many tenants had gone out of business in
recession), in place rents of approx $14.50/SF, NNN. All spaces had been
occupied at one time, so all spaces were second generation and thus only
would require approx $5/SF on average to retrofit for new tenants. Building
1 was almost entirely comprised of 4000 SF (27.5 ft x 145 ft) spaces that
couldn’t affordably be demised smaller (RRs already built in rear). 
- Building 3: fully leased, with average in place rents of approximately
$14.50/SF, NNN.
- Building 2: the big decision,  80,000 SF vacant warehouse building with
approximately 4500 SF of existing, old, office space at the southeast corner
of the building.  Cast in place concrete construction, dock high finished
floor.  Built 1948. Roof, built of cast in place concrete, was perfectly
flat and retained water after rains.

 Environment(Jan, 2011)
Surrounding district had boomed starting around 2007.  By 2010,
approximately 800 apartments and condos had been built within walking
distance of Foch Street Warehouses (FSW). Cypress Equities' W 7th Project
was built immediately west of Foch Street, had leased to approx 12
restaurants, a movie theater, a gym, and some clothing boutiques. The W 7th
project was generating a ton of visitor traffic to the neighborhood and the
initial 345 apartments in the project leased up immediately and had a
waiting list upon opening.  Retail rents in the project ranged from
$30-45/SF, NNN (NNN expenses $11/SF).  Office rents in the 100,000 SF office
component of the W7th project were getting $25-26/SF even in the deepest
parts of the recession without offering big incentives.

Land in the Cultural District/West 7th Corridor traded at a high water mark
of approx $42/SF in 2008 when Cypress bought the site for the W 7th mixed
use project, which was fully entitled, with some modest incentives from the
City of Fort Worth for the developer to build according to the City's mixed
use village plan.  Other sites in the district had traded for $30-35/SF
however none had sold since approx 2009.

Office vacancy was still tight, despite the recession at approx 12%, but
velocity was slow, and Class A rents were approx $22-25/SF plus electric,
down $1-2/SF from 2008 levels.  
Retail varied greatly from $12-45 depending on location in the district and
landlord's ability to fund TIs for credit tenants.

Multifamily rents in newer projects were approx $1.40-1.50/SF and rising,
even as new supply of apartments were added. 


Analysis

Zoning
Zoning around site

-This buildings are included in MU-2 (high intensity mixed use district). It means that if a developer developed as mixed use, city provides many benefits. So, building2 surly fit for mixed-use development.

-However, this area is not included in Historic area. Thus, it cannot get some tax benefit for historic district. A developer doesn't need to preserve this building for reuse.


 Demographic

This area is urban. So, renter's rate is higher over Texas average. And, density of population is high. Also, the resident's average salary is higher than State's average. It means that to use building2 as parking place or abandoned building is not good choice. It should be reused or redeveloped.



Summary 
- This is 100% urban area. The biggest part of age is 30's in this Area (Zip 76107)
- % of renter is 50%. It is higher than state average 36%
- 2,793 people per square mile
- White people live here more than half of all races
- Median hous/condo value (2010) is $197,845(Texas $127,400)
- Median resident age is 37.1 years
- Average Adjusted Gross Income (AGI, 2004) is $91,101(State average $47,881)
- Salary/Wage is $55,074(State average 41,947)


My suggestion

I'd like to suggest the flexible use development for Building2. This development can bring maximum profit with minimum costs. Flexible use means the space of building can be used as residential and retail, office, special use. It can boost rent rates and occupancy rates.
And, I suggest constructing new building to be an anchor of this district. This building's new construction can affect increasing rent rates and occupancy rates of other building1 and 3.

According to RSMeans QuickCost Estimator, approximately the total cost of new construction is around $8,384,000. I assume this is much like office having a diverse purpose. It can be used to other uses. Residential space is just like studio for young professionals. It can be easily to be converted to office by renter's uses.

I draw the draft image of this new building. Total rentable area is around 63,000sf according to my estimation.
The average rent rate per sf is $15(including office and residence, retail). Then, if occupancy rate is 80%, the annual revenue is $9,072,000. It is simply over than construction cost. It means that this development project is worth enough to do. 

My conceptual drawing for new building 2
   

Fort Worth Southside and Montgomery Plaza



Fort Worth South, Inc and Southside

 The redevelopment of historic district is very attractive and unique. The Fort Worth’s near Southside is one of the most attractive districts that have many opportunities of redevelopment and reuse. When I was hearing the lecture of the special guest on April 7 in the class, I was surprised because non-profit company is developing this area. The company is Fort Worth South, Inc(FWSI). This company began as a small coalition of Southside businesses and community leaders. 
Southside is very vivid street area, which was developed as the city's first streetcar suburb. Southside has an economic anchor, that is Medical District that has 5 major hospitals as well as dozens of independent medical clinics. But, until a few years ago, that was all this area had.
But, this district is transforming. Dozens of restoration and new construction projects is undergoing. The vibrancy is back because of redevelopment. FWSI put many efforts to vibrate this area. The walking road was brooded. Neat street was made which seem like safety street. Their development vision inspired me.

1. Vibrant, urban, mixed used district
2. Prioritize residential development
3. Support economic anchor
4. Promote locally-owned business
5. Encourage both small-sale & larger projects
6. Balance preservation & new construction
7. Improve perceptions

I thought one of the most important parts of their vision is the residential development. It is essential to make people live here for improving safety and vibrant business around Southside.



With FWSI's effort, Southside of Fort Worth is transforming form auto-oriented, low intensity, single use to pedestrian-oriented, higher intensity, mixed use, urban village.
Tax Increment Financing (TIF) is powerful helper for this development. This tax revenue can be used for infrastructure of this street. Without city's will and help, the street cannot change enough to attract many people.

route of street car in Fort Worth
Modern streetcar
The guest speaker had much time to explain the modern streetcar in Fort Worth. This project was stopped several years ago by city council’s decision.
FWSI thought the streetcar would promote economic development and high-density, mixed-use project while providing an alternate form of transportation.
Fort Worth city has proposed the modern streetcar as a possible solution to meet the demands and needs of a growing population and an expanding regional economy. The route of this streetcar extends to Southside of Fort Worth. The total cost of this project is 85million. But, FED approved25million grant to this Streetcar project.
If the project was approved, we might see a different Forth Worth downtown and Southside, which have more development opportunities.


The Live Oak Music Hall & Lounge

We have been to Southside of Fort Worth. This district was really attractive place that I want to visit later with my family. We met Bill Smith who is developing the Live Oak Music Hall & Lounge. This is located near Southside (1311 lipscomb St, Fort Worth, TX 76104). This building is still on remodeling. With only one sight, I knew I like this place.
This building was built in 1952. Now, the founder of the Live Oak Music Hall & Lounge, Bill Smith, is taking a 5,000 sf building that once house the Lion's Club and transforming it into a relaxing, intimate acoustic lounge and auditorium-style music hall. Bill said the customers who come here would experience varying styles of music from nearly every ere, performed by the hottest emerging artists to the most renowned, established touring acts.
Music Hall

This building has a rooftop patio which offers a beautiful view of the Fort Worth skyline. Maybe, customer will like this patio very much just like me.
Around this music bar, there are many residential places. Bill had many meeting to persuade residents to understand why the Oak music rouge should be established in this area. That is nice approach to make intimacy relationship with neighborhood.
Rooptop patio
Bill said we would surprise if we know Bill started this project with how small fund. The thing makes a developer beautiful is an idea not money.
Bill estimates startup investment cost is $1,182,236. And, the NPV of year 1 that Bill is anticipating is $1,104,500. And, projected profit for 3 years is $3,630,002. With this financial analysis, Bill and his investor could get $2,447,766 for 3 years. How good investment it is! I really hope this financial analysis become real and be correct.


Montgomery Plaza

After field trip on Southside, we visited Montgomery Plaza that is symbol of Fort Worth revival and reuse of historic building. The original Montgomery Ward store and catalog building was completed in 1928. The building was the largest building in Texas. Its twin-tower design allowed trains to enter between the two buildings to unload goods.
The Montgomery Ward Company ceased operations in 2001, and in 2004 the building was purchased in order to be converted into the Montgomery Plaza that has mixed used residential community. 
Floors three through eight were converted into 240 luxury condominiums. Outdoor rooftop amenities were created on the third floor including pools and spa, cabana, fire pits, lush landscaping and outdoor dining.
And on first floor, there are a diverse collection of shops, boutiques, restaurants and bars. And within walking distant, there are large grocery and shopping store like Target and Ross.
But, this project was not successful because many condos were not sold. Eventually, 144 condos were sold for $18 million in foreclosure auction.
I thought that this result is because of wrong market analysis. And, this kind of urban life style doesn’t fit to Texans. The Montgomery plaza is the very fascinated project but not profitable project.