|WDAY.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1Main7/31/202010/31/20201/31/20214/30/20217/31/202110/31/20211/31/20224/30/20227/31/202210/31/20221/31/2023
2FQ121FQ221FQ321FQ421FQ122FQ222FQ322FQ422FQ123FQ223FQ323FQ423F2021F2022F2023F2024F2025F2026F2027F2028F2029F2030
3Subscription931.698931.698968.5471006.2511032.1691113.4541171.5171229.1731272.0761367.3351432.3931495.4023838.19400000000044546.3135567.206
4Professional130.269130.269137.413125.433142.864146.907155.746146.968162.581168.463166.71150.858523.384592.485648.6120000000001
5Revenue1061.9671061.9671105.961131.6841175.03300000000011260.36099999999991327.26300000000011376.1411434.6571535.7981599.1031646.264361.5785138.7986215.818
6COGS284.27700000000004295.181313.044333.053345.52099999999996359.724389.797402.821423.08500000000004435.793453.47900000000004892.50200000000011428.0951715.178
7Gross Margin777.69810.779818.64841.9800000000001914.8399999999999967.5390000000002986.3441031.83599999999981112.7131163.311192.7813469.07600000000053710.70299999999954500.64
8R&D418.681419.962439.095441.616444.251455.615537.738541.509547.835565.727615.5891277.7381879.222270.66
9S&M276.497302.87335.249326.494358.157366.323410.947429.301458.701470.196489.895914.6161461.92100000000031848.0929999999998
10G&A99.266102.024117.607112.183113.552121.656138.621133.869140.255153.708176.255318.89700000000005486.01200000000006604.087
11OpEx794.444824.856891.951880.293915.9599999999999943.5941087.3061104.67899999999991146.79100000000021189.6311281.7392511.2513827.15300000000074722.84
12OpInc-16.753999999999905-14.076999999999998-73.31100000000004-38.312999999999874-1.120000000000004523.945000000000164-100.96199999999999-72.84300000000007-34.0780000000002-26.32100000000014-88.95800000000008957.8250000000003-116.45000000000118-222.19999999999982
13Finance-11.453-8.8464.737-9.051021.55717.141-20.163-32.7894.16311.039-15.56229.647-37.75
14Pretax Income-28.206999999999905-22.923-68.57400000000004-47.363999999999876-1.120000000000004545.502000000000166-83.821-93.00600000000007-66.8670000000002-22.15800000000014-77.91900000000008942.2630000000003-86.80300000000119-259.9499999999998
15Taxes-0.1911.4173.133-0.842-3.8712.0910.5689.167052.56304.3597.94499999999999961.730000000000004
16Net Income-28.015999999999906-24.34-71.70700000000004-46.521999999999882.750999999999995443.41200000000016-94.389-102.17300000000007-66.8670000000002-74.72100000000015-77.91900000000008937.9040000000002-94.74800000000118-321.67999999999984
17EPS-0.11871085838255567-0.10224356147005574-0.29754929624219906-0.190868100714288140.0105801181465755780.17040351703564202-0.37749107153569583-0.4058623278502285-0.2614514785750322-0.2921607957677922-0.302807377526989833.9349698553813504-0.37577610806716594-1.260784404024805
18Shares236.002238.059240.992243.739260.016254.76250.043251.743255.753255.753257.322238.351252.1395255.14275
19
20Revenue y/y0.186817481145835850.200100365293500730.216011713517201050.220950390329462950.218538180727585240.20481245992693230.196287299048571340.178196973664118690.2095859771098223
21
22Net Cash2134.1609999999993145.459999999999
23Cash6255.3556121.393999999999
24AR778.0761570.086
25Deferred Costs496.51800000000003612.042
26Prepaids252.989225.69
27PP&E1186.0041201.254
28Lease252.236249.278
29Goodwill3209.4313145.509
30Other368.497360.985
31Assets12799.10613486.238000000001
32
33AP123.361153.751
34AE246.939260.131
35Compensation362.269563.548
36DR3182.482879.4273633.933
37Lease262.81273.142
38Debt4121.1942975.934
39Other22.29940.231
40SE4780.8075585.568
41L+SE12799.10613486.238000000001
42
43Model NI-46.52199999999988-102.17300000000007-66.8670000000002-74.72100000000015-77.91900000000008
44Reported NI-46.522-102.173
45D&A82.46389.846
46SBC264.635311.506
47Amortization31.61439.427
48Lease22.2322.048
49Gain of Investments6.0188.08
50Other-1.6240.709
51AR392.119462.964
52Deferred Costs-26.27-41.729
53Prepaid-35.566-23.997
54AP-0.176.91
55AE-10.92-30.873
56DR-225.579-303.001
57CFFO452.42800000000005439.71699999999987
58
59
60DR y/y0.14185572258113166