-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathstatements-data-pivoted
46 lines (46 loc) · 7.17 KB
/
statements-data-pivoted
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Company,FY,Assets,EBIT,EBITDA,Equity,Interest Expense,Long Term Debt,Net Income,Total Debt,Total Revenue,Interest Coverage Ratio,EBIT Margin,Debt EBITDA
ACCENTURE,Average,21487656.0,5073534.75,5564146.75,8250804.25,16480.0,22970.75,3667632.25,12669722.25,34588571.5,308.58334932056084,0.14659840555404835,2.286004012502337
ACCENTURE,FY15,18202647.0,4500251.0,4911189.0,6133725.0,14578.0,25587.0,3053581.0,11555076.0,31047931.0,308.70153656194265,0.1449452783182235,2.352806214543973
ACCENTURE,FY16,20609004.0,4810445.0,5256063.0,7555262.0,16258.0,24457.0,4111892.0,12419628.0,32882723.0,295.8817197687292,0.14629095650016574,2.362914599767925
ACCENTURE,FY17,22689890.0,5142402.0,5654636.0,8949477.0,15545.0,22163.0,3445149.0,12979690.0,34850182.0,330.8074622064973,0.147557392957087,2.295406813099906
ACCENTURE,FY18,24449083.0,5841041.0,6434699.0,10364753.0,19539.0,19676.0,4059907.0,13724495.0,39573450.0,298.942678745074,0.1475999944407172,2.132888422597545
CGI,Average,11698970.0,1575995.0,1828827.5,6358552.5,70351.5,1739648.25,1055717.25,5340417.5,10830562.75,22.921241693835523,0.14544354406118948,2.926048249305283
CGI,FY15,11787270.0,1466773.0,1756830.0,6082169.0,86252.0,1896181.0,977556.0,5705101.0,10287096.0,17.00566943375226,0.14258377680153855,3.247383639851323
CGI,FY16,11693332.0,1556098.0,1816228.0,6464608.0,70257.0,1765062.0,1068716.0,5228724.0,10683264.0,22.148654226625105,0.14565754436097433,2.878891857189736
CGI,FY17,11396212.0,1581829.0,1811984.0,6202626.0,62022.0,1811485.0,1035195.0,5193586.0,10845066.0,25.504321047370286,0.14585701921961564,2.866242748280338
CGI,FY18,11919066.0,1699280.0,1930268.0,6684807.0,62875.0,1485865.0,1141402.0,5234259.0,11506825.0,27.026322067594432,0.14767583586262936,2.711674751899736
COGNIZANT,Average,14614250.0,2470750.0,2879750.0,10524750.0,21750.0,777000.0,1695500.0,4089500.0,14209500.0,114.62424781761166,0.17373263249486715,1.423771188737075
COGNIZANT,FY15,13061000.0,2142000.0,2472000.0,9278000.0,18000.0,877000.0,1624000.0,3783000.0,12416000.0,119.0,0.17251932989690721,1.5303398058252426
COGNIZANT,FY16,14262000.0,2316000.0,2695000.0,10728000.0,19000.0,797000.0,1553000.0,3534000.0,13487000.0,121.89473684210526,0.17172091643805146,1.311317254174397
COGNIZANT,FY17,15221000.0,2589000.0,3032000.0,10669000.0,23000.0,698000.0,1504000.0,4552000.0,14810000.0,112.56521739130434,0.174814314652262,1.5013192612137203
COGNIZANT,FY18,15913000.0,2836000.0,3320000.0,11424000.0,27000.0,736000.0,2101000.0,4489000.0,16125000.0,105.03703703703704,0.17587596899224806,1.3521084337349398
DXC,Average,15135250.0,946000.0,1929250.0,5084250.0,175250.0,2781500.0,531750.0,9885250.0,11846500.0,3.8141644364614877,0.055505935280314014,6.58659100485266
DXC,FY15,10221000.0,102000.0,738000.0,2937000.0,126000.0,1550000.0,2000.0,7256000.0,8117000.0,0.8095238095238095,0.012566219046445731,9.831978319783198
DXC,FY16,7736000.0,195000.0,872000.0,2025000.0,123000.0,1865000.0,251000.0,5704000.0,7106000.0,1.5853658536585367,0.027441598649028988,6.541284403669724
DXC,FY17,8663000.0,441000.0,1088000.0,1888000.0,117000.0,2159000.0,123000.0,6497000.0,7607000.0,3.769230769230769,0.057972919679242806,5.971507352941177
DXC,FY18,33921000.0,3046000.0,5019000.0,13487000.0,335000.0,5552000.0,1751000.0,20084000.0,24556000.0,9.092537313432835,0.12404300374653852,4.0015939430165375
IBM,Average,119175750.0,13703750.0,18018000.0,16724500.0,609000.0,35911500.0,9885750.0,102308000.0,80097500.0,23.511692330120376,0.17084330925103897,5.743633059245046
IBM,FY15,110495000.0,16517000.0,20372000.0,14262000.0,468000.0,33431000.0,13190000.0,96071000.0,81741000.0,35.292735042735046,0.20206505915024284,4.715835460435892
IBM,FY16,117470000.0,14170000.0,18551000.0,18246000.0,630000.0,34663000.0,11872000.0,99078000.0,79919000.0,22.49206349206349,0.1773045208273377,5.34084415934451
IBM,FY17,125356000.0,11898000.0,16439000.0,17594000.0,615000.0,39871000.0,5753000.0,107631000.0,79139000.0,19.346341463414635,0.15034306726140081,6.547296064237484
IBM,FY18,123382000.0,12230000.0,16710000.0,16796000.0,723000.0,35681000.0,8728000.0,106452000.0,79591000.0,16.915629322268327,0.15366058976517447,6.370556552962298
MAXIMUS,Average,1358259.75,290025.5,344337.25,846352.75,2173.5,187978.0,191577.75,508003.25,2336594.5,175.6717798069889,0.12416164168266691,1.5008015023060461
MAXIMUS,FY15,1271558.0,264577.0,310874.0,612378.0,1398.0,210618.0,157772.0,655859.0,2099821.0,189.25393419170243,0.12599978760094313,2.1097261269839227
MAXIMUS,FY16,1348819.0,280555.0,343136.0,749081.0,4134.0,165338.0,178362.0,595679.0,2403360.0,67.86526366715046,0.11673448838293056,1.7359851487456868
MAXIMUS,FY17,1350662.0,315187.0,372564.0,940085.0,2162.0,,209426.0,404894.0,2450961.0,145.78492136910268,0.1285973134619441,1.086777036965461
MAXIMUS,FY18,1462000.0,299783.0,350775.0,1083867.0,1000.0,,220751.0,375581.0,2392236.0,299.783,0.12531497728484983,1.070717696529114
NTT,Average,2038060500.0,106383500.0,265473250.0,786740000.0,5674250.0,366644250.0,54844000.0,1218309750.0,1744087250.0,18.778448235350794,0.06099625662350877,4.584381211461659
NTT,FY15,1822837000.0,84015000.0,230911000.0,773493000.0,5782000.0,349511000.0,32144000.0,1016633000.0,1511812000.0,14.530439294361813,0.05557238598450072,4.402704938266258
NTT,FY16,1860319000.0,100886000.0,248847000.0,740908000.0,5492000.0,319513000.0,63373000.0,1086649000.0,1614897000.0,18.369628550619083,0.062472095743567546,4.366735383589113
NTT,FY17,2234809000.0,117110000.0,271652000.0,798701000.0,5372000.0,328693000.0,65686000.0,1404541000.0,1732473000.0,21.800074460163813,0.06759701305590332,5.170368707022219
NTT,FY18,2234277000.0,123523000.0,310483000.0,833858000.0,6051000.0,468860000.0,58173000.0,1365416000.0,2117167000.0,20.41365063625847,0.0583435317100635,4.397715816969045
TCS,Average,1033967500.0,317822500.0,337685000.0,829650000.0,787500.0,,269642500.0,200377500.0,1240447500.0,649.3410244269619,0.25651308256289884,0.5908430001235727
TCS,FY15,890960000.0,288140000.0,307020000.0,710720000.0,330000.0,,242700000.0,176690000.0,1086460000.0,873.1515151515151,0.26520994790420266,0.575499967428832
TCS,FY16,1032520000.0,303410000.0,323280000.0,862140000.0,320000.0,,262890000.0,166720000.0,1179660000.0,948.15625,0.25720122747232255,0.5157139321950013
TCS,FY17,1062960000.0,305180000.0,325320000.0,851280000.0,520000.0,,258260000.0,207660000.0,1231040000.0,586.8846153846154,0.2479042110735638,0.6383253412025083
TCS,FY18,1149430000.0,374560000.0,395120000.0,894460000.0,1980000.0,,314720000.0,250440000.0,1464630000.0,189.17171717171718,0.2557369438015062,0.6338327596679489
TELUS,Average,29563250.0,2705500.0,4336000.0,8816000.0,544000.0,12089250.0,1441000.0,20711500.0,13138750.0,5.008332139768563,0.2059011753639587,4.770693650200615
TELUS,FY15,26406000.0,2537000.0,4050000.0,7672000.0,470000.0,11182000.0,1382000.0,18734000.0,12430000.0,5.397872340425532,0.20410297666934835,4.625679012345679
TELUS,FY16,27729000.0,2617000.0,4228000.0,7917000.0,502000.0,11625000.0,1223000.0,19793000.0,12725000.0,5.213147410358566,0.2056581532416503,4.6814096499526965
TELUS,FY17,31053000.0,2781000.0,4450000.0,9416000.0,579000.0,12332000.0,1559000.0,21595000.0,13305000.0,4.803108808290156,0.20901916572717025,4.852808988764045
TELUS,FY18,33065000.0,2887000.0,4616000.0,10259000.0,625000.0,13218000.0,1600000.0,22724000.0,14095000.0,4.6192,0.20482440581766584,4.922876949740035