Mixed-use, Mixed-income Housing Development Proposal

Page 1

3rd & Binney Apartments and Condos Mixed-use & Mixed-income Development

Katherine Mella Yuqi Wang

Instructors: Peter Roth Alexis Wheeler

December 2013


2

3rd & Binney Apartments and Condos


TABLE OF CONTENTS

COVER LETTER

COVER LETTER ........................................................................................................................1

Dear Lenders,

EXECUTIVE SUMMARY ...........................................................................................................2

I’m applying for funding for two components of a large development project consisting of 425 rental (affordable and market-rate) and condominium units. This project will be developed in Cambridge, Massachusetts, on a parcel situated on the corner of 3rd and Binney Streets.

COVER SHEET ...........................................................................................................................3 INTRODUCTION ........................................................................................................................5 MISSION STATEMENT .............................................................................................................5 CONTEXT ...................................................................................................................................6 THE NEIGHBORHOOD .............................................................................................................7 ZONING ANALYSIS ..................................................................................................................8 NEIGHBORHOOD PLAN ..........................................................................................................9 PROGRAM SUMMARY...........................................................................................................11 SITE PLAN ...............................................................................................................................13 PLOOR PLAN...........................................................................................................................15 SECTIONS ................................................................................................................................19 DESIGN FEATURES ................................................................................................................24 TYPICAL UNIT PLANS ...........................................................................................................25 PROJECT PROGRAM.............................................................................................................25 OUTLINE SPECIFICATION MEMO .......................................................................................26

For the rental component of the project, I am applying for the following: ·

$49,000,000 for a Construction/Bridge Loan from MassHousing

·

$43,500,000 for a MassHousing Permanent loan

·

$10,000,000 of 9% Low Income Housing Tax Credits

·

$9,397,822 of 4% Low Income Housing Tax Credits

·

$2,704,367 of MassHousing Priority Development Funds

·

$1,000,000 of Massachusetts HOME

·

$1,000,000 of Cambridge HOME

·

$3,000,000 of Cambridge Housing Trust funds

·

$1,000,000 of Affordable Housing Trust funds

·

$12,556,249 of cash equity

For the condominium component of the project, I am applying for the following: ·

$35,100,000 for a Construction loan

·

$13,682,182 of cash equity

FINANCING PLAN ..................................................................................................................27 MARKETING PLAN .................................................................................................................28 APPENDIX A: CONDOMINIUM AND RENTAL PROFORMAS...........................................29

1

The mission of the project is to create a mixed-income and mixed-use project that will cater to a variety of demographics, including young professionals, families, and retired couples at both marketrate and affordable pricing. In addition, the commercial and retail components will bolster the existing amenities in the Kendall Square/East Cambridge neighborhoods, particularly with the addition of a sorely needed grocery store. The development will also offer community features through the creation of abundant open, green space and a day care center.

Mixed-use & Mixed-income Development


EXECUTIVE SUMMARY The 3rd and Binney Apartments and Condos development is situated in East Cambridge, in the heart of action and continuous growth by Kendall Square. In responding to the neighborhood context and distinct opportunities, the project’s mission centers around creating a dense, mixed-use and mixed-income development that responds to the existing demand of residential options, in addition to bolstering the neighborhood’s amenities through commercial and retail, as well as community uses. To reflect this mission, the development’s program centers around three major components: residential, commercial and retail, and community uses. 2

Financing Plan To cover the development costs of the mixed-income component of the project, 9% and 4% tax credits are being used to fund the affordable units at 60% AMI. In addition Priority Development funds are used to support the use of 4% credits. The rest of the sources involve substantial grants from Massachusetts and Cambridge HOME funds, as well as Cambridge housing trust sources. A construction/bridge loan and equity round out the sources. For the condominium portion of the project, a construction loan equal to 65% of costs as well as proceeds from condo sales and cash equity cover the development costs. The resulting profit is equal to 16% of costs.

Residential To address the need of both affordable and market rate rental units in the city and in the East Cambridge neighborhood, the project has a for-sale condominium component, which is a 15-story high-rise tower with a total of 123 market-rate units. The second residential section is mid-rise at 7 stories and high-rise at 10 stories. This component has 120 affordable rental units, which are 60% of the area median income, in addition to 182 market-rate rental units. The 402 residential units in the entire development range from studios to 3-bedroom units.

Commercial and Retail Over 15,000 square feet of commercial space will be dedicated to a grocery store to be anchored by Whole Foods, an amenity that is sorely lacking in East Cambridge. In addition, over 4,000 square feet of retail space will be created along 3rd Street, extending the existing retail from Kendall and along 3rd Street up through East Cambridge. This retail space would ideally add to the variety of options currently available in close proximity to the site.

Community 2,500 square feet will be dedicated to a day care center to fill an existing demand for additional childcare options in East Cambridge. This will be a valuable community amenity and aid in attracting more families to the neighborhood and our residences. Open green space will also be created on the ground level off of Munroe Street as well as on two of the rooftops of the development. This will be a wonderful feature for both residents and the Cambridge community at large.

Target Demographic Given the site’s proximity to both institutional as well as office and laboratory space, which is continuously expanding, the development is a prime residential location for young professionals moving to the city for employment, as well as recently graduated individuals. The existing and key amenities being developed will also attract families and retired couples, who are looking for convenient access to public transportation and desirable amenities like restaurants and coffee shops.

3rd & Binney Apartments and Condos

Overall, the development will activate a prime location, which currently exists as a large gap in the streetscape. The generated activity created from the dense residential uses, as well as retail, commercial, and outdoor space will be key in turning Kendall Square and East Cambridge into a truly vibrant 18-hour community.


COVER SHEET Proposed building by type Proposed buildings by and typesize and size

Proposed Building Market‐rate Condominiums Market‐rate and Affordable Apartments

Type Residential

Grocery store

Commercial

3rd street retail space

Retail

Day Care Center

Community

Parking

Underground Parking

Residential

Size 15 story high rise tower 7 story midrise and 10 story high rise tower one story – first floor of 10 story high rise one story one story – first floor of 15 story high rise 2 levels

Rental Apartments (10 stories of units)

Rental Type 60% AMI

Dwelling unit destribution by floor, size, bedroom/bath number and handicap designation For Sale Condos (14 stories of units)

Unit Type

Floors 2‐7

Studio A Studio B 2 bedroom A 2 bedroom B 3 bedroom A 3 bedroom B 3 bedroom C

Subtotal Floors 8‐15

Subtotal Total Condo Units

Studio C 1 bedroom A 2 bedroom C 2 bedroom B 2 bedroom A 3 bedroom C 3 bedroom B 3 bedroom A

Market Rate # of Units 6 18 6 6 6 6 6 54 7 16 8 8 8 8 8 6 69 123

# of Baths

Handicap Accessibility

1 1 2 2 2 2 2

Yes Yes Yes Yes Yes Yes Yes

Net Sq. Ft. 432.0 435.0 913.5 918.0 1030.0 1109.0 1134.0

1 1 1 2 2 2 2 2

Yes Yes Yes Yes Yes Yes Yes Yes

518.0 609.0 823.5 918.0 913.5 1134.0 1109.0 1030.0

Total Rental Units

Unit Type

120

Studio A Studio B Studio C 1 bedroom 2 bedroom 3 bedroom A 3 bedroom B 3 bedroom C 3 bedroom D 182 Studio A Studio B Studio C 1 bedroom 2 bedroom 3 bedroom A 3 bedroom B 3 bedroom C 3 bedroom D

Net Sq. Ft.

1 1 1 1 2 2 2 2 2 1 1 1 1 2 2 2 2 2

Handicap Accessibility Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

# of Units # of Baths 4 4 4 18 67 6 6 5 6 9 8 11 85 60 1 1 3 4 302

435.0 443.5 525.0 609.0 913.5 1134.0 1160.0 1224.0 1247.0 435.0 443.5 525.0 609.0 913.5 1134.0 1160.0 1224.0 1247.0

Mixed-use & Mixed-income Development

3


Square footage breakdown between commercial, residential, community and other usage in the buildings.

4

Building Usage Residential Market‐rate Condominiums Market‐rate and Affordable Apartments Commercial & Retail Grocery store 3rd street retail Community Day Care Center Other Parking (underground)

Square Footage (Footprint) 8757 40,198.5 15,707 4,386 2,522 45,542

Number of parking spaces, parking ratio required and proposed Residential Spaces Whole Foods Spaces Total Parking Spaces

Required Parking Ratio @ 1 425 75 500

Proposed Parking Ratio @. 4 170 75 245

2 levels of underground parking will offer 330 total spaces.

Dwelling units per acre under current zoning The majority of our parcel (71,862 square feet) is zoned C-2B residential under the base district and requires a minimum lot area of 600 square feet per unit. This equals about 120 units for the parcel and 72 units per acre.

Percentage breakdown of the tract to be occupied by buildings, by parking and other vehicular areas, and by open areas

• 65% of the parcel occupied by buildings • 35% occupied by open areas

3rd & Binney Apartments and Condos


INTRODUCTION The goal of 3rd & Binney Apartments and Condos is to create additional housing to serve the Kendall Square and East Cambridge parts of the city giving young professionals and families more options for comfortable living, as well as adding to the overall affordable housing stock of the Cambridge. In addition, we also want to create more commercial space and extend the existing retail corridor along 3rd Street.

MISSION STATEMENT Our mission is to create quality, affordable and market-rate units in an increasingly dense and popular urban area with convenient access to public transit and burgeoning job opportunities. As a mixed-use development, we will also provide attractive commercial uses and desired community amenities.

5

Mixed-use & Mixed-income Development


CONTEXT The 77,752 square feet parcel is located on the corner of 3rd and Binney Streets near Kendall Square, in the East Cambridge neighborhood of the city, which has undergone quite a transformation in recent years.

6

0.6 mile to Lechmere Square

2000 ft N

In addition to being near MIT’s campus, the site is also in close proximity to a large and continuously growing volume of office and laboratory space, home to predominantly high-tech companies. In addition, three luxury residential developments are within several blocks. To the north of the site is a more residential area of single and multi-family homes with a strong neighborhood and community feel.

Cambridge Facts & Figures • 39.6% of all households are family households • 40.7% of all households are single persons living • • • •

alone 19.7% are roommates As of 2010, the average household size is 2.0 people The median family income in Cambridge is $92,965 The average annual wage earned in Cambridge in 2012 was $96,200

0.25 mile

2 miles`to Harvard Square

Median monthly rents in Cambridge:

• • • •

Studio: $1800 1 bedroom: $2300 2 bedrooms: $2800 3 bedroom: $3175

1.28 miles to Central Square

0.24 mile to Kendall Square

1.85 miles to Boston Downtown

Starting monthly rents in Kendall Square area:

• • • •

Studio: $2100 1 bedroom: $2700 2 bedrooms: $3200 3+ bedrooms: $3800

The median market rate sales price for a condo in Cambridge is $445,500.

3rd & Binney Apartments and Condos

T Station

Zipcar

Hubway

Bike Route

Bus Stop Destination


THE NEIGHBORHOOD Our site is located to a variety of residential uses, particularly market-rate and luxury housing.

PLAYGROUND

1000 ft

N

BASEBALL FIELD

OTHER

Archstone Kendall Square Apartments

BASKETBALL

• “Provide modern living in one of the hottest neighborhoods in

OTHER

Cambridge”

PLAYGROUND

• Offers studios, one-bedroom and two-bedroom units in loft and duplex

BASKETBALL

floor plans • Studio rents start at $2,260/month; 1-bedrooms start at $2,185 and 2-bedrooms start at $2,575 • Amenities include 9-feet ceilings and a fitness center

PLAYGROUND PLAYGROUND

St.

3rd

5rd

Binney

Third Square Apartments

St.

St.

PLAYGROUND

PLAYGROUND PLAYGROUND

0.25 mile

• “Kendall’s premier property” • Offers a greater variety of unit sizes, from studios to 4-bedrooms • 2-bedroom rents start at $2,945/month while their 3+ bedrooms start at $5,667/month • Amenities include private patios/balconies and indoor swimming pool Watermark Kendall West

Bro

ad

wa y

• • • •

PLAYGROUND OTHER

“Brings a new level of apartment living to Cambridge” Offers 1 and 2 bedroom units 1-bedroom rents start at $3112 and 2-bedrooms start at $3,427 Amenities include 24-hour concierge service and a Zen garden

Transportation The site has excellent access to public transportation and is located a mile or less away from the following options:

PLAYGROUND

Main St.

• The red line and bus routes at Kendall Square • The green line and bus routes at Lechmere Station • Zipcar car-sharing location • NAVTEQ, Hubway bike-sharing location Copyright:© 2013 Esri, DeLorme, TomTom

Land Uses Residential Mid-rise Residential High-rise Commercial Mixed Use (O+C) Mixed Use (R+C) Under Construction

7

Neighborhood Amenities Office Institution Industry Parking Lot On Street Meter Parking

Restaurant Cafe Bar T Station Zip-car Hubway

School Daycare Church Green Space Outdoor

The site also located near major roadway access to other parts of Cambridge, Boston and Somerville via the following:

Zipcar

• • • • •

Monsignor O’Brien Highway Binney Street Memorial Drive Storrow Drive Longfellow Bridge

Mixed-use & Mixed-income Development


ZONING ANALYSIS

Transfer of Development Rights (TDR) District of East Cambridge

Zoning District Designations: • 71,862 square feet of the parcel is zoned C-2B (residential) • 5,889 square feet of the parcel along 3rd Street is zoned BA (business) Allowed Development As-of-right

8

Allowed Uses Residential Retail Business and Consumer Service

Other

Townhouse dwellings and multifamily dwellings (apartments, condos) (1) Stationery and office supply store. (2) Printing and reproduction service establishment, photography studio. (3) Other store for retail sale of merchandise located in a structure primarily containing non‐retail use provided no manufacturing, assembly or packaging occur on the premises. (4) Barber shop, beauty shop, laundry and dry‐cleaning pick‐up agency, shoe repair, self‐service laundry or other similar establishments. (5) Restaurants or other eating and drinking establishments listed in Subsection 4.35 e, f, and g. (6) Theater or hall for public gatherings. Any use not listed in subsections 13.12.1 through 13.12.4, otherwise allowed in a Business B District may be allowed by the Planning Board only upon written determination by the Board that such use is consistent with the objectives of the PUD‐KS district and the policies and guidelines set forth in the ECaPS Plan. Transportation, Communication, Utility, Institutional Uses

Planned Unit Development Overlay – Kendall Square (PUD-KS) The entire parcel is also zoned PUD-KS. According to the city of Cambridge Community Development Department, PUDs allow for flexibility in terms of integrating different land uses and densities. The developer can choose to follow the PUD controls instead of the base district requirements with a special permit. PUD-KS: “Kendall Square. Mixed use with office and retail, residential, and a required public park.” PUD‐KS Maximum FAR Maximum Height

Special requirements

3.0 65’ with areas allowing up to 85’, 120’, 180’, or 250’ and 45’ adjacent to public open space Under Article 13.00 of Cambridge’s Zoning Ordinance, residential uses, townhouse development and multi‐family dwellings are allowed, which fits in with our development plans. For retail business and consumer service establishments, the total amount of gross floor area (GFA) in the Kendall Square district cannot exceed 70,000 square feet, and no individual establishment can be greater than 10,000 square feet unless the Planning Board decides that more retail GFA better serves the residents within the district and also advances the policies of the Eastern Cambridge Plan and the Eastern Cambridge Design Guidelines.”

3rd & Binney Apartments and Condos

Our site is also in the TDR District of East Cambridge and specifically, in the Receiving District. According to Article 21.00 of the TDR Regulations, the purpose of the district is to “establish regulations by which Gross Floor Area (GFA) permitted on one lot or lots, as determined by the zoning district applicable to that lot [the Donating Lot(s)], may be transferred and used on another lot or lots [the Receiving Lot(s)] in the same or different zoning district.”

Parking Requirements Article 13.00 of the zoning ordinance also has the following guidelines for parking: 13.17.1 Off Street parking facilities shall be provided as follows: (1) Residence: 1 space per unit minimum, 1.5 spaces per unit maximum. (2) Public Assembly: Number of seats requiring one space: 15. (3) Institutional: 1 space per 1,800 square feet. (4) Retail (except as noted in Section 13.17.2 below) and Office: Ground floor: 1,125 square feet Other level: 1,800 square feet The Eastern Cambridge Planning Study suggests the use of underground parking, but if parking is built above ground, it should not be visible from public Streets.

Variances to Be Proposed Parking Although Article 13’s parking guidelines provide 1 space per unit minimum for residential parking, we are using a .4 ratio for parking spaces to units given the excellent public transportation accessibility from the site. Whole Foods Grocery stores do not fall under any of the accepted business establishments listed, but the ordinance also states that “any use not listed…but otherwise allowed in a Business B District may be allowed by the Planning Board only upon written determination by the Board that such use is consistent with the objectives of the PUD-KS district and the policies and guidelines set forth in the ECaPS Plan.” We can argue for a variance to build the grocery store since it will be an amenity that is consistent with the Eastern Cambridge Planning Study (ECaPS). The Planning Study identifies our site to be in a “key position to affect the character of Kendall Square.” In addition, it wants to transform this district into one that encourages 18-hour activity “that residents desire in Kendall Square.” The addition of a grocery store in particular would serve the current and future residents of the area, especially families, in addition to attracting patrons who live and work nearby into the evening, thus creating more foot traffic after 5PM. Moreover, in 2011 a study was conducted by the Economic Division of Cambridge’s Community Development Study cited a grocery store as the second most desired amenity residents wanted to see in Kendall Square.


Day Care Center Under Article 4.33 a daycare center is listed under institutional use within “educational purposes.” Article 13.00 of the zoning ordinance permits institutional use provided that it is allowed under the base zoning district. The base zoning of Residence 2B and Business A both allow for daycare centers, so we should not need any relief if we choose to have a daycare center as part of our development. Density and FAR PUDs maximum FAR is 3.0; however, our proposed development will have an FAR of 5.5. Given the height of the neighboring buildings (the majority are at least 5 stories, with Kendall Watermark at 22 stories) and the infill development that has been occurring in the neighborhood in recent years, we are responding with added density on our site. The PUD’s FAR of 3 would not have been able to support our 15 story high rise, which is appropriate for the site and location. The location’s proximity to convenient public transportation also support the transit-oriented development’s principle of added density. Thus, the project should get a variance for exceeding the site’s existing FAR maximum.

NEIGHBORHOOD PLAN Site The site on 3rd and Binney Streets is currently occupied by the Research and Innovation Technology Administration of the U.S. Department of Transportation, and hosts the Center for Human Factors Research in Transportation (Volpe Center). Beyond a one-story building, the parcel has some parking and green space and is underdeveloped overall.

Surrounding Uses The site is surrounded by dense residential developments in addition to a large number of biotechnology and pharmaceutical companies on 3rd Street and along Binney Street. These buildings house both office and laboratory spaces for companies like Genzyme, Momenta Pharmaceuticals, and Alnylam US.

Existing Amenities There are a variety of amenities in Kendall Square, along Broad Canal Way, and 3rd Street, which are all within walking distance of the site. The retail related amenities include restaurants, bars, coffee shops, dry cleaners, banks, the post office, and other small shops. A major shopping center, the Cambridgeside Galleria, is also half a mile away. The site is in close proximity to other great features like the Museum of Science and the Charles River. In addition the site is close to a variety of public transportation options. Despite the varied existing amenities, there are still some uses that are much needed in this area. A grocery store, a day care center and more public green space have been highlighted as needed uses.

Transportation The site has excellent access to public transportation and is located near the following options:

• .24 mile away from the red line at Kendall Square and also has access to the following bus lines – 64, 68, 85, CT2;

• .6 mile from the green line at Lechmere with access to the following bus lines – 69, 80, 87, 88; • .25 mile away from the bike sharing port, Hubway; • The site is also near car-sharing opportunities like Zipcar and other rental locations. There is also roadway access via the Monsignor O’Brien Highway north of the site, via Binney Street and Memorial Drive in the west, and the Longfellow Bridge to the south. All of the above transportation options allows for convenient travel to other parts of the city, including Central and Harvard Squares, as well as Somerville and Boston.

Current and Future Development Alexandria Center A parcel diagonally situated from our site at 75-125 Binney Street is currently being developed into a life science complex, which will house Ariad Pharmaceuticals and will be part of Alexandria Center, a science and technology campus. This development is one of a total of 8 separate construction sites covering areas around Kendall Square.

Mixed-use & Mixed-income Development

9


Kendall Square Initiative In addition to individual development projects currently in the construction phase, MIT is undertaking a large-scale redevelopment of properties it owns in East Campus and in Kendall Square. This will result in 1.1 million square feet of new development in the form of office space, labs, retail, commercial, housing, and open space. Currently, the initiative is undergoing a gateway study to create a long-term framework for this development. All of these development projects in the Kendall Square area signal a large influx of activities, which will in turn attract both residents and new employees given the excellent access to public transportation and desirable amenities. Thus, Kendall Square and East Cambridge is poised to become a much more vibrant, 18-hour neighborhood.

St.

ANALYSIS 3rd

Opportunities Density Although three major residential buildings are within walking distance of the site, there is still a lack of much needed residential use in East Cambridge. The volume of office and laboratory space in Kendall is large and continues to grow, which increasingly attracts more professionals to the area. The influx of employment opportunities coupled with easy access to surrounding amenities like retail and public transportation makes our site a prime location for additional housing options. In addition, the site currently exists as a gap along 3rd Street, which has become much more active and dense with residential, retail, office and laboratory uses. Moreover, except for the parking lot to the west of the site, the buildings on the other three sides of the site are over five stories, and the residential buildings within three blocks are midrise and high-rise developments. Thus, the site is poised for both dense, vertical development. Amenities Although a variety of retail options exist near our site, the development has the opportunity to extend the retail corridor along 3rd Street in particular, as well as add more desired and needed amenities, like a grocery store, day care

3rd & Binney Apartments and Condos

30 feet N Binney St .

St.

Existing

3rd

10

Binney St.

Proposal Concept Circulation Barriers

High-rise Residential

Grocery Store

Vehicle Route

Mid-rise Residential

New Retail

Yard / Green Space

Daycare

Neighborhood Connection

New Pedestrian Route

Buildings > 50’ height

Bro

adw ay

Kendall Square


center and green open space, to the benefit of both residents and employees.

PROGRAM SUMMARY

Green space

The development has the following components:

The 2001 Eastern Cambridge Planning Study highlighted the site as part of a geographic area in need of a community park. Although some green space has been added in Eastern Cambridge since the publication of this report, it has not been nearly enough. The Third Square Apartments have a green in the middle of their development, but it is not used often and rarely used by the public. Because of the location and size of the 3rd and Binney parcel, there is an excellent opportunity to add much needed green space that is accessible by both our development’s residents and the public.

Residential (424,227 gsf)

Constraints Circulation Barriers One of the major site constraints is its adjacency to Binney Street, which is a very active main road, which experiences heavy traffic on a daily basis. This activity makes it the ideal location for our grocery store, but mitigation must occur to make it a more pedestrian friendly street along our development. Another circulation barrier that exists is in the navigation around our parcel from Binney or 3rd Street. Because 5th Street does not cut through the parcel to Binney Street, it makes circulation less than optimal. To address this barrier, the development will create a pedestrian corridor, which will allow residents to walk from 5th Street to Binney Street.

• Market-rate condominiums in 15-story high rise tower • Market-rate and affordable apartments in 7-story mid-rise and 10-story high rise tower Commercial & Retail

• Whole Foods grocery store (15,707 gsf) • Leasable retail space (4,386 gsf) Community

• Day care center (2,522 gsf) • Green space • Pedestrian walkway Parking

• Residential parking • Whole Foods parking Total FAR: 5.5

Residential The residential portion of the development will have a total of 425 residential units – 302 in the rental component and 123 in the for-sale component of the project. In both components, unit types range from studios to 3-bedrooms.

Commercial & Retail

11

Whole Foods Despite the varied retail offerings in East Cambridge and Kendall Square, a grocery store and day care center were highlighted as two uses that were sorely lacking. As part of the development, we will be creating a grocery store on the edge of the site on Binney Street, with the intention of having Whole Foods as the tenant. The creation of 428 new units in a burgeoning residential area and an already bustling employment area ensures that there will be high demand for such an amenity. Whole Foods is the ideal tenant for this space given the demographics of the immediate neighborhood, which can afford a more upscale offering. In addition, Whole Foods’ prepared food section is particularly attractive as another lunch/dinner option for both residents and employees in the area. Retail Space Beyond the grocery store, 4,386 gsf will be available as retail space. Although specific businesses have not been identified for the space, the intention is to extend the 3rd Street retail corridor and create further

Mixed-use & Mixed-income Development


activity in the neighborhood. Potential tenants for this space include a pharmacy and more varied dining options.

Community Day Care Center During the research phase of the project, a need for a daycare center emerged, which fit into the overall program given the desire to attract families to the development. As such, 2,522 gsf will be dedicated to this community use. The day care center is located off of 3rd Street on Munroe Street and will have an adjacent playground and access to the green space. 12

Green Space The 2001 Eastern Cambridge Planning Study highlighted our parcel as part of the area in need of a community park. The development will be adding a total of 3 green spaces, two of which are roof parks. The main open space will be located off of Munroe Street and be most accessible to both residents of the development and the public. Pedestrian Walkway A pedestrian walkway will be created to activate the edge of our parcel and allow access to Binney from 5th Street and create another convenient route to Whole Foods. Because Whole Foods will be open late into the evening, it will help create a well-lit and safe corridor for pedestrians.

Parking Two levels of underground parking will be provided for both residents of the development and customers of Whole Foods. The main entry and exit point in and out of the parking level will be off of Binney Street located between the Whole Foods and mid-rise component of the development. Because the development has very convenient access to public transportation, a .4 parking ratio will be used, which allocates 170 spaces for residents of the development. Another 75 spaces will be allocated to Whole Foods based on comparable urban grocery stores in Cambridge. As such, a total of 245 spaces are needed. 165 spaces are available on each parking level, offering a total of 330 spaces. The remaining 85 spaces can be rented or sold to future development projects.

The entire development program is meant to advance the creation of an 18-hour neighborhood, where the added amenities of both retail and Whole Foods in particular will serve both the employee population as well as the residents through the evening.

3rd & Binney Apartments and Condos


SITE PLAN

13

30 feet

N

Mixed-use & Mixed-income Development


14

Residential Unit Entrance (Condos / Rental) Walk-up Rental Units Green Space Access (Public / Private) Commercial Frontage Kids Activities Parking Entrance & Exit (Residential & Grocery Store)

30 feet N

March 10am

3rd & Binney Apartments and Condos

March 3pm

October 10am

October 3pm


FLOOR PLAN

Rental Apartment Plan L1

30 feet

N

15

Parking Plan -L1 & -L2

30 feet

N

Mixed-use & Mixed-income Development


L2-L7 TR

Laundry

16

Storage/ Common room

Roof Garden (L2)

30 feet

N

L8-L10

Roof Garden (L8)

30 feet

3rd & Binney Apartments and Condos

N


Condo Plan

N

Man Offic ager e

30 feet

Leasing Office

Storage

TR

L1

L2-L7

L8-L15

17

Mixed-use & Mixed-income Development


30 feet

18

3rd & Binney Apartments and Condos


SECTIONS

19

Mixed-use & Mixed-income Development


30 feet 20

3rd & Binney Apartments and Condos


21

Mixed-use & Mixed-income Development


30 feet 22

3rd & Binney Apartments and Condos


23

Mixed-use & Mixed-income Development


DESIGN FEATURES

24

3rd & Binney Apartments and Condos


TYPICAL UNIT PLANS

PROJECT PROGRAM

10 feet

2,335,236 s.f. Rental Flat Units 101 one-bedroom

99,783 s.f. Condo Units 16 one-bedroom

Studio 435 s.f.

36 two-bedroom 40 three-bedroom 31 studio

2,522 s.f. Daycare Center with playground

Green Space 19,929 s.f. Walk-up Rental Units 2 one-bedroom

4,386 s.f. Retail

1 bedroom 609 s.f.

18 two-bedroom 2 three-bedroom

Pedestrian Walkway

330 Underground Parking 170 residential parking

109 two-bedroom 30 three-bedroom 40 studio

75 grocery store parking

15,707 s.f. Grocery Store

2 bedroom 913.5 s.f.

25

RENTAL

3 bedroom 1160 s.f.

Market Rate Affordable FOR-SALE

Total Number of Units Unit Type Square Footage Monthly Rents 60% AMI Rents

40 Studio (A, B, C) 435 sq. ft. - 525 sq. ft. $2,100-$2,175 $892-942

103 1 bedroom 609 sq. ft. $2,700 $991

127 2 bedroom 914 sq. ft. $3,200 $1,134

32 3 bedroom (A, B, C, D) 1,134 sq. ft. -1,247 sq. ft. $3,825-3,925 $1,200-$1,275

Total Number of Units Unit Type Square Footage Sales

31 Studio (A, B, C) 432 sq. ft.-518 sq. ft. $280,000 - $320,000

16 1 bedroom 609 sq. ft. $380,000

36 2 bedroom (A, B, C) 823 sq. ft. - 918 sq. ft. $525,000 - $580,000

40 3 bedroom (A, B, C) 1030 sq. ft.-1134 sq. ft. $685,000 - $725,000

TOTAL UNITS 302

123

425

Â

Mixed-use & Mixed-income Development


OUTLINE SPECIFICATION MEMO 174-182 Binney Street, Cambridge, MA New Construction Scope of Work

446,842 gsf New Construction

26

The entire development is concrete and steel construction given the 15-story high rise tower along 3rd Street and the connected mid-rise and high rise tower along Binney Street.

PROGRAM

• Laundry Room on each floor accommodating 2 coin op washers and 2 coin op gas • Trash Room on each floor with access to Trash Chute and area for recycling bins • Access to rooftop garden is available in the elevator lobby on the 8th floor Rooftop Open Space:

• A rooftop garden will be above the 2nd floor on the mid-rise portion of the building • Access is available from the 2nd floor elevator lobby Condominium Component

Site:

• Site work includes a new curb cut on Binney Street to allow for temporary parking for three vehicles, as well as a general drop-off and pick-up location in front of the Binney street residential lobby entrance. • There will also be substantial landscaping involved, which includes adding trees and plantings along Binney Street and the pedestrian walkway. In addition, a lawn will be planted off of Munroe Street, as well as new trees and plantings along the perimeter of the open space and periodically between stoop entrances. Roof lawns will be added on two other areas of the development. • Other minor site improvements include installing outdoor seating and bike racks. Rental Component First Floor:

• Trash Room accommodating compacter and 3 rolling 2 dumpsters for residential garbage, with • • • • • •

space for storing recyclables. Trash room is located on the ground floor with relatively easy access to the outdoors for pickup by dumpster truck. Electric room sized to accommodate switchgear and meter banks; Space for gas meters (no need to enclose, just protect); Residential barrier-free entrance lobby as per plans accommodating mailboxes; 22 residences with direct access to Binney Street and the green space on the Munroe Street side of the development 22 residential apartments per plans Laundry Room on first floor accommodating 2 coin op washers and 2 coin op gas dryers

Floors 2 through 7:

• 220 residential apartments per plans • Laundry Room on each floor accommodating 4 coin op washers and 4 coin op gas dryers • Trash Room on each floor with access to Trash Chute and area for recycling bins Floors 8 through 10:

• 60 residential apartments per plans

3rd & Binney Apartments and Condos

First Floor:

• Retail space per plans along Third Street between Munroe and Binney Streets to include 13 feet • • • • •

ceiling height to underside of lowest structure, separately metered gas and electric and conventional forced air HVAC system, and modern retail finishes. Trash Room accommodating compacter and 3 rolling 2 dumpsters for residential garbage, with space for storing recyclables. Trash room is located on the ground floor with relatively easy access to the outdoors for pickup by dumpster truck. Electric room sized to accommodate switchgear and meter banks; Space for gas meters (no need to enclose, just protect); Residential barrier-free Entrance Lobby as per plans accommodating mailboxes; Property Management office adjacent to Lobby plus storage closet and barrier free restroom;

Floors 2 through 7:

• • • • •

54 residential apartments per plans Trash Room on each floor with access to Trash Chute and area for recycling bins Storage space available adjacent to elevator lobby There will be laundry machines in each unit Electric Closet on each floor, minimum 2x5 ft, accommodating telephone and cable boxes

Floor 8 through 15:

• • • •

80 Residential Apartments per plans Trash Room on each floor with access to Trash Chute and area for recycling bins There will be laundry machines in each unit Electric Closet on each floor, minimum 2x5 ft, accommodating telephone and cable boxes

Rooftop Open Space:

• A rooftop garden will be above the 7th floor on the mid-rise portion of the building • Access is available from the 7th floor elevator lobby


FINANCING PLAN Residential Units Rental Units 120 = 40% of units at 60% AMI 182 = 60% of units at market-rate 302 units total

Funding Source Funding Source $49,000,000 for a Construction/Bridge Loan

Features Features $17 million in affordable portion reflects 50% of the affordable unit’s total project costs for 9%

$49,000,000 for a Construction/Bridge Loan from tax credits eligibility; bridge and construction loan to help finance construction phase $17 million in affordable portion reflects 50% of the affordable unit’s total project costs from MassHousing MassHousing for 9% tax credits eligibility; bridge and construction loan to help finance construction $43,500,000 for a MassHousing Permanent loan Loan to help pay short‐term construction and bridge loan phase $10,000,000 of 9% Low Income Housing Tax Maximum allocation for 9% tax credits for a total of 40 units at 60% $43,500,000 for a MassHousing Permanent loan Loan to help pay short‐term construction and bridge loan Credits $10,000,000 of 9% Low Income Housing Tax Credits Maximum allocation for 9% tax credits for a total of 40 units at 60% $9,397,822 of 4% Low Income Housing Tax Balance of tax credits needed help fund the remaining 80 affordable units at 60% AMI $9,397,822 of 4% Low Income Housing Tax Credits Balance of tax credits needed help fund the remaining 80 affordable units at 60% AMI Credits $2,704,367 of MassHousing Priority Development Funds available to incentivize developers to build affordable and mixed income housing. This Funds available to incentivize developers to build affordable and mixed income housing $2,704,367 of MassHousing Priority Funds using 4% credits. This allocation helps close the funding gap. Development Funds allocation helps close the funding gap. $1,000,000 of Massachusetts HOME

Affordable housing grant; 100% of benefiting residents will have incomes that do not Affordable housing grant; 100% of benefiting residents will have incomes that do not exceed exceed 60% AMI 60% AMI

$1,000,000 of Cambridge HOME $3,000,000 of Cambridge Housing Trust fund

Match for state HOME funds Match for state HOME funds Project meets the high quality, sustainable design and creation of family housing criteria Project meets the high quality, sustainable design and creation of family housing criteria

$1,000,000 of Affordable Housing Trust fund

Funds available for the creation of affordable units in mixed‐income developments; Funds available for the creation of affordable units in mixed‐income developments; incomes incomes do not exceed more than 110% of AMI at 60% AMI. do not exceed more than 110% of AMI at 60% AMI.

$12,556,249 of Cash Equity

Equity helps to close the funding gap Equity helps to close the funding gap

27

Condominium Units Condominium Units 123units unitsatatmarket-rate market-rate 123 Funding Source $35,100,000 of BCC Construction Loan $63,351,650 of Gross Unit Sales $13,682,182 of Cash Equity

Features 65% of total development costs Reflects gross sale proceeds of 123 units 25% of total development costs

See Appendix A: Condominium and Rental Proformas

Mixed-use & Mixed-income Development


MARKETING PLAN

Advertising and Promotion:

• Website/Social Media 3rd and Binney Apartments and Condos The site on 3rd and Binney Streets is located north of Kendall Square along the 3rd Street Corridor in East Cambridge that has undergone quite a transformation in recent years. In addition to being near MIT, the site is also in close proximity to a large and continuously growing volume of office space, home to predominantly high-tech companies. In addition, three luxury residential developments are within several blocks. 28

Most people search for housing via the internet. Like other projects in Kendall square, this project’s website should include floor plans, pricing, amenities and good pictures in order to attract potential customers. We should put ads in search engines such as google. In addition, the ads easily access target renters and purchasers by Social Media which customizes users by age, gender, and address.

• Direct Mail There are many similar affordable rental apatments in Cambridge as well as Boston and the renters in those apartments would be looking for new apartments before their contracts are expired. The renters might be thinking to purchase condominium units. The marketing team should send direct mails to the potentital renters or purchasers to show the appeal of our property.

Typical Affordable Unit Renters

• Small, Young Families with Kids The site offers a total of 90 2- and 3- bedroom units, ideal for small families with kids.

• Free Magazines

• Roommates Young singles will be also be attracted to the 2-bedroom units, ideal for sharing at a more reasonable rent.

• Other Young Professionals Young professionals working in the bio-tech offices and labs nearby are ideal targets for the studio and 1-bedroom units in the development.

• Retired Couples Retired couples in search of a smaller residence to meet their lifestyle needs and may not have enough income and savings. The site location is near Kendall square, which has easy access to MGH and other hospitals in Boston. Typical Market Rate Unit Renters

The free magazines such as Apartment Finder could be an option for the advertisement. We can install the magazines at offices, restaurants, university campuses, research centers and stations in Kendall. The installation would be a good appeal for people who live or work in Kendall.

• Advertising Signs/Posters The signs for affordable rentals should be located at the site during the construction. In addition, poster advertisements in public spaces such as community centers are effective for people in Boston and Cambridge.

• Local Newspaper Ads in the local newspaper such as the Boston Globe, the Boston Herald, the Phoenix, and Cambridge Civic Journal might catch the retired parents, which would encourage them to be interested in the project. Also the ads could be on local free newspapers such as the Metro.

• Single Young Professionals The project has studios which attract professionals who are working around Kendall Square; studios and 1 bedrooms are ideal for them.

2014 Jan: Construction starts & press release

• Young Families with Kids The project has a day care center and green spaces for the kids. The project has 3-bedroom units that fit families’ needs.

• Young Scholars and Researchers The site is surrounded by new office buildings and MIT campus. The site would be dential place for them.

an ideal resi-

Typical Market Rate Units Purchasers

• Young Professionals Young professionals who work around the site are potential purchasers since they can live and potentially lease out the unit in the future. The project also has the units from studios to 3 bedrooms. Therefore, the professionals could be singles or families with or without kids.

3rd & Binney Apartments and Condos

Marketing Schedule:

2015 Jan: The affordable leasing website started and advertising signs are installed on the site Aug: Start general marketing, put ads on social media, newspapers and magazines and send out the direct mails Oct: Deadline for affordable rent applications and take lottery Dec: The selection is completed 2016 Jan: The construction is completed and occupancy process is started

Marketing budget for the market rate rental units: $200,000 Marketing budget for market rate sale units: $3,277,032.50


APPENDIX A: CONDOMINIUM AND RENTAL PROFORMAS

3rd and Binney Condos Sources and Uses of Funds 12/13/13 Sources (cash) BCC Const Loan BCCConst Loan Repayment Gross Unit Sales Cash Equity Repay Cash Equity Total

Total Units

Total Per Unit $35,100,000 285,365.85 ($35,100,000) (285,365.85) $63,351,650 515,054.07 $13,682,183 111,237.26 ($13,682,183) $63,351,650

Developer fee Profit/(Loss) As a percent of cost

$0 $8,622,916 $13,768,457 16%

Uses (cash) ACQUISITION Land

TOTAL

8.66 5% 0.50%

of loan amt 3.50% ew Ecology 5% 2%

$ 225.00 $ 35,000.00

PER UNIT

$14,379,600 116,907.32 $14,379,600 116,907.32

subtotal

HARD COSTS 122,598 Construction 49 Shared Parking Cost Contingency 882 0.4 5% 0.75% 1%

123

% of TDC 26.27% 26.27%

subtotal SOFT COSTS A/E Design & Inspection A/E Additional Services Bond Permits Survey Geo/Environmental Assessment Clerk Insurance & Condo Fees RE Taxes Marketing/Lease Up Environmental Contingency Title and Recording Appraisal Traffic Study Lender & LP Review and Inspection Cost Certification/Accounting Developer Legal Const Loan Fee & Legal Const Loan Interest Other Consultants Testing Developer Overhead Soft Cost Contingency

$27,584,550 1,722,000 $1,465,328 $30,771,878

224,264.63 14,000.00 11,913.23 250,177.87

50.40% 3.15% 2.68% 56.23%

$1,379,228 $16,000 $206,884 $404,909.50 $6,000 $23,757 $100,000 $170,975 $374,781 $3,167,582.50 $30,000 $318,350 $10,000 $15,000 $20,000 $25,000 $225,000 $351,000.00 $1,500,000 $ 20,000 $25,000 $1,000,000 $187,789.34

11,213.23 130.08 1,681.98 3,291.95 48.78 193.15 813.01 1,390.04 3,047.00 25,752.70 243.90 2,588.21 81.30 121.95 162.60 203.25 1,829.27 2,853.66 12,195.12 162.60 203.25 8,130.08 1,526.74

2.52% 0.03% 0.38% 0.74% 0.01% 0.04% 0.18% 0.31% 0.68% 5.79% 0.05% 0.58% 0.02% 0.03% 0.04% 0.05% 0.41% 0.64% 2.74% 0.04% 0.05% 1.83% 0.34%

subtotal

$9,577,256

77,863.87 444,949.05

17.50%

Total Development Costs

$

$54,728,734

100.00%

Mixed-use & Mixed-income Development

29


3rd and Binney Condos Cash Flow During Construction

SOURCES of Funds

30

Construction/Bridge Loan Repay Const/Bridge Loan Cash Equity Repay Cash Equity Unit Sales Total Sources USES of Funds

Construction Loan Balance Equity Balance UnSold Unit Balance RE Taxes Sources $35,100,000 ($35,100,000) $13,682,183 ($13,682,183) $63,351,650 $63,351,650

$3,811,440.68 $13,682,183

$5,005,825 $13,682,183

Jan‐14 Closing

Feb‐14 Month 1

$10,519,661 $13,682,183

$11,427,123 $13,682,183

$12,415,640 $13,682,183

Mar‐14 Month 2

Apr‐14 Month 3

May‐14 Month 4

Jun‐14 Month 5

Jul‐14 Month 6

Aug‐14 Month 7

Sep‐14 Month 8

Oct‐14 Month 9

$1,232,498

$622,628

$622,777

$933,238

$903,161

$907,462

$988,517

$13,682,183

$0

$0

$0.00

$0

$0

$0

$0

$0

$0

$17,493,624

$1,194,384 $0

$14,379,600

SUBTOTAL: ACQUISITION COST

$14,379,600

$14,379,600

$0

Construction Costs: Construction Shared Parking Cost Contingency SUBTOTAL: CONSTRUCTION COST

$27,584,550 $1,722,000 $1,465,328 $30,771,878

$0 $0

$551,691 $574,000.00 $0 $1,125,691

3rd & Binney Apartments and Condos

$9,616,500 $13,682,183

$1,199,534

$14,379,600

$54,728,734 $8,622,916

$8,683,263 $13,682,183

$1,194,384

Acquisition Costs: Land

Total DEVELOPMENT COST Surplus/(Deficit) Price per Unit

$8,060,485 $13,682,183

$3,811,441

Closing

$1,395,228 $25,000 $206,884 $6,000 $404,910 $23,757 $30,000 $100,000 $170,975 $374,781 $3,167,583 $318,350 $10,000 $15,000 $20,000 $25,000 $225,000 $351,000 $1,500,000 $20,000 $1,000,000 $187,789

$7,437,858 $13,682,183

8.66

USES

General Development Costs: A/E Design & Inspection & Additional Services Construction Testing Bond Survey Permits Geo/Environmental Assessment Environmental Contingency Clerk Insurance & Condo Fees RE Taxes Marketing Title and Recording Appraisal Traffic Study Lender & LP Review and Inspection Cost Certification/Accounting Developer Legal Construction Loan Fees & Legal 3.50% Construction Loan Interest Other Consultants Developer Overhead Soft Cost Contingency

$6,205,359 $13,682,183

$1,116,182 $0 $206,884 $5,500 $404,910 $23,757 $170,975 $31,132 $33,268 $10,000 $15,000 $5,000 $25,000 $213,750 $351,000 $0 $1,666.67 $500,000.00 $17,493,624 $0

Month 1

$1,199,534 $0

Month 2

$1,232,498 ($0)

$0 2%

$551,691 $574,000.00 $0 $1,125,691

Month 3

$622,628 $0

$0 2%

Month 4

$622,777 ($0)

$0

$551,691 $574,000.00 $0 $1,125,691

2%

$551,691 $0 $0 $551,691

Month 5

$933,238 ($0)

$0 2%

Month 6

$903,161 $0

$0

$551,691 $0 $0 $551,691

2%

$827,537 $0 $0 $827,537

Month 7

$907,462 ($0)

$0 3%

Month 8

$988,517 ($0)

$0

$827,537 $0 $0 $827,537

3%

$827,537 $0 $0 $827,537

Month 9

$0 3%

$827,537 $0 $0 $827,537

$11,627 $2,500

$11,627 $2,500

$11,627 $2,500

$11,627 $2,500

$11,627 $2,500

$11,627 $2,500

$11,627 $2,500

$11,627 $2,500

$11,627 $2,500

$10,000 $4,166.67

$10,000 $4,166.67

$10,000 $4,166.67

$4,166.67

$4,166.67

$4,166.67

$4,166.67

$4,166.67

$4,166.67

$31,132

$625

$11,117 $20,833.33 $7,824.56 $1,194,384 $0

$625

$14,600 $1,667 $20,833.33 $7,824.56 $1,199,534 $0

$625

$18,099 $20,833.33 $7,824.56 $1,232,498 $0

$31,132

$625

$21,694 $1,667 $20,833.33 $7,824.56 $622,628 $0

$625

$23,510 $20,833.33 $7,824.56 $622,777 $0

$625

$25,326 $1,667 $20,833.33 $7,824.56 $933,238 $0

$0

3%

$31,132 $48,943

$625

$28,048 $20,833.33 $7,824.56 $903,161 $0

$625

$30,682 $1,667 $20,833.33 $7,824.56 $907,462 $0

$625

$33,329 $20,833.33 $7,824.56 $988,517 $0


$13,378,632 $13,682,183

Nov‐14 Month 10

$14,762,644 $13,682,183

Dec‐14 Month 11

$16,183,492 $13,682,183

Jan‐15 Month 12

$17,575,685 $13,682,183

Feb‐15 Month 13

$18,948,605 $13,682,183

Mar‐15 Month 14

$20,630,840 $13,682,183

Apr‐15 Month 15

$22,288,517 $13,682,183

May‐15 Month 16

$23,949,362 $13,682,183

Jun‐15 Month 17

$25,647,849 $13,682,183

Jul‐15 Month 18

$27,589,338 $13,682,183

Aug‐15 Month 19

Sep‐15 Month 20

Oct‐15 Month 21

Nov‐15 Month 22

Dec‐15 Month 23

$1,392,193

$1,372,920

$1,682,235

$1,657,677

$1,660,845

$1,698,488

$0

$0

$0

$0

$0

$0

$0

$0

$0

$962,992

$1,384,012

$1,420,847

$1,392,193

$1,372,920

$1,682,235

$1,657,677

$1,660,845

$1,698,488

$1,941,488

$1,948,818

$1,837,434

$0 $2,089,174

$0 $2,095,045

Month 18

Month 19

Month 20

Month 21

Month 22

Month 23

$0

$0

$0

$0

$0

$0

Month 10

($0)

$0

$827,537 $0 $0 $827,537

Month 11

($0)

$0 3%

$11,627 $2,500

Month 12

$0

$0

$1,103,382.00 $0 $146,532.75 $1,249,915

4%

$11,627

$1,103,382.00 $0 $146,532.75 $1,249,915

Month 13

$0

$0 4%

$11,627

Month 14

$0

$0

$1,103,382.00 $0 $146,532.75 $1,249,915

4%

$11,627

$1,103,382.00 $0 $146,532.75 $1,249,915

Month 15

$0

$0 4%

$11,627

Month 16

$0

$0

$1,379,228 $0 $146,532.75 $1,525,760

5%

$11,627

$1,379,228 $0 $146,532.75 $1,525,760

Month 17

($1)

$0 5%

$11,627

$1,379,228 $0 $146,532.75 $1,525,760

5%

$11,627

$1,379,228 $0 $146,532.75 $1,525,760

5%

$11,627

$0

$1,655,073 $0 $146,532.75 $1,801,606

6%

$11,627

$0

$1,655,073 $0 $146,532.75 $1,801,606

6%

$11,627

$0

$0

$1,655,073.00 $0

6%

$2,089,174

$35,559,808 $13,682,183

$1,420,847

$0

$1,837,434

$33,464,764 $13,682,183

$1,384,012

$0

$1,948,818

$31,375,590 $13,682,183

$962,992

$0

$1,941,488

$29,538,156 $13,682,183

$0

$0

$1,930,918.50 $0

7%

$2,095,045 $0

$0

$1,930,918.50 $0

$1,655,073

$1,930,919

$1,930,919

$11,627

$11,627

$11,627

7%

$250

$4,166.67

$4,166.67

$4,166.67

$50,000

$50,000

$31,132 $50,000

$625

$625

$625

$36,212 $1,667 $20,833.33 $7,824.56 $962,992 $0

$39,021 $20,833.33 $7,824.56 $1,384,012 $0

$43,058 $1,667 $20,833.33 $7,824.56 $1,420,847 $0

$4,166.67

$4,166.67

$4,166.67

$50,000

$25,000

$31,132 $25,000

$625

$625

$625

$47,202 $20,833.33 $7,824.56 $1,392,193 $0

$51,262 $1,667 $20,833.33 $7,824.56 $1,372,920 $0

$55,267 $20,833.33 $7,824.56 $1,682,235 $0

$4,166.67

$4,166.67

$4,166.67

$25,000

$25,000

$31,132 $25,000

$625

$625

$625

$60,173 $1,667 $20,833.33 $7,824.56 $1,657,677 $0

$65,008 $20,833.33 $7,824.56 $1,660,845 $0

$69,852 $1,667 $20,833.33 $7,824.56 $1,698,488 $0

$4,166.67

$4,166.67

$4,166.67

$20,000

$20,000

$31,132 $20,000

$20,000

$21,194

$625

$625

$625

$625

$625

$74,806 $20,833.33 $7,824.56 $1,941,488 $0

$80,469 $1,667 $20,833.33 $7,824.56 $1,948,818 $0

$4,166.67

$4,166.67

31

$86,153 $20,833.33 $7,824.56 $1,837,434 $0

$91,512 $1,667 $20,833.33 $7,824.56 $2,089,174 $0

$97,606 $20,833.33 $7,824.56 $2,095,045 $0

Mixed-use & Mixed-income Development


$7,463,958 $13,682,183

Jan‐16 Month 24 ($28,095,850) $0

32

$31,675,825 $3,579,975

$4,489,881 $13,682,183 $31,675,825 $22,859 Month 25 ($2,974,077) $3,167,583 $193,506

$0 $15,187,027 $28,508,243 $20,573 Month 26

$0 $12,186,609 $25,340,660 $18,288 Month 27

$0 $9,183,904 $22,173,078 $16,002 Month 28

$0 $6,178,914 $19,005,495 $13,716 Month 29

$0 $3,171,637 $15,837,913 $11,430 Month 30

$0

$0 $12,670,330 $9,144 Month 31

$0

$0 $9,502,748 $6,858 Month 32

$0

$0 $6,335,165 $4,572 Month 33

$0

$0 $3,167,583 $2,286 125,727 Month 34

Total Sources $35,559,808 ($35,559,808) $13,682,183 ($13,682,183) $63,351,650 $63,351,650 ($1) Total Uses

($4,489,881) $1,504,844 $3,167,583 $182,545

($3,000,419) $3,167,583 $167,164

($3,002,705) $3,167,583 $164,878

($3,004,990) $3,167,583 $162,592

($3,007,276) $3,167,583 $160,306

($3,171,637) $3,167,583 ($4,055)

$3,167,583 $3,167,583

$3,167,583 $3,167,583

$3,167,583 $3,167,583

Month 24

$14,379,600 $0 $14,379,600

$0

$1,930,919 $0

7%

$1,930,919

$0

$0

$0

$0

$0

$0

$0

$0

$0

$27,584,550 $1,722,000 $1,465,328 $30,771,878

$0

$11,627 $250

$4,166.67 $1,346,223 $142,541

$22,859 $134,622 $14,254

$20,573 $134,622 $14,254

$18,288 $134,622 $14,254

$16,002 $134,622 $14,254

$13,716 $134,622 $14,254

$11,430 $134,622 $14,254

$9,144 $134,622 $14,254

$6,858 $134,622 $14,254

$4,572 $134,622 $14,254

$2,286 $134,622 $14,254

$21,770

$13,095

$0

$0

$0

$0

$0

$0

$0

$0

$193,506 $0

$182,545 ($0)

$167,164 $0

$164,878 $0

$162,592 ($0)

$160,306 $0

$158,020 ($162,075)

$155,734 $3,011,848

$153,448 $3,014,134

$151,162 $3,016,420

$625 $11,250 $103,716 $20,833.33 $7,824.56 $3,579,975 $0

total

$1,395,228 $25,000 $206,884 $6,000 $404,910 $23,757 $30,000 $100,000 $170,975 $374,781 $3,167,582 $318,350 $10,000 $15,000 $20,000 $25,000 $225,000 $351,000 $1,242,588 $20,000 $1,000,000 $187,789 $0 $54,471,322 $8,880,328

$0 ($0) $0 $0 ($0) ($1) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1

$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($0) $0 $0 $0 $0 $0 $0 $257,412 $0 $0 $0 $0 $257,412 ($257,412) $1 $0

3rd & Binney Apartments and Condos

100.000%


3rd and Binney Condos Sales Schedule 12/13/13

# of Units 6 18 6 6 6 6 6 Subtotal 54 Floors 8-15 7 16 8 8 8 8 8 6 Subtotal 69 Total Condo Units 123 Floors 2-7

Unit Type studio A studio B 2 bedroom A 2 bedroom B 3 bedroom A 3 bedroom B 3 bedroom C

Net Sq Ft 432.0 435.0 913.5 918.0 1030.0 1109.0 1134.0

Cost/Sq Ft 648.1 655.2 629.4 631.8 665.0 631.2 639.3

For Sale PricTotal Sales Proceeds $280,000 $1,680,000 $285,000 $5,130,000 $575,000 $3,450,000 $580,000 $3,480,000 $685,000 $4,110,000 $700,000 $4,200,000 $725,000 $4,350,000

studio C 1 bedroom A 2 bedroom C 2 bedroomB 2 bedroom A 3 bedroom C 3 bedroomB 3 bedroom A

518.0 609.0 823.5 918.0 913.5 1134.0 1109.0 1030.0

617.8 624.0 637.5 631.8 629.4 639.3 631.2 665.0

$320,000 $380,000 $525,000 $580,000 $575,000 $725,000 $700,000 $685,000

13,027

$2,240,000 $6,080,000 $4,200,000 $4,640,000 $4,600,000 $5,800,000 $5,600,000 $4,110,000 $63,670,000 Unit type studio 1 bedroom 2 bedroom 3 bedroom TOTAL less recording costs

Sales Proceeds $9,050,000 $6,080,000 $20,370,000 $28,170,000 $63,670,000 $318,350

NET SALE PROCEEDS $63,351,650

33

0.50%

Mixed-use & Mixed-income Development


3rd and Binney Condos Estimated Condominium Fees/Operating Expenses

Total Units

123 Condominium Budget: Landscaping Snow Removal Master Condo Fee Condo Mgmt Fees Condo Manager Payroll Banking Fees Telephone Legal Exterminating General Repairs Janitorial Supplies Janitor Payroll Trash Removal Elevator HVAC ‐ Maintenance Insurance Fire System Sprinkler Systems Electricity Gas Water/Sewer Tax Preparation Misc Admin Replacement Reserves Total Condo Fees Per Unit Average

34

3rd & Binney Apartments and Condos

Monthly 0.0 0.0 4000.0 3690.0 3600.0 100.0 1000.0 208.3 100.0 400.0 300.0 2520.0 1666.7 3000.0 1000.0 3587.5 800.0 500.0 4100.0 5125.0 3587.5 300.0 300.0 3988.5 43873.5 356.7

Annual Notes 0 included in Master Condo Fee 0 included in Master Condo Fee 48000 (master mgmt, snow removal, landscaping) 44280 $30/Per Door 43200 40 hours/week at $30/hour 1200 Checking Account/Reserve Account/Direct Deb 12000 Answering Service/Fire Alarm Line/Elevator Lin 2500 Collection Issues/Recording of Trustee docume 1200 Preventative Maintenance Contract 4800 Exterior Repairs//Hallway Repairs 3600 Cleaning products/Shovel/Rock Salt/Keys 30240 30 hours/week @$21/hou6 hours per week‐Part‐time cleaner 20000 Trash/Recycling 36000 600 per high rise cab Elevator contract/State‐testing/permits 12000 Bi‐Annual Service 43050 Insurance policy for 126 units in one bldg 9600 Fire Alarm Contract/Monitoring/Testing 6000 Quarterly Testing 49200 Common Area only 61500 Common Area only 43050 350 per unit per year 3600 Annual Tax Preparation/Filing 3600 As Needed 47862 10% of Condo Fees‐ Fannie Mae Freddie Mac 526482


3rd and Binney Apartments Sources and Uses of Funds 12/13/13

DHCD allowable fee

Total

Sources (cash) Const/Bridge Loan ‐ MassHousing (Tax Exempt) Const/Bridge Loan Repayment MassHousing Permanent Loan 9% LIHTC Syndication Proceeds ‐ 40 units 4% LIHTC Syndication Proceeds ‐ 80 units Priority Development Fund ‐ MassHousing State HOME Cambridge Housing Trust Cambridge HOME Affordable Housing Trust Cash Equity Total Surplus/(Gap)

$49,000,000 ($49,000,000) $43,500,000 $10,000,000 $9,397,822 $2,704,367 $1,000,000 $3,000,000 $1,000,000 $1,000,000 $12,556,249 $0 $84,158,438 $0

Affordable 120 units $17,000,000 ($17,000,000) $6,000,000 50,000 $10,000,000 $1.00 $9,397,822 $1.00 $2,704,367 $1,000,000 $8,333 $3,000,000 $40,000 $1,000,000 $8,333 $1,000,000 $8,333 $0 $34,102,189 $0

ACQUISITION Land HARD COSTS Construction Shared Parking Cost Contingency

Cost

per unit per unit per unit per unit per unit

Calculated Fee

75%

$0 $0 $0 $ 12,556,249 $50,056,249 ($0)

3.25% 4% Credit Rate

1.3

$33,365,048.56 $43,374,563.13 $1,409,673.30 $14,096,733.02 $117,472.78

Market Rate Per Unit

% of TDC

Cost

Per Unit

$149,850 $149,850

$1,248.75 $1,248.75

0.4% $ 183,150 0.4% $ 183,150

$1,006.32 $1,006.32

$ 225.00 $ 60,222,487.50 $ 35,000.00 $4,228,000 $3,222,524 subtotal $ 67,673,011.88

$23,929,465 $1,680,000 $1,280,473.26 $26,889,938

$199,412.21 $14,000.00 $10,670.61 $224,082.82

70.2% $ 36,293,022 4.9% $ 2,548,000 3.8% $1,942,051 78.9% $ 40,783,073

$199,412.21 $14,000.00 $10,670.61 $224,082.82

$3,383,651 $1,344,496.92 $16,000 $6,000 $507,548 $201,675 $ 676,730.12 $268,899.38 $15,000 $7,500 $23,757 $9,503 $150,000 $50,000 $128,000 $57,600 $7,160 $580 $215,000 $15,000 $60,000 $20,000 $35,000 $20,000 $12,000 $6,000 $15,000 $7,500 $20,000 $10,000 $35,000 $30,000 $325,000 $175,000 $20,000 $20,000 $499,580 $92,290 $490,000 $170,000 $1,886,500 $654,500 $10,000 $10,000.00 $20,000 $15,000 $25,000 $12,500 3,249,290 1,624,645 $2,436,968 $1,624,645 $285,244 $129,066.67 $120,000 $120,000 $1,485,000 $360,000

$11,204.14 $50.00 $1,680.62 $2,240.83 $62.50 $79.19 $416.67 $480.00 $4.83 $125.00 $166.67 $166.67 $50.00 $62.50 $83.33 $250.00 $1,458.33 $166.67 $769.08 $1,416.67 $5,454.17 $83.33 $125.00 $104.17 $13,538.71 $13,538.71 $1,075.56 $1,000.00 $3,000.00

subtotal

LIHTC Basis with basis boost Annual Credit using 4% Creits Total 4% Credits per unit 9% LIHTC equity per unit

13.1% ROE* *based on 90% of CF to Mkt Rate

$333,000 $333,000

subtotal

SOFT COSTS A/E Design & Inspection A/E Additional Services Bond Permits Survey Geo/Environmental Assessment Clerk Insurance RE Taxes Marketing/Lease Up ENV Contingency Title and Recording Appraisal Traffic Study Lender & LP Review and Inspection Cost Certification/Accounting Legal Developer City Counsel Perm Loan Appl, Legal + Loan Fees Const Loan Fee & Legal Const Loan Interest DHCD Tax Credit Fees Other Consultants Testing Developer Overhead Developer Fee Soft Cost Contingency Syndication Costs Operating Reserves

Total Development Costs

raise raise

Affordable

Total Uses (cash)

Market Rate 182 units $32,000,000 ($32,000,000) $37,500,000 $0

Fee Cost Basis: $30,492,899 15% 3,000,000 450,000 12.5% 2,000,000 250,000 10% 25,492,899 2,549,290 3,249,290 1,624,645 fee 1,624,645 overhead

$16,152,426

$7,062,400

$58,853.33

$84,158,438

$34,102,189

$284,184.90

3.9% 0.0% 0.6% 0.8% 0.0% 0.0% 0.1% 0.2% 0.0% 0.0% 0.1% 0.1% 0.0% 0.0% 0.0% 0.1% 0.5% 0.1% 0.3% 0.5% 1.9% 0.0% 0.0% 0.0% 4.8% 4.8% 0.4% 0.4% 1.1%

100.0%

$ 2,039,153.67 $ 10,000 $305,873 $407,830.73 $ 7,500 $ 14,254 $ 100,000 $ 70,400 $ 6,580 $ 200,000 $ 40,000 $ 15,000 $ 6,000 $ 7,500 $ 10,000 $ 5,000 $ 150,000 $ ‐ $407,290 $320,000 $1,232,000 $ ‐ $ 5,000 $ 12,500 $ 1,624,645 $ 812,323 $156,176.98 $ ‐ $ 1,125,000

$11,204.14 $54.95 $1,680.62 $2,240.83 $41.21 $78.32 $549.45 $386.81 $36.15 $1,098.90 $219.78 $82.42 $32.97 $41.21 $54.95 $27.47 $824.18 $0.00 $2,237.86 $1,758.24 $6,769.23 $0.00 $27.47 $68.68 $8,926.62 $4,463.31 $858.12 $0.00 $6,181.32

$ 9,090,026

$49,945.20

$50,056,249

% of TDC 0.4% 0.4% 0.0% 72.5% 5.1% 3.9% 81.5% 0.0% 4.1% 0.0% 0.6% 0.8% 0.0% 0.0% 0.2% 0.1% 0.0% 0.4% 0.1% 0.0% 0.0% 0.0% 0.0% 0.0% 0.3% 0.0% 0.8% 0.6% 2.5% 0.0% 0.0% 0.0% 3.2% 1.6% 0.3% 0.0% 2.2%

0.4%

35

55.0%

3.5% 1.0% 3.0%

$275,034.34

Mixed-use & Mixed-income Development


3rd and Binney Apartments Cash Flow During Construction 12/13/2013

SOURCES of Funds Const/Bridge Loan ‐ MassHousing (Tax Exempt Const/Bridge Loan Repayment MassHousing Permanent Loan 9% LIHTC Syndication Proceeds ‐ 40 units 4% LIHTC Syndication Proceeds ‐ 80 units State HOME Cambridge Housing Trust Cambridge HOME Affordable Housing Trust Cash Equity

36

$81,454,071

USES of Funds

USES

6.00%

Jan‐14 Closing

Feb‐14 Month 1

Mar‐14 Month 2

Apr‐14 Month 3

$0 ($9,010,930) Closing

$0 ($1,496,028) Month 1

$0 ($1,496,923) Month 2

$0 ($1,496,028) Month 3

May‐14 Month 4

Jun‐14 Month 5

Jul‐14 Month 6

Aug‐14 Month 7

Sep‐14 Month 8

Oct‐14 Month 9

Nov‐14 Month 10

Dec‐14 Month 11

$49,000,000 ($49,000,000) $43,500,000 $10,000,000 $9,397,822 $1,000,000 $3,000,000 $1,000,000 $1,000,000 $12,556,249

Total Sources

Acquisition Costs: Acquisition: Land SUBTOTAL: ACQUISITION COST

3rd & Binney Apartments and Condos

Sources

$333,000 $333,000

$333,000 $333,000

$0

Construction Costs: Construction Shared Parking Cost Contingency

$60,222,488 $4,228,000 $3,222,524

$1,204,449.75 $84,560 $64,450.49

SUBTOTAL: CONSTRUCTION COST

$67,673,012

General Development Costs: A/E Design & Inspection A/E Additional Services Bond Permits Survey Geo/Environmental Assessment Clerk Insurance RE Taxes Marketing/Lease Up ENV Contingency Title and Recording Appraisal Traffic Study Lender & LP Review and Inspection Cost Certification/Accounting Legal Developer City Counsel Perm Loan Appl, Legal + Loan Fees Const Loan Fee & Legal Const Loan Interest DHCD Tax Credit Fees Other Consultants Testing Developer Overhead Developer Fee Soft Cost Contingency Syndication Costs Operating Reserves SUBTOTAL: SOFT COSTS TOTAL ACQ., CONSTR., & SOFT COSTS

$3,383,651 $16,000 $507,548 $676,730 $15,000 $23,757 $150,000 $128,000 $7,160 $215,000 $60,000 $35,000 $12,000 $15,000 $20,000 $35,000 $325,000 $20,000 $499,580 $490,000 $1,886,500 $10,000 $20,000 $25,000 $3,249,290 $2,436,968 $285,244 $120,000 $1,485,000 $16,152,426 $84,158,438

$2,706,920

Total DEVELOPMENT COST

$84,158,438

$9,010,930

$507,548 $676,730 $15,000 $23,757 $128,000

$35,000 $12,000 $15,000 $5,000 $11,000 $308,750 $14,000 $499,580 $490,000 $10,000 $20,000 $0 $1,624,645 $90,000 $1,485,000 $8,677,930 $9,010,930

$0 2%

$0

$0 $0 ($1,476,028) ($1,470,673) Month 4 Month 5

$0

$0

$0 $0 $0 $0 $0 $0 ($1,469,778) ($1,469,778) ($2,147,403) ($2,146,508) ($2,146,508) ($2,824,133) Month 6 Month 7 Month 8 Month 9 Month 10 Month 11

$0

$0

$0

$0

$0

$0

2% 2% $1,204,450 $1,204,450 $84,560 $84,560 $64,450 $64,450

2% 2% 2% 2% 3% 3% 3% 4% $1,204,450 $1,204,450 $1,204,450 $1,204,450 $1,806,675 $1,806,675 $1,806,675 $2,408,900 $84,560 $84,560 $84,560 $84,560 $126,840 $126,840 $126,840 $169,120 $64,450 $64,450 $64,450 $64,450 $96,676 $96,676 $96,676 $128,901

$1,353,460

$1,353,460

$1,353,460

$1,353,460

$1,353,460

$1,353,460

$1,353,460

$2,030,190

$2,030,190

$2,030,190

$2,706,920

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$894.94

$895

$895

$895

$20,000

$20,000

$20,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$6,250 $67,693.54

$6,250 $67,693.54

$6,250 $67,693.54

$6,250 $67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$142,567 $1,496,028

$143,462 $1,496,923

$142,567 $1,496,028

$122,567 $1,476,028

$117,212 $1,470,673

$116,317 $1,469,778

$116,317 $1,469,778

$117,212 $2,147,403

$116,317 $2,146,508

$116,317 $2,146,508

$117,212 $2,824,133

$1,496,028

$1,496,923

$1,496,028

$1,476,028

$1,470,673

$1,469,778

$1,469,778

$2,147,403

$2,146,508

$2,146,508

$2,824,133


Jan‐15 Month 12

Feb‐15 Month 13

Mar‐15 Month 14

Apr‐15 Month 15

May‐15 Month 16

Jun‐15 Month 17

Jul‐15 Month 18

Aug‐15 Month 19

Sep‐15 Month 20

Oct‐15 Month 21

Nov‐15 Month 22

Dec‐15 Month 23

Jan‐16 Month 24

Jan‐16 Month 25

Total Sources $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 ($2,823,238) ($2,823,238) ($3,500,863) Month 12 Month 13 Month 14

$0

$0

$0 ($3,499,968) Month 15

$0 ($3,499,968) Month 16

$0 ($3,500,863) Month 17

$0 ($4,176,698) Month 18

$0 ($4,176,698) Month 19

$0 ($4,177,593) Month 20

$0 ($4,176,698) Month 21

$0 ($4,932,512) Month 22

$0 ($4,933,407) Month 23

$0 ($4,962,512) Month 24

5% $3,011,124 $211,400 $161,126

5% $3,011,124 $211,400 $161,126

5% $3,011,124 $211,400 $161,126

6% $3,613,349 $253,680 $193,351

6% $3,613,349 $253,680 $193,351

6% $3,613,349 $253,680 $193,351

6% $3,613,349 $253,680 $193,351

7% $4,215,574 $295,960 $225,577

7% $4,215,574 $295,960 $225,577

7% $4,215,574 $295,960 $225,577

$2,706,920

$2,706,920

$3,383,651

$3,383,651

$3,383,651

$3,383,651

$4,060,381

$4,060,381

$4,060,381

$4,060,381

$4,737,111

$4,737,111

$4,737,111

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$28,197 $666.67

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$6,250.00

$71,666.67

$895 $71,666.67

$71,666.67

$895

$625 $1,000

$625 $1,000

$895

$625 $1,000

$625 $1,000

$625 $1,000

$895

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000

$625 $1,000 $5,417 $2,000

$625 $1,000 $5,417 $2,000

7%

$0

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$67,693.54

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15

$11,885.15 $30,000

$116,317 $2,823,238

$116,317 $2,823,238

$117,212 $3,500,863

$116,317 $3,499,968

$116,317 $3,499,968

$117,212 $3,500,863

$116,317 $4,176,698

$116,317 $4,176,698

$117,212 $4,177,593

$116,317 $4,176,698

$195,401 $4,932,512

$196,296 $4,933,407

$225,401 $4,962,512

$2,823,238

$3,500,863

$3,499,968

$3,499,968

$3,500,863

$4,176,698

$4,176,698

$4,177,593

$4,176,698

$4,932,512

$4,933,407

$4,962,512

$67,673,012

$4,323,468 $4,323,468

$4,323,468

$0 $0 $0 $84,158,438

$625 $1,000 $5,417 $2,000

$67,693.54

$60,222,488 $4,228,000 $3,222,524

$3,383,651 $16,000 $507,548 $676,730 $15,000 $23,757 $150,000 $128,000 $7,160 $215,000 $60,000 $35,000 $12,000 $15,000 $20,000 $35,000 $325,000 $20,000 $499,580 $490,000 $1,886,500 $10,000 $20,000 $25,000 $3,249,290 $2,436,968 $285,244 $120,000 $1,485,000 $16,152,426 $84,158,438

$1,886,500

$2,823,238

$0 ($84,158,438) Total Uses $333,000 $333,000

$0

4% 4% 5% $2,408,900 $2,408,900 $3,011,124 $169,120 $169,120 $211,400 $128,901 $128,901 $161,126

$625 $1,000

$0 ($4,323,468)

$2,436,968

($49,000,000) $49,000,000 ($43,500,000) ($10,000,000) ($9,397,822) ($1,000,000) ($3,000,000) ($1,000,000) ($1,000,000) ($12,556,249) ($81,454,071) ($84,158,438) $0 $0 $0 $0 $0 $0 $0 $0 $0

107%

$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

37

Mixed-use & Mixed-income Development


3rd and Binney Apartments 15‐Year Operating Projection 12/13/13

Units

Affordable Market Rate

Total Units 60% AMI Vacancy Rate Market Rate Vacancy Rate Commercial Vacancy Rate MRVP Income Trending 60% Income Trending S8 income Trending Other Income Trending Operating Expense Trending Water and Sewer Trending Real Estate Taxes Trending

38

Year Revenue

Gross Rental Revenue Less Vacancy Total Vacancy Net Rental Income Other Income Draw on Reserve Total Net Revenue Operating Expenses Administrative

Total Administrative Maintenance

Total Maintenance Utilities

Total Utilities MIP Real Estate Taxes ‐ Affordable Real Estate Taxes ‐Market Insurance Replacement Res. Total Operating Expenses Net Operating Income Debt Service Net Cash Flow

Year 1

$7,792,776 60% AMI Market Rate Commercial

Year 4

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 5

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 6

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 7

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 8

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 9

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 10

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 11

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 12

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5% Year 13

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5%

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5%

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 4.0% 2.5%

Year 14

Year 15

Year 16

$1,691,752 $6,578,004 $0 $8,269,756 $84,588 $526,240 $0 $610,828

$1,725,587 $6,709,564 $0 $8,435,151 $86,279 $536,765 $0 $623,044

$1,760,099 $6,843,755 $0 $8,603,854 $88,005 $547,500 $0 $635,505

$1,795,301 $6,980,630 $0 $8,775,931 $89,765 $558,450 $0 $648,215

$1,831,207 $7,120,243 $0 $8,951,450 $91,560 $569,619 $0 $661,180

$1,867,831 $7,262,648 $0 $9,130,479 $93,392 $581,012 $0 $674,403

$1,905,188 $7,407,901 $0 $9,313,089 $95,259 $592,632 $0 $687,891

$1,943,292 $7,556,059 $0 $9,499,350 $97,165 $604,485 $0 $701,649

$1,982,157 $7,707,180 $0 $9,689,337 $99,108 $616,574 $0 $715,682

$2,021,801 $7,861,324 $0 $9,883,124 $101,090 $628,906 $0 $729,996

$2,062,237 $8,018,550 $0 $10,080,787 $103,112 $641,484 $0 $744,596

$2,103,481 $8,178,921 $0 $10,282,402 $105,174 $654,314 $0 $759,488

$2,145,551 $8,342,499 $0 $10,488,050 $107,278 $667,400 $0 $774,678

$7,217,179 $45,300

$7,361,523 $46,659

$7,508,753 $48,059

$7,658,928 $49,501

$7,812,107 $50,986

$7,968,349 $52,515

$8,127,716 $54,091

$8,290,270 $55,713

$8,456,076 $57,385

$8,625,197 $59,106

$8,797,701 $60,879

$8,973,655 $62,706

$9,153,128 $64,587

$9,336,191 $66,525

$9,522,915 $68,520

$9,713,373 $70,576

$7,262,479

$7,408,182

$7,556,812

$7,708,429

$7,863,092

$8,020,864

$8,181,807

$8,345,984

$8,513,460

$8,684,303

$8,858,581

$9,036,361

$9,217,715

$9,402,715

$9,591,435

$9,783,949

$254,187 $325,000 $65,000 $25,000 $20,000 $150,000 $24,000 $12,000 $6,000 $20,000 $40,000 $10,000 $951,187

$261,812 $334,750 $66,950 $25,750 $20,600 $154,500 $24,720 $12,360 $6,180 $20,600 $41,200 $10,300 $979,722

$269,667 $344,793 $68,959 $26,523 $21,218 $159,135 $25,462 $12,731 $6,365 $21,218 $42,436 $10,609 $1,009,114

$277,757 $355,136 $71,027 $27,318 $21,855 $163,909 $26,225 $13,113 $6,556 $21,855 $43,709 $10,927 $1,039,387

$286,089 $365,790 $73,158 $28,138 $22,510 $168,826 $27,012 $13,506 $6,753 $22,510 $45,020 $11,255 $1,070,569

$294,672 $376,764 $75,353 $28,982 $23,185 $173,891 $27,823 $13,911 $6,956 $23,185 $46,371 $11,593 $1,102,686

$303,512 $388,067 $77,613 $29,851 $23,881 $179,108 $28,657 $14,329 $7,164 $23,881 $47,762 $11,941 $1,135,767

$312,618 $399,709 $79,942 $30,747 $24,597 $184,481 $29,517 $14,758 $7,379 $24,597 $49,195 $12,299 $1,169,840

$321,996 $411,700 $82,340 $31,669 $25,335 $190,016 $30,402 $15,201 $7,601 $25,335 $50,671 $12,668 $1,204,935

$331,656 $424,051 $84,810 $32,619 $26,095 $195,716 $31,315 $15,657 $7,829 $26,095 $52,191 $13,048 $1,241,083

$341,606 $436,773 $87,355 $33,598 $26,878 $201,587 $32,254 $16,127 $8,063 $26,878 $53,757 $13,439 $1,278,315

$351,854 $449,876 $89,975 $34,606 $27,685 $207,635 $33,222 $16,611 $8,305 $27,685 $55,369 $13,842 $1,316,665

$362,410 $463,372 $92,674 $35,644 $28,515 $213,864 $34,218 $17,109 $8,555 $28,515 $57,030 $14,258 $1,356,165

$373,282 $477,273 $95,455 $36,713 $29,371 $220,280 $35,245 $17,622 $8,811 $29,371 $58,741 $14,685 $1,396,850

$384,480 $491,592 $98,318 $37,815 $30,252 $226,888 $36,302 $18,151 $9,076 $30,252 $60,504 $15,126 $1,438,755

$396,015 $506,339 $101,268 $38,949 $31,159 $233,695 $37,391 $18,696 $9,348 $31,159 $62,319 $15,580 $1,481,918

$125,000 $25,000 $25,000 $50,000 $75,000 $75,000 $25,000 $40,000 $30,000 $10,000 $30,000 $12,500 $522,500

$128,750 $25,750 $25,750 $51,500 $77,250 $77,250 $25,750 $41,200 $30,900 $10,300 $30,900 $12,875 $538,175

$132,613 $26,523 $26,523 $53,045 $79,568 $79,568 $26,523 $42,436 $31,827 $10,609 $31,827 $13,261 $554,320

$136,591 $27,318 $27,318 $54,636 $81,955 $81,955 $27,318 $43,709 $32,782 $10,927 $32,782 $13,659 $570,950

$140,689 $28,138 $28,138 $56,275 $84,413 $84,413 $28,138 $45,020 $33,765 $11,255 $33,765 $14,069 $588,078

$144,909 $28,982 $28,982 $57,964 $86,946 $86,946 $28,982 $46,371 $34,778 $11,593 $34,778 $14,491 $605,721

$149,257 $29,851 $29,851 $59,703 $89,554 $89,554 $29,851 $47,762 $35,822 $11,941 $35,822 $14,926 $623,892

$153,734 $30,747 $30,747 $61,494 $92,241 $92,241 $30,747 $49,195 $36,896 $12,299 $36,896 $15,373 $642,609

$158,346 $31,669 $31,669 $63,339 $95,008 $95,008 $31,669 $50,671 $38,003 $12,668 $38,003 $15,835 $661,887

$163,097 $32,619 $32,619 $65,239 $97,858 $97,858 $32,619 $52,191 $39,143 $13,048 $39,143 $16,310 $681,744

$167,990 $33,598 $33,598 $67,196 $100,794 $100,794 $33,598 $53,757 $40,317 $13,439 $40,317 $16,799 $702,196

$173,029 $34,606 $34,606 $69,212 $103,818 $103,818 $34,606 $55,369 $41,527 $13,842 $41,527 $17,303 $723,262

$178,220 $35,644 $35,644 $71,288 $106,932 $106,932 $35,644 $57,030 $42,773 $14,258 $42,773 $17,822 $744,960

$183,567 $36,713 $36,713 $73,427 $110,140 $110,140 $36,713 $58,741 $44,056 $14,685 $44,056 $18,357 $767,309

$189,074 $37,815 $37,815 $75,629 $113,444 $113,444 $37,815 $60,504 $45,378 $15,126 $45,378 $18,907 $790,328

$194,746 $38,949 $38,949 $77,898 $116,848 $116,848 $38,949 $62,319 $46,739 $15,580 $46,739 $19,475 $814,038

200 300 0 325

$60,400 $90,600 $0 $98,150 $249,150

$62,212 $93,318 $0 $104,039 $259,569

$64,078 $96,118 $0 $110,281 $270,477

$66,001 $99,001 $0 $116,898 $281,900

$67,981 $101,971 $0 $123,912 $293,864

$70,020 $105,030 $0 $128,869 $303,919

$72,121 $108,181 $0 $134,023 $314,325

$74,284 $111,427 $0 $139,384 $325,095

$76,513 $114,769 $0 $144,960 $336,242

$78,808 $118,212 $0 $150,758 $347,779

$81,173 $121,759 $0 $156,788 $359,720

$83,608 $125,412 $0 $163,060 $372,079

$86,116 $129,174 $0 $169,582 $384,872

$88,699 $133,049 $0 $176,366 $398,114

$91,360 $137,041 $0 $183,420 $411,821

$94,101 $141,152 $0 $190,757 $426,010

500 3500 350 $350.00

$60,000 $637,000 $105,700 $105,700 $2,631,237

$61,500

$63,038

$64,613

$66,229

$67,884

$69,582

$71,321

$73,104

$74,932

$76,805

$78,725

$80,693

$82,711

$84,778

$86,898

$108,871 $108,871 $2,056,708

$112,137 $112,137 $2,121,223

$115,501 $115,501 $2,187,853

$118,966 $118,966 $2,256,673

$122,535 $122,535 $2,325,281

$126,211 $126,211 $2,395,989

$129,998 $129,998 $2,468,861

$133,898 $133,898 $2,543,964

$137,915 $137,915 $2,621,367

$142,052 $142,052 $2,701,141

$146,314 $146,314 $2,783,359

$150,703 $150,703 $2,868,096

$155,224 $155,224 $2,955,432

$159,881 $159,881 $3,045,445

$164,677 $164,677 $3,138,218

150

3.50% 20%

50

Payroll Payroll Taxes & Ben Janitorial Mat. & Svc Landscaping Decorating (int. only) Repairs Trash Removal Elevator Maintenance Snow removal Exterminating Alarm & Sprinkler Maint. Misc.

3rd & Binney Apartments and Condos

Year 3

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 6.0% 2.5%

$1,658,581 $6,449,023 $0 $8,107,604 $82,929 $515,922 $0 $598,851

Management Fee Payroll Payroll Taxes & Ben Legal Audit Marketing Telephone Office Supplies LIHTC monitoring Asset Management Resident Services Misc.

First Mortgage

Year 2

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 6.0% 2.5%

$1,626,060 $6,322,572 $0 $7,948,632 $81,303 $505,806 $0 $587,109

Laundry

$8,712.70 per unit

5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 6.0% 2.5%

$1,594,176 $6,198,600 $0 $7,792,776 $79,709 $495,888 $0 $575,597

60% AMI Market Rate Commercial

Electricity Gas Oil Water & Sewer

120 182 302 5.0% 8.0% 8.0% 2.0% 2.0% 2.0% 3.0% 3.0% 6.0% 2.5%

20%

$4,631,242 $5,351,473 $5,435,589 $5,520,576 $5,606,420 $5,695,583 $5,785,818 $5,877,123 $5,969,497 $6,062,937 $6,157,440 $6,253,002 $6,349,619 $6,447,284 $6,545,990 $6,645,731 (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) (2,802,209) $1,829,034 $2,549,265 $2,633,380 $2,718,367 $2,804,211 $2,893,374 $2,983,609 $3,074,914 $3,167,288 $3,260,728 $3,355,231 $3,450,794 $3,547,410 $3,645,075 $3,743,782 $3,843,522


3rd and Binney Apartments Revenue Schedule 12/13/13

Household size 60% 1 person (studio) $39,660 1 person (1 bedroom$39,660 2 persons (2 bedroo $45,360 3 persons (3 bedroo $51,000 total

RENTAL: 40% of total units

Total Residential Un 60% AMI

Market Rate

Total Rental Units

# of Units

302 120 4 4 4 18 67 6 6 5 6 182 9 8 11 85 60 1 1 3 4 302

Unit Type

Net Sq FtGross Monthly RenRent/Sq Ft Yearly Rent

studio A 435 studio B 444 studio C 525 1 bedroom 609 2 bedroom 914 3 bedroom A 1,134 3 bedroom B 1,160 3 bedroom C 1,224 3 bedroom D 1,247 studio A 435 studio B 444 studio C 525 1 bedroom 609 2 bedroom 914 3 bedroom A 1,134 3 bedroom B 1,160 3 bedroom C 1,224 3 bedroom D 1,247 15,382

$892 $917 $942 $992 $1,134 $1,175 $1,200 $1,225 $1,275 $2,100 $2,150 $2,175 $2,700 $3,200 $3,800 $3,825 $3,900 $3,925 $37,525

2.05 2.07 1.79 1.63 1.24 1.04 1.03 1.00 1.02 4.83 4.85 4.14 4.43 3.50 3.35 3.30 3.19 3.15

$42,792 $43,992 $45,192 $214,164 $911,736 $84,600 $86,400 $73,500 $91,800 $226,800 $206,400 $287,100 $2,754,000 $2,304,000 $45,600 $45,900 $140,400 $188,400 $7,792,776

Affordable sf Market rate sf Total

Net Square Footage 105,147 130,767 235,914

Affordable Market Rate Total

Yearly Revenue $1,594,176 $6,198,600 $7,792,776

39

total

Mixed-use & Mixed-income Development




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.