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.

42 tables with numbers, filed Aug 3, 2018. 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, 2018 and December 31, 20172
Condensed Consolidated Statements of Income and Comprehensive Income for the three and six months ended June 30, 2018 and 20173
Condensed Consolidated Statement of Equity for the six months ended June 30, 20184
Condensed Consolidated Statements of Cash Flows for the six months ended June 30, 2018 and 20175
Condensed Consolidated Financial Statements of Essex Portfolio, L.P. (Unaudited)
Condensed Consolidated Balance Sheets as of June 30, 2018 and December 31, 20177

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

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

Download CSV
ASSETSJune 30, 2018December 31, 2017
Real estate:
Rental properties:
Land and land improvements$2,710,139$2,719,064
Buildings and improvements10,693,68210,639,108
13,403,82113,358,172
Less: accumulated depreciation(2,992,819)(2,769,297)
10,411,00210,588,875

First 8 of 38 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,
2018201720182017
Revenues:
Rental and other property$346,526$336,766$691,473$669,934
Management and other fees from affiliates2,1972,2964,5054,532
348,723339,062695,978674,466
Expenses:
Property operating, excluding real estate taxes58,15655,859115,406111,995

First 8 of 35 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, 201766,054$7$7,129,571$(833,726)$(18,446)$119,419$6,396,825
Net income———191,358—11,691203,049
Reversal of unrealized losses upon the sale of marketable debt securities————2—2
Change in fair value of derivatives and amortization of swap settlements————9,3353219,656
Change in fair value of marketable debt securities, net————(95)(4)(99)
Issuance of common stock under:

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

Table 5 after “(In thousands)”

Download CSV
Six Months Ended June 30,
20182017
Cash flows from operating activities:
Net income$203,049$263,346
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization238,435233,442
Amortization of discount on marketable securities(8,469)(7,270)
Amortization of (premium) discount and debt financing costs, net(1,352)(4,317)

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

Table 6 after “5”

Download CSV
Six Months Ended June 30,
20182017
Redemption of redeemable noncontrolling interest(43)(720)
Common and preferred stock dividends paid(238,454)(219,618)
Net cash used in financing activities(248,063)(79,311)
Net increase (decrease) in unrestricted and restricted cash and cash equivalents116,45029,574
Unrestricted and restricted cash and cash equivalents at beginning of period61,126170,302
Unrestricted and restricted cash and cash equivalents at end of period$177,576$199,876

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

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

Download CSV
June 30, 2018December 31, 2017
ASSETS
Real estate:
Rental properties:
Land and land improvements$2,710,139$2,719,064
Buildings and improvements10,693,68210,639,108
13,403,82113,358,172
Less: accumulated depreciation(2,992,819)(2,769,297)

First 8 of 41 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,
2018201720182017
Revenues:
Rental and other property$346,526$336,766$691,473$669,934
Management and other fees from affiliates2,1972,2964,5054,532
348,723339,062695,978674,466
Expenses:
Property operating, excluding real estate taxes58,15655,859115,406111,995

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

Table 9 after “(In thousands)”

Download CSV
General PartnerLimited PartnersAccumulated other comprehensive loss
Common EquityCommon EquityNoncontrolling Interest
UnitsAmountUnitsAmountTotal
Balances at December 31, 201766,054$6,295,8522,268$49,792$(15,229)$66,410$6,396,825
Net income—191,358—6,592—5,099203,049
Reversal of unrealized losses upon the sale of marketable debt securities————2—2
Change in fair value of derivatives and amortization of swap settlements————9,656—9,656
Change in fair value of marketable debt securities, net————(99)—(99)

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

Table 10 after “(In thousands)”

Download CSV
Six Months Ended June 30,
20182017
Cash flows from operating activities:
Net income$203,049$263,346
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization238,435233,442
Amortization of discount on marketable securities(8,469)(7,270)
Amortization of (premium) discount and debt financing costs, net(1,352)(4,317)

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

Table 11 after “10”

Download CSV
Six Months Ended June 30,
20182017
Redemption of redeemable noncontrolling interest(43)(720)
Common and preferred units and preferred interest distributions paid(249,060)(230,389)
Net cash used in financing activities(248,063)(79,311)
Net increase (decrease) in unrestricted and restricted cash and cash equivalents116,45029,574
Unrestricted and restricted cash and cash equivalents at beginning of period61,126170,302
Unrestricted and restricted cash and cash equivalents at end of period$177,576$199,876

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

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

Download CSV
June 30, 2018
AmortizedCostGrossUnrealizedGain (Loss)Carrying Value
Equity securities:
Investment funds - debt securities$31,852$(371)$31,481
Investment funds - U.S. treasuries11,250(85)11,165
Common stock and stock funds39,6802,59142,271
Debt securities:
Available for sale

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

Table 13 after “(Unaudited)”

Download CSV
December 31, 2017
AmortizedCostGrossUnrealizedGain (Loss)Carrying Value
Equity securities:
Investment funds - debt securities$27,914$(29)$27,885
Investment funds - U.S. treasuries10,999(55)10,944
Common stock and stock funds34,3292,97337,302
Debt securities:
Available for sale

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

Table 14 after “($ in thousands):”

Download CSV
Change in fairvalue and amortizationof swap settlementsUnrealizedgains/(losses) onavailable for sale securitiesTotal
Balance at December 31, 2017$(20,641)$2,195$(18,446)
Cumulative effect upon adoption of ASU 2016-01—(2,234)(2,234)
Other comprehensive income before reclassification13,263(95)13,168
Amounts reclassified from accumulated other comprehensive loss(3,928)2(3,926)
Other comprehensive income9,335(2,327)7,008
Balance at June 30, 2018$(11,306)$(132)$(11,438)

Table 15 after “($ in thousands):”

Download CSV
Change in fairvalue and amortizationof swap settlementsUnrealizedgains/(losses) onavailable for sale securitiesTotal
Balance at December 31, 2017$(17,417)$2,188$(15,229)
Cumulative effect upon adoption of ASU 2016-01—(2,228)(2,228)
Other comprehensive income before reclassification13,719(99)13,620
Amounts reclassified from accumulated other comprehensive loss(4,063)2(4,061)
Other comprehensive income9,656(2,325)7,331
Balance at June 30, 2018$(7,761)$(137)$(7,898)

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

Download CSV
Balance at December 31, 2017$39,206
Reclassification due to change in redemption value and other1,845
Redemptions(4,794)
Balance at June 30, 2018$36,257

Table 17 after “The following table provides a reconciliation of cash, cash equivalents, and restricted cash reported within the condensed consolidated bala”

Download CSV
June 30, 2018December 31, 2017June 30, 2017December 31, 2016
Cash and cash equivalents - unrestricted$160,902$44,620$183,885$64,921
Cash and cash equivalents - restricted16,67416,50615,991105,381
Total unrestricted and restricted cash and cash equivalents shown in the condensed consolidated statement of cash flows$177,576$61,126$199,876$170,302

Table 18 after “The following table presents the Company’s revenues disaggregated by revenue source ($ in thousands):”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Rental$323,020$314,546$644,681$624,668
Other property leasing revenue23,50622,22046,79245,266
Management and other fees from affiliates2,1972,2964,5054,532
Total revenues$348,723$339,062$695,978$674,466

Table 19 after “The following table presents the Company’s rental and other property-related revenues disaggregated by geographic operating segment ($ in th”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Southern California$150,431$145,600300,200290,504
Northern California129,590126,550258,212249,858
Seattle Metro58,79557,087117,509113,279
Other real estate assets (1)7,7107,52915,55216,293
Total rental and other property leasing revenues$346,526$336,766$691,473$669,934

Table 20 after “The following table presents the Company’s rental and other property-related revenues disaggregated by current property category status ($ i”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Same-property (1)$321,283$312,629$641,378$622,460
Acquisitions (2)10,50110,17020,88418,356
Development (3)450—469—
Redevelopment5,0364,90910,0609,723
Non-residential/other, net (4)9,2569,05818,68219,395
Total rental and other property revenues$346,526$336,766$691,473$669,934

Table 21 after “are as follows ($ in thousands, except parenthetical amounts):”

Download CSV
Weighted Average Company Ownership Percentage (1)June 30, 2018December 31, 2017
Ownership interest in:
CPPIB54%$492,382$500,287
Wesco I, Wesco III, Wesco IV, and Wesco V53%211,574214,408
BEXAEW, BEX II and BEX III (2)50%120,78813,827
Other52%47,36751,810
Total operating and other co-investments, net872,111780,332
Total development co-investments, net50%76,52573,770

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

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

Download CSV
June 30, 2018December 31, 2017
Combined balance sheets: (1)
Rental properties and real estate under development$4,032,421$3,722,778
Other assets166,521110,333
Total assets$4,198,942$3,833,111
Debt$1,948,724$1,705,051
Other liabilities64,98245,515
Equity2,185,2362,082,545

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

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

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Combined statements of income: (1)
Property revenues$81,348$72,111$162,190$148,016
Property operating expenses(26,567)(25,866)(53,636)(51,275)
Net operating income54,78146,245108,55496,741
Interest expense(13,639)(14,024)(30,374)(25,945)
General and administrative(2,388)(1,917)(3,880)(3,695)

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

Table 24 after “($ in thousands):”

Download CSV
June 30, 2018December 31, 2017
Notes receivable, bearing interest at 10.00%, due May 2021$14,470$13,762
Notes receivable, bearing interest at 10.75%, due September 202030,92629,318
Related party note receivable, bearing interest at 9.50%, due October 2019(1)6,6106,656
Related party note receivable, bearing interest at 3.50%, due March 2018(1)—29,500
Notes and other receivables from affiliates (2)4,2345,061
Other receivables12,14616,629
Total notes and other receivables$68,386$100,926

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

Download CSV
June 30, 2018December 31, 2017Weighted AverageMaturityIn Years as of June 30, 2018
Unsecured bonds private placement - fixed rate$274,525$274,4272.6
Term loan - variable rate348,621348,5453.6
Bonds public offering - fixed rate3,174,9512,878,7378.2
Unsecured debt, net (1)3,798,0973,501,709
Lines of credit (2)2,670179,000
Mortgage notes payable, net (3)1,890,3262,008,4175.1
Total debt, net$5,691,093$5,689,126

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

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

Download CSV
Remaining in 2018$119,779
2019606,843
2020694,921
2021544,846
2022692,466
Thereafter3,035,808
Total$5,694,663

Table 27 after “($ in thousands):”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Revenues:
Southern California$150,431$145,600$300,200$290,504
Northern California129,590126,550258,212249,858
Seattle Metro58,79557,087117,509113,279
Other real estate assets7,7107,52915,55216,293
Total property revenues$346,526$336,766$691,473$669,934

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

Table 28 after “($ in thousands):”

Download CSV
June 30, 2018December 31, 2017
Assets:
Southern California$4,601,755$4,685,358
Northern California4,253,3974,219,114
Seattle Metro1,495,3881,521,907
Other real estate assets60,462162,496
Net reportable operating segment - real estate assets10,411,00210,588,875
Real estate under development343,841355,735

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

Table 29 after “Essex Property Trust, Inc.”

Download CSV
Three Months Ended June 30, 2018Three Months Ended June 30, 2017
IncomeWeighted-averageCommonSharesPerCommonShareAmountIncomeWeighted-averageCommonSharesPerCommonShareAmount
Basic:
Net income available to common stockholders$100,44066,047,751$1.52$70,75965,729,074$1.08
Effect of Dilutive Securities:
Stock options—48,598—90,620
Diluted:
Net income available to common stockholders$100,44066,096,349$1.52$70,75965,819,694$1.08

Table 30 after “(Unaudited)”

Download CSV
Six Months Ended June 30, 2018Six Months Ended June 30, 2017
IncomeWeighted-averageCommonSharesPerCommonShareAmountIncomeWeighted-averageCommonSharesPerCommonShareAmount
Basic:
Net income available to common stockholders$191,35866,045,897$2.90$249,72365,639,775$3.80
Effect of Dilutive Securities:
Stock options—42,906—91,515
DownREIT units——738210,728
Diluted:

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

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

Download CSV
Three Months Ended June 30, 2018Three Months Ended June 30, 2017
IncomeWeighted-averageCommon UnitsPerCommonUnitAmountIncomeWeighted-averageCommon UnitsPerCommonUnitAmount
Basic:
Net income available to common unitholders$103,90068,320,849$1.52$73,18167,980,761$1.08
Effect of Dilutive Securities:
Stock options—48,598—90,620
Diluted:
Net income available to common unitholders$103,90068,369,447$1.52$73,18168,071,381$1.08

Table 32 after “(Unaudited)”

Download CSV
Six Months Ended June 30, 2018Six Months Ended June 30, 2017
IncomeWeighted-averageCommon UnitsPerCommonUnitAmountIncomeWeighted-averageCommon UnitsPerCommonUnitAmount
Basic:
Net income available to common unitholders$197,95068,319,151$2.90$258,29167,891,734$3.80
Effect of Dilutive Securities:
Stock options—42,906—91,515
DownREIT units——738210,728
Diluted:

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

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

Download CSV
As of June 30, 2018As of June 30, 2017
Apartment Homes%Apartment Homes%
Southern California22,96447%23,34347%
Northern California15,97032%15,84832%
Seattle Metro10,23821%10,23821%
Total49,172100%49,429100%

Table 34 after “is as follows:”

Download CSV
Three Months Ended June 30,
20182017
Southern California96.8%96.2%
Northern California96.7%96.7%
Seattle Metro96.3%96.2%

Table 35 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)Homes20182017ChangeChange
Same-Property Revenues:
Southern California22,269$145,799$141,110$4,6893.3%
Northern California14,356116,688114,4332,2552.0%
Seattle Metro10,23858,79657,0861,7103.0%
Total Same-Property Revenues46,863321,283312,6298,6542.8%
Non-Same Property Revenues25,24324,1371,1064.6%

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

Table 36 after “is as follows:”

Download CSV
Six Months Ended June 30,
20182017
Southern California96.9%96.3%
Northern California97.1%96.7%
Seattle Metro96.6%96.4%

Table 37 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)Homes20182017ChangeChange
Same-Property Revenues:
Southern California22,269$290,927$281,576$9,3513.3%
Northern California14,356232,942227,6055,3372.3%
Seattle Metro10,238117,509113,2794,2303.7%
Total Same-Property Revenues46,863641,378622,46018,9183.0%
Non-Same Property Revenues50,09547,4742,6215.5%

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

Table 38 after “Essex Property Trust, Inc.”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Net income available to common stockholders$100,440$70,759$191,358$249,723
Adjustments:
Depreciation and amortization119,330117,939238,435233,442
Gains not included in Funds from Operations attributable to common stockholders and unitholders(22,244)(2,159)(22,244)(114,815)
Depreciation and amortization add back from unconsolidated co-investments15,72013,62731,57926,481
Noncontrolling interest related to Operating Partnership units3,4602,4226,5928,568

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

Table 39 after “the value of a real estate asset or group of assets. The Company defines Same-Property NOI as Same-Property revenue less Same-Property opera”

Download CSV
Three Months Ended June 30,Six Months Ended June 30,
2018201720182017
Earnings from operations$116,272$112,247$226,819$221,478
Adjustments:
Corporate-level property management expenses7,7827,52215,55215,031
Depreciation and amortization119,330117,939238,435233,442
Management and other fees from affiliates(2,197)(2,296)(4,505)(4,532)
General and administrative11,12510,33725,93820,938

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

Table 40 after “.”

Download CSV
Carrying andEstimated Carrying Value
NotionalMaturityEstimated50-50
($ in thousands)AmountDate RangeFair ValueBasis PointsBasis Points
Cash flow hedges:
Interest rate swaps$175,0002022$8,473$11,378$5,602
Interest rate caps9,9242019———
Total cash flow hedges$184,9242019-2022$8,473$11,378$5,602

Table 41 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 Ended20182019202020212022ThereafterTotalFair value
($ in thousands, except for interest rates)
Fixed rate debt$119,502606,251694,273544,138341,6922,768,858$5,074,714$5,055,937
Average interest rate5.8%4.4%5.0%4.5%3.8%3.8%4.2%
Variable rate debt (1)$2775923,318708350,774266,950$622,619$618,156
Average interest rate2.5%2.5%2.7%2.5%2.8%2.3%2.6%

Table 42 after “Item 6: Exhibits”

Download CSV
A. Exhibits
10.1†Form of Non-Employee Director Restricted Stock Award Agreement
10.2†Form of Non-Employee Director Stock Option Award Agreement
12.1*Ratio of Earnings to Fixed Charges.
31.1*Certification of Michael J. Schall, Chief Executive Officer, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
31.2*Certification of Angela L. Kleiman, Chief Financial Officer, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
31.3*Certification of Michael J. Schall, Principal Executive Officer of General Partner, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.
31.4*Certification of Angela L. Kleiman, Principal Financial Officer of General Partner, pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.

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