Malden Field Study Report 2014

Page 1

dy in Real Estate, Planning & Urban Design

FIELD STUDY IN REAL ESTATE, PLANNING, & URBAN DESIGN UNIVERSITY HARVARDOF UNIVERSITY SCHOOL DESIGN GRADUATE SCHOOL OF DESIGN

Revitilization & Affordable&Housing the City Downtown Revitalization AffordableinHousing in of theMalden City of Malden

MALDEN


2


I. CONTEXT II. DEMOGRAPHICS III. MARKET ANALYSIS IV. PRECEDENTS V. PROPOSALS TREMONT PARK MALDEN MALL VI. ASIAN CDC PROPOSALS SUMMER STREET PLEASANT STREET

TABLE OF CONTENTS

SECTION FORWARD



FORWARD This report is the result of a semester- long field study at the Harvard Graduate School of Design on two related but distinctly different topics: visions for the future of downtown Malden, and affordable housing to be developed by the Asian Community Development Corporation. The Spring, 2014 class was inspired by Professor Ann Forsyth’s studio for first year planning students at GSD the previous year and the interest of the Asian Community Development Corporation to find a site in Malden for a new affordable housing project. The City of Malden also expressed interest in developing additional visions for the future of downtown Malden. The Asian CDC was looking for a housing site in the downtown vicinity, within walking distance of the Malden transit stop. Consequently, it made sense to combine the two exercises into the Spring Field Study class. The Malden Field Study was the focus of five students working in two teams for the class, GSD 5212: Field Studies in Real Estate, Planning and Urban Design. This course combines planning and urban design visions of the future with real estate market and financial

realities and implementation. The students are challenged to produce visions that are not academic but rather are achievable in the real world – visions that meet the constraints of the market place, local political and stakeholder concerns, and legal and financial realities. The visions of the two teams are presented together in this report, along with site information, demographic and real estate market data, precedent studies, and other common background material that is relevant for downtown Malden and the Asian CDC’s site selection. The two teams focus on different parts of downtown for their visions of future development. Alexander Akel, Alison Crowley, and Greg Demaiter focus on the superblock south of downtown across Centre Street that is currently occupied by the Stop and Shop. They envision a new mixed use development, Tremont Park, anchored by a new urban-style Stop and Shop with office and residential that links downtown to the industrial corridor to the south. Stephanie Torres and Weishun Xu focus on the downtown core and how to activate Exchange Street with new development that

they call Malden Mall. Both projects attempt to create vital urban streets and blocks with open space and strong visual appeal that cater to the Millennials and young professionals who are flocking to Malden. Both teams select sites for housing development by the Asian CDC across the tracks from downtown Malden. The sites are both within an easy walk of the MBTA station and are of a size that will accommodate 30-50 new housing units. Their design visions and financial analyses should contribute to the CDC’s plans for the area. I am grateful to Angie Liou at the Asian CDC and Kevin Duffy and Michelle Romero at the City of Malden for their support of the Field Study and time they so generously gave to the students. I believe the students have produced worthy visions for future development in downtown Malden that will enhance the environment and help to make downtown an even more vibrant place to live and work. Hopefully their visions will be useful to the citizens and leaders of Malden as they plan for the future. Richard Peiser Michael D. Spear Professor of Real Estate Development


DOWNTOWN MALDEN CIRCA 1940


CONTEXT

I


I. CONTEXT - OVERVIEW

I. CONTEXT History + Present Day Overview History The city of Malden in Boston’s northern suburbs borders Stoneham and Melrose to the north, Revere to the east, Everett to the south, and Medford to the west . Settled by Puritans in 1640 on land originally owned by the Pawtucket Indians, the city was named after the town of Maldon, England, by early landholder Joseph Hills. Malden was the site of a number of significant historical events, including the 1648 compilation of New England’s first printed code of enacted laws and the active resistance to the British colonial government through boycotts, protests, and petitions. Incorporated as a city in 1882, Malden continues to retain regional significance as an emerging lifestyle alternative to the increasingly expensive Somerville and Cambridge suburbs. The Malden Redevelopment Authority (MRA) from 1958 and 1972 through four federally funded and one state funded urban renewal project took over 400 properties within the City through eminent domain. Through the takings, the City was able to completely rebuild its industrial and commercial base as the backbone that exists today.

Present Day Today, the 5.1-square-mile city is closely tied into the Boston region through proximity to major highways, including Route 1, Route 16, Route 99, Route 128, and Interstate 93, as

well as with a stop on the MBTA Orange Line. The city is home to a mix of families living in the residential neighborhoods surrounding the downtown and to a number of singles and childless couples taking residence in the highrise apartment buildings built in proximity to the Malden Center T Station.

Amenities + Attractions Malden is home to thirty parks, including 56 acres of the Middlesex Fells Reservation, a state park that features the Fells Reservoir and Spot Pond. The city also shares a portion of the 107-acre Pine Banks Park with neighboring Melrose. Waitt’s Mountain, a summit located directly north of downtown, features sweeping views of the Boston skyline just a few miles south. Closer to downtown, Malden has become known for its burgeoning restaurant scene, located primarily along Pleasant Street and Exchange Street in the Central Business District. An article published in the April 30, 2014 issue of The Boston Herald highlighted the diverse dining options available to residents, including the critically acclaimed All Seasons Table, an establishment featuring pan-Asian cuisine.

Satellite Image of Malden Relative to Boston

Schools Malden has five public elementary schools, five public middle schools, and one public high school. The five elementary schools, Beebe, Ferryway, Forestdale, Linden, and Salemwood, were all built in the late 1990s to replace outdated facilities. Outside of public education, the city has one charter elementary, middle,

Malden City Boundaries

8


I. CONTEXT - EXISTING CONDITIONS

I. Traditional CBD The traditional CBD is bounded by Florence Street to the north, Centre Street to the south, Commercial Street to the west, and Main Street to the east. These blocks comprise the primary downtown retail offering in Malden, running east-west down Exchange and Pleasant Streets. The building stock is a diverse mix of two and three-story buildings,

The CBD is anchored on the western end by the Malden Center MBTA station and the existing City Hall, which is slated for demolition and redevelopment as a mixed-use project that will include re-connecting Pleasant Street’s retail corridor to Commercial Street. On the southern side of the traditional CBD between Exchange and Centre Streets, two large municipal parking lots create barriers between

II.

the CBD and areas south. New market-rate residential projects targeting childless singles are quickly filling in remaining pockets in the traditional CBD boundaries, which began with 160 Pleasant Street’s opening in 2006 and has continued with plans for 80 units at 39 Florence Street, 210 units at 18 Jackson Street, and 195 units at 33 Dartmouth Street to be delivered in full by 2016. Significantly, the traditional CBD offers little green, public space for residents and visitors. Existing gaps in the street fabric tend to be filled in with municipally owned surface parking lots rather than pocket parks, and none of the more recent private projects have offered or been required to provide public amenities as a requisite for development.

e Street

Florenc

I.

Pleasant Street

Main Street

Canal Street

III.

Centre Street

Middlesex Street

Exchange Street

reet

The city is loosely characterized by 18 separate and largely residential neighborhoods, of which one—Downtown—will be the focus of this report. For purposes of this report, we will dive

Existing Conditions

largely with retail on the ground floor and office above. Several traditional banks, built in neoRomanesque style with limestone façades, dot the streetscape. Due to an overabundance of general retail offerings, the CBD retail mix currently underperforms relative to its suburban counterparts.

ial S t

Neighborhoods

more deeply into the context of the CBD, which has within it four distinct nodes of activity: the traditional CBD, the T-Zone, the Centre Street Linkage, and the Industrial Zone.

Com merc

and high school, as well as one Catholic prekindergarten through middle school and one Catholic high school. A study conducted by the National Center for Education Statistics in 2013 found that Malden High School was the most diverse public high school in the state of Massachusetts. Though the public high school receives high marks on state assessments, Malden government authorities have stated concerns regarding school overcrowding.

Charles Street

IV. Malden and the Boston T (Orange Line)

Zones within Malden

9


I. CONTEXT - EXISTING CONDITIONS

II. T-Zone The Malden Center MBTA station on Commercial Street anchors the city’s CBD and naturally pushes residents from the station across Commercial Street to the activated streets in the traditional CBD. However, the land directly to the west of the station, technically situated behind the station as it fronts Commercial, represents an area of future growth opportunity. The triangle lot bounded by the station to the west, Pleasant Street to the north, and Centre Street to the south is home to a Malden fire station with a significant amount of surface parking. This site, directly adjacent to the 214-unit Gateway at Malden Center project, has been proposed for redevelopment as a hotel and could potentially feature a greater mix of uses. The MBTA, which owns underutilized land adjacent to the T in this area, has hired consultants to help determine the highest and best use for the parcel and have expressed interest in redevelopment.

III. Centre Street Linkage The two parcels bounded by Canal Street to the west, Centre Street to the north, Main Street to the east, and Charles Street to the south represent the most significant redevelopment opportunity within a quarter-mile of the T station. The 10-acre site, if developed to its highest and best use, could create a visual and program-oriented link between the traditional CBD to the north and the largely industrial zone to the south, extending the economic reaches of the CBD beyond its current boundaries. Further, the site abuts the proposed Malden Ballpark development, which will draw residents and visitors alike

from the more densely populated residential neighborhoods to the north and, hopefully, from areas outside of Malden altogether. Currently, this site, divided into two parcels by Middlesex Street running north-south between Centre Street and Charles Street, boasts a 70,000 square foot Stop & Shop supermarket, constructed in a suburban format with a sea of surface parking filling the majority of its 9-acre parcel. A small strip retail center facing Centre Street is situated on the northeastern corner of the Stop & Shop parcel, and an Applebee’s restaurant sits on a pad site at the corner of Charles Street and Middlesex Street. On the parcel to the east, bounded by Centre and Charles to the north and south and Middlesex and Main Street to the west and east, a large Walgreen’s dominates an otherwise forgettable retail strip.

New England Coffee

IV. Industrial Zone South of Centre Street and east of the Orange Line Tracks and Commercial Street is the city’s main industrial zone, which transitions from large footprint warehouses along the Malden River to smaller format, office-oriented onestory buildings fronting Charles Street. The area is generally low density with a number of vacancies. The main anchor employer for the area is New England Coffee. Another is Piantedosi Bakery on Commercial Street.

Piantedosi Baking

Industrial Zone (Present Day)

10


I. CONTEXT - EXISTING CONDITIONS

Malden City Hall

Massachusetts Dept. of Elementary & Secondary Education

Malden High School

Existing Conditions (Civic Use)

Jackson Street Parking Garage

CBD Parking Garage

11


I. CONTEXT - EXISTING CONDITIONS

View of Pleasant St. from City Hall

Ethnic Cuisine on Exchange Street

Restaurants and Bars in the CBD

Existing Conditions (Businesses & the Downtown)

New England Coffee Company

Stop N Shop Plaza

Walgreens

12


I. CONTEXT - RECENT DEVELOPMENTS

Recent Developments Residential Boom in the CBD

Building a Ballpark

Malden is evolving. As the cost of living continues to rise in Boston and its closestin suburbs of Cambridge and Somerville, more singles and families are choosing to move further away for the lifestyle they desire. Malden attracts young professionals and students seeking cheaper living close to Boston. Developers such as Raymond Properties, Corcoran Jennison and Combined Properties are leading the residential development wave in Malden. Class A apartment buildings in Malden’s downtown boast impressively low vacancy rates and another 816 new units are expected to come online in the next four years, reflected in the map of the CBD below.

One block away from this project, the City continues to pursue the development of a new 6,000-seat state of the art baseball field in partnership with the non-profit organization Baseball Field of Dreams. When realized, the Malden Ballpark will host a franchise team from the independent Atlantic League of Professional Baseball, as well as local school sports teams, regional events, and community celebrations.

Revitalizing 200 Pleasant Street In February 2014, the City of Malden sold City Hall, located at 200 Pleasant Street directly across the street from the Malden Center MBTA station, to the Jefferson Apartment Group for the purposes of building a new mixed-use project to anchor the gateway to Malden’s CBD. The proposed project, which includes 245 units of new housing and 17,250 square feet of new commercial space, will re-connect Pleasant Street to the T station and reflects the city’s priority of maximizing private investment downtown. As a result of this development, City Hall will be relocated to the pin on the map, the northern fringe of the CBD.

Lack of Open Space Malden compared to cities like Cambridge and Somerville lacks quality open space. Within the CBD, remaining spaces for public space are frequently used as municipal parking lots.

Existing Conditions (Downtown Malden)

13


I. CONTEXT - RECENT DEVELOPMENTS

Attracting New Businesses Beyond all of the new development activity, the city’s Economic Development office continues to focus on bringing high-quality dining and nightlife options to Pleasant and Exchange Streets, the two main commercial streets in the CBD. These efforts seek to update the aged retail mix that has until recently plagued the CBD, and has gained attention in local news outlets. An article from the Boston Herald highlights Malden’s growing restaurant scene which is being driven by the city’s influx of young individuals and its diverse population. Chefowner, Jason Ladd identified Malden as the “right place at the right time” as the city is “trying to position itself as Greater Boston’s premier up-and-round culinary destination”. Malden is taking notes from areas such as Davis Square. The city’s culinary diversity is exemplified by its Cuban, Ethiopian, MiddleEastern and Asian Cuisine.

Current City Hall: Serves as a Wall Between the T-Stop & the CBD

Addressing Vacancies In 2014, Bank of America vacated 80,000 square feet of Class A office space located at 200 Exchange Street, one of limited Class A options in the CBD. The building is over 300,000 square feet and has the highest assessed value in the city. The city of Malden continues to work closely with the landlord to identify a new long-term tenant who will fill the space with the hopes of keeping the existing building on site for at least twenty years.

Gateway to Malden: Project Rendering for 200 Pleasant Street

14


I. CONTEXT - RECENT DEVELOPMENTS

Malden Ballpark: View from Centre Street

Existing Conditions: Malden Ballpark Site

Malden Ballpark: New Amenity for the Central Business District

Malden Ballpark Rendering from the Southeast

15


DIVERSE CITY IN THE COMMONWEALTH


DEMOGRAPHICS

II


II. DEMOGRAPHICS - MALDEN

II. DEMOGRAPHICS Overall Trends Malden’s population, though increasing, has grown at a slower rate than the state and nation overall. Since 2009, the population has increased 0.51%, compared to Massachusetts’ overall population increase of 1.3% and the national average of 0.91%. The percentage of families has increased at an even slower rate—0.41%—and the number of ownership households has declined by 0.14% , indicating that much of the population growth in Malden is likely attributed toward childless couples and singles moving into the apartment complexes recently built in the city’s Central Business District (CBD). The city is trending toward a more diverse population, with a projected 13% increase in the city’s minority population between 2000-2014. One significant indicator of diversity is language spoken at home; as of 2010, approximately 42% of households in Malden did not speak English as a first language, and one in five residents was not fluent in English.

Population Relative to its neighbors, Malden is a mediumsized city that is larger than nearby Everett and Melrose and nearly the same size as Revere and Medford. Its population is dense at 17.3 people per acre, which is significantly higher than the state’s average (1.3 people per acre), as well as the density found in Revere, Medford, and Melrose. The median age of the city’s residents is 36, which is slightly younger than its MSA, measured at 38.5 years of age.

Ethnicities In 2014, approximately 60% of the city identified as Caucasian, 22% as Asian, 10% as Black, and the rest a mix of ethnicities. Since

2000, this represents a 15% decline in the Caucasian population and a 66% increase in the Asian population , indicating that the city is moving toward greater ethnic diversity and has likely benefited from positive immigration in the last decade. A significant portion of the city’s Asian population resides in the census tract that encompasses the Central Business District, while a higher proportion of Caucasian residents live in the southeastern corner of the city, on the boundary with Revere, MA . Relative to its neighbors, Malden has the largest non-white population, as well as the largest Black and Asian populations, of the close-in northern suburbs.

Income Between 2008-2012, the median annual household income was $54,229, which was slightly lower than Medford and Melrose but higher than Revere and Everett. Relative to the Boston MSA, Malden’s annual household income was $13,646 lower than the MSA median. The city has an overall 11.8% poverty rate and a childhood poverty rate of 16.9%. The unemployment rate in 2009 stood at 8.2%, although this number has likely trended down since the nadir of the recession.

of respective adult populations reaching the same level of education.

Housing Trends

HOUSING TENURE, 2008-2012

The American Community Survey estimates that more than half of Malden residents are renters, which coincides with the recent rental residential developments in the CBD and the continued trends toward rental tenure, evidenced by the pipeline of more than 800 new rental units in the next four years. Both the median monthly costs of ownership and the median gross rent for Malden are higher than the Massachusetts average due to the city’s proximity to Boston. Another significant trend in Malden’s residential patterns relates to when new residents move to the city. In the last four years, 12.4% of the current residents moved to the city; since 2000, an additional 56% of current residents moved into Malden. This population migration into Malden is likely indicative of rising costs in neighboring suburban communities and the city’s amenities, including access to the MBTA, new residential products, and a growing downtown commercial district.

Owners 43%

Renters

Renters 57%

Owners

Housing Tenure, 2008 - 2012

ETHNICITIES REPRESENTED, 2014 8% 22%

Education In an MSA that trends toward high educational attainment, Malden falls in the middle. Based on American Community Survey estimates, 18% of Malden’s population aged 25+ held a Bachelor’s degree, compared to 42% for the Boston MSA overall, and 38% average in the state. Though lower than the MSA, Malden’s educational attainment still ranks higher than Everett and Revere, with 16% and 17%

60%

10%

White

Black

Asian

Other

Ethnicities Represented in Malden, 2014

18


II. DEMOGRAPHICS - MALDEN

POPULATION BY SUBURB, 2012 70,000 60,374

MEDIAN HOUSING COSTS, RENTERS AND OWNERS, 2008-2012

57,033

60,000

53,179

50,000

Median Selected Monthly Owner Costs

42,567

Median Gross Rent

40,000 30,000

$2,145

Massachusetts

27,435

$1,056

20,000 $2,202

Malden

10,000 0

Malden

Everett

Medford

Melrose

Revere

Population Statistics by Suburb, 2012

$1,211 $0

$500

$1,000

$1,500

$2,000

$2,500

Median Housing Cost by Tenure, 2008-2012

MEDIAN HOUSEHOLD INCOME, 2008-2012 $100,000

$86,264

$90,000 $72,773

$80,000 $70,000 $60,000

$54,229

$50,000

$49,993

$49,702

$40,000 $30,000 $20,000 $10,000 $0

Malden

Everett

Medford

Melrose

Revere

Median Household Income, 2008-2012

Educational Attainment in Malden, 2008-2012

19



MARKET ANALYSIS

III


III. MARKET ANALYSIS - BOSTON METRO

III. MARKET ANALYSIS

Metro-Area Market Analysis

Boston Office The Creative Industry to Continue to Drive Growth Today, in the City of Boston, the burgeoning Seaport Innovation District is continuing to attract tenants as companies from the suburban markets and Cambridge engage in urban migration. Office rents in Boston have still not completely recovered to the 2007 level $55/ft/yr as they are still shy 15% (Figure 2). Expectations are that this gap will close in 2014. Financial services, insurance and legal operations have supported the downtown Boston market while the suburban office and Cambridge office and lab markets have experienced accelerated activity amongst small to mid-size firms as they drive the demand for creative spaces. Figure 3 displays the actual and projected greatest percentage change in employment growth by industry in the region with the professional, scientific and technical services leading the way at 36.5%. On a similar note, Figure 4 demonstrates

the year-over-year employment growth for the traditional and creative office sectors in Boston, Cambridge and Quincy. Traditional office has struggled to maintain the pace with growth roughly to 20-30 basis points above 0%. In the past three years, creative office employment grew an average of 5%.

and suburban sites. Figure 6 demonstrates a strong retail market in the Boston area. Completions of 6,000 (sf x 1,000) dwarfs the absorption of 1,450. With an availability rate of 8% expected to fall to 7%, and rent inflation forecasted north of 3%, the retail market is displaying strong fundamentals.

Boston Multifamily

60

Overheating?

50

Historic Boston Asking Rents vs. Availability 18.00% 16.00% 14.00%

40

Innovation is also driving the residential market as the increased employment levels 30 have resulted in a need for more housing units within Boston and its suburbs. Figure 20 5 shows the annual units completed, net 10 absorption, vacancy and rent inflation rates for the multifamily market in Boston. With 0 6,500 new units forecasted for 2014 and net absorption of 5,800, Boston will face an oversupply of housing units. This will cause a decrease in values as vacancy rates rise and rent inflation falls. Vacancy rates are predicted to rise to 3.7%, still a healthy number for a large market. In the future, it is predicted that 10% new supply will pull back, helping the market achieve equilibrium. 8%

Boston Retail Attractive Market Fundamentals Strong lease-up and development in the retail sector is predicted for 2014. Retailers, capitalizing on personal income growth, will continue to grow by seizing existing real estate or seeking development opportunities. Developers are focusing their efforts transitoriented mixed-use opportunities on urban

12.00% 10.00% 8.00% 6.00%

Asking Rent Availability

4.00% 2.00% 2006

2007

2008

2009

2010

2011

2012

2013

0.00%

Office Asking Rents & Availability in Boston (CBRE)

Boston Employment, Population and Personal Income Growth

6% 4%

Total Employment

2%

Personal Income

Population

0% 20 05 20 06 20 07 20 08 20 09 20 10 20 11 20 12 20 13 20 14 20 15 20 16 20 17 20 18 20 19

The economy of the Greater Boston area continued to improve over the course of 2013 as the region saw gains in employment, personal income and consumer confidence. Figure 1 displays the growth in employment, population and personal income over the years. Personal income growth sky-rocketed by 5.8% from 2013 to 2014 after a equal drop the year before. Personal income levels are expected to continue to grow at healthy levels at a falling pace over the next five years. Both population and employment growth are low yet positive and will continue to fall over the years.

-2% -4%

Boston Employment, Population & Personal Income Growth (CBRE)

22


III. MARKET ANALYSIS - BOSTON METRO

Boston Multifamily Market Data 12,000

7.00%

10,000

6.00%

Greatest % change between 2010 (actual) and 2020 (projected) in Employment Growth by Industry in the Boston Region

5.00%

8,000

4.00%

6,000

3.00%

4,000

2.00%

2,000

1.00%

Units Net Absorption Vacancy Rate Rent Inflation

0.00% 06 20 07 20 08 20 09 20 10 20 11 20 12 20 13 20 14 20 15 20 16 20 17 20 18

20

20

(2,000)

05

-

(4,000)

Professional, Scientific & Technical Services Finance & Insurance Social Assistance Health Care Administrative & Support Services Management of Companies & Enterprises Manufacturing

Unit Completions

-1.00% -2.00%

-3.00% Boston Multifamily Market Data (CBRE)

Boston Retail Market Data

8.00%

2000

7.00% 6.00%

12.00% 10.00%

1500

5.00% 4.00%

8.00% 6.00%

1000

3.00% 2.00%

4.00%

500 2004

2005

2006

2007

2008

2009

2010

2011

2012

0.00%

0 20

-2.00%

2013

2.00%

05 20 06 20 07 20 08 20 09 20 10 20 11 20 12 20 13 20 14 20 15 20 16 20 17 20 18

1.00% -1.00%

-500

-3.00% Creative Office

19.20% 15.25%

Boston Multifamily Market Data (Northeastern University Dukakis Institute)

Year-over-Year Employment Growth Boston-Cambridge-Quincy

0.00%

36.50% 28.90% 28.80% 25.00% 24.50%

Traditional Office

Creative v. Traditional Office Employment (CBRE)

-1000

-2.00%

Completions (sf x 1000) Net Absorption (sf x 1000) Availability Rate % Rent Inflation

-4.00% -6.00% -8.00%

Boston Retail Market Data (CBRE)

23


III. MARKET ANALYSIS - SUBMARKET

Sub-market Analysis

Malden falls within the Close-In Suburbs North sub-market, shown in Figure 7. This sub-market is dominated by Malden, Melrose and Revere. Beginning with the office market, the Close-In Suburbs North boasts a rentable area of 4.1 million square feet, vacancy and sublease rates of 11.8% and 2.4% respectively and quarterly net absorption of 16,500 square feet. Asking rents are currently $18.41. Figures 8 and 9 indicate the size of the sub-market and its performance relative to the Metro North, West and South in addition to the overall suburban office market. The Metro North market has underperformed relative to Metro West and South. CBRE rationalizes this phenomenon by pointing to the area’s lower-quality building stock and the region’s poor amenities. Metro West, which is the largest in size, commands the highest rents at $21/ft/yr. However, the Close-InSuburbs is outperforming its umbrella market with higher rents and a lower vacancy rate. This is most likely due to the sub-markets proximity and access to Boston.

Location Analysis Dearth of Class A Space Zooming in on Medford/Malden, the office, residential and retail markets conditions paint different pictures. Of the three, the office market has struggled the most over the years with the highest vacancies, lowest net absorption and oldest inventory. According to Dukakis Institute at Northeastern University,

a study was conducted on the office market in Malden. In Malden, 10% of its office stock is Class A, 40% Class B and 50% Class C. Data obtained from CoStar (Figure 10) shows current market data for Medford/Malden for each office type. Currently, Class B spaces are achieving the highest rents at $20.44/ ft/yr. However, year to date net absorption was -85,000 square feet, primarily due to a major loss of space vacated by Bank of America on 200 Exchange Street in Malden. The City of Malden is close to re-letting this space to a government tenant. Figures 11 and 12 indicate that Medford/Malden’s vacancy rates are hovering at 13% relative to 9.5% while its net absorption as a percentage of inventory is almost at 0%. Based on these findings, the office market in this region is not attractive from an investment or development play. Simultaneously, there is a clear demand for newer, higher quality office spaces in the region.

Multifamily: T-Stop Spurs Multifamily Boom Unlike the office market, the multifamily market in downtown Malden is booming. The downtown’s proximity to the MBTA stop on the Orange Line is seen as engine for the housing boom as Boston is only fifteen minutes. Malden has attracted the young, professional demographic consisting of students from local universities or those employed throughout the Greater Boston area. In the next few years, over eight hundred units are anticipated to hit the market. Figure 13 is a map highlighting the residential pipeline for downtown Malden. Conservations with local brokers in Malden point to an annual net absorption of 200 to

225 units. The supply in the pipeline should face no absorption challenges as Malden continues to experience its housing boom. Retail: Malden’s Next Growth Spurt Retail is typically broken down into four categories: general retail, mail, power center and shopping center. Downtown Malden is concentrated with general retail with rents of $19/ft/yr. With 10,500 square feet in the pipeline, like the office, the majority of the 2.1 million square feet of existing inventory is old stock. However, Medford/Malden’s retail occupancy rates are above 96.5%, much higher than the vacancy rate for the Boston area. Additionally rents are almost $3 higher in Medford/Malden compared to those achieved in the Greater Boston area. A net absorption of 20,000 square feet was posted for 2013. The Medford/Malden retail market appears to be healthy and the population influx and residential boom in downtown Malden will enhance the performance of this sector.

Sub-markets of Boston

Office Vacancy Medford/Malden vs. Boston 16.00% 14.00% 12.00% 10.00% 8.00%

Medford/Malden

6.00%

Greater Boston

4.00% 2.00% 0.00%

1Q09 2Q09 3Q09 4Q09 1Q10 2Q10 3Q10 4Q10 1Q11 2Q11 3Q11 4Q11 1Q12 2Q12 3Q12 4Q12 1Q13 2Q13 3Q13 4Q13

Metro North Trails the Pack

Office Vacancy Medford/Malden v. Boston (Co-Star)

24


III. MARKET ANALYSIS - SUBMARKET

Boston Suburban Office Net Absorption 800 600 400 North South

200

West 0

4Q11

1Q12

2Q12

3Q12

4Q12

1Q13

2Q13

3Q13

4Q13

-­‐200 Boston Suburban Office Net Absorption (CBRE)

-­‐400

Office Overview Medford/Malden

(As of End 2013)

Existing Inventory Vacancy Rate % Class A 1,252,721 14% Class B 1,272,277 17.20% Class C 823,391 4% Total Office Submarket 3,348,389 12.80%

YTD Net Absorption 47,994 -85,287 -19,455

YTD Completions 17,838 17,838

Pipeline Asking Rents $17.50 $20.44 $15.89 $18.33

Office Overview Malden (Co-Star) Office Net Absorption as % of Inventory

2.00% 1.00% 0.00% -1.00% -2.00%

Medford/Malden

-3.00%

Greater Boston

-4.00%

1Q 09 2Q 09 3Q 09 4Q 09 1Q 10 2Q 10 3Q 10 4Q 10 1Q 11 2Q 11 3Q 11 4Q 11 1Q 12 2Q 12 3Q 12 4Q 12 1Q 13 2Q 13 3Q 13 4Q 13

-5.00%

Office Net Absorption in Medford/Malden v. Boston (Co-Star)

25


III. MARKET ANALYSIS - SUBMARKET

Retail NNN Rent/SF/Yr Medford/Malden vs. Boston $25.00 $20.00 $15.00 Medford/Malden

$10.00

Greater Boston

4Q13

3Q13

2Q13

1Q13

4Q12

3Q12

2Q12

1Q12

4Q11

3Q11

2Q11

1Q11

4Q10

3Q10

2Q10

1Q10

4Q09

3Q09

2Q09

$0.00

1Q09

$5.00

Retail Rents Medford/Malden v. Boston (Co-Star)

Residential Units in Pipeline

General Retail Mall Power Center Shopping Center Total Retail Submarket

Existing Inventory 2,138,417 177,781 1,753,749 4,069,947

Vacancy Rate % YTD Net AbsorptionYTD Completions 2.90% 14,305 0% 3.60% 5,732 3.10% 20,037 -

Pipeline Asking Rents 10,554 $17.65 $22.23 10,554 $19.28

Retail Overview Medford/Malden (Co-Star)

97.50% 97.00% 96.50% 96.00% 95.50% 95.00% 94.50% 94.00% 93.50% 93.00% 92.50%

Medford/Malden Greater Boston

1Q09 2Q09 3Q09 4Q09 1Q10 2Q10 3Q10 4Q10 1Q11 2Q11 3Q11 4Q11 1Q12 2Q12 3Q12 4Q12 1Q13 2Q13 3Q13 4Q13

Retail Overview Medford/Malden

(As of End 2013)

Retail Occupancy Rate Medford/Malden vs. Boston

Retail Occupancy Medford/Malden v. Boston (Co-Star)

26


27


DOWNTOWN MALDEN POST URBAN RENEWAL (1970s)


PRECEDENTS

IV


IV. PRECEDENTS - DAVIS SQUARE

Davis Square Somerville, MA Quick Facts

Somerville population: 77,104 Distance from nearest major city: 4 miles Distance from furthest rail station: 0 miles Median household income: $64,603 Davis Square has been a center of commercial activity for Somerville, MA since its designation as a Square in 1883. However, the site fell into decline following World War II, when the persistent flight of residents to outer ring suburbs caused extensive decline in urban centers around the country. In 1980, a planning study completed on Davis Square asserted that the neighborhood suffered from a “lack of competitiveness among merchants, traffic congestion, inadequate parking, and an increasingly deteriorated physical environment.� Through the efforts of the Somerville Office of Planning and Community Development and the Davis Square Task Force in the late 1970s, the neighborhood successfully petitioned the MBTA to create a Red Line stop in the heart of Davis Square. The Task Force continued to play a role in the Square’s development, encouraging the City of Somerville to make the Red Line stop the cornerstone of downtown revitalization efforts. The six-point intersection immediately outside of the Square was reconfigured to prioritize pedestrian access, adding crosswalks, curb extensions, and refuge islands to enhance safety and efficient travel. The plaza outside of the stop that today hosts public art, festivals, and other community events was once a poorly defined railroad right-of-way containing surface

parking and debris; this too changed during the extensive planning efforts in the 1980s and into the 1990s. Today, Davis Square is a revitalized hub of commercial and residential activity, commanding some of the highest rents in Somerville and continuing to attract new businesses whenever space becomes available. Davis Square represents what Malden could do with the real estate directly adjacent to its own Orange Line stop by prioritizing pedestrian access across Commercial Street, opening a large public space for gathering at the gateway into the CBD, and activating the street frontage of each of the buildings along Commercial Street. Although Malden has begun this effort through the re-development of the City Hall site, the City still has much opportunity left to capitalize on the foot traffic and activity inherent to their MBTA stop.

30


IV. PRECEDENTS - BELMAR

Belmar Shopping District Lakewood, Colorado Quick Facts

Lakewood population: 145,516 Distance from nearest major city: 8 miles Distance from furthest rail station: 1 mile Median household income: $55,093 Belmar Shopping District Size: 3.5 million SF Lakewood, Colorado, a town of 150,000 just outside the Denver city limits was once home to the Villa Italia Mall, a 1.4 million square foot enclosed mall surrounded by surface parking on a 104-acre parcel of land. The mall, which opened in 1966, flourished until the early 1980s when it fell into disrepair, like many suburban communities experienced at the time. With the mall becoming an eyesore and inhibiting Lakewood’s development, local officials approached a small development company about purchasing the property and re-developing it into a mixed-use center. The developer, Continuum Partners, purchased the land in 1999 and the mall itself shortly thereafter. In the early 2000s, work began to subdivide the 104 acres into 22 city blocks. From there, Continuum planned a pedestrianfriendly downtown district comprised of 900,000 square feet of retail, 269,000 square

feet of office space, 1,300 new residential units, and extensive new public space.

and visitors to the closest light rail station, located one mile away, for free.

Continuum utilized a variety of tax incentives through the US Environmental Protection Agency to clean up the contaminated site and install a network of 8,370 solar panels atop the district’s three parking garages. The parking meters are also solar powered, and energy for the streetlights comes from wind turbines on top of the light poles.

The Belmar Shopping District represents a successful redevelopment of an outdated urban typology. The efforts by the City of Lakewood to engage a private developer and negotiate the sale of the Villa Italia Mall very much aligns with the plans for Tremont Park, discussed later in the proposal.

To date, the overall project cost $750 million to build and currently generates around $17 million annually in tax revenue for Lakewood. The retail spaces are 95 percent leased and the Class A office space is completely leased. The site also includes a theater complex, public park, and outdoor cafes, all of which see heavy foot traffic during the warmer months. The final 400 new residential units are currently under construction, and the developers have contracted with a local shuttle bus company to transport residents

31


IV. PRECEDENTS - FOOD INCUBATOR

Rutgers Food Innovation Center Bridgeton, New Jersey Quick Facts

Lakewood population: 25,290 Median household income: $31,044 Size: 25,000 SF The 23,000 square foot Rutgers Food Innovation Center (FIC) in Bridgeton, New Jersey, offers a variety of uses benefiting the area’s local food economy. The Center thrives as a business incubator and economic development accelerator program by providing business and technology expertise to both start-up and established farmers and food companies. The FIC concept combines the success of test kitchens, intended for entrepreneurial chefs hoping to launch a business, with space for commercial-level food processing, marketing and technology assistance for food entrepreneurs, food laboratories, consumer research and focus group meeting spaces, and a variety of training and education space for conferences and meetings. The largest portion of the Innovation Center is a USDA and FDA-approved shared-use processing area, in which a broad range of agricultural and food products, from fresh vegetables and fruits to soups, sauces, seasoning blends, and beverages can be manufactured either directly by a producer or on a contracted basis. Since the Center opened in 2000, more than 1,200 entrepreneurs and businesses have used the facilities to develop new products and manufacture goods at a level commensurate with local distribution needs. The current facility for the FIC opened in 2008, and by 2011 had already helped a

series of entrepreneurs launch 35 new food products. For those who come to the Center hoping to develop an entire strategy for a new business, the FIC runs Food Business Basics Workshops throughout the year that offer technical assistance to aspiring business owners. The Center is a program within Rutgers University’s New Jersey Agricultural Experiment Station, the research and outreach arm of Rutgers University whose mission is to provide wide-ranging educational programming, including agriculture, food, nutrition, and health, and workforce development, to all residents of New Jersey. With the resources available through Rutgers, the FIC has been able to partner with statewide programs like the New Jersey Farm-toSchool program to bring fresh foods produced at the FIC into school lunch programs around the state. Further, the FIC began to operate a national level in 2002 when it founded the Food Business Incubation Network (FoodBIN), an umbrella organization for similar incubators and centers that hosts annual conferences and provides networking opportunities for entrepreneurs at incubators across the country. Malden can learn much from the Food Innovation Center for the future of its Industrial Zone. With New England Coffee Company anchoring a food-based industrial economy, the City of Malden could incorporate into its zoning, branding, and development strategies for areas south of Charles Street plans for an entire Food Innovation Campus.

32


33


PROPOSAL II

PROPOSAL I

34


PROPOSALS

V 35


V. PROPOSAL I: Tremont Park Alexander Akel, Alison Crowley & Greg Demaiter

36


V. PROPOSAL I - TREMONT PARK - CONTEXT

Context The development activity in the blocks immediately surrounding the T station and running down Pleasant and Exchange Streets indicate Malden’s growing appeal to both new residents and private developers, but one area of the city’s downtown remains stalwartly suburban in its design and use. The two blocks immediately to the south of Exchange Street and to the east of the Malden Ballpark site, referred to in this report as the Centre Street Linkage, are woefully out of date with current trends in urban infill real estate development, particularly in transit-oriented communities such as this.

Malden, the Centre Street parcels represent the most heavily underutilized infill development opportunity in the city’s CBD. Although the Stop & Shop remains a necessity to Malden’s residents and commuters, we believe the site can be re-developed to maximize density, expand the CBD’s economic reach beyond Exchange Street, create much-needed new public space, and still provide a grocery store for which the residents value the site today.

Centre Street, the site’s northern boundary, serves as a major arterial through Malden to Interstate 93 to the west and Route 1 to the east. The four lane road has a narrow median in the center and few traffic lights, which encourages cars to speed and creates a significant barrier to the pedestrian-oriented CBD directly to the north for anyone hoping to reach the site on foot. The site’s current use is anchored by a 79,229 square foot suburban-format Super Stop & Shop grocery store that has been in the community since 1992 (Parcel A). Other developments include an Applebee’s pad site and a small strip retail center with multiple vacancies and H&R Block, RadioShack, and Bank of America as tenants. On the adjacent block (Parcel B), bounded by Middlesex and Main to the west and east, a large Walgreens anchors another retail strip that features multiple takeout establishments and a nail salon. Overall, with a site so close to the Malden Center MBTA station, next to the proposed Malden Ballpark, across the street from the city’s main restaurant and retail district, and in close proximity to the 800 new units of housing coming to

Existing Conditions Top Left: Stop & Shop (Parcel A) Top Right: Vacant Restaurant Outparcel Site (Parcel A) Bottom Left: Outparcel Site with Radioshack & H&R Block (Parcel A) Bottom Right: Walgreens and Jay’s Restaurant (Parcel B)

37


38


V. PROPOSAL I - TREMONT PARK - VISION

Vision Tremont Park capitalizes on the positive developments underway in Malden and creates an entirely new hub of activity featuring residential, office, commercial, entertainment, and recreational uses within a compact, pedestrian-oriented site. Specifically, the master plan calls for the following: 76,210 square foot new urban-oriented Stop & Shop grocery store 510 new mixed-income rental residential units 223,581 square feet of new Class A office space 44,340 square feet of restaurant-oriented retail 19,020 square feet of artist-oriented retail, 10,000 square foot gym An eight-screen, 37,000 square foot movie theater 950 total parking spaces, and Four acre public park and plaza with a central lake around which community events can be organized. The project, named Tremont Park, reflects the site’s historic street grid structure, which featured a Tremont Avenue running through the heart of what today is the surface parking lot serving the Stop & Shop grocery. Our vision for Tremont Park is four-fold:

1) Create a new public space for Malden, a city whose downtown currently lacks any single large assembly point for outdoor activities; 2) Generate economic activity through providing new Class A office space to attract the technology and research-oriented industries that populate the Boston metro area; 3) Bolster the amenities offered to the city’s burgeoning young professional population to ensure long-term economic success and residential retention; and 4) Most importantly, stitch together the economic engines of the CBD to the north and the industrial zone to the south, creating a transition between the two that remains sensitive to both uses while standing independently on its own. With the uses planned for the site, Tremont Park will become a destination in its own right. By creating new physical and program-oriented connections between the CBD and industrial zone, Tremont Park will lessen the disruptive impact of heavy east-west traffic on Centre Street that simply serves to carry people through Malden to somewhere else, and instead better articulate a north-south link drawing disparate parts of the city closer together. The project also proposes a new infrastructural component, a road connecting Canal Street and Middlesex Street that will cut through the center of the project to create a more traditional street grid, emphasizing walkability and pedestrians over the cars and commuters on Centre Street.

projects fronting Centre Street to tie into the young professional-oriented development occurring along Exchange and Pleasant Streets. On the southern half of the site, facing Charles Street and adjacent to the New England Coffee Company office campus, which serves as the introduction to the city’s industrial zone, the project transitions to residential with artist-oriented retail spaces. These retail spaces are intended for use as workshops, galleries, artist-owned businesses, and potentially community group and non-profit office space to better match the building stock and uses to the south of Tremont Park. Malden has expressed a strong desire to generate arts-oriented business and programming for the city, financing artists live/work studio projects and emphasizing the arts in much of their city branding. Our project acknowledges the city’s goals and seeks to include those in a natural transition from the CBD into the industrial.

Phasing Tremont Park will be built in four phases over the span of 10 years. The phases are as follows:

Phase 1:

Building A: New Stop & Shop grocery store with 6,100 sf of inline retail in the eastern parcel bounded by Centre, Main, Charles, and Middlesex Streets. Parking Component: 549 spaces on two-level structured rooftop parking to serve grocery store customers and future Building E office workers.

Phase 2:

Buildings B, C, + D: 242 market-rate and 60 affordable apartment units with 18,000 sf of food and beverage-oriented retail and a 37,000 sf theater with 10,000 sf gym. Parking Component: 243 spaces built into the first floor ground levels of Buildings B and C to serve residents in both buildings, as well as retail users. Infrastructure Component: Four-acre park with lake and new street with on-street parking spaces to be built connecting Canal and Middlesex Streets.

Phase 3:

Buildings E, F, + G: 167 market-rate and 41 affordable apartment units with 2,160 sf of food and beverage-oriented retail and 19,020 sf of artists-oriented retail, 2,000 sf of food and beverage retail, as well as one 102,660 sf Class A office building. Parking Component: 158 spaces built into a partially-submerged platform beneath Buildings F and G, eight feet below grade and four feet above grade. Parking will serve residents in Buildings F and G as well as office workers in the future Building H. Infrastructure Component: A private courtyard serving residents in Buildings F and G to be built above parking platform.

Phase 4:

Building H: A second 120,921 sf Class A office building with 7,257 sf of inline retail, primarily food and beverage.

The site’s programming features grocery, entertainment, office, and mixed-use residential

39


V. PROPOSAL I - TREMONT PARK - PHASING

Phasing, continued Phase 1 will require the most significant amount of negotiation. The success of Tremont Park hinges on our ability to deliver a new grocery store to replace the existing Stop & Shop that would be demolished. This requires negotiating a sale with the owner of the Stop & Shop parcel, as discussed in our Development Strategy below, and assembling the five individually owned parcels inclusive of the new Phase 1 site. These owners include three trusts, one individual, and one limited partnership. With the city’s support, the project intends to reach an acquisition agreement after two years of negotiation to assemble the property and purchase outright. Project scheduling begins at Year 0, when the developer completes negotiations and obtains site control. At that point, construction can commence on the new build-to-suit Stop & Shop, which will open after a one year construction period. Stabilization for this phase is expected by Year 2. Following Phase 1, the project’s assemblage becomes substantially more straightforward, as the developer will have already reached an agreement with the owner of the Stop & Shop site and must only acquire the last remaining parcel, a subdivided piece of land at the corner of Centre Street and Middlesex Streets where the three-tenant retail strip center currently sits. These acquisition negotiations will take place throughout the entire Phase 1 process, and construction on Phase 2 will commence in Year 3. Phases 2 through 4 each project a two year construction period due to the complex nature of each site. Starting with Phase 2, once construction is completed, Phase 3 will begin construction with this trend repeating

for Phase 4. The project is phased such that no more than 200 residential units come to market at any given time, reflecting an absorption rate of 100 units per year. This absorption rate was reached by considering the current and proposed pipeline of residential projects underway in the CBD, and acknowledging the continued demand for reasonably priced studio, 1, and 2-bedroom units in the Boston metro area. The two office components, introduced in Phases 2 and 4, will be separated by ten years between lease up, offering more than enough time to fill one building without allowing another to sit vacant. Our confidence that there will be a market for Class A office in Malden in fifteen years, when Phase 4 comes to market, is due to the emerging creative office industry and emphasis on health and human sciences in the Boston region. With areas like Kendall Square, the Seaport Innovation District, Assembly Square, and the suburban office parks in Lexington and Concord filling quickly and experiencing rapidly increasing rents, we believe that future office growth will be pushed further from the Boston city center, but remain closely tied to the public transportation system. Malden, then, is well situated to capture the next wave of office development focused on the region’s strengths in biotech, health sciences, and research and technology. From the acquisition of the new grocery store parcel to the sale of the buildings in Phase 3, the project is projected to span seventeen years.

Development Strategy

Retail Strategy

The success of the project is contingent on the developer’s ability to convince Ahold, the Dutch owner of the Stop & Shop brand and the nine acre site in Malden, to sell their interest in the site. The Stop & Shop on Centre Street grosses annual revenues of over $60 million and is one of the strongest performing stores in Ahold’s portfolio. According to Malden’s GIS, the site was purchased by Ahold in 2006 for $21.6 million. The developer will take on the risks to aggregate the five parcels for the new grocery store at $12.5 million. The new 76,000 square foot store will be built to suit for Stop & Shop. Upon the completion of construction, the store and 274 structured parking spaces will be sold to Ahold at a discount to replacement cost or $27 million. By offering Stop & Shop an attractive bid price of $22 million and $3 million for the outparcel on the site, taking on the development risk to acquire the new site and providing a new, updated space that is built-tosuit at a discount to replacement cost, Ahold will receive a completely new store at almost no additional cost or loss of revenue within a growing market. The developer will strata-title sell the grocery store and retain ownership of the 6,000 food and beverage retail and the upper level of parking or 275 spaces. Once the grocery store is built, the old site will be free.

Malden’s Central Business District is primarily composed of restaurants (25%) and healthcare and personal stores (23%) such as salons and spas. The City’s current restaurant boom must not be ignored and the plethora of healthcare and personal stores is not appropriate for the vibrant downtown Malden seeks to establish. Tremont Park will continue to focus on restaurants while also emphasizing bars and lounges and specialty food shops. Both a fitness center and a theater will be incorporated in the development.

Phases 1, 2 and 3 will be sold ten years after completion while phase 4, only five years after. Phase 1 has a long holding period as the parking garage will not reach stabilized occupancy until the office in Phase 2 is completed. Phases 2 and 3 must be held for five years given the affordable housing component. The office and retail, however could be strata-titled off at an earlier stage. Phase 4 will have the shortest holding period of only five years to enhance the investments internal rate of return.

“Fast Casual” and traditional dining options on a local and national scale were identified as the opportunities Malden desires. Local fast casual dinning options such as Cambridge and Somerville favorites: Anna’s Taqueria and Dave’s Fresh Pasta would be attractive to the young transient population in the City. National fast casual chains such as Chipotle, Nando’s Peri Peri and Sweetgreen would also fill this void. Malden has already achieved recognition for its traditional ethnic restaurants. Tremont Park will continue this trend by sourcing both local and national tenants such as Vapiano’s (Italian) or Cambridge’s Orinoco (Venezuelan) and Kaju Soft Tofu (Asian). Tremont Park will also fill another void: the nightlife and entertainment scene. For the theater, iPic and Alamo Drafthouse Cinema are potential tenants. The ideal tenant will embody an affordable yet luxury and private movie viewing experience, the new trend within the industry. Finally cafes such as Peet’s Coffee & Tea and Caribou Coffee would serve the residents, office employees and visitors to Tremont Park.

40


V. PROPOSAL I - TREMONT PARK - PHASING

Phasing PhasingTimeline Phasing Phase I Acquisition Construction Stabilization

Year 0

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20

Phase II Acquisition Construction Lease-Up Stabilization Sale Phase III Construction Lease-Up Stabilization Sale Phase IV Construction Lease-Up Stabilization

1 A

4

3

B

A

B

A

B

1

2

3

4

Negotiate with existing grocery store to move to newly constructed store proposed on Pod B

Aggregate the parcels in Pod B for $12.5 million

Construct the new grocery store

Strata-title Sale of the Grocery Store and 274 Parking Spaces for $27 million and Purchase Pod A for $25 million

41


V. PROPOSAL I - TREMONT PARK - DESIGN

Water-Scape

Water-Scape

Soft-Scape

Soft-Scape

Pedestrian Connections

Hard-Scape

Hard-Scape Pedestrian Connections

Major Intersections

Pedestrian Connections Major Intersections

Major Future Intersections

Major Intersections

Major Future Intersections

Major Arterial

Major Arterial

Service Road

Grocery Store Circulation

Major Future Intersections

Service Road

Grocery Store Circulation

42


V. PROPOSAL I - TREMONT PARK - DESIGN

Residential

Office

Food & Beverage

Theatre

Grocery

Other Retail

Municipal Parking Garage

Residential

Food & Beverage

Theatre

Office

Grocery

Food & Beverage

Other Retail

Theatre

Grocery

Structured Parking

Street Parking

PHASE I

PHASE II

PHASE III

PHASE IV

Other Retail

Municipal Parking Garage

Structured Parking

Street Parking

PHASE I

PHASE II

PHASE III

PHASE IV

43


V. PROPOSAL I - TREMONT PARK - DESIGN

Aerial View Looking East

44


V. PROPOSAL I - TREMONT PARK - DESIGN

Aerial View Looking Northwest

45


V. PROPOSAL I - TREMONT PARK - DESIGN

Design Tremont Park is designed to fit into the vernacular of Malden’s architecture with a modern edge. The six story building height reflects the new development occurring within the CBD and will be a natural transition from the older buildings on Pleasant and Exchange Streets to the newer projects south of Centre Street. The site is designed to maximize pedestrian access by creating new north-south links between the traditional CBD and Tremont Park. The main entrance to the Park will be in front of the proposed theater, where a wide plaza will draw pedestrians toward the food and beverage options and into the public space, which anchors the project. Other links created include the cut-outs of Buildings B and C, which provide sight-lines through the project, and the continuation of the proposed Ballpark plaza to the western side of Tremont Park. The cut-outs also serve to break up the block between Canal Street and Middlesex Street. The pedestrian access created adjacent to the theater turns into a street with sidewalk on the southern half of the site, but wide right of ways for pedestrians will ensure that their experience remains a priority. Tremont Park is oriented with retail and public space activity primarily clustered on the eastern half of the site due to fact that the back side of the Ballpark will front Canal Street. The Ballpark wall, while certainly not activating Canal Street, could be enlivened via murals or greenery, but as a result of that edge, the decision was made to focus pedestrian gathering spaces on the opposite side of the project. However, an outdoor covered podium on the western end of the park will provide space for live music or groups to perform, creating

Precedent images capture the intended look and feel of the public spaces within Tremont Park.

46


V. PROPOSAL I - TREMONT PARK - DESIGN

enough activation to ensure that the entire length of the park is well utilized. We also expect visitors coming from the Malden Center T station to enter the park from the western corner next to Building B, which will draw them immediately toward the lake and into the heart of the project. Parking for the site will be placed primarily in partially-sunken garages rising four feet above grade. The only exception to this will be the new Stop & Shop on the Middlesex Street parcel, which will feature two stories of parking on the roof. This concept was designed for an urban Safeway grocery store in Hyattsville, MD, and reflects a broader trend in reducing or eliminating surface parking for large format stores. The residential parking spaces are designed at a ratio of 0.75 spaces per unit, the office parking is designed at a ratio of 4 spaces per every 1,000 square feet of development, and the retail parking is expected to occur on the allotted on-street spaces and in the municipal garages fronting Centre Street. Materials for the buildings are, in schematic, a mix of glass and paneling. Although the palette of the residential buildings reflects the brick tones of the Pleasant and Exchange Street building typologies, the materials are distinctively modern in an effort to brand Tremont Park as a unique destination within Malden. The theater and office building adjacent are connected by an enclosed atrium, allowing passage between the entertainment use and the retail use on the ground floor of the office. The grocery store will be designed to Stop & Shop’s standards, which will likely incorporate some form of masonry. Pavers on site will be pervious and earth-toned in an effort to keep the space light, especially on the southern

portion of the park, which will be cast in shadow during portions of the day due to Building C’s massing. The residential buildings F and G south of the new Sherman Street both include private, enclosed courtyards for use by the residents. This layout maximizes the quality of the views for all of the units in the building, providing future residents with views of the Boston skyline on the southern side, Building C and the park on the northern side, and the courtyards for the interior units. The decision not to differentiate the heights of the four residential projects was made to maximize density and ensure the highest level of activation throughout the day.

Hyattsville , Maryland: Urban Grocery Store

Ultimately, Tremont Park is designed with the casual user in mind, drawing visitors to the park via tables, benches, and outdoor café spaces following a movie or day at work. With the 24-hour nature of the site’s uses, the hope is that Tremont Park will be busy all day and all year as a new center for activity to complement the traditional CBD and the new Malden Ballpark.

Building typology mix will emphasize Malden’s industrial past with a trend toward more modern materials and facades.

47


48


49


V. PROPOSAL I - TREMONT PARK - PROGRAM

PROGRAM SUMMARY PHASE 1 Apartment - Market 0sf Apartment - Market (Units) 0 units Apartment - Affordable 0sf Apartment - Affordable (Units) 0 units Retail - Grocery 76,210sf Retail - F&B 6,100sf Retail - Theater 0sf Retail - Other 0sf Office 0sf TOTAL 82,310sf FAR 0.93 Parking 549 spaces Parks + Hardscape 0.0 acres Construction Period Hold Period PROJECT RETURNS Internal Rates of Return Primary Use Unlevered SF BY BUILDING Unlevered + Subsidy APT - MARKET Levered APT - AFFORDABLE Levered + Subsidy RETAIL - GROCERY General Partner RETAIL - F&B Limited Partner RETAIL - THEATER GP + Sponsor RETAIL - OTHER Return on Total Assets

OFFICE BUILDING SF PARK/GREEN SPACE ROAD/INFRA OVERALL SHARE PHASE PHASE 1 PHASE 2 PHASE 3 PHASE 4

1 Years 10 Years PHASE 1

PHASE 2 242,520sf 242 units 60,630sf 60 units 0sf 28,823sf 37,090sf 0sf 0sf 369,063sf 1.24 243 spaces 4.0 acres 2 Years 10 Years PHASE 2

PHASE 3 PHASE 4 167,736sf 0sf 167 units 0 units 41,934sf 0sf 41 units 0 units 0sf 0sf 2,160sf 7,257sf 0sf 0sf 19,020sf 0sf 102,660sf 120,921sf 333,510sf 128,178sf 3.22 4.48 158 spaces 0 spaces 0.5 acres 0.0 acres 2 Years 10 Years PHASE 3

2 Years 5 Years PHASE 4

Grocery Apartment Apartment Theater 5.4% 7.8% 9.7% 12.9% A B C D 5.4% 9.1% 10.9% 12.9% 0 124,000 118,520 0 5.2% 10.7% 16.6% 27.5% 0 31,000 29,630 0 5.2% 21.1% 22.8% 27.5% 76,210 0 0 0 6,100 3,510 10,915 14,398 0 0 0 37,090 0 0 0 0 6.0% 7.2% 8.6% 0 0 0 0 82,310 158,510 159,065 51,488 0 0 0 123,685 0 0 0 48,400 9% 1 100% 0% 0% 0%

17% 2 0% 43% 0% 0%

17% 2 0% 43% 0% 0%

Tremont Park

TOTAL 410,256sf 409 units 102,564sf 101 units 76,210sf 44,340sf 37,090sf 19,020sf 223,581sf 913,061sf 1.76 950 spaces 4.5 acres

6% 2 0% 14% 0% 0%

TOTAL Office Apartment Apartment Office 9.0% E F G H TOTAL 10.2% 0 91,516 76,220 0 410,256 14.0% 0 22,879 19,055 0 102,564 18.21% 0 0 0 0 76,210 17.21% 2,160 0 0 7,257 44,340 17.21% 0 0 0 0 37,090 23.75%0 11,285 7,735 0 19,020 102,660 0 0 120,921 223,581 104,820 125,680 103,010 128,178 913,061 0 0 22,875 0 146,560 0 0 0 0 48,400 11% 3 0% 0% 31% 0%

14% 3 0% 0% 38% 0%

11% 3 0% 0% 31% 0%

Tremont(Park

% 45% 11% 8% 5% 4% 2% 24% 100%

14% 4 0% 0% 0% 100%

50


V. PROPOSAL I - TREMONT PARK - DEVELOPMENT STRATEGY

Financial Analysis Key Assumptions

Development Cost Assumptions

The proposal calls for the development of market and affordable rental housing, a grocery store, food and beverage retail, an eight screen movie theatre, artists work spaces and office spaces. The key assumptions are broken down into five categories: operating, lease-up, development, finance and sale, and partnership structure.

With a total build-out of over 900,000 square feet on twelve acres, the first consideration is land cost. The Center Street parcel is a little over nine acres in size and is compromise of two sites while the future grocery store site is over approximately three acres spread over four separately owned sites. A land value of $25 million and $12.5 million was determined for both sites based on recent sales of those sites. Second, the hard construction costs for the market and affordable rental units were underwritten at $250/sf and $220/sf. The difference takes into account changes in the fit-outs within the units. Retail hard construction costs for the grocery store, restaurants, theater were lower at $150/sf with the artists spaces $20/sf less. Since the project possesses a large open space component, construction costs of $50/sf were entered for this category. The proposed road cutting through the site will cost $20/sf. The design calls for three types of parking thus three dissimilar construction cost estimates. The structured parking utilized above the grocery store and all of the residential building except F and G will cost $14,000/space. Parking in buildings F and G, through the use of a subterranean podium structure, is anticipated to amount to $20,000/space in comparison to $1,000/ space for the street parking around the development. Third, soft costs such as pre-development, administrative, design services, hard and soft contingencies and developer fees were considered. Pre-development costs of $500,000 for each phase to cover permitting, engineering services and impact fees of each phase were taken into account. Administrative fees of $750,000 for each phase are necessary for legal and account services rendered.

Operating Assumptions Beginning with the apartment units, market rate and affordable rents were penciled in at $3.25/sf/month and $1.17/sf/month. The model also utilizes an efficiency factor of 90% and an annual operating expense of $7,000 per unit. The average unit size is 900 square feet. The anticipated market rate rents are higher than the current rates as the development does not hit the market until five years after the grocery store parcel is acquired. The restaurants, theatre and artists retail spaces will have rents of $35/sf/year, $30/sf/ year and $20/sf/year and the leases will be structured as triple-net. The office will also be a triple-net lease with rents at $33/sf/year. Parking revenue will come from the residential units at $200/space/month and $150/ space/month from the office. Since the 275 parking spaces above the garage will serve the office tenants in building E, these spaces will be leased out at $75/space/month until the office is completed. Commercial and residential real estate taxes of 3.2% and 1.2% were inputed. An annual inflation rate of 3% to construction costs, rents and operating expenses was determined.

Design costs and hard cost contingencies were penciled in at 5.0% of total hard costs. Finally, a developer fee of 2.5% is needed to cover the cost of the developer’s overhead and day-today operations.

of the performance of the work spaces and the weakness of the office market, those spaces are anticipated to be 50% leased in the first year.

Finance & Sale Assumptions

Given the size and magnitude of the development opportunity, the developer will utilize outside equity. Of the required equity contribution for each phase, the developer will contribute 10% as a pari passu in the deal. For each phase, a new sponsor entity will be created to oversee the development. Broken into a four tiered waterfall structure, in the first tier, the GP and LP(s) are to be provided with an annual preferred return of 15% and the return of their capital contribution. In the second tier, the GP and LP(s) will share 80% of the cash flows on a pro-rata basis with the remaining 20% to the Sponsor until the investors achieve a 16% internal rate of return. Similar to tier three, the investors will share, also on a pro-rata basis, 70% of the cash flows with the remaining 30% to the Sponsor until the investors obtain a return of 17.50%. Lastly, in tier four, the Sponsor receives a promote as any remaining cash flows are split 60/40 to the investors and the Sponsor.

The construction of each phase will be financed through a construction loan at a 5.50% interest rate. The LTC for each construction loan will be 70%. The thirty-year, 6% interest rate permanent loan, also known as a take-out loan, will be annually amortized. A debt service ratio of 1.20 is a applied in order to calculate the value of the take-out loan at which the NOI supports the debt service. No loan origination fee or points were applied. Regarding the sale of the properties, exit cap rates for each product type were determined. The exit cap rate for market rate and affordable apartments is 6%and 6.5% while the food and beverage, theatre and artists retail spaces are at 6%, 6% and 6.25% respectively. The office exit cap rate is 6.25% as well. The cost of sale is 2% of the sale price to account for legal fees.

Lease-Up Assumptions Based on the conducted market analysis, each use has its own lease-up schedule. Beginning with the residential units, the first year average occupancy for both the market rate and affordable units is 60%. Next, the theatre will be completely occupied in the first year as it will be pre-leased or built-to-suit. Since Malden is already a booming restaurant scene, it is believed the food and beverage spaces will be leased quickly, with over 60% in the first year. On the other hand, given the uncertainty

Partnership Structure

Sources & Uses Tremont Park will be financed through five different sources: investor equity, construction debt, low income housing tax credits, environmental grants from the Community Preservation Act and tax increment bond financing. Regarding LIHTC, the developer will apply for 9% tax credit or 70% subsidy. Tax credits will be

51


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS

Financial Analysis, continued sold at $0.90 for each dollar of credit. A 2.5% investor ownership interest in the property by the purchasers of the tax credits is required. The developer and its consultants recommend that the City of Malden consider utilizing TIF to pay for infrastructure improvements within the central business district (zone I), the baseball field and center street sites (zone II), and the industrial zone (zone IV). TIF is a public financing method that utilizes the future gains in taxes to subsidize current improvements which are utilized to create the conditions for the future gains. Under a TIF, the City would issue bonds and provide developers with the proceeds from their sale. Future development would lead to an increase in tax revenue, or a tax increment which the City would then used to repay the interest and principal of the outstanding bonds. TIFs provide many short-term and long-term benefits such as development incentives that require no tax increases, the creation of jobs and a stronger and broader tax base, attraction of private investment and growth of property values. Lastly, Community Preservation Act financing, a state of Massachusetts program, will be sought after for open space improvements. In Phase 1, the development of the grocery store and parking will be financed 30% by investor equity and 70% construction debt. In Phase 2, the construction debt will also cover 70% of the total costs with 12% and 11% funded by LIHTC and investor equity. The TIF will cover 6% of the total costs, such as open space and roads and infrastructure. CPA financing will cover 1% of the cost for this phase. For Phase 3, 70% of the costs will be financed by a construction loan, 10% from LIHTC and the remaining 20% from investor equity while Phase 4 will be financed com-

pletely by a construction loan and equity from the partnership. The total development will cost approximately $326 million. Phase 1, 2, 3 and 4 will cost approximately $38 million, $139 million, $110 million and $38 million respectively. Figure X displays the sources and uses for Tremont Park.

Return Analysis Unlevered, subsidized unlevered, levered and subsidized levered internal rates of returns in addition to return on total assets were calculated for each phase (Figure x). With no subsidies, Phase 1 has the lowest unlevered and levered returns at 5.4% and 5.2%, indicating negative leverage. The low returns are driven by the fact that the grocery store is sold at a discount to replacement cost. The IRRs are still greater than 0% since the retained parking and food and beverage retail is expected to perform well. In Phase 2, unlevered and levered returns are 7.8% and 9.2% and with LIHTC, TIF and CPA, the returns are bumped up to 10.7% and 21.7%. The return on total assets (ROTA) is 6%. In Phase 3, the returns are also driven by the subsidies as the unlevered and levered IRRs are 9.7% and 16.6% and rise to 10.9% and 22.8% with the introduction of LIHTC. The ROTA is 7.2%. Lastly, Phase 4, which is primarily office, is not subsidized, providing unlevered and levered returns of 12.9% and 27.5% with a ROTA of 8.3%. For the entire project, the unlevered and levered IRRs are 9.0% and 14.0% while the subsidized unlevered and levered returns are 10.2% and 18.40%.

Sensitivity Analysis A sensitivity analysis was conducted with three scenarios: a pessimistic, base and an optimistic one. In the pessimistic scenario, rent is decreased by 5%, construction increased by 5%, interest rates rise 1%, LIHTC subsidy falls by 5% while the cap rate is 1% higher. The growth rate falls from 3% to 1%. The unlevered and levered returns fall to 4.53% and 0.81% while the investor return is 7.15%. The optimistic scenario assumes the exact opposite (rents increase, construction costs decrease, etc). As a result, unlevered and levered returns rise to 13.71% and 26.27% while the investors receive 26.28%.

Waterfall Analysis A waterfall was developed to determine the returns to the general partner and limited partners of Tremont Park. The project will create $326 million in total cash flow. The GP and LP(s) are expected to receive levered returns of 17.21% The sponsor will receive approximately $36 million over the timeframe of the development. The levered IRR to the GP and Sponsor is 23.31%.

Sensitivity Analysis

Pessimistic

Rent Change

PROGRAM SUMMARY PHASE 1 Construction Cost Change Apartment - Market 0sf Interest Rate Change Apartment - Market (Units) 0 units Subsidy -Change Apartment Affordable 0sf Cap Rate- Affordable Change(Units) Apartment 0 units Retail - Grocery 76,210sf Growth Rate Retail - F&B 6,100sf Retail Theater 0sf Internal Rates of Return Retail - Other 0sf Unlevered Office 0sf Unlevered + Subsidy 82,310sf TOTAL Levered FAR 0.93 Levered + Subsidy 549 spaces Parking Parks + Hardscape 0.0 acres General Partner

Limited Partner

Construction Period GP + Sponsor Hold Period

PROJECT RETURNS Internal Rates of Return Unlevered Unlevered + Subsidy Levered Levered + Subsidy General Partner Limited Partner GP + Sponsor Return on Total Assets

1 Years 10 Years PHASE 1 5.4% 5.4% 5.2% 5.2%

-5%

PHASE 2 5% 242,520sf 242 1% units -5% 60,630sf 60 1% units 0sf 1% 28,823sf 37,090sf 0sf 4.53% 0sf 5.75% 369,063sf 0.81% 1.24 2435.47% spaces 4.0 acres 7.15%

7.15% 2 Years 7.15%

10 Years

PHASE 2

Base

Optimistic

0%

PHASE 3 PHASE 4 0% 167,736sf 0sf 167 units 0% 0 units 41,934sf 0% 0sf 41 units 0% 0 units 0sf 3% 0sf 2,160sf 7,257sf 0sf 0sf 19,020sf 0sf 8.97% 102,660sf 120,921sf 10.20% 333,510sf 128,178sf 14.00% 3.22 4.48 18.21%0 spaces 158 spaces 0.5 acres 17.21%0.0 acres

17.21%

5%

TOTAL -5% 410,256sf 409-1% units 5% 102,564sf 101-1% units 76,210sf 5% 44,340sf 37,090sf 19,020sf 13.71% 223,581sf 14.96% 913,061sf 26.27% 1.76 30.18% 950 spaces 4.5 acres 26.28%

26.28%

2 Years 23.75% 2 Years 45.14% 10 Years 5 Years PHASE 3

PHASE 4

7.8% 9.1% 10.7% 21.1%

9.7% 10.9% 16.6% 22.8%

12.9% 12.9% 27.5% 27.5%

6.0%

7.2%

8.6%

TOTAL 9.0% 10.2% 14.0% 18.21% 17.21% 17.21% 23.75%

52


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS

Key KeyAssumptions Assumptions KEY ASSUMPTIONS Current rent/price Efficiency factor Occupancy Other income Parking revenue Parking occupancy OPEX (excluding taxes) Exit cap rate First year avg occupancy

CONSTRUCTION COSTS Apartment - Market Apartment - Affordable Retail - Grocery Retail - F&B Retail - Theater Retail - Other Office Parking - Structured Parking - Podium Parking - Surface Park/green space Roads/infrastructure OTHER COSTS Design Hard contingency Soft contingency Developer fee Environmental

YES NO

Tremont Park APT - MARKET APT - AFFORDABLE $3.25/sf $1.17/sf 90% 90% 95% 100% 0% 0% $200/month $0/month 95% 95% $7,000/unit $7,000/unit 6.00% 6.50% 60% 60%

$250/sf $220/sf $150/sf $150/sf $150/sf $130/sf $215/sf $14,000/space $20,000/space $1,000/space $50/sf $20/sf

5.0% of hard costs 5.0% of hard costs 5.0% of soft costs 2.5% of all costs $0/acre

RETAIL - GROCERY $15/sf NNN 85% 100% 0% $0/day 0% 0% 6.00% 100%

FINANCE Interest rates TIF Construction Permanent DSCR Amortization (yrs) Loan fee

RETAIL - F&B RETAIL - THEATER $35/sf NNN $30/sf NNN 85% 85% 90% 100% 0% 0% $0/day $0/day 0% 0% 0% 0% 6.00% 6.00% 60% 100%

4.00% 5.50% 6.00% 1.20 30 0.00%

Tax credits LIHTC/SHTC applicable % LIHTC/SHTC credit pricing Investor ownership

9% $0.90 2.5%

OTHER Inflation Commercial tax Residential tax Cost of sale

3.0% 3.2% 1.3% 2.0%

RETAIL - OTHER $20/sf NNN 90% 90% 0% $0/day 0% 0% 6.25% 50%

PARKING RATIOS Sf per space - Structure Parking Sf per space - Structured Podium Sf per space - Surface Parking GROCERY STORE PARKING Monthly Parking Revenue Occupancy

OFFICE $33 85% 90% 0% $150/month 95% 0% 6.25% 50%

300 300 250

$75/space 50%

PARTNERSHIP GP LP Annual Preferred Return

10% 90% 15%

Tier II GP/LP Sponsor Until Investor

80% 20% 16%

Tier III GP/LP Sponsor Until Investor

70% 30% 17.50%

Tier IV GP/LP Sponsor

60% 40%

53


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS

Project Absorption Project Absorption ABSORPTION

Tre

TOTAL

Apartment - Market Units Delivered Units Absorbed Cumulative Absorption

409 389

Apartment - Affordable Units Delivered Units Absorbed Cumulative Absorption

101 101

Retail - Grocery Space Delivered Space Absorbed Cumulative Absorption

76,210 76,210

Retail - F&B Space Delivered Space Absorbed Cumulative Absorption

44,340 39,906

Year 1

Year 2

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

Year 10

Year 11

Year 12

Year 13

Year 14

Year 15

Year 16

Year 17

Year 18

Year 19

Year 20

242 145 145.2

85 230

167 100 330

58 389

389

389

389

389

389

389

389

389

389

389

389

389

60 36 36

24 60

41 25 84.6

16 101

101

101

101

101

101

101

101

101

101

101

101

101

76,210 76,210 76,210

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

76,210

-

6,100 3,660 3,660

1,830 5,490

5,490

28,823 17,294 22,784

8,647 31,431

2,160 1,296 32,727

648 33,375

7,257 4,354 37,729

2,177 39,906

39,906

39,906

39,906

39,906

39,906

39,906

39,906

39,906

39,906

39,906

37,090

-

-

-

-

37,090 37,090 37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

37,090

Retail - Other Space Delivered Space Absorbed Cumulative Absorption

19,020 17,118

-

-

-

-

-

-

19,020 9,510 9,510

7,608 17,118

17,118

17,118

17,118

17,118

17,118

17,118

17,118

17,118

17,118

17,118

17,118

17,118

Office Space Delivered Space Absorbed Cumulative Absorption

223,581 201,223

-

-

-

-

-

-

102,660 51,330 51,330

41,064 92,394

120,921 60,461 152,855

48,368 201,223

201,223

201,223

201,223

201,223

201,223

201,223

201,223

201,223

201,223

201,223

Retail - Theater Space Delivered Space Absorbed Cumulative Absorption

-

Year 3

-

-

54


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS

Sources + Uses SOURCES Construction Debt LIHTC TIF Environmental Credits Partnership TOTAL TOTAL SUBSIDY

PHASE 1 26,610,440 0 0 0 11,404,474 38,014,915 0

% 70% 0% 0% 0% 30% 100% 0%

PHASE 2 97,273,226 16,363,817 8,757,333 0 16,567,376 138,961,752 25,121,150

% 70% 12% 6% 0% 12% 100% 18%

PHASE 3 76,917,718 10,658,393 22,306,343 109,882,454 10,658,393

% 70% 10% 0% 0% 20% 100% 10%

PHASE 4 27,136,929 11,630,112 38,767,042 0

Tremont  TOTAL %Park 227,938,313 70% 27,022,210 8% 8,757,333 3% 0 0% 61,908,306 19% 325,626,162 100% 35,779,543 11%

% 70% 0% 0% 0% 30% 100% 0%

10%

11%

11%

19% 0% 3%

Construction Debt

Land + Environmental

LIHTC

Buildings

3% 4% Parking

TIF

8%

Parks + Hardscape Environmental Credits Soft Cost + Contingency Partnership

70%

USES Land + Environmental Buildings Parking Parks + Hardscape Soft Cost + Contingency Finance TOTAL

PHASE 1 12,500,000 12,346,500 7,686,000 0 4,004,689 1,477,725 38,014,915

% 33% 32% 20% 0% 11% 4% 100%

Finance

PHASE 2 17,333,593 83,855,550 2,637,000 7,152,250 13,776,952 14,206,406 138,961,752

% 12% 60% 2% 5% 10% 10% 100%

PHASE 3 6,005,184 76,027,980 3,160,000 1,143,750 12,009,601 11,535,939 109,882,454

61%

% 5% 69% 3% 1% 11% 10% 100%

PHASE 4 1,661,222 27,086,565 5,722,302 4,296,952 38,767,042

% 4% 70% 0% 0% 15% 11% 100%

TOTAL 37,500,000 199,316,595 13,483,000 8,296,000 35,513,545 31,517,022 325,626,162

% 12% 61% 4% 3% 11% 10% 100%

55


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS Phase PHASEI:I -Proforma PROFORMA PRO-FORMA - PH1 Land Environmental Hard costs Soft costs TOTAL DEVELOPMENT

Tremont Park TOTAL (12,500,000) 0 (21,665,149) (3,077,013) (37,242,161)

OPERATIONS Gross Potential Rent Vacancy Parking Other Income EFFECTIVE GROSS INCOME

TOTAL 2,207,104 (278,468) 3,767,546 0 5,696,182

Operating Expenses Real Estate Taxes EXPENSES NET OPERATING INCOME SALE PROCEEDS

Acquisition Year 0 (12,500,000) 0 0 (538,125) (13,038,125)

Year 0

Construction Stabilization Year 1 Year 2 0 0 0 0 (21,665,149) 0 (2,538,888) 0 (24,204,036) 0

Year 1

Year 2 192,527 (77,011) 131,286 0 246,802

Hold Year 3

Hold Year 4 0 0 0 0 0

Year 3 198,303 (19,830) 135,225 0 313,697

Hold Year 5 0 0 0 0 0

Year 4 204,252 (20,425) 139,282 0 323,108

Hold Year 6 0 0 0 0 0

Year 5 210,379 (21,038) 143,460 0 332,802

Hold Year 7 0 0 0 0 0

Year 6 216,691 (21,669) 147,764 0 342,786

Hold Year 8 0 0 0 0 0

Year 7 223,191 (22,319) 578,348 0 779,220

Hold Year 9 0 0 0 0 0

Year 8 229,887 (22,989) 595,699 0 802,597

0 0 0 0 0

Year 9 236,784 (23,678) 613,570 0 826,675

Hold Year 10 0 0 0 0 0

Hold Year 11 0 0 0 0 0

Sale Year 12

Year 10 243,887 (24,389) 631,977 0 851,475

Year 11 251,204 (25,120) 650,936 0 877,019

Year 12

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

5,696,182

0

0

246,802

313,697

323,108

332,802

342,786

779,220

802,597

826,675

851,475

877,019

0

41,558,515

0

0

27,242,161

0

0

0

0

0

0

0

0

0

14,316,354

PROJECT-LEVEL RETURN UNLEVERAGED

IRR 5.38%

TOTAL 10,012,536

Year 0 (13,038,125)

Year 1 Year 2 (24,204,036) 27,488,964

Year 3 313,697

Year 4 323,108

Year 5 332,802

Year 6 342,786

Year 7 779,220

Year 8 802,597

Year 9 826,675

Year 10 851,475

Year 11 877,019

Year 12 14,316,354

PROJECT-LEVEL RETURN UNLEVERAGED/SUBSIDIZED

IRR 5.38%

TOTAL 10,012,536

Year 0 (13,038,125)

Year 1 Year 2 (24,204,036) 27,488,964

Year 3 313,697

Year 4 323,108

Year 5 332,802

Year 6 342,786

Year 7 779,220

Year 8 802,597

Year 9 826,675

Year 10 851,475

Year 11 877,019

Year 12 14,316,354

TOTAL (1,441,691) 0 (36,042) (1,477,733) (38,719,894)

Year 0 (53,336) 0 (1,333) (54,670) (13,092,795)

Year 1 (720,842) 0 (18,021) (738,863) (24,942,899)

Year 2 (667,505) 0 (16,688) (684,193) (684,193)

Year 3

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

Year 10 0 0 0 0 0

Year 11 0 0 0 0 0

Year 12

Year 2

Year 3

Year 12

CONSTRUCTION FINANCING Construction interest Finance Developer fee Total financing cost TOTAL DEVELOPMENT - LEVERAGED

PERMANENT LOAN Draws Interest Repayments

TOTAL 2,830,995 (1,584,696) (2,830,995)

CASH FLOW AFTER DEBT SERVICE

Year 0 0 0 0

Year 1 2,830,995 0 0

18,566,080

0

0

EQUITY PARTNERSHIP

TOTAL 11,615,966

Year 0 11,615,966

LIHTC Contributions Distributions TIF STATE/FED ENVIRONMENTAL TOTAL EQUITY CONTRIBUTIONS

0 0 0 0 11,615,966

CASH FLOW TO PARTNERSHIP

18,566,080

Year 1

0 (169,860) (35,809) 3,010,370

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Year 4

Year 5

Year 6

Year 7

0 (165,434) (40,235)

0 (163,020) (42,649)

0 (160,461) (45,208)

0 (157,748) (47,921)

0 (154,873) (50,796)

0 (151,825) (53,844)

Year 10 0 (148,595) (57,074)

Year 11 0 (145,170) (60,499)

0 0 (2,359,004)

108,029

117,440

127,133

137,117

573,552

596,928

621,006

645,806

671,351

11,957,349

Year 12

0

0

0

0

0

0

0

0

Year 10 0

Year 11 0

0 0 0 0 11,615,966

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0

0

3,010,370

108,029

117,440

127,133

137,117

573,552

596,928

621,006

645,806

671,351

11,957,349

0

Year 2 3,010,370

Year 3 108,029

Year 4 117,440

Year 5 127,133

Year 6 137,117

Year 7 573,552

Year 8 596,928

Year 9 621,006

Year 10 645,806

Year 11 671,351

Year 12 11,957,349

0

Year 2 3,010,370

Year 3 108,029

Year 4 117,440

Year 5 127,133

Year 6 137,117

Year 7 573,552

Year 8 596,928

Year 9 621,006

Year 10 645,806

Year 11 671,351

Year 12 11,957,349

IRR 5.17%

TOTAL 6,950,114

Year 0 (11,615,966)

Year 1

PROJECT-LEVEL LEVERAGED/SUBSIDIZED

IRR 5.17%

TOTAL 6,950,114

Year 0 (11,615,966)

Year 1

Year 4

Year 5

Year 6

Year 7

Year 9

0 0 0 0 0

0 (167,711) (37,958)

Year 3

Year 8

0 0 0 0 0

0

PROJECT-LEVEL LEVERAGED

Year 2

0 0 0 0 0

Year 8

Year 9

0

56


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS Phase PHASE II: II -Proforma PROFORMA PRO-FORMA - PH2 Land Environmental Hard costs Soft costs TOTAL DEVELOPMENT

Tremont Park TOTAL (17,333,593) 0 (109,056,281) (10,061,161) (136,451,035)

OPERATIONS Gross Potential Rent Vacancy Parking Other income EFFECTIVE GROSS INCOME

TOTAL 147,275,353 (10,903,375) 3,817,887 0 140,189,865

Operating expenses Real Estate Taxes EXPENSES NET OPERATING INCOME

3.00%

SALE PROCEEDS

Acquisition Year 2 (17,333,593) 0 0 (570,897) (17,904,490)

Year 2

Construction Year 3 0 0 (53,722,306) (4,675,007) (58,397,313)

Year 3

Construction Year 4 0 0 (55,333,975) (4,815,257) (60,149,232)

Year 4

Lease-up Year 5

Lease-up Year 6 0 0 0 0 0

0 0 0 0 0

Stabilization Year 7 0 0 0 0 0

Hold Year 8

Hold Year 9 0 0 0 0 0

Hold Year 10 0 0 0 0 0

Hold Year 11 0 0 0 0 0

Hold Year 12 0 0 0 0 0

Hold Year 13 0 0 0 0 0

Hold Year 14 0 0 0 0 0

Sale Year 15 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Year 5 12,846,904 (4,700,187) 333,036 0 8,479,753

Year 6 Year 7 13,232,311 13,629,280 (610,604) (628,922) 343,027 353,318 0 0 12,964,734 13,353,676

Year 8 Year 9 14,038,158 14,459,303 (647,790) (667,223) 363,918 374,835 0 0 13,754,287 14,166,915

Year 10 Year 11 Year 12 14,893,082 15,339,875 15,800,071 (687,240) (707,857) (729,093) 386,080 397,663 409,593 0 0 0 14,591,923 15,029,680 15,480,571

Year 13 16,274,073 (750,966) 421,880 0 15,944,988

Year 14 16,762,295 (773,495) 434,537 0 16,423,338

Year 15

(28,094,591) (18,130,901) (46,225,492)

0 0 0

0 0 0

0 0 0

(2,450,705) (1,581,568) (4,032,273)

(2,524,227) (1,629,015) (4,153,241)

(2,599,953) (1,677,885) (4,277,839)

(2,677,952) (1,728,222) (4,406,174)

(2,758,291) (1,780,068) (4,538,359)

(2,841,039) (1,833,470) (4,674,510)

(2,926,270) (3,014,059) (1,888,475) (1,945,129) (4,814,745) (4,959,187)

(3,104,480) (2,003,483) (5,107,963)

(3,197,615) (2,063,587) (5,261,202)

0 0 0

93,964,373

0

0

0

4,447,480

8,811,493

9,075,838

9,348,113

9,628,556

9,917,413

10,214,935

10,521,384

10,837,025

11,162,136

0

187,588,383

0

0

0

0

0

0

0

0

0

0

0

0

0

187,588,383

0 0 0 0 0

PROJECT-LEVEL RETURN UNLEVERAGED

IRR TOTAL 7.77% 145,101,720

Year 2 (17,904,490)

Year 3 Year 4 (58,397,313) (60,149,232)

Year 5 4,447,480

Year 6 8,811,493

Year 7 9,075,838

Year 8 9,348,113

Year 9 9,628,556

Year 10 9,917,413

Year 11 10,214,935

Year 12 10,521,384

Year 13 10,837,025

Year 14 11,162,136

Year 15 187,588,383

PROJECT-LEVEL RETURN UNLEVERAGED/SUBSIDIZED

IRR TOTAL 9.15% 155,803,976

Year 2 (17,904,490)

Year 3 Year 4 (40,656,238) (60,149,232)

Year 5 4,336,293

Year 6 8,591,206

Year 7 8,848,942

Year 8 9,114,410

Year 9 9,387,842

Year 10 9,669,478

Year 11 9,959,562

Year 12 10,258,349

Year 13 10,566,099

Year 14 10,883,082

Year 15 182,898,673

Year 3 Year 4 (1,073,832) (3,973,975) 0 0 (26,846) (99,349) (1,100,678) (4,073,325) (59,497,991) (64,222,557)

Year 5 (5,800,286) 0 (145,007) (5,945,293) (5,945,293)

Year 6 (2,937,367) 0 (73,434) (3,010,801) (3,010,801)

CONSTRUCTION FINANCING Construction interest Finance Developer fee Total financing cost TOTAL DEVELOPMENT - LEVERAGED

TOTAL (14,418,272) 0 (360,457) (14,778,729) (151,229,764)

Year 2

PERMANENT LOAN Draws Interest Repayments

TOTAL 104,106,146 (47,472,309) (104,106,146)

Year 2

0 0 0 0 (17,904,490)

Year 10 (74,448) 0 (1,861) (76,309) (76,309)

Year 11 (74,448) 0 (1,861) (76,309) (76,309)

Year 7

Year 8

Year 9

Year 10

Year 11

Year 12 (74,448) 0 (1,861) (76,309) (76,309)

Year 14 (74,448) 0 (1,861) (76,309) (76,309)

Year 13

Year 14

Year 15 (37,224) 0 (931) (38,155) (38,155)

0 0 0

Year 6 104,106,146 0 0

128,620,703

0

0

0

4,447,480

8,811,493

EQUITY PARTNERSHIP

TOTAL 17,961,766

Year 2 17,904,490

Year 3 57,275

Year 5

Year 6

LIHTC Contributions Distributions TIF STATE/FED ENVIRONMENTAL TOTAL EQUITY CONTRIBUTIONS

17,741,074 (3,215,518) 9,494,392 0 45,197,232

0 0 0 0 17,904,490

17,741,074 0 9,494,392 0 27,292,742

0 0 0 0 0

0

0

0

4,336,293

8,591,206

1,474,824

1,740,292

2,013,724

2,295,359

2,585,444

2,884,231

3,191,981

3,508,964

92,782,868

0

Year 5 4,447,480

Year 6 8,811,493

Year 7 1,512,640

Year 8 1,784,915

Year 9 2,065,358

Year 10 2,354,215

Year 11 2,651,737

Year 12 2,958,185

Year 13 3,273,827

Year 14 3,598,938

Year 15 95,161,916

0

Year 5 4,336,293

Year 6 8,591,206

Year 7 1,474,824

Year 8 1,740,292

Year 9 2,013,724

Year 10 2,295,359

Year 11 2,585,444

Year 12 2,884,231

Year 13 3,191,981

Year 14 3,508,964

Year 15 92,782,868

Year 4 0

PROJECT-LEVEL LEVERAGED

IRR 10.75%

TOTAL 83,423,471

Year 2 (17,904,490)

Year 3 (27,292,742)

Year 4

PROJECT-LEVEL LEVERAGED/SUBSIDIZED

IRR TOTAL 21.07% 107,443,420

Year 2 (17,904,490)

Year 3 (57,275)

Year 4

0

0 (111,187) 0 0 0

0 (6,167,359) (1,395,839)

0 (6,083,609) (1,479,590)

0 (5,994,833) (1,568,365)

1,512,640

1,784,915

2,065,358

2,354,215

2,651,737

2,958,185

3,273,827

3,598,938

Year 10

Year 11

Year 12

Year 13

Year 14

0 (220,287) 0 0 0

Year 8 0

0 (37,816) 0 0 0

Year 9 0

0 (44,623) 0 0 0

0

0 (51,634) 0 0 0

0

0 (58,855) 0 0 0

0

0 (66,293) 0 0 0

0

0 (73,955) 0 0 0

0 (5,695,250) (1,867,948)

Year 15 0 0 (5,583,174) 0 (1,980,025) (91,072,869)

0 (6,246,369) (1,316,829)

Year 7 0

Year 12 0 0 (5,900,731) (5,800,983) (1,662,467) (1,762,215)

Year 13 (74,448) 0 (1,861) (76,309) (76,309)

0 0 0

125,405,185

Year 5

Year 9 (74,448) 0 (1,861) (76,309) (76,309)

0 0 0

CASH FLOW TO PARTNERSHIP

Year 4

Year 8 (74,448) 0 (1,861) (76,309) (76,309)

0 0 0

CASH FLOW AFTER DEBT SERVICE

Year 3

Year 7 (74,448) 0 (1,861) (76,309) (76,309)

0

0 (81,846) 0 0 0

95,161,916

Year 15 0

0 (89,973) 0 0 0

0

0 (2,379,048) 0 0 0

57


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS

Phase PHASEIII: III -Proforma PROFORMA

Tremont Park

PRO-FORMA - PH3 Land Environmental Hard costs Soft costs TOTAL DEVELOPMENT

TOTAL (6,005,184) 0 (99,249,559) (9,377,558) (114,632,301)

OPERATIONS Gross Potential Rent Vacancy Parking Other income EFFECTIVE GROSS INCOME

TOTAL 136,812,904 (13,187,509) 4,283,455 0 127,908,850

Operating expenses Real Estate Taxes EXPENSES NET OPERATING INCOME

3.00%

SALE PROCEEDS

Acquisition Year 4 (6,005,184) 0 0 (605,664) (6,610,849)

Year 4

Construction Year 5 0 0 (48,891,408) (4,321,130) (53,212,538)

Year 5

Construction Year 6 0 0 (50,358,151) (4,450,764) (54,808,914)

Year 6

Lease-up Year 7

Lease-up Year 8 0 0 0 0 0

0 0 0 0 0

Stabilization Year 9 0 0 0 0 0

Hold Year 10

Hold Year 11 0 0 0 0 0

Hold Year 12 0 0 0 0 0

Hold Year 13 0 0 0 0 0

Hold Year 14 0 0 0 0 0

Hold Year 15 0 0 0 0 0

Hold Year 16 0 0 0 0 0

Sale Year 17 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Year 7 11,934,259 (5,169,966) 373,648 0 7,137,941

Year 8 Year 9 12,292,287 12,661,055 (789,198) (812,874) 384,857 396,403 0 0 11,887,946 12,244,585

Year 10 Year 11 Year 12 Year 13 Year 14 13,040,887 13,432,114 13,835,077 14,250,129 14,677,633 (837,260) (862,378) (888,249) (914,896) (942,343) 408,295 420,544 433,160 446,155 459,540 0 0 0 0 0 12,611,922 12,990,280 13,379,988 13,781,388 14,194,830

Year 15 Year 16 15,117,962 15,571,501 (970,614) (999,732) 473,326 487,526 0 0 14,620,675 15,059,295

(20,528,327) (16,632,508) (37,160,835)

0 0 0

0 0 0

0 0 0

(1,790,696) (1,450,862) (3,241,558)

(1,844,417) (1,494,388) (3,338,805)

(1,899,750) (1,539,220) (3,438,969)

(1,956,742) (1,585,396) (3,542,138)

93,134,856

0

0

0

4,104,588

8,763,593

9,026,500

9,297,295

9,576,214

9,863,501

183,285,987

0

0

0

0

0

0

0

0

0

(2,015,445) (2,075,908) (1,632,958) (1,681,947) (3,648,403) (3,757,855)

(2,268,401) (2,336,453) (1,837,909) (1,893,046) (4,106,309) (4,229,499)

0 0 0

10,159,406

10,464,188

10,778,114

11,101,457

0

0

0

0

183,285,987

Year 14 10,464,188

Year 15 10,778,114

Year 16 11,101,457

Year 17 183,285,987

Year 14 10,202,583

Year 15 10,508,661

Year 16 10,823,921

Year 17 178,703,837

Year 14

Year 15

Year 16

Year 17

IRR TOTAL 9.74% 161,788,542

Year 4 (6,610,849)

Year 5 Year 6 (53,212,538) (54,808,914)

Year 7 4,104,588

Year 8 8,763,593

Year 9 9,026,500

Year 10 9,297,295

Year 11 9,576,214

PROJECT-LEVEL RETURN UNLEVERAGED/SUBSIDIZED

IRR TOTAL 10.88% 167,116,104

Year 4 (6,610,849)

Year 5 Year 6 (40,974,455) (54,808,914)

Year 7 4,001,973

Year 8 8,544,503

Year 9 8,800,838

Year 10 9,064,863

Year 11 9,336,809

Year 12 9,616,913

Year 5 Year 6 (769,813) (3,198,550) 0 0 (19,245) (79,964) (789,058) (3,278,514) (54,001,596) (58,087,428)

Year 7 (4,857,475) 0 (121,437) (4,978,912) (4,978,912)

Year 8 (2,428,737) 0 (60,718) (2,489,456) (2,489,456)

Year 10

Year 11

Year 4

PERMANENT LOAN Draws Interest Repayments

TOTAL 103,540,212 (47,214,243) (103,540,212)

Year 4

0 0 0 0 (6,610,849)

0 0 0 0 0

0

0

0

4,104,588

23,986,083

1,504,417

1,775,212

2,054,131

EQUITY PARTNERSHIP

TOTAL 25,612,389

Year 4 6,610,849

Year 5 19,001,540

Year 10

Year 11

LIHTC Contributions Distributions TIF STATE/FED ENVIRONMENTAL TOTAL EQUITY CONTRIBUTIONS

12,238,084 (3,522,222) 0 0 37,850,472

0 0 0 0 6,610,849

12,238,084 0 0 0 31,239,623

0 0 0 0 0

0

0

0

4,001,973

23,386,431

1,466,806

1,730,831

2,002,777

2,282,882

2,571,389

2,868,552

3,174,629

3,489,889

90,390,497

0

Year 7 4,104,588

Year 8 23,986,083

Year 9 1,504,417

Year 10 1,775,212

Year 11 2,054,131

Year 12 2,341,417

Year 13 2,637,322

Year 14 2,942,104

Year 15 3,256,030

Year 16 3,579,373

Year 17 92,708,202

0

Year 7 4,001,973

Year 8 23,386,431

Year 9 1,466,806

Year 10 1,730,831

Year 11 2,002,777

Year 12 2,282,882

Year 13 2,571,389

Year 14 2,868,552

Year 15 3,174,629

Year 16 3,489,889

Year 17 90,390,497

PROJECT-LEVEL LEVERAGED

IRR TOTAL 16.60% 103,038,407

Year 4 (6,610,849)

Year 5 (31,239,623)

Year 6

PROJECT-LEVEL LEVERAGED/SUBSIDIZED

IRR 22.77%

Year 4 (6,610,849)

Year 5 (19,001,540)

Year 6

TOTAL 111,754,268

Year 8

0 (102,615) 0 0 0

Year 9 0

0 (599,652) 0 0 0

0

0 (37,610) 0 0 0

0

0 (44,380) 0 0 0

Year 12 0

0 (51,353) 0 0 0

0

0 (58,535) 0 0 0

Year 14

0 0 0 0 0

140,888,879

2,341,417

Year 13

0 0 0 0 0

0 (6,133,832) (1,388,251)

0

Year 12 0 0 (6,050,537) (5,962,245) (1,471,546) (1,559,839)

0 0 0 0 0

0 (6,212,413) (1,309,671)

Year 7

Year 11

0 0 0 0 0

Year 8 103,540,212 0 0

0

Year 10

Year 13 0 0 0 0 0

0 0 0

Year 6

Year 9

Year 12 0 0 0 0 0

0 0 0

137,366,657

Year 7

0 0 0 0 0

0 0 0

CASH FLOW TO PARTNERSHIP

Year 6

0 0 0 0 0

Year 13 9,905,421

0 0 0

CASH FLOW AFTER DEBT SERVICE

Year 5

Year 9

0 0 0 0 0

(2,202,331) (1,784,377) (3,986,708)

PROJECT-LEVEL RETURN UNLEVERAGED

TOTAL (11,254,578) 0 (281,364) (11,535,943) (126,168,244)

Year 17

(2,138,185) (1,732,405) (3,870,590)

0 192,795,411 Year 12 Year 13 9,863,501 10,159,406

CONSTRUCTION FINANCING Construction interest Finance Developer fee Total financing cost TOTAL DEVELOPMENT - LEVERAGED

0 0 0 0 0

Year 15

Year 16 Year 17 0 0 0 (5,664,290) (5,552,823) 0 (1,857,793) (1,969,261) (90,577,786)

0 (5,868,654) (1,653,429)

0 (5,769,448) (1,752,635)

2,637,322

2,942,104

3,256,030

3,579,373

92,708,202

Year 13

Year 14

Year 15

Year 16

Year 17

0

0 (65,933) 0 0 0

0

0 (73,553) 0 0 0

0

0 (81,401) 0 0 0

0

0 (89,484) 0 0 0

0

0 (2,317,705) 0 0 0

58


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS

Phase IV: Proforma PHASE IV - PROFORMA PRO-FORMA - PH4 Land Environmental Hard costs Soft costs TOTAL DEVELOPMENT

Tremont Park TOTAL (1,661,222) 0 (35,503,392) (4,448,290) (41,612,904)

OPERATIONS Gross Potential Rent Vacancy Parking Other income EFFECTIVE GROSS INCOME

TOTAL 24,991,531 (4,353,891) 0 0 20,637,640

Operating expenses Real Estate Taxes EXPENSES NET OPERATING INCOME

3.00%

SALE PROCEEDS

Acquisition Year 6 (1,661,222) 0 0 (642,549) (2,303,772)

Year 6

Construction Year 7 0 0 (17,489,356) (1,874,749) (19,364,105)

Year 7

Construction Year 8 0 0 (18,014,036) (1,930,992) (19,945,028)

Year 8

Lease-up Year 9

Lease-up Year 10 0 0 0 0 0

0 0 0 0 0

Stabilization Year 11 0 0 0 0 0

Hold Year 12

Hold Year 13 0 0 0 0 0

Sale Year 14 0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

Year 9 4,707,269 (2,325,465) 0 0 2,381,804

Year 10 4,848,487 (484,849) 0 0 4,363,638

Year 11 4,993,942 (499,394) 0 0 4,494,548

Year 12 5,143,760 (514,376) 0 0 4,629,384

Year 13 5,298,073 (529,807) 0 0 4,768,266

Year 14

0 (2,786,336) (2,786,336)

0 0 0

0 0 0

0 0 0

0 (524,819) (524,819)

0 (540,564) (540,564)

0 (556,781) (556,781)

0 (573,484) (573,484)

0 (590,689) (590,689)

17,851,304

0

0

0

1,856,985

3,823,075

3,937,767

4,055,900

4,177,577

0

67,661,558

0

0

0

0

0

0

0

0

67,661,558

0 0 0 0 0 0 0 0

PROJECT-LEVEL RETURN UNLEVERAGED

IRR 12.94%

TOTAL 43,899,957

Year 6 (2,303,772)

Year 7 Year 8 (19,364,105) (19,945,028)

Year 9 1,856,985

Year 10 3,823,075

Year 11 3,937,767

Year 12 4,055,900

Year 13 4,177,577

Year 14 67,661,558

PROJECT-LEVEL RETURN UNLEVERAGED/SUBSIDIZED

IRR 12.94%

TOTAL 43,899,957

Year 6 (2,303,772)

Year 7 Year 8 (19,364,105) (19,945,028)

Year 9 1,856,985

Year 10 3,823,075

Year 11 3,937,767

Year 12 4,055,900

Year 13 4,177,577

Year 14 67,661,558

Year 7 Year 8 (278,639) (1,162,404) 0 0 (6,966) (29,060) (285,605) (1,191,464) (19,649,710) (21,136,492)

Year 9 (1,767,528) 0 (44,188) (1,811,717) (1,811,717)

Year 10 (883,764) 0 (22,094) (905,858) (905,858)

Year 11

Year 12

Year 13

CONSTRUCTION FINANCING Construction interest Finance Developer fee Total financing cost TOTAL DEVELOPMENT - LEVERAGED

TOTAL (4,092,336) 0 (102,308) (4,194,644) (45,807,548)

Year 6

PERMANENT LOAN Draws Interest Repayments

TOTAL 45,168,915 (8,025,507) (45,168,915)

Year 6

0 0 0 0 (2,303,772)

0 0 0

Year 7 0 0 0

Year 8 0 0 0

0 0 0

Year 10 45,168,915 0 0

0

1,856,985

16,855,109

CASH FLOW AFTER DEBT SERVICE

45,350,474

0

0

EQUITY PARTNERSHIP

TOTAL 13,772,957

Year 6 2,303,772

Year 7 11,469,186

LIHTC Contributions Distributions TIF STATE/FED ENVIRONMENTAL TOTAL EQUITY CONTRIBUTIONS

0 0 0 0 13,772,957

0 0 0 0 2,303,772

CASH FLOW TO PARTNERSHIP

45,350,474

0

Year 9

Year 8

Year 9

Year 10

0 0 0 0 0

Year 11

0 0 0 0 0

Year 12

0 (2,710,135) (571,338) 656,294

Year 11

Year 14 0 0 0 0 0

0 0 0 0 0

Year 13

0 (2,675,855) (605,618) 774,428

Year 12

Year 14 0 0 (2,639,518) 0 (641,955) (43,350,004) 896,105

Year 13

24,311,554

Year 14

0

0

0

0

0

0

0

0 0 0 0 11,469,186

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0

0

1,856,985

16,855,109

656,294

774,428

896,105

24,311,554

0

Year 9 1,856,985

Year 10 16,855,109

Year 11 656,294

Year 12 774,428

Year 13 896,105

Year 14 24,311,554

0

Year 9 1,856,985

Year 10 16,855,109

Year 11 656,294

Year 12 774,428

Year 13 896,105

Year 14 24,311,554

PROJECT-LEVEL LEVERAGED

IRR 27.49%

TOTAL 31,577,517

Year 6 (2,303,772)

Year 7 (11,469,186)

Year 8

PROJECT-LEVEL LEVERAGED/SUBSIDIZED

IRR 27.49%

TOTAL 31,577,517

Year 6 (2,303,772)

Year 7 (11,469,186)

Year 8

59


V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS PROFORMA - MASTER Master Proforma PRO-FORMA - MASTER Land Environmental Hard costs Soft costs TOTAL DEVELOPMENT

Tremon TOTAL (37,500,000) 0 (258,961,147) (26,964,022) (323,425,169)

OPERATIONS Gross potential rent Vacancy Parking Other income EFFECTIVE GROSS INCOME

TOTAL 311,286,892 (28,723,244) 0 0 282,563,648

Operating expenses Real estate taxes EXPENSES

Year 0 (12,500,000) 0 0 (538,125) (13,038,125)

Year 0

Year 1 0 0 (21,665,149) (2,538,888) (24,204,036)

Year 1

Year 2 (17,333,593) 0 0 (570,897) (17,904,490)

Year 2 192,527 (77,011) 0 0 115,516

Year 3

Year 4 Year 5 0 (6,005,184) 0 0 0 0 (52,345,470) (53,915,834) (47,059,755) (4,675,007) (5,420,922) (4,321,130) (57,020,477) (65,341,940) (51,380,885)

Year 3 198,303 (19,830) 0 0 178,472

Year 6 (1,661,222) 0 (48,471,548) (5,093,313) (55,226,083)

0 0 (17,489,356) (1,874,749) (19,364,105)

0 0 (18,014,036) (1,930,992) (19,945,028)

Year 6 13,449,001 (632,273) 0 0 12,816,729

Year 7 25,786,730 (4,050,426) 0 0 21,736,304

Year 8 26,560,332 (1,095,195) 0 0 25,465,137

Year 9 32,064,411 (1,240,729) 0 0 30,823,682

Year 10 33,026,344 (1,190,907) 0 0 31,835,436

Year 11 34,017,134 (1,226,634) 0 0 32,790,500

Year 12 34,778,908 (1,237,559) 0 0 33,541,349

Year 13 35,822,275 (1,274,686) 0 0 34,547,589

Year 14 31,439,929 (1,280,271) 0 0 30,159,658

Year 15 15,117,962 (521,979) 0 0 14,595,983

Year 16 15,571,501 (537,639) 0 0 15,033,862

(2,450,705) (1,581,568) (4,032,273)

(2,524,227) (1,629,015) (4,153,241)

(4,390,650) (3,128,747) (7,519,397)

(4,522,369) (3,222,610) (7,744,979)

(4,658,040) (3,844,107) (8,502,147)

(4,797,781) (3,959,430) (8,757,212)

(4,941,715) (4,078,213) (9,019,928)

(5,089,966) (4,200,560) (9,290,526)

(5,242,665) (4,326,576) (9,569,242)

(5,399,945) (3,847,965) (9,247,910)

(2,268,401) (1,837,909) (4,106,309)

(2,336,453) (1,893,046) (4,229,499)

0 0 0

Year 4 Year 5 204,252 13,057,283 (20,425) (4,721,225) 0 0 0 0 183,827 8,336,058

Year 7

Year 8

Year 9

Year 10 0 0 0 0 0

Year 11 0 0 0 0 0

Year 12 0 0 0 0 0

Year 13 0 0 0 0 0

Year 14 0 0 0 0 0

Year 15 0 0 0 0 0

Year 16 0 0 0 0 0

Year 17 0 0 0 0 0

0 0 0 0 0

Year 17

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

(48,622,918) (37,549,746) (86,172,663)

0 0 0

0 0 0

0 0 0

0 0 0

0 0 0

NET OPERATING INCOME

210,646,715

0

0

246,802

313,697

323,108

4,780,281

9,154,279

13,959,646

18,914,303

21,338,717

23,889,258

24,605,936

24,440,784

25,174,008

21,626,324

10,778,114

11,101,457

0

SALE PROCEEDS

480,094,443

0

0

27,242,161

0

0

0

0

0

0

0

0

0

14,316,354

0

67,661,558

187,588,383

0

183,285,987

PROJECT-LEVEL RETURN UNLEVERAGED

IRR TOTAL 8.97% 367,315,988

Year 0 (13,038,125)

Year 1 (24,204,036)

Year 2 9,584,474

Year 3 Year 4 Year 5 (56,706,779) (65,018,832) (46,600,604)

Year 6 (46,071,805)

Year 7 (5,404,458)

Year 8 (1,030,725)

Year 9 21,338,717

Year 10 23,889,258

Year 11 24,605,936

Year 12 38,757,138

Year 13 25,174,008

Year 14 89,287,882

Year 15 198,366,496

Year 16 11,101,457

Year 17 183,285,987

PROJECT-LEVEL RETURN UNLEVERAGED/SUBSIDIZED

IRR TOTAL 10.20% 390,557,406 23,241,418

Year 0 (13,038,125)

Year 1 (24,204,036)

Year 2 9,584,474

Year 3 Year 4 Year 5 (38,965,705) (65,018,832) (34,473,707)

Year 6 (46,292,092)

Year 7 (5,544,889)

Year 8 (1,675,000)

Year 9 21,249,472

Year 10 23,786,023

Year 11 24,488,290

Year 12 38,624,648

Year 13 25,026,229

Year 14 89,124,356

Year 15 195,906,048

Year 16 11,011,973

Year 17 180,968,282

Year 0 (53,336) 0 (1,333) (54,670) (13,092,795)

Year 1 (720,842) 0 (18,021) (738,863) (24,942,899)

Year 2 (667,505) 0 (16,688) (684,193) (18,588,683)

Year 3 Year 4 Year 5 (1,073,832) (3,973,975) (6,570,098) 0 0 0 (26,846) (99,349) (164,252) (1,100,678) (4,073,325) (6,734,351) (58,121,155) (69,415,265) (58,115,236)

Year 6 (6,135,917) 0 (153,398) (6,289,315) (61,515,398)

Year 7 (5,210,562) 0 (130,264) (5,340,826) (24,704,931)

Year 8 (3,246,970) 0 (81,174) (3,328,144) (23,273,173)

Year 9 (1,004,739) 0 (25,118) (1,029,858) (1,029,858)

CONSTRUCTION FINANCING Construction interest Finance Developer fee Total financing cost TOTAL DEVELOPMENT - LEVERAGED

TOTAL (29,160,170) 0 (729,004) (29,889,174) (353,314,344)

PERMANENT LOAN Draws Interest Repayments Ending balance

TOTAL 255,646,268 (104,296,755) (255,646,268)

0 0 0 0

Year 1 2,830,995 0 0 2,830,995

333,426,111

0

TOTAL 68,963,077

Year 0 11,615,966

LIHTC/SHTC Contributions Distributions TIF STATE/FED ENVIRONMENTAL TOTAL EQUITY CONTRIBUTIONS

29,979,158 (6,737,740) 9,494,392 0 108,436,627

CASH FLOW TO PARTNERSHIP

326,688,371

CASH FLOW AFTER DEBT SERVICE

EQUITY PARTNERSHIP

Year 0

Year 2

Year 3

Year 4

0 (169,860) (35,809) 2,795,186

0 (167,711) (37,958) 2,757,229

0 (165,434) (40,235) 2,716,994

0

3,010,370

108,029

117,440

4,574,612

8,948,610

6,190,779

0

Year 2 17,904,490

Year 3 57,275

Year 4 6,610,849

Year 5 19,001,540

Year 6 2,303,772

Year 7 11,469,186

0 0 0 0 11,615,966

0 0 0 0 0

0 0 0 0 0

17,741,074 0 9,494,392 0 17,904,490

0 0 0 0 27,292,742

12,238,084 (111,187) 0 0 6,610,849

0 (220,287) 0 0 31,239,623

0 (140,431) 0 0 2,303,772

0 (644,275) 0 0 11,469,186

0

0

3,010,370

108,029

117,440

4,463,425

8,728,323

6,050,349

10,501,161

0

Year 2 3,010,370

Year 5 (2,036,237)

Year 6 (22,291,013)

Year 7 3,887,008

0

Year 2 (14,894,120)

Year 6 6,424,551

Year 7 (5,418,837)

Year 1

PROJECT-LEVEL LEVERAGED

IRR 14.00%

TOTAL 224,989,483

Year 0 (11,615,966)

Year 1

PROJECT-LEVEL LEVERAGED/SUBSIDIZED

IRR 18.21%

TOTAL 257,725,294

Year 0 (11,615,966)

Year 1

Year 3 Year 4 (17,796,462) (27,175,303)

Year 3 50,753

Year 5

Year 6 0 104,106,146 (163,020) (160,461) (42,649) (45,208) 2,674,345 106,735,283

Year 4 Year 5 (6,493,409) (14,538,114)

Year 7 0 (6,404,117) (1,364,750) 105,370,533

Year 10 (502,370) 0 (12,559) (514,929) (514,929)

Year 11

Year 12 0 0 0 0 0

Year 13 0 0 0 0 0

Year 14 (0) 0 (0) (0) (0)

Year 15 (0) 0 (0) (0) (0)

Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 103,540,212 0 45,168,915 0 0 0 0 (6,322,232) (12,447,847) (12,277,260) (14,806,574) (14,439,083) (14,203,422) (11,352,622) (1,446,635) (2,843,104) (3,013,690) (3,765,849) (6,286,676) (4,163,332) (47,082,664) 207,464,110 204,621,006 246,776,231 243,010,381 236,723,705 232,560,373 185,477,709 11,145,436

Year 8

6,047,766

Year 9 0

Year 8 (323,750)

Year 8 10,501,161

35,499,237

Year 10 0

0 (89,244) 0 0 0

6,033,513

Year 11 0

0 (103,236) 0 0 0

18,031,379

Year 12 0

0 (117,647) 0 0 0

6,807,253

Year 13 0

0 (132,490) 0 0 0

30,852,590

Year 14 0

0 (147,779) 0 0 0

Year 16 0 0 0 0 0

Year 15

Year 16

0 (163,526) 0 0 0

(0) 0 (0) (0) (0)

Year 17

0 (5,664,290) (92,930,663) 92,547,046

0 (5,552,823) (1,969,261) 90,577,786

0 0 (90,577,786) 0

99,771,538

3,579,373

92,708,186

Year 15 0

Year 17 (0) 0 (0) (0) (0)

Year 16 0

0 (2,460,449) 0 0 0

Year 17 0

0 (89,484) 0 0 0

0

0 (2,317,705) 0 0 0

5,958,522

35,396,001

5,915,866

17,898,889

6,659,475

30,689,064

97,311,090

3,489,889

90,390,481

Year 9 6,047,766

Year 10 35,499,237

Year 11 6,033,513

Year 12 18,031,379

Year 13 6,807,253

Year 14 30,852,590

Year 15 99,771,538

Year 16 3,579,373

Year 17 92,708,186

Year 9 5,958,522

Year 10 35,396,001

Year 11 5,915,866

Year 12 17,898,889

Year 13 6,659,475

Year 14 30,689,064

Year 15 97,311,090

Year 16 3,489,889

Year 17 90,390,481

60


Tremont Park

V. PROPOSAL I - TREMONT PARK - FINANCIAL ANALYSIS Partnership Waterfall PARTNERSHIP WATERFALL WATERFALL Total Cash Flow for Distribution

TOTAL 326,688,371

GP Return Account Beginning Balance GP Equity Drawn 10% Preferred Return Pro Rata Cash Flow Ending Balance GP Cash Flow

(6,896,308) (14,084,456) 20,980,763

Year 1 0

Year 2 3,010,370

Year 3 108,029

Year 4 117,440

Year 5 4,463,425

Year 6 8,728,323

Year 7 6,050,349

Year 8 10,501,161

Year 9 5,958,522

Year 10 35,396,001

Year 11 5,915,866

Year 12 17,898,889

Year 13 6,659,475

Year 14 30,689,064

Year 15 97,311,090

(1,161,597)

(1,161,597) (174,239) (1,335,836)

(1,335,836) (1,790,449) (200,375) 301,037 (3,025,624)

(3,025,624) (5,728) (453,844) 10,803 (3,474,392)

(3,474,392) (661,085) (521,159) 11,744 (4,644,891)

(4,644,891) (1,900,154) (696,734) 446,343 (6,795,437)

(6,795,437) (230,377) (1,019,315) 872,832 (7,172,297)

(7,172,297) (1,146,919) (1,075,845) 605,035 (8,790,025)

(8,790,025) (1,318,504) 1,050,116 (9,058,413)

(9,058,413) (1,358,762) 595,852 (9,821,323)

(9,821,323) (1,473,198) 3,539,600 (7,754,921)

(7,754,921) (1,163,238) 591,587 (8,326,572)

(8,326,572) (1,248,986) 1,789,889 (7,785,669)

(7,785,669) (1,167,850) 665,947 (8,287,572)

(8,287,572) (1,243,136) 3,068,906 (6,461,802)

(6,461,802) (969,270) 7,431,072 -

-

-

(649,341)

(1,453,811)

3,068,906

7,431,072

-

-

(31,269,526) (5,949,764) (4,690,429) 105,696 (41,804,023)

(41,804,023) (17,101,386) (6,270,603) 4,017,083 (61,158,929)

(61,158,929) (2,073,394) (9,173,839) 7,855,490 (64,550,673)

(64,550,673) (10,322,267) (9,682,601) 5,445,314 (79,110,227)

(79,110,227) (11,866,534) 9,451,045 (81,525,716)

(81,525,716) (12,228,857) 5,362,669 (88,391,904)

(88,391,904) (13,258,786) 31,856,401 (69,794,288)

(69,794,288) (10,469,143) 5,324,280 (74,939,152)

(74,939,152) (11,240,873) 16,109,000 (70,071,025)

(70,071,025) (10,510,654) 5,993,527 (74,588,151)

(74,588,151) (11,188,223) 27,620,158 (58,156,216)

(58,156,216) (8,723,432) 66,879,649 -

-

-

(5,844,068)

(13,084,303)

5,782,096

(4,876,953)

9,451,045

5,362,669

31,856,401

5,324,280

16,109,000

5,993,527

27,620,158

66,879,649

-

-

0

0

0

0

0

0

0

23,000,369

3,489,889

90,390,481

1,840,029 16,560,265 4,600,074 -

279,191 2,512,720 697,978 -

499,524 4,495,718 18,078,096 67,317,143

(1,161,597) IRR

LP Return Account Beginning Balance LP Equity Drawn 10% Preferred Return Pro Rata CF Ending Balance LP Cash Flow

Year 0 0

15.00%

(62,066,769) (126,760,100) 188,826,870

(1,161,597)

(10,454,369)

(10,454,369) IRR

15.00%

(10,454,369)

Net Cash Available for Distributions

-

(1,489,412)

(10,454,369) (1,568,155) (12,022,525) -

0

(12,022,525) (16,114,041) (1,803,379) 2,709,333 (27,230,612) (13,404,708)

0

5,075

(27,230,612) (51,548) (4,084,592) 97,226 (31,269,526) 45,678

0

0

0

642,455

0

(541,884)

0

1,050,116

0

595,852

3,539,600

591,587

1,789,889

665,947

Year 16 3,489,889

Tier II: 80%/20% up to 16% Investor IRR GP (8%) LP (72%) Sponsor (20%) Remaining Cash Available

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Tier III: 70%/30% up to 17.5% Investor IRR GP (7%) LP (63%) Sponsor (30%) Remaining Cash Available

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Tier IV GP (6%) LP (54%) Sponsor (40%)

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions GP LP Sponsor Totals Total to GP + Sponsor

IRR IRR

IRR

Year 17 90,390,481

4,712,200 42,409,800 20,195,143 -

-

17.21% 17.21%

(1,161,597) (10,454,369) (11,615,966)

-

(1,489,412) (13,404,708) (14,894,120)

5,075 45,678 50,753

(649,341) (5,844,068) (6,493,409)

(1,453,811) (13,084,303) (14,538,114)

642,455 5,782,096 6,424,551

(541,884) (4,876,953) (5,418,837)

1,050,116 9,451,045 10,501,161

595,852 5,362,669 5,958,522

3,539,600 31,856,401 35,396,001

591,587 5,324,280 5,915,866

1,789,889 16,109,000 17,898,889

665,947 5,993,527 6,659,475

3,068,906 27,620,158 30,689,064

9,271,102 83,439,914 4,600,074 97,311,090

279,191 2,512,720 697,978 3,489,889

5,211,724 46,905,517 38,273,239 90,390,481

23.8%

(1,161,597)

-

(1,489,412)

5,075

(649,341)

(1,453,811)

642,455

(541,884)

1,050,116

595,852

3,539,600

591,587

1,789,889

665,947

3,068,906

13,871,175

977,169

43,484,963

61


V. PROPOSAL I - INDUSTRIAL ZONE

Existing Conditions

Malden’s Industrial Zone The land to the south of Charles Street and east of the Malden River has long been a center of Malden’s industrial economy. Today, many of the one-story office and light manufacturing warehouses are occupied by the New England Coffee Company, though a number stand vacant. Malden’s proximity to Boston, lower land rents, and availability of space will continue to make this area economically viable, provided the city pursues aggressive branding strategies to attract context-appropriate industries.

cial space on the Campus. Along with zoning rights, the City of Malden should other economic development incentives such as tax abatements or building rehabilitation grants to catalyze the development. The Charles Street Food Innovation Campus will be linked to the rest of the city by the new Malden Ballpark and the proposed development of Tremont Park, providing yet another engine for growth within downtown Malden.

With the New England Coffee Company as its anchor and with the diversity of building stock throughout the industrial zone, Malden could develop the Charles Street Food Innovation Campus, capitalizing on existing strengths and capturing revenue from a growing local agribusiness movement. The Food Innovation Campus would house commercial test kitchens for area food entrepreneurs, production facilities for locally distributed food products, a brewery or distillery for use by a single local craft brewer or a revolving base of start-up brewers, office and meeting space for business development, and public space for farmers markets, tastings, and other outdoor programming. The products launched and food grown on the Campus could benefit Malden directly through distribution to Malden’s burgeoning restaurant scene as well as area public schools. By zoning the area for this use, Malden would incentivize developers interested in becoming involved in the local food movement to re-develop the existing industrial building stock for food and beverage production purposes, as well as build related office and commer-

COMMUNITY TRAIL PRIVATE PARKING / LOADING

62


NG

V. PROPOSAL I - INDUSTRIAL ZONE

Proposed Conditions

Precedent Images

Mama’s Small Business Kitchen Incubator, Pasadena, CA

The Plant Chicago, industrial re-use for a vertically-integrated farm, food incubator, and business development center.

COMMUNITY TRAIL PRIVATE PARKING / LOADING

The Brewery District, adaptive re-use of industrial complex, Boston, MA

Mark’s Carts food truck courtyard, Ann Arbor, MI

63


64


V. PROPOSAL II Malden Mall and Premier Gym (MMPG) Stephanie Torres & Weishun Xu

65


V. PROPOSAL II - MMPG - CONTEXT

Context The intention behind our proposal is to contribute in fulfilling the Malden Vision. The Malden Vision is a community survey conducted by the Malden Planning Board in 2008 to assess the community’s goals for future development. A question in the survey that is especially relevant to this field study is: Which of the following type of development is needed in Malden? As shown on the chart to the right, the top four answers are: passive recreational parks/ activities, active recreational parks/activities, retail businesses, and restaurants. These answers became the basis for the formation of our proposal to revitalize Downtown Malden-. To ignite a sustainable revitalization of Malden’s downtown area, we believe it is important to begin with the revitalization of the downtown core itself. We identify the downtown core as the area along and within the area bounded by

Pleasant St, Main St, Exchange St, and Commercial St. This core area has a diverse base of services and uses including a church, the Malden Senior Community Center, the Commonwealth of Massachusetts Department of Elementary and Secondary Education, residential units, office space, banks, and various types of retail including restaurants and bars, specialty stores, mom-and-pops, and a supermarket. To capitalize on the high density of retail businesses in the core area and positive retail submarket conditions, our proposal is a venture to reinforce the core area as Malden’s top shopping destination. Additionally, the 800 residential units in the pipeline expected to be delivered within the next four years will create a new wave of demand. This will unlatch a new window of opportunity to redevelop the core’s existing retail scene.

66


V. PROPOSAL II - MMPG - VISION Pleasant St

Â

MALDEN MALL SITE 3

MALDEN MALL SITE 1

Vision MALDEN MALL SITE 2

Our vision is to create a vibrant and welcoming environment where residents and visitors alike can shop, eat, and be engaged in recreational activities. We propose to develop Malden (mini) Mall which will feature 102 units of retail space. Given the site selection, these retail units are intended to be occupied by existing and new tenants alike. Malden Mall will consist of three structures on three distinct sites as shown on the diagram to the right.

Our goal is to redevelop the core area to create a more energetic and pleasant environment with enough potential to incite further redevelopment outside of the core area.

Pleasant St.

Exchange St.

Ma in S t.

Commerce

St.

PREMIER GYM

Furthermore, to take advantage of the subway station on the west end of Pleasant St., we are also proposing creating over 21,000 square feet of green space along with a gym on the west end of Pleasant St, altogether named Premier Gym. The green space will serve as an ameni-

ty to Malden’s residents and visitors alike, but we also hope it will increase foot traffic along Pleasant St. and Exchange St. as people will be encouraged to walk from the park to the subway station and vice versa. The increase in foot traffic will potentially benefit the retail businesses, including the Malden Mall, along the stretch between the subway station and Premier Gym.

67


V. PROPOSAL II - MMPG - MALDEN MALL: EXISTING

Part of the Malden Vision we are assessing: • Retail businesses • Restaurants Altogether, the 3 mini-mall sites will contribute 102 retail units. The property on Site 1 will create indoor retail space while the properties on Site 2 and Site 3 along with the side of the property on Site 1 along Exchange St. will create a balance of outdoor retail space.

Existing Conditions Site 1 Currently on this site, there is 177,100 square feet of commercial space. The site is composed of 8 different parcels of land and the properties are an agglomeration of buildings with different facades and heights built mostly in the early 1900s. Both along Pleasant St and Exchange St, the buildings contain ground floor retail, which includes a fashion boutique, two banks, discount stores, and a wide array of restaurants most notably All Seasons Table. It should be noted that there is a negative grade change going from Pleasant St. to Exchange St.

Aerial view of Site 1 from Pleasant St.

Aerial view of Site 1 from Exchange St.

68


V. PROPOSAL II - MMPG - MALDEN MALL: EXISTING

Site 2

Site 3

The second portion of the mall will be located on the Exchange St. facing portion of the ground floor of a six-level garage. Along Exchange St, the garage is fronted with a small green space with benches. This site is adjacent to Site 3. The proposed program will occupy 13,250 square feet of the ground floor of the parking garage reducing the amount of parking spaces in the garage by approximately 25.

The site currently serves as a surface parking lot and contains approximately 4,800 square feet of commercial space. The commercial space and parking late are located on two different parcels of land. Site 3 has a total area of 22,840 square feet.

Aerial view of Site 2 from Exchange St.

Aerial view of Site 3 from Exchange St.

Ground view of Site 2 from Exchange St.

Ground view of Site 3 from Exchange St.

69


V. PROPOSAL II - MMPG - MALDEN MALL: PROPOSAL

Proposal Site 1

Site 2

The proposed property on Site 1 will contain 84 retail units ranging in size from 1,420 to 2,270 square feet intended to have restaurant, bar, cafĂŠ, fashion boutique, and mom-and-pop tenants amongst other retail uses and services. Due to the grade change between Pleasant St. and Exchange St., the property will be 3 floors high along Pleasant St. and 4 stories high along Exchange St. In terms of circulation, the property will have an interior corridor going from east to west. Additionally, there will be a central, ceiling-high atrium that will provide a connection between Pleasant St. and Exchange St. Due the specific program needs of the property on Site 3 and the irregularity of the existing properties, our development strategy includes demolishing the existing structures. Although, the proposed property will be new, it will be designed such that it naturally integrates into the existing fabric of the built environment in the downtown core area.

The proposed property on site 2 will contain 6 retail units each having an average size of 1,870 square feet. Although the property on Site 1 will be the main mini-mall building, the property on Site 2 is intended to attract pedestrians from Pleasant St. to Exchange St. and improve the aesthetic fabric on Exchange St. Site 2 will make use of the green space fronting it as an amenity for the shoppers.

Site 1 Floor Layout

Site 2 Floor Layout

70


V. PROPOSAL II - MMPG - MALDEN MALL: PROPOSAL

Site 3 The proposed property on Site 3 will contain 12 retail units averaging 1,760 square feet in size equally distributed throughout the two floors of the property. The purpose behind having two floors on this property is to create a balance between the 6-floor parking garage next door and the 4-floor mini mall across the street. Given the proposed building program, the existing structure on this site will have to be demolished. Like Site 2, Site 3 is intended to draw pedestrian activity from Pleasant St. Altogether, Site 1, Site 2, and Site 3 will create a short retail strip along Exchange St. in hopes of reviving and increasing pedestrian liveliness along Exchange St.

Site 3 Floor Layout

71


V. PROPOSAL II - MMPG - PREMIER GYM: EXISTING

Part of the Malden Vision we are assessing: •Active recreational parks/activities • Passive recreational parks/activities Premier Gym consists of two recreational areas one of which is a green space and the other is a full service gym. Premier Gym is intended to provide an amenity to the downtown area but is also set out to create a destination at the end of Pleasant St.

Existing Conditions Currently on the site there exists 32,000 square feet of office and retail space. The whole site is composed of 7 parcels of land, which is occupied by 3 different buildings and a parking lot. The site is situated between Malden High School adjacent to the east and the downtown core on the west. Since the site is located directly in between Malden High School and Pleasant St, to get from the high school to the core area and vice versa, you need to go around the site which corners a highly trafficked intersection

Premier Gym site on the intersection of Main St. and Ferry St.

Current path to go from the downtown core area to the Malden High School Area

Aerial view of Premier Gym Site

72


V. PROPOSAL II - MMPG - PREMIER GYM: PROPOSAL

Proposal The proposal for this site is to create a 15,520 square foot gym along with 21,860 square feet of green space, altogether named Premier Gym. Aside from being an amenity, the green space is intended to provide a passageway from the downtown core to the high school area. Additionally, the location of the gym at the end of Pleasant St. will increase pedestrian activity along Pleasant St. from the people getting off the subway station to go to the gym and vice versa. Although the Malden YMCA is just a 5-minute walk away, the Premier Gym will be unique in that it will contain over 5,000 square feet of rock climbing walls along with other gym amenities. Given the program of the proposed space, the existing stricture will be demolished to create the gym.

73


V. PROPOSAL II - MMPG - DEVELOPMENT STRATEGY

Development Strategy The development strategy is divided into five steps which go in accordance with the phasing of the project.

Step 1 • Acquire the 10 parcels of land necessary to construct Malden Mall • Negotiate a property lease with the parking garage owner

Step 2 • Demolish the structures on Site 1 and Site 3 • Allow a one-year development period for the Malden Mall • Acquire the 7 parcels necessary to construct Premier Gym

74


V. PROPOSAL II - MMPG - DEVELOPMENT STRATEGY

Step 4 • Demolish the structures on the gym parcel • Allow a 6 month development period for Premier Gym

Step 3 • Inaugurate Malden mall • Relocate the retail tenants on the Premier Gym site into Malden Mall

75


V. PROPOSAL II - MMPG - PHASING, SCHEDULE, AND ABSORPTION

Project Phasing, Schedule, and Absorption The project consists of 2 phases split into the development of Malden Mall followed by the development of Premier Gym. Phase 1, which is the development of Malden Mall, is proposed to begin in 2017 during the time when the last round of residential units in the current pipeline will be delivered. Phase 1 will have a one-year development period followed by a one-year lease up period during which 61 retail units will be leased during the 1st quarter of 2018 followed by 14 units on the 2nd quarter, 14 uints on the 3rd quarter, and finally 13 retail units on the 4th quarter.

PROJECT SCHEDULE

2017 Q1

MALDEN MALL No. of Retail Units Absorbed PREMIER

Q2

While Malden Mall reaches a stabilized occupancy, the construction of the Premier Gym will begin during the second quarter of 2018 and is allotted a 6-month development period. The gym is expected to be preleased to a gym operator and thus doesn’t require a lease-up period. Both the Premier Gym and Malden Mall are then fully operating by 2019. The exit strategy is then to sell Malden Mall in 2026 and Premier Gym in 2027. From the construction start date of Malden Mall to the disposition of Premier Gym, the project is set to span 10 years.

2018 Q3

Q4

Q1

Q2

Development Period 61

2019 Q3

Lease-Up Period 14 14

Q4

Q1

Q2

2020 Q3

First Stabilized Year

2021

2022

2023

2024

2025

2026

2027

Q4 Hold Period

Sell

13

Development Period

First Stabilized Year

Hold Period

Sell

76


V. PROPOSAL II - MMPG - PHASING, SCHEDULE, AND ABSORPTION

Phase I

Phase II

77


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

Financial Analysis The total development costs for the project is approximately $77,000,000; using a 1.2 debt service coverage ratio, the project will be financed through a construction loan followed by permanent loan totaling over $67,000,000. The sole investor in the project will then contribute $10,000,000 of initial equity. Complete details are included in the ‘Assumptions’ sheet. Beginning with the Malden Mall development in 2017 and disposing of the Premier Gym in 2027, the total After-Tax IRR is 15.0%.

RETURN MEASURES Unleveraged IRR Project Cost Net Operating Income Adjusted Sales Price Unleveraged Cash Flow Unleveraged IRR Net Present Value

Time Zero

8% $

Premier Sale

Malden Mall Hold Period 2019

2020

2021

2022

2023

2024

2025

Malden Mall Sale 2026

2027

9.2% 7,372,709

$ (8,386,433) $ (5,615,288) $ (54,512) $ 1,266,800 $ $ (8,386,433) $ (5,669,800) $ 1,266,800 $

952,632 $ 1,110,974 $ 1,274,066 $ 1,442,051 $ 1,615,076 $ 1,793,291 $ 1,976,852 $ 2,165,921 $ 225,867 $ 43,555,070 $ 4,974,534 952,632 $ 1,110,974 $ 1,274,066 $ 1,442,051 $ 1,615,076 $ 1,793,291 $ 1,976,852 $ 45,720,991 $ 5,200,401

$ (8,386,433) $ (5,615,288) $ (54,512) $ 1,266,800 $

818,014 $

882,422 $

$ (8,386,433) $ (5,669,800) $ 1,266,800 $

818,014 $

882,422 $

19.0% 8% $ 17,106,690

After-Tax IRR Equity After-Tax Operating Cash Flow After-Tax Cash Flow from Sale Total After-Tax Cash Flow After-Tax IRR Net Present Value

Premier Hold Period

$ (64,884,500) $ (12,239,407) $ (54,512) $ 3,964,468 $ 5,278,061 $ 5,436,403 $ 5,599,495 $ 5,767,480 $ 5,940,504 $ 6,118,719 $ 6,302,281 $ 6,491,349 $ 6,686,090 $ 95,429,699 $ 10,746,392 $ (64,884,500) $ (12,293,919) $ 3,964,468 $ 5,278,061 $ 5,436,403 $ 5,599,495 $ 5,767,480 $ 5,940,504 $ 6,118,719 $ 6,302,281 $ 101,921,048 $ 17,432,482

Before-Tax IRR Equity Before-Tax Operating Cash Flow Before-Tax Cash Flow from Sale Total Before-Tax Cash Flow Before-Tax IRR Net Present Value

Premier Development Malden Mall Malden Mall Development Lease-Up 2017 2018

8% $

977,278 $ 1,074,624 $ 1,174,518 $ 1,272,429 $ 1,347,788 $ 1,446,869 $ 173,564 $ 31,641,547 $ 4,030,061 977,278 $ 1,074,624 $ 1,174,518 $ 1,272,429 $ 1,347,788 $ 33,088,416 $ 4,203,625

15.0% 9,266,320

78


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

MALDEN REVITALIZATION: ASSUMPTIONS RENT AND VACANCY RENT Malden Mall Site 1 Malden MallSite 2 Malden Mall Site 3 Premier Gym Premier Green Space Total

DEVELOPMENT COSTS Retail / SF Lot Size 86,150 13,215 22,840 11,810 21,860

Gross SF 175,570 13,215 24,860 20,520 21,860 256,025

Efficiency 85% 85% 85% 90% 100%

Net SF 149,235 11,233 21,131 18,468 21,860 221,926

Rent/YR/ GSF $ 27.50 $ 27.50 $ 27.50 $ 30.00 -

$ $ $ $ $

Annual 4,828,175 363,413 683,650 615,600 6,490,838

Annual Revenue Growth VACANCY Vacancy Bad Debt

3% Malden Mall 5.0% 0.5%

Premier 0.0% 0.5%

Total No. of Retail Spaces Malden Mall Site 1 Malden Mall Site 2 Malden Mall Site 3 Premier Gym Premier Green Space Total

No. of Floors Spaces/Floor 3.5 24 1 6 2 6 2 0 0 0

Total 84 6 12 0 0 102

EXPENSES Expense Ratio Annual increase in operating expenses Increase in real estate taxes OPERATING RESERVE Lease-Up Period (months) Average Occupancy During Lease-Up Estimated Rent During Lease-Up Estimated Operating Expenses During Lease-Up NOI During Lease Up Construction Interest During Lease-Up

15% 3% 3% Malden Mall 12 80% $ 4,700,190 $ 881,286 $ 3,818,904 $ 2,719,021

TAXABLE INCOME Income Tax Rate Depreciation Period (years)

Premier

$ $ $ $

0 100% -

35% 39

PROPERTY SALE Purchase Cap Rate Sale Cap Rate Percent of sale price for broker, lawyer, etc. Capital gains tax rate Accumulated depreciation recapture tax rate

Malden Mall 7.0% 6.0% 5% 20% 25%

Premier 7.0% 6.0% 5% 20% 25%

Malden Mall

Premier

CONSTRUCTION COSTS Hard Costs Soft Costs Developer Fee Total Construction Costs

$ 20% $ 2.5% $ $

Contingency

140.00 28.00 4.20 172.20

Gym / SF $ $ $ $

150.00 30.00 3.75 183.75

2.5% of hard costs

ACQUISITION PRICE Malde Mall SITE 1 (as-is value) Gross SF Net SF Rent/YR/NSF Annual Revenue Less Vacancy Less Expenses NOI

$ $ $ $

50.00 10.00 1.25 61.25

Site 1

20% 15%

Malden Mall Site 2

$ 24,579,800 $ 1,850,100 $ 4,915,960 $ 370,020 $ 737,394 $ 55,503 $ 30,233,154 $ 2,275,623 $

85%

Capitalized Value

$ $ $ $ $

614,495 $

15%

Gym

Premier Green Space

$ 3,480,400 $ 3,078,000 $ 696,080 $ 615,600 $ 104,412 $ 76,950 $ 4,280,892 $ 3,770,550

46,253 $

87,010 $

$

27,325 $

852,033

$ $ $ $ $

177,155 150,582 17.50 2,635,181 527,036 395,277 1,712,867

$ 24,469,534

$

54,512 99 6%

$ $ $ $ $ $ $

3.65% 115.03

543,502 7,764,311 4,280,892 3,483,419 856,178 2,627,240 95,894

85% $ $ $ $ $

20% 15%

Capitalized Value

32,000 27,200 17.50 476,000 95,200 71,400 309,400

$ 4,420,000 $

Total

$ 1,093,000 $ 34,081,300 $ 218,600 $ 6,816,260 $ 27,325 $ 1,001,584 $ 1,338,925 $ 41,899,144

76,950 $

177,155 150,582 17.50 2,635,181 527,036 395,277 1,712,867

20%

Premier (as-is-value) Gross SF Net SF Rent/YR/NSF Annual Revenue Less Vacancy Less Expenses NOI

Land Value Land Carry (12 months)

Site 3

$ 24,469,534

Malden Mall SITE 2 (lease) Price/YR (% of Annual Revenue) Term (years) Percent of Total Net Square Feet Malden Mall SITE 3 NOI Capitalized Value Construction Costs Residual Land Value Developer Profit Margin Land Land Carry (12 months) Land/sf

Green Space / SF

115.00 /sf 3.65%

$

54,512

$ $ $ $ $ $ $

543,502 7,764,311 4,280,892 3,483,419 856,178 2,627,240 95,894

$ $ $ $ $

32,000 27,200 17.50 476,000 95,200 71,400 309,400

$ 4,420,000

$ 1,358,150 $ 2,513,900 $ 3,872,050 $ 91,757 $ 91,757

DEBT Interest rates Construction Permanent Amortization (yrs) DCR Construction Period (months) Average Draw

4.5% 5.0% 30 1.2 12 65%

4.5% 5.0% 30 1.2 12 65%

TOTAL DEVELOPMENT COSTS Construction Costs Contingency Acquisiton Total Development Costs before Interest and Operating Reserve Malden Mall Premier

$ 30,233,154 $ 2,275,623 $ 614,495 $ 46,253 $ 24,469,534 $ 54,512 $ 55,317,183 $ 2,376,387

$ 4,280,892 $ 3,770,550 $ 1,338,925 $ 41,899,144 $ 87,010 $ 76,950 $ 27,325 $ 852,033 $ 2,723,135 $ 4,420,000 $ 2,605,657 $ 34,272,838 $ 7,091,037 $ 8,267,500 $ 3,971,907 $ 77,024,015 $ 64,784,607 $ 12,239,407

Estimated Construction Loan Interest First Year Operating Reserve

Malden Mall Premier Gym $ 1,767,364 $ 196,829 $ (1,099,883) $ -

TOTAL DEVELOPMENT COSTS

$ 65,452,088 $ 12,436,236

79


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

DOWNTOWN REVITALIZATION: PRO-FORMA NOI NOI REVENUE Malden Mall Factor Premier Gym Factor Annual Gross Potential Revenue Less: Vacancy 5% 0% Less: Bad Debt 0.5% 0.5% Effective Gross Revenue Malden Mall Premier EXPENSES Annual Expenses Malden Mall Premier

15%

NOI Annual NOI Malden Mall Premier

DEBT CALCULATION Debt Based on DCR Monthly NOI Maximum DCR Maximum Monthly Payment Maximum Loan CASH FLOW AFTER FINANCING NOI Less: Annual Debt Service Less: CapEx Cash Flow After Financing

$ $ $ $

Malden Mall Site 2 363,413 18,170.63 1,817 343,425

724,226

$

3,838,399

$

$ $ $ $

Site 1 4,828,175 241,409 24,141 4,562,625

15% $

$

Premier Gym Open Space 615,600 $ $ 3,078 $ 612,522 $ -

$ $ $ $

Site 3 683,650 34,183 3,418 646,049

$ $ $ $

54,512

$

102,548

$

92,340

$

288,913

$

543,502

$

520,182

$

Total 6,490,838 293,762 32,454 6,164,621 5,552,099 612,522

-

$ $ $

973,626 881,286 92,340

-

$ $ $

5,190,996 4,670,814 520,182

$ $

Malden Mall 389,234.48 1.2 324,362 60,422,691

$ $ $ $

4,670,814 3,892,345 28,025 750,444

$

0.6%

$ $ $ $ $ $

SIMPLE RATIOS Overall Return (NOI/Dev. Cost)

$ $ $

$ $ $ $

7.2%

Premier 43,348.50 1.2 36,124 6,729,191

520,182 433,485 3,121.09 83,576

4.3%

CASH-ON-CASH RETURN NOI Annual Debt Service Cash Throw-Off

$ $ $

4,670,814 3,892,345 778,469

$ $ $

520,182 433,485 86,697

Development Cost Permanent Mortgage Equity

$ $ $

64,784,607 60,422,691 4,361,916

$ $ $

12,239,407 6,729,191 5,510,217

Cash-on-Cash Return

17.8%

1.6%

80


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

DOWNTOWN REVITALIZATION: SOURCES AND USES

Total

Year 0

Year 1

Year 2

Total

USES MALDEN MALL Total Development Costs Construction Loan: Capitalized Interest

$ $

64,884,500 $ 1,925,219 $

27,247,181 $ 34,227,030 124,975 $ 1,800,244

$ $

3,410,290 -

Total Capital Costs

$

66,809,719 $

27,372,156 $ 36,027,273

$

Cash Flow from Operations NOI Less: Construction Loan Interest during Operations Cash Flow from Operations after Interest

$ $ $

4,009,850 $ 2,697,668 $ 1,312,181 $

$ $ $

Construction Loan Balance to Be Refinanced

$

-

TOTAL USES

$

65,497,538

PREMIER Total Development Costs Construction Loan: Capitalized Interest

$ $

12,239,407 $ 98,844 $

Total Capital Costs

$

12,338,252 $

Cash Flow from Operations NOI Less: Construction Loan Interest during Operations Cash Flow from Operations after Interest

$ $ $

-

$ $ $

-

$ $ $

-

Construction Loan Balance to Be Refinanced

$

-

$

-

$

-

TOTAL USES

$

12,338,252

TOTAL Total Development Costs Construction Loan: Capitalized Interest

$ $

77,123,908 $ 2,024,063 $

$ $

79,147,971 $ $

Cash Flow from Operations NOI Less: Construction Loan Interest during Operations Cash Flow from Operations after Interest

$ $ $

4,009,850 $ 2,697,668 $ 1,312,181 $

-

$ $ $

Construction Loan Balance to Be Refinanced

$

-

-

$

TOTAL USES

$

Total Capital Costs

77,835,790

$

$

$ $

-

$ $ $

-

27,372,156 $ 36,027,273

Year 2

$ 57,836,027 $

22,217,784

$

34,227,030 $

1,391,213

Net Accrued Interest Net Construction Loan Funding

$ 2,586,664 $ $ 60,422,691 $

124,975 22,342,759

$ $

1,800,244 $ 36,027,273 $

661,445 2,052,658

4,009,850 2,697,668 1,312,181

Equity Additional Equity Required Permanent Mortgage Refinancing Less: Positive Cash Flow after Interest—Distributed Less: Cash Proceeds from Construction Loan Takeout

$ $ $ $ $

5,029,397 -

$ $

-

$

-

$ 65,497,538

2,098,109

TOTAL SOURCES

7,025,657 7,933

$ $

5,213,750 90,911

PREMIER Construction Loan Funding Net Draws

7,033,591

$

5,304,661

Net Accrued Interest Net Construction Loan Funding Equity Additional Equity Required Permanent Mortgage Refinancing Less: Positive Cash Flow after Interest—Distributed Less: Cash Proceeds from Construction Loan Takeout

$ $ $ $ $

5,029,397 $ 3,357,037 $ (3,311,586) $ -

-

$

$ $ $ $ $

3,357,037 (3,311,586) -

36,027,273 $

2,098,109

$

27,372,156

$

6,624,119 $

1,410,369

$

5,213,750

$ $

98,844 $ 6,722,963 $

7,933 1,418,302

$ $

90,911 5,304,661

5,615,288 -

$ $ $ $ $

5,615,288 -

$ $ $ $ $

$ 12,338,252

$

7,033,591

$

5,304,661

-

$

5,304,661

TOTAL SOURCES

34,272,838 $ 34,227,030 132,908 $ 1,800,244

$ $

8,624,040 90,911

TOTAL Construction Loan Funding Net Draws

$ 64,460,146 $

23,628,153

$

34,227,030 $

6,604,963

34,405,747 $ 36,027,273 $ -

$ $

8,714,951 -

Net Accrued Interest Net Construction Loan Funding

$ 2,685,509 $ $ 67,145,654 $

132,908 23,761,061

$ $

1,800,244 $ 36,027,273 $

752,356 7,357,319

-

$ $ $

4,009,850 2,697,668 1,312,181

-

$

Equity Additional Equity Required Permanent Mortgage Refinancing Less: Positive Cash Flow after Interest—Distributed Less: Cash Proceeds from Construction Loan Takeout

$ 10,644,685 $ $ 3,357,037 $ $ $ $ (3,311,586) $ $ $

10,644,685 -

$ $ $ $ $

TOTAL SOURCES

$ 77,835,790

$

34,405,747

$

5,615,288 5,615,288

34,405,747 $ 36,027,273

$

7,402,770

MALDEN MALL Check: Equity for Capital Investment

-

$ $ $ $ $

3,357,037 (3,311,586) -

36,027,273 $

7,402,770

PREMIER Check: Equity for Capital Investment

Equity Sources + Cash Flow from Operations - Positive Cash Flow After Interests Total Capital Costs - Loan Sources

$ $

Construction Loan Takeout at Stabilization Permanent Mortgage Amount for Income Property Construction Loan Ending Balance for Income Property Cash Proceeds from Construction Loan Takeout

$ $ $

Depreciable Basis Total Development Cost Excluding Interest Interest Accrued During Construction Period Total Capital Costs Land Cost Depreciable Basis

$ $ $ $ $

Annual Depreciation Estimate Depreciation Period (years) Acceleration Factor Annual Depreciation

Year 1

3,410,290

$

7,033,591

Year 0

SOURCES MALDEN MALL Construction Loan Funding Net Draws

$

Equity Sources + Cash Flow from Operations - Positive Cash Flow After Interests Total Capital Costs - Loan Sources

$ $

5,615,288 $ 5,615,288 $

60,422,691 60,422,691 -

Construction Loan Takeout at Stabilization Permanent Mortgage Amount for Income Property Construction Loan Ending Balance for Income Property Cash Proceeds from Construction Loan Takeout

$ $ $

6,722,963 6,722,963 -

64,884,500 1,925,219 66,809,719 16,408,956 50,400,764

Depreciable Basis Total Development Cost Excluding Interest Interest Accrued During Construction Period Total Capital Costs Land Cost Depreciable Basis

$ 12,239,407 $ 98,844 $ 12,338,252 $ 3,872,050 $ 8,466,202

5,074,847 $ 5,074,847 $

39 1 1,292,327

5,029,397 $ 5,029,397 $

-

$ $

45,450 45,450

Annual Depreciation Estimate Depreciation Period (years) Acceleration Factor Annual Depreciation

$

$ $

-

39 1 217,082

81


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

DOWNTOWN REVITALIZATION: DEVELOPMENT AND OPERATING PERIOD PRO-FORMA PROJECT COSTS Development Costs Land Cost

Site 1 $ 55,317,183 $ $ 9,909,665 $

Malden Mall Site 2 2,376,387 $ $

FINANCING ASSUMPTIONS Equity Mortage Principal Interest Rate Amortization Annual Debt Service

$ $

$

DEPRECIATION ASSUMPTIONS Building Basis Life (in years) Acceleration Factor Straight Line MORTGAGE CALCULATION MALDEN MALL Beginning Balance Ending Balance Amortization of Principal Interest/Annual Payment PREMIER Beginning Balance Ending Balance Amortization of Principal Interest/Annual Payment TOTAL Beginning Balance Ending Balance Amortization of Principal Interest/Annual Payment DEPRECIATION CALCULATION MALDEN MALL Beginning Balance Less: Annual Depreciation Ending Balance Cumulative Depreciation Taken Cumulative Straight Line Recapture Remaining Book Value PREMIER Beginning Balance Less: Annual Depreciation Ending Balance Cumulative Depreciation Taken Cumulative Straight Line Recapture Remaining Book Value TOTAL Beginning Balance Less: Annual Depreciation Ending Balance Cumulative Depreciation Taken Cumulative Straight Line Recapture Remaining Book Value

$

$ Year 0

Premier Site 3

Gym 7,091,037 $ 2,627,240 $

Green Space Total 8,267,500 $ 1,366,250 $ 74,418,357 1,358,150 $ 2,513,900 $ 16,408,956

Malden Mall 4,361,916 $ 60,422,691 $ 5.0% 30 3,892,345 $

Premier 5,510,217 6,729,191 5.0% 30 433,485

Malden Mall 52,247,702 $ 39 1 1,339,685 $

Premier 2,376,387 39 1 60,933

Year 1 DEVELOPMENT PERIOD

Year 2 LEASE-UP PERIOD

$ 60,422,691

5.0% $

Year 3

Year 4

Year 5

$ 60,422,691 $ 59,531,236 $ $ 59,531,236 $ 58,594,172 $ $ 891,455 $ 937,064 $ $ 3,000,889 $ 2,955,281 $

3,892,345

Year 6 INVESTMENT PERIOD 58,594,172 $ 57,609,166 $ 57,609,166 $ 56,573,765 $ 985,006 $ 1,035,401 $ 2,907,339 $ 2,856,944 $

DEVELOPMENT PERIOD $

6,722,963

5.0% $

$

$ $ $ $

433,084

4,325,429 Year 0

Year 1 DEVELOPMENT PERIOD $ $ $ $ $ $ $

Year 2 LEASE-UP PERIOD 50,400,764 1,292,327 49,108,436 1,292,327 1,292,327 1,292,327 49,108,436

6,722,963 6,722,963 (0) 433,084

$ $ $ $

$ $ $ $

$ $ $ $

Year 5

$ 49,108,436 $ 47,816,109 $ $ 1,292,327 $ 1,292,327 $ $ 47,816,109 $ 46,523,782 $ $ 2,584,655 $ 3,876,982 $ $ 2,584,655 $ 3,876,982 $ $ 2,584,655 $ 3,876,982 $ $ 47,816,109 $ 46,523,782 $

Year 6 INVESTMENT PERIOD 46,523,782 $ 45,231,455 $ 1,292,327 $ 1,292,327 $ 45,231,455 $ 43,939,127 $ 5,169,309 $ 6,461,636 $ 5,169,309 $ 6,461,636 $ 5,169,309 $ 6,461,636 $ 45,231,455 $ 43,939,127 $

8,466,202 217,082 8,249,120 217,082 217,082 217,082 8,249,120

$ $ $ $ $ $ $

8,249,120 217,082 8,032,037 434,164 434,164 434,164 8,032,037

$ $ $ $ $ $ $

8,032,037 217,082 7,814,955 651,246 651,246 651,246 7,814,955

$ 57,574,638 $ 56,065,229 $ 54,555,819 $ 1,509,409 $ 1,509,409 $ 1,509,409 $ 56,065,229 $ 54,555,819 $ 53,046,410 $ 2,801,737 $ 4,311,146 $ 5,820,555 $ 2,801,737 $ 4,311,146 $ 5,820,555 $ 2,801,737 $ 4,311,146 $ 5,820,555 $ 56,065,229 $ 54,555,819 $ 53,046,410

$ $ $ $

Year 7 43,939,127 1,292,327 42,646,800 7,753,964 7,753,964 7,753,964 42,646,800

$ $ $ $

Year 8

6,173,612 6,046,318 127,294 305,790

$ $ $ $

Year 9

$ 42,646,800 $ 41,354,473 $ $ 1,292,327 $ 1,292,327 $ $ 41,354,473 $ 40,062,146 $ $ 9,046,291 $ 10,338,618 $ $ 9,046,291 $ 10,338,618 $ $ 9,046,291 $ 10,338,618 $ $ 41,354,473 $ 40,062,146 $

6,046,318 5,912,511 133,807 299,277

Year 12

$ 51,874,629 $ 50,545,838 $ 1,328,791 $ 2,563,554

$ $ $ $

SALE 5,912,511 5,771,859 140,653 292,431

Year 10 SALE 40,062,146 1,292,327 38,769,818 11,630,945 11,630,945 11,630,945 38,769,818

Year 11 $ $ $ $ $ $ $

38,769,818 1,292,327 37,477,491 12,923,273 12,923,273 12,923,273 37,477,491

Year 12

7,163,709 217,082 6,946,627 1,519,575 1,519,575 1,519,575 6,946,627

$ $ $ $ $ $ $

6,946,627 217,082 6,729,545 1,736,657 1,736,657 1,736,657 6,729,545

$ $ $ $ $ $ $

SALE 6,729,545 217,082 6,512,463 1,953,739 1,953,739 1,953,739 6,512,463

$ $ $ $ $ $ $

6,512,463 217,082 6,295,381 2,170,821 2,170,821 2,170,821 6,295,381

$ 53,046,410 $ 51,537,001 $ 50,027,591 $ 48,518,182 $ 1,509,409 $ 1,509,409 $ 1,509,409 $ 1,509,409 $ 51,537,001 $ 50,027,591 $ 48,518,182 $ 47,008,772 $ 7,329,965 $ 8,839,374 $ 10,348,783 $ 11,858,193 $ 7,329,965 $ 8,839,374 $ 10,348,783 $ 11,858,193 $ 7,329,965 $ 8,839,374 $ 10,348,783 $ 11,858,193 $ 51,537,001 $ 50,027,591 $ 48,518,182 $ 47,008,772

$ $ $ $ $ $ $

47,008,772 1,509,409 45,499,363 13,367,602 13,367,602 13,367,602 45,499,363

$ $ $ $ $ $ $

45,499,363 1,509,409 43,989,954 14,877,012 14,877,012 14,877,012 43,989,954

$ $ $ $ $ $ $

6,512,463 217,082 6,295,381 2,170,821 2,170,821 2,170,821 6,295,381

$ $ $ $ $ $ $

INVESTMENT PERIOD 7,814,955 $ 7,597,873 217,082 $ 217,082 7,597,873 $ 7,380,791 868,328 $ 1,085,410 868,328 $ 1,085,410 868,328 $ 1,085,410 7,597,873 $ 7,380,791

6,294,711 6,173,612 121,099 311,985

Year 11

5,771,859 5,624,010 147,849 285,235

$ $ $ $ $ $ $

50,400,764 1,292,327 49,108,436 1,292,327 1,292,327 1,292,327 49,108,436

$ 55,485,391 $ 54,341,334 $ $ 54,341,334 $ 53,138,745 $ $ 1,144,057 $ 1,202,589 $ $ 2,748,288 $ 2,689,756 $

Year 10 SALE 53,138,745 51,874,629 1,264,116 2,628,229

$ 67,145,654 $ 66,254,199 $ 65,217,947 $ 64,128,678 $ 62,983,680 $ 61,780,102 $ 60,514,946 $ 59,185,063 $ 57,787,140 $ $ 66,254,199 $ 65,217,947 $ 64,128,678 $ 62,983,680 $ 61,780,102 $ 60,514,946 $ 59,185,063 $ 57,787,140 $ 56,317,697 $ $ 891,455 $ 1,036,252 $ 1,089,269 $ 1,144,998 $ 1,203,578 $ 1,265,156 $ 1,329,883 $ 1,397,923 $ 1,469,443 $ $ 3,433,973 $ 3,289,176 $ 3,236,160 $ 3,180,431 $ 3,121,850 $ 3,060,273 $ 2,995,545 $ 2,927,506 $ 2,855,986 $

DEVELOPMENT PERIOD

$ $ $ $ $ $ $

INVESTMENT PERIOD 6,519,512 $ 6,409,915 6,409,915 $ 6,294,711 109,597 $ 115,204 323,487 $ 317,879

Year 9

5,771,859 5,624,010 147,849 285,235

Year 4

6,623,775 6,519,512 104,263 328,821

56,573,765 55,485,391 1,088,374 2,803,971

Year 8

$ $ $ $

Year 3

6,722,963 6,623,775 99,188 333,896

Year 7

$ $ $ $ $ $ $

7,380,791 217,082 7,163,709 1,302,493 1,302,493 1,302,493 7,163,709

$ $ $ $ $ $ $

82


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

ANNUAL CASH FLOWS MALDEN MALL Gross Potential Revenue Less: Vacancy Vacancy Rate Less: Bad Debt Effective Gross Revenue Total Operating Expenses Less: Site 2 Land Lease

Year 0 3.0% 5.0% 0.5%

3.0% 15.0%

Year 1 DEVELOPMENT PERIOD $ $ 70.0% $ $ -

$ $ $ $

Year 2 LEASE-UP PERIOD 5,875,238 (954,726) 16.3% (29,376.2) 4,891,135.2

Year 3 $ $

6,051,495 (302,575) 5.0% $ (30,257.5) $ 5,718,662.4

$ $

$ (54,512) $

Net Operating Income Less: Construction Loan Interest During Operating Period Less: Annual Debt Service Add: Operating Reserve Funded by Construction Loan

$ $

(54,512) $ $

Before-Tax Operating Cash Flow

$

(54,512) $

1,266,800 $

Taxes

$

-

-

After-Tax Operating Cash Flow

$

(54,512) $

$

$

Year 4

(881,286) $ (45,381) $

Year 5

$ $

6,233,039 (311,652) 5.0% $ (31,165.2) $ 5,890,222.3

(907,724) $ (53,059) $

$ $ $ $

(934,956) $ (54,651) $

Year 6 Year 7 INVESTMENT PERIOD 6,420,031 $ 6,612,632 $ 6,811,011 (321,002) $ (330,632) $ (340,551) 5.0% 5.0% 5.0% (32,100.2) $ (33,063.2) $ (34,055.1) 6,066,929.0 $ 6,248,936.8 $ 6,436,404.9 (963,005) $ (56,290) $

Year 8 $ $

7,015,341 (350,767) 5.0% $ (35,076.7) $ 6,629,497.1

Year 9 $ $

7,225,801 (361,290) 5.0% $ (36,129.0) $ 6,828,382.0

$ $ $ $

Year 11

Year 12

$ $

7,665,852 (383,293) 5.0% $ (38,329.3) $ 7,244,230.5

(991,895) $ (1,021,652) $ (1,052,301) $ (1,083,870) $ (1,116,386) $ (1,149,878) (57,979) $ (59,719) $ (61,510) $ (63,355) $ (65,256) $ (67,214)

3,964,468 $ 4,757,879 $ 4,900,615 $ 5,047,634 $ 5,199,063 $ 5,355,035 $ 5,515,686 $ 5,681,156 $ 5,851,591 $ 6,027,139 (2,697,668) $ (3,892,345) $ (3,892,345) $ (3,892,345) $ (3,892,345) $ (3,892,345) $ (3,892,345) $ (3,892,345) $ (3,892,345) $ (3,892,345) 865,534 $ 1,008,271 $ 1,155,289 $ 1,306,718 $ 1,462,690 $ 1,623,341 $ 1,788,812 $ 440,558 $

134,618 $

228,553 $

296,789 $

367,427 $

594,676 $

675,862

1,266,800 $

730,916 $

779,718 $

858,500 $

939,291 $ 1,022,132 $ 1,107,066 $ 1,194,136 $

1,283,384

634,068 (3,170) 630,898

653,090 (3,265) 649,825

3.0% 0.0% 0.5%

DEVELOPMENT PERIOD $ $ $ $ -

$ $ $ $

615,600 (3,078) 612,522

Total Operating Expenses

3.0%

$

-

$

(92,340) $

(95,110) $

(97,964) $

(100,902) $

(103,929) $

(107,047) $

(110,259) $

Net Operating Income Less: Construction Loan Interest During Operating Period Less: Annual Debt Service Add: Operating Reserve Funded by Construction Loan

$ $ $ $

-

$

520,182 $

535,787 $

551,861 $

568,417 $

585,469 $

603,034 $

$

(433,084) $

(433,084) $

(433,084) $

(433,084) $

(433,084) $

Before-Tax Operating Cash Flow

$

-

$

87,098 $

102,704 $

118,777 $

135,333 $

152,386 $

Taxes

$

-

$

-

-

-

-

-

After-Tax Operating Cash Flow

$

-

$

87,098 $

TOTAL Gross Potential Revenue Less: Vacancy Less: Bad Debt Effective Gross Revenue

$ $ $ $

-

$ $ $ $

Total Operating Expenses

$

-

$

Net Operating Income

$

(54,512) $

3,964,468 $

Before-Tax Operating Cash Flow

$

(54,512) $

1,266,800 $

Taxes

$

-

After-Tax Operating Cash Flow

$

(54,512) $

5,875,238 (954,726) (29,376) 4,891,135

6,667,095 (302,575) (33,335) 6,331,184

$

$ $ $ $

$ $ $ $

$

102,704 $

$ $ $ $

$

118,777 $

$ $ $ $

135,333 $

$ $ $ $

803,218 (4,016) 799,202

(113,567) $

(116,974) $

(120,483)

621,125 $

639,758 $

658,951 $

678,720

(433,084) $

(433,084) $

(433,084) $

(433,084) $

(433,084)

169,950 $

188,041 $

206,674 $

225,867

$

4,587 $

34,388 $

43,190 $

52,303

152,386 $

165,363 $

153,652 $

163,485 $

173,564

5,767,480 $

$ $ $ $

$ $ $ $

$ $ $ $

757,110 (3,786) 753,325

8,199,685 (372,129) (40,998) 7,786,558

$ $ $ $

$ $ $ $

8,445,676 (383,293) (42,228) 8,020,155

6,491,349 $

6,686,090 $

952,632 $ 1,110,974 $ 1,274,066 $ 1,442,051 $ 1,615,076 $ 1,793,291 $ 1,976,852 $

2,165,921 $

225,867

440,558 $

6,118,719 $

7,960,860 (361,290) (39,804) 7,559,765

$ $ $ $

6,302,281 $

367,427 $

5,940,504 $

7,728,990 (350,767) (38,645) 7,339,578

735,059 (3,675) 731,383

SALE 779,824 (3,899) 775,925

$ $ $ $

7,503,874 (340,551) (37,519) 7,125,804

$ $ $ $

(120,483)

5,599,495 $

7,285,314 (330,632) (36,427) 6,918,256

713,649 (3,568) 710,081

(881,286) $ (1,000,064) $ (1,030,066) $ (1,060,968) $ (1,092,797) $ (1,125,581) $ (1,159,348) $ (1,194,129) $ (1,229,953) $ (1,266,851) $ 5,436,403 $

7,073,121 (321,002) (35,366) 6,716,754

$

$ $ $ $

803,218 (4,016) 799,202

5,278,061 $

6,867,107 (311,652) (34,336) 6,521,120

$ $ $ $

$ $ $ $

-

$ $ $ $

$ $ $ $

INVESTMENT PERIOD 672,683 $ 692,863 - $ (3,363) $ (3,464) 669,319 $ 689,399

516,275 $

1,959,246

$

PREMIER Gross Potential Revenue Less: Vacancy Less: Bad Debt Effective Gross Revenue

$

Year 10 SALE 7,442,575 (372,129) 5.0% (37,212.9) 7,033,233.5

$

134,618 $

228,553 $

296,789 $

520,862 $

629,064 $

719,052 $

52,303

1,266,800 $

818,014 $

882,422 $

977,278 $ 1,074,624 $ 1,174,518 $ 1,272,429 $ 1,347,788 $

1,446,869 $

173,564

678,720

Development and Operating ProForma Page 2/4

83


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

INCOME TAX CALCULATION MALDEN MALL Net Operating Income Deduct: Interest Deduct: Depreciation Taxable Income/(Loss) Passive Loss Offset

Year 0

Taxable Income Passive Loss Carryforward Annual Income Taxes

35%

PREMIER Net Operating Income Deduct: Interest Deduct: Depreciation Taxable Income/(Loss) Passive Loss Offset Taxable Income Passive Loss Carryforward Annual Income Taxes SALE CALCULATION (INCLUDING TAX) Cash Flow from Sale Sale Price (cap rate applied to following year NOI) Less: Commission Adjusted Sales Price Less: Remaining Mortgage Balance Before-Tax Cash Flow from Sale

35%

Year 1 DEVELOPMENT PERIOD $ (54,512) $ $ $ (54,512) $ -

$ $ $ $ $

Year 2 LEASE-UP PERIOD 3,964,468 (2,697,668) (1,292,327) (25,527) -

Year 3 $ $ $ $ $

4,757,879 (3,000,889) (1,292,327) 464,662 (80,039.05)

Year 4

Year 5

$ 4,900,615 $ $ (2,955,281) $ $ (1,292,327) $ $ 653,007 $ $ $

Year 6 INVESTMENT PERIOD 5,047,634 $ 5,199,063 $ (2,907,339) $ (2,856,944) $ (1,292,327) $ (1,292,327) $ 847,968 $ 1,049,792 $ $ $

Year 7 5,355,035 (2,803,971) (1,292,327) 1,258,737 -

Year 8 $ $ $ $ $

5,515,686 (2,748,288) (1,292,327) 1,475,071 -

Year 9 $ $ $ $ $

5,681,156 (2,689,756) (1,292,327) 1,699,074 -

$ $ $ $ $

Year 10 SALE 5,851,591 (2,628,229) (1,292,327) 1,931,035 1,931,035 -

$ $

$ (54,511.88) $

$ (80,039.05) $

384,623 $ $

653,007 $ $

847,968 $ 1,049,792 $ 1,258,737 $ 1,475,071 $ 1,699,074 $ $ $ $ $ $

$

-

-

$

134,618 $

228,553 $

296,789 $

$ $ $ $ $ $ $ $ $ $

520,182 (433,084) (217,082) (129,984) (129,984) -

535,787 (333,896) (217,082) (15,190) (145,174) -

551,861 (328,821) (217,082) 5,958 (5,958) (139,216) -

$

DEVELOPMENT PERIOD $ $ $ $ $ $ $ $ $ $ -

$ $ $ $ $ $ $ $ $ $

$ $ $ $ $ $ $ $ $ $

$ $ $ $ $ $ $ $ $ $

367,427 $

440,558 $

INVESTMENT PERIOD 568,417 $ 585,469 (323,487) $ (317,879) (217,082) $ (217,082) 27,848 $ 50,508 (27,848) $ (50,508) $ $ (111,368) $ (60,860) $ $ -

$ $ $ $ $ $ $ $ $ $

516,275 $

594,676 $

675,862

603,034 (311,985) (217,082) 73,966 (60,860) 13,106 4,587

621,125 (305,790) (217,082) 98,253 98,253 34,388

639,758 (299,277) (217,082) 123,399 123,399 43,190

$ $ $ $ $ $ $ $ $ $

$ $ $ $ $ $ $ $ $ $

Year 11

$ $ $ $ $ $ $ $ $ $

SALE 658,951 (292,431) (217,082) 149,438 149,438 52,303

MALDEN MALL SALEPREMIER SALE $ $ $ $ $

11,311,992 565,600 10,746,392 5,771,859 4,974,534

Total Tax at Sale

$ 11,913,523 $

944,473

After-Tax Cash Flow from Sale

$ 31,641,547 $ 4,030,061

Tax Calculation from Sale Adjusted Sales Price Remaining Book Value Total Taxable Gain Passive Loss Carryforward Total Net Taxable Gain

$ $ $ $ $

6.00% 5%

$ 100,452,315 $ 5,022,616 $ 95,429,699 $ 51,874,629 $ 43,555,070

95,429,699 38,769,818 56,659,881 56,659,881

$ $ $ $ $

10,746,392 6,512,463 4,233,930 4,233,930

Total Depreciation Taken Recapture Tax

25%

$ 11,630,945 $ 1,953,739 $ 2,907,736 $ 488,435

Capital Gain Tax on Capital Gain

20%

$ 45,028,935 $ 2,280,191 $ 9,005,787 $ 456,038

Total Tax at Sale

Year 12

$ 11,913,523 $

944,473

Development and Operating ProForma Page 3/4

84


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

RETURN MEASURES Unleveraged IRR Project Cost Net Operating Income Adjusted Sales Price Unleveraged Cash Flow Unleveraged IRR Net Present Value

Year 0

8% $

Year 3

Year 4

Year 5

Year 6

Year 7

Year 8

Year 9

6,302,281 $ 6,491,349 $ 6,686,090 $ 95,429,699 $ 10,746,392 6,302,281 $ 101,921,048 $ 17,432,482

$ (64,884,500) $ $

(12,239,407) (54,512) $

3,964,468 $

5,278,061 $

5,436,403 $

5,599,495 $

5,767,480 $

5,940,504 $

6,118,719 $

$ (64,884,500) $

(12,293,919) $

3,964,468 $

5,278,061 $

5,436,403 $

5,599,495 $

5,767,480 $

5,940,504 $

6,118,719 $

$ (8,386,433) $ $

(5,615,288) (54,512) $

1,266,800 $

952,632 $

1,110,974 $

1,274,066 $

1,442,051 $

1,615,076 $

1,793,291 $

$ (8,386,433) $

(5,669,800) $

1,266,800 $

952,632 $

1,110,974 $

1,274,066 $

1,442,051 $

1,615,076 $

1,793,291 $

$ (8,386,433) $ $

(5,615,288) (54,512) $

1,266,800 $

818,014 $

882,422 $

977,278 $

1,074,624 $

1,174,518 $

1,272,429 $

$ (8,386,433) $

(5,669,800) $

1,266,800 $

818,014 $

882,422 $

977,278 $

1,074,624 $

1,174,518 $

1,272,429 $

Year 10

Year 11

1,976,852 $ 2,165,921 $ $ 43,555,070 $ 1,976,852 $ 45,720,991 $

225,867 4,974,534 5,200,401

1,347,788 $ 1,446,869 $ $ 31,641,547 $ 1,347,788 $ 33,088,416 $

173,564 4,030,061 4,203,625

19.0% 8% $ 17,106,690

After-Tax IRR Equity After-Tax Operating Cash Flow After-Tax Cash Flow from Sale Total After-Tax Cash Flow After-Tax IRR Net Present Value

Year 2

9.2% 7,372,709

Before-Tax IRR Equity Before-Tax Operating Cash Flow Before-Tax Cash Flow from Sale Total Before-Tax Cash Flow Before-Tax IRR Net Present Value

Year 1

8% $

15.0% 9,266,320

Development and Operating ProForma Page 4/4

85


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

DOWNTOWN REVITALIZATION: DEVELOPMENT PERIOD CASH FLOWS DEVELOPMENT COSTS MALDEN MALL Acquisition Land Carry Site 2 Land Lease Hard Costs Soft Costs Contingency Developer Fee Total Development Costs, Excl. Constr. Loan Interest and Operating Reserve

Data

Total

Time Zero

Year 1 Total

45,381 2,991,030 373,879 3,410,290

$ 27,151,287 $ 27,151,287 $ 27,151,287 $ 95,894 $ 95,894 $ 95,894 15% $ 54,512 $ 99,893 $ $ 29,910,300 $ 29,910,300 $ $ 5,982,060 $ 5,982,060 $ $ 747,758 $ 747,758 $ $ 897,309 $ 897,309 $ $ 64,839,119 $ 64,884,500 $ 27,247,181

Total Development Costs, Excl. Constr. Loan Interest and Operating Reserve

$ 6,933,900 $ 91,757 $ 4,171,000 $ 834,200 $ 104,275 $ 104,275 $ 12,239,407

6,933,900 91,757 7,025,657

$ $ $ $ $ $ $

4,171,000 834,200 104,275 104,275 5,213,750

TOTAL Acquisition Land Carry Site 2 Land Lease Hard Costs Soft Costs Contingency Developer Fee Total Development Costs, Excl. Constr. Loan Interest and Operating Reserve

$ 34,085,187 $ 34,085,187 $ 34,085,187 $ 187,652 $ 187,652 $ 187,652 $ 54,512 $ 99,893 $ $ 34,081,300 $ 34,081,300 $ $ 6,816,260 $ 6,816,260 $ $ 852,033 $ 852,033 $ $ 1,001,584 $ 1,001,584 $ $ 77,078,527 $ 77,123,908 $ 34,272,838

$ $ $ $ $ 54,512 $ $ 29,910,300 $ $ 2,991,030 $ $ 373,879 $ $ 897,309 $ $ 34,227,030 $

45,381 4,171,000 3,825,230 478,154 104,275 8,624,040

PREMIER Acquisition Land Carry Hard Costs Soft Costs Contingency Developer Fee

$ 6,933,900 $ 91,757 $ 4,171,000 $ 834,200 $ 104,275 $ 104,275 $ 12,239,407

Quarter 3

Quarter 4

Quarter 5

Quarter 6

$ $ $ $ $ $ $

$ $ $ $ $ $

13,628 7,477,575 747,758 93,470 224,327 8,556,757

$ $ $ $ $ $

13,628 7,477,575 747,758 93,470 224,327 8,556,757

$ $ $ $ $ $

13,628 7,477,575 747,758 93,470 224,327 8,556,757

102

5% 3% $

3%

1,468,809 $ $ 0.5% $ $ 15% $ $

5,875,238 (954,726) (29,376) 4,891,135 (881,286) 4,009,850

$ $ $ $ $ $

61.2 61.2 70.0% 0.0% 70.0% -

$ $ $ $ $ $

$ (60,874,651) $ (27,247,181) $ (34,227,030) $

40.8 102 15.0% 5.0% 16.3% 5,875,238 (954,726) (29,376) 4,891,135 (881,286) 4,009,850

Quarter 7

$ $ $ $ $ $

13,628 7,477,575 747,758 93,470 224,327 8,556,757

13,628 7,477,575 747,758 93,470 224,327 8,556,757

$ $ $ $ $ $

13,628 7,477,575 747,758 93,470 224,327 8,556,757

$ $ $ $ $ $

13,628 7,477,575 747,758 93,470 224,327 8,556,757

Quarter 9

Quarter 10

$ $ $ $ $ $

13,628 7,477,575 747,758 93,470 224,327 8,556,757

9,017.17 $

10,834 $

12,651 $

$ $

747,758 $ 93,470 $

747,758 $ 93,470 $

747,758 $ 93,470 $

747,758 93,470

$

850,244 $

852,061 $

853,878 $

854,106 $

$ $ $ $ $ $

9,017 747,758 93,470 850,244

$ $ $ $ $ $

10,834 747,758 93,470 852,061

$ $ $ $ $ $ $ $

12,878 $

$ $ $ $ $ $

599,560 $ (8,556,757) $ (8,556,757) $ (8,556,757) $ (8,556,757) $

13.6 74.8 33.3% 0.0% 33.3% 1,468,809 (489,603) (7,344) 971,862 (220,321) 751,541

$ $ $ $ $ $

(98,704) $

13.6 88.4 20.0% 0.0% 20.0% 1,468,809 (293,762) (7,344) 1,167,703 (220,321) 947,382

$ $ $ $ $ $

95,321 $

3% $ $

3%

-

$ $ $ $ $ $

-

$ $ $ $ $ $

Net Cash Flow Before Debt During First Two Years

$ (12,239,407) $ (7,025,657)

TOTAL Gross Potential Revenue Vacancy Loss Bad Debt Effective Gross Revenue Operating Expenses NOI

$ $ $ $ $ $

Net Cash Flow Before Debt During First Three Years

$ (73,114,058) $ (34,272,838) $ (34,227,030) $ (4,614,190) $ (8,556,757) $ (8,556,757) $ (8,556,757) $ (8,556,757) $

5,875,238 (954,726) (29,376) 4,891,135 (881,286) 4,009,850

$ (5,213,750)

$ $ $ $ $ $

-

$ $ $ $ $ $

5,875,238 (954,726) (29,376) 4,891,135 (881,286) 4,009,850

$ $ $ $ $ $

1,468,809 (489,603) (7,344) 971,862 (220,321) 751,541

$ $ $ $ $ $

(98,704) $

1,468,809 (293,762) (7,344) 1,167,703 (220,321) 947,382

13,265 $

13,265 $

53,059

13,265 $

13,265 $

13,265 $

13,265 $

53,059

DEVELOPMENT PERIOD $ $ 2,085,500 $ 2,085,500 417,100 $ 417,100 52,138 $ 52,138 52,138 $ 52,138 2,606,875 $ 2,606,875

12,651 2,085,500 1,164,858 145,607 52,138 3,460,753

$ $ $ $ $ $ $ $

FIRST STABILIZED YEAR

12,878 $ 2,085,500 1,164,858 145,607 52,138 3,460,981 $

13,265 $

13,265 $

13,265 $

13,265 $

53,059

13,265 $

13,265 $

13,265 $

13,265 $

53,059

FIRST STABILIZED YEAR

13.6 102 6.7% 0.0% 6.7% 1,468,809 (97,921) (7,344) 1,363,545 (220,321) 1,143,223

$ $ $ $ $ $

289,345 $

0 102 0.0% 5.0% 5.0% 1,468,809 (73,440) (7,344) 1,388,025 (220,321) 1,167,703

$ $ $ $ $ $

313,598 $

0 102 0.0% 5.0% 5.0% 1,512,874 (75,644) (7,564) 1,429,666 (226,931) 1,202,735

$ $ $ $ $ $

1,189,470 $

-

$ $ $ $ $ $

-

$ $ $ $ $ $

(2,606,875) $ (2,606,875) $

$ $ $ $ $ $

1,468,809 (97,921) (7,344) 1,363,545 (220,321) 1,143,223

$ $ $ $ $ $

0 102 0.0% 5.0% 5.0% 1,512,874 (75,644) (7,564) 1,429,666 (226,931) 1,202,735

$ $ $ $ $ $

1,189,470 $

0 102 0.0% 5.0% 5.0% 1,512,874 (75,644) (7,564) 1,429,666 (226,931) 1,202,735

$ $ $ $ $ $

1,189,470 $

0 102 0.0% 5.0% 5.0% 1,512,874 (75,644) (7,564) 1,429,666 (226,931) 1,202,735

$ $ $ $ $ $

0 102 0.0% 5.0% 5.0% 6,051,495 (302,575) (30,257) 5,718,662 (907,724) 4,810,938

1,189,470 $

4,757,879

FIRST STABILIZED YEAR

$

95,321 $

Year 3 Total

13,265 $

DEVELOPMENT PERIOD 100% 153,900 $ $ 0.5% $ $ 15% $ $

Quarter 12

13,265 $

LEASE-UP PERIOD

61.2 61.2 70.0% 0.0% 70.0%

Quarter 11

FIRST STABILIZED YEAR

$

$ $ $ $ $ $ $

$ $ $ $ $ $

Quarter 8

LEASE-UP PERIOD

DEVELOPMENT PERIOD 60% 12 102

Net Cash Flow Before Debt During First Three Years PREMIER Initial Occupancy Upon Opening Gross Potential Revenue Vacancy Loss Bad Debt Effective Gross Revenue Operating Expenses NOI

Quarter 2

DEVELOPMENT PERIOD $ $ $ $ $ 54,512 $ $ 29,910,300 $ $ 2,991,030 $ $ 373,879 $ $ 897,309 $ $ 34,227,030 $

OPERATING INCOME/ (LOSS) DURING LEASE UP MALDEN MALL Initial Occupancy Upon Opening Months to Reach Stabilized Occupancy Spaces Leased per Quarter Cumulative No. Of Spaces Leased Vacancy Due to Lease Up (% of Gross Potential) Stablized Vacancy (% of Gross Potential) Overall Vacancy Rate Gross Potential Revenue Vacancy Loss Bad Debt Effective Gross Revenue Operating Expenses NOI

Quarter 1

Year 2 Total

1,468,809 (73,440) (7,344) 1,388,025 (220,321) 1,167,703

$ $ $ $ $ $

(2,317,530) $ (2,293,277) $

153,900 (770) 153,131 (23,085) 130,046

$ $ $ $ $ $

130,046 $

1,666,774 (75,644) (8,334) 1,582,796 (250,016) 1,332,780

$ $ $ $ $ $

1,319,515 $

153,900 (770) 153,131 (23,085) 130,046

$ $ $ $ $ $

130,046 $

1,666,774 (75,644) (8,334) 1,582,796 (250,016) 1,332,780

$ $ $ $ $ $

1,319,515 $

153,900 (770) 153,131 (23,085) 130,046

$ $ $ $ $ $

130,046 $

1,666,774 (75,644) (8,334) 1,582,796 (250,016) 1,332,780

$ $ $ $ $ $

1,319,515 $

153,900 (770) 153,131 (23,085) 130,046

$ $ $ $ $ $

615,600 (3,078) 612,522 (92,340) 520,182

130,046 $

520,182

1,666,774 (75,644) (8,334) 1,582,796 (250,016) 1,332,780

$ 6,667,095 $ (302,575) $ (33,335) $ 6,331,184 $ (1,000,064) $ 5,331,120

1,319,515 $

5,278,061

Continued on next page

86


V. PROPOSAL II - MMPG - FINANCIAL ANALYSIS

CONSTRUCTION LOAN BALANCE AND INTERESTS CALCULATION MALDEN MALL Total Development Costs Maximum Loan Balance Equity Required Equity Account Ending Balance

$ 65,452,088 $ 60,422,691 $ 5,029,397 $ $

PREMIER Total Development Costs Maximum Loan Balance Equity Required Equity Account Ending Balance

$ 12,344,479 $ 6,729,191 $ 5,615,288 $ 5,615,288 $ $ 11,230,577 $

TOTAL Total Development Costs Maximum Loan Balance Equity Required Equity Account Ending Balance

$ 77,796,567 $ 67,151,882 $ 10,644,685 $ 10,644,685 $ 10,644,685 $ $ 16,259,973 $ 10,644,685 $

CONSTRUCTION LOAN ACCOUNT MALDEN MALL Beginning Balance Loan Draws Construction Draw (Initial Request) Operating Deficit Trial Balance Additional Equity Required Net Construction Draw Ending Balance Before Interest Average Loan Balance Before Interest Total Construction Loan Interest Interest Accrued During Construction Period Interest Accrued During Operating Period Interest Paid from Operations Trial Ending Balance Additional Equity Required Net Interests Accrued Ending Balance

DEVELOPMENT PERIOD

5,029,397 $ 5,029,397 $

5,029,397 $ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

LEASE-UP PERIOD

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

5,029,397

DEVELOPMENT PERIOD

5,615,288 5,615,288

$ $ 11,230,577

$ $

$ $ 5,029,397 $ 16,259,973 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,029,397 $

$ 5,615,288 $

FIRST STABILIZED YEAR

5,615,288

$ 10,644,685 $ 10,644,685

DEVELOPMENT PERIOD LEASE-UP PERIOD $ 22,342,759 $ 31,199,004 $ 40,154,882 $ 49,211,514 $ 58,370,033 $ 59,881,722 $ 60,422,691 $ 60,422,691

4.5%

$ 59,855,104 $ $ 141,262,852 $ (2,019,077) $ 57,836,027 $ 140,408,746 $ 125,021,476 $ 4,622,887 $ 1,925,219 $ 2,697,668 $ (698,263) $ 141,501,640 $ (1,337,960) $ 2,586,664 $ 60,422,691

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

22,217,784 22,217,784 22,217,784 22,217,784 11,108,892 124,975 124,975 22,342,759 124,975 22,342,759

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

34,227,030 57,768,271 34,227,030 57,768,271 53,489,893 1,800,244 1,800,244 58,370,033 1,800,244 58,370,033

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

3,410,290 61,276,797 (2,019,077) 1,391,213 60,422,691 60,422,691 2,697,668 2,697,668 (698,263) 60,788,848 (1,337,960) 661,445 60,422,691

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,556,757 30,899,516 8,556,757 30,899,516 26,621,138 299,488 299,488 31,199,004 299,488 31,199,004

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,556,757 39,755,762 8,556,757 39,755,762 35,477,383 399,121 399,121 40,154,882 399,121 40,154,882

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,556,757 48,711,640 8,556,757 48,711,640 44,433,261 499,874 499,874 49,211,514 499,874 49,211,514

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,556,757 57,768,271 8,556,757 57,768,271 53,489,893 601,761 601,761 58,370,033 601,761 58,370,033

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

Total Additional Equity Required

$

-

$

-

$ (3,357,037) $

-

$

-

$

-

$

-

$

Net Cash Flow After Debt

$

-

$

-

$

-

$

-

$

-

$

-

$

PREMIER Beginning Balance Loan Draws Construction Draw (Initial Request) Operating Deficit Trial Balance Additional Equity Required Net Construction Draw Ending Balance Before Interest Average Loan Balance Before Interest Total Construction Loan Interest Interest Accrued During Construction Period Interest Accrued During Operating Period Interest Paid from Operations Trial Ending Balance Additional Equity Required Net Interests Accrued Ending Balance

$ 5,029,397 $

FIRST STABILIZED YEAR

3,311,586

$

850,244 59,220,277 850,244 59,220,277 58,795,155 661,445 661,445 59,881,722 661,445 59,881,722 751,541

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

852,061 60,733,784 (311,092.8) 540,969 60,422,691 60,152,207 676,712 676,712 (95,321) 61,004,083 (581,392) (0) 60,422,691

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

$

(892,485) $

$

852,061

$

$

4.5%

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

6,624,119 6,662,672 6,624,119 6,662,672 2,372,836 98,844 98,844 6,722,963 98,844 6,722,963

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

1,410,369 1,410,369 1,410,369 1,410,369 705,185 7,933 7,933 1,418,302 7,933 1,418,302

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

5,213,750 6,662,672 5,213,750 6,662,672 4,040,487 90,911 90,911 6,722,963 90,911 6,722,963

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

853,878 61,276,569 (853,878) 60,422,691 60,422,691 679,755 679,755 (289,345) 60,813,101 (390,410) (0) 60,422,691

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

854,106 61,276,797 (854,106) 60,422,691 60,422,691 679,755 679,755 (313,598) 60,788,848 (366,157) (0) 60,422,691

(1,244,289) $ (1,220,263) 853,878

$

854,106

DEVELOPMENT PERIOD 1,418,302 $ 4,055,797 2,606,875 4,025,177 2,606,875 4,025,177 2,721,740 30,620 30,620 4,055,797 30,620 4,055,797

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

$

-

$

-

$

-

$

-

Net Cash Flow After Debt

$

-

$

-

$

-

$

-

$ 66,479,223 $ $ 147,925,524 $ (2,019,077) $ 64,460,146 $ 147,071,418 $ 127,394,311 $ 4,721,732 $ 2,024,063 $ 2,697,668 $ (698,263) $ 148,224,603 $ (1,337,960) $ 2,685,509 $ 67,145,654

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

23,628,153 23,628,153 23,628,153 23,628,153 11,814,077 132,908 132,908 23,761,061 132,908 23,761,061

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

34,227,030 57,768,271 34,227,030 57,768,271 53,489,893 1,800,244 1,800,244 58,370,033 1,800,244 58,370,033

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,624,040 67,939,469 (2,019,077) 6,604,963 67,085,363 64,463,178 2,788,579 90,911 2,697,668 (698,263) 67,511,812 (1,337,960) 752,356 67,145,654

$ 22,342,759 $ 31,199,004 $ 40,154,882 $ 49,211,514 $ 58,370,033 $ 59,881,722 $

61,840,993 $ 64,478,488

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

3,460,753 65,301,747 (853,878) 2,606,875 64,447,868 63,144,431 710,375 30,620 679,755 (289,345) 64,868,898 (390,410) 30,620 64,478,488

8,556,757 30,899,516 8,556,757 30,899,516 26,621,138 299,488 299,488 31,199,004 299,488 31,199,004

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,556,757 39,755,762 8,556,757 39,755,762 35,477,383 399,121 399,121 40,154,882 399,121 40,154,882

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,556,757 48,711,640 8,556,757 48,711,640 44,433,261 499,874 499,874 49,211,514 499,874 49,211,514

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

8,556,757 57,768,271 8,556,757 57,768,271 53,489,893 601,761 601,761 58,370,033 601,761 58,370,033

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

850,244 59,220,277 850,244 59,220,277 58,795,155 661,445 661,445 59,881,722 661,445 59,881,722

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

852,061 60,733,784 (311,093) 540,969 60,422,691 60,152,207 676,712 676,712 (95,321) 61,004,083 (581,392) (0) 60,422,691

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

Total Additional Equity Required

$

-

$

-

$ (3,357,037) $

-

$

-

$

-

$

-

$

-

$

(892,485) $

Net Cash Flow After Debt

$

-

$

-

$ 3,311,586 $

-

$

-

$

-

$

-

$

751,541 $

852,061 $

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

3,460,981 67,939,469 (854,106) 2,606,875 67,085,363 65,781,925 740,047 60,291 679,755 (313,598) 67,511,812 (366,157) 60,291 67,145,654

(1,244,289) $ (1,220,263) 853,878 $

FIRST STABILIZED YEAR

2,606,875 6,662,672 2,606,875 6,662,672 5,359,234 60,291 60,291 6,722,963 60,291 6,722,963

Total Additional Equity Required

TOTAL Beginning Balance Loan Draws Construction Draw (Initial Request) Operating Deficit Trial Balance Additional Equity Required Net Construction Draw Ending Balance Before Interest Average Loan Balance Before Interest Total Construction Loan Interest Interest Accrued During Construction Period Interest Accrued During Operating Period Interest Paid from Operations Trial Ending Balance Additional Equity Required Net Interests Accrued Ending Balance

FIRST STABILIZED YEAR

854,106

87


88


ASIAN CDC PROPOSALS

VI 89


VI. Asian Community Development Corporation

Mission The Asian Community Development Corporation is a non-profit organization founded with the objective of serving the Asian American community of Greater Boston. Asian CDC focuses on sustaining the culture and revitalizing Boston’s Chinatown by developing affordable housing, fostering economic development, stimulating leadership development, and advocating on behalf of Greater Boston’s Asian American community.

History Asian CDC was founded 27 years ago to mitigate the rising needs of the Chinatown community specifically attributed to the lack of affordable housing. Asian CDC’s community

based efforts than expanded to attend the whole Greater Boston Asian American community as an increasing number of Asian immigrants and low income families had to leave Chinatown in response to the shortage of affordable housing. Currently, Asian CDC is in charge of programs such as the Comprehensive Housing Opportunities Program, the Community Organizing and Planning program, the Chinatown Heritage Project and specifically relevant to this field study, the real estate development program. Asian CDC’s effort to provide affordable housing to the Asian American community continues as Chinatown is undergoing a process of gentrification.

Recent development of luxury apartment buildings in the Chinatown area is causing property values to rise beyond the affordability of many longtime residents. Asian CDC’s real estate development program is then focused on developing high-quality affordable communities that are welcoming for residents, neighbors, and visitors alike.

Real Estate Portfolio Asian CDC revolves around transit-oriented, large-scale, mixed-use and mixed-income development projects. Since 1995, the organization has successfully completed four development projects with the recent groundbreaking of the fourth project on May 6th, 2014. Asian CDC has created over $100 million of mixed-income developments that house over 800 residents. The following is a brief overview of each of the projects:

OAK TERRACE Asian CDC’s first development project is Oak Terrace, which was completed in 1995. Oak Terrace is located in Chinatown and was at its time of completion, the first new development in Chinatown in over 20 years. Additionally, it is one of the earlier developments to make use of the Low Income Housing Tax Credit (LIHTC) program. Oak Terrace Limited Partnership owns the property in partnership with Oak Terrace Corporation, which is the general partner with a 1% ownership. Oak terrace Corporation is a subsidiary managed by Asian CDC.

Asian CDC Executive Board

Oak Terrace contains 88 units of which 16% are one-bedroom units, 36% are two-bedroom units, 38% are three-bedroom units and 10% are 4-bedroom units. Approximately one-third of the units are low-income units, one-third are moderate-income units, and one-third are market rate units and provides housing to over 300 residents. Additionally, Oak Terrace provides community and 4 ground-floor commercial spaces, which partake an area of approximately 2,775 square feet.

THE METROPOLITAN The Metropolitan, located in Downtown Boston, is the second development project Asian CDC was involved with and was completed in 2004. Asian CDC developed this $89 million, 23-story-high-rise project in partnership with for-profit developer Edward A. Fish Associates. The Metropolitan contains a total of 133 rental units and 118 for-sale condominiums of which 46% are affordable to low and moderate income families. 61% of the rental units are affordable to low and moderate income families and 29% of the condominiums are sold at affordable prices ranging from 80% to 120% of area median income. The Metropolitan also provides community space for community-based social services organizations, retail and commercial space, and 283 underground parking spaces.

6 FORT STREET 6 Fort Street, located in Quincy, MA, is Asian CDC’s first development project outside of Downtown Boston. The property was completed in 2012 and is an adaptive reuse of a church which was converted to office space, representing a sustainable approach

90


VI. ASIAN CDC - REAL ESTATE PORTFOLIO

Oak Terrace Oak Terrace

to affordable housing. The building contains 34 units, which encompass approximately 42,000 square feet of space, 64 parking spaces and approximately 1,000 square feet of community space. Of the 34 units, 100% of them are affordable. 23% of the units are onebedroom, 65% are two-bedroom, and 12% are three bedroom.

ONE GREENWAY The latest development venture Asian CDC has been involved with is One Greenway, a 2-building project located in Boston. The first building is set to open in 2015 while the second building is set to be completed in 2016. Asian CDC developed One Greenway in joint venture with New Boston Fund, Inc. Upon completion, the property will contain 362 residential units, 5,000 square feet of community space, 3,000 square feet of commercial space, and 13,000 square feet of central open space. The residential units are a mix of 312 rental and 50 condominium units. 30% of the rental units and 100% of the condominiums will be offered at affordable prices.

Asian CDC in Malden The rising housing prices in Chinatown have forced many residents to look elsewhere in the Greater Boston area for more affordable housing. Along with Quincy, Malden is becoming home to an increasing number of Asian residents. According to the US Census Bureau, in 1990 just 5.2% of Malden’s population was Asian. As of 2012, Asians now represent over 20.1% of the city’s population. Relative to it’s nearest neighbors of Everett, Medford, and Revere, Malden boasts the

MetropolisMetropolis

One Greenway One Greenway

highest percentage of Asian population. Following the increase in Asian population, there has been a surge of Asian-owned businesses in Malden including restaurants. What makes Malden especially attractive to the Asian community is the Malden Center Station, which is serviced by the Orange Subway Line, providing a direct connection to Chinatown. Due to its unique characteristics, it’s no surprise then that Asian CDC is looking to fulfill some of the housing needs the Asian community in Malden is facing. Asian CDC is interested in a ground-up or adaptive re-use opportunity to develop a minimum of 30 affordable residential rental units in Malden. Like 6 Fort Street in Quincy, Asian CDC wants this project to be more family oriented by providing mostly two to three bedroom units. Depending on the site characteristics, the property can be an allaffordable, 30-unit (approximate) development such as 6 Fort Street or it can be a 60 to 80-unit mixed-income development project in which at least 30 of the units are affordable. Additionally, to capitalize on the direct subway link between Malden and Chinatown, ideally the property site will be a 10-minute walk from the subway station. Using these basic characteristics of what Asian CDC envisions the affordable housing developing project to be, each team was tasked to select a site and implement a development scheme.

BOSTON - CHINATOWN

QUINCY

Asian CDC’s existing project portfolio.

6 Fort Street6 Fort Street

91


VI. ASIAN CDC PROPOSAL I - SUMMER STREET

VI. Asian CDC PROPOSAL I SUMMER STREET Alexander Akel, Alison Crowley & Greg Demaiter Overview Selection Criteria Based on our conversations with the Asian Community Development Corporation (Asian CDC) throughout site visits to their Quincy and Chinatown project locations, we sought to identify a site for the Asian CDC that would meet the following criteria: 1) Capable of fitting at least 30 units, the majority family sized, on site. There is an increasingly dire need for more family housing in the transit-oriented section of Malden. Current new residential projects emphasize studios and one-bedroom units to attract young professional commuters, and we hope that this project can help combat that effect by providing less-common two and three-bedroom units. 2) New construction or adaptive re-use of a vacant building. Our initial site selection process included multiple existing buildings that we felt were ideal for rehabilitation and reuse as affordable apartment buildings. However, in considering the acquisition of existing residential projects, we risked displacing those residents during the rehabilitation construction process. It was our understanding that Asian CDC’s goal is to increase the number of affordable units in the city rather than simply take ownership of an existing affordable project, and we did not want to displace any current residents, be they market or affordable. This narrowed our sites to those either currently vacant or with a vacant structure suitable to re-use.

3) Located within a 0.5-mile walk shed to the Malden Center MBTA Station. Because the residents of this building may rely on public transportation to get to their jobs in other parts of the Boston metro region, we wanted to ensure that the project remained within a half-mile walk to the Malden Center MBTA Station, which would take approximately 10 minutes to reach. Because some of our residents may be older and have difficulty walking far distances, we wanted the access to the T to be as direct and safe as possible. 4) Large enough site area to provide at least one parking space per every three residential units. Although Malden typically requires more stringent parking requirements, we believe the project would be eligible for parking relief due to its proximity to the MBTA station and due to the affordability restrictions placed on the units. Fewer households in lower income brackets own cars, and having to incorporate more parking spaces than what are currently proposed would severely limit the number of new affordable units we could build. 5) Straightforward acquisition potential. Arranging financing for a 100% affordable project will be complex no matter how experienced a developer is in this type of development. As such, we wanted to eliminate further complications by avoiding sites that could be difficult to acquire. This includes subdivided sites with multiple owners requiring assemblage, sites that were recently acquired, and sites with investor owners unlikely to be open to negotiation.

Site Selection Ultimately, we selected a site located at the intersection of Mountain Avenue and Summer Street just northeast of the CBD. The site meets our criteria in the following ways: 1) The land area is 12,955 SF, allowing enough space to build 42 units of primarily two and three-bedroom units in a six story building, the maximum allowed in the CBD. 2) The site has no structure on it, enabling a straightforward ground-up project that won’t displace any current residents.

STOP T O T & CBD

0.297 AC

3) The site is 0.3 miles from the pedestrian entrance to the Malden Center train station and 0.2 miles from the future connection of Pleasant Street to Commercial Street when the City Hall site is re-developed. 4) With 70% of the site’s land area utilized for the building footprint, the remaining 30% of the site can hold 16 parking spaces, a parking ratio of 0.38. 5) Perhaps most significantly, the site’s current use is as a municipal parking lot with approximately forty spaces serving the courthouse located across the street. Although public parking options continue to be a concern for Malden authorities, the site has a city-owned parking garage directly across the street that would remain in operation throughout construction and project completion. On a weekday visit during normal business hours, the parking garage was less than half-full, indicating that for the buildings it serves, the spaces provided are sufficient. Furthermore,

though the primary user for the parking lot and garage is the Malden City Courthouse, Malden government authorities have indicated that the site will likely be re-developed in the near term future as a community arts center. If this occurs, there will likely be an even further reduced need for parking, as arts centers employ fewer workers than courthouses and generally have less daytime traffic. Because the City of Malden owns the parking lot, we believe Asian CDC can negotiate with the City to obtain the parking lot at little or no cost, cutting out the profit incentives inherent to a private market transaction.

Proposed site for the Asian CDC.

92


VI. ASIAN CDC - PROPOSAL I - SUMMER STREET

Malden MBTA Station

Malden CBD

Site Plan showing Ground Level Retail, Parking , Building Outline Above

Municipal Garage

District Courthouse

Asian CDC Site

93


VI. ASIAN CDC PROPOSAL I - SUMMER STREET

Program Program Residential Retail TOTAL Parking - surface Park/Green space Roads/Infrastructure

SF

Units 51,911 2,500 54,411 16 0 0

Building Calculation Total Land Area % building footprint Total Built Footprint Number of stories Total GSF

12,955 70% 9,069 6 54,411

Total Parking Footprint # Parking spaces total # Parking for retail # Parking for resi Parking resi ratio/unit

3,887 16 4 12 0.27

Unit Mix

By utilizing 70% of the site area for the building footprint, the remaining 30% of the site can hold 16 parking spaces at 250 SF per

Unit Count 1 BR 2 BR 3 BR

TOTAL Average Rent/SF

Efficiency Floor 1 Floors 2-6 TOTAL SF Residential Efficiency Avg Unit Size (Weighted)

Similar to Asian CDC’s Oak Terrace apartments, we propose a small 2,500 SF ground floor commercial component that will provide additional cash flow month to month. The site is separated from a retail corridor to its south by two small residential projects. As such, the nature of the site likely lends itself to neighborhood-serving retail or small office space, similar to the dental office at Oak Terrace. The remaining ground floor space is reserved for common areas and core. This programming is, of course, flexible; because there is no outdoor common area component to the project, Asian CDC may elect instead to fully utilize the ground floor space for resident amenities. Although this would impact their stabilized NOI, the project could still move forward with that alternative plan.

Avg SF 42 933 0 2,500 42

LIHTC Rent 9 $957 27 $1,148 6 $1,326 42 $1.24

Total Monthly Rent $8,610 $30,983 $7,954 $47,547

Unit SF Monthly Rent/SF 750 $1.28 850 $1.35 1200 $1.10 933

space. Malden requires two spaces per every 1,000 square feet of retail, so four spaces are set aside for retail. This leaves 12 remaining spaces for a parking ratio of 0.27 spaces per unit. Asian CDC could have the option of requesting that the retail parking be moved to the parking garage across the street, thus reserving all 16 spaces for residents. Although this is a relatively low parking ratio by Malden standards, it is on par with ratios associated with transit-oriented projects located this close to a train station. The unit mix reflects Asian CDC’s desire to better serve families in Malden, reserving 79% of the total units for two bedrooms or larger. This will contrast directly with the projects coming to market in Malden over the next four years, the majority of which will emphasize studios and one bedroom units over family sized. Through the Summer Street site, Asian CDC can reach a critically under-served population.

Total SF 6,750 22,950 7,200 36,900

Gross SF Retail Amenity + Core SF Net Residential SF 9,069 2,500 6,569 45,343 8,443 54,411 2,500 15,011

36,900 36,900 81% 879

94


VI. ASIAN CDC PROPOSAL I - SUMMER STREET

Existing site

Proposed six-story masonry design

95


VI. ASIAN CDC PROPOSAL I - SUMMER STREET - FINANCIAL ANALYSIS

Financial Analysis funds, which provide up to $750,000 per project or $50,000 per unit. Finally, we would intend to apply for HOME funding through the HOME dollars allocated to the area North Suburban Consortium (NSC), which allocates HOME funding to eight area suburban communities, including Malden. The FY 2014 allotment for the NSC was $1,518,879. Our project will request $500,000 in project funds from this allocation, recognizing the positive impact of the Asian Community Development Corporation’s involvement in Malden and the urgent need for family-size affordable housing as rents continue to rise in the entire region.

Sources As a 100% affordable project, we intend to finance the project through state-level soft debt resources, federal and state-level LIHTC, and a construction loan at 15% loan-to-cost.

Soft Debt Our state subsidy sources include a total request of $2.25 million from three separate sources. The largest subsidy would come from the Affordable Housing Trust Fund (AHTF), which is administered by MassHousing and prioritizes affordable housing for families at 80% AMI or lower. The AHTF will not fund in excess of $1 million per project or $50,000 per unit; our project will seek to obtain the full $1,000,000 maximum allotment. We will also pursue debt funding through the Commercial Area Transit Node Housing Program (CATNHP), a 30-year deferred payment loan at 0% interest that provides financing to projects complying with the state’s definition of “transit-oriented.” Our proximity to the Malden Center MBTA station will render the project eligible for these

LIHTC Equity By setting all of our units at 60% AMI and lower, we can apply for both federal and state LIHTC for the entire project, acquiring through compliance with the program’s restrictions a total equity raise of $12,820,500. We assume $0.90 credit pricing in order to remain within conservative estimates. In order to receive federal LIHTC, we will set aside 10% of the units to families earning 30% AMI or lower, which we reflect in our stabilized NOI. In compliance with 4%

6% SOURCES Construction Debt Fed LIHTC State LIHTC AHTF CATNHP HOME TOTAL TOTAL SUBSIDY

3%

the Massachusetts Qualified Allocation Plan for FY 2014, our project meets the 4th funding priority for tax credit projects, known as family housing production in neighborhoods and communities providing access to jobs, transportation, education and public amenities. To meet this requirement and to achieve the maximum $250,000 per unit tax credit cap for large unit projects within the Boston metro area, we have provided at least 65% of our units as two-bedrooms and 10% as three-bedrooms.

Construction Loan The remaining costs necessary to fund the project will be financed through a construction loan with 4.5 percent interest rate and a fee of one percent. The loan totals $2,478,653 at 15% loan-to-cost.

Uses The 42-unit project has total development costs (TDC) of $16,700,325, of which 96% of costs are attributable to the rental portion of the project at a rate of $382,875 per unit. In developing the project’s financing fundamen-

14%

tals, we made two major assumptions: 1) No Acquisition Cost. Asian CDC will be able to negotiate with the City of Malden to acquire the municipal parking lot at no cost, eliminating the hurdle of a high acquisition cost. We believe the value of having the Asian Community Development Corporation working in Malden far exceeds the current value of the site as a surface parking lot with approximately forty spaces, discussed in our Site Selection Criteria section above. 2) No Developer Equity. Asian CDC will not put any of their own equity into the project and will not defer their developer’s fee, equal to 2.5% of all costs. The project is modeled without any outside private investors due to the restricted nature of the stabilized NOI. Although we know that Asian CDC has a relationship with investors from its previous projects in Chinatown, due to the scale of this project we chose not to make the assumption that we could obtain private equity financing.

5% USES Land + Environmental Buildings Parking Parks + Hardscape Soft Cost + Contingency Finance TOTAL TOTAL UNLEVERAGED

% 2,478,653 11,056,500 1,764,000 1,000,000 750,000 500,000 17,549,153 14,570,500

14% 63% 10% 6% 4% 3% 100% 83%

18%

Construction Debt

10%

Fed LIHTC State LIHTC AHTF

Buildings Parking

0.4%

Soft Cost + Contingency

CATNHP HOME

Finance

% 0 13,477,750 77,730 0 3,144,845 848,828 17,549,153 16,700,325

0% 77% 0.4% 0% 18% 5% 100%

77%

63%

96


VI. ASIAN CDC PROPOSAL I - SUMMER STREET - FINANCIAL ANALYSIS

Budget Cost Land $0 Environmental $0 Hard Costs Apt - Affordable $12,977,750 Retail $500,000 Parking - surface $77,730 Contigency $677,774 Soft Costs Pre-development $500,000 Design $711,663 Administrative $750,000 Contigency $98,083 Developer Fee $407,325 Total Budget $16,700,325 Residential % 96% Retail % 4%

Financing - Federal LIHTC Eligible Basis 130% Boost? Eligible Basis after Boost Percent of Low Income Units Qualified Basis Applicable Tax Percentage Maximum Annual TC Amount Syndication Rate Est. Syndication Yield Availab Net Yield Per Unit Per Unit Tax Credit Cap Number of Units

Applicable tax percentage Boost basis

Financing - State AHTF Maximum allowed/unit Maximum allowed total Total Units Basis per unit Total allowed (lesser of) Financing - State CATNHP Maximum allowed/unit Maximum allowed total Total Units Basis per unit Total allowed (lesser of) Financing - HOME Total HOME juris. allocation Pro rata Malden share HOME loan request Per unit request

Per Unit Debt Subsidy Per Unit Equity Subsidy Total Per Unit Subsidy

$50,000 $1,000,000 42 $2,100,000 $1,000,000

$50,000 $750,000 42 $2,100,000 $750,000

$1,518,589 $189,824 $500,000 $11,905

$53,571 $305,250 $358,821

Syndication Rate Max over 10 years MAXIMUM LIHTC Investor Ownership Financing - State LIHTC # Units Basis/Unit Max Basis Allowed Eligible Basis Applicable rate TC % Annual tax credit Multiplier (years) TC price EQUITY RAISE Investor Ownership

$16,093,170 No $16,093,170 100% $16,093,170 9% $1,448,385 $0.90 $13,035,468 $310,368 $250,000 42 $10,500,000 9.00% 130% $1,228,500 $0.90 10 $11,056,500 3%

42 $14,955,119 $250,000 $10,500,000 4.80% $504,000 5 $0.70 $1,764,000.00 3%

Federal Syndication Proceeds Pay-In: Closing 25% Construction Complete 50% Construction Complete 75% Construction Complete Construction Completion Permanent (Stabilization) Total State Syndication Proceeds Pay-In: Closing 25% Construction Complete 50% Construction Complete 75% Construction Complete Construction Completion Permanent (Stabilization) Total KEY ASSUMPTIONS Current rent/price Efficiency factor Occupancy Other income Parking revenue Parking occupancy OpEx (excluding taxes) Exit cap rate First year avg occupancy

11,056,500 3,869,775 3,869,775 3,316,950 11,056,500

35% 0% 35% 0% 30% 0% 100%

1,764,000 617,400 617,400 529,200 1,764,000

35% 0% 35% 0% 30% 0% 100%

Financing - Construction Loan Unleveraged TDC $16,700,325 TDC + Financing Cost $17,549,153 LTC 14% Use? YES Loan amount $2,478,653 Interest rate 4.50% Points 1% Loan fee 24,787 Financing - Permanent Debt DSCR 1.15 Stabilized NOI $315,606 Interest rate 5.00% Amortization (yrs) 30 Use? YES Loan amount $4,218,821

APT - AFFORDABLE RETAIL $1.24 $22 85% 95% 100% 90% 0% 0% $0/month $0/day 95% 0% $5,500 0% 6.75% 7.00% 90% 75%

CONSTRUCTION COSTS Apt - Affordable Retail Parking - surface Park/green space Roads/infrastructure

$250.00 $200.00 $5,000.00 $80.00 $20.00

/sf /sf /space /sf /sf

OTHER COSTS Design Hard contingency Soft contingency Developer fee Environmental

5.00% 5.00% 5.00% 2.50% $300,000

of hard costs of hard costs of soft costs of all costs /acre

FINANCE Interest rates Construction Permanent DSCR Amortization (yrs) Loan fee

4.50% 5.00% 1.15 30 1.00%

Tax credits LIHTC/SHTC applicable% LIHTC/SHTC credit pricing Investor ownership

9% $0.90 3%

OTHER Inflation Commercial tax Residential tax Cost of sale

3.00% 3.20% 1.30% 2.00%

97


VI. ASIAN CDC PROPOSAL I - SUMMER STREET - FINANCIAL ANALYSIS

Pro-Forma - Affordable Rental Apartment Building

Acquisition

Construction

Construction

Lease-Up

Stabilization

Hold

Hold

Holy

Hold

Hold

Hold

Hold

Hold

Hold

Sale

TOTAL

0

1

2

3

4

5

6

7

8

9

10

11

12

13

Land

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Environmental

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

(13,567,589)

0

(6,683,541)

(6,884,047)

0

0

0

0

0

0

0

0

0

0

0

(522,725)

0

(257,500)

(265,225)

0

0

0

0

0

0

0

0

0

0

0

Parking - Surface

(81,263)

0

(40,031)

(41,232)

Park/green space

-

0

-

-

0

0

0

0

0

0

0

0

0

0

0

Roads/infrastructure

-

0

-

-

0

0

0

0

0

0

0

0

0

0

0

Residential Retail

Contingency

0

(349,054)

(359,525)

0

0

0

0

0

0

0

0

0

0

0

(13,493,803)

0

(7,330,126)

(7,550,030)

0

0

0

0

0

0

0

0

0

0

0

Pre-development

(500,000)

(500,000)

0

0

0

0

0

0

0

0

0

0

0

0

0

Design

(744,008)

0

(366,506)

(377,501)

0

0

0

0

0

0

0

0

0

0

0

Administrative

(784,088)

0

(386,250)

(397,838)

0

0

0

0

0

0

0

0

0

0

0

Contingency

(101,405)

(25,000)

(37,638)

(38,767)

0

0

0

0

0

0

0

0

0

0

0

Developer Fee

(425,241)

(13,125)

(203,013)

(209,103)

0

0

0

0

0

0

0

0

0

0

0

(2,554,741)

(538,125)

(993,407)

(1,023,209)

0

0

0

0

0

0

0

0

0

0

0

(16,048,544)

(538,125)

(8,323,533)

(8,573,239)

0

0

0

0

0

0

0

0

0

0

0

9,214,546

0

0

0

719,448

741,032

763,263

786,161

809,745

834,038

859,059

884,831

911,376

938,717

966,878

689,284

0

0

0

53,818

55,432

57,095

58,808

60,572

62,389

64,261

66,189

68,174

70,220

72,326

0

0

0

0

0

0

773,266

Residential

0

0

0

(71,945)

0

0

0

0

0

0

0

0

0

0

Retail

0

0

0

(13,454)

(5,543)

(5,709)

(5,881)

(6,057)

(6,239)

(6,426)

(6,619)

(6,817)

(7,022)

(7,233)

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

(85,399)

(5,543)

(5,709)

(5,881)

(6,057)

(6,239)

(6,426)

(6,619)

(6,817)

(7,022)

(7,233)

9,754,884

0

0

0

687,867

790,921

814,648

839,088

864,260

890,188

916,894

944,400

972,732

Hard costs

Soft costs TOTAL DEVELOPMENT Operations Residential Retail Parking Gross potential rent

677,774

TOTAL

0 9,903,830

Parking Vacancy EFFECTIVE GROSS INCOME Residential

(148,946)

0

0 796,464

0 820,358

0 844,968

0 870,317

0 896,427

0 923,320

0 951,019

0 979,550

0 1,008,936

1,001,914

0 1,039,205

1,031,972

(3,232,943)

0

0

0

(252,420)

(259,993)

(267,792)

(275,826)

(284,101)

(292,624)

(301,403)

(310,445)

(319,758)

(329,351)

(339,231)

Retail

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Parking

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Operating expenses

(3,232,943)

0

0

0

(252,420)

(259,993)

(267,792)

(275,826)

(284,101)

(292,624)

(301,403)

(310,445)

(319,758)

(329,351)

(339,231)

Residential

(2,677,470)

0

0

0

(209,050)

(215,322)

(221,781)

(228,435)

(235,288)

(242,346)

(249,617)

(257,105)

(264,818)

(272,763)

(280,946)

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Real estate taxes

(2,677,470)

0

0

0

(209,050)

(215,322)

(221,781)

(228,435)

(235,288)

(242,346)

(249,617)

(257,105)

(264,818)

(272,763)

(280,946)

EXPENSES

(5,910,413)

0

0

0

(461,470)

(475,314)

(489,574)

(504,261)

(519,389)

(534,970)

(551,019)

(567,550)

(584,576)

(602,114)

(620,177)

Residential

3,232,188

0

0

0

186,033

265,718

273,689

281,900

290,357

299,068

308,040

317,281

326,799

336,603

346,701

612,283

0

0

0

40,363

49,889

51,385

52,927

54,515

56,150

57,835

59,570

61,357

63,198

65,094

0

0

0

Retail

Retail Parking

14

0

0 226,397

0

0

0

(538,125)

(8,323,533)

(8,573,239)

226,397

315,606

325,075

334,827

344,872

355,218

365,874

376,851

388,156

399,801

411,795

6,123,246

0

0

(2,477,089)

219,605

306,138

315,322

324,782

334,526

344,561

354,898

365,545

376,511

387,807

399,441

5,939,548

0

399,801

0

0

0

388,156

0

6,123,246

0

376,851

0

SALE PROCEEDS

0

365,874

0

0

0

355,218

0

0

0

344,872

0

0

0

334,827

0

3,844,471

0

325,075

0

NET OPERATING INCOME

0

315,606

0

0

411,795 0

6,123,246

PROJECT-LEVEL RETURN UNLEVERAGED

(7,467,181) -5%

PROJECT-LEVEL RETURN UNLEVERAGED/SUBSIDIZED

7,191,596 17%

98


VI. ASIAN CDC PROPOSAL I - SUMMER STREET - FINANCIAL ANALYSIS

Pro-Forma - Affordable Rental Apartment Building

Acquisition

Construction

Construction

Lease-Up

Stabilization

Hold

Hold

Holy

Hold

Hold

Hold

Hold

Hold

Hold

Sale

TOTAL

0

1

2

3

4

5

6

7

8

9

10

11

12

13

0 TOTAL 0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

(13,567,589)

(6,683,541) 0 (257,500) 0 (40,031) 0 0 0 (349,054) 0 (7,330,126) 0

(6,884,047) 0 (265,225) 2,477,089 (41,232) 0 2,477,089 1,238,544 (359,525) (55,735) (7,550,030) 0

0 2,477,089 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

677,774 (111,469) (13,493,803) 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0

(2,477,089) 0 0 0 1,238,544 0 (55,735) 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

(2,787) (500,000) (114,256) (744,008) (17,549,153) (784,088)

0 (500,000) 0 0 (538,125) 0

0 0 0 (366,506) (8,323,533) (386,250)

(1,393) 0 (57,128) (377,501) (8,630,367) (397,838)

(1,393) 0 (57,128) 0 (57,128) 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

0 0 0 0 0 0

(101,405) TOTAL (425,241)

(25,000)

(37,638)

(38,767)

0

0

0

0

0

0

0

0

0

0

0

(13,125) 0 (538,125) 0 (538,125) 0

(203,013) 0 (993,407) 0 (8,323,533) 0

(209,103) 0 (1,023,209) 0 (8,573,239) 0

0 0 0 4,218,821 0 0

0 4,218,821 0 0 0 (210,941)

0 4,155,322 0 0 0 (207,766)

0 4,088,648 0 0 0 (204,432)

0 4,018,640 0 0 0 (200,932)

0 3,945,131 0 0 0 (197,257)

0 3,867,948 0 0 0 (193,397)

0 3,786,905 0 0 0 (189,345)

0 3,701,809 0 0 0 (185,090)

0 3,612,460 0 0 0 (180,623)

0

0

0

0

0

(63,499)

(66,674)

(70,008)

(73,508)

(77,184)

(81,043)

(85,095)

(89,350)

9,214,546

0 0

0 0

0 0

4,218,821 719,448

4,155,322 741,032

4,088,648 763,263

4,018,640 786,161

3,945,131 809,745

3,867,948 834,038

3,786,905 859,059

3,701,809 884,831

3,612,460 911,376

Retail CASH FLOW AFTER DEBT SERVICE Parking

689,284 5,544,911 0

0 0 0

0 0 0

0 0 0

53,818 1,968,129 0

Gross potential rent EQUITY

9,903,830 TOTAL

0

0

0

773,266

0 538,125 0 0

0 7,201,425 0 0

0 3,316,950 0 0

Land CONSTRUCTION FINANCING Environmental CONSTRUCTION LOAN Residential Beginning balance Retail Draws Parking - Surface Repayments Park/green space Ending balance Roads/infrastructure Average balance Contingency Construction interest Hard costs Finance Developer fee Pre-development Total financing cost Design TOTAL DEVELOPMENT - LEVERAGED Administrative

Contingency PERMANENT LOAN Developer Fee Beginning balance Soft costs Draws TOTAL DEVELOPMENT Interest Repayments Operations Ending balance Residential

LIHTC - Federal Residential Contributions Retail Distributions Parking

(522,725) 2,477,089 (81,263) (2,477,089) -

(2,554,741) 4,218,821 (16,048,544) (1,945,716) (4,218,821) TOTAL

11,056,500 (166,347)

Vacancy LIHTC - State EFFECTIVE GROSS INCOME Contributions

9,754,884 1,764,000

Distributions Residential

(166,347) (3,232,943)

0

0

0

Retail AHTF Parking CATNHP Operating expenses HOME

0 1,000,000 0 750,000 (3,232,943) 500,000

0

0

0 1,000,000 0 750,000 0 500,000

TOTAL EQUITY CONTRIBUTIONS Residential

14,957,808 (2,677,470)

538,125 0

8,323,533 0

6,096,150 0

Retail CASH FLOW TO PARTNERSHIP Real estate taxes

0 5,212,216 (2,677,470)

0

0

0

EXPENSES PROJECT-LEVEL RETURN LEVERAGED Residential

Retail

(148,946)

0

0

0

0

0 1,122,108

0 529,200

-

-

0 0

-

-

0 0

(71,945) (13,454) (59,044) 0 (85,399)

55,432 41,166 0 796,464 0 (5,543) (1,235) 0 (5,543)

57,095 50,634 0 820,358 0 (5,709) (1,519) 0 (5,709)

58,808 60,386 0 844,968 0 (5,881) (1,812) 0 (5,881)

60,572 70,431 0 870,317 0 (6,057) (2,113) 0 (6,057)

62,389 80,777 0 896,427 0 (6,239) (2,423) 0 (6,239)

64,261 91,434 0 923,320 0 (6,426) (2,743) 0 (6,426)

66,189 102,410 0

68,174 113,716 0

951,019

979,550

0 (6,619) (3,072) 0 (6,619)

0 (6,817) (3,411) 0 (6,817)

3,518,642

70,220 125,360 0 1,008,936 0 (7,022) (3,761) 0 (7,022) 1,001,914 -

72,326 137,354 0

0 (7,233) (4,121) 0

916,894 -

944,400 -

972,732 -

(59,044) (252,420)

(1,235) (259,993)

(1,519) (267,792)

(1,812) (275,826)

(2,113) (284,101)

(2,423) (292,624)

(2,743) (301,403)

(3,072) (310,445)

(3,411) (319,758)

(3,761) (329,351)

(4,121) (339,231)

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

(252,420)

(259,993)

(267,792)

(275,826)

(284,101)

(292,624)

(301,403)

(310,445)

(319,758)

(329,351)

(339,231)

(209,050)

(215,322)

(221,781)

(228,435)

(235,288)

(242,346)

(249,617)

(257,105)

(264,818)

(272,763)

(280,946)

0 38,696 (215,322)

0 47,596 (221,781)

0 56,763 (228,435)

0 66,205 (235,288)

0 75,931 (242,346)

0 85,948 (249,617)

0 96,266 (257,105)

0 106,893 (264,818)

0 117,839 (272,763)

0 129,113 (280,946)

1,031,972 -

(475,314)

(489,574)

(504,261)

(519,389)

(534,970)

(551,019)

(567,550)

(584,576)

(602,114)

(620,177)

(5,910,413)

0

0

0

(461,470)

(9,412,897) 3,232,188 -10% 612,283

(538,125) 0

(8,323,533) 0

(6,096,150) 0

1,968,129 186,033

41,166 265,718

50,634 273,689

60,386 281,900

70,431 290,357

80,777 299,068

91,434 308,040

102,410 317,281

113,716 326,799

125,360 336,603

137,354 346,701

0

0

0

40,363

49,889

51,385

52,927

54,515

56,150

57,835

59,570

61,357

63,198

65,094

0

0

0

0

0

0

0

3,844,471 5,212,216

SALE PROCEEDS

6,123,246

-

-

-

226,397 1,850,041 0

315,606 38,696 0

325,075 47,596 0

334,827 56,763 0

344,872 66,205 0

355,218 75,931 0

0 365,874 85,948 0

0 376,851 96,266 0

0 388,156 106,893 0

0 399,801 117,839 0

0

2,703,112

(81,093)

(7,233)

890,188 -

0

3,420,134

1,039,205

864,260 -

0

0

0

839,088 -

0

0 0

3,420,134 966,878

814,648 -

0

0 0

3,518,642 938,717

790,921 -

0

0

(3,420,134)

687,867 -

0

0

(98,508)

0

Parking PROJECT LEVEL RETURN NET OPERATING INCOME LEVERAGED/SUBSIDIZED

0

(93,817)

0

-

0

0

0

-

0

0 0 0 (175,932)

0 1,850,041 (209,050)

-

14

(81,093)

2,540,925

2,703,112

0 411,795 129,113 0

2,540,925

0

0

0

6,123,246

(538,125)

(8,323,533)

(8,573,239)

226,397

315,606

325,075

334,827

344,872

355,218

365,874

376,851

388,156

399,801

411,795

6,123,246

0

0

(2,477,089)

219,605

306,138

315,322

324,782

334,526

344,561

354,898

365,545

376,511

387,807

399,441

5,939,548

PROJECT-LEVEL RETURN UNLEVERAGED

(7,467,181) -5%

PROJECT-LEVEL RETURN UNLEVERAGED/SUBSIDIZED

7,191,596 17%

99


VI. Asian CDC PROPOSAL II: 299 Pleasant St. Stephanie Torres & Weishun Xu Selection Criteria The selection of an appropriate site and the development strategy to building affordable units in Malden was founded on the guidelines the Asian Community Development Corporation gave us during our meetings: 1| The project is a transit-oriented development. The site is located within a 3-minute walk to the Malden Center Station. Additionally, it is a 5-minute walk from the downtown core, and a 10-minute walk from Stop & Shop. 2| The project will provide at least 30 affordable units of which the majority of the units are family oriented. The proposed project will supply 42 affordable units. 15% of the units are 1-bedroom units, 70% are 2-bedroom units, and 15% are 3 bedroom units. 3| The project will provide parking for the residents. With 42 units, the project will provide 21 parking spaces, that is, 1 parking space per 2 units. Although this ratio is below the Malden standard parking ratio, we believe this is a feasible proposal given the project’s proximity to the subway station. The lower parking ratio also allows the project to have surface parking, which is more economical to build than a parking structure. 4| The project will be a new construction. The proposed project will be a ground up construction development. Although the project requires demolishing the two existing structures on the site, neither of these structures contain residential units, thus no one will be displaced.

100


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST - SITE SELECTION AND EXISTING

Site Selection and Existing Conditions The site is located just 0.1 miles east of the Malden Center Station along Pleasant St. When we began the process of looking for a suitable site, we didn’t just see it as selecting a site to build a building on, but rather we looked for a site where such development would benefit and contribute to the downtown revitalization endeavor. With the relocation of the City Hall, Pleasant St. will reconnect into one continuous street that stretches past the subway station

and past the proposed site. We anticipate that the unity of Pleasant St. will initiate an effort to redevelop east of the core downtown area. Therefore aside from already benefiting from the proximity to the subway station and core downtown area, the site has a potential to be in the center of a redevelopment scheme. The site is composed of two parcels of land currently occupied by 2,785 square feet of retail

Aerial view of proposed site

space and an auto shop. Immediately east of the site there is a luxury residential high rise, to the north and west of the site are a set of duplexes, and south of the site, across Pleasant St. is the City of Malden Fire Department along with a surface parking lot. The site is currently a Neighborhood Business District, so a rezoning proposal will need to be made. The site has a total area of 27,680 square feet.

Ground view of proposed site

101


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST. -

Proposal Given the site characteristics, we propose the development of a 42 unit residential project that will provide 21 parking spaces. Additionally, included in the building program is 1,500 gross square feet of community space. As the city permits, the residential complex will be 6 stories high. A complete summary of the building program is show on the diagram to the right. The building occupies 90% of the site with the remaining 10% left for surface parking.

BUILDING PROGRAM RESIDENTIAL UNITS Net Sf / Unit 1 Bedroom 650 2 Bedroom 900 3 Bedroom 1,250 Total

Efficiency Gross SF / Unit No. of Units 85% 747.5 6 85% 1035 30 85% 1437.5 6 42

PARKING Spaces/Unit Total No. of Spaces

Total Net SF 4,485 31,050 8,625 44,160

0.5 21

COMMUNITY SPACE Community Space

Efficiency 90%

Gross SF 1,500

Net SF 1,350

102


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST. - FINANCIAL ANALYSIS

Financial Analysis 299 Pleasant St. will provide 100% affordable units, as such, the project will be funded through federal and state LIHTC, state soft debt, and a 24.4% loan-to-cost construction loan. Given the rents were set at a maximum 60% AMI, the project qualifies for federal and state LIHTC funding. 10% of the units are designated for families earning less than 30% AMI to comply with the federal LIHTC regulation. On average the monthly per-square-foot rent was calculated to be $1.24. Additionally, given the unit mix is family oriented, the project also qualifies as a 4th funding priority tax credit project as noted by the Massachusetts Qualified Allocation Plan for FY 2014. The project will also receive funding from the Affordable Housing Trust (AHTF) and the Commercial Area Transit Node Housing Program (CATNHP). The remaining costs of the project will be funded through a 24.4% loan-tocost fixed rate construction loan.

299 PLEASANT ST: SOURCES AND USES

Total

Year 0

USES Total Development Costs Construction Loan: Capitalized Interest Total Capital Costs

$ $ $

19,606,735 17,244 19,623,979

$ $ $

Cash Flow from Operations NOI Less: Construction Loan Interest during Operations Cash Flow from Operations after Interest

$ $ $

810,891 180,182 630,709

$ $ $

TOTAL USES

$

18,993,270

$

SOURCES Construction Loan Funding Net Draws Net Accrued Interest Net Construction Loan Funding

$ $ $

4,786,235 197,426 4,983,661

$ $ $

Equity Federal LIHTC State LIHTC Affordable Housing Trust CATNHP Additional Equity Required Permanent Mortgage Refinancing Less: Positive Cash Flow after Interest—Distributed Less: Cash Proceeds from Construction Loan Takeout

$ $ $ $ $ $ $ $ $

14,820,500 11,056,500 1,764,000 1,000,000 1,000,000 (810,891) -

$ $ $ $ $ $

$

18,993,270

$

Construction Loan Takeout at Stabilization Permanent Mortgage Amount for Income Property Construction Loan Ending Balance for Income Property Cash Proceeds from Construction Loan Takeout

$ $ $

4,983,661 4,983,661 -

Depreciable Basis Total Development Cost Excluding Interest Interest Accrued During Construction Period Total Capital Costs Land Cost Depreciable Basis

$ $ $ $ $

19,606,735 17,244 19,623,979 487,735 19,136,244

Year 1

487,735 487,735

-

Year 2

$ 17,398,290 $ 17,244 $ 17,415,534

$ $ $

1,720,710 1,720,710

$ $ $

$ $ $

810,891 180,182 630,709

$ 17,415,534

$

1,090,001

$ $ $

3,065,525 17,244 3,082,769

$ $ $

1,720,710 180,182 1,900,892

$ 14,332,765 $ 10,568,765 $ 1,764,000 $ 1,000,000 $ 1,000,000 $ -

$ $ $ $ $ $ $ $ $

-

Construction Loan Balance to Be Refinanced

TOTAL SOURCES

Annual Depreciation Estimate Depreciation Period (years) Acceleration Factor Annual Depreciation

$

$

487,735

487,735 487,735 -

487,735

$

-

$ 17,415,534

$

(810,891) 1,090,001

27.5 1 695,863

103


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST. - FINANCIAL ANALYSIS

299 PLEASANT ST: ASSUMPTIONS RENT AND VACANCY Lot Size

27,680

RESIDENTIAL UNITS 1 Bedroom 2 Bedroom 3 Bedroom Total

Net Sf / Unit 650 900 1,250

Efficiency Gross SF / Unit 85% 747.5 85% 1035 85% 1437.5

No. of Units

Total Net SF 4,485 31,050 8,625 44,160

6 30 6 42

PARKING SF per Space Required Spaces / Unit Total No. of Spaces Required

250 0.5 21

RENT Residential Community Space Parking Total

Gross SF 44,160 1,500 5,250 50,910

Efficiency 85% 90%

Net SF Rent/Mo 37,536 $ 1.24 1,350 $ $ 38,886

Annual Revenue $ 657,101 $ $ $ 657,101

Annual Revenue Growth

3%

VACANCY Vacancy Bad Debt EXPENSES OPEX / Unit Annual increase in operating expenses Increase in real estate taxes OPERATING RESERVE Lease-Up Period (months) Average Occupancy During Lease-Up Estimated Rent During Lease-Up Estimated Operating Expenses During Lease-Up NOI During Lease Up Construction Interest During Lease-Up

0% 0.5%

$

$ $ $ $

5,500 3% 3%

12 100% 657,101 231,000 426,101 256,835

DEVELOPMENT COSTS CONSTRUCTION COSTS Hard Costs Soft Costs Developer Fee Total Construction Costs

Residential/SF $ 220.00 $ 44.00 $ 6.60 $ 270.60

20% 2.5%

Contingency

2.5% of hard costs

ACQUISITION PRICE Price per SF Lot Size (SF) Land Purchase Price Land Carry (12 months)

Total Residential $ 10,045,200 $ 2,009,040 $ 251,130.00 $ 12,305,370 $

$ $ $ $

Parking/SF 1,000.00 200.00 25.00 1,225

251,130

$ $ $ $ $

Total Parking 5,250,000 1,050,000 131,250 6,431,250

Total $ 15,295,200 $ 3,059,040 $ 382,380 $ 18,736,620

131,250 $

382,380

$

17.00 27,680 470,560 17,175

$ $

3.65%

TOTAL DEVELOPMENT COSTS Construction Costs Contingency Land Total Development Costs before Interest and Operating Reserve

$ 18,736,620 $ 382,380 $ 487,735 $ 19,606,735

Estimated Construction Loan Interest First Year Operating Reserve

$ $

TOTAL DEVELOPMENT COSTS

$ 19,604,412

FINANCING Interest rates Construction Permanent Amortization (yrs) DCR Construction Period (months) Average Draw

166,943 (169,266)

4.5% 5.0% 30 1.2 12 65%

EQUITY SOURCES Maximum / Unit $50,000 $50,000

Affordable Housing Trust CATNHP

Units 42 $ 42 $

Total Units Maximum Allowed Subsidy Amount 2,100,000 $ 1,000,000 $ 1,000,000 2,100,000 $ 1,000,000 $ 1,000,000

LIHTC TAXABLE INCOME Income Tax Rate Depreciation Period (years) PROPERTY SALE Purchase Cap Rate Sale Cap Rate Percent of sale price for broker, lawyer, etc. Capital gains tax rate Accumulated depreciation recapture tax rate

35% 27.5

7.00% 6.75% 3% 20% 25%

Total eligible development cost DDA basis boostb@ 130% Eligible basis Applicable fraction Total qualified basis Applicable tax credit percentage Annual allowable tax credit DHCD annual tax credit limit per unit Total Credit limit Term (years) Credit Amount Syndication rate Syndicated value Ownership percentage

FEDERAL $ 12,305,370 NO $ 12,305,370 100% $ 12,305,370 9.0% $ 1,107,483 $ 250,000 $ 10,500,000 10 $ 1,228,500 $ 0.90 $ 11,056,500 3%

$ $ $ $ $ $ $ $ $

STATE 12,305,370 NO 12,305,370 100% 12,305,370 4.8% 590,658 250,000 10,500,000 5 504,000 0.70 1,764,000 3%

Syndication Schedule Time Zero 25% Dev. Period 50% Dev. Period 75% Dev. Period 100% Dev. Period Lease-Up Period Operational Period

35% 0% 35% 0% 30% 0% 0%

$ $ $ $ $ $ $

FEDERAL 3,869,775 3,869,775 3,316,950 -

$ $ $ $ $ $ $

STATE 617,400 617,400 529,200 -

104


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST. - FINANCIAL ANALYSIS

299 PLEASANT ST: PRO-FORMA NOI Factor REVENUE Annual Gross Potential Revenue Less: Vacancy Less: Bad Debt Effective Gross Revenue EXPENSES Annual Expenses

$

Total

0% 0.5%

5,500 /unit

NOI Annual NOI

DEBT CALCULATION Total Development Costs Subsidy Sources Federal LIHTC State LIHTC Affordable Housing Trust CATNHP Loan Needed Debt Based on DCR Monthly NOI Maximum DCR Maximum Monthly Payment Maximum Loan CASH FLOW AFTER FINANCING NOI Less: Annual Debt Service Less: CapEx Cash Flow After Financing

0.6%

$ $ $ $

657,101 (3,285.50) 653,815

$

231,000

$

422,815

$

19,606,735

$ $ $ $ $

11,056,500 1,764,000 1,000,000 1,000,000 4,786,235

$ $ $

35,235 1.15 30,639 5,707,443

$ $ $ $

422,815 367,665 2,537 52,613

SIMPLE RATIOS Overall Return (NOI/Dev. Cost)

2.2%

CASH-ON-CASH RETURN NOI Annual Debt Service Cash Throw-Off

$ $ $

422,815 367,665 55,150

Development Cost Permanent Mortgage Equity

$ $ $

19,606,735 4,786,235 14,820,500

Cash-on-Cash Return

0.4%

105


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST. - FINANCIAL ANALYSIS

299 PLEASANT ST: DEVELOPMENT PERIOD CASH FLOWS

Data

DEVELOPMENT COSTS Land Land Carry Hard Costs Soft Costs Contingency Developer Fee Total Development Costs, Excl. Constr. Loan Interest and Operating Reserve OPERATING INCOME/ (LOSS) DURING LEASE UP Initial Occupancy Upon Opening Months to Reach Stabilized Occupancy Spaces Leased per Quarter Cumulative No. Of Spaces Leased Vacancy Due to Lease Up (% of Gross Potential) Stablized Vacancy (% of Gross Potential) Overall Vacancy Rate Gross Potential Revenue Vacancy Loss Bad Debt Effective Gross Revenue Operating Expenses NOI

Total

$ 470,560 $ 470,560 $ 17,175 $ 17,175 $ 15,295,200 $ 15,295,200 $ 3,059,040 $ 3,059,040 $ 382,380 $ 382,380 $ 382,380 $ 382,380 $ 19,606,735 $ 19,606,735

$ $ $ $ $ $ $

Year 1 Total

470,560 17,175 487,735

70% 12 42

42

3% $

3% $

164,275 $ $ 0.5% $ $ 57,750 $ $

EQUITY ACCOUNT BALANCE Total Development Costs Maximum Loan Balance Equity Required Equity Available Federal LIHTC State LIHTC Affordable Housing Trust CATNHP Equity Account Ending Balance

$ $ $ $ $ $ $ $

19,606,735 4,786,235 14,820,500 14,820,500 11,056,500 1,764,000 1,000,000 1,000,000

657,101 (73,924) (3,286) 579,891 231,000 810,891

$ $ $ $ $ $

29.4 29.4 65.0% 0.0% 65.0% -

$ $ $ $ $ $

(487,735) $ (17,398,290) $

$ $ $ $ $ $ $

487,735 $ 14,332,765 $ 487,735 $ 14,332,765 $ 487,735 $ 10,568,765 $ $ 1,764,000 $ $ 1,000,000 $ $ 1,000,000 $ 487,735 $ 14,820,500 $ 14,820,500

4,786,235 4,930,612 4,786,235 4,930,612 2,768,405 197,426 17,244 180,182 4,983,661 197,426 4,983,661

$

3,065,525 3,065,525 3,065,525 3,065,525 1,532,763 17,244 17,244 3,082,769 17,244 3,082,769

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

3,823,800 382,380 47,798 95,595 4,349,573

$ 3,823,800 $ 3,823,800 $ 382,380 $ 382,380 $ 47,798 $ 47,798 $ 95,595 $ 95,595 $ 4,349,573 $ 4,349,573

$ $ $ $ $

3,823,800 382,380 $ 47,798 $ 95,595 4,349,573 $

29.4 29.4 65.0% 0.0% 65.0% $ $ $ $ $ $

(909,819) $ (4,349,573) $ (4,349,573) $ (4,349,573) $ (4,349,573) $

1,720,710 4,930,612 1,720,710 4,930,612 4,004,047 180,182 180,182 4,983,661 180,182 4,983,661

$ $ $ $ $ $ $

4,349,573 4,349,573 1,732,173 617,400 1,000,000 1,000,000 4,837,308

$ 4,349,573 $ 4,349,573 $ $ 4,349,573 $ 4,349,573 $ $ 3,732,173 $ 3,820,373 $ $ 617,400 $ 529,200 $

LEASE-UP PERIOD Quarter 6 Quarter 7

Quarter 5

1,284,047 $ 1,284,047 1,284,047 -

Quarter 8

382,380 $ 47,798 $

382,380 $ 47,798 $

382,380 47,798

430,178 $

430,178 $

430,178 $

430,178 $

4.2 33.6 25.0% 0.0% 25.0% 164,275 (41,069) (821) 122,385 57,750 180,135

4.2 37.8 15.0% 0.0% 15.0% 164,275 (24,641) (821) 138,813 57,750 196,563

4.2 42 5.0% 0.0% 5.0% 164,275 (8,214) (821) 155,240 57,750 212,990

0 42 0.0% 0.0% 0.0% 164,275 (821) 163,454 57,750 221,204

$ $ $ $ $ $

$ $ $ $ $ $

$ $ $ $ $ $

$ $ $ $ $ $

(250,042) $

(233,615) $

(217,187) $

(208,974) $

-

-

-

-

$

$

$

FIRST STABILIZED YEAR Quarter 10 Quarter 11

Quarter 9

382,380 $ 47,798 $

-

0 42 0.0% 0.0% 0.0% 169,203 (846) 168,357 59,483 227,840

$

-

$ $ $ $ $ $

0 42 0.0% 0.0% 0.0% 169,203 (846) 168,357 59,483 227,840

227,840 $

$

-

$ $ $ $ $ $

0 42 0.0% 0.0% 0.0% 169,203 (846) 168,357 59,483 227,840

227,840 $

Quarter 12

$

-

$ $ $ $ $ $

0 42 0.0% 0.0% 0.0% 169,203 (846) 168,357 59,483 227,840

227,840 $

Year 3 Total

$

-

$ $ $ $ $ $

0 42 0.0% 0.0% 0.0% 676,814 (3,384) 673,430 237,930 911,360

227,840 $

911,360

$ 9,186,880 $ 13,536,453 $ 14,820,500 $ 14,820,500 $ 14,820,500 $ 14,820,500 $ 14,820,500

$

-

$

-

$

-

$

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

-

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

-

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

-

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

3,065,525 3,065,525 3,065,525 3,065,525 1,532,763 17,244 17,244 3,082,769 17,244 3,082,769

$ 3,082,769 $ 3,550,047 $ 4,022,583 $

4,500,434

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

430,178 4,930,612 430,178 4,930,612 4,715,523 53,050 53,050 4,983,661 53,050 4,983,661

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

-

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

Total Additional Equity Required

$

-

$

-

$

-

$

-

$

-

$

-

$

-

$

-

Net Cash Flow After Debt

$

-

$

-

$

810,891 $

-

$

-

$

-

$

-

$

180,135 $

4.5%

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $

$ $ $

$ $ $ $ $

Quarter 4

12.6 42 11.3% 0.0% 11.3% 657,101 (73,924) (3,286) 579,891 231,000 810,891

$ (18,795,844) $

14,820,500 14,820,500 11,056,500 1,764,000 1,000,000 1,000,000 14,820,500

DEVELOPMENT PERIOD Quarter 2 Quarter 3

Quarter 1

Year 2 Total

$ $ $ $ $ 15,295,200 $ $ 1,529,520 $ 1,529,520 $ 191,190 $ 191,190 $ 382,380 $ $ 17,398,290 $ 1,720,710

0%

Net Cash Flow Before Debt During First Three Years

CONSTRUCTION LOAN ACCOUNT Beginning Balance Loan Draws Construction Draw (Initial Request) Operating Deficit Trial Balance Additional Equity Required Net Construction Draw Ending Balance Before Interest Average Loan Balance Before Interest Total Construction Loan Interest Interest Accrued During Construction Period Interest Accrued During Operating Period Interest Paid from Operations Trial Ending Balance Additional Equity Required Net Interests Accrued Ending Balance

Time Zero

430,178 3,512,947 430,178 3,512,947 3,297,858 37,101 37,101 3,550,047 37,101 3,550,047

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

430,178 3,980,225 430,178 3,980,225 3,765,136 42,358 42,358 4,022,583 42,358 4,022,583 -

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

196,563 $

430,178 4,452,760 430,178 4,452,760 4,237,671 47,674 47,674 4,500,434 47,674 4,500,434 -

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

212,990 $

221,204

106


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST. - FINANCIAL ANALYSIS

299 PLEASANT ST: DEVELOPMENT AND OPERATIONAL PERIOD PROJECT COSTS Development Costs Land Cost FINANCING ASSUMPTIONS Equity Mortage Principal Interest Rate Amortization Annual Debt Service DEPRECIATION ASSUMPTIONS Building Basis Life (in years) Acceleration Factor Straight Line

MORTGAGE CALCULATION Beginning Balance Ending Balance Amortization of Principal Interest/Annual Payment

$ $

$ $

$

$

$

Total 19,119,000 487,735

14,820,500 4,786,235 5.0% 30 years 308,323

18,631,265 27.5 1 677,501

$

4,983,661

5.0% $

DEPRECIATION CALCULATION Beginning Balance Less: Annual Depreciation Ending Balance Cumulative Depreciation Taken Cumulative Straight Line Recapture Remaining Book Value ANNUAL CASH FLOWS Gross Potential Revenue Less: Vacancy Vacancy Rate Less: Bad Debt Effective Gross Revenue

DEVELOPMENT PERIOD Year 1 Year 2

Year 0

321,040 Year 0

Year 1 $ $ $ $ $ $ $

Year 0

Year 1

Year 2 657,101 (73,924) 11.3% (3,285.5) 579,891

Year 3 676,814 0.0% (3,384.1) 673,430

Year 4 17,744,517 695,863 17,048,653 2,087,590 2,087,590 2,087,590 17,048,653 Year 4 697,118 0.0% (3,485.6) 693,633

Year 5 17,048,653 695,863 16,352,790 2,783,454 2,783,454 2,783,454 16,352,790

-

$

231,000 $

-

Net Operating Income Less: Construction Loan Interest During Operating Period Less: Annual Debt Service Add: Operating Reserve Funded by Construction Loan Cash Flow After Debt Service Less: LICTH Ownership Distributions Federal State Before-Tax Operating Cash Flow

$ $

-

$ $

673,430 $ (180,182) $ (321,040) $

693,633 $ (180,182) $ (321,040) $

$

-

$ $

348,891 $ (180,182) $ $ 168,709 $

172,207 $

$ $ $

-

$ $ $

(5,061) $ (5,061) $ 158,587 $

Taxes

$

-

$

-

After-Tax Operating Cash Flow

$

-

$

158,587 $

-

INCOME TAX CALCULATION Net Operating Income Deduct: Interest Deduct: Depreciation Taxable Income/(Loss) Passive Loss Offset

Year 0

Taxable Income Passive Loss Carryforward 35%

-

-

Year 1 $ $ $ $ $

-

$ $ $ $ $

$ $

-

$ $

$

-

$

-

Year 2 348,891 (180,182) (695,863) (527,154) -

$ $

$

$ $ $ $ $

$ (527,154.06) $ -

$

$ $

$ $ $ $ $ $ $

$

3.0%

$ $

$ $ $ $ $ $ $

$ $

0.0% 0.5%

$ $

Year 3 18,440,380 695,863 17,744,517 1,391,727 1,391,727 1,391,727 17,744,517

$ $ $ $

Year 5 4,832,845 4,751,602 81,243 239,797

$ $

Annual Income Taxes

$ $

$ $ $ $ $ $ $

$ $ $ $

Year 4 4,910,134 4,832,845 77,289 243,751

65.0% -

Total Operating Expenses

3.0%

Year 2 19,136,244 695,863 18,440,380 695,863 695,863 695,863 18,440,380

$ $ $ $

Year 3 4,983,661 4,910,134 73,527 247,513

$ $ $

$ $

$ $ $ $

Year 9 4,482,071 4,382,882 99,190 221,851

$ $ $ $

Year 10 4,382,882 4,278,617 104,264 216,776

$ $ $ $

$ $ $ $ $ $ $

Year 6 16,352,790 695,863 15,656,927 3,479,317 3,479,317 3,479,317 15,656,927

$ $ $ $ $ $ $

Year 8 14,961,063 695,863 14,265,200 4,871,044 4,871,044 4,871,044 14,265,200

$ $ $ $ $ $ $

Year 9 14,265,200 695,863 13,569,336 5,566,907 5,566,907 5,566,907 13,569,336

$ $ $ $ $ $ $

Year 10 13,569,336 695,863 12,873,473 6,262,771 6,262,771 6,262,771 12,873,473

Year 11 $ 12,873,473 $ 695,863 $ 12,177,610 $ 6,958,634 $ 6,958,634 $ 6,958,634 $ 12,177,610

Year 10 832,396 0.0% (4,162.0) 828,234

Year 11 857,368 0.0% $ (4,286.8) $ 853,081

$ $ $ $

$ $

Year 7 761,760 0.0% (3,808.8) 757,951

$ $ $ $

Year 8 784,613 0.0% (3,923.1) 780,690

$ $ $ $

Year 9 808,151 0.0% (4,040.8) 804,110

$ $ $ $

$ $

57,750 $

59,483

714,442 $ (180,182) $ (321,040) $

735,875 $ (180,182) $ (321,040) $

700,201 $ (180,182) $ (321,040) $

722,940 $ (180,182) $ (321,040) $

746,360 $ (180,182) $ (321,040) $

770,484 $ (180,182) $ (321,040) $

793,598 (180,182) (321,040)

192,410 $

213,219 $

234,652 $

198,979 $

221,717 $

245,138 $

269,261 $

292,376

(5,166) $ (5,166) $ 161,875 $

(5,772) $ (5,772) $ 180,865 $

(6,397) $ (6,397) $ 200,426 $

(7,040) $ (7,040) $ 220,573 $

(5,969) $ (5,969) $ 187,040 $

(6,652) $ (6,652) $ 208,414 $

(7,354) $ (7,354) $ 230,430 $

(8,078) (8,078) 253,105

-

-

-

-

-

-

-

Year 3 673,430 (67,331) (695,863) (89,765) -

$ $ $ $ $

$ (616,918.83) $ -

$

Year 4 693,633 (63,569) (695,863) (65,800) -

$ $ $ $ $

$ (682,718.92) $ -

$

$

200,426 $ Year 5 714,442 (59,615) (695,863) (41,037) -

$ $ $ $ $

$ (723,755.77) $ -

$

-

$ $

Year 7 15,656,927 695,863 14,961,063 4,175,180 4,175,180 4,175,180 14,961,063

57,750 $

180,865 $

$

Year 6 739,573 0.0% (3,697.9) 735,875

$ $ $ $ $ $ $

Year 11 4,278,617 4,169,019 109,599 211,442

57,750 $

$

-

Year 8 4,576,433 4,482,071 94,362 226,679

57,750 $

161,875 $

$

Year 5 718,032 0.0% (3,590.2) 714,442

$ $ $ $

$

$

-

$ $

$ $ $ $

INVESTMENT PERIOD Year 6 Year 7 4,751,602 $ 4,666,202 4,666,202 $ 4,576,433 85,400 $ 89,769 235,641 $ 231,271

$

220,573 $ Year 6 735,875 (55,459) (695,863) (15,447) -

$ $ $ $ $

$ (739,202.82) $ -

$

$

187,040 $ Year 7 700,201 (51,089) (695,863) (46,752) -

$ $ $ $ $

$ (785,954.40) $ -

$

$

208,414 $ Year 8 722,940 (46,497) (695,863) (19,420) -

$ $ $ $ $

$ (805,374.70) $ -

$

$

230,430 $ Year 9 746,360 (41,669) (695,863) 8,828 (8,828.12)

253,105

$ $ $ $ $

Year 10 770,484 (36,594) (695,863) 38,026 (38,026.16)

$ (796,546.57) $

(758,520.42)

-

$

Year 11

-

107


VI. ASIAN CDC - PROPOSAL II - 299 PLEASANT ST. - FINANCIAL ANALYSIS

SALE CALCULATION (INCLUDING TAX) Cash Flow from Sale Sale Price (cap rate applied to following year NOI) Less: Commission Adjusted Sales Price Less: Remaining Mortgage Balance Before-Tax Cash Flow from Sale

SALE 6.75% 3%

$ $ $ $ $

11,757,010 293,925 11,463,085 4,278,617 7,184,467

Total Tax at Sale

$

182,765

After-Tax Cash Flow from Sale

$

7,001,702

Tax Calculation from Sale Adjusted Sales Price Remaining Book Value Total Taxable Gain Passive Loss Carryforward Total Net Taxable Gain

$ $ $ $ $

11,463,085 12,873,473 (1,410,388) (758,520) (651,868)

Total Depreciation Taken Recapture Tax

25%

$ $

6,262,771 1,565,693

Capital Gain Tax on Capital Gain

20%

$ $

(6,914,639) (1,382,928)

$

182,765

Total Tax at Sale RETURN MEASURES Unleveraged IRR Project Cost Subsidies Net Operating Income Adjusted Sales Price Unleveraged Cash Flow Unleveraged IRR Net Present Value

Year 0 $ $

8% $

8% $

Year 4

Year 5

Year 6

Year 7

Year 8

(487,735) $ 487,735 $ $

(17,398,290) $ 14,332,765 $ - $

(1,720,710) 348,891 $

673,430 $

693,633 $

714,442 $

735,875 $

700,201 $

722,940 $

$

-

$

(3,065,525) $

(1,371,819) $

673,430 $

693,633 $

714,442 $

735,875 $

700,201 $

722,940 $

$ $

(487,735) $ 487,735 $ $

(17,415,534) $ 14,332,765 - $

158,587 $

161,875 $

180,865 $

200,426 $

220,573 $

187,040 $

208,414 $

$

-

$

(3,082,769) $

(1,562,123) $

161,875 $

180,865 $

200,426 $

220,573 $

187,040 $

208,414 $

$ $

(487,735) $ 487,735 $ $

(17,415,534) $ 14,332,765 - $

158,587 $

161,875 $

180,865 $

200,426 $

220,573 $

187,040 $

208,414 $

-

(3,082,769) $

(1,562,123) $

161,875 $

180,865 $

200,426 $

220,573 $

187,040 $

208,414 $

$

8% $

Year 3

Year 9

Year 10

746,360 $ $ 746,360 $

770,484 11,463,085 12,233,568

230,430 $ $ 230,430 $

253,105 7,184,467 7,437,573

230,430 $ $ 230,430 $

253,105 7,001,702 7,254,808

(1,720,710)

8.4% 125,206

After-Tax IRR Capital Costs Subsidies After-Tax Operating Cash Flow After-Tax Cash Flow from Sale Total After-Tax Cash Flow After-Tax IRR Net Present Value

Year 2

21.2% 4,818,849

Before-Tax IRR Capital Costs Subsidies Before-Tax Operating Cash Flow Before-Tax Cash Flow from Sale Total Before-Tax Cash Flow Before-Tax IRR Net Present Value

Year 1

$

(1,720,710)

8.1% 40,551

108


HARVARD UNIVERSITY GRADUATE SCHOOL OF DESIGN GSD 5212 Field Study in Real Estate, Planning, and Urban Design: Malden, MA Downtown Revitalization and Affordable Housing in the City of Malden A Field Study Research Report of the Harvard Graduate School of Design Richard Peiser, Michael D. Spear Professor of Real Estate Development Authors Alexander Akel, MDes REBE - Master in Design Studies - Real Estate and the Built Environment Alison Crowley, MCP/MSRED - Master in City Planning / Master of Science in Real Estate Development Greg Demaiter, MDes REBE - Master in Design Studies - Real Estate and the Built Environment Stephanie Torres, MDes REBE - Master in Design Studies - Real Estate and the Built Environment Weishun Xu, M.Arch I - Master in Architecture I Image Credits Unless otherwise noted, photographs were taken by students and all images and graphs related to the research were found on the world wide web. The Harvard University Graduate School of Design is a leading center for education, information, and technical expertise on the built environment. Its departments of Architecture, Landscape Architecture, and Urban Planning and Design offer masters and doctoral degree programs and also provide the foundation for Advanced Studies and Executive Education programs. Copyright 2014, The President and Fellows of Harvard College All rights are reserved.

109


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.