Tables

Tables in the 10-Q of Allegion plc

55 tables with numbers, filed Apr 25, 2019. Each one downloads as an Excel file or a CSV (numbers are stored as numbers), 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 ↗

PART I FINANCIAL INFORMATION	1
Item 1 -	Financial Statements	1
	Condensed and Consolidated Statements of Comprehensive Income for the three months ended March 31, 2019 and 2018 (Unaudited)	1
	Condensed and Consolidated Balance Sheets at March 31, 2019 and December 31, 2018 (Unaudited)	2
	Condensed and Consolidated Statements of Cash Flows for the three months ended March 31, 2019 and 2018 (Unaudited)	3
	Notes to Condensed and Consolidated Financial Statements (Unaudited)	4
Item 2 -	Management’s Discussion and Analysis of Financial Condition and Results of Operations	30
Item 3 -	Quantitative and Qualitative Disclosures about Market Risk	40

	Three months ended
	March 31,
In millions, except per share amounts	2019	2018
Net revenues	$655.0		$613.1
Cost of goods sold	378.1		355.3
Selling and administrative expenses	168.9		159.1
Operating income	108.0		98.7
Interest expense	13.7		12.9

In millions	March 31, 2019	December 31, 2018
ASSETS
Current assets:
Cash and cash equivalents	$153.8		$283.8
Restricted cash	6.8		6.8
Accounts and notes receivable, net	359.6		324.9
Inventories	296.8		280.3
Other current assets	33.2		35.8

In millions	Americas	EMEIA		Asia Pacific	Total
December 31, 2018 (gross)	$486.1		$767.1		$115.3	$1,368.5
Accumulated impairment	—		(478.6)		(6.9)	(485.5)
December 31, 2018 (net)	486.1		288.5		108.4	883.0
Acquisitions and adjustments(a)	0.7		3.7		(4.4)	—
Currency translation	0.1		(5.6)		1.2	(4.3)
March 31, 2019 (net)	$486.9		$286.6		$105.2	$878.7

Business	Date
Technical Glass Products, Inc. ("TGP")	January 2018
Hammond Enterprises, Inc. ("Hammond")	January 2018
Qatar Metal Industries LLC ("QMI")	February 2018
AD Systems, Inc. ("AD Systems")	March 2018
Gainsborough Hardware and API Locksmiths ("Door and Access Systems")	July 2018
ISONAS Security Systems, Inc. ("ISONAS")	July 2018

In millions
Accounts receivable, net	$28.9
Inventories	28.5
Other current assets	1.3
Property, plant and equipment, net	27.6
Goodwill	141.8
Intangible assets, net	204.3
Other noncurrent assets	—

		Designated as hedge instruments	Not designated as hedge instruments
In millions	Balance Sheet classification	March 31, 2019	December 31, 2018		March 31, 2019	December 31, 2018
Asset derivatives
Currency derivatives	Other current assets	$0.5		$1.7		$0.5	$0.4
Interest rate swaps	Other noncurrent assets	4.1		5.7		—	—
Total asset derivatives		4.6		7.4		0.5	0.4
Liability derivatives
Currency derivatives	Accrued expenses and other current liabilities	0.1		—		0.7	0.1

	Amount of gain (loss) recognized in Accumulated other comprehensive loss	Location of gain recognized in Net earnings		Amount of gain reclassified from Accumulated other comprehensive loss and recognized into Net earnings
In millions	2019	2018			2019		2018
Currency derivatives	$0.6		$1.8			Cost of goods sold		$2.0	$0.6
Interest rate swaps	(0.7)		2.3			Interest expense		0.9	0.2
Total	$(0.1)		$4.1					$2.9	$0.8

In millions	Balance Sheet classification		Real estate	Equipment		Total
ROU asset	Other noncurrent assets		$59.5		$22.9		$82.4
Lease liability - current	Accrued expenses and other current liabilities		15.1		12.0		27.1
Lease liability - noncurrent	Other noncurrent liabilities		44.4		10.9		55.3
Other information:
Weighted-average remaining term (years)		6.8		2.2
Weighted-average discount rate		4.6%		4.1%

In millions	Remainder of 2019	2020		2021	2022	2023		Thereafter	Total
Real estate leases	$13.5		$14.3		$11.2		$8.7		$5.1	$17.4	$70.2
Equipment leases	10.2		8.4		4.0		1.0		0.3	—	23.9
Total	$23.7		$22.7		$15.2		$9.7		$5.4	$17.4	$94.1

In millions	March 31, 2019	December 31, 2018
Raw materials	$124.7		$117.2
Work-in-process	36.8		34.4
Finished goods	135.3		128.7
Total	$296.8		$280.3

	March 31, 2019	December 31, 2018
In millions	Gross carrying amount	Accumulated amortization		Net carrying amount		Gross carrying amount	Accumulated amortization		Net carrying amount
Completed technologies/patents	$59.0		$(15.3)			$43.7		$59.4		$(14.2)		$45.2
Customer relationships	413.2		(92.0)			321.2		419.3		(88.5)		330.8
Trade names (finite-lived)	83.0		(47.2)			35.8		84.9		(47.4)		37.5
Other	12.9		(6.8)			6.1		9.5		(6.5)		3.0
Total finite-lived intangible assets	568.1		$(161.3)			406.8		573.1		$(156.6)		416.5
Trade names (indefinite-lived)	129.5				129.5		130.6				130.6

In millions	March 31, 2019	December 31, 2018
Term Facility	$647.5		$656.3
Revolving Facility	—		—
3.200% Senior Notes due 2024	400.0		400.0
3.550% Senior Notes due 2027	400.0		400.0
Other debt	0.9		1.2
Total borrowings outstanding	1,448.4		1,457.5
Less discounts and debt issuance costs, net	(12.0)		(12.7)

In millions	Real estate	Equipment		Total
Cash paid for amounts included in the measurement of lease liabilities	$4.6		$4.0		$8.6
ROU assets obtained in exchange for new lease liabilities	3.1		1.6		4.7

	U.S.
In millions	2019	2018
Service cost	$1.5		$1.7
Interest cost	2.9		2.6
Expected return on plan assets	(3.2)		(3.7)
Administrative costs and other	0.4		0.5
Net amortization of:
Prior service costs	0.1		0.1

	Non-U.S.
In millions	2019	2018
Service cost	$0.4		$0.6
Interest cost	2.2		2.1
Expected return on plan assets	(3.2)		(3.9)
Administrative costs and other	0.3		0.4
Net amortization of:
Prior service costs	0.1		—

	Fair value measurements	Total fair value
In millions	Quoted prices in active markets for identical assets (Level 1)	Significant other observable inputs (Level 2)		Significant unobservable inputs (Level 3)
Recurring fair value measurements
Assets:
Investments	$—		$15.9		$—	$15.9
Interest rate swaps	—		4.1		—	4.1
Foreign currency contracts	—		1.0		—	1.0
Total asset recurring fair value measurements	$—		$21.0		$—	$21.0

		Allegion plc shareholders' equity
		Ordinary shares
In millions	Total equity	Amount		Shares	Capital in excess of par value	Retained earnings		Accumulated other comprehensive loss	Noncontrolling interests
Balance at December 31, 2018	$654.0		$0.9		94.6		$—		$873.6	$(223.5)	$3.0
Net earnings	80.3		—		—		—		80.2	—	0.1
Currency translation	(11.4)		—		—		—		—	(12.0)	0.6
Change in value of derivatives qualifying as cash flow hedges, net of tax	(2.2)		—		—		—		—	(2.2)	—
Pension and OPEB adjustments, net of tax	(1.1)		—		—		—		—	(1.1)	—

In millions	Cash flow hedges	Pension and OPEB Items		Foreign Currency Items	Total
December 31, 2018	$6.1		$(123.2)		$(106.4)	$(223.5)
Other comprehensive loss before reclassifications	(0.9)		(1.4)		(12.0)	(14.3)
Amounts reclassified from accumulated other comprehensive loss(a)	(2.0)		1.4		—	(0.6)
Tax benefit (expense)	0.7		(1.1)		—	(0.4)
March 31, 2019	$3.9		$(124.3)		$(118.4)	$(238.8)

	2019	2018
	Number granted	Weighted- average fair value per award		Number granted	Weighted- average fair value per award
Stock options	195,675		$19.58		160,525	$21.29
RSUs	104,566		$88.07		91,374	$86.55

	2019	2018
Dividend yield	1.23%		0.97%
Volatility	21.44%		22.38%
Risk-free rate of return	2.53%		2.75%
Expected life	6.0 years		6.0 years

	Three months ended March 31, 2019
In millions	Americas	EMEIA		Asia Pacific	Consolidated
Net revenues
Products	$475.3		$138.7		$34.7	$648.7
Services	—		4.2		2.1	6.3
Total Net revenues	$475.3		$142.9		$36.8	$655.0

	Three months ended March 31, 2018
In millions	Americas	EMEIA		Asia Pacific	Consolidated
Net revenues
Products	$439.1		$146.8		$23.7	$609.6
Services	—		3.5		—	3.5
Total Net revenues	$439.1		$150.3		$23.7	$613.1

In millions	Allegion plc	Allegion US Holding		Othersubsidiaries	Consolidatingadjustments	Total
Net revenues	$—		$—		$655.0		$—	$655.0
Cost of goods sold	—		—		378.1		—	378.1
Selling and administrative expenses	1.4		—		167.5		—	168.9
Operating (loss) income	(1.4)		—		109.4		—	108.0
Equity earnings (loss) in affiliates, net of tax	89.3		35.2		—		(124.5)	—
Interest expense	7.5		6.1		0.1		—	13.7
Intercompany interest and fees	0.2		26.3		(26.5)		—	—

Tables in the 10-Q of Allegion plc

Table 1 after “INDEX”

Table 2 after “(Unaudited)”

Table 3 after “(Unaudited)”

Table 4 after “(Unaudited)”

Table 5 after “The major classes of inventory were as follows:”

Table 6 after “were as follows:”

Table 7 after “The gross amount of the Company’s intangible assets and related accumulated amortization were as follows:”

Table 8 after “In 2018, the Company completed six acquisitions:”

Table 9 after “The preliminary allocation of the aggregate purchase price to assets acquired and liabilities assumed for the acquisitions listed above is a”

Table 10 after “Long-term debt and other borrowings consisted of the following:”

Table 11 after “The fair values of derivative instruments included within the Condensed and Consolidated Balance Sheets were as follows:”

Table 12 after “were as follows:”

Table 13 after “, were as follows:”

Table 14 after “:”

Table 15 after “Future minimum rental commitments for the subsequent five years under non-cancellable operating leases with terms in excess of one year as o”

Table 16 after “, are as follows:”

Table 17 after “were as follows:”

Table 18 after “were as follows:”

Table 19 after “, were as follows:”

Table 20 after “, were as follows:”

Table 21 after “, were as follows:”

Table 22 after “, were as follows:”

Table 23 after “, were as follows:”

Table 24 after “, were as follows:”

Table 25 after “:”

Table 26 after “were as follows:”

Table 27 after “:”

Table 28 after “, were as follows:”

Table 29 after “were as follows:”

Table 30 after “:”

Table 31 after “, respectively, disaggregated by business segment. Net revenues are shown by tangible product sales and services, as contract terms, conditi”

Table 32 after “(Unaudited)”

Table 33 after “was as follows:”

Table 34 after “were as follows:”

Table 35 after “March 31, 2019”

Table 36 after “March 31, 2018”

Table 37 after “March 31, 2019”

Table 38 after “December 31, 2018”

Table 39 after “March 31, 2019”

Table 40 after “March 31, 2018”

Table 41 after “March 31”

Table 42 after “, which resulted from the following:”

Table 43 after “, due to the following:”

Table 44 after “, were as follows:”

Table 45 after “March 31”

Table 46 after “, due to the following:”

Table 47 after “Table of Contents”

Table 48 after “, due to the following:”

Table 49 after “, due to the following:”

Table 50 after “, due to the following:”

Table 51 after “, due to the following:”

Table 52 after “. For additional details, see the Condensed and Consolidated Statements of Cash Flows in the Condensed and Consolidated Financial Statements”

Table 53 after “Long-term debt consisted of the following:”

Table 54 after “Issuer Purchases of Equity Securities”

Table 55 after “(a) Exhibits”

In millions, except per share amounts	2019	% of revenues		2018		% of revenues
Net revenues	$655.0				$613.1
Cost of goods sold	378.1		57.7%			355.3	58.0%
Selling and administrative expenses	168.9		25.8%			159.1	26.0%
Operating income	108.0		16.5%			98.7	16.1%
Interest expense	13.7				12.9
Other income, net	(1.1)				(0.4)
Earnings before income taxes	95.4				86.2

Pricing	2.1%
Volume	3.7%
Acquisitions	3.3%
Currency exchange rates	(2.3)%
Total	6.8%

In millions	Operating Income	Operating Margin
March 31, 2018	$98.7		16.1%
Pricing and productivity in excess of inflation	5.8		0.6%
Volume / product mix	10.1		1.0%
Restructuring / acquisition expenses	(1.5)		(0.2)%
Currency exchange rates	(2.6)		(0.1)%
Investment spending	(2.2)		(0.3)%
Acquisitions	(0.3)		(0.6)%

Pricing	2.6%
Volume	5.0%
Acquisitions	0.9%
Currency exchange rates	(0.3)%
Total	8.2%

Pricing	0.8%
Volume	0.9%
Acquisitions	0.9%
Currency exchange rates	(7.5)%
Total	(4.9)%

Pricing	(0.4)%
Volume	(1.8)%
Acquisitions	63.2%
Currency exchange rates	(5.7)%
Total	55.3%

In millions	Operating Loss	Operating Margin
March 31, 2018	$(1.5)		(6.3)%
Pricing and productivity in excess of inflation	0.3		1.2%
Volume / product mix	(0.2)		(0.8)%
Currency exchange rates	—		(0.2)%
Investment spending	(0.1)		(0.6)%
Acquisitions	0.2		3.5%
Restructuring / acquisition expenses	(0.2)		(0.9)%

Period	Total number of shares purchased (000s)	Average price paid per share		Total number of shares purchased as part of program (000s)	Approximate dollar value of shares still available to be purchased under the program (000s)
January 1 - January 31	245		81.05		245	$352,827
February 1 - February 28	95		88.88		95	344,357
March 1 - March 31	398		89.12		398	308,920
Total	738		86.41		738	$308,920

Exhibit No.	Description	Method of Filing
3.1	Amended and restated Memorandum and Articles of Association of Allegion plc.	Incorporated by reference to Exhibit 3.1 to the Company's Form 8-K filed with the SEC on June 13, 2016 (File No. 001-35971).
10.1	Form of Restricted Stock Unit Award Agreement. *	Incorporated by reference to Exhibit 10.22 to the Company's Form 10-K filed with the SEC on February 19, 2019 (File No. 001-35971).
10.2	Form of Stock Option Award Agreement. *	Incorporated by reference to Exhibit 10.23 to the Company's Form 10-K filed with the SEC on February 19, 2019 (File No. 001-35971).
10.3	Form of Performance Share Unit Award Agreement. *	Incorporated by reference to Exhibit 10.24 to the Company's Form 10-K filed with the SEC on February 19, 2019 (File No. 001-35971).
31.1	Certification of Chief Executive Officer Pursuant to Rule 13a-14(a) or Rule 15d-14(a), as Adopted Pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.	Filed herewith.
31.2	Certification of Chief Financial Officer Pursuant to Rule 13a-14(a) or Rule 15d-14(a), as Adopted Pursuant to Section 302 of the Sarbanes-Oxley Act of 2002.	Filed herewith.
32.1	Certifications of Chief Executive Officer and Chief Financial Officer Pursuant to Rule 13a-14(b) or Rule 15d-14(b) and 18 U.S.C. Section 1350, as Adopted Pursuant to Section 906 of the Sarbanes-Oxley Act of 2002.	Furnished herewith.