tickdelta
Sign in
Tables

Tables in the 10-Q of TYLER TECHNOLOGIES INC

51 tables with numbers, filed Oct 30, 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 ↗

← Filings of TYL

Table 1 after “(Unaudited)”

Three Months Ended September 30,Nine Months Ended September 30,
2019201820192018
Revenues:
Software licenses and royalties$25,379$22,444$67,847$67,620
Subscriptions75,27258,699216,022160,736
Software services54,99748,199160,841144,812
Maintenance109,83396,215316,674286,188
Appraisal services6,0085,54417,45516,470

First 8 of 29 rows. The download has all of them.

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

September 30, 2019 (unaudited)December 31, 2018
ASSETS
Current assets:
Cash and cash equivalents$161,438$134,279
Accounts receivable (less allowance for doubtful accounts of $4,302 in 2019 and $4,647 in 2018)347,982298,912
Short-term investments32,93144,306
Prepaid expenses24,54433,258
Income tax receivable44,697

First 8 of 40 rows. The download has all of them.

Table 3 after “(Unaudited)”

Nine Months Ended September 30,
20192018
Cash flows from operating activities:
Net income$99,737$115,910
Adjustments to reconcile net income to cash provided by operating activities:
Depreciation and amortization56,54745,627
Share-based compensation expense44,36937,966
Operating lease right-of-use assets - non cash3,979—

First 8 of 34 rows. The download has all of them.

Table 4 after “(Unaudited)”

Common StockAdditionalPaid-inCapitalAccumulated OtherComprehensiveIncome (Loss)RetainedEarningsTreasury StockTotalShareholders'Equity
SharesAmountSharesAmount
Balance at June 30, 201948,148$481$715,920$(46)$830,156(9,582)$(124,881)$1,421,630
Net income————40,390——40,390
Exercise of stock options and vesting of restricted stock units——(38,160)——39678,32340,163
Employee taxes paid for withheld shares upon equity award settlement—————(1)(191)(191)
Stock compensation——14,887————14,887
Issuance of shares pursuant to employee stock purchase plan——(61)——152,7792,718

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

Table 5 after “(Unaudited)”

Common StockAdditionalPaid-inCapitalAccumulated OtherComprehensiveIncome (Loss)RetainedEarningsTreasury StockTotalShareholders'Equity
SharesAmountSharesAmount
Balance at June 30, 201848,148$481$686,782$(46)$701,449(9,517)$(48,377)$1,340,289
Net income————38,924——38,924
Exercise of stock options and vesting of restricted stock units——21,645——3264,57426,219
Stock compensation——14,476————14,476
Issuance of shares pursuant to employee stock purchase plan——2,032——121862,218
Treasury stock purchases————————

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

Table 6 after “(Unaudited)”

Common StockAdditionalPaid-inCapitalAccumulated OtherComprehensiveIncome (Loss)RetainedEarningsTreasury StockTotalShareholders'Equity
SharesAmountSharesAmount
Balance at December 31, 201848,148$481$731,435$(46)$771,925(9,872)$(178,949)$1,324,846
Retained earnings adjustment-adoption of Topic 842 Leases, net of taxes————(1,116)——(1,116)
Net income————99,737——99,737
Exercise of stock options and vesting of restricted stock units——(82,449)——746144,74462,295
Employee taxes paid for withheld shares for taxes upon equity award—————(17)(3,572)(3,572)
Stock compensation——44,369————44,369

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

Table 7 after “(Unaudited)”

Common StockAdditionalPaid-inCapitalAccumulated OtherComprehensiveIncome (Loss)RetainedEarningsTreasury StockTotalShareholders'Equity
SharesAmountSharesAmount
Balance at December 31, 201748,148$481$626,867$(46)$624,463(10,262)$(60,029)$1,191,736
Net income————115,910——115,910
Exercise of stock options and vesting of restricted stock units——54,666——1,04815,87070,536
Stock compensation——37,966————37,966
Issuance of shares pursuant to employee stock purchase plan——5,436——355425,978
Treasury stock purchases————————

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

Table 8 after “The following table summarizes the changes in the allowance for doubtful accounts (in thousands):”

Nine months ended September 30, 2019
Balance, beginning of period December 31, 2018$4,647
Provisions for losses - accounts receivable2,908
Collection of accounts previously written off—
Deductions for accounts charged off or credits issued(3,253)
Balance, end of period$4,302

Table 9 after “Amounts recognized at January 1, 2019, for operating leases were as follow (in thousands):”

Operating lease right-of-use assets$15,633
Operating lease liabilities(4,344)
Operating lease liabilities, long-term(12,405)
Retained earnings$(1,116)

Table 10 after “We have performed a preliminary valuation analysis of the fair market value of MicroPact’s assets and liabilities. The following table summa”

(In thousands)
Cash$1,983
Accounts receivable12,247
Other current assets8,979
Other noncurrent assets10,417
Identifiable intangible assets131,443
Goodwill73,193
Accounts payable(602)

First 8 of 13 rows. The download has all of them.

Table 11 after “The following unaudited pro forma consolidated operating results information has been prepared as if the MicroPact acquisition had occurred ”

Three Months Ended September 30,Nine Months Ended September 30,
2019201820192018
Revenues$275,400$257,236$809,389$750,240
Net income40,39040,90799,449115,181
Basic earnings per share1.041.062.582.99
Diluted earnings per share$1.00$1.01$2.49$2.85

Table 12 after “The following table details activity in our common stock (in thousands):”

Three Months Ended September 30,Nine Months Ended September 30,
2019201820192018
SharesAmountSharesAmountSharesAmountSharesAmount
Purchases of treasury shares—$——$—(72)$(14,289)—$—
Stock option exercises39540,16332626,21969162,2951,04870,536
Employee stock plan purchases152,718122,218437,327355,978
Restricted stock units vested, net of withheld shares upon award settlement1$(191)—$—38$(3,572)—$—

Table 13 after “The following table details the reconciliation of basic earnings per share to diluted earnings per share (in thousands):”

Three Months Ended September 30,Nine Months Ended September 30,
2019201820192018
Numerator for basic and diluted earnings per share:
Net income$40,390$38,924$99,737$115,910
Denominator:
Weighted-average basic common shares outstanding38,76538,76138,61438,533
Assumed conversion of dilutive securities:
Stock awards1,5151,7671,4011,812

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

Table 14 after “The components of operating lease expense were as follows (in thousands):”

Lease CostsFinancial Statement ClassificationThree Months Ended September 30,Nine Months Ended September 30,
20192019
Operating lease costSelling, general and administrative expenses$1,692$4,726
Short-term lease costSelling, general and administrative expenses5451,707
Variable lease costSelling, general and administrative expenses370901
Net lease cost$2,607$7,334

Table 15 after “, ROU lease assets and lease liabilities for our operating leases were recorded in the condensed consolidated balance sheet as follows (in t”

September 30, 2019
Assets:
Operating lease right-of-use assets$20,172
Liabilities:
Operating leases, short-term6,413
Operating leases, long-term18,134
Total lease liabilities$24,547

Table 16 after “Supplemental information related to leases was as follows:”

Other InformationNine Months Ended September 30,
2019
Cash Flows (in thousands):
Cash paid amounts included in the measurement of lease liabilities:
Operating cash outflows from operating leases$5,141
Right-of-use assets obtained in exchange for lease obligations (non-cash):
Operating leases$3,350
Lease Term and Discount Rate:

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

Table 17 after “, maturities of lease liabilities were as follows (in thousands):”

Year ending December 31,Amount
2019 (Remaining 2019)$2,124
20207,499
20216,063
20223,821
20232,856
Thereafter4,528
Total lease payments26,891

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

Table 18 after “, the future minimum lease commitments related to lease agreements under Topic 840, the predecessor of Topic 842, were as follows (in thousa”

Year ending December 31,Amount
2019$5,994
20205,146
20213,976
20221,925
20231,164
Thereafter2,132
Total$20,337

Table 19 after “Future minimum operating rental income based on contractual agreements is as follows (in thousands):”

Year ending December 31,Amount
2019 (Remaining 2019)$331
20201,341
20211,372
20221,402
20231,432
Thereafter2,395
Total$8,273

Table 20 after “The following table summarizes share-based compensation expense related to share-based awards recorded in the condensed consolidated stateme”

Three Months Ended September 30,Nine Months Ended September 30,
2019201820192018
Cost of software services, maintenance and subscriptions$3,612$3,909$11,166$9,640
Selling, general and administrative expenses11,27510,56733,20328,326
Total share-based compensation expense$14,887$14,476$44,369$37,966

Table 21 after “16”

For the three months ended September 30, 2019
Enterprise SoftwareAppraisal and TaxCorporateTotals
Revenues
Software licenses and royalties$23,449$1,930$—$25,379
Subscriptions72,3982,874—75,272
Software services46,2968,701—54,997
Maintenance103,4386,395—109,833
Appraisal services—6,008—6,008

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

Table 22 after “16”

For the three months ended September 30, 2018
EnterpriseSoftwareAppraisal and TaxCorporateTotals
Revenues
Software licenses and royalties$19,544$2,900$—$22,444
Subscriptions56,2202,479—58,699
Software services41,6406,559—48,199
Maintenance90,0726,143—96,215
Appraisal services—5,544—5,544

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

Table 23 after “16”

For the nine months ended September 30, 2019
EnterpriseSoftwareAppraisal and TaxCorporateTotals
Revenues
Software licenses and royalties$60,443$7,404$—$67,847
Subscriptions207,9078,115—216,022
Software services138,40422,437—160,841
Maintenance297,93318,741—316,674
Appraisal services—17,455—17,455

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

Table 24 after “17”

For the nine months ended September 30, 2018
EnterpriseSoftwareAppraisal and TaxCorporateTotals
Revenues
Software licenses and royalties$60,224$7,396$—$67,620
Subscriptions153,5417,195—160,736
Software services126,92817,884—144,812
Maintenance267,68118,507—286,188
Appraisal services—16,470—16,470

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

Table 25 after “17”

Three Months Ended September 30,Nine Months Ended September 30,
Reconciliation of reportable segment operating income to the Company's consolidated totals:2019201820192018
Total segment operating income$53,674$47,868$149,617$142,310
Amortization of acquired software(7,975)(5,897)(22,645)(17,003)
Amortization of customer and trade name intangibles(5,646)(4,386)(15,762)(11,742)
Other income, net4991,0418382,198
Income before income taxes$40,552$38,626$112,048$115,763

Table 26 after “Timing of revenue recognition by revenue category during the period is as follows (in thousands):”

For the three months ended September 30, 2019
Products and services transferred at a point in timeProducts and services transferred over timeTotal
Revenues
Software licenses and royalties$21,362$4,017$25,379
Subscriptions—75,27275,272
Software services—54,99754,997
Maintenance—109,833109,833
Appraisal services—6,0086,008

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

Table 27 after “Timing of revenue recognition by revenue category during the period is as follows (in thousands):”

For the nine months ended September 30, 2019
Products and services transferred at a point in timeProducts and services transferred over timeTotal
Revenues
Software licenses and royalties$54,074$13,773$67,847
Subscriptions—216,022216,022
Software services—160,841160,841
Maintenance—316,674316,674
Appraisal services—17,45517,455

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

Table 28 after “19”

For the three months ended September 30, 2018
Products and services transferred at a point in timeProducts and services transferred over timeTotal
Revenues
Software licenses and royalties$17,373$5,071$22,444
Subscriptions—58,69958,699
Software services—48,19948,199
Maintenance—96,21596,215
Appraisal services—5,5445,544

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

Table 29 after “19”

For the nine months ended September 30, 2018
Products and services transferred at a point in timeProducts and services transferred over timeTotal
Revenues
Software licenses and royalties$53,697$13,923$67,620
Subscriptions—160,736160,736
Software services—144,812144,812
Maintenance—286,188286,188
Appraisal services—16,47016,470

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

Table 30 after “Recurring revenues and non-recurring revenues recognized during the period are as follows (in thousands):”

For the three months ended September 30, 2019
EnterpriseSoftwareAppraisal and TaxCorporateTotals
Recurring revenues$175,836$9,269$—$185,105
Non-recurring revenues73,67016,639(14)90,295
Intercompany4,029—(4,029)—
Total revenues$253,535$25,908$(4,043)$275,400

Table 31 after “20”

For the nine months ended September 30, 2019
EnterpriseSoftwareAppraisal and TaxCorporateTotals
Recurring revenues$505,840$26,856$—$532,696
Non-recurring revenues211,46047,2986,136264,894
Intercompany11,242—(11,242)—
Total revenues$728,542$74,154$(5,106)$797,590

Table 32 after “20”

For the three months ended September 30, 2018
EnterpriseSoftwareAppraisal and TaxCorporateTotals
Recurring revenues$146,292$8,622$—$154,914
Non-recurring revenues66,18315,003(33)81,153
Intercompany3,373—(3,373)—
Total revenues$215,848$23,625$(3,406)$236,067

Table 33 after “20”

For the nine months ended September 30, 2018
EnterpriseSoftwareAppraisal and TaxCorporateTotals
Recurring revenues$421,222$25,702$—$446,924
Non-recurring revenues199,67741,7834,917246,377
Intercompany9,696—(9,696)—
Total revenues$630,595$67,485$(4,779)$693,301

Table 34 after “Total deferred revenue, including long-term, by segment is as follows (in thousands):”

September 30, 2019December 31, 2018
Enterprise Software$367,416$327,521
Appraisal and Tax23,22420,018
Corporate1,1613,397
Totals$391,801$350,936

Table 35 after “Changes in total deferred revenue, including long-term, were as follows (in thousands):”

September 30, 2019
Balance, beginning of period December 31, 2018$350,936
Deferral of revenue691,512
Recognition of deferred revenue(650,647)
Balance, end of period$391,801

Table 36 after “ANALYSIS OF RESULTS OF OPERATIONS”

Percent of Total Revenues
Three Months EndedNine Months Ended
2019201820192018
Revenues:
Software licenses and royalties9.2%9.5%8.5%9.8%
Subscriptions27.324.927.123.2
Software services20.020.420.220.9
Maintenance39.940.839.641.2

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

Table 37 after “, which is included in our condensed consolidated statements of income from the date of acquisition:”

(In thousands)Three Months EndedNine Months Ended
Revenues:
Software licenses and royalties$1,109$1,869
Subscriptions2,0244,606
Software services5,10012,055
Maintenance8,12017,854
Appraisal services——
Hardware and other324

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

Table 38 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
ES$23,449$19,544$3,90520%$60,443$60,224$219—%
A&T1,9302,900(970)(33)7,4047,3968—
Total software licenses and royalties revenue$25,379$22,444$2,93513%$67,847$67,620$227—%

Table 39 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
ES$72,398$56,220$16,17829%$207,907$153,541$54,36635%
A&T2,8742,479395168,1157,19592013
Total subscriptions revenue$75,272$58,699$16,57328%$216,022$160,736$55,28634%

Table 40 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
ES$46,296$41,640$4,65611%$138,404$126,928$11,4769%
A&T8,7016,5592,1423322,43717,8844,55325
Total software services revenue$54,997$48,199$6,79814%$160,841$144,812$16,02911%

Table 41 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
ES$103,438$90,072$13,36615%$297,933$267,681$30,25211%
A&T6,3956,143252418,74118,5072341.3
Total maintenance revenue$109,833$96,215$13,61814%$316,674$286,188$30,48611%

Table 42 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
ES$—$—$——%$—$—$——%
A&T6,0085,544464817,45516,4709856
Total appraisal services revenue$6,008$5,544$4648%$17,455$16,470$9856%

Table 43 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
Software licenses and royalties$971$957$141%$2,680$2,939$(259)(9)%
Acquired software7,9755,8972,0783522,64517,0035,64233
Software services, maintenance and subscriptions128,545111,50817,03715371,464327,08044,38414
Appraisal services4,0963,5055911711,30610,8544524
Hardware and other3,0962,5745222014,87011,7183,15227
Total cost of revenues$144,683$124,441$20,24216%$422,965$369,594$53,37114%

Table 44 after “September 30:”

Three Months EndedNine Months Ended
20192018Change20192018Change
Software licenses, royalties and acquired software64.8%69.5%(4.7)%62.7%70.5%(7.8)%
Software services, maintenance and subscriptions46.545.11.446.444.71.7
Appraisal services31.836.8(5.0)35.234.11.1
Hardware and other20.848.2(27.4)20.732.9(12.2)
Overall gross margin47.5%47.3%0.2%47.0%46.7%0.3%

Table 45 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
Selling, general and administrative expenses$63,888$52,605$11,28321%$187,481$152,471$35,01023%

Table 46 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
Research and development expense$21,130$17,050$4,08024%$60,172$45,929$14,24331%

Table 47 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
Amortization of other intangibles$5,646$4,386$1,26029%$15,762$11,742$4,02034%

Table 48 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
Other income, net$499$1,041$(542)NM$838$2,198$(1,360)NM

Table 49 after “September 30:”

Three Months EndedChangeNine Months EndedChange
($ in thousands)20192018$%20192018$%
Income tax provision (benefit)$162$(298)$460NM$12,311$(147)$12,458NM
Effective income tax rate0.4%(0.8)%11.0%(0.1)%

Table 50 after “September 30:”

(in thousands)20192018
Cash flows provided (used) by:
Operating activities$178,527$179,353
Investing activities(203,204)(222,341)
Financing activities51,83676,514
Net increase in cash and cash equivalents$27,159$33,526

Table 51 after “ITEM 6. Exhibits”

Exhibit 31.1Certification Pursuant to Section 302 of the Sarbanes-Oxley Act of 2002
Exhibit 31.2Certification Pursuant to Section 302 of the Sarbanes-Oxley Act of 2002
Exhibit 32.1Certifications Pursuant to 18 U.S.C. Section 1350, as adopted Pursuant to Section 906 of the Sarbanes-Oxley Act of 2002
Exhibit 10.1Agreement and plan of merger by and among Tyler Technologies, Inc., TMP Subsidiary Inc., MP Holdings Parent, Inc. (filed as Exhibit 10.7 to our Form 10-K dated Feb 20, 2019 and incorporated by reference herein).
Exhibit 10.2Credit Agreement dated September 30, 2019, among Tyler Technologies, Inc. and Wells Fargo Bank, N. A. as Administrative Agent and other lenders party hereto (filed as Exhibit 10.1 to our Form 8-K dated October 2, 2019 and incorporated by reference herein).
Exhibit 101Instance Document
Exhibit 101Schema Document
Exhibit 101Calculation Linkbase Document

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