|TXN.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAF
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422FY07FY08FY09FY10FY11FY12FY13FY14FY15FY16FY17FY18FY19FY20FY21FY22FY23
3Analog810483398536990010801
4Embedded27402787302334983554
5Other22011874181115631429
6Revenue428945804643490552125241138351250110427139661373512825122051304513000133701496115784143831446118344
7COGS149215031491146315871624521951925968
8Gross Profits2797307731523442362536179164926912376
9R&D386391388391414431194014761570154415301554
10SG&A425425412422422431161413201519164516231666
11Operating Expenses81181680081383686235542796308900000000318931533220
12Operating Income198622612352262927892755-3554-2796-308900000000597561169156
13Other029-30-37-42-205123-41
14Pretax Income198622902322259227472735-308900000000598062399115
15Taxes1863113283253903637114221150
16Net Income180019791994226723572372-308900000000526958177965
17EPS1.92513368983957212.1120597652081112.13034188034188032.42719486081370442.53440860215053742.569880823401955.5346638655462196.2347266881028948.509615384615385
18Shares935937936934930923952933936
19
20Revenue y/y0.143623222196316070.137991266375545820.12879603704501408-0.0964221178171305-0.165906727461803020.3394073079505131-0.016540168981812986-0.06625409537677462-0.048343079922027240.06882425235559197-0.0034495975469528430.0284615384615385380.11899775617053110.05500969186551696-0.088760770400405420.0054230689007856990.2685153170596777
21
22Gross Margin0.65213336442061090.67183406113537110.67887141934094330.70173292558613660.6955103607060630.69013547033008970.63714106931794480.64096535509300880.6746620148277366
23Operating Margin0.46304499883422710.493668122270742360.50656902864527240.53598369011213040.53511128165771290.52566304140431220.41542098310505460.42293064103450660.49912778020061055
24
25CFFO18502121242821441768276632563414338440544397461453637189664961398756
26CapEx3083864864435977908164954123855515316951131847
27FCF154217351942170111711976244029192972366938464083466860585802