Allegion Financials

$548.8 M

Revenue Q1, 2017

$7.9 B

Mkt cap, 31-Oct-2017
Gross profit (Q1, 2017)240.8 M
Gross profit margin (Q1, 2017), %44%
Net income (Q1, 2017)68.7 M
EBIT (Q1, 2017)98.8 M
Closing share price, 31-Oct-201782
Cash, 31-Mar-2017189.6 M

Market Value

Revenue/Financials

Income Statement

Annual

USDFY, 2014FY, 2015FY, 2016

Revenue

2.1 b2.1 b2.2 b

Revenue growth, %

(2%)8%

General and administrative expense

527.4 m510.5 m559.8 m

Operating expense total

527.4 m510.5 m559.8 m

EBIT

326.3 m358.6 m425.5 m

EBIT margin, %

15%17%19%

Interest expense

53.8 m52.9 m64.3 m

Net Income

172.6 m154.3 m231.2 m

Quarterly

USDQ2, 2014Q3, 2014Q1, 2015Q2, 2015Q3, 2015Q1, 2016Q2, 2016Q3, 2016Q1, 2017

Revenue

531.5 m546.7 m458.7 m519.5 m544.5 m502.3 m584.9 m581.1 m548.8 m

Cost of goods sold

305.2 m310.6 m271.6 m297.7 m304.5 m286 m317.5 m317.6 m308 m

Gross profit

226.3 m236.1 m187.1 m221.8 m240 m216.3 m267.4 m263.5 m240.8 m

Gross profit Margin, %

43%43%41%43%44%43%46%45%44%

General and administrative expense

136.6 m130.5 m116.1 m126.1 m129.6 m133.8 m143.1 m142 m142 m

Operating expense total

136.6 m130.5 m116.1 m126.1 m129.6 m133.8 m143.1 m142 m142 m

EBIT

89.7 m105.6 m71 m95.7 m110.4 m82.5 m124.3 m121.5 m98.8 m

EBIT margin, %

17%19%15%18%20%16%21%21%18%

Interest expense

12.5 m12.7 m11.6 m11.3 m13.7 m16.3 m16.5 m15.6 m15.9 m

Pre tax profit

78.2 m56.3 m84 m75 m116.4 m82.3 m

Income tax expense

(23.1 m)(27.2 m)(12.4 m)(19 m)(19.4 m)(16.2 m)(21 m)(19.1 m)(13.6 m)

Net Income

47 m65.6 m43.7 m65 m(26.4 m)58.8 m95.4 m2 m68.7 m

Balance Sheet

Annual

USDFY, 2014FY, 2015FY, 2016

Cash

290.5 m199.7 m312.4 m

Accounts Receivable

13.7 m20.3 m

Inventories

49.2 m220.6 m

Current Assets

973.8 m735.1 m829.3 m

PP&E

211.2 m224.8 m226.6 m

Goodwill

506 m714.1 m716.8 m

Total Assets

2 b2.3 b2.2 b

Accounts Payable

1.4 m79.3 m179.9 m

Current Liabilities

531.3 m447.1 m429.6 m

Long-term debt

1.2 b1.5 b1.4 b

Total Debt

1.4 b

Total Liabilities

2.1 b

Additional Paid-in Capital

24.4 m

Retained Earnings

142.4 m232.4 m376.6 m

Total Equity

18.5 m29.7 m116.4 m

Debt to Equity Ratio

12.2 x

Debt to Assets Ratio

0.6 x

Financial Leverage

109 x76.9 x19.3 x

Quarterly

USDQ2, 2014Q3, 2014Q1, 2015Q2, 2015Q3, 2015Q1, 2016Q2, 2016Q3, 2016Q1, 2017

Cash

193.2 m251.4 m229.6 m201 m175.2 m125.5 m169.1 m214.5 m189.6 m

Inventories

174.1 m180.7 m184.9 m205.9 m216.3 m216.5 m225.3 m228.3 m238 m

Current Assets

887.6 m934 m903.7 m923.2 m875.7 m710.4 m827.9 m802.3 m742.2 m

PP&E

210.3 m212.5 m206.3 m207.8 m227.9 m226.1 m227.1 m226.4 m232.1 m

Goodwill

517.8 m509.9 m498.6 m527.5 m823.4 m727.2 m728.8 m736.1 m724.6 m

Total Assets

2 b2 b1.9 b2 b2.4 b2.3 b2.3 b2.3 b2.2 b

Accounts Payable

219.8 m222.9 m231.5 m233.8 m180.2 m162.3 m175.7 m165.1 m173.1 m

Current Liabilities

437.4 m464.2 m482.1 m479 m517.2 m406.1 m469.7 m432.3 m398.5 m

Long-term debt

1.3 b1.2 b1.2 b1.2 b1.6 b1.4 b1.4 b1.4 b1.4 b

Additional Paid-in Capital

5.6 m2.6 m5.1 m12.3 m17.9 m1.1 m8.8 m16.9 m

Retained Earnings

55.5 m95.4 m152.8 m207.1 m170.2 m277.3 m360.6 m350.7 m401.8 m

Total Equity

(11.2 m)6 m1.5 m72.7 m28 m77.7 m142.8 m155.5 m155 m

Financial Leverage

-175.7 x332 x1284.9 x27.4 x86 x29.2 x16.4 x14.8 x14.1 x

Cash Flow

Annual

USDFY, 2014FY, 2015FY, 2016

Net Income

172.6 m154.3 m231.2 m

Depreciation and Amortization

48.8 m53.2 m66.9 m

Accounts Receivable

7.4 m(6.6 m)

Inventories

22.1 m(15.6 m)

Accounts Payable

(12.9 m)3.4 m

Cash From Operating Activities

255.9 m257 m377.5 m

Capital Expenditures

(51.5 m)(35.2 m)(42.5 m)

Cash From Investing Activities

(34.8 m)(533.8 m)(64 m)

Long-term Borrowings

(1 b)(440.5 m)(47 m)

Free Cash Flow

204.4 m221.8 m335 m

Quarterly

USDQ2, 2014Q3, 2014Q1, 2015Q2, 2015Q3, 2015Q1, 2016Q2, 2016Q3, 2016Q1, 2017

Net Income

47 m65.6 m43.7 m65 m(26.4 m)58.8 m95.4 m2 m68.7 m

Inventories

205.9 m216.3 m216.5 m225.3 m228.3 m238 m

Accounts Payable

233.8 m180.2 m162.3 m175.7 m165.1 m173.1 m

Ratios

USDY, 2017

Revenue/Employee

58.4 k

Financial Leverage

14.1 x