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 Nov 3, 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 September 30, 2017 and December 31, 20162
Condensed Consolidated Statements of Income and Comprehensive Income for the three and nine months ended September 30, 2017 and 20163
Condensed Consolidated Statement of Equity for the nine months ended September 30, 20174
Condensed Consolidated Statements of Cash Flows for the nine months ended September 30, 2017 and 20165
Condensed Consolidated Financial Statements of Essex Portfolio L.P. (Unaudited)
Condensed Consolidated Balance Sheets as of September 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
ASSETSSeptember 30, 2017December 31, 2016
Real estate:
Rental properties:
Land and land improvements$2,719,064$2,559,743
Buildings and improvements10,585,74210,116,563
13,304,80612,676,306
Less: accumulated depreciation(2,651,542)(2,311,546)
10,653,26410,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 September 30,Nine Months Ended September 30,
2017201620172016
Revenues:
Rental and other property$341,974$327,078$1,011,908$958,818
Management and other fees from affiliates2,3952,0936,9276,145
344,369329,1711,018,835964,963
Expenses:
Property operating, excluding real estate taxes66,60663,781193,632185,390

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

Table 4 after “(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———329,446—18,935348,381
Reversal of unrealized gains upon the sale of marketable securities————(1,596)(54)(1,650)
Change in fair value of derivatives and amortization of swap settlements————7,1602457,405
Change in fair value of marketable securities, net————1,902641,966
Issuance of common stock under:

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

Table 5 after “(In thousands)”

Download CSV
Nine Months Ended September 30,
20172016
Cash flows from operating activities:
Net income$348,381$233,893
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization350,893329,847
Amortization of discount on marketable securities and other investments(11,128)(10,771)
Amortization of (premium) discount and debt financing costs, net(5,132)(11,432)

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

Table 6 after “5”

Download CSV
Nine Months Ended September 30,
20172016
Common and preferred stock dividends paid(335,110)(306,284)
Net cash used in financing activities(245,304)(150,198)
Net (decrease) increase in cash and cash equivalents(18,414)165,484
Cash and cash equivalents at beginning of period64,92129,683
Cash and cash equivalents at end of period$46,507$195,167
Supplemental disclosure of cash flow information:

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

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

Download CSV
September 30, 2017December 31, 2016
ASSETS
Real estate:
Rental properties:
Land and land improvements$2,719,064$2,559,743
Buildings and improvements10,585,74210,116,563
13,304,80612,676,306
Less: accumulated depreciation(2,651,542)(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 September 30,Nine Months Ended September 30,
2017201620172016
Revenues:
Rental and other property$341,974$327,078$1,011,908$958,818
Management and other fees from affiliates2,3952,0936,9276,145
344,369329,1711,018,835964,963
Expenses:
Property operating, excluding real estate taxes66,60663,781193,632185,390

First 8 of 39 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—329,446—11,289—7,646348,381
Reversal of unrealized gains upon the sale of marketable securities————(1,650)—(1,650)
Change in fair value of derivatives and amortization of swap settlements————7,405—7,405
Change in fair value of marketable securities, net————1,966—1,966

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

Table 10 after “(In thousands)”

Download CSV
Nine Months Ended September 30,
20172016
Cash flows from operating activities:
Net income$348,381$233,893
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization350,893329,847
Amortization of discount on marketable securities and other investments(11,128)(10,771)
Amortization of (premium) discount and debt financing costs, net(5,132)(11,432)

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

Table 11 after “10”

Download CSV
Nine Months Ended September 30,
20172016
Common and preferred units and preferred interest distributions paid(349,947)(320,957)
Net cash used in financing activities(245,304)(150,198)
Net (decrease) increase in cash and cash equivalents(18,414)165,484
Cash and cash equivalents at beginning of period64,92129,683
Cash and cash equivalents at end of period$46,507$195,167
Supplemental disclosure of cash flow information:

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

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

Download CSV
September 30, 2017
AmortizedCostGrossUnrealizedGain (Loss)Carrying Value
Available for sale:
Investment-grade unsecured bonds$4,450$(14)$4,436
Investment funds - debt securities28,06714628,213
Investment funds - U.S. treasuries10,910(29)10,881
Common stock and stock funds33,8161,68735,503
Held to maturity:

First 8 of 19 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 reclassification13,5121,90215,414
Amounts reclassified from accumulated other comprehensive loss(6,352)(1,596)(7,948)
Other comprehensive income7,1603067,466
Balance at September 30, 2017$(25,803)$1,171$(24,632)

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 reclassification13,9741,96615,940
Amounts reclassified from accumulated other comprehensive loss(6,569)(1,650)(8,219)
Other comprehensive income7,4053167,721
Balance at September 30, 2017$(22,756)$1,129$(21,627)

Table 15 after “is as follows ($ in thousands):”

Download CSV
Balance at December 31, 2016$44,684
Reclassification due to change in redemption value and other903
Redemptions(5,543)
Balance at September 30, 2017$40,044

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

Download CSV
Weighted Average Essex Ownership PercentageSeptember 30, 2017December 31, 2016
Membership interest/Partnership interest in:
CPPIB54%$502,419$422,068
Wesco I, III, IV, and V50%225,041180,687
Palm Valley (1)50%—68,396
BEXAEW50%45,52347,963
BEX II (2)50%(36,245)19,078
Other53%40,47143,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
September 30, 2017December 31, 2016
Combined balance sheets:
Rental properties and real estate under development$3,671,101$3,807,245
Other assets111,372121,505
Total assets$3,782,473$3,928,750
Debt$1,597,597$1,617,639
Other liabilities65,86574,607
Equity (1)2,119,0112,236,504

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

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

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
2017201620172016
Combined statements of income:
Property revenues$76,303$72,124$224,319$216,434
Property operating expenses(27,753)(24,976)(79,028)(75,377)
Net operating income48,55047,148145,291141,057
Gain on sale of real estate10,058—10,05828,291
Interest expense(13,718)(10,978)(39,663)(35,260)

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

Table 19 after “($ in thousands):”

Download CSV
September 30, 2017December 31, 2016
Notes receivable, secured, bearing interest at 10.00%, due May 2021$13,416$—
Notes receivable, secured, bearing interest at 10.75%, due September 202028,53217,685
Related party note receivable, secured, bearing interest at 9.50%, due October 2019(1)6,5996,593
Related party note receivable, secured, bearing interest at 3.50%, due December 2017(1)55,000—
Notes and other receivables from affiliates (2)3,9814,695
Other receivables14,02911,997
Total notes and other receivables$121,557$40,970

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

Download CSV
September 30, 2017December 31, 2016Weighted AverageMaturityIn Years
Unsecured bonds private placement - fixed rate$274,378$314,1903.3
Term loan - variable rate348,45798,1894.4
Bonds public offering - fixed rate2,878,3112,834,4006.7
Unsecured debt, net (1)3,501,1463,246,779
Lines of credit (2)2,609125,000
Mortgage notes payable, net (3)2,111,4672,191,4815.4
Total debt, net$5,615,222$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$7,719
2018257,108
2019661,318
2020694,887
2021544,810
Thereafter3,439,209
Total$5,605,051

Table 22 after “($ in thousands):”

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
2017201620172016
Revenues:
Southern California$150,413$142,112$445,296$417,114
Northern California127,673115,318377,531338,761
Seattle Metro58,28555,543171,564161,192
Other real estate assets5,60314,10517,51741,751
Total property revenues$341,974$327,078$1,011,908$958,818

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

Table 23 after “($ in thousands):”

Download CSV
September 30, 2017December 31, 2016
Assets:
Southern California$4,822,941$4,924,792
Northern California4,241,4603,791,549
Seattle Metro1,532,7841,570,340
Other real estate assets56,07978,079
Net reportable operating segment - real estate assets10,653,26410,364,760
Real estate under development313,825190,505

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

Table 24 after “Essex Property Trust, Inc.”

Download CSV
Three Months Ended September 30, 2017Three Months Ended September 30, 2016
IncomeWeighted-averageCommonSharesPerCommonShareAmountIncomeWeighted-averageCommonSharesPerCommonShareAmount
Basic:
Net income available to common stockholders$79,72365,994,896$1.21$65,56165,507,669$1.00
Effect of Dilutive Securities:
Stock options—83,387—109,882
Diluted:
Net income available to common stockholders$79,72366,078,283$1.21$65,56165,617,551$1.00

Table 25 after “(Unaudited)”

Download CSV
Nine Months Ended September 30, 2017Nine Months Ended September 30, 2016
IncomeWeighted-averageCommonSharesPerCommonShareAmountIncomeWeighted-averageCommonSharesPerCommonShareAmount
Basic:
Net income available to common stockholders$329,44665,759,450$5.01$215,55565,455,004$3.29
Effect of Dilutive Securities:
Stock options—77,515—123,657
Diluted:
Net income available to common stockholders$329,44665,836,965$5.00$215,55565,578,661$3.29

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

Download CSV
Three Months Ended September 30, 2017Three Months Ended September 30, 2016
IncomeWeighted-averageCommon UnitsPerCommonUnitAmountIncomeWeighted-averageCommon UnitsPerCommonUnitAmount
Basic:
Net income available to common unitholders$82,44468,246,008$1.21$67,78467,728,621$1.00
Effect of Dilutive Securities:
Stock options—83,387—109,882
Diluted:
Net income available to common unitholders$82,44468,329,395$1.21$67,78467,838,503$1.00

Table 27 after “(Unaudited)”

Download CSV
Nine Months Ended September 30, 2017Nine Months Ended September 30, 2016
IncomeWeighted-averageCommon UnitsPerCommonUnitAmountIncomeWeighted-averageCommon UnitsPerCommonUnitAmount
Basic:
Net income available to common unitholders$340,73568,011,123$5.01$223,01267,679,240$3.30
Effect of Dilutive Securities:
Stock options—77,515—123,657
Diluted:
Net income available to common unitholders$340,73568,088,638$5.00$223,01267,802,897$3.29

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

Download CSV
As of September 30, 2017As of September 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 September 30,
20172016
Southern California96.8%96.7%
Northern California96.9%96.5%
Seattle Metro96.2%96.1%

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 September 30,DollarPercentage
Property Revenues ($ in thousands)Homes20172016ChangeChange
Same-Property Revenues:
Southern California21,998$141,203$136,368$4,8353.5%
Northern California13,892109,820108,1561,6641.5%
Seattle Metro10,23858,28555,5452,7404.9%
Total Same-Property Revenues46,128309,308300,0699,2393.1%
Non-Same Property Revenues32,66627,0095,65720.9%

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

Table 31 after “is as follows:”

Download CSV
Nine Months Ended September 30,
20172016
Southern California96.5%96.2%
Northern California96.8%96.2%
Seattle Metro96.3%95.9%

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

Download CSV
Number of ApartmentNine Months Ended September 30,DollarPercentage
Property Revenues ($ in thousands)Homes20172016ChangeChange
Same-Property Revenues:
Southern California21,998$417,651$401,321$16,3304.1%
Northern California13,892326,880318,4988,3822.6%
Seattle Metro10,238171,564161,19310,3716.4%
Total Same-Property Revenues46,128916,095881,01235,0834.0%
Non-Same Property Revenues95,81377,80618,00723.1%

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

Table 33 after “Essex Property Trust, Inc.”

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
2017201620172016
Net income available to common stockholders$79,723$65,561$329,446$215,555
Adjustments:
Depreciation and amortization117,451110,467350,893329,847
Gains not included in Funds from Operations attributable to common stockholders and unitholders(10,307)—(125,122)(33,304)
Deferred tax expense on sale of real estate and land - taxable REIT subsidiary activity———4,279
Depreciation and amortization add back from unconsolidated co-investments13,85412,85740,33537,337

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

Table 34 after “assets. The Company defines Same-Property NOI as Same-Property revenue less Same-Property operating expenses, including property taxes. Plea”

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
2017201620172016
Earnings from operations$112,669$109,412$334,147$315,280
Adjustments:
Depreciation and amortization117,451110,467350,893329,847
Management and other fees from affiliates(2,395)(2,093)(6,927)(6,145)
General and administrative9,7889,64730,72628,527
Acquisition and investment related costs3242841,1541,379

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$175,0002022$3,814$7,389$214
Interest rate caps20,6742018-2019———
Total cash flow hedges$195,6742018-2022$3,814$7,389$214

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$7,590256,567660,726694,241544,1032,810,732$4,973,959$5,102,418
Average interest rate4.5%5.7%4.2%4.8%4.3%3.6%4.0%
Variable rate debt (1)$2,738541592646707628,477(2) (3)$633,701$629,127
Average interest rate1.9%1.9%1.9%1.9%1.9%2.1%2.1%

Table 37 after “Item 6: Exhibits”

Download CSV
A. Exhibits
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.
32.2Certification of Angela L. Kleiman, Chief Financial Officer, pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.

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