{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Calcbench Export"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Calcbench Export","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Exported from Calcbench"]
[]
["Year ",2015]
[null,"values highlighted in yellow can be changed"]
["Data"]
["Company","Ticker","PropertyPlantAndEquipmentGross","AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment","PPE","DepreciationAmortization"]
["Abbott Laboratories","abt",{"$f":"_xll.CalcbenchData(C$6, $B7, $B$3,\"y\")","v":12383000000},{"$f":"_xll.CalcbenchData(D$6, $B7, $B$3,\"y\")","v":6653000000},{"$f":"_xll.CalcbenchData(E$6, $B7, $B$3,\"y\")","v":5730000000},{"$f":"_xll.CalcbenchData(F$6, $B7, $B$3,\"y\")","v":1472000000}]
["AbbVie Inc.","abbv",{"$f":"_xll.CalcbenchData(C$6, $B8, $B$3,\"y\")","v":7334000000},{"$f":"_xll.CalcbenchData(D$6, $B8, $B$3,\"y\")","v":4769000000},{"$f":"_xll.CalcbenchData(E$6, $B8, $B$3,\"y\")","v":2565000000},{"$f":"_xll.CalcbenchData(F$6, $B8, $B$3,\"y\")","v":836000000}]
["Allergan Inc","agn",{"$f":"_xll.CalcbenchData(C$6, $B9, $B$3,\"y\")","v":4017900000},{"$f":"_xll.CalcbenchData(D$6, $B9, $B$3,\"y\")","v":1088400000},{"$f":"_xll.CalcbenchData(E$6, $B9, $B$3,\"y\")","v":1531300000},{"$f":"_xll.CalcbenchData(F$6, $B9, $B$3,\"y\")","v":7486500000}]
["Bristol Myers Squibb Co","bmy",{"$f":"_xll.CalcbenchData(C$6, $B10, $B$3,\"y\")","v":8631000000},{"$f":"_xll.CalcbenchData(D$6, $B10, $B$3,\"y\")","v":4219000000},{"$f":"_xll.CalcbenchData(E$6, $B10, $B$3,\"y\")","v":4412000000},{"$f":"_xll.CalcbenchData(F$6, $B10, $B$3,\"y\")","v":621000000}]
["Celgene Corp /DE/","celg",{"$f":"_xll.CalcbenchData(C$6, $B11, $B$3,\"y\")","v":1445600000},{"$f":"_xll.CalcbenchData(D$6, $B11, $B$3,\"y\")","v":631500000},{"$f":"_xll.CalcbenchData(E$6, $B11, $B$3,\"y\")","v":814100000},{"$f":"_xll.CalcbenchData(F$6, $B11, $B$3,\"y\")","v":408900000}]
["Forest Laboratories Inc","frx",{"$f":"_xll.CalcbenchData(C$6, $B12, $B$3,\"y\")","v":{"$error":"#N/A"}},{"$f":"_xll.CalcbenchData(D$6, $B12, $B$3,\"y\")","v":{"$error":"#N/A"}},{"$f":"_xll.CalcbenchData(E$6, $B12, $B$3,\"y\")","v":{"$error":"#N/A"}},{"$f":"_xll.CalcbenchData(F$6, $B12, $B$3,\"y\")","v":{"$error":"#N/A"}}]
["Hospira Inc","hsp",{"$f":"_xll.CalcbenchData(C$6, $B13, $B$3,\"y\")","v":{"$error":"#N/A"}},{"$f":"_xll.CalcbenchData(D$6, $B13, $B$3,\"y\")","v":{"$error":"#N/A"}},{"$f":"_xll.CalcbenchData(E$6, $B13, $B$3,\"y\")","v":{"$error":"#N/A"}},{"$f":"_xll.CalcbenchData(F$6, $B13, $B$3,\"y\")","v":{"$error":"#N/A"}}]
["Johnson & Johnson","jnj",{"$f":"_xll.CalcbenchData(C$6, $B14, $B$3,\"y\")","v":36648000000},{"$f":"_xll.CalcbenchData(D$6, $B14, $B$3,\"y\")","v":20743000000},{"$f":"_xll.CalcbenchData(E$6, $B14, $B$3,\"y\")","v":15905000000},{"$f":"_xll.CalcbenchData(F$6, $B14, $B$3,\"y\")","v":3746000000}]
["Lilly Eli & Co","lly",{"$f":"_xll.CalcbenchData(C$6, $B15, $B$3,\"y\")","v":16660900000},{"$f":"_xll.CalcbenchData(D$6, $B15, $B$3,\"y\")","v":8607400000},{"$f":"_xll.CalcbenchData(E$6, $B15, $B$3,\"y\")","v":8053500000},{"$f":"_xll.CalcbenchData(F$6, $B15, $B$3,\"y\")","v":1427700000}]
["Merck & Co. Inc.","MRK",{"$f":"_xll.CalcbenchData(C$6, $B16, $B$3,\"y\")","v":28430000000},{"$f":"_xll.CalcbenchData(D$6, $B16, $B$3,\"y\")","v":15923000000},{"$f":"_xll.CalcbenchData(E$6, $B16, $B$3,\"y\")","v":12507000000},{"$f":"_xll.CalcbenchData(F$6, $B16, $B$3,\"y\")","v":6375000000}]
["Mylan Inc.","myl",{"$f":"_xll.CalcbenchData(C$6, $B17, $B$3,\"y\")","v":3294000000},{"$f":"_xll.CalcbenchData(D$6, $B17, $B$3,\"y\")","v":1310100000},{"$f":"_xll.CalcbenchData(E$6, $B17, $B$3,\"y\")","v":1983900000},{"$f":"_xll.CalcbenchData(F$6, $B17, $B$3,\"y\")","v":1131700000}]
["Nbty Inc","nty",{"$f":"_xll.CalcbenchData(C$6, $B18, $B$3,\"y\")","v":866341000},{"$f":"_xll.CalcbenchData(D$6, $B18, $B$3,\"y\")","v":260293000},{"$f":"_xll.CalcbenchData(E$6, $B18, $B$3,\"y\")","v":605708000},{"$f":"_xll.CalcbenchData(F$6, $B18, $B$3,\"y\")","v":154197000}]
["Pfizer Inc","PFE",{"$f":"_xll.CalcbenchData(C$6, $B19, $B$3,\"y\")","v":27268000000},{"$f":"_xll.CalcbenchData(D$6, $B19, $B$3,\"y\")","v":13502000000},{"$f":"_xll.CalcbenchData(E$6, $B19, $B$3,\"y\")","v":13766000000},{"$f":"_xll.CalcbenchData(F$6, $B19, $B$3,\"y\")","v":5157000000}]
["Teva Pharmaceutical Industries Ltd","TEVA",{"$f":"_xll.CalcbenchData(C$6, $B20, $B$3,\"y\")","v":10073000000},{"$f":"_xll.CalcbenchData(D$6, $B20, $B$3,\"y\")","v":3529000000},{"$f":"_xll.CalcbenchData(E$6, $B20, $B$3,\"y\")","v":6544000000},{"$f":"_xll.CalcbenchData(F$6, $B20, $B$3,\"y\")","v":1308000000}]
["Valeant Pharmaceuticals International, Inc.","VRX",{"$f":"_xll.CalcbenchData(C$6, $B21, $B$3,\"y\")","v":2625800000},{"$f":"_xll.CalcbenchData(D$6, $B21, $B$3,\"y\")","v":1184000000},{"$f":"_xll.CalcbenchData(E$6, $B21, $B$3,\"y\")","v":1441800000},{"$f":"_xll.CalcbenchData(F$6, $B21, $B$3,\"y\")","v":2772800000}]
["Zoetis Inc.","ZTS",{"$f":"_xll.CalcbenchData(C$6, $B22, $B$3,\"y\")","v":2515000000},{"$f":"_xll.CalcbenchData(D$6, $B22, $B$3,\"y\")","v":1208000000},{"$f":"_xll.CalcbenchData(E$6, $B22, $B$3,\"y\")","v":1307000000},{"$f":"_xll.CalcbenchData(F$6, $B22, $B$3,\"y\")","v":199000000}]
[]
["Analysis"]
["Company","Ticker","Average age of PPE (years)","Average remaning life of PPE (years)"]
["Abbott Laboratories","abt",{"$f":"D7/F7","v":4.5197010869565215},{"$f":"E7/F7","v":3.8926630434782608}]
["AbbVie Inc.","abbv",{"$f":"D8/F8","v":5.7045454545454541},{"$f":"E8/F8","v":3.0681818181818183}]
["Allergan Inc","agn",{"$f":"D9/F9","v":0.14538168703666599},{"$f":"E9/F9","v":0.2045415080478194}]
["Bristol Myers Squibb Co","bmy",{"$f":"D10/F10","v":6.7938808373590982},{"$f":"E10/F10","v":7.1046698872785825}]
["Celgene Corp /DE/","celg",{"$f":"D11/F11","v":1.5443873807776962},{"$f":"E11/F11","v":1.9909513328442161}]
["Hospira Inc","hsp",{"$f":"D13/F13","v":{"$error":"#N/A"}},{"$f":"E13/F13","v":{"$error":"#N/A"}}]
["Johnson & Johnson","jnj",{"$f":"D14/F14","v":5.5373731980779501},{"$f":"E14/F14","v":4.2458622530699417}]
["Lilly Eli & Co","lly",{"$f":"D15/F15","v":6.0288576031379142},{"$f":"E15/F15","v":5.6408909434755197}]
["Merck & Co. Inc.","MRK",{"$f":"D16/F16","v":2.4977254901960784},{"$f":"E16/F16","v":1.9618823529411764}]
["Mylan Inc.","myl",{"$f":"D17/F17","v":1.1576389502518336},{"$f":"E17/F17","v":1.7530264204294423}]
["Nbty Inc","nty",{"$f":"D18/F18","v":1.6880548908214816},{"$f":"E18/F18","v":3.9281438679092329}]
["Pfizer Inc","PFE",{"$f":"D19/F19","v":2.6181888694977702},{"$f":"E19/F19","v":2.669381423308125}]
["Teva Pharmaceutical Industries Ltd","TEVA",{"$f":"D20/F20","v":2.6980122324159019},{"$f":"E20/F20","v":5.0030581039755351}]
["Valeant Pharmaceuticals International, Inc.","VRX",0.42700519330640507,0.51997980380842468]
["Zoetis Inc.","ZTS",6.0703517587939695,6.5678391959798992]