{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["IS","BS","CF","WACC"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"IS","index":0,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,2,4]]}
[" ","Financial statement type","Income Statement"]
[]
[]
[]
[null,null,2017,{"$f":"C5-1","v":2016},{"$f":"D5-1","v":2015}]
[]
[null,"Revenue"]
[null,"Net sales",7719,7676,7586]
[]
[null,null,null,null,null,null,null,null,0,0,0]
[]
[]
[]
[]
[null,"Operating Costs"]
[null,"Cost of products sold",4616,4526,4558]
[null,"Marketing and selling expenses",1007,1058,1077]
[null,"Administrative expenses",612,605,591]
[null,"Research and development expenses",129,123,114]
[null,"Other expenses / (income)",13,4,61]
[null,"Restructuring charges",63,12,0]
[]
[]
[]
[]
[]
[]
[]
[null,"Non-Operating Costs"]
[null,"Interest expense",122,112,110]
[null,"Interest income",11,6,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Income taxes( income stax credits)"]
[null,"Taxes on earnings",366,398,347]

{"sheet":"BS","index":1,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,5,37,6]]}
[null,"Financial statement type","Balance Sheet"]
[]
[]
[]
[null,"Assets",null,null,null,null,null,"Liabilties",null,null,null,null,null,"Equity"]
[]
[null,"($ in million, except per share data)",{"$f":"IS!C5","v":2017},{"$f":"IS!D5","v":2016},{"$f":"IS!E5","v":2015},null,null,"($ in million, except per share data)",{"$f":"C7","v":2017},{"$f":"D7","v":2016},2015,null,null,"($ in million, except per share data)",{"$f":"I7","v":2017},{"$f":"J7","v":2016},2015]
[]
[null,"Cash",null,null,null,null,null,"Current Liabilities Excluding Debt",null,null,null,null,null,"Shareholder's equity"]
[null,"Cash and cash equivalents",484,254,null,null,null,"Payable to suppliers and others",585,545,null,null,null,"Total equity",1096,929]
[null,null,null,null,null,null,null,"Accrued liabilities",619,560]
[null,null,null,null,null,null,null,"Dividend payable",95,95]
[null,null,null,null,null,null,null,"Accrued income taxes",33,30]
[]
[]
[]
[null,"Current Assets Excluding Cash"]
[null,"Accounts receivable",560,512]
[null,"Inventories",767,724]
[null,"Other current assets",152,197]
[]
[]
[null,null,null,null,null,null,null,"Debt",null,null,null,null,null,"Check",{"$f":"SUM(C9:C43)-SUM(I10:I43)-SUM(O9:O21)","v":0},{"$f":"SUM(D9:D43)-SUM(J10:J43)-SUM(P9:P21)","v":0},0]
[null,null,null,null,null,null,null,"Short-term borrowings",657,835]
[null,null,null,null,null,null,null,"Long-term debt",2427,1945]
[]
[]
[]
[]
[]
[null,"Long-term assets"]
[null,"Plant assets, net of depreciation",2103,2051]
[null,"Goodwill",2133,1919]
[null,"Other intangible assets, net of amortization",527,509,null,null,null,"Long-term liabilities"]
[null,"Other assets",136,110,null,null,null,"Deferred taxes",367,258]
[null,null,null,null,null,null,null,"Other liabilities",983,1079]

{"sheet":"CF","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,2,4]]}
[null,"Financial statement type","Cash flow statement"]
[null,"Instructions: Please enter data by category as displayed below. Please do not enter any data from the total and subtotal lines on the statement."]
[]
[]
[null,"($ in million, except per share data)",{"$f":"BS!O7","v":2017},{"$f":"BS!P7","v":2016},{"$f":"BS!Q7","v":2015}]
[]
[null,"DA"]
[null,"Depreciation and amortization",268,251,264]
[]
[]
[]
[]
[null,"CapEx"]
[null,"Purchases of plant assets",-272,-315,-345]
[null,"Sales of plant assets",9,13,1]
[null,"Business acquired",0,0,-66]
[null,"Sale of business, net of cash divested",0,0,38]
[null,"Other, net",2,2,-6]

{"sheet":"WACC","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions: Choose the comparable Companies.  Enter one ticker per line."]
[]
[null,"Comps tickers"]