Mercury systems, inc. (MRCY)
Balance Sheet / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11
Assets
Current assets:
Cash and cash equivalents

407,146

182,037

161,299

257,932

112,515

93,903

72,869

66,521

44,217

32,035

26,074

41,637

270,238

46,185

77,314

81,691

84,245

81,554

79,073

77,586

66,520

56,987

48,876

47,287

45,710

44,535

40,106

39,126

35,145

33,900

30,568

115,964

114,845

104,955

165,862

162,875

Accounts receivable, net of allowance for doubtful accounts of $1,301 and $1,228 at March 27, 2020 and June 30, 2019, respectively

127,129

132,072

108,904

118,832

114,806

123,117

113,920

104,040

101,400

87,315

89,037

76,341

68,227

68,827

62,158

73,427

39,314

35,468

41,993

31,765

47,552

47,432

35,155

37,625

33,535

31,117

35,143

29,229

29,470

35,275

40,503

38,532

38,190

46,807

38,128

44,786

Unbilled receivables and costs in excess of billings

86,860

-

68,568

57,387

55,941

45,194

39,977

39,774

40,177

35,655

32,413

37,332

28,389

28,052

23,574

22,467

29,376

24,645

24,423

22,021

20,475

19,774

29,228

22,036

18,610

9,888

13,913

17,266

17,997

12,567

10,959

10,918

11,672

8,495

1,202

1,059

Inventory

161,858

153,642

148,500

137,112

131,655

126,402

121,156

108,585

117,075

105,912

93,274

81,071

72,096

70,088

58,443

58,284

34,348

36,707

34,666

31,960

32,526

30,011

30,771

31,655

35,330

33,140

35,179

37,432

38,744

40,783

40,438

25,845

21,802

22,760

24,502

18,540

Deferred income taxes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

12,788

12,363

12,379

-

13,044

15,172

15,182

15,216

10,060

10,190

10,724

11,534

13,016

13,194

12,258

7,653

8,132

8,745

6,896

7,678

Prepaid income taxes

1,129

5,454

3,171

90

0

766

6,736

3,761

2,487

15

2,085

1,434

1,487

5,049

2,804

3,401

1,912

2,880

3,041

3,747

3,981

4,729

1,399

1,481

3,113

8,681

3,541

2,369

3,014

2,617

2,307

2,585

1,668

1,955

371

1,075

Prepaid expenses and other current assets

11,271

10,602

12,599

10,819

10,253

9,923

9,521

9,062

7,802

7,970

9,114

8,381

7,916

6,646

7,665

6,122

4,652

5,361

5,292

8,678

3,661

3,835

4,547

3,631

4,683

6,916

6,737

7,326

4,919

5,444

6,253

6,206

4,894

5,262

4,242

4,171

Current assets of discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

1,095

894

1,374

-

-

-

2,019

-

-

-

-

-

-

-

-

Total current assets

795,393

545,109

503,041

582,172

425,170

399,305

364,179

331,743

313,158

268,902

251,997

246,196

448,353

224,847

231,958

245,392

206,635

198,978

200,867

175,757

187,759

179,035

166,052

160,305

151,041

144,467

145,343

146,301

142,305

143,780

143,286

207,703

201,203

198,979

241,203

240,184

Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

264

264

264

264

264

264

264

265

265

546

546

546

546

546

658

3,546

3,281

3,281

3,281

3,000

3,000

Property and equipment, net

78,664

72,696

65,946

60,001

55,857

53,130

50,829

50,980

51,291

51,640

51,603

51,643

47,356

39,379

31,376

28,337

13,512

13,324

13,493

13,226

12,391

12,968

13,343

14,144

15,226

16,145

14,565

14,462

16,631

18,261

19,738

15,929

15,351

14,452

14,221

14,520

Estimated goodwill

614,830

614,648

617,175

562,146

543,515

519,660

520,589

497,442

499,292

384,785

384,200

380,846

365,713

366,791

344,525

344,027

173,741

173,749

168,146

168,146

168,146

168,146

168,146

168,146

177,116

176,612

176,612

167,551

178,398

178,429

177,517

132,621

132,325

132,471

79,558

79,558

Intangible assets, net

216,546

224,507

230,187

206,124

180,828

176,671

183,606

177,904

186,391

120,672

126,501

129,037

117,953

122,308

112,071

116,673

17,235

18,608

16,470

17,998

19,739

21,481

23,244

25,006

28,954

31,131

32,758

32,308

37,209

39,565

41,795

25,083

26,231

27,545

15,906

16,702

Operating lease right-of-use assets

61,112

49,826

51,312

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net deferred tax asset

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,574

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other non-current assets

5,095

5,834

6,191

6,534

7,011

7,873

7,771

6,411

6,814

9,817

8,291

8,023

2,001

1,952

2,231

1,803

3,369

3,169

2,148

915

941

1,238

1,255

987

713

841

1,061

1,158

1,305

1,446

1,098

989

955

928

926

1,598

Non-current assets of discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

2,235

4,685

4,859

-

-

-

12,105

-

-

-

-

-

-

-

-

Total assets

1,771,640

1,512,620

1,473,852

1,416,977

1,212,381

1,156,639

1,126,974

1,064,480

1,056,946

835,816

822,592

815,745

981,376

755,277

722,161

736,496

414,756

408,092

401,388

386,880

389,240

385,367

376,990

373,712

373,596

369,742

370,885

374,431

376,394

382,139

386,980

385,606

379,346

377,656

354,814

355,562

Liabilities and Shareholders' Equity
Current liabilities:
Accounts payable

50,089

35,988

34,940

39,030

35,220

30,750

25,726

21,323

32,857

37,628

42,225

27,485

24,321

26,236

19,283

26,723

12,412

11,858

17,186

6,928

14,387

11,300

12,384

7,054

10,412

3,553

7,522

4,773

5,997

8,875

10,888

9,002

8,204

7,168

12,539

7,972

Accrued expenses

24,727

23,906

21,741

18,897

20,342

16,875

15,144

16,386

16,655

10,427

10,639

20,594

14,600

10,547

8,970

10,273

12,534

8,719

9,143

9,005

9,190

8,817

9,403

8,377

9,440

6,793

6,743

7,115

7,779

9,822

12,673

9,895

12,272

8,883

6,192

5,808

Accrued compensation

34,781

31,372

28,154

28,814

27,500

23,064

20,281

21,375

20,288

17,781

16,603

18,406

17,888

15,841

14,355

13,283

11,880

11,409

8,488

9,875

9,062

8,979

7,265

9,983

8,690

9,105

8,403

11,488

9,943

10,558

8,341

13,190

12,149

11,996

7,474

16,288

Income taxes payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,574

473

-

Deferred revenues and customer advances

12,419

16,618

9,235

11,291

10,728

22,491

21,605

12,596

9,537

8,440

5,849

6,360

6,556

5,896

3,566

7,365

5,166

9,406

7,944

7,477

8,094

8,778

3,649

5,898

4,476

4,879

4,749

5,788

4,898

6,007

4,602

4,855

4,870

9,595

4,994

6,138

Long-term Debt, Current Maturities

-

-

-

-

-

-

-

-

-

-

-

-

10,000

10,000

10,000

10,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Current liabilities of discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

1,583

1,383

1,618

-

-

-

1,654

-

-

-

-

-

-

-

-

Total current liabilities

122,016

107,884

94,070

98,032

93,790

93,180

82,756

71,680

79,337

74,276

75,316

72,845

73,365

68,520

56,174

67,644

41,992

41,392

42,761

33,285

40,733

39,457

34,084

32,930

33,018

24,330

27,417

30,818

28,617

35,262

36,504

36,942

37,495

39,216

31,672

36,206

Deferred income taxes

19,166

18,406

18,028

17,814

11,811

12,202

13,266

13,635

14,161

0

650

4,856

7,030

11,954

9,575

11,842

2,391

2,287

2,658

0

3,174

5,021

5,437

5,911

1,437

7,035

7,238

6,652

12,011

12,768

13,537

7,197

9,400

7,978

3,652

3,877

Deferred gain on sale-leaseback

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

61

350

639

-

1,218

1,507

1,796

2,086

2,375

2,664

2,953

3,242

3,531

3,821

4,110

4,399

4,689

4,978

5,267

5,556

Income taxes payable

1,751

1,397

1,172

1,273

2,880

2,880

2,879

998

855

855

855

855

700

700

700

700

1,513

1,505

1,459

1,459

2,255

3,277

3,154

3,154

2,771

2,880

2,880

2,880

2,597

2,597

2,597

2,597

1,912

1,777

1,777

1,777

Long-term debt

200,000

-

-

0

276,500

240,000

240,000

195,000

195,000

-

-

0

176,137

180,710

180,246

182,275

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Operating lease liabilities

67,028

55,257

53,063

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other non-current liabilities

12,246

12,620

12,241

15,119

15,018

12,301

11,452

11,276

11,797

11,454

11,503

11,772

12,762

8,677

927

991

1,056

1,100

1,237

1,998

1,195

1,165

1,307

1,666

1,733

2,021

1,179

1,269

1,216

1,608

1,678

1,367

754

5,496

5,764

6,710

Non-current liabilities of discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

724

771

818

-

-

-

1,069

-

-

-

-

-

-

-

-

Total liabilities

422,207

195,564

178,574

132,238

399,999

360,563

350,353

292,589

301,150

86,585

88,324

90,328

269,994

270,561

247,622

263,452

47,013

46,634

48,754

36,742

48,575

51,151

46,549

46,565

41,334

38,930

41,667

45,930

47,972

56,056

58,426

52,502

54,250

59,445

48,132

54,126

Commitments and contingencies

-

-

-

-

-

-

0

-

0

-

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Shareholders' equity:
Shareholders’ equity:

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Preferred stock, $0.01 par value; 1,000,000 shares authorized; no shares issued or outstanding

546

545

545

542

473

472

472

469

468

468

467

463

461

392

391

387

333

332

330

326

324

322

320

312

312

311

309

304

303

302

300

297

296

295

294

291

Additional paid-in capital

1,064,698

1,056,238

1,049,952

1,058,745

599,238

594,670

587,788

590,163

584,855

581,534

575,737

584,795

579,893

360,477

355,164

357,500

260,805

259,140

255,083

254,568

251,000

248,228

244,609

241,725

239,335

237,331

234,620

231,711

229,550

227,827

225,384

222,769

220,463

218,812

216,309

213,777

Retained earnings

285,231

261,666

245,990

226,743

213,939

199,830

187,447

179,968

169,867

166,171

157,038

139,085

130,281

123,233

118,029

114,210

105,747

101,221

96,428

94,468

88,538

84,863

84,598

84,099

91,645

92,223

93,268

95,524

97,536

96,748

101,532

108,732

103,056

97,811

88,766

86,113

Accumulated other comprehensive income

-1,042

-1,393

-1,209

-1,291

-1,268

1,104

914

1,291

606

1,058

1,026

1,074

747

614

955

947

858

765

793

776

803

803

914

1,011

970

947

1,021

962

1,033

1,206

1,338

1,306

1,281

1,293

1,313

1,255

Total shareholders' equity

1,349,433

1,317,056

1,295,278

1,284,739

812,382

796,076

776,621

771,891

755,796

749,231

734,268

725,417

711,382

484,716

474,539

473,044

367,743

361,458

352,634

350,138

340,665

334,216

330,441

327,147

332,262

330,812

329,218

328,501

328,422

326,083

328,554

333,104

325,096

318,211

306,682

301,436

Total liabilities and shareholders' equity

1,771,640

1,512,620

1,473,852

1,416,977

1,212,381

1,156,639

1,126,974

1,064,480

1,056,946

835,816

822,592

815,745

981,376

755,277

722,161

736,496

414,756

408,092

401,388

386,880

389,240

385,367

376,990

373,712

373,596

369,742

370,885

374,431

376,394

382,139

386,980

385,606

379,346

377,656

354,814

355,562

Long-term debt

200,000

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

19,166

-

-

17,814

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-