After The Drop Appendixes

In [1]:
from IPython.display import HTML

HTML('''<script>
code_show=true; 
function code_toggle() {
if (code_show){
$('div.input').hide();
} else {
$('div.input').show();
}
code_show = !code_show
} 
$( document ).ready(code_toggle);
</script>
<form action="javascript:code_toggle()"><input type="submit" value="Hide/Show code blocks"></form>''')
Out[1]:

This article contains appendixes for After The Drop article.

Appendix 1. Financial Reports (Annual)

In [2]:
import pandas as pd
import numpy as np
from IPython.display import display, HTML, Markdown

tickers = ['ACIA', 'EXPR', 'URBN', 'GCO', 'CATO']
for ticker in tickers:
    I_FILE = './{} Income Statement.csv'.format(ticker)
    BS_FILE = './{} Balance Sheet.csv'.format(ticker)
    CF_FILE = './{} Cash Flow.csv'.format(ticker)
    display(Markdown("### {}".format(ticker)))
        
    i_df = pd.read_csv(I_FILE, index_col=0, header=1, mangle_dupe_cols=True)
    i_df = i_df.replace(np.nan, '', regex=True)
    bs_df = pd.read_csv(BS_FILE, index_col=0, header=1)
    bs_df = bs_df.replace(np.nan, '', regex=True)
    cf_df = pd.read_csv(CF_FILE, index_col=0, header=1)
    cf_df = cf_df.replace(np.nan, '', regex=True)
    
    display(Markdown("#### {} Income Statement (annual)".format(ticker)))
    display(i_df)

    print("\n\n")
    display(Markdown("#### {} Balance Sheet (annual)".format(ticker)))
    display(bs_df)

    print("\n\n")
    display(Markdown("#### {} Cash Flow (annual)".format(ticker)))
    display(cf_df)

ACIA

ACIA Income Statement (annual)

2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 2015-12 2016-12 2017-12 TTM
Fiscal year ends in December. USD in millions except per share data.
Revenue 78 146 239 478 385 343
Cost of revenue 48 94 145 257 217 208
Gross profit 30 53 94 221 168 136
Operating expenses
Research and development 24 28 39 76 92 99
Sales, General and administrative 5 7 13 28 39 44
Total operating expenses 29 35 52 103 131 143
Operating income 0 18 42 118 37 -8
Other income (expense) -2 -1 -2 -3 3 4
Income before taxes -1 16 40 115 40 -3
Provision for income taxes 3 -1 -17 2 3
Net income from continuing operations -1 14 41 132 39 -6
Net income -1 14 41 132 39 -6
Preferred dividend 4 4 -2 2
Net income available to common shareholders -5 9 43 130 39 -6
Earnings per share
Basic 1.39 3.77 0.99 -0.17
Diluted 1.3 3.22 0.92 -0.17
Weighted average shares outstanding
Basic 31 25 39 39
Diluted 33 30 42 41
EBITDA 3 20 47 127 49 5

ACIA Balance Sheet (annual)

2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 2015-12 2016-12 2017-12
Fiscal year ends in December. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 20 21 28 206 67
Short-term investments 104 212
Total cash 20 21 28 310 279
Receivables 12 18 41 108 87
Inventories 16 15 28 32 62
Prepaid expenses 0 3 3 12 19
Other current assets 1 1 3 0 0
Total current assets 50 58 103 462 447
Non-current assets
Property, plant and equipment
Gross property, plant and equipment 8 15 27 42 56
Accumulated Depreciation -4 -7 -11 -17 -28
Net property, plant and equipment 4 8 16 25 28
Equity and other investments 85
Deferred income taxes 11 24 42
Other long-term assets 0 0 0 6 9
Total non-current assets 4 8 27 55 164
Total assets 54 66 131 517 611
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 6 1
Accounts payable 11 13 25 49 48
Taxes payable 0 1 1 0
Accrued liabilities 8 7 11 21 23
Deferred revenues 2 4 8 1 1
Other current liabilities 1 2 4 8 14
Total current liabilities 28 26 48 81 86
Non-current liabilities
Long-term debt 2 1
Other long-term liabilities 63 68 74 1 24
Total non-current liabilities 65 69 74 1 24
Total liabilities 93 95 123 82 109
Stockholders' equity
Common stock 0 0 0 0 0
Additional paid-in capital 296 325
Retained earnings -39 -29 8 139 177
Accumulated other comprehensive income 0 0
Total stockholders' equity -39 -29 8 435 502
Total liabilities and stockholders' equity 54 66 131 517 611

ACIA Cash Flow (annual)

2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 2015-12 2016-12 2017-12 TTM
Fiscal year ends in December. USD in millions except per share data.
Cash Flows From Operating Activities
Net income -1 14 41 132 39 -6
Depreciation & amortization 3 3 5 9 12 13
Deferred income taxes -11 -12 -18 -20
Stock based compensation 2 0 1 21 23 25
Change in working capital -5 -4 -15 -51 7 46
Accounts receivable -3 -6 -23 -67 22 40
Inventory -11 1 -13 -4 -31 -23
Prepaid expenses 0 -2 1 -11 -7 -2
Accounts payable 5 2 12 23 -2 -3
Accrued liabilities 4 0 7 14 7 11
Income taxes payable 21
Other working capital -1 1 2 -8 -3 23
Other non-cash items 1 1 2 4 0 0
Net cash provided by operating activities -1 13 22 101 64 58
Cash Flows From Investing Activities
Investments in property, plant, and equipment -3 -6 -12 -17 -14 -15
Purchases of investments -119 -437 -393
Sales/Maturities of investments 15 243 292
Other investing activities 0 0 0 0 0 0
Net cash used for investing activities -3 -6 -12 -121 -208 -117
Cash Flows From Financing Activities
Debt repayment 0 -6 -2 0
Preferred stock issued 22
Common stock issued 217 6 6
Common stock repurchased -2 -3 0
Other financing activities 0 0 -2 -15 0
Net cash provided by (used for) financing activities 20 -6 -4 199 5 6
Effect of exchange rate changes 0 0
Net change in cash 16 1 6 179 -139 -53
Cash at beginning of period 4 20 21 28 206 140
Cash at end of period 20 21 28 206 67 87
Free Cash Flow
Operating cash flow -1 13 22 101 64 58
Capital expenditure -3 -6 -12 -17 -14 -15
Free cash flow -4 7 10 84 49 43

EXPR

EXPR Income Statement (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 1737 1721 1906 2073 2148 2219 2165 2350 2193 2138 2143
Cost of revenue 1280 1175 1227 1319 1405 1501 1505 1555 1529 1523 1517
Gross profit 457 546 678 754 743 718 661 795 663 615 626
Operating expenses
Sales, General and administrative 447 409 461 484 492 504 524 588 560 562 570
Other operating expenses 6 10 18 -0 0 1 -0
Total operating expenses 453 419 479 484 492 504 524 588 560 563 570
Operating income 4 127 199 271 251 213 137 208 104 53 56
Interest Expense 37 53 59 36 20
Other income (expense) 4 3 2 0 0 -20 -25 -17 -13 -25 -18
Income before income taxes -29 77 142 236 232 193 112 191 91 28 38
Provision for income taxes 0 1 14 95 93 77 43 74 33 9 16
Net income from continuing operations -29 75 127 141 139 117 68 117 57 19 23
Net income -29 75 127 141 139 117 68 117 57 19 23
Net income available to common shareholders -29 75 127 141 139 117 68 117 57 19 23
Earnings per share
Basic 1.49 1.59 1.6 1.38 0.81 1.39 0.73 0.25 0.29
Diluted 1.48 1.58 1.6 1.37 0.81 1.38 0.73 0.25 0.29
Weighted average shares outstanding
Basic 74 85 89 87 84 84 84 79 79 78
Diluted 74 86 89 87 85 85 85 79 79 78
EBITDA 89 202 270 339 319 283 213 282 186 143 144

EXPR Balance Sheet (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 176 234 188 152 256 312 346 187 207 236
Total cash 176 234 188 152 256 312 346 187 207 236
Receivables 7 4 10 9 11 17 23 22 16 12
Inventories 170 172 185 209 215 213 241 255 241 266
Prepaid expenses 21 21 22 23 25 29 29 31 32 31
Other current assets 7 5 22 18 8 13 14 18 18 20
Total current assets 381 437 427 412 516 583 654 513 514 565
Non-current assets
Property, plant and equipment
Fixtures and equipment 168 184 218 242 275 315 341 378 487 503
Other properties 201 212 230 280 350 452 499 571 542 544
Property and equipment, at cost 369 396 448 522 625 768 840 949 1029 1047
Accumulated Depreciation -116 -181 -237 -295 -347 -392 -433 -504 -578 -642
Property, plant and equipment, net 253 215 211 227 278 376 408 444 451 405
Intangible assets 197 197 197 198 198 198 198 198 198 198
Deferred income taxes 6 12 17 18 12 21 8 7
Other long-term assets 29 20 21 13 10 8 6 2 14 13
Total non-current assets 479 433 435 450 503 599 624 665 671 622
Total assets 860 870 863 862 1019 1183 1278 1179 1185 1188
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 75
Accounts payable 147 151 86 134 176 155 154 150 173 146
Accrued liabilities 65 96 106 124 109 116 105 127 80 116
Deferred revenues 22 22 25 28 28 28 29 31 29 29
Other current liabilities 80 6
Total current liabilities 309 269 297 291 313 299 287 307 282 291
Non-current liabilities
Long-term debt 422 416 366 199 199 199 200
Other long-term liabilities 32 95 70 91 136 210 235 253 267 243
Total non-current liabilities 454 511 436 290 335 409 434 253 267 243
Total liabilities 763 780 733 581 648 708 722 561 550 534
Stockholders' equity
Common stock 1 1 1 1 1 1 1 1 1
Other Equity -4
Additional paid-in capital 172 106 77 88 105 131 150 170 185 199
Retained earnings -69 -18 52 193 332 448 517 633 691 710
Treasury stock 0 -67 -105 -108 -181 -237 -256
Accumulated other comprehensive income -6 0 0 -1 -3 -5
Total stockholders' equity 97 89 130 281 371 475 556 618 636 654
Total liabilities and stockholders' equity 860 870 863 862 1019 1183 1278 1179 1185 1188

EXPR Cash Flow (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 81 72 69 68 68 70 76 75 82 90 88
Amortization of debt discount/premium and issuance costs -9 -11 -13 -11 -13 -13
Investment/asset impairment charges 2 3 0 0 0 0 11 3 5 10 4
Deferred income taxes 0 0 -19 0 4 -1 6 -11 20 -1 -3
Stock based compensation 2 2 5 10 16 21 19 18 13 14 14
Accounts receivable 6 3 5
Inventory -6 -2 -14 -24 -2 2 -29 -15 14 -29 -2
Accounts payable -32 34 40 -16 -13 -60
Other working capital 7 15 2 12 44 -5 15 51 3 25 24
Other non-cash items -20 76 136 146 139 117 70 120 70 32 35
Net cash provided by operating activities 35 201 220 213 269 195 157 230 187 119 93
Cash Flows From Investing Activities
Investments in property, plant, and equipment -52 -27 -55 -77 -100 -105 -116 -115 -99 -57 -51
Purchases of investments -10
Purchases of intangibles -1 0 0 0 0 -1 0 0
Other investing charges 1 0 0 0 0 1 0 0 -9 -9
Net cash used for investing activities -52 -27 -55 -77 -100 -105 -116 -115 -109 -67 -60
Cash Flows From Financing Activities
Long-term debt issued 369 246
Long-term debt repayment -1 -82 -302 -170 0 0 -1 -200 -2 -2 -2
Excess tax benefit from stock based compensation 0 0 0 0
Repurchases of treasury stock 0 0 0 -67 -38 -4 -73 -56 -19 -36
Cash dividends paid -50
Other financing activities -495 -33 -107 -1 1 5 0 -1 -2 -2
Net cash provided by (used for) financing activities -127 -116 -212 -171 -66 -33 -5 -272 -58 -23 -39
Effect of exchange rate changes 0 0 -1 -1 -1 1 0 0
Net change in cash -144 58 -47 -35 104 56 34 -159 20 29 -6
Cash at beginning of period 320 176 234 188 152 256 312 346 187 207 191
Cash at end of period 176 234 188 152 256 312 346 187 207 236 185
Free Cash Flow
Operating cash flow 35 201 220 213 269 195 157 230 187 119 93
Capital expenditure -52 -27 -55 -77 -100 -105 -116 -115 -99 -57 -51
Free cash flow -17 174 165 135 169 90 40 114 88 61 42
Supplemental schedule of cash flow data
Cash paid for income taxes 72 -40 6
Cash paid for interest 26 18 18 18 9

URBN

URBN Income Statement (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 1835 1938 2274 2474 2795 3087 3323 3445 3546 3616 3711
Cost of revenue 1121 1152 1337 1613 1763 1925 2148 2243 2301 2441 2494
Gross profit 713 786 937 861 1032 1161 1175 1202 1245 1176 1216
Operating expenses
Sales, General and administrative 414 447 522 576 657 735 810 848 906 916 924
Total operating expenses 414 447 522 576 657 735 810 848 906 916 924
Operating income 299 339 414 285 374 427 365 354 339 260 293
Other income (expense) 10 5 3 4 1 1 -2 -4 -0 1 1
Income before income taxes 309 344 417 289 376 428 363 350 338 261 294
Provision for income taxes 110 125 144 104 138 145 131 126 120 153 156
Net income from continuing operations 199 220 273 185 237 282 232 224 218 108 138
Net income 199 220 273 185 237 282 232 224 218 108 138
Net income available to common shareholders 199 220 273 185 237 282 232 224 218 108 138
Earnings per share
Basic 1.2 1.31 1.64 1.2 1.63 1.92 1.7 1.79 1.87 0.97 1.25
Diluted 1.17 1.28 1.6 1.19 1.62 1.89 1.68 1.78 1.86 0.96 1.24
Weighted average shares outstanding
Basic 167 168 167 154 145 147 137 125 117 112 110
Diluted 171 171 170 156 147 149 138 126 117 112 111
EBITDA 381 431 515 393 493 559 503 496 474 388 419

URBN Balance Sheet (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 316 159 340 145 245 242 155 265 248 282
Short-term investments 50 343 116 90 228 282 104 61 111 165
Total cash 366 502 457 235 474 524 259 326 359 447
Receivables 36 38 37 37 40 55 70 76 55 77
Inventories 170 186 230 250 282 311 358 330 339 351
Deferred income taxes 6 12 14 5 15 29 19
Prepaid expenses 46 68 67 70 62 76 103 102 129 103
Total current assets 624 806 804 597 872 995 809 834 881 979
Non-current assets
Property, plant and equipment
Land 1 2 2 6 6 15 15 15 21 21
Fixtures and equipment 262 306 355 410 484 537 591 675 718 740
Other properties 599 669 753 886 966 1089 1217 1200 1240 1262
Property and equipment, at cost 861 977 1111 1302 1456 1641 1823 1890 1979 2024
Accumulated Depreciation -356 -437 -525 -617 -723 -834 -933 -1027 -1111 -1210
Property, plant and equipment, net 505 540 586 685 733 807 889 863 868 814
Equity and other investments 243 352 127 150 366 104 37 44 59
Deferred income taxes 44 46 52 75 42 53 86 99 109 102
Other long-term assets 155
Total non-current assets 705 830 990 887 925 1226 1080 999 1021 974
Total assets 1329 1636 1794 1484 1797 2221 1889 1833 1903 1953
Liabilities and stockholders' equity
Liabilities
Current liabilities
Accounts payable 63 78 83 96 99 137 156 118 120 128
Taxes payable 24 16 12 12 17 25 36
Accrued liabilities 34 111 128 31 24 32 30 22 34 27
Deferred revenues 34 37 44 48 52 55 56
Other current liabilities 44 49 74 106 108 120 120 113
Total current liabilities 141 189 211 233 250 332 354 329 353 360
Non-current liabilities
Long-term debt 150
Other long-term liabilities 134 151 172 184 192 195 207 217 237 292
Total non-current liabilities 134 151 172 184 192 195 207 367 237 292
Total liabilities 275 339 383 417 443 527 561 696 590 652
Stockholders' equity
Common stock 0 0 0 0 0 0 0 0 0 0
Additional paid-in capital 170 185 28 48 98 1
Retained earnings 901 1121 1394 1078 1315 1597 1343 1161 1347 1311
Accumulated other comprehensive income -18 -9 -10 -12 -9 -1 -15 -23 -34 -11
Total stockholders' equity 1054 1297 1412 1066 1355 1694 1328 1137 1313 1301
Total liabilities and stockholders' equity 1329 1636 1794 1484 1797 2221 1889 1833 1903 1953

URBN Cash Flow (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 82 92 101 108 119 133 138 143 135 128 127
Investment/asset impairment charges 9 4 11
Deferred income taxes -9 2 -9 -12 22 -29 -2 14 -5 8 5
Stock based compensation 5 11 3 11 16 17 16 18 15 14
Accounts receivable 0 -3 -15 -18 -14 21 -22 -5
Inventory 0 -16 -43 -21 -32 -28 -69 27 -10 -9 -43
Prepaid expenses 9 -26 15 6 16 3 -23 4 -10 13 12
Other working capital -20 53 50 21 32 68 49 -4 40 46 79
Other non-cash items 190 214 260 177 231 275 232 220 221 112 154
Net cash provided by operating activities 252 325 385 283 396 423 322 413 415 303 344
Cash Flows From Investing Activities
Investments in property, plant, and equipment -113 -109 -144 -190 -169 -186 -230 -135 -144 -84 -85
Acquisitions, net -15
Purchases of investments -809 -807 -463 -169 -373 -728 -406 -266 -319 -281 -283
Sales/Maturities of investments 865 421 571 415 208 452 830 374 243 244 236
Net cash used for investing activities -57 -495 -36 55 -334 -462 195 -27 -235 -121 -132
Cash Flows From Financing Activities
Long-term debt issued 292
Long-term debt repayment -142 -150
Excess tax benefit from stock based compensation 6 13 9 7 10 4 6 0
Common stock issued 9
Repurchases of treasury stock -205 -545 -11 -615 -475 -48 -159 -163
Other financing activities 13 3 24 4 31 35 11 46 4 5
Net cash provided by (used for) financing activities 22 10 -168 -532 37 34 -601 -273 -193 -159 -158
Effect of exchange rate changes -6 3 -1 -1 1 2 -4 -3 -4 12 7
Net change in cash 211 -157 181 -195 100 -3 -88 111 -17 34 61
Cash at beginning of period 105 316 159 340 145 245 242 155 265 248 252
Cash at end of period 316 159 340 145 245 242 155 265 248 282 314
Free Cash Flow
Operating cash flow 252 325 385 283 396 423 322 413 415 303 344
Capital expenditure -113 -109 -144 -190 -169 -186 -230 -135 -144 -84 -85
Free cash flow 139 216 241 93 227 237 93 278 271 219 259
Supplemental schedule of cash flow data
Cash paid for income taxes 137 121 121 103 160 145 99 112 84 80

GCO

GCO Income Statement (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 1552 1574 1790 2292 2605 2625 2860 3022 2868 2907 2909
Cost of revenue 772 778 888 1138 1306 1326 1459 1579 1451 1491 1490
Gross profit 780 796 902 1154 1298 1299 1400 1443 1418 1416 1419
Operating expenses
Sales, General and administrative 713 722 807 1008 1113 1134 1231 1284 1276 1321 1327
Total operating expenses 713 722 807 1008 1113 1134 1231 1284 1276 1321 1327
Operating income 67 74 95 147 185 165 170 159 141 95 92
Interest Expense 10 4 1 5 5 5 3 4 5 5 5
Other income (expense) 197 -19 -9 -3 -17 -1 -9 -3 16 -191 -192
Income before income taxes 254 50 85 139 163 159 157 152 151 -102 -106
Provision for income taxes 96 21 30 56 52 66 58 56 54 10 9
Net income from continuing operations 158 29 55 83 111 93 99 95 98 -111 -115
Net income from discontinuing ops -5 -0 -1 -1 -0 -0 -2 -1 -0 -0 -0
Net income 153 29 53 82 111 93 98 95 97 -112 -115
Net income available to common shareholders 153 29 53 82 111 93 98 95 97 -112 -115
Earnings per share
Basic 7.93 1.33 2.28 3.52 4.68 3.98 4.16 4.13 4.85 -5.82 -5.99
Diluted 6.49 1.3 2.24 3.43 4.6 3.92 4.12 4.11 4.83 -5.82 -5.99
Weighted average shares outstanding
Basic 19 21 23 23 24 23 24 23 20 19 19
Diluted 24 24 24 24 24 24 24 23 20 19 19
EBITDA 310 102 134 198 232 231 235 235 232 -18 -22

GCO Balance Sheet (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 18 82 56 54 60 59 113 133 48 40
Total cash 18 82 56 54 60 59 113 133 48 40
Receivables 24 27 45 44 48 53 55 47 44 43
Inventories 306 291 360 435 505 567 598 530 564 543
Deferred income taxes 15 17 19 23 24 23 28 29 21
Prepaid expenses 36 32 34 40 45 54 53 61 61 67
Total current assets 398 450 513 595 682 757 848 800 738 693
Non-current assets
Property, plant and equipment
Land 5 5 5 6 6 6 8 8 8 8
Fixtures and equipment 179 188 198 245 270 305 357 393 392 392
Other properties 300 299 306 327 347 391 408 428 453 554
Property and equipment, at cost 484 492 509 578 623 703 772 829 852 954
Accumulated Depreciation -244 -276 -311 -350 -382 -423 -466 -506 -521 -572
Property, plant and equipment, net 240 216 199 228 242 280 306 323 331 383
Goodwill 112 119 153 260 274 288 297 281 271 100
Intangible assets 54 56 65 93 89 87 94 90 87 90
Deferred income taxes 7 14 19 28 26 3 0 1 0 25
Other long-term assets 8 8 12 33 21 24 39 45 22 25
Total non-current assets 420 414 448 642 652 682 735 741 711 622
Total assets 818 864 961 1237 1334 1439 1583 1541 1449 1315
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 9 6 7 13 14 9 2
Accounts payable 73 93 117 139 118 145 176 154 171 141
Taxes payable 1 13 16 29 28 47 41 31 18
Accrued liabilities 56 68 94 79 116 118 71 79 64 93
Other current liabilities 9 9 10 61 7 7 99 35 34 2
Total current liabilities 139 170 234 304 276 306 406 324 309 255
Non-current liabilities
Long-term debt 119 32 45 27 16 98 74 87
Pensions and other benefits 26 20 12 22 21 9 22 10 6
Minority interest 3 2 2 2 2 2 1 2
Other long-term liabilities 88 91 88 161 182 179 140 153 137 143
Total non-current liabilities 232 112 102 217 249 218 180 263 218 231
Total liabilities 371 281 337 522 525 523 586 586 528 486
Stockholders' equity
Preferred stock 5 5 5 5 4 1 1 1 1 1
Common stock 20 25 24 25 24 24 25 22 20 20
Additional paid-in capital 38 147 132 149 170 191 209 224 238 251
Retained earnings 432 452 505 587 656 735 821 768 731 604
Treasury stock -18 -18 -18 -18 -18 -18 -18 -18 -18 -18
Accumulated other comprehensive income -31 -29 -24 -33 -28 -17 -41 -43 -51 -29
Total stockholders' equity 447 582 624 715 809 916 997 955 921 829
Total liabilities and stockholders' equity 818 864 961 1237 1334 1439 1583 1541 1449 1315

GCO Cash Flow (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 47 47 48 54 64 67 74 79 76 78 78
Amortization of debt discount/premium and issuance costs 2 0 1 1 1 1 1 1 1
Investment/asset impairment charges 9 13 7 1 1 2 9 3 6 185 186
Deferred income taxes 8 4 -12 -2 -23 11 2 -2 5 -16 -15
Stock based compensation 8 7 8 8 11 12
Accounts receivable 2 -2 -12 3 -6 -4 -1 -7 1 1 4
Inventory -3 24 -44 -42 -61 -58 -31 28 -45 32 31
Prepaid expenses -13 3 0 5 -5 -9 0 -9 -2 -4 -5
Accounts payable -8 11 14 -1 -18 20 28 3 25 -7 2
Accrued liabilities -18 2 42 9 -7 -10 53 -71 -16 -22 -13
Other working capital 12 -6 -4 23 52 13 -60 11 10 13 12
Other non-cash items 136 37 56 87 114 94 115 109 101 -95 -97
Net cash provided by operating activities 179 142 103 145 123 140 190 145 162 165 183
Cash Flows From Investing Activities
Investments in property, plant, and equipment -49 -34 -29 -49 -72 -98 -103 -101 -94 -128 -117
Property, plant, and equipment reductions 0 0 0
Acquisitions, net -4 -12 -76 -93 -24 -14 -35 -35 23 0
Other investing charges 0 0 0 0 60 1
Net cash used for investing activities -54 -46 -105 -142 -95 -112 -138 -76 -71 -128 -116
Cash Flows From Financing Activities
Short-term borrowing 2 3 4 3 -3 3 -1 -8 -22 -33
Long-term debt issued 295 197 107 300 440 417 307 429 341 516 443
Long-term debt repayment -334 -233 -109 -320 -430 -436 -313 -336 -364 -518 -481
Excess tax benefit from stock based compensation 0 1
Redemption of preferred stock -1
Repurchases of treasury stock -91 -27 -38 -21 -5 -138 -140 -18 -2
Cash dividends paid 0 0 0 0 0 0
Other financing activities 1 0 -1 14 10 11 5 -2 -2 -4 -9
Net cash provided by (used for) financing activities -125 -32 -24 -4 -22 -30 -1 -48 -174 -47 -81
Effect of exchange rate changes -1 0 2 3 -1 -1 2 2
Net change in cash 0 64 -26 -2 6 0 53 20 -85 -8 -12
Cash at beginning of period 18 18 82 56 54 60 59 113 133 48 43
Cash at end of period 18 82 56 54 60 59 113 133 48 40 31
Free Cash Flow
Operating cash flow 179 142 103 145 123 140 190 145 162 165 183
Capital expenditure -49 -34 -29 -49 -72 -98 -103 -101 -94 -128 -117
Free cash flow 130 108 73 96 51 42 87 44 68 37 66
Supplemental schedule of cash flow data
Cash paid for income taxes 92 13 24 50 82 53 43 59 52 37 36
Cash paid for interest 9 2 1 5 4 4 3 3 4 5 5

CATO

CATO Income Statement (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 858 884 926 931 944 920 987 1011 957 850 849
Cost of revenue 562 552 566 574 582 571 601 616 602 553 550
Gross profit 296 332 360 357 362 349 386 395 355 297 299
Operating expenses
Sales, General and administrative 228 245 251 239 244 246 276 276 290 266 268
Other operating expenses 23 22 22 22 22 22 22 23 23 20 19
Total operating expenses 250 267 273 261 267 268 298 299 312 286 287
Operating income 45 65 87 96 95 81 88 96 42 11 12
Interest Expense 0 0 0 0 0 0 0 0 0 0
Other income (expense) 7 4 4 4 4 3 3 3 7 5 5
Income before income taxes 53 69 91 100 99 84 91 99 49 16 16
Provision for income taxes 19 23 33 35 37 30 31 32 2 7 7
Net income from continuing operations 34 46 58 65 62 54 61 67 47 9 10
Net income 34 46 58 65 62 54 61 67 47 9 10
Preferred dividend 1 1 0 0
Net income available to common shareholders 34 46 58 65 62 54 61 65 46 8 9
Earnings per share
Basic 1.16 1.55 1.96 2.21 2.11 1.86 2.15 2.39 1.72 0.34 0.43
Diluted 1.15 1.55 1.96 2.21 2.11 1.86 2.15 2.39 1.72 0.34 0.43
Weighted average shares outstanding
Basic 29 29 29 29 29 29 28 27 27 25 25
Diluted 29 29 29 29 29 29 28 27 27 25 25
EBITDA 75 91 113 122 122 106 114 122 72 36 36

CATO Balance Sheet (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 42 50 49 35 31 79 94 67 47 78
Short-term investments 103 148 181 206 158 161 162 215 201 119
Total cash 145 198 230 241 189 241 256 283 248 197
Receivables 44 40 40 43 40 39 41 37 30 28
Inventories 112 119 132 130 141 151 138 141 146 122
Deferred income taxes 6 8 5 4 5 5 4
Prepaid expenses 8 3 3 6 10 7 11 7 16 22
Other current assets 3 5 5 6 5 4 4 4 4
Total current assets 315 371 415 429 390 447 454 472 444 372
Non-current assets
Property, plant and equipment
Land 4 4 4 7 7 8 8 14 14 14
Fixtures and equipment 215 218 226 239 257 268 275 262 274 276
Other properties 76 77 83 102 121 134 139 144 138 129
Property and equipment, at cost 294 299 313 348 386 409 422 420 425 419
Accumulated Depreciation -178 -196 -214 -232 -251 -268 -286 -282 -299 -310
Property, plant and equipment, net 116 103 100 115 134 141 135 138 126 109
Equity and other investments 19 21 21
Deferred income taxes 1 3 10 14 13
Other long-term assets 4 7 8 7 8 8 15 2 2 1
Total non-current assets 120 110 107 122 142 150 154 170 163 144
Total assets 435 481 522 551 533 597 608 642 606 516
Liabilities and stockholders' equity
Liabilities
Current liabilities
Accounts payable 103 104 106 94 99 112 112 113 105 83
Taxes payable 12 11 12 15 28 30 30 32 20 18
Accrued liabilities 36 54 58 48 32 30 24 36 44 35
Other current liabilities 5 27 12 3 3
Total current liabilities 151 168 176 157 160 177 194 193 172 139
Non-current liabilities
Deferred taxes liabilities 3 4 6 8 3
Other long-term liabilities 20 17 15 20 24 29 34 37 51 51
Total non-current liabilities 23 21 21 27 28 29 34 37 51 51
Total liabilities 174 190 197 184 187 206 228 230 222 190
Stockholders' equity
Common stock 1 1 1 1 1 1 1 1 1 1
Additional paid-in capital 62 65 69 72 77 80 85 90 95 100
Retained earnings 354 225 256 293 267 309 293 321 288 226
Treasury stock -156
Accumulated other comprehensive income 0 1 0 1 1 1 1 1 0 0
Total stockholders' equity 262 291 326 367 345 391 380 413 384 326
Total liabilities and stockholders' equity 435 481 522 551 533 597 608 642 606 516

CATO Cash Flow (annual)

2009-01 2010-01 2011-01 2012-01 2013-01 2014-01 2015-01 2016-01 2017-01 2018-01 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 23 22 22 22 22 22 22 23 23 20 19
Investment/asset impairment charges 2 3 2 2 14 8
Deferred income taxes 1 0 5 -2 -6 -5 -2 -3 -3 1 0
Stock based compensation 2 2 2 3 3 3 4 4 4 4 4
Accounts receivable -3 0 -2 -5 2 0 -3 4 5 2 -5
Inventory 6 -6 -13 14 -10 -10 13 -4 -5 24 24
Prepaid expenses 1 1 0 -2 -6 3 -6 2 -10 -7 2
Income taxes payable 4 0 1 4 0 1 0 1 1 -2
Other working capital -4 15 4 -18 9 21 25 0 -8 -29 -16
Other non-cash items 41 51 61 67 64 56 62 64 51 15 23
Net cash provided by operating activities 72 85 79 81 80 93 117 94 72 36 52
Cash Flows From Investing Activities
Investments in property, plant, and equipment -19 -10 -20 -36 -45 -32 -29 -27 -27 -11 -8
Purchases of investments -170 -163 -145 -109 -109 -65 -50 -117 -111 -16 -42
Sales/Maturities of investments 160 108 111 86 157 63 49 67 123 94 70
Other investing charges 7 -2 0 -1 1 2 -5 0 -1 0
Net cash used for investing activities -29 -58 -56 -60 2 -33 -28 -82 -15 67 19
Cash Flows From Financing Activities
Short-term borrowing 0
Long-term debt issued 30
Long-term debt repayment -30
Excess tax benefit from stock based compensation 0 0 0 0 1 0 0 0 0
Common stock issued 0 0 0 0 1 0 1
Repurchases of treasury stock -2 0 -6 -11 0 -6 -42 -6 -43 -39 -19
Cash dividends paid -19 -19 -21 -26 -87 -6 -34 -34 -35 -34 -33
Other financing activities 0 0 1 0 0 0 0 0 1 1 1
Net cash provided by (used for) financing activities -22 -18 -26 -35 -86 -12 -75 -39 -77 -72 -52
Effect of exchange rate changes 0
Net change in cash 21 8 -2 -14 -4 48 15 -27 -20 31 19
Cash at beginning of period 22 42 50 49 35 31 79 94 67 47 55
Cash at end of period 42 50 49 35 31 79 94 67 47 78 74
Free Cash Flow
Operating cash flow 72 85 79 81 80 93 117 94 72 36 52
Capital expenditure -19 -10 -20 -36 -45 -32 -29 -27 -27 -11 -8
Free cash flow 52 75 60 45 35 61 89 67 45 25 44
Supplemental schedule of cash flow data

Appendix 2. Financial Reports (Quarterly)

In [4]:
for ticker in tickers:
    I_FILE = './{} Income Statement Q.csv'.format(ticker)
    BS_FILE = './{} Balance Sheet Q.csv'.format(ticker)
    CF_FILE = './{} Cash Flow Q.csv'.format(ticker)
    
    display(Markdown("### {}".format(ticker)))
        
    i_df = pd.read_csv(I_FILE, index_col=0, header=1, mangle_dupe_cols=True)
    i_df = i_df.replace(np.nan, '', regex=True)
    bs_df = pd.read_csv(BS_FILE, index_col=0, header=1)
    bs_df = bs_df.replace(np.nan, '', regex=True)
    cf_df = pd.read_csv(CF_FILE, index_col=0, header=1)
    cf_df = cf_df.replace(np.nan, '', regex=True)
    
    display(Markdown("#### {} Income Statement (quarterly)".format(ticker)))
    display(i_df)

    print("\n\n")
    display(Markdown("#### {} Balance Sheet (quarterly)".format(ticker)))
    display(bs_df)

    print("\n\n")
    display(Markdown("#### {} Cash Flow (quarterly)".format(ticker)))
    display(cf_df)

ACIA

ACIA Income Statement (quarterly)

2015-12 2016-03 2016-06 2016-09 2016-12 2017-03 2017-06 2017-09 2017-12 2018-03 TTM
Fiscal year ends in December. USD in millions except per share data.
Revenue 69 84 116 135 142 115 79 105 87 73 343
Cost of revenue 37 49 62 72 74 58 54 59 47 49 208
Gross profit 31 35 54 63 68 56 25 46 40 24 136
Operating expenses
Research and development 12 15 22 19 20 18 23 27 24 24 99
Sales, General and administrative 5 4 9 8 7 9 9 10 11 14 44
Total operating expenses 17 19 30 26 27 26 32 37 35 39 143
Operating income 14 16 23 37 41 30 -7 9 5 -15 -8
Other income (expense) 0 0 -4 0 0 0 1 1 1 1 4
Income before taxes 14 16 20 37 42 30 -6 10 6 -13 -3
Provision for income taxes -9 2 2 2 -23 -5 -11 -9 26 -4 3
Net income from continuing operations 23 15 18 35 64 36 5 18 -20 -9 -6
Net income 23 15 18 35 64 36 5 18 -20 -9 -6
Preferred dividend -17 0 1
Net income available to common shareholders 40 14 17 35 64 36 5 18 -20 -9 -6
Earnings per share
Basic 0.46 0.51 0.97 1.82 0.93 0.12 0.47 -0.53 -0.23 -0.17
Diluted 0.43 0.43 0.86 1.58 0.86 0.11 0.44 -0.53 -0.23 -0.17
Weighted average shares outstanding
Basic 31 21 36 38 38 39 39 39 40 39
Diluted 33 24 41 43 42 42 42 42 40 41
EBITDA 16 18 26 40 44 33 -4 12 8 -11 5

ACIA Balance Sheet (quarterly)

2015-12 2016-03 2016-06 2016-09 2016-12 2017-03 2017-06 2017-09 2017-12 2018-03
Fiscal year ends in December. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 28 33 159 123 206 140 106 116 67 85
Short-term investments 53 104 132 176 173 212 223
Total cash 28 33 159 176 310 271 282 289 279 308
Receivables 41 64 78 102 108 115 83 96 87 75
Inventories 28 26 23 29 32 34 42 50 62 57
Prepaid expenses 3 4 2 4 12 18 19 17 19 19
Other current assets 3 2 1 2 0 0 0 0 0
Total current assets 103 129 263 312 462 438 426 452 447 459
Non-current assets
Property, plant and equipment
Gross property, plant and equipment 27 33 36 39 42 47 47 50 56 62
Accumulated Depreciation -11 -13 -15 -18 -17 -19 -22 -25 -28 -31
Net property, plant and equipment 16 20 21 21 25 27 26 25 28 30
Equity and other investments 50 60 59 85 60
Deferred income taxes 11 12 12 16 24 25 37 47 42 45
Other long-term assets 0 0 0 3 6 8 9 9 9 9
Total non-current assets 27 33 33 40 55 111 133 140 164 144
Total assets 131 161 296 352 517 548 559 593 611 603
Liabilities and stockholders' equity
Liabilities
Current liabilities
Accounts payable 25 38 49 48 49 37 35 38 48 35
Taxes payable 1 1 2 9 1 1 0 1 0
Accrued liabilities 11 12 12 16 21 22 20 25 23 27
Deferred revenues 8 8 7 8 1 2 2 1 1 1
Other current liabilities 4 5 5 6 8 9 10 10 14 16
Total current liabilities 48 64 74 88 81 71 68 76 86 79
Non-current liabilities
Other long-term liabilities 74 1 1 2 1 2 2 2 24 24
Total non-current liabilities 74 1 1 2 1 2 2 2 24 24
Total liabilities 123 64 75 89 82 72 70 78 109 103
Stockholders' equity
Common stock 0 0 0 0 0 0 0 0 0 0
Additional paid-in capital 75 182 188 296 301 310 317 325 332
Retained earnings 8 22 40 74 139 175 179 198 177 169
Accumulated other comprehensive income 0 0 0 0 0 0 -1
Total stockholders' equity 8 97 221 262 435 476 489 514 502 500
Total liabilities and stockholders' equity 131 161 296 352 517 548 559 593 611 603

ACIA Cash Flow (quarterly)

2015-12 2016-03 2016-06 2016-09 2016-12 2017-03 2017-06 2017-09 2017-12 2018-03 TTM
Fiscal year ends in December. USD in millions except per share data.
Cash Flows From Operating Activities
Net income 23 15 18 35 64 36 5 18 -20 -9 -6
Depreciation & amortization 1 2 2 3 3 3 3 3 3 3 13
Deferred income taxes -1 0 -5 -7 -1 -12 -10 5 -3 -20
Stock based compensation 0 0 9 7 5 5 6 6 6 7 25
Change in working capital 1 -4 -2 -18 -28 -26 21 -11 24 12 46
Accounts receivable 11 -23 -14 -24 -6 -7 32 -13 9 12 40
Inventory -8 2 2 -6 -2 -2 -8 -8 -12 5 -23
Prepaid expenses 0 0 -1 -2 -8 -5 -1 1 -2 -1 -2
Accounts payable -6 13 10 1 -1 -12 -1 2 8 -12 -3
Accrued liabilities 0 2 1 13 -2 2 -1 5 1 6 11
Income taxes payable -2
Other working capital 3 2 0 -1 -8 -2 0 0 21 4 23
Other non-cash items -11 0 4 0 0 0 0 0 0 0 0
Net cash provided by operating activities 14 12 31 21 37 16 22 7 18 9 58
Cash Flows From Investing Activities
Investments in property, plant, and equipment -4 -6 -2 -4 -5 -6 -2 -2 -4 -7 -15
Purchases of investments -66 -117 -117 -73 -130 -74 -393
Sales/Maturities of investments 39 61 77 65 88 292
Other investing activities 0 0 -53 14 0 0 0 0 0
Net cash used for investing activities -4 -6 -2 -57 -56 -83 -58 2 -69 8 -117
Cash Flows From Financing Activities
Debt repayment 0 0 0
Common stock issued 0 119 1 2 0 2 1 6
Common stock repurchased -1 -1 0 0
Other financing activities -1 0 97 -15 0
Net cash provided by (used for) financing activities -1 0 97 -1 103 1 2 0 2 1 6
Effect of exchange rate changes 0 0 0
Net change in cash 10 5 126 -36 83 -67 -34 10 -48 18 -53
Cash at beginning of period 18 28 33 159 123 206 140 106 116 67 140
Cash at end of period 28 33 159 123 206 140 106 116 67 85 87
Free Cash Flow
Operating cash flow 14 12 31 21 37 16 22 7 18 9 58
Capital expenditure -4 -6 -2 -4 -5 -6 -2 -2 -4 -7 -15
Free cash flow 11 6 29 17 32 10 20 5 14 2 43

EXPR

EXPR Income Statement (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 766 503 505 506 679 467 479 499 694 479 2143
Cost of revenue 505 335 354 354 486 340 347 350 486 336 1517
Gross profit 261 168 151 152 193 127 131 149 208 143 626
Operating expenses
Sales, General and administrative 167 136 133 137 154 130 132 138 163 141 570
Other operating expenses -0 0 0 -1 -0 1 -0 -0
Total operating expenses 167 136 133 137 154 130 131 137 164 140 570
Operating income 93 32 18 15 39 -3 0 11 44 3 56
Other income (expense) -2 -11 -1 -1 -1 -7 -17 -1 -0 -0 -18
Income before income taxes 91 21 17 14 38 -11 -16 11 44 3 38
Provision for income taxes 35 8 7 3 15 -6 -4 4 15 2 16
Net income from continuing operations 56 13 10 12 23 -5 -12 6 29 1 23
Net income 56 13 10 12 23 -5 -12 6 29 1 23
Net income available to common shareholders 56 13 10 12 23 -5 -12 6 29 1 23
Earnings per share
Basic 0.67 0.16 0.13 0.15 0.29 -0.06 -0.15 0.08 0.38 0.01 0.29
Diluted 0.67 0.16 0.13 0.15 0.29 -0.06 -0.15 0.08 0.38 0.01 0.29
Weighted average shares outstanding
Basic 83 79 79 78 78 78 79 79 78 75 78
Diluted 83 80 79 79 79 78 79 79 79 76 78
EBITDA 112 49 37 38 62 19 23 34 67 24 144

EXPR Balance Sheet (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 187 111 120 102 207 191 173 198 236 185
Total cash 187 111 120 102 207 191 173 198 236 185
Receivables 22 17 16 16 16 16 15 16 12 11
Inventories 255 281 257 342 241 287 261 343 266 278
Prepaid expenses 31 31 32 31 32 31 30 31 31 30
Other current assets 18 20 27 22 18 22 31 29 20 26
Total current assets 513 459 450 513 514 548 511 617 565 529
Non-current assets
Property, plant and equipment
Fixtures and equipment 378 487 503
Other properties 571 959 991 1017 542 1039 1030 1039 544 1052
Property and equipment, at cost 949 959 991 1017 1029 1039 1030 1039 1047 1052
Accumulated Depreciation -504 -511 -530 -551 -578 -599 -598 -618 -642 -658
Property, plant and equipment, net 444 447 462 467 451 440 432 421 405 394
Intangible assets 198 198 198 198 198 198 198 198 198 198
Deferred income taxes 21 21 22 22 8 8 8 8 7 7
Other long-term assets 2 2 12 13 14 13 13 13 13 13
Total non-current assets 665 668 693 698 671 659 650 640 622 612
Total assets 1179 1128 1143 1212 1185 1207 1161 1257 1188 1141
Liabilities and stockholders' equity
Liabilities
Current liabilities
Accounts payable 150 146 162 223 173 198 166 229 146 126
Accrued liabilities 127 169 166 167 80 112 113 118 116 107
Deferred revenues 31 28 23 25 29 25 23 22 29 38
Total current liabilities 307 343 352 415 282 335 302 369 291 270
Non-current liabilities
Other long-term liabilities 253 191 195 186 267 238 230 249 243 237
Total non-current liabilities 253 191 195 186 267 238 230 249 243 237
Total liabilities 561 534 546 601 550 573 532 618 534 507
Stockholders' equity
Common stock 1 1 1 1 1 1 1 1 1 1
Other Equity -4 -4
Additional paid-in capital 170 177 180 183 185 189 193 196 199 203
Retained earnings 633 646 656 668 691 686 674 681 710 705
Treasury stock -181 -227 -237 -237 -237 -239 -239 -239 -256 -274
Accumulated other comprehensive income -5 -3 -4 -4
Total stockholders' equity 618 594 596 611 636 633 629 639 654 634
Total liabilities and stockholders' equity 1179 1128 1143 1212 1185 1207 1161 1257 1188 1141

EXPR Cash Flow (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 19 17 20 23 23 23 22 23 22 21 88
Amortization of debt discount/premium and issuance costs -4 9 -3 -3 -14 -3 -3 -3 -3 -3 -13
Investment/asset impairment charges 3 4 6 0 4 4
Deferred income taxes -4 0 0 0 20 1 0 0 -2 0 -3
Stock based compensation 3 4 3 3 2 4 3 4 3 4 14
Accounts receivable 0 1 -1 4 1 5
Inventory 109 -26 25 -85 101 -46 22 -81 76 -17 -2
Accounts payable 21 -26 67 -75 -30 -60
Other working capital -9 -33 6 65 -44 1 -10 24 10 -2 24
Other non-cash items 56 13 12 12 34 -4 -1 6 31 1 35
Net cash provided by operating activities 174 -16 62 14 127 1 9 37 71 -25 93
Cash Flows From Investing Activities
Investments in property, plant, and equipment -30 -18 -32 -31 -18 -15 -16 -12 -15 -8 -51
Other investing charges -10 -9 -9
Net cash used for investing activities -30 -18 -42 -31 -18 -15 -25 -12 -15 -8 -60
Cash Flows From Financing Activities
Long-term debt repayment 0 0 0 0 0 0 0 0 0 0 -2
Excess tax benefit from stock based compensation 0
Repurchases of treasury stock -47 -46 -10 0 0 -2 0 0 -17 -18 -36
Other financing activities 0 3 0 -3 0 -2 0 -2
Net cash provided by (used for) financing activities -47 -44 -10 0 -4 -2 -2 0 -18 -19 -39
Effect of exchange rate changes -1 2 -1 0 0 0 0 0 0
Net change in cash 96 -76 9 -18 106 -16 -18 25 38 -52 -6
Cash at beginning of period 91 187 111 120 102 207 191 173 198 236 191
Cash at end of period 187 111 120 102 207 191 173 198 236 185 185
Free Cash Flow
Operating cash flow 174 -16 62 14 127 1 9 37 71 -25 93
Capital expenditure -30 -18 -32 -31 -18 -15 -16 -12 -15 -8 -51
Free cash flow 144 -34 30 -17 109 -14 -6 25 56 -33 42
Supplemental schedule of cash flow data

URBN

URBN Income Statement (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 1013 763 891 862 1030 761 873 893 1089 856 3711
Cost of revenue 664 501 548 563 690 521 576 595 748 575 2494
Gross profit 349 262 343 300 340 240 297 298 341 281 1216
Operating expenses
Sales, General and administrative 233 211 224 230 241 219 222 225 250 227 924
Total operating expenses 233 211 224 230 241 219 222 225 250 227 924
Operating income 116 50 118 70 100 21 75 73 91 54 293
Other income (expense) -1 -2 1 1 -1 0 2 -1 0 0 1
Income before income taxes 116 49 119 71 99 21 77 72 91 54 294
Provision for income taxes 43 19 42 24 34 9 27 27 90 13 156
Net income from continuing operations 73 30 77 47 64 12 50 45 1 41 138
Net income 73 30 77 47 64 12 50 45 1 41 138
Net income available to common shareholders 73 30 77 47 64 12 50 45 1 41 138
Earnings per share
Basic 0.6 0.25 0.66 0.41 0.56 0.1 0.44 0.41 0.02 0.38 1.25
Diluted 0.6 0.25 0.66 0.4 0.55 0.1 0.44 0.41 0.02 0.38 1.24
Weighted average shares outstanding
Basic 118 117 117 117 116 116 114 110 108 108 110
Diluted 119 118 117 117 117 117 114 110 109 110 111
EBITDA 152 85 152 103 134 53 108 105 122 84 419

URBN Balance Sheet (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 265 228 243 235 248 252 277 235 282 314
Short-term investments 61 60 59 25 111 118 110 93 165 166
Total cash 326 288 302 260 359 371 387 328 447 480
Receivables 76 72 95 69 55 84 76 78 77 89
Inventories 330 360 367 454 339 359 365 450 351 405
Prepaid expenses 102 90 95 108 129 110 110 111 103 124
Total current assets 834 810 859 890 881 925 938 967 979 1097
Non-current assets
Property, plant and equipment
Land 15 21 21
Fixtures and equipment 675 718 740
Other properties 1200 1240 1262
Property and equipment, at cost 1890 1979 2024
Accumulated Depreciation -1027 -1111 -1210
Property, plant and equipment, net 863 872 879 872 868 851 843 829 814 820
Equity and other investments 37 19 26 6 44 38 26 41 59 35
Deferred income taxes 99 115 110 117 109 114 116 116 102 99
Total non-current assets 999 1005 1015 995 1021 1003 985 986 974 954
Total assets 1833 1815 1874 1885 1903 1928 1923 1953 1953 2051
Liabilities and stockholders' equity
Liabilities
Current liabilities
Accounts payable 118 152 135 199 120 157 160 209 128 159
Taxes payable 17 25 36
Accrued liabilities 22 190 222 206 34 196 210 215 27 256
Deferred revenues 52 55 56
Other current liabilities 120 120 113
Total current liabilities 329 342 357 405 353 353 370 423 360 415
Non-current liabilities
Long-term debt 150 75 50
Other long-term liabilities 217 223 222 232 237 242 244 246 292 290
Total non-current liabilities 367 298 272 232 237 242 244 246 292 290
Total liabilities 696 641 629 638 590 595 614 669 652 705
Stockholders' equity
Common stock 0 0 0 0 0 0 0 0 0 0
Additional paid-in capital 7 7 1 6
Retained earnings 1161 1188 1265 1285 1347 1358 1332 1310 1311 1359
Accumulated other comprehensive income -23 -14 -27 -38 -34 -32 -23 -25 -11 -19
Total stockholders' equity 1137 1174 1245 1248 1313 1333 1309 1285 1301 1346
Total liabilities and stockholders' equity 1833 1815 1874 1885 1903 1928 1923 1953 1953 2051

URBN Cash Flow (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 36 35 34 33 34 32 33 32 31 30 127
Deferred income taxes 13 -3 4 -12 6 -4 -1 0 13 -7 5
Stock based compensation 3 6 7 7 -2 6 8 0 1 6 14
Accounts receivable -8 4 -23 26 15 -29 9 -3 2 -12 -5
Inventory 110 -27 -10 -90 117 -20 -4 -85 101 -54 -43
Prepaid expenses -16 13 -6 -15 -3 2 0 0 10 2 12
Other working capital -36 13 8 70 -51 13 14 56 -38 47 79
Other non-cash items 83 30 78 49 69 12 51 46 13 43 154
Net cash provided by operating activities 185 70 91 68 186 13 110 46 133 54 344
Cash Flows From Investing Activities
Investments in property, plant, and equipment -26 -31 -43 -38 -32 -24 -19 -20 -20 -25 -85
Acquisitions, net -15
Purchases of investments -52 -37 -58 -57 -166 -50 -66 -58 -106 -52 -283
Sales/Maturities of investments 78 57 52 109 25 65 88 57 34 57 236
Net cash used for investing activities 0 -27 -49 15 -173 -9 2 -21 -93 -19 -132
Cash Flows From Financing Activities
Long-term debt issued 100
Long-term debt repayment -65 -75 -25 -50
Excess tax benefit from stock based compensation 0 0 0 0 0
Repurchases of treasury stock -100 -11 -37 0 -1 -91 -68 0 -5 -163
Other financing activities 2 0 1 5 5
Net cash provided by (used for) financing activities -65 -83 -25 -86 0 -1 -91 -68 0 0 -158
Effect of exchange rate changes -4 3 -2 -5 1 1 2 1 7 -3 7
Net change in cash 116 -37 15 -8 13 4 24 -42 47 31 61
Cash at beginning of period 150 265 228 243 235 248 252 277 235 282 252
Cash at end of period 265 228 243 235 248 252 277 235 282 314 314
Free Cash Flow
Operating cash flow 185 70 91 68 186 13 110 46 133 54 344
Capital expenditure -26 -31 -43 -38 -32 -24 -19 -20 -20 -25 -85
Free cash flow 159 39 48 30 154 -11 91 26 113 29 259
Supplemental schedule of cash flow data
Cash paid for income taxes 39 10 31 44 27 7 35 20 23 2 80

GCO

GCO Income Statement (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 932 649 626 711 883 643 617 717 930 645 2909
Cost of revenue 509 319 311 355 466 324 310 363 494 323 1490
Gross profit 423 330 315 356 417 319 307 354 437 322 1419
Operating expenses
Sales, General and administrative 349 308 303 315 351 316 308 323 374 322 1327
Total operating expenses 349 308 303 315 351 316 308 323 374 322 1327
Operating income 74 21 12 41 67 3 -2 31 63 -0 92
Interest Expense 1 1 1 1 1 1 1 1 2 1 5
Other income (expense) 1 -4 10 -1 9 -0 -0 -184 -7 -2 -192
Income before income taxes 74 17 21 39 75 2 -3 -154 54 -3 -106
Provision for income taxes 29 6 7 13 28 1 1 11 -2 -1 9
Net income from continuing operations 45 11 15 26 47 1 -4 -165 56 -2 -115
Net income from discontinuing ops -0 -0 0 -0 -0 -0 -0 -0 -0 -0 -0
Net income 45 10 15 26 47 1 -4 -165 56 -2 -115
Net income available to common shareholders 45 10 15 26 47 1 -4 -165 56 -2 -115
Earnings per share
Basic 1.99 0.5 0.72 1.3 2.34 0.05 -0.21 -8.56 2.92 -0.12 -5.99
Diluted 1.98 0.5 0.72 1.3 2.34 0.05 -0.21 -8.56 2.92 -0.12 -5.99
Weighted average shares outstanding
Basic 22 21 20 20 19 19 19 19 19 19 19
Diluted 22 21 20 20 19 19 19 19 19 19 19
EBITDA 96 37 42 59 95 22 17 -133 76 18 -22

GCO Balance Sheet (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 133 43 41 31 48 43 44 51 40 31
Total cash 133 43 41 31 48 43 44 51 40 31
Receivables 47 53 46 55 44 54 39 53 43 51
Inventories 530 551 664 720 564 578 670 698 543 1105
Deferred income taxes 29 29 28 24 21
Prepaid expenses 61 60 69 65 61 64 84 74 67 72
Other current assets -552
Total current assets 800 735 849 895 738 740 837 875 693 706
Non-current assets
Property, plant and equipment
Land 8 8 8 8 8 8 8 8 8 8
Fixtures and equipment 393 396 400 387 392 398 412 368 392 402
Other properties 428 436 441 443 453 470 487 556 554 547
Property and equipment, at cost 829 840 849 837 852 876 907 932 954 957
Accumulated Depreciation -506 -519 -528 -515 -521 -533 -545 -553 -572 -579
Property, plant and equipment, net 323 321 321 322 331 343 362 378 383 377
Goodwill 281 287 277 269 271 273 276 93 100 96
Intangible assets 90 93 89 86 87 87 88 87 90 88
Deferred income taxes 1 4 2 3 0 15 12 41 25 25
Other long-term assets 45 43 43 22 22 22 22 22 25 25
Total non-current assets 741 747 732 702 711 740 761 623 622 611
Total assets 1541 1482 1581 1596 1449 1479 1598 1498 1315 1317
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 14 15 11 12 9 2 2 2 2 2
Accounts payable 154 167 269 247 171 176 243 244 141 146
Taxes payable 41 29 27 23 31 27 20 44 18 14
Accrued liabilities 79 89 64 64 64 65 64 69 93 77
Other current liabilities 35 11 37 26 34 23 22 20 2 2
Total current liabilities 324 311 408 372 309 293 351 379 255 241
Non-current liabilities
Long-term debt 98 101 125 214 74 136 189 221 87 104
Pensions and other benefits 10 10 9 9 6 6 6 6
Minority interest 2 1 2 2 1 1 2 2 2 2
Other long-term liabilities 153 155 152 135 137 131 135 137 143 144
Total non-current liabilities 263 267 288 360 218 275 331 366 231 250
Total liabilities 586 578 696 732 528 568 682 746 486 491
Stockholders' equity
Preferred stock 1 1 1 1 1 1 1 1 1 1
Common stock 22 21 21 20 20 20 20 20 20 20
Additional paid-in capital 224 227 230 234 238 241 244 248 251 254
Retained earnings 768 706 698 685 731 716 710 546 604 606
Treasury stock -18 -18 -18 -18 -18 -18 -18 -18 -18 -18
Accumulated other comprehensive income -43 -34 -47 -58 -51 -49 -43 -44 -29 -37
Total stockholders' equity 955 904 885 864 921 911 915 753 829 827
Total liabilities and stockholders' equity 1541 1482 1581 1596 1449 1479 1598 1498 1315 1317

GCO Cash Flow (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 21 19 19 19 19 20 19 19 21 20 78
Amortization of debt discount/premium and issuance costs 0 0 0 0 0 0 0 0 0
Investment/asset impairment charges 1 3 1 1 1 0 0 183 2 1 186
Deferred income taxes -5 -3 4 12 -9 -2 3 -30 13 -2 -15
Accounts receivable 20 -5 6 -9 10 -12 15 -13 11 -9 4
Inventory 209 -16 -118 -62 151 -14 -87 -30 163 -15 31
Prepaid expenses 3 2 -11 3 4 -2 -19 10 8 -3 -5
Accounts payable -89 23 98 -16 -81 5 68 5 -85 14 2
Accrued liabilities 8 -23 0 -11 18 -18 -9 26 -22 -8 -13
Other working capital 5 3 -2 -3 12 2 2 3 6 1 12
Other non-cash items 47 15 16 30 41 4 0 -160 60 2 -97
Net cash provided by operating activities 221 19 12 -36 167 -18 -7 12 177 1 183
Cash Flows From Investing Activities
Investments in property, plant, and equipment -23 -17 -23 -25 -28 -30 -37 -37 -24 -20 -117
Acquisitions, net -35 -1 0 23 0 0
Other investing charges 60 0 1 1
Net cash used for investing activities 2 -17 -24 -24 -5 -30 -37 -37 -24 -19 -116
Cash Flows From Financing Activities
Short-term borrowing -12 7 -4 1 3 -2 -3 -21 -8 -33
Long-term debt issued 111 70 191 80 191 134 115 76 119 443
Long-term debt repayment -207 -3 -42 -94 -226 -136 -86 -81 -215 -99 -481
Repurchases of treasury stock -17 -77 -24 -40 -16 -2 0 -2
Other financing activities -3 0 0 -2 0 1 0 0 -6 -3 -9
Net cash provided by (used for) financing activities -116 -92 11 51 -145 43 43 31 -165 9 -81
Effect of exchange rate changes -2 0 -1 -1 0 0 0 0 1 0 2
Net change in cash 105 -91 -1 -11 18 -5 0 7 -11 -9 -12
Cash at beginning of period 28 133 43 41 31 48 43 44 51 40 43
Cash at end of period 133 43 41 31 48 43 44 51 40 31 31
Free Cash Flow
Operating cash flow 221 19 12 -36 167 -18 -7 12 177 1 183
Capital expenditure -23 -17 -23 -25 -28 -30 -37 -37 -24 -20 -117
Free cash flow 198 1 -11 -61 139 -48 -44 -24 153 -19 66
Supplemental schedule of cash flow data
Cash paid for income taxes 19 13 21 0 18 2 22 3 10 1 36
Cash paid for interest 1 1 1 1 2 1 1 1 2 1 5

CATO

CATO Income Statement (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Revenue 250 288 239 209 220 240 207 190 213 238 849
Cost of revenue 159 164 149 134 155 146 141 124 142 142 550
Gross profit 91 124 90 76 65 94 66 66 71 96 299
Operating expenses
Sales, General and administrative 69 71 68 68 83 64 64 62 76 66 268
Other operating expenses 6 6 6 6 6 5 5 5 5 4 19
Total operating expenses 75 77 73 74 89 69 69 67 81 70 287
Operating income 16 47 17 2 -24 25 -3 -1 -9 26 12
Other income (expense) 1 3 1 1 1 1 1 1 2 1 5
Income before income taxes 17 50 18 3 -22 26 -2 -0 -8 27 16
Provision for income taxes 5 14 2 -5 -10 4 -1 -3 8 3 7
Minority interest 1
Other income 1
Net income from continuing operations 12 36 16 8 -13 22 -1 3 -16 23 10
Net income 12 36 16 8 -13 22 -1 3 -16 23 10
Preferred dividend 0 1 0 0 -0 0 -0 0 -0 1 0
Net income available to common shareholders 12 35 16 8 -13 22 -1 3 -15 23 9
Earnings per share
Basic 0.42 1.29 0.57 0.3 -0.45 0.85 -0.03 0.11 -0.59 0.94 0.43
Diluted 0.42 1.29 0.57 0.3 -0.45 0.85 -0.03 0.11 -0.59 0.94 0.43
Weighted average shares outstanding
Basic 27 27 27 27 26 26 25 25 24 24 25
Diluted 27 27 27 27 26 26 25 25 24 24 25
EBITDA 25 53 22 8 -11 30 1 4 0 30 36

CATO Balance Sheet (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04
Fiscal year ends in January. USD in millions except per share data.
Assets
Current assets
Cash
Cash and cash equivalents 67 56 43 33 47 52 78 79 78 71
Short-term investments 215 242 262 210 201 179 160 136 119 147
Total cash 283 298 305 243 248 231 238 215 197 219
Receivables 37 37 34 33 30 32 30 31 28 37
Inventories 141 134 134 153 146 132 106 128 122 108
Prepaid expenses 7 7 7 9 16 15 14 17 22 12
Other current assets 4 4 4 4 4 4 4 4 4 4
Total current assets 472 481 485 443 444 414 392 393 372 379
Non-current assets
Property, plant and equipment
Land 14 14 14
Fixtures and equipment 262 274 276
Other properties 144 138 129
Property and equipment, at cost 420 425 419
Accumulated Depreciation -282 -299 -310
Property, plant and equipment, net 138 135 134 142 126 125 122 120 109 106
Equity and other investments 19 21 21
Deferred income taxes 10 10 10 10 14 12 12 12 13 13
Other long-term assets 2 22 22 22 2 23 23 22 1 21
Total non-current assets 170 168 167 175 163 160 158 155 144 140
Total assets 642 649 652 618 606 574 549 548 516 518
Liabilities and stockholders' equity
Liabilities
Current liabilities
Accounts payable 113 97 99 95 105 83 75 88 83 69
Taxes payable 32 12 1 0 20 2 2 2 18 2
Accrued liabilities 36 49 53 56 44 56 58 55 35 56
Other current liabilities 12 5 3 3 3 2 3 3 3 4
Total current liabilities 193 163 156 154 172 144 138 149 139 131
Non-current liabilities
Other long-term liabilities 37 51 53 52 51 50 49 47 51 46
Total non-current liabilities 37 51 53 52 51 50 49 47 51 46
Total liabilities 230 215 210 206 222 194 186 196 190 177
Stockholders' equity
Common stock 1 1 1 1 1 1 1 1 1 1
Additional paid-in capital 90 91 92 94 95 96 97 99 100 101
Retained earnings 321 341 348 316 288 283 264 253 226 240
Accumulated other comprehensive income 1 1 1 1 0 0 0 0 0 -1
Total stockholders' equity 413 434 442 412 384 380 363 352 326 341
Total liabilities and stockholders' equity 642 649 652 618 606 574 549 548 516 518

CATO Cash Flow (quarterly)

2016-01 2016-04 2016-07 2016-10 2017-01 2017-04 2017-07 2017-10 2018-01 2018-04 TTM
Fiscal year ends in January. USD in millions except per share data.
Cash Flows From Operating Activities
Depreciation & amortization 6 6 6 6 6 5 5 5 5 4 19
Amortization of debt discount/premium and issuance costs 0
Deferred income taxes -1 1 0 0
Stock based compensation 1 0 1 1 1 0 1 1 1 1 4
Accounts receivable 1 -1 3 1 3 -2 3 -1 2 -9 -5
Inventory -5 7 0 -19 8 14 26 -22 6 14 24
Prepaid expenses 2 0 -1 -2 -7 1 0 -2 -6 11 2
Accounts payable -13
Income taxes payable 4 11 -11 -1 2 -2
Other working capital 13 -23 5 -4 14 -27 -7 10 -4 1 -16
Other non-cash items 15 37 15 10 0 23 1 4 -5 23 23
Net cash provided by operating activities 36 36 19 -9 26 16 28 -5 -2 32 52
Cash Flows From Investing Activities
Investments in property, plant, and equipment -4 -6 -4 -14 -3 -3 -3 -2 -2 -1 -8
Purchases of investments -15 -37 -48 -17 -9 -10 -6 0 0 -36 -42
Sales/Maturities of investments 15 11 30 67 16 32 24 23 15 8 70
Other investing charges 0 0 0 0 1 -1 0 0 0 0 0
Net cash used for investing activities -4 -32 -22 36 4 18 15 20 13 -29 19
Cash Flows From Financing Activities
Long-term debt issued 21
Long-term debt repayment -21
Excess tax benefit from stock based compensation 0 0 0 0 0
Repurchases of treasury stock -7 -1 -29 -6 -20 -9 -6 -3 -1 -19
Cash dividends paid -8 -8 -9 -9 -9 -9 -9 -8 -8 -8 -33
Other financing activities 0 0 0 0 0 0 0 0 0 0 1
Net cash provided by (used for) financing activities -8 -15 -10 -37 -15 -29 -18 -14 -11 -9 -52
Effect of exchange rate changes 0 0
Net change in cash 24 -11 -13 -10 14 5 25 1 -1 -6 19
Cash at beginning of period 43 67 56 43 33 47 52 78 79 81 55
Cash at end of period 67 56 43 33 47 52 78 79 78 75 74
Free Cash Flow
Operating cash flow 36 36 19 -9 26 16 28 -5 -2 32 52
Capital expenditure -4 -6 -4 -14 -3 -3 -3 -2 -2 -1 -8
Free cash flow 32 30 15 -23 23 12 25 -7 -5 31 44
Supplemental schedule of cash flow data


Tags: investing, research