sampledata.txt

"netincome2015":-888663000,"netincomecontinuing2015":-888663000,"depreciationexpense2015":422590000,"noncashadjustmentstonetincome2015":434863000,"increasedecreaseinoperatingcapital2015":-493289000,"netcashfromcontinuingoperatingactivities2015":-524499000,"netcashfromoperatingactivities2015":-524499000,"purchaseofplantpropertyandequipment2015":-1634850000,"acquisitions2015":-12260000,"otherinvestingactivitiesnet2015":-26441000,"netcashfromcontinuinginvestingactivities2015":-1673551000,"netcashfrominvestingactivities2015":-1673551000,"repaymentofdebt2015":-203780000,"repurchaseofcommonequity2015":-17025000,"issuanceofdebt2015":568745000,"issuanceofcommonequity2015":856611000,"otherfinancingactivitiesnet2015":318972000,"netcashfromcontinuingfinancingactivities2015":1523523000,"netcashfromfinancingactivities2015":1523523000,"effectofexchangeratechanges2015":-34278000,"netchangeincash2015":-708805000,"cashinterestpaid2015":32060000,"cashincometaxespaid2015":9461000,"netincome2014":-294040000,"netincomecontinuing2014":-294040000,"depreciationexpense2014":231931000,"noncashadjustmentstonetincome2014":261597000,"increasedecreaseinoperatingcapital2014":-256825000,"netcashfromcontinuingoperatingactivities2014":-57337000,"netcashfromoperatingactivities2014":-57337000,"purchaseofplantpropertyandequipment2014":-969885000,"purchaseofinvestments2014":-205841000,"saleofinvestments2014":189131000,"otherinvestingactivitiesnet2014":-3849000,"netcashfromcontinuinginvestingactivities2014":-990444000,"netcashfrominvestingactivities2014":-990444000,"repaymentofdebt2014":-11179000,"repurchaseofcommonequity2014":-35149000,"issuanceofdebt2014":3271000,"issuanceofcommonequity2014":489615000,"otherfinancingactivitiesnet2014":1696572000,"netcashfromcontinuingfinancingactivities2014":2143130000,"netcashfromfinancingactivities2014":2143130000,"effectofexchangeratechanges2014":-35525000,"netchangeincash2014":1059824000,"cashinterestpaid2014":20539000,"cashincometaxespaid2014":3120000,"operatingrevenue2014":3198356000,"totalrevenue2014":3198356000,"operatingcostofrevenue2014":2316685000,"totalcostofrevenue2014":2316685000,"totalgrossprofit2014":881671000,"sgaexpense2014":603660000,"rdexpense2014":464700000,"totaloperatingexpenses2014":1068360000,"totaloperatingincome2014":-186689000,"totalinterestexpense2014":100886000,"totalinterestincome2014":1126000,"otherincome2014":1813000,"totalotherincome2014":-97947000,"totalpretaxincome2014":-284636000,"incometaxexpense2014":9404000,"netincometocommon2014":-294040000,"weightedavebasicsharesos2014":124539000,"basiceps2014":-2.36,"weightedavedilutedsharesos2014":124539000,"dilutedeps2014":-2.36,"weightedavebasicdilutedsharesos2014":124539000,"basicdilutedeps2014":-2.36,"operatingrevenue2015":4046025000,"totalrevenue2015":4046025000,"operatingcostofrevenue2015":3122522000,"totalcostofrevenue2015":3122522000,"totalgrossprofit2015":923503000,"sgaexpense2015":922232000,"rdexpense2015":717900000,"totaloperatingexpenses2015":1640132000,"totaloperatingincome2015":-716629000,"totalinterestexpense2015":118851000,"totalinterestincome2015":1508000,"otherincome2015":-41652000,"totalotherincome2015":-158995000,"totalpretaxincome2015":-875624000,"incometaxexpense2015":13039000,"netincometocommon2015":-888663000,"weightedavebasicsharesos2015":128202000,"basiceps2015":-6.93,"weightedavedilutedsharesos2015":128202000,"dilutedeps2015":-6.93,"weightedavebasicdilutedsharesos2015":128202000,"basicdilutedeps2015":-6.93,"cashandequivalents2014":1905713000,"restrictedcash2014":17947000,"accountsreceivable2014":226604000,"netinventory2014":953675000,"prepaidexpenses2014":76134000,"totalcurrentassets2014":3180073000,"netppe2014":2596011000,"othernoncurrentassets2014":43209000,"othernoncurrentnonoperatingassets2014":11374000,"totalnoncurrentassets2014":54583000,"totalassets2014":5830667000,"shorttermdebt2014":611099000,"accountspayable2014":777946000,"accruedexpenses2014":268883000,"totalcurrentliabilities2014":2107166000,"longtermdebt2014":1876981000,"othernoncurrentliabilities2014":642539000,"totalnoncurrentliabilities2014":2811791000,"totalliabilities2014":4860761000,"totalpreferredequity2014":0,"commonequity2014":2345392000,"retainedearnings2014":-1433660000,"aoci2014":-22000,"totalcommonequity2014":911710000,"totalequity2014":911710000,"totalequityandnoncontrollinginterests2014":911710000,"totalliabilitiesandequity2014":5830667000,"currentdeferredrevenue2014":449238000,"noncurrentdeferredrevenue2014":292271000,"cashandequivalents2015":1196908000,"restrictedcash2015":22628000,"accountsreceivable2015":168965000,"netinventory2015":1277838000,"prepaidexpenses2015":115667000,"totalcurrentassets2015":2782006000,"netppe2015":5194737000,"othernoncurrentassets2015":59674000,"othernoncurrentnonoperatingassets2015":31522000,"totalnoncurrentassets2015":91196000,"totalassets2015":8067939000,"shorttermdebt2015":627927000,"accountspayable2015":916148000,"accruedexpenses2015":422798000,"othercurrentliabilities2015":136831000,"totalcurrentliabilities2015":2811035000,"longtermdebt2015":2021093000,"othernoncurrentliabilities2015":1658717000,"totalnoncurrentliabilities2015":4125915000,"totalliabilities2015":6936950000,"commitmentsandcontingencies2015":0,"redeemablenoncontrollinginterest2015":47285000,"totalpreferredequity2015":0,"commonequity2015":3409583000,"retainedearnings2015":-2322323000,"aoci2015":-3556000,"totalcommonequity2015":1083704000,"totalequity2015":1083704000,"totalequityandnoncontrollinginterests2015":1083704000,"totalliabilitiesandequity2015":8067939000,"customerdeposits2015":283370000,"currentdeferredrevenue2015":423961000,"noncurrentdeferredrevenue2015":446105000,"52_week_high":269.34,"52_week_low":141.05,"marketcap":27789425160,"pricetoearnings":"nm","basiceps":-8.48,"volume":2380649,"average_daily_volume":2543436,"open_price":206.4,"close_price":206.43,"change":1.21,"beta":2.5171,"revenuegrowth2015":0.265033,"nopat2015":-727300390.4,"nopatmargin2015":-0.179757,"investedcapital2015":2528951000,"investedcapitalturnover2015":2.0262,"investedcapitalincreasedecrease2015":1064195000,"freecashflow2015":-1791495390.4,"netnonopex2015":161362609.6,"netnonopobligations2015":1397962000,"ebit2015":-758281000,"depreciationandamortization2015":422590000,"ebitda2015":-335691000,"capex2015":1634850000,"dfcfnwc2015":-620638000,"dfnwc2015":598898000,"nwc2015":-29029000,"debt2015":2649020000,"ltdebtandcapleases2015":2021093000,"netdebt2015":1429484000,"totalcapital2015":3780009000,"bookvaluepershare2015":8.4531,"tangbookvaluepershare2015":8.4531,"marketcap2015":30769762020,"enterprisevalue2015":32246531020,"pricetobook2015":28.3931,"pricetotangiblebook2015":28.3931,"pricetorevenue2015":7.6049,"pricetoearnings2015":"nm","dividendyield2015":0,"earningsyield2015":-0.028881,"evtoinvestedcapital2015":12.751,"evtorevenue2015":7.9699,"evtoebitda2015":"nm","evtoebit2015":"nm","evtonopat2015":"nm","evtoocf2015":"nm","evtofcff2015":"nm","ebitdagrowth2015":-8.134013,"ebitgrowth2015":-3.101565,"nopatgrowth2015":-2.771191,"netincomegrowth2015":-2.022252,"epsgrowth2015":-1.936441,"ocfgrowth2015":-8.147653,"fcffgrowth2015":-0.445978,"investedcapitalgrowth2015":0.726534,"revenueqoqgrowth2015":0.06803,"ebitdaqoqgrowth2015":-0.603224,"ebitqoqgrowth2015":-0.363256,"nopatqoqgrowth2015":-0.345608,"netincomeqoqgrowth2015":-0.314789,"epsqoqgrowth2015":-0.305085,"ocfqoqgrowth2015":0.097329,"fcffqoqgrowth2015":-4.099459,"investedcapitalqoqgrowth2015":29.497149,"grossmargin2015":0.228249,"ebitdamargin2015":-0.082968,"operatingmargin2015":-0.177119,"ebitmargin2015":-0.187414,"profitmargin2015":-0.219639,"costofrevtorevenue2015":0.771751,"sgaextorevenue2015":0.227935,"rdextorevenue2015":0.177433,"opextorevenue2015":0.405369,"taxburdenpct2015":1.014891,"interestburdenpct2015":1.154749,"efftaxrate2015":-0.014891,"assetturnover2015":0.5822,"arturnover2015":20.4567,"invturnover2015":2.7986,"faturnover2015":1.0387,"apturnover2015":3.6864,"dso2015":17.8425,"dio2015":130.4238,"dpo2015":99.0136,"ccc2015":49.2527,"finleverage2015":0.9551,"leverageratio2015":6.804,"compoundleveragefactor2015":7.857,"ltdebttoequity2015":1.787,"debttoequity2015":2.3422,"roic2015":-0.364223,"nnep2015":0.165415,"roicnnepspread2015":-0.529638,"rnnoa2015":-0.505864,"roe2015":-0.870087,"croic2015":-0.897159,"oroa2015":-0.109116,"roa2015":-0.127878,"noncontrollinginterestsharingratio2015":0.023148,"roce2015":-0.849946,"divpayoutratio2015":0,"augmentedpayoutratio2015":-0.019158,"ocftocapex2015":-0.320824,"stdebttocap2015":0.166118,"ltdebttocap2015":0.534679,"debttototalcapital2015":0.700797,"preferredtocap2015":0,"noncontrolinttocap2015":0.012509,"commontocap2015":0.286693,"debttoebitda2015":-7.8912,"netdebttoebitda2015":-4.2583,"ltdebttoebitda2015":-6.0207,"debttonopat2015":-3.6423,"netdebttonopat2015":-1.9655,"ltdebttonopat2015":-2.7789,"altmanzscore2015":2.4454,"ebittointerestex2015":-6.3801,"nopattointerestex2015":-6.1194,"ebitlesscapextointerestex2015":-20.1356,"nopatlesscapextointex2015":-19.8749,"ocftointerestex2015":-4.4131,"ocflesscapextointerestex2015":-18.1685,"fcfftointerestex2015":-15.0735,"currentratio2015":0.9897,"quickratio2015":0.4859,"dfcfnwctorev2015":-0.153395,"dfnwctorev2015":0.148021,"nwctorev2015":-0.007175,"normalizednopat2015":-501640300,"normalizednopatmargin2015":-0.123983,"pretaxincomemargin2015":-0.216416,"revenuegrowth2014":0.588459,"nopat2014":-192856959.6,"nopatmargin2014":-0.060299,"investedcapital2014":1464756000,"investedcapitalturnover2014":3.3963,"investedcapitalincreasedecrease2014":1046094000,"freecashflow2014":-1238950959.6,"netnonopex2014":101183040.4,"netnonopobligations2014":553046000,"ebit2014":-184876000,"depreciationandamortization2014":231931000,"ebitda2014":47055000,"capex2014":969885000,"dfcfnwc2014":-239654000,"dfnwc2014":1684006000,"nwc2014":1072907000,"debt2014":2488080000,"ltdebtandcapleases2014":1876981000,"netdebt2014":564420000,"totalcapital2014":3399790000,"bookvaluepershare2014":7.3207,"tangbookvaluepershare2014":7.3207,"marketcap2014":27698718990,"enterprisevalue2014":28263138990,"pricetobook2014":30.3811,"pricetotangiblebook2014":30.3811,"pricetorevenue2014":8.6603,"pricetoearnings2014":"nm","dividendyield2014":0,"earningsyield2014":-0.010616,"evtoinvestedcapital2014":19.2955,"evtorevenue2014":8.8368,"evtoebitda2014":600.6405,"evtoebit2014":"nm","evtonopat2014":"nm","evtoocf2014":"nm","evtofcff2014":"nm","ebitdagrowth2014":-0.301875,"ebitgrowth2014":-3.779504,"nopatgrowth2014":-2.036951,"netincomegrowth2014":-2.972762,"epsgrowth2014":-2.806452,"ocfgrowth2014":-1.216526,"fcffgrowth2014":-9.594532,"investedcapitalgrowth2014":2.49866,"revenueqoqgrowth2014":0.119514,"ebitdaqoqgrowth2014":-0.396568,"ebitqoqgrowth2014":-0.56387,"nopatqoqgrowth2014":-0.48683,"netincomeqoqgrowth2014":-0.450817,"epsqoqgrowth2014":-0.532468,"ocfqoqgrowth2014":-1.351649,"fcffqoqgrowth2014":-7.82493,"investedcapitalqoqgrowth2014":0.422427,"grossmargin2014":0.275664,"ebitdamargin2014":0.014712,"operatingmargin2014":-0.05837,"ebitmargin2014":-0.057803,"profitmargin2014":-0.091935,"costofrevtorevenue2014":0.724336,"sgaextorevenue2014":0.188741,"rdextorevenue2014":0.145293,"opextorevenue2014":0.334034,"taxburdenpct2014":1.033039,"interestburdenpct2014":1.539605,"efftaxrate2014":-0.033039,"assetturnover2014":0.7756,"arturnover2014":23.2006,"invturnover2014":3.5806,"faturnover2014":1.721,"apturnover2014":4.2826,"dso2014":15.7323,"dio2014":101.939,"dpo2014":85.2293,"ccc2014":32.442,"finleverage2014":0.1929,"leverageratio2014":5.2239,"compoundleveragefactor2014":8.0427,"ltdebttoequity2014":2.0587,"debttoequity2014":2.729,"roic2014":-0.204795,"nnep2014":0.664393,"roicnnepspread2014":-0.869187,"rnnoa2014":-0.167684,"roe2014":-0.372478,"croic2014":-1.315641,"oroa2014":-0.044831,"roa2014":-0.071303,"noncontrollinginterestsharingratio2014":0,"roce2014":-0.372478,"divpayoutratio2014":0,"augmentedpayoutratio2014":-0.119538,"ocftocapex2014":-0.059117,"stdebttocap2014":0.179746,"ltdebttocap2014":0.552087,"debttototalcapital2014":0.731833,"preferredtocap2014":0,"noncontrolinttocap2014":0,"commontocap2014":0.268167,"debttoebitda2014":52.876,"netdebttoebitda2014":11.9949,"ltdebttoebitda2014":39.8891,"debttonopat2014":-12.9012,"netdebttonopat2014":-2.9266,"ltdebttonopat2014":-9.7325,"altmanzscore2014":3.7395,"ebittointerestex2014":-1.8325,"nopattointerestex2014":-1.9116,"ebitlesscapextointerestex2014":-11.4462,"nopatlesscapextointex2014":-11.5253,"ocftointerestex2014":-0.5683,"ocflesscapextointerestex2014":-10.182,"fcfftointerestex2014":-12.2807,"currentratio2014":1.5092,"quickratio2014":1.0119,"dfcfnwctorev2014":-0.07493,"dfnwctorev2014":0.526522,"nwctorev2014":0.335456,"normalizednopat2014":-130682300,"normalizednopatmargin2014":-0.040859,"pretaxincomemargin2014":-0.088994