|SONY.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1Main3/30/20216/30/20219/30/202112/31/20213/31/20226/30/20229/30/202212/31/2022
2Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q4232018201920202021202220232024202520262027202820292030
3Game & Network615.81645.439813.264604.116720.7351246.5498001943.8122310.8721977.5512656.2782739.7633371.4
4Music254.873271.61295.873308.07359.319363.747799.995807.489849.909939.8671116.949
5Pictures204.736260.706461.234341.377337.468331.5371011.067986.8731011.854752.9871238.911
6Entertainment576.268581.919686.946552.31677.045752.8232602.3672320.6281911.2682068.0872339.186
7TVs221.021207.179269.5141.793226.751250.192
8AV73.08975.267105.391.0699.887122.605
9Cameras116.41104.972117.85139.703147.862171.146
10Mobiles81.41399.102102.3399.0393.22793.302
11Other74.58681.38584.54572.3299.005105.235
12Imaging & Sensing197.885278.263324.813219.223398.366417.151850.01879.331070.5761012.4971076.424
13
14Sales1844.7132003.2032562.2271986.55899999999952016.0372451.0433056.1832085.88694999999967322.7477390.9789999999996960.03800000000057333.678396.7029609.149949999999
15Financial412.13366.162469.092277.427295.457300.836356.731291.298351221.2351274.7081299.8471664.9911524.81100000000011244.32235
16Revenue2256.8432369.3653031.3192263.98599999999942311.4942751.8793412.91399999999982377.18529999999968543.9828665.6878259.8858998.6619921.51299999999910853.4723
17COGS1636.84199999999991688.1052221.0621673.83200000000061605.76699999999981939.37900000000012463.8286230.42200000000056263.1965925.0496567.5537219.841
18Gross Profit620.001681.2599999999998810.2570000000001590.1539999999989705.7270000000003812.4999999999998949.08599999999982313.55999999999952402.4912334.83600000000022431.1082701.6719999999987
19SG&A345.302369.908423.509449.7539999999999406.766482.457529.1881583.1971576.8251502.6251473.1541588.473
20Operating Income274.69899999999996311.35199999999975386.74800000000005140.39999999999895298.9610000000003330.0429999999998419.8979999999998730.3629999999996825.6659999999999832.2110000000002957.95400000000021113.1989999999987
21Other8.511000000000003-25.82499999999999674.821-53.203-7.58500000000000115.713000000000005-21.319000000000003-31.314191.98000000000002-32.76099999999999640.0114.304000000000002
22Pretax Income283.21285.52699999999976461.569000000000187.19699999999895291.3760000000003345.7559999999998398.5789999999998699.04899999999961017.646799.4500000000003997.96500000000011117.5029999999988
23Taxes70.09568.703113.645-23.3459999999999973.0778.08570.073151.7745.098177.190229.09699999999998
24Net Income213.11499999999998216.82399999999976347.9240000000001110.54299999999894218.30600000000032267.6709999999998328.5059999999998547.2789999999997972.548622.2600000000002997.9650000000001888.4059999999988
25
26Revenue y/y0.0242156853622517150.16144156767741570.125884144822765220.0500000000000000440.014244529073212053-0.046828601125334820.08944143895465850.102554368922220580.09393318337636614
27Gross Margin0.27472048343637550.287528515024067570.267295193940327640.260670339834256470.3053120622419960.29525280726369140.2780867024484062
28Games % of R0.27286346458304810.27241011832284180.2682871713600581400.2613530469903880.26190650097624210.36524477323483690.227506565439861640.2666692208015360.239416287272764680.29518591710477810.27614366881341590.310628700826002
29
30
31
32Games OpInc8267942132177.478311.092238.4341.718346.089
33Music OpInc5058678733127.786232.487142.3184.786210.933
34Pictures OpInc316292762041.1154.59968.15779.851217.393
35Entertainment OpInc7271177840133.12976.50887.276127.859212.942
36Imaging OpInc4972573987164.023143.874235.584145.884155.597
37Financial OpInc4305354628178.947161.477129.597154.765150.111
38
39Games OpMargin0.091304097309822150.134621043484883630.120553148818917950.128645420396509720.12632078030106983
40Music OpMargin0.15973349833436460.28791351956497240.16742968953146750.196608669098925710.1888474764738587
41Pictures OpMargin0.0406600156072742940.05532525461736210.067358531962121010.106045655502684650.17547103867832314
42Entertainment OpMargin0.051156889093659720.0329686619311669040.045663925728887830.0618247684937819340.09103252156946903
43Imaging OpMargin0.192965965106292850.163617754426665730.220053503908176520.144083389876710740.14454991713302565
44Financial OpMargin0.146529537722060070.126677639114212810.099701734127170360.092952454397651390.09844564342728376
45
46CFFO1253.9711258.7381349.7451140.2171233.643
47CapEx262.989312.644439.761477.931441.096
48FCF990.982946.094909.9839999999999662.2860000000001792.547