Ultimate Software Group Inc ULTI Balance Sheet

Ultimate software group inc (ULTI)

Balance Sheet / TTM

Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11	Dec'10
Assets
Current Assets:
Cash and cash equivalents
100,424	151,247	132,723	184,855	143,639	155,685	125,712	98,039	73,765	73,773	94,786	82,318	83,372	109,325	122,138	104,276	115,274	108,298	99,923	80,967	91,080	79,794	100,921	81,193	72,081	58,817	73,143	62,612	57,123	46,149	42,216	45,234	48,022	40,889
Investments in marketable securities
3,448	10,741	8,232	3,274	4,257	9,434	12,213	12,924	10,098	15,541	16,319	15,673	12,944	10,780	6,797	6,543	7,447	7,862	8,711	7,780	8,288	8,682	8,737	7,934	6,936	9,223	8,709	9,439	8,321	7,584	8,778	7,112	8,399	8,884
Accounts receivable, net of allowance for doubtful accounts of $1,750 for 2019 and $1,650 for 2018
247,651	238,768	210,867	195,247	192,477	190,989	183,879	168,920	161,407	162,240	147,683	147,167	139,964	130,106	119,982	108,701	99,866	100,218	88,144	84,354	82,256	85,676	74,216	70,713	70,059	70,774	57,472	53,667	51,084	56,186	46,612	46,733	45,644	47,570
Deferred contract costs, prepaid expenses and other current assets
110,155	90,761	83,588	78,116	64,290	71,602	72,335	72,458	66,776	61,901	57,237	53,280	48,536	46,804	42,904	40,576	36,666	34,788	34,729	32,528	31,578	29,374	28,470	29,931	29,088	25,949	24,689	25,580	23,356	22,944	21,402	22,707	20,360	18,613
Deferred tax assets, net
-	-	-	-	-	-	0	0	0	1,125	913	851	839	883	1,050	983	983	965	909	949	982	1,015	1,369	1,372	1,372	1,372	1,353	1,310	1,287	1,277	1,508	1,458	1,440	1,434
Total current assets before funds held for customers
461,678	491,517	435,410	461,492	404,663	427,710	394,139	352,341	312,046	314,580	316,938	299,289	285,655	297,898	292,871	261,079	260,236	252,131	232,416	206,578	214,184	204,541	213,713	191,143	179,536	166,135	165,366	152,608	141,171	134,140	120,516	123,244	123,865	117,390
Funds held for customers
1,378,121	618,206	567,208	624,110	1,210,419	563,062	477,957	489,618	923,998	465,167	394,400	930,790	1,312,428	923,308	331,220	401,283	847,172	759,087	378,839	461,901	711,154	262,227	332,097	443,875	642,443	281,007	144,196	157,684	332,529	118,660	100,696	165,468	255,999	72,875
Total current assets
1,839,799	1,109,723	1,002,618	1,085,602	1,615,082	990,772	872,096	841,959	1,236,044	779,747	711,338	1,230,079	1,598,083	1,221,206	624,091	662,362	1,107,408	1,011,218	611,255	668,479	925,338	466,768	545,810	635,018	821,979	447,142	309,562	310,292	473,700	252,800	221,212	288,712	379,864	190,265
Property and equipment, net
321,962	302,939	290,192	274,841	259,782	243,664	233,171	220,589	203,442	179,558	166,333	153,135	141,508	125,492	111,459	103,004	96,652	86,595	82,188	75,147	67,385	58,186	51,452	46,684	41,990	38,068	35,547	32,886	25,195	24,486	23,516	22,040	20,095	18,075
Capitalized software, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	102	205	356	508	752	1,090	1,427	1,765	2,102	2,440	2,777	3,115
Goodwill
216,395	219,904	223,198	35,484	35,613	35,808	35,859	35,563	35,378	35,322	35,583	29,173	24,873	24,410	24,637	25,226	25,056	25,696	25,774	26,169	25,813	26,942	3,025	3,025	3,025	3,025	3,025	3,025	3,025	3,025	3,025	3,025	3,025	3,025
Investments in marketable securities
-	-	-	-	-	-	0	0	4,306	8,547	7,904	6,918	7,461	9,278	11,443	3,129	2,651	2,294	1,973	2,548	2,320	1,771	1,705	1,947	2,313	1,311	1,069	1,076	1,585	1,546	1,214	1,636	926	433
Intangible assets, net
137,059	144,411	151,247	19,227	20,034	20,862	21,662	22,371	23,099	23,860	23,551	10,840	5,094	5,167	5,507	6,018	6,203	6,774	7,218	7,704	7,822	8,274	-	-	-	0	-	-	-	-	-	-	-	-
Deferred contract costs and other assets, net
201,056	129,108	121,782	114,623	104,582	53,409	51,251	50,995	49,198	47,432	41,834	39,009	34,253	31,107	27,374	25,035	22,779	20,611	19,284	18,603	17,593	17,340	16,865	16,033	16,983	16,687	16,329	15,802	15,453	15,056	14,014	12,290	11,921	11,656
Deferred income tax assets, net
0	14,632	21,556	30,242	22,429	32,696	71,878	70,735	65,838	60,222	83,531	48,874	48,901	48,909	47,979	43,458	40,556	37,110	35,619	21,250	20,116	18,913	19,957	19,487	19,191	18,543	19,637	19,886	20,077	20,142	21,304	22,386	22,843	22,988
Total assets
2,716,271	1,920,717	1,810,593	1,560,019	2,057,522	1,377,211	1,285,917	1,242,212	1,617,305	1,134,688	1,070,074	1,518,028	1,860,173	1,465,569	852,490	868,232	1,301,305	1,190,298	783,311	819,900	1,066,387	598,194	638,916	722,399	905,837	525,284	385,921	384,057	540,462	318,820	286,387	352,529	441,451	249,557
LIABILITIES AND STOCKHOLDERS’ EQUITY
Current liabilities:
Accounts payable
16,825	16,058	12,107	14,125	16,003	16,099	12,849	13,835	18,946	13,519	11,618	8,889	9,479	7,395	6,924	7,388	9,633	7,418	7,935	7,341	8,769	6,422	5,441	6,368	6,185	7,584	4,912	7,642	5,658	6,265	5,149	6,376	6,561	4,683
Accrued expenses and other liabilities
143,982	154,383	150,095	93,990	65,280	60,394	55,110	38,562	34,243	50,973	49,304	39,833	46,498	42,097	40,532	31,652	34,645	30,941	32,374	26,647	27,196	26,040	24,924	18,522	21,124	15,055	17,577	15,299	15,555	11,589	12,958	12,895	11,164	11,074
Deferred revenue
249,219	238,940	223,382	212,997	200,576	197,088	186,014	184,408	173,702	171,669	162,758	156,329	147,064	142,793	128,484	121,147	111,282	109,552	105,809	103,649	103,481	102,686	94,493	93,142	91,936	90,674	83,334	82,732	82,234	83,416	75,619	73,212	72,315	71,808
Finance lease obligations
8,142	6,303	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capital Lease Obligations, Current
-	-	6,420	6,511	5,307	5,474	5,175	5,305	4,866	5,056	5,509	5,101	5,231	4,488	4,224	4,303	4,423	3,655	3,675	3,576	3,231	2,949	2,969	2,764	2,968	2,968	3,096	3,078	2,878	2,694	2,699	2,614	2,552	2,551
Other borrowings
-	-	-	-	-	-	-	-	-	-	100	200	300	400	400	400	569	567	632	670	2,267	2,264	2,261	2,258	3,860	2,311	2,362	2,413	-	0	-	-	-	-
Total current liabilities before customer funds obligations
418,168	415,684	392,004	327,623	287,166	279,055	259,148	242,110	231,757	241,217	229,289	210,352	208,572	197,173	180,564	164,890	160,552	152,133	150,425	141,883	144,944	140,361	130,088	123,054	126,073	118,592	111,281	111,164	106,325	103,964	96,425	95,097	92,592	90,116
Customer funds obligations
1,378,736	619,230	568,545	625,511	1,212,055	564,031	478,621	491,661	925,815	466,423	395,150	931,249	1,312,671	923,366	331,220	401,283	847,172	759,087	378,839	461,901	711,154	262,227	332,097	443,875	642,443	281,007	144,196	157,684	332,529	118,660	100,696	165,468	255,999	72,875
Total current liabilities
1,796,904	1,034,914	960,549	953,134	1,499,221	843,086	737,769	733,771	1,157,572	707,640	624,439	1,141,601	1,521,243	1,120,539	511,784	566,173	1,007,724	911,220	529,264	603,784	856,098	402,588	462,185	566,929	768,516	399,599	255,477	268,848	438,854	222,624	197,121	260,565	348,591	162,991
Deferred revenue
844	1,009	1,213	1,431	1,650	1,773	2,360	2,547	2,167	2,307	2,492	2,660	2,813	2,934	2,847	57	131	153	200	256	341	498	689	881	1,049	1,302	1,720	2,118	2,689	3,147	3,761	4,798	5,146	6,287
Deferred rent
0	8,472	8,778	8,695	9,162	5,349	5,778	6,208	6,258	6,022	4,309	4,140	4,885	3,719	3,598	2,839	2,609	2,368	2,281	2,724	2,495	2,687	2,696	2,622	2,689	2,777	2,919	2,995	3,377	3,384	3,321	3,580	3,391	3,022
Finance lease obligations
7,136	5,739	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capital Lease Obligations, Noncurrent
-	-	5,954	6,346	3,981	4,477	4,186	4,707	3,718	3,985	5,090	4,354	4,826	3,665	3,528	4,024	4,724	3,359	3,454	3,369	2,748	2,240	2,437	2,094	2,481	2,469	2,641	2,591	2,379	2,175	2,326	2,281	2,243	2,406
Other long-term liabilities
60,872	500	625	2,375	2,500	4,250	3,250	4,875	4,875	0	-	-	-	-	100	200	300	400	0	128	297	593	760	926	1,255	2,601	2,765	2,928	-	0	-	-	-	-
Deferred income tax liability
24,165	25,105	25,230	380	361	251	358	441	468	519	584	824	644	646	753	817	911	1,049	1,131	1,244	1,244	1,371	-	-	-	0	-	-	-	-	-	-	-	-
Income taxes payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,866	1,866	1,866	1,866	1,866	1,866	1,866	1,866	1,866	1,866	1,866	1,866
Total liabilities
1,889,921	1,075,739	1,002,349	972,361	1,516,875	859,186	753,701	752,549	1,175,058	720,473	636,914	1,153,579	1,534,411	1,131,503	522,610	574,110	1,016,399	918,549	536,330	611,505	863,223	409,977	470,633	575,318	777,856	410,614	267,388	281,346	449,165	233,196	208,395	273,090	361,237	176,572
Commitments and contingencies (Note 17)
-	-	-	-	-	-	-	-	-	0	-	-	-	0	-	-	-	0	-	-	-	0	-	-	-	0	-	-	-	0	-	-	-	0
Statement of Stockholders' Equity [Abstract]
Preferred Stock
0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-	0	0	-	-	-	0	-	-	-	0	0	0	-	0	-	-	-	-
Preferred Stock, $.01 par value, 2,000,000 shares authorized, no shares issued or outstanding
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Common Stock, $.01 par value, 50,000,000 shares authorized, 36,338,258 and 35,985,995 shares issued as of March 31, 2019 and December 31, 2018, respectively
363	360	359	353	353	348	345	345	343	340	336	336	335	333	330	330	329	327	325	324	324	321	320	319	317	314	309	307	305	302	296	296	294	290
Additional paid-in capital
836,185	863,030	834,846	629,156	595,426	609,160	602,251	565,326	523,302	520,524	533,805	517,912	480,961	463,609	455,649	423,376	393,810	376,609	362,602	342,493	324,589	315,691	304,501	289,898	275,183	266,130	266,371	255,584	246,613	242,100	236,484	229,365	223,098	216,262
Accumulated other comprehensive loss
-19,537	-14,574	-9,208	-7,013	-6,613	-5,912	-5,680	-6,611	-6,999	-7,023	-6,477	-6,179	-6,237	-7,829	-7,087	-5,061	-5,605	-3,590	-2,514	-1,334	-2,279	-1,442	-377	-675	-156	109	240	-136	76	-57	-91	175	187	126
Accumulated earnings
220,697	207,521	193,606	176,521	162,840	125,788	146,659	141,962	136,960	111,733	116,855	63,739	62,062	59,627	50,596	44,745	41,088	36,928	25,093	5,437	-926	-7,809	-17,617	-23,917	-28,819	-33,339	-39,637	-44,294	-46,947	-47,971	-49,947	-51,032	-51,925	-52,253
Stockholders' equity before treasury stock
1,037,708	1,056,337	1,019,603	799,017	752,006	729,384	743,575	701,022	653,606	625,574	644,519	575,808	537,121	515,740	499,488	463,390	429,622	410,274	385,506	346,920	321,708	306,761	286,827	265,625	246,525	233,214	227,283	211,461	200,047	194,374	186,742	178,804	171,654	164,425
Treasury stock, 4,657,995 shares, at cost, for 2019 and 2018
211,359	211,359	211,359	211,359	211,359	211,359	211,359	211,359	211,359	211,359	211,359	211,359	211,359	181,674	169,608	169,268	144,716	138,525	138,525	138,525	118,544	118,544	118,544	118,544	118,544	118,544	-108,750	-108,750	-108,750	108,750	108,750	99,365	91,440	-91,440
Stockholders' Equity Attributable to Parent
826,349	844,978	808,244	587,658	540,647	518,025	532,216	489,663	442,247	414,215	433,160	364,449	325,762	334,066	329,880	294,122	284,906	271,749	246,981	208,395	203,164	188,217	168,283	147,081	127,981	114,670	118,533	102,711	91,297	85,624	77,992	79,439	80,214	72,985
Total liabilities and stockholders’ equity
2,716,270	1,920,717	1,810,593	1,560,019	2,057,522	1,377,211	1,285,917	1,242,212	1,617,305	1,134,688	1,070,074	1,518,028	1,860,173	1,465,569	852,490	868,232	1,301,305	1,190,298	783,311	819,900	1,066,387	598,194	638,916	722,399	905,837	525,284	385,921	384,057	540,462	318,820	286,387	352,529	441,451	249,557
Series A Junior Preferred Stock
Preferred Stock
0	0	0	0	0	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-