|ANSS.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUV
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422202020212022202320242025
3ACV755.41870.7
4
5License141.622382.057132.604214.822200.394397.977157.445208.981220.43340000000003437.7747945.7971024.6341
6Maintenance225.343241.629230.622231.832240.774257.69267.632264.869264.8514283.459960.91800000000011080.8114
7Revenue366.96500000000003623.686363.226446.654441.168655.6669999999999425.077473.85485.2848721.23371906.71500000000012105.4455
8COGS43.47456.48847.15449.13299999999999647.55753.37847.50845.07348.5284872.12337000000001197.22199999999998213.23285000000004
9Gross Margin323.49100000000004567.1980000000001316.072397.521393.611602.2889999999999377.569428.77700000000004436.75632649.110331709.49300000000021892.2126499999997
10SG&A132.642195.845146.215160.41165.368243.384169.755170.383173.6364255.5532715.377769.3276000000001
11R&D86.61696.51100.479100.879102.023101.489105.274108.941107.12415106.56345404.87427.9026
12Operating Expenses219.25799999999998292.355246.69400000000002261.289267.39099999999996344.873275.029279.324280.76055362.116651120.24699999999981197.2302
13Operating Income104.23300000000006274.843000000000169.37799999999999136.23200000000003126.22000000000003257.4159999999999102.54000000000002149.45300000000003155.99577286.99368589.2460000000003694.9824499999997
14Interest Expense-1.099-1.834-2.798-2.8499999999999996-2.402-2.277-2.44-4.34-1-1-10.327000000000002-8.78
15Pretax Income103.13400000000006273.0090000000000766.57999999999998133.38200000000003123.81800000000003255.1389999999999100.10000000000002145.11300000000003154.99577285.99368578.9190000000003686.2024499999998
16Taxes14.51742.24035.14418.55631.8027.04124.09423.249365542.89905285.5020000000000197.2834175
17Net Income88.61700000000006230.7690000000000666.5799999999999898.23800000000003105.26200000000003223.336999999999993.05900000000003121.01900000000003131.74640449999998243.094628493.4170000000003588.9190324999997
18EPS1.01597037512611272.63356766256590550.75671129497874651.12699614537444951.19386632489877442.53213682384553351.06050142450142481.385909460496331.50875968552810872.7839194237354135.614603839282676.736026770523255
19Shares87.22487.62687.98687.16888.16988.20187.7587.32187.32187.32187.88187.42824999999999
20
21Revenue y/y0.20220729497363510.0512774056175702150.170282413703864770.060888293847139120.100000000000000090.100000000000000090.10422664110787383
22Gross Margin0.8815309361928250.90942878307353390.87017999812788740.88999762679837190.89220206361295460.91858977194215960.88823671946494410.90487918117547750.90.90.89656451016538920.8987231680896037
23
24
25Net Cash-95.93499999999995-235.76700000000005
26Cash657.7650000000001517.635
27AR513.738566.829
28OCA278.375242.761
29PP&E84.67881.154
30Leases130.274125.743
31Goodwill4138.9564338.224999999999
32OLTA227.383226.341
33DT22.01419.892
34Assets6053.1836118.58
35
36AP17.10217.304
37Compensation30.64655.026
38Taxes7.06517.015
39Other184.663174.444
40DR386.019360.91
41DT99.43973.087
42Lease114.238111.357
43Debt753.7753.402
44OLTL96.36103.28
45SE4363.9514452.755
46L+SE6053.1836118.58
47
48Model NI93.05900000000003121.01900000000003
49Reported NI70.98898.80000000000001
50D&A29.0828.932000000000002
51Lease5.5535.821000000000001
52DT-0.861-34.443000000000005
53Bad Debt2.3260.10000000000000009
54SBC35.65139.498
55Other0.9192.643
56WC67.27999999999999-22.406999999999996
57CFFO210.93599999999998118.94400
58
59Acquisitions-4.915-236.715
60CapEx-5.062-4.996999999999999
61Other0.0130.07200000000000001
62CFFI-9.964-241.6400
63
64Buyback-155.5710
65Stock Tax-59.196-2.358000000000004
66SBC proceeds10.1220.6920000000000002
67Other0-1.29
68CFFF-204.64499999999998-2.95600000000000400
69
70FX-6.573-21.039
71CIC-10.24600000000001-146.69099999999997
72CINC-139.8320000000001