tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of ESS

Tables in the 10-Q of ESSEX PROPERTY TRUST, INC.

37 tables with numbers, filed Jul 31, 2017. Each one downloads as a CSV for Excel or Google Sheets, with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed. Open the filing on sec.gov ↗

Table 1 after “INDEX”

Download CSV
PART I. FINANCIAL INFORMATIONPage No.
Item 1.Condensed Consolidated Financial Statements of Essex Property Trust, Inc. (Unaudited)
Condensed Consolidated Balance Sheets as of June 30, 2017 and December 31, 20162
Condensed Consolidated Statements of Income and Comprehensive Income for the three and six months ended June 30, 2017 and 20163
Condensed Consolidated Statement of Equity for the six months ended June 30, 20174
Condensed Consolidated Statements of Cash Flows for the six months ended June 30, 2017 and 20165
Condensed Consolidated Financial Statements of Essex Portfolio L.P. (Unaudited)
Condensed Consolidated Balance Sheets as of June 30, 2017 and December 31, 20167

First 8 of 22 rows. The CSV has all of them.

Table 2 after “(In thousands, except parenthetical and share amounts)”

Download CSV
ASSETSJune 30, 2017December 31, 2016
Real estate:
Rental properties:
Land and land improvements$2,719,064$2,559,743
Buildings and improvements10,536,63910,116,563
13,255,70312,676,306
Less: accumulated depreciation(2,534,646)(2,311,546)
10,721,05710,364,760

First 8 of 39 rows. The CSV has all of them.

Table 3 after “(In thousands, except share and per share amounts)”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2017201620172016
Revenues:
Rental and other property$336,766$319,562$669,934$631,740
Management and other fees from affiliates2,2962,0284,5324,052
339,062321,590674,466635,792
Expenses:
Property operating, excluding real estate taxes63,38161,538127,026121,609

First 8 of 38 rows. The CSV has all of them.

Table 4 after “(Dollars and shares in thousands)”

Download CSV
Common stockAdditional paid-in capitalDistributionsin excess of accumulated earningsAccumulatedothercomprehensive loss, netNoncontrolling Interest
SharesAmountTotal
Balances at December 31, 201665,528$6$7,029,679$(805,409)$(32,098)$100,059$6,292,237
Net income———249,723—13,623263,346
Reversal of unrealized gains upon the sale of marketable securities————(1,564)(54)(1,618)
Change in fair value of derivatives and amortization of swap settlements————4,6571604,817
Change in fair value of marketable securities, net————66423687
Issuance of common stock under:

First 8 of 17 rows. The CSV has all of them.

Table 5 after “(In thousands)”

Download CSV
Six Months Ended June 30,
20172016
Cash flows from operating activities:
Net income$263,346$163,731
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization233,442219,380
Amortization of discount on marketable securities and other investments(7,270)(7,457)
Amortization of (premium) discount and debt financing costs, net(4,317)(7,598)

First 8 of 49 rows. The CSV has all of them.

Table 6 after “5”

Download CSV
Six Months Ended June 30,
20172016
Cash and cash equivalents at end of period$183,885$182,515
Supplemental disclosure of cash flow information:
Cash paid for interest, net of $6.6 million and $6.2 million capitalized in 2017 and 2016, respectively$106,448$93,031
Supplemental disclosure of noncash investing and financing activities:
Issuance of DownREIT units in connection with acquisition of real estate$22,506$—
Transfers between real estate under development to rental properties, net$1,540$108,402

First 8 of 11 rows. The CSV has all of them.

Table 7 after “(In thousands, except parenthetical and unit amounts)”

Download CSV
June 30, 2017December 31, 2016
ASSETS
Real estate:
Rental properties:
Land and land improvements$2,719,064$2,559,743
Buildings and improvements10,536,63910,116,563
13,255,70312,676,306
Less: accumulated depreciation(2,534,646)(2,311,546)

First 8 of 42 rows. The CSV has all of them.

Table 8 after “(In thousands, except unit and per unit amounts)”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2017201620172016
Revenues:
Rental and other property$336,766$319,562$669,934$631,740
Management and other fees from affiliates2,2962,0284,5324,052
339,062321,590674,466635,792
Expenses:
Property operating, excluding real estate taxes63,38161,538127,026121,609

First 8 of 38 rows. The CSV has all of them.

Table 9 after “(Unaudited)”

Download CSV
General PartnerLimited PartnersAccumulated other comprehensive loss
Common EquityCommon EquityNoncontrolling Interest
UnitsAmountUnitsAmountTotal
Balances at December 31, 201665,528$6,224,2762,237$49,436$(29,348)$47,873$6,292,237
Net income—249,723—8,568—5,055263,346
Reversal of unrealized gains upon the sale of marketable securities————(1,618)—(1,618)
Change in fair value of derivatives and amortization of swap settlements————4,817—4,817
Change in fair value of marketable securities, net————687—687

First 8 of 18 rows. The CSV has all of them.

Table 10 after “(In thousands)”

Download CSV
Six Months Ended June 30,
20172016
Cash flows from operating activities:
Net income$263,346$163,731
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization233,442219,380
Amortization of discount on marketable securities and other investments(7,270)(7,457)
Amortization of (premium) discount and debt financing costs, net(4,317)(7,598)

First 8 of 49 rows. The CSV has all of them.

Table 11 after “10”

Download CSV
Six Months Ended June 30,
20172016
Cash and cash equivalents at end of period$183,885$182,515
Supplemental disclosure of cash flow information:
Cash paid for interest, net of $6.6 million and $6.2 million capitalized in 2017 and 2016, respectively$106,448$93,031
Supplemental disclosure of noncash investing and financing activities:
Issuance of DownREIT units in connection with acquisition of real estate$22,506$—
Transfers between real estate under development to rental properties, net$1,540$108,402

First 8 of 11 rows. The CSV has all of them.

Table 12 after “, marketable securities consist of the following ($ in thousands):”

Download CSV
June 30, 2017
AmortizedCostGrossUnrealizedGain (Loss)Carrying Value
Available for sale:
Investment-grade unsecured bonds$18,332$148$18,480
Investment funds - U.S. treasuries7,774(23)7,751
Common stock and stock funds23,66341824,081
Held to maturity:
Mortgage backed securities101,683—101,683

First 8 of 18 rows. The CSV has all of them.

Table 13 after “($ in thousands)”

Download CSV
Change in fairvalue and amortizationof swap settlementsUnrealizedgains/(losses) onavailable for salesecuritiesTotal
Balance at December 31, 2016$(32,963)$865$(32,098)
Other comprehensive income before reclassification8,6296649,293
Amounts reclassified from accumulated other comprehensive loss(3,972)(1,564)(5,536)
Other comprehensive income (loss)4,657(900)3,757
Balance at June 30, 2017$(28,306)$(35)$(28,341)

Table 14 after “($ in thousands):”

Download CSV
Change in fairvalue and amortizationof swap settlementsUnrealizedgains/(losses) onavailable for salesecuritiesTotal
Balance at December 31, 2016$(30,161)$813$(29,348)
Other comprehensive income before reclassification8,9256879,612
Amounts reclassified from accumulated other comprehensive loss(4,108)(1,618)(5,726)
Other comprehensive income (loss)4,817(931)3,886
Balance at June 30, 2017$(25,344)$(118)$(25,462)

Table 15 after “(Unaudited)”

Download CSV
2017
Balance at January 1,$44,684
Reclassification due to change in redemption value and other1,117
Redemptions(720)
Additions—
Balance at June 30,$45,081

Table 16 after “are as follows (in thousands, except in parenthetical):”

Download CSV
Ownership PercentageJune 30, 2017December 31, 2016
Membership interest/Partnership interest in:
CPPIB50%-55%$461,872$422,068
Wesco I, III and IV50%180,005180,687
Palm Valley (1)50%—68,396
BEXAEW50%46,72847,963
BEX II (2)50%(36,025)19,078
Other50%-55%41,05343,713

First 8 of 12 rows. The CSV has all of them.

Table 17 after “The combined summarized entity financial information of co-investments and preferred equity investments is as follows (in thousands).”

Download CSV
June 30, 2017December 31, 2016
Combined balance sheets:
Rental properties and real estate under development$3,460,610$3,807,245
Other assets86,369121,505
Total assets$3,546,979$3,928,750
Debt$1,416,292$1,617,639
Other liabilities69,12874,607
Equity (1)2,061,5592,236,504

First 8 of 10 rows. The CSV has all of them.

Table 18 after “(Unaudited)”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2017201620172016
Combined statements of income:
Property revenues$72,111$69,180$148,016$144,310
Property operating expenses(25,866)(24,580)(51,275)(50,401)
Net operating income46,24544,60096,74193,909
Gain on sale of real estate—10,796—28,291
Interest expense(14,024)(11,142)(25,945)(24,282)

First 8 of 12 rows. The CSV has all of them.

Table 19 after “($ in thousands):”

Download CSV
June 30, 2017December 31, 2016
Notes receivable, secured, bearing interest at 10.00%, due May 2021$3,967$—
Notes receivable, secured, bearing interest at 10.75%, due September 202027,76817,685
Related party note receivable, secured, bearing interest at 9.50%, due October 2019(1)6,5966,593
Notes and other receivables from affiliates (2)4,3614,695
Other receivables11,96811,997
Total notes and other receivables$54,660$40,970

Table 20 after “Debt consists of the following ($ in thousands):”

Download CSV
June 30, 2017December 31, 2016Weighted AverageMaturityIn Years
Unsecured bonds private placement - fixed rate$314,315$314,1903.1
Term loan - variable rate348,36898,1894.6
Bonds public offering - fixed rate2,878,1192,834,4007.0
Unsecured debt, net (1)3,540,8023,246,779
Lines of credit (2)—125,000
Mortgage notes payable, net (3)2,122,5932,191,4815.7
Total debt, net$5,663,395$5,563,260

First 8 of 12 rows. The CSV has all of them.

Table 21 after “are as follows (excluding lines of credit) ($ in thousands):”

Download CSV
Remaining in 2017$55,105
2018257,108
2019653,114
2020695,070
2021552,831
Thereafter3,439,209
Total$5,652,437

Table 22 after “(Unaudited)”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2017201620172016
Revenues:
Southern California$147,784$139,108$294,883$275,002
Northern California126,550113,035249,858223,443
Seattle Metro57,08753,576113,279105,649
Other real estate assets5,34513,84311,91427,646
Total property revenues$336,766$319,562$669,934$631,740

First 8 of 26 rows. The CSV has all of them.

Table 23 after “($ in thousands):”

Download CSV
June 30, 2017December 31, 2016
Assets:
Southern California$4,854,134$4,924,792
Northern California4,266,1003,791,549
Seattle Metro1,544,3641,570,340
Other real estate assets56,45978,079
Net reportable operating segment - real estate assets10,721,05710,364,760
Real estate under development263,284190,505

First 8 of 15 rows. The CSV has all of them.

Table 24 after “Essex Property Trust, Inc.”

Download CSV
Three Months Ended June 30, 2017Three Months Ended June 30, 2016
IncomeWeighted-averageCommonSharesPerCommonShareAmountIncomeWeighted-averageCommonSharesPerCommonShareAmount
Basic:
Net income available to common stockholders$70,75965,729,074$1.08$72,01365,451,110$1.10
Effect of Dilutive Securities:
Stock options—90,620—124,268
Diluted:
Net income available to common stockholders$70,75965,819,694$1.08$72,01365,575,378$1.10

Table 25 after “Essex Property Trust, Inc.”

Download CSV
Six Months Ended June 30, 2017Six Months Ended June 30, 2016
IncomeWeighted-averageCommonSharesPerCommonShareAmountIncomeWeighted-averageCommonSharesPerCommonShareAmount
Basic:
Net income available to common stockholders$249,72365,639,775$3.80$149,99465,428,382$2.29
Effect of Dilutive Securities:
Stock options—91,515—130,429
DownREIT units738210,728——
Diluted:

First 8 of 9 rows. The CSV has all of them.

Table 26 after “Essex Portfolio, L.P.”

Download CSV
Three Months Ended June 30, 2017Three Months Ended June 30, 2016
IncomeWeighted-averageCommon UnitsPerCommonUnitAmountIncomeWeighted-averageCommon UnitsPerCommonUnitAmount
Basic:
Net income available to common unitholders$73,18167,980,761$1.08$74,46367,675,038$1.10
Effect of Dilutive Securities:
Stock options—90,620—124,268
Diluted:
Net income available to common unitholders$73,18168,071,381$1.08$74,46367,799,306$1.10

Table 27 after “Essex Portfolio, L.P.”

Download CSV
Six Months Ended June 30, 2017Six Months Ended June 30, 2016
IncomeWeighted-averageCommon UnitsPerCommonUnitAmountIncomeWeighted-averageCommon UnitsPerCommonUnitAmount
Basic:
Net income available to common unitholders$258,29167,891,734$3.80$155,22867,654,279$2.29
Effect of Dilutive Securities:
Stock options—91,515—130,429
DownREIT units738210,728——
Diluted:

First 8 of 9 rows. The CSV has all of them.

Table 28 after “The Company’s consolidated apartment communities are as follows:”

Download CSV
As of June 30, 2017As of June 30, 2016
Apartment Homes%Apartment Homes%
Southern California23,34347%23,94949%
Northern California15,84832%14,86530%
Seattle Metro10,23821%10,23921%
Total49,429100%49,053100%

Table 29 after “is as follows:”

Download CSV
Three Months Ended June 30,
20172016
Southern California96.2%95.9%
Northern California96.7%96.2%
Seattle Metro96.2%95.9%

Table 30 after “The following table provides a breakdown of revenue amounts, including revenues attributable to the Same-Properties:”

Download CSV
Number of ApartmentThree Months Ended June 30,DollarPercentage
Property Revenues ($ in thousands)Homes20172016ChangeChange
Same-Property Revenues:
Southern California21,998$138,476$133,341$5,1353.9%
Northern California13,892109,100106,1772,9232.8%
Seattle Metro10,23857,08653,5753,5116.6%
Total Same-Property Revenues46,128304,662293,09311,5693.9%
Non-Same Property Revenues32,10426,4695,63521.3%

First 8 of 9 rows. The CSV has all of them.

Table 31 after “is as follows:”

Download CSV
Six Months Ended June 30,
20172016
Southern California96.3%96.0%
Northern California96.7%96.1%
Seattle Metro96.4%95.8%

Table 32 after “The following table provides a breakdown of revenue amounts, including revenues attributable to the Same-Properties:”

Download CSV
Number of ApartmentSix Months Ended June 30,DollarPercentage
Property Revenues ($ in thousands)Homes20172016ChangeChange
Same-Property Revenues:
Southern California21,998$276,448$264,953$11,4954.3%
Northern California13,892217,060210,3426,7183.2%
Seattle Metro10,238113,279105,6487,6317.2%
Total Same-Property Revenues46,128606,787580,94325,8444.4%
Non-Same Property Revenues63,14750,79712,35024.3%

First 8 of 9 rows. The CSV has all of them.

Table 33 after “Essex Property Trust, Inc.”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2017201620172016
Net income available to common stockholders$70,759$72,013$249,723$149,994
Adjustments:
Depreciation and amortization117,939109,673233,442219,380
Gains not included in Funds from Operations attributable to common stockholders and unitholders(2,159)(5,611)(114,815)(33,304)
Deferred tax expense on sale of real estate and land - taxable REIT subsidiary activity———4,279
Depreciation add back from unconsolidated co-investments13,62712,45726,48124,480

First 8 of 22 rows. The CSV has all of them.

Table 34 after “different financing and overhead structures, with varying marginal impacts to overhead by acquiring real estate, NOI is considered by many i”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2017201620172016
Earnings from operations$112,247$105,873$221,478$205,868
Adjustments:
Depreciation and amortization117,939109,673233,442219,380
Management and other fees from affiliates(2,296)(2,028)(4,532)(4,052)
General and administrative10,3379,69820,93818,880
Acquisition and investment related costs2742678301,095

First 8 of 11 rows. The CSV has all of them.

Table 35 after “.”

Download CSV
Carrying andEstimated Carrying Value
NotionalMaturityEstimated50-50
(in thousands)AmountDate RangeFair ValueBasis PointsBasis Points
Cash flow hedges:
Interest rate swaps$200,0002017-2022$3,871$7,643$62
Interest rate caps20,6742018-2019———
Total cash flow hedges$220,6742017-2022$3,871$7,643$62

Table 36 after “The Company’s interest rate risk is monitored using a variety of techniques. The table below presents the principal amounts and weighted ave”

Download CSV
For the Years Ended20172018201920202021ThereafterTotalFair value
(in thousands, except for interest rates)
Fixed rate debt$54,852256,567652,522694,424552,1232,810,732$5,021,220$5,157,073
Average interest rate4.6%5.7%4.3%4.8%4.3%3.6%4.0%
Variable rate debt (1)$253541592646708628,477(2) (3)$631,217$626,655
Average interest rate1.9%1.9%1.9%1.9%1.9%2.0%2.0%

Table 37 after “Item 6: Exhibits”

Download CSV
A. Exhibits
4.1Indenture, dated as of April 10, 2017, among Essex Portfolio, L.P., Essex Property Trust, Inc., and U.S. Bank National Association, as trustee, including the form of 3.625% Senior Notes due 2027 and the guarantee thereof, attached as Exhibit 4.1 to the Company’s Current Report on Form 8-K, filed April 10, 2017, and incorporated herein by reference.
12.1Ratio of Earnings to Fixed Charges.
31.1Certification of Michael J. Schall, Chief Executive Officer, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
31.2Certification of Angela L. Kleiman, Chief Financial Officer, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
31.3Certification of Michael J. Schall, Principal Executive Officer of General Partner, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
31.4Certification of Angela L. Kleiman, Principal Financial Officer of General Partner, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
32.1Certification of Michael J. Schall, Chief Executive Officer, pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.

First 8 of 17 rows. The CSV has all of them.