PLC Balance Statement of Sports Fashion

1. JD Sports Fashion PLC Balance StatementJD SPORTS FASHION PLC (JD.) CashFlowFlag BALANCE SHEETFiscal year ends in January. GBP in thousands except per share data. 2013-01 2014-01 2015-01 2016-01 2017-01AssetsCash and cash equivalents 53484 76797 121317 215996 247560Total cash 53484 76797 121317 215996 247560Inventories 146569 186116 225020 238324 348007Prepaid expenses 37962 45366 37738 30486 45527Other current assets 18799 21600 16184 25889 73075Total current assets 256814 329879 400259 510695 714169Land 23959 12120 12674 17185Fixtures and equipment 221121 245410 259421 301150 379900Other properties 20872 19050 22787 61375Property and equipment, at cost 245080 278402 291145 341122 441275Accumulated Depreciation -115979 -136828 -143211 -167805 -205513Property, plant and equipment, net 129101 141574 147934 173317 235762Goodwill 54176 78776 86139 83944 130627Intangible assets 41848 25554 14936 -10333 60275Deferred income taxes 482Other long-term assets 20568 23802 32402 33191 38103Total non-current assets 245693 269706 281411 280601 464767Total assets 502507 599585 681670 791296 1178936Liabilities and stockholders’ equityShort-term debt 7108 30933 36685 6257 30928Capital leases 49 37 28 44 503Accounts payable 97084 128510 124590 122638 165003Taxes payable 35693 35216 46203 57470 92159Other current liabilities 72815 90955 119242 161745 246563Total current liabilities 212749 285651 326748 348154 535156Long-term debt 684 516 339 210 2068Capital leases 7 35 35 64 461Deferred taxes liabilities 3852 4283 1804 8192Minority interest 13934 13074 13502 18405 26592Other long-term liabilities 33458 36260 42753 42043 54217Total non-current liabilities 51935 54168 58433 60722 91530Total liabilities 264684 339819 385181 408876 626686Common stock 2433 2433 2433 2433Additional paid-in capital 11659 11659 11659 11659 11659Retained earnings 230572 257744 297161 378898 543268Accumulated other comprehensive income -4408 -12070 -14764 -10570 -5110Total stockholders’ equity 237823 259766 296489 382420 552250Total liabilities and stockholders’ equity 502507 599585 681670 791296 1178936Source :(Morningstar, 2017b)1. JD Sports Fashion PLC Cash Flow StatementJD SPORTS FASHION PLC (JD.) Statement of CASH FLOWFiscal year ends in January. GBP in thousands except per share data. 2013-01 2014-01 2015-01 2016-01 2017-01Cash Flows From Operating ActivitiesDeferred income taxes 16364 20531 31001 53788Inventory -23551 -29372 -54696 -13304 -21240Other working capital -18295 10969 53857 55785 39301Other non-cash items 76574 79234 96070 152532 207412Net cash provided by operating activities 34728 77195 115762 226014 279261Cash Flows From Investing ActivitiesInvestments in property, plant, and equipment -43671 -43575 -63048 -72765 -84115Property, plant, and equipment reductions 977 557 705 1145 2431Acquisitions, net 11969 -17213 9027 -138568Purchases of intangibles -5540 -4609 -7152 -4401 -3843Other investing charges 645 575 657 -5955 767Net cash used for investing activities -35620 -64265 -59811 -81976 -223328Cash Flows From Financing ActivitiesShort-term borrowing -245Long-term debt issued 26000 5000Long-term debt repayment -129 -291 -31191 -3133Repurchases of treasury stock -14815Cash dividends paid -12408 -12871 -13260 -13820 -14501Other financing activities -971 -105 -72 -75 -804Net cash provided by (used for) financing activities -13624 12895 -8623 -45086 -33253Effect of exchange rate changes -867 -10 -3674 -4790 1796Net change in cash -15383 25815 43654 94162 24476Cash at beginning of period 61611 46228 72043 115697 209859Cash at end of period 46228 72043 115697 209859 234335Free Cash FlowOperating cash flow 34728 77195 115762 226014 279261Capital expenditure -49211 -48184 -70200 -77166 -87958Free cash flow -14483 29011 45562 148848 191303Supplemental schedule of cash flow dataSource:(MorningStar, 2017c)1. JD Sports Horizontal and Vertical Analysis tableJD SPORTS INCOME STATEMENTVertical Analysis(Margin) Horizontal Analysis(Growth)Fiscal year ends in January. Units in % 2013-01 2014-01 2015-01 2016-01 2017-01 2014-01 2015-01 2016-01 2017-01Revenue 100.00 100.00 100.00 100.00 100.00 5.69 14.41 19.67 30.58Cost of revenue 51.27 51.52 51.42 51.46 51.08 6.20 14.19 19.77 29.62Gross profit 48.73 48.48 48.58 48.54 48.92 5.16 14.64 19.56 31.60Total operating expenses 44.48 44.17 42.56 41.28 38.91 4.95 10.24 16.09 23.08Operating income 4.25 4.32 6.03 7.26 10.00 7.30 59.63 44.09 80.06Net income 3.08 3.02 3.46 5.36 7.52 3.54 31.17 85.34 83.25JD SPORTS BALANCE SHEETVertical Analysis(Margin) Horizontal Analysis(Growth)Fiscal year ends in January. Units in % 2013-01 2014-01 2015-01 2016-01 2017-01 2014-01 2015-01 2016-01 2017-01Total cash 10.64 12.81 17.80 27.30 21.00 43.59 57.97 78.04 14.61Inventories 29.17 31.04 33.01 30.12 29.52 26.98 20.90 5.91 46.02Prepaid expenses 7.55 7.57 5.54 3.85 3.86 19.50 -16.81 -19.22 49.34Total current assets 51.11 55.02 58.72 64.54 60.58 28.45 21.34 27.59 39.84Total assets 100.00 100.00 100.00 100.00 100.00 19.32 13.69 16.08 48.99Capital leases 0.01 0.01 0.00 0.01 0.04 -24.49 -24.32 57.14 1043.18Capital leases 0.00 0.01 0.01 0.01 0.04 400.00 0.00 82.86 620.31Total liabilities 52.67 56.68 56.51 51.67 53.16 28.39 13.35 6.15 53.27Total stockholders’ equity 47.33 43.32 43.49 48.33 46.84 9.23 14.14 28.98 44.41JD SPORTS CASH FLOWHorizontal Analysis(Growth)Fiscal year ends in January. Units in % 2014-01 2015-01 2016-01 2017-01Inventory 24.72 86.22 -75.68 59.65Other working capital -159.96 390.99 3.58 -29.55Net cash provided by operating activities 122.28 49.96 95.24 23.56Investments in property, plant, and equipment -0.22 44.69 15.41 15.60Property, plant, and equipment reductions -42.99 26.57 62.41 112.31Acquisitions, net -243.81 -152.44 -100.00Net cash used for investing activities 80.42 -6.93 37.06 172.43Long-term debt issued -80.77 -100.00Long-term debt repayment 125.58 10618.56 -89.96Cash dividends paid 3.73 3.02 4.22 4.93Net cash provided by (used for) financing activities -194.65 -166.87 422.86 -26.25