{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Historicals"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Notes"]
["The first step in financial modelling is the recording and reconciliation of the company reported historical data in the company reported format"]
["The recording of raw data and ensuring that all reported data balances and reconciles with each other is important since this would give us the historical trends based on which we will be forecasting the future earnings"]
["This recording process also helps us gauge the revenue and cost drivers of the company based on which we will be able to create assumptions to forecast the company earnings"]
["These do not reflect the company's pure/organic growth from operations, therefore companies generally report the notional adjustments made to their accounts and the Adjusted/pure earnings figures."]
["As we cannot forecast such notional adjustments which are the discretion of the management, therefore, we separate out and forecast organic growth based on its historical trend."]
["Instructions"]
["Complete all relevant data in the Historical tab following the format of the examples"]
["If there are new line items mentioned in the older reports, feel free to insert new rows for them, however ensure that these rows are taken in to account for the formulas"]
["Ensure all checks are balanced and any differences are reconciled"]
["You are required to record all segmental breakdowns  following the example "]
["The requred annual reports and earnings releases can be found in:"]
["https://investors.nike.com/Home/default.aspx"]
["Submssion time is 3 days from the day the task was given to you"]

{"sheet":"Historicals","index":1,"n_rows":151,"n_cols":9,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["NIKE, INC.\n(Dollars and Shares in Millions Except Per Share Amounts)",{"$f":"+C1-1","v":2015},2016,2017,2018,2019,2020,{"$f":"+I1-1","v":2021},2022]
["Revenues",30601,32376,34350,36397,39117,37403,44538,46710]
["Cost of sales",16534,17405,19038,20441,21643,21162,24576,25231]
["Gross profit",{"$f":"B2-B3","v":14067},{"$f":"C2-C3","v":14971},15312,15956,17474,16241,19962,21479]
["Demand creation expense",3213,3278,3341,3577,3753,3592,3114,3850]
["Operating overhead expense",6679,7191,7222,7934,8949,9534,9911,10954]
["Total selling and administrative expense",9892,10469,10563,11511,12702,13126,13025,14804]
["Interest expense (income), net",28,19,59,54,49,89,262,205]
["Other (income) expense, net",-58,-140,-196,66,-78,139,14,-181]
["Income before income taxes",{"$f":"B4-B7-B8-B9","v":4205},{"$f":"C4-C7-C8-C9","v":4623},4886,{"$f":"E4-E7-E8-E9","v":4325},4801,2887,6661,6651]
["Income tax expense",932,863,646,2392,772,348,934,605]
["NET INCOME",3273,3760,4240,1933,4029,2539,5727,6046]
["Net earnings per share:"]
["Basic",1.9,2.21,2.56,1.19,2.5499999999999998,1.63,3.64,3.83]
["Diluted",1.85,2.16,2.5099999999999998,1.17,2.4900000000000002,1.6,3.56,3.75]
["Average shares outstanding:"]
["Basic",1723.5,1697.9,1657.8,1623.8,1579.7,1558.8,1573,1578.8]
["Diluted",1768.8,1742.5,1692,1659.1,1618.4,1591.6,1609.4,1610.8]
[]
["Check (Reported diluted EPS-(Net income/diluted no. of shares)",{"$f":"+ROUND(((B12/B18)-B15),2)","v":0},0,0,0,0,0,0,{"$f":"+ROUND(((I12/I18)-I15),2)","v":0}]
[]
["CONSOLIDATED BALANCE SHEETS"]
["ASSETS"]
["Current assets:"]
["Cash and equivalents",3852,3138,3808,4249,4466,8348,9889,8574]
["Short-term investments",2072,2319,2371,996,197,439,3587,4423]
["Accounts receivable, net",3358,3241,3677,3498,4272,2749,4463,4667]
["Inventories",4337,4838,5055,5261,5622,7367,6854,8420]
["Deferred income taxes",389,0,0,0,0,0,0,0]
["Prepaid expenses and other current assets",1968,1489,1150,1130,1968,1653,1498,2129]
["Total current assets",{"$f":"+SUM(B25:B30)","v":15976},15025,16061,15134,16525,20556,26291,{"$f":"+SUM(I25:I30)","v":28213}]
["Property, plant and equipment, net",3011,3520,3989,4454,4744,4866,4904,4791]
["Operating lease right-of-use assets, net",0,0,0,0,0,3097,3113,2926]
["Identifiable intangible assets, net",281,281,283,285,283,274,269,286]
["Goodwill",131,131,139,154,154,223,242,284]
["Deferred income taxes and other assets",2201,2422,2787,2509,2011,2326,2921,3821]
["TOTAL ASSETS",{"$f":"+SUM(B31:B36)","v":21600},{"$f":"C31+C32+C33+C34+C35+C36","v":21379},{"$f":"+SUM(D31:D36)","v":23259},22536,23717,31342,37740,{"$f":"+SUM(I31:I36)","v":40321}]
["LIABILITIES AND SHAREHOLDERS' EQUITY"]
["Current liabilities:"]
["Current portion of long-term debt",107,44,6,6,6,3,0,500]
["Notes payable",74,1,325,336,9,248,2,10]
["Accounts payable",2131,2191,2048,2279,2612,2248,2836,3358]
["Current portion of operating lease liabilities",0,0,0,0,0,445,467,420]
["Accrued liabilities",3951,3037,3011,3269,5010,5184,6063,6220]
["Income taxes payable",71,85,84,150,229,156,306,222]
["Total current liabilities",{"$f":"+SUM(B40:B45)","v":6334},{"$f":"SUM(C40:C45)","v":5358},5474,6040,7866,8284,9674,{"$f":"+SUM(I40:I45)","v":10730}]
["Long-term debt",1079,1993,3471,3468,3464,9406,9413,8920]
["Operating lease liabilities",0,0,0,0,0,2913,2931,2777]
["Deferred income taxes and other liabilities",1480,1770,1907,3216,3347,2684,2955,2613]
["Commitments and contingencies (Note 18)"]
["Redeemable preferred stock",null,null,null,null,"—","—",0,0]
["Shareholders' equity:"]
["Common stock at stated value:"]
["Class A convertible — 305 and 305 shares outstanding",null,null,null,null,"—","—"]
["Class B — 1,266 and 1,273 shares outstanding",3,3,3,3,3,3,3,3]
["Capital in excess of stated value",6773,7786,8638,6384,7163,8299,9965,11484]
["Accumulated other comprehensive income (loss)",1246,318,-213,-92,231,-56,-380,318]
["Retained earnings (deficit)",4685,4151,3979,3517,1643,-191,3179,3476]
["Total shareholders' equity",{"$f":"+SUM(B54:B58)","v":12707},12258,12407,9812,9040,8055,12767,15281]
["TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY",{"$f":"+SUM(B46:B51)+B59","v":21600},21379,23259,22536,23717,31342,37740,40321]
[" Check (total assets - total labilities and equity)",{"$f":"+B60-B37","v":0},{"$f":"+C60-C37","v":0},{"$f":"+D60-D37","v":0},0,0,0,0,{"$f":"+I60-I37","v":0}]
["CONSOLIDATED STATEMENTS OF CASH FLOWS"]
["(Link Net income figures from income statement)"]
["Cash provided (used) by operations:"]
["Net income",{"$f":"B12","v":3273},3760,{"$f":"D12","v":4240},1933,4029,2539,{"$f":"+H12","v":5727},{"$f":"+I12","v":6046}]
["Adjustments to reconcile net income to net cash provided (used) by operations:"]
["Depreciation",606,649,706,747,705,721,744,717]
["Deferred income taxes",-113,-80,-273,647,34,-380,-385,-650]
["Stock-based compensation",191,236,215,218,325,429,611,638]
["Amortization, impairment and other",43,13,10,27,15,398,53,123]
["Net foreign currency adjustments",424,98,-117,-99,233,23,-138,-26]
["Changes in certain working capital components and other assets and liabilities:"]
["(Increase) decrease in accounts receivable",-216,60,-426,187,-270,1239,-1606,-504]
["(Increase) decrease in inventories",-621,-590,-231,-255,-490,-1854,507,-1676]
["(Increase) decrease in prepaid expenses, operating lease right-of-use assets and other current and non-current assets",-144,-161,-120,35,-203,-654,-182,-845]
["Increase (decrease) in accounts payable, accrued liabilities, operating lease liabilities and other current and non-current liabilities",1237,-889,-364,1515,1525,24,1326,1365]
["Cash provided (used) by operations",4680,3096,3640,4955,5903,2485,{"$f":"+SUM(H65:H76)","v":6657},{"$f":"+SUM(I65:I76)","v":5188}]
["Cash provided (used) by investing activities:"]
["Purchases of short-term investments",-4936,-5367,-5928,-4783,-2937,-2426,-9961,-12913]
["Maturities of short-term investments",3655,2924,3623,3613,1715,74,4236,8199]
["Sales of short-term investments",2216,2386,2423,2496,2072,2379,2449,3967]
["Investments in reverse repurchase agreements",-150,150,0,0,0,0,0,0]
["Additions to property, plant and equipment",-963,-1143,-1105,-1028,-1119,-1086,-695,-758]
["Disposals of property,plant and equipment",3,10,13,0,0,0]
["Other investing activities",0,6,-34,-22,5,31,171,-19]
["Cash provided (used) by investing activities",{"$f":"+SUM(B79:B85)","v":-175},-1034,{"$f":"+SUM(D79:D85)","v":-1008},276,-264,-1028,-3800,-1524]
["Cash provided (used) by financing activities:"]
["Proceeds from borrowings, net of debt issuance costs",0,981,1482,"—","—",6134,0,0]
["Long-term debt repayments",-7,-106,-44,0,0,0]
["Increase (decrease) in notes payable, net",-63,-67,327,13,-325,49,-52,15]
["Repayment of borrowings",-19,-7,-17,0,0,0,-197,0]
["Proceeds from exercise of stock options and other stock issuances",514,507,489,733,700,885,1172,1151]
["Excess tax benefits from share-based arrangements",218,281,177,0,0,0]
["Repurchase of common stock",-2534,-3238,-3223,-4254,-4286,-3067,-608,-4014]
["Dividends — common and preferred",-899,-1022,-1133,-1243,-1332,-1452,-1638,-1837]
["Other financing activities",0,0,0,-84,-50,-58,-136,-151]
["Cash provided (used) by financing activities",{"$f":"+SUM(B88:B96)","v":-2790},-2671,-1942,{"$f":"+SUM(E88:E96)","v":-4835},{"$f":"+SUM(F88:F96)","v":-5293},{"$f":"+SUM(G88:G96)","v":2491},{"$f":"+SUM(H88:H96)","v":-1459},{"$f":"+SUM(I88:I96)","v":-4836}]
["Effect of exchange rate changes on cash and equivalents",-83,-105,-20,45,-129,-66,143,-143]
["Net increase (decrease) in cash and equivalents",{"$f":"+B77+B86+B97+B98","v":1632},-714,670,{"$f":"+E77+E86+E97+E98","v":441},{"$f":"+F77+F86+F97+F98","v":217},{"$f":"+G77+G86+G97+G98","v":3882},{"$f":"+H77+H86+H97+H98","v":1541},{"$f":"+I77+I86+I97+I98","v":-1315}]
["Cash and equivalents, beginning of year",2220,3852,3138,3808,4249,4466,8348,{"$f":"+H101","v":9889}]
["CASH AND EQUIVALENTS, END OF YEAR",{"$f":"+B99+B100","v":3852},{"$f":"+C99+C100","v":3138},3808,{"$f":"+E99+E100","v":4249},{"$f":"+F99+F100","v":4466},{"$f":"+G99+G100","v":8348},{"$f":"+H99+H100","v":9889},{"$f":"+I99+I100","v":8574}]
[" Check (cash at eop - cash in balance sheet)",{"$f":"+B101-B25","v":0},0,0,0,0,0,0,{"$f":"+I101-I25","v":0}]
["Supplemental disclosure of cash flow information:"]
["Cash paid during the year for:"]
["Interest, net of capitalized interest",53,70,98,125,153,140,293,290]
["Income taxes",1262,748,703,529,757,1028,1177,1231]
["Non-cash additions to property, plant and equipment",206,252,266,294,160,121,179,160]
["Dividends declared and not paid",240,271,300,320,347,385,438,480]
[]
["Segmental Breakdowns"]
["Revenue:"]
["North America",{"$f":"+SUM(B113:B115)","v":13740},14764,15216,14855,15902,14484,17179,{"$f":"+SUM(I113:I115)","v":18353}]
["Footwear",8506,9299,9684,9322,10045,9329,11644,12228]
["Apparel",4410,4746,4886,4938,5260,4639,5028,5492]
["Equipment",824,719,646,595,597,516,507,633]
["Europe, Middle East & Africa",{"$f":"+SUM(B117:B119)","v":11024},{"$f":"+SUM(C117:C119)","v":7568},{"$f":"+SUM(D117:D119)","v":7970},{"$f":"+SUM(E117:E119)","v":9242},{"$f":"+SUM(F117:F119)","v":9812},{"$f":"+SUM(G117:G119)","v":9347},{"$f":"+SUM(H117:H119)","v":11456},{"$f":"+SUM(I117:I119)","v":12479}]
["Footwear",7344,5043,5192,5875,6293,5892,6970,7388]
["Apparel",3072,2149,2395,2940,3087,3053,3996,4527]
["Equipment",608,376,383,427,432,402,490,564]
["Greater China",{"$f":"+SUM(B121:B123)","v":3067},{"$f":"+SUM(C121:C123)","v":3785},{"$f":"+SUM(D121:D123)","v":4237},{"$f":"+SUM(E121:E123)","v":5134},{"$f":"+SUM(F121:F123)","v":6208},{"$f":"+SUM(G121:G123)","v":6679},{"$f":"+SUM(H121:H123)","v":8290},{"$f":"+SUM(I121:I123)","v":7547}]
["Footwear",2016,2599,2920,3496,4262,4635,5748,5416]
["Apparel",925,1055,1188,1508,1808,1896,2347,1938]
["Equipment",126,131,129,130,138,148,195,193]
["Asia Pacific & Latin America",{"$f":"+SUM(B125:B127)","v":755},{"$f":"+SUM(C125:C127)","v":4317},{"$f":"+SUM(D125:D127)","v":4737},{"$f":"+SUM(E125:E127)","v":5166},{"$f":"+SUM(F125:F127)","v":5254},{"$f":"+SUM(G125:G127)","v":5028},{"$f":"+SUM(H125:H127)","v":5343},{"$f":"+SUM(I125:I127)","v":5955}]
["Footwear",452,2930,3285,3575,3622,3449,3659,4111]
["Apparel",230,1117,1185,1347,1395,1365,1494,1610]
["Equipment",73,270,267,244,237,214,190,234]
["Global Brand Divisions",115,73,73,88,42,30,25,102]
["TOTAL NIKE BRAND",{"$f":"+B112+B116+B120+B124+B128","v":28701},30507,32233,34485,37218,35568,42293,44436]
["Converse",1982,1955,2042,1886,1906,1846,2205,2346]
["Corporate",-82,-86,75,26,-7,-11,40,-72]
["TOTAL NIKE, INC. REVENUES",{"$f":"+SUM(B129:B131)","v":30601},32376,34350,36397,39117,37403,44538,{"$f":"+SUM(I129:I131)","v":46710}]
[" Check",{"$f":"+B132-B2","v":0},{"$f":"+C132-C2","v":0},0,{"$f":"+E132-E2","v":0},0,0,{"$f":"+H132-H2","v":0},0]
["EBIT:"]
["North America",3645,3763,3875,3600,3925,2899,5089,5114]
["Europe, Middle East & Africa",2342,1787,1507,1587,1995,1541,2435,3293]
["Greater China",993,1372,1507,1807,2376,2490,3243,2365]
["Asia Pacific & Latin America",100,1002,980,1189,1323,1184,1530,1896]
["Global Brand Divisions",-2267,-2596,-2677,-2658,-3262,-3468,-3656,-4262]
["TOTAL NIKE BRAND",{"$f":"+SUM(B135:B139)","v":4813},5328,5192,5525,6357,4646,8641,8406]
["Converse",517,487,477,310,303,297,543,669]
["Corporate",-1097,-1173,-724,-1456,-1810,-1967,-2261,-2219]
["TOTAL NIKE, INC. EBIT",{"$f":"+SUM(B140:B142)","v":4233},4642,4945,4379,4850,2976,6923,{"$f":"+SUM(I140:I142)","v":6856}]
[" Check",{"$f":"+B143-B10-B8","v":0},{"$f":"+C143-C10-C8","v":0},{"$f":"+D143-D10-D8","v":0},{"$f":"+E143-E10-E8","v":0},{"$f":"+F143-F10-F8","v":0},{"$f":"+G143-G10-G8","v":0},{"$f":"+H143-H10-H8","v":0},{"$f":"+I143-I10-I8","v":0}]
[]
[]
[]
["Notes:"]
["due to change in segmentation in 2017, the 2015 segmentation numbers are obtained through the following"]
["\"Western Europe\" \"Central Europe\" and \"Emerging Markets\" segments were combined to create the new \"Europe,Middle East, and Africa\" segment number for 2015"]
["The \"Japan\" segment number is reflected under the new \"Asia Pacific & Latin America\" segment for 2015"]